Attachment_D_-_ZEV_CRDTS_database_diagram.pdf
PDF 605 KB Posted
- Solicitation number
- 0000032094
- Issued by
- Sacramento County, Sacramento City, California
About this file
This is a Request for Information (RFI) issued by the California Air Resources Board (CARB) regarding the development of the Advanced Clean Cars (ACC) II ZEV Regulation Tracking System. The purpose of this RFI is to gather information, suggestions, and best practices on the technical resources available to provide the state with a comprehensive solution for tracking and reporting ZEV compliance across multiple jurisdictions. The system aims to enhance data verification processes and contribute to the success of ACC II in reducing emissions from passenger cars and light-duty trucks.
The RFI does not provide specific details on pricing terms, set-asides, incumbents, funding requirements or sources. However, it is clear that the state is seeking input from vendors and stakeholders to inform the development of the ACC II ZEV Regulation Tracking System, which will be a critical component in the state's efforts to implement the ACC II regulations and achieve its emissions reduction goals.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_A_-_High_Level_Process_Flows.pdf | ||
| RFI-_2024CARB__ACC_II-RFI002_-_ACC_II_-_Original.pdf | ||
| Attachment_B_-_Functional_Requirements.xlsm | XLSM spreadsheet | |
| 2024CARB__ACC_II_-_RFI_-_Q_A_-_Responses.pdf | ||
| Attachment_C_-_ZEV_CRDTS_Database_Details.csv | CSV file |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
TravelCredits
PK Id int
FK ZevStateId int
FK AccountId int
FK AccountTypeId int
ModelYear int
ReportingYear int
StandardCredits float
TSCredits float
ATDPCredits float
SubmittedOn datetime
FK SubmittedBy int
FK Status int
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
FK UpdatedBy int
ZEVStates
PK id int
FK StateId int
SalesDataDeadlineMonth int
SalesDataDeadlineDay int
SupplementalDataDeadlineMonth int
SupplementalDataDeadlineDay int
FK PoolingRegionId int
Status int
FK CreatedBy int
CreatedOn datetime
FK ModifiedBy int
ModifiedOn datetime
_ErrorRedirect_DM_CreditBalanceStaging
MFR varchar(255)
STATE varchar(255)
AccountType varchar(255)
ModelYear varchar(255)
CreditType varchar(255)
Credits varchar(255)
Purpose varchar
Error_Desc varchar
FileName varchar
CreatedBy int
CreatedOn datetime
_ErrorRedirect_DM_NMOGTotalSalesStaging
STATE varchar(255)
MODEL_YR varchar(255)
EO_MFR_NAME varchar(255)
PC_LDT1_SALES varchar(255)
LDT2_SALES varchar(255)
Error_Desc varchar
FileName varchar(255)
CreatedBy int
CreatedOn datetime
_ErrorRedirect_DM_ZEVAnnualCreditsStaging
VIN varchar(255)
ExecutiveOrderNumber varchar(255)
Make varchar
Model varchar
TestGroup varchar(255)
ModelYear varchar(255)
Delivered varchar(255)
DateDelivered varchar(255)
DeliveryState varchar(255)
Placed varchar(255)
DatePlaced varchar(255)
PlacementState varchar(255)
AgencyName varchar
AgencyContact varchar
ContactEmail varchar(255)
GovtPlacement varchar(255)
Error_Desc varchar
FileName varchar
CreatedBy int
CreatedOn datetime
_Import_DM_CreditBalanceStaging
MFR varchar(255)
STATE varchar(255)
AccountType varchar(255)
ModelYear varchar(255)
CreditType varchar(255)
Credits varchar(255)
Purpose varchar
IsImportFailed bit
Error_Desc varchar
FileName varchar
_Import_DM_NMOGTotalSalesStaging
STATE varchar(255)
MODEL_YR varchar(255)
EO_MFR_NAME varchar(255)
PC_LDT1_SALESvarchar(255)
LDT2_SALES varchar(255)
IsImportFailed bit
Error_Desc varchar
FileName varchar
_Import_DM_ZEVAnnualCreditsStaging
VIN varchar(255)
ExecutiveOrderNumber varchar(255)
Make varchar
Model varchar
TestGroup varchar(255)
ModelYear varchar(255)
Delivered varchar(255)
DateDelivered varchar(255)
DeliveryState varchar(255)
Placed varchar(255)
DatePlaced varchar(255)
PlacementState varchar(255)
AgencyName varchar
AgencyContact varchar
ContactEmail varchar(255)
GovtPlacement varchar(255)
IsImportFailed bit
Error_Desc varchar
FileName varchar
_ImportECERTStaging
MODEL_YEAR varchar(255)
MFR_CODE varchar(255)
EO_MFR_NAME varchar(255)
ARB_EO_NUM varchar(255)
TEST_GRP varchar(255)
MAKE varchar
MODEL varchar
EO_MODEL_VEH_CLASS varchar(255)
VEH_TYPE varchar(255)
ZEV_SUBCAT varchar(255)
ZEV_TIER varchar(255)
ZEV_URB_AER_UDDS_POST2018 varchar(255)
BEVX varchar(255)
PZEV_VEH_TYPE varchar(255)
BASE_PZEV_ALLOW varchar(255)
EAER varchar(255)
RCDA varchar(255)
ZERO_EMIS_VMT_PZEV_ALLOW varchar(255)
ADV_ZEV_COMP_PZEV_ALLOW varchar(255)
LOW_FUEL_CYCLE_ALLOW varchar(255)
H2_ICE_ALLOW_POST2018 varchar(255)
US06_ALLOW_POST2018 varchar(255)
CA Projected Sales varchar(255)
Total US Projected Sales varchar(255)
Section 177States Projected Sales varchar(255)
IsImportFailed bit
Error_Desc nvarchar
FileUploadMappingId int
ZEV_URB_AER_UDDS_PRE2018 varchar(255)
_ImportNMOGTotalSalesStaging
MODEL_YR varchar(255)
EO_MFR_NAME varchar(255)
PC_LDT1_SALES varchar(255)
LDT2_SALES varchar(255)
IsImportFailed bit
Error_Desc varchar
FileUploadMappingId int
_ImportNMOGZEVSalesStaging
MODEL_YR varchar(255)
MFR_CODE varchar(255)
EXECUTIVE_ORDER_NUMBER varchar(255)
TEST_GRP_NAME varchar(255)
MAKE varchar
MODEL varchar
STATE varchar
ZEV_SALES varchar(255)
IsImportFailed bit
Error_Desc varchar
FileUploadMappingId int
_ImportZEVAdvTechDemoAnnualCreditsStaging
VIN varchar(255)
ModelYear varchar(255)
ExecutiveOrderNumber varchar(255)
TestGroup varchar(255)
Make varchar
Model varchar
StartDate1 varchar(255)
EndDate1 varchar(255)
Location1 varchar(255)
StartDate2 varchar(255)
EndDate2 varchar(255)
Location2 varchar(255)
StartDate3 varchar(255)
EndDate3 varchar(255)
Location3 varchar(255)
StartDate4 varchar(255)
EndDate4 varchar(255)
Location4 varchar(255)
StartDate5 varchar(255)
EndDate5 varchar(255)
Location5 varchar(255)
StartDate6 varchar(255)
EndDate6 varchar(255)
Location6 varchar(255)
IsImportFailed bit
Error_Desc varchar
FileUploadMappingId int isPrototype varchar(255)
_ImportZEVAnnualCreditsStaging
VIN varchar(255)
ExecutiveOrderNumber varchar(255)
Make varchar
Model varchar
TestGroup varchar(255)
ModelYear varchar(255)
Delivered varchar(255)
DateDelivered varchar(255)
DeliveryState varchar(255)
Placed varchar(255)
DatePlaced varchar(255)
PlacementState varchar(255)
AgencyName varchar
AgencyContact varchar
ContactEmail varchar(255)
GovtPlacement varchar(255)
IsImportFailed bit
Error_Desc varchar
FileUploadMappingId int
_ImportZEVFCVAnnualCreditStaging
VIN varchar(255)
ExecutiveOrderNumber varchar(255)
Make varchar
Model varchar
TestGroup varchar(255)
ModelYear varchar(255)
Delivered varchar(255)
DateDelivered varchar(255)
DeliveryState varchar(255)
Placed varchar(255)
DatePlaced varchar(255)
PlacementState varchar(255)
AgencyName varchar(255)
AgencyContact varchar(255)
ContactEmail varchar(255)
GovtPlacement varchar(255)
IsImportFailed bit
Error_Desc varchar
FileUploadMappingId int
AccountActions
PK Id int
Name nvarchar
Links nvarchar
AccountBalancePoolings
PK Id int
ModelYear int
FK AccountId int
FK AccountTypeId int
FK Pool int
StandardCredits float
ATDPCredits float
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
AccountBalances
PK Id int
ModelYear int
FK AccountId int
FK AccountTypeId int
StandardCredits float
TransSystemCredits float
AdvDemoCredits float
PreProgramCredits float
FK TransactionTypeId int
FK StateId int
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
AccountDebitPoolings
PK Id int
ModelYear int
FK AccountId int
FK AccountTypeId int
FK TransactionTypeId int
StandardCreditsUsedEast float
ATDPCreditsUsedEast float
StandardCreditsUsedWest float
ATDPCreditsUsedWest float
ParentId int
IsHold bit
Status int
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
AccountDebits
PK Id int
ReportingYear int
CreditModelYear int
FK AccountId int
FK StateId int
ObligationAccountTypeId int
FK AccountTypeId int
FK TransactionTypeId int
TransferTransactionTypeId int
CreditTransactionTypeId int
StandardCreditsUsed float
TSCreditsUsed float
ATDPCreditsUsed float
PreProgramCreditsUsed float
ParentId int
IsHold bit
Status int
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
PoolingTransactionTypeId int
Accounts
PK Id int
FK CompanyTypeId int
ExecutiveOrderNumber nvarchar(14)
ManufacturingCompanyName nvarchar(30)
CompanyAddress nvarchar(200)
AccountCode nvarchar(20)
IsTermsAndConditionAccepted bit
FK AccountStatusId int
OptedForPooling bit
InvitationToken nvarchar
FK AccountActionId int
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
OptedForGHG bit
AccountStatus
PK Id int
Name nvarchar
SortOrder int
AccountTypes
PK Id int
AccountType nvarchar(50)
AccountTypeCode nvarchar(50)
IsAnnualRequirement int
IsSubAccount int
ParentAccountTypeId int
CreditAccountHierarchy int
SortingOrder int
TravelAccountTypes int
PoolingAccountTypes int
Status int
CreatedOn datetime
CreatedBy int
ModifiedOn datetime
ModifiedBy int
AccountVolumeStatus
PK Id int
FK AccountId int
FK VolumeStatusId int
ModelYear int
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime isSameYearMethodApproved int isAdditionalDeficitYearAllowed bit
Adjustments
PK Id int
FK AccountId int
FK StateId int
CreditModelYear int
FK AccountTypeId int
FK CreditTypeId int
FK TransactionTypeId int
PreviousBalance float
AdjustmentCredit float
CreditOrDebit nvarchar(1)
NewBalance float
Reason nvarchar
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
AdvTechDemoPgmAnnualCredits
PK Id int
ReportingYear int
VIN nvarchar(17)
ExecutiveOrderNumber nvarchar
Make nvarchar
Model nvarchar
TestGroup nvarchar
ModelYear int
Tier int
StartDate1 datetime
EndDate1 datetime
Location1 int
StartDate2 datetime
EndDate2 datetime
Location2 int
StartDate3 datetime
EndDate3 datetime
Location3 int
StartDate4 datetime
EndDate4 datetime
Location4 int
StartDate5 datetime
EndDate5 datetime
Location5 int
StartDate6 datetime
EndDate6 datetime
Location6 int
FK Status int
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int isPrototype bit
AnnualRequirements
PK Id int
FK AccountId int
ModelYear int
CreditPercentageRequirement float
FK AnnualRequirementStatusLookupId int
FK CalculationMethodId int
FK AccountypeId int
IsTermsAndConditionsAccepted bit
TermsAndConditionsAcceptedBy nvarchar
FK ZEVStateId int
CreditPercentage float
IsPoolingRequirement bit
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
AnnualRequirementStatusLookups
PK Id int
Value nvarchar
ApplicationActivityMenus
PK Id int
MenuName nvarchar
ControllerName nvarchar
ActionName nvarchar
ParentId int
SubMenuDisplayOrder int
Active bit
ApplicationWideFlags
PK Id int
Name nvarchar
Description nvarchar
Status bit
PlannedEffectiveModelYear int
ActualEffectiveModelYear int
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
FK UpdatedBy int
ATPZEVAnnualCredits
PK Id int
ReportingYear int
ExecutiveOrderNumber nvarchar
ModelYear int
Make nvarchar
Model nvarchar
TestGroup nvarchar
VehiclesDelivered int
Base_PZEV_Allow float
Adv_Componentry_Allow float
Low_Fuel_Cycle_Allow float
HEV_Type nvarchar(1)
HEV_Type_Allow float
Total_PZEV_Credit float
FK Status int
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
ATPZEVCreditsValues
PK Id int
Manufacturer nvarchar
AccountCode nvarchar
ExecutiveOrderNumber nvarchar
TestGroup nvarchar
ModelYear int
Make nvarchar
ModelName nvarchar
CreditValue decimal
Status bit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
AuditLogs
PK Id int
AccountId int
StateId int
FK AuditTypeId int
ActionType int
Description nvarchar
FK CreatedBy int
CreatedOn datetime
AuditTypes
PK Id int
Name nvarchar
BalanceTrasferJobSchedules
PK Id int
AccountId int
StateId int
ReportingYear int isBalanceTransfered bit
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
CalculationMethods
PK Id int
Value nvarchar
ChangeRepresentativesRequests
PK Id int
FK AccountId int
PresentPrimaryUserId int
PresentSecondaryUserId int
PresentExecutiveUserId int
NewPrimaryUserId int
NewSecondaryUserId int
NewExecutiveUserId int
StatusId int
StepsCompletedId int isChangeApplied bit
Comments nvarchar
FileUploadId int
EffectiveDate datetime
RequestedById int
RequestedOn datetime
ApprovedById int
ApprovedOn datetime
ChangeRepStatus
PK Id int
Status nvarchar(20)
ChangeRepSteps
PK Id int
Step nvarchar(20)
CommonStatus
PK Id int
Value nvarchar
CompanyTypes
PK Id int
Name nvarchar
Compliances
PK Id int
FK AnnualRequirementId int
CreditsApplied float
IsPoolingRequirement bit
Status int
ComplianceStatus bit
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
ConsultingCompanies
PK Id int
FK CompanyTypeId int
FK AccountId int
ConsultingCompanyName nvarchar(30)
ConsultingCompanyAddress nvarchar(200)
ConsultingCompanyPhone nvarchar(30)
ConsultingCompanyFax nvarchar(30)
IsTermsAndConditionAccepted bit
FK AccountStatusId int
InvitationToken nvarchar
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ControlAttributes
PK Id int
Key nvarchar(20)
Name nvarchar(50)
Description nvarchar
Value int
MinAllowed int
MaxAllowed int
UpdatedOn datetime
UpdatedBy int
CreditPercentages
PK Id int
FK VolumeStatusId int
ModelYear int
Requirement float
FK AccountypeId int
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
CreditTypes
PK Id int
Name nvarchar
Status bit
DeficitNoticeStatus
Id int
AccountId int
StateId int
ComplianceYear int
NoticeSentOn datetime
DM_CreditBalance_ModelYear_Lookup
PK Id int
ModelYearInFile varchar(50)
ModelYearInSystem int
ECertDatas
PK Id int
ModelYear int
AccountCode nvarchar(4)
ManufacturerName nvarchar
ExecutiveOrderNumber nvarchar
EOType nvarchar
TestGroup nvarchar
Make nvarchar
Model nvarchar
FK VehicleTypesId int
EO_MODEL_VEH_CLASS nvarchar
CA_PROJ_SALES int
TOTAL_US_PROJECTED_SALES int
SECTION_177_STATES_PROJECTED_SALES int
ZEV_TIER nvarchar
BASE_PZEV_ALLOW float
EAER float
RCDA float
UF float
ZERO_EMIS_VMT_PZEV_ALLOW float
TOT_PZEV_CREDIT float
US06_ALLOW_POST2018 float
ADV_ZEV_COMP_PZEV_ALLOW float
Status int
ZEV_URB_AER_UDDS_POST2018 float
H2_ICE_ALLOW_POST2018 float
HEVTYPE nvarchar(1)
HEVTypeCredit float
LOW_FUEL_CYCLE_ALLOW float
ZEVStateId int
LinkageToTranist bit
Shared_Used_Intelligence bit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ZEV_AER_UDDS_POST2018 float
ELMAH_Error
PK ErrorId uniqueidentifier
Application nvarchar(60)
Host nvarchar(50)
Type nvarchar(100)
Source nvarchar(60)
Message nvarchar(500)
User nvarchar(50)
StatusCode int
TimeUtc datetime
Sequence int
AllXml ntext(1073741823)
EmailTemplates
PK Id int
Name nvarchar
EmailFrom nvarchar
EmailCC nvarchar
EmailBCC nvarchar
Priority nvarchar
Subject nvarchar
Content nvarchar
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ErrorLog_SSISPackages
PK Id int
FK ModuleId int
Source nvarchar
FK FileUploadMappingId int
Error_Desc nvarchar
UserId int
TimeStamp datetime
FileStatusLookUps
PK FileStatusId int
FileStatusName nvarchar
Description nvarchar
FileUploadMappings
PK FileUploadMappingId int
FK ModuleId int
AccountId int
ConsultingCompanyId int
FK FileUploadId int
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
FK UserId int
FileUploads
PK FileUploadId int
UploadedFileName nvarchar(300)
FileNameOnDisk nvarchar(500)
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
FK Status int
AccountId int
ConsultingCompanyId int
FK StateId int
GHGVehicleCredits
PK Id int
ReportingYear int
ModelYear int
FK Status int
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
FK AccountId int
Credits float
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
GlobalRevenues
PK Id int
FK AccountId int
ModelYear int
Revenue float
ModuleTypeLookUps
PK ModuleId int
ModuleName nvarchar
FileExtensions nvarchar
FolderName nvarchar
MyPoolings
PK Id int
FK AccountId int
FK TransfereeStateId int
FK TransferorStateId int
InternalRefNumber nvarchar(50)
ReportingYear int
CreditModelYear int
FK AccountTypeId int
StandardCreditTransferedIn float
StandardCreditTransferedOut float
ATDPCreditsTransferedIn float
ATDPCreditsTransferedOut float
TravelStandardCreditTransferedIn float
TravelStandardCreditTransferedOut float
TravelATDPCreditsTransferedIn float
TravelATDPCreditsTransferedOut float
IsHold bit
FK Status int
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
TSCreditsTransferedIn float
TSCreditsTransferedOut float
TravelTSCreditsTransferedIn float
TravelTSCreditsTransferedOut float
BalTransInPre float
BalTransInPost float
BalTransOutPre float
BalTransOutPost float
NMOGTotalSales
PK NMOGTotalSalesId int
ModelYear int
LDT1Sales int
LDT2Sales int
FK AccountId int
FK ZEVStateId int
UpdatedBy int
UpdatedOn datetime
CreatedBy int
CreatedOn datetime
NMOGZEVSales
PK NMOGZEVSalesId int
ZEVSales int
ExecutiveOrderNumber nvarchar
TestGroupName nvarchar
MakeName nvarchar
ModelName nvarchar
FK AccountId int
ModelYear int
FK ZEVStateId int
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
ReportingYear int
NotificationMessages
Id int
Name nvarchar(40)
Title nvarchar
Message nvarchar isActive bit
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
NotificationTypes
PK Id int
Name nvarchar
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
PoolingPercentageForAccounts
PK Id int
FK AccountId int
ModelYear int
FK AccountTypeId int
IsActive bit
PoolingRequirement float
Description nvarchar
FK UpdatedBy int
UpdatedOn datetime
PoolingPercentageRequirements
PK Id int
FK AccountTypeId int
ModelYear int
PoolingRequirement float
IsActive bit
Description nvarchar
FK CreatedBy int
CreatedOn datetime
FK UpdatedBy int
UpdatedOn datetime
PoolingRegions
PK Id int
Name nvarchar
Poolings
PK Id int
FK AccountId int
FK StateId int
FK Pool int
FK Transaction int
ReportingYear int
CreditModelYear int
FK AccountTypeId int
StandardCreditsUsed float
ATDPCreditsUsed float
IsHold bit
FK Status int
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
PoolingStatus
PK Id int
Name nvarchar
PoolingTransactionTypes
PK Id int
TransactionType nvarchar
PZEVAnnualCredits
PK Id int
ReportingYear int
ExecutiveOrderNumber nvarchar
ModelYear int
Make nvarchar
Model nvarchar
TestGroup nvarchar
VehiclesDelivered int
Total_PZEV_Credit float
FK Status int
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
PZEVVehicleTypeLookUps
PK Id int
Value nvarchar
QuickLinks
PK id int title nvarchar type int location nvarchar isHidden bit sortOrder int updatedOn datetime updatedBy int
RegistrationInvites
PK Id int
CompanyName nvarchar(50)
FK CompanyTypeId int
FK AutoManufaturerId int
ContactName nvarchar(50)
Email nvarchar
PhoneNumber nvarchar
FK InviteStatusId int
Token nvarchar
CreatedOn datetime
FK CreatedBy int
UpdatedBy int
UpdatedOn datetime
RegistrationInviteStatus
PK Id int
Name nvarchar
RejectionReasons
PK Id int
Description nvarchar
ReportParameterKeys
PK KeyValue nvarchar(20)
RoleId int
AccountId int
Roles
PK Id int
RoleType nvarchar
Status bit
Description nvarchar
RolesActionApplicationActivityMappings
PK Id int
FK ActivityId int
FK RolesId int
States
PK Id int
Name nvarchar
ShortForm nvarchar
SuppressRequirementForAccounts
PK Id int
AccountId int
OptionalComments nvarchar
SuppressFromYear int
SuppressUntilYear int
IsActive bit
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
SystemNotifications
PK Id int
FK AccountId int
FK StateId int
FK UserTypeId int
FK UserId int
FK UserRoleId int
Description nvarchar
Status bit
FK NotificationTypeId int
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
TierLookUps
PK Id int
Tier nvarchar
TransactionHistories
PK Id int
FK AccountId int
FK StateId int
AccountTypeId int
ReportingYear int
ModelYear int
ExecutiveOrderNumber nvarchar
TestGroup nvarchar
Make nvarchar
Model nvarchar
VehiclesDelivered int
CreditOrDebit nvarchar(1)
TransactionDate datetime
FK TransactionTypeId int
TransferId int
Credits float
FK CreditTypeId int
Description nvarchar
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
TransactionTypes
PK Id int
Name nvarchar(20)
Status bit
Transfers
PK Id int
FK TransferorMfr int
FK TransfereeMfr int
FK CreditAccount int
ModelYear int
CreditModelYear int
IsTravel bit
StandardCreditsUsed float
TSCreditsUsed float
ATDPCreditsUsed float
PreProgramCreditsUsed float
StateId int
InternalRefNumber nvarchar(50)
TransferCode nvarchar(5)
FK Status int
RejectionComment nvarchar
RejectionCommentLog nvarchar
TransfereeApprovalDate datetime
AdminApprovalDate datetime
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
UpdatedBy int
TransferStatus
PK Id int
Name nvarchar
TransportationSystemsCreditValues
PK Id int
VehicleType nvarchar
ModelYearFrom int
ModelYearTo int
SharedUseIntelligenceCredit float
LinkageToTransit float
TravelCredits
PK Id int
FK ZevStateId int
FK AccountId int
FK AccountTypeId int
ModelYear int
ReportingYear int
StandardCredits float
TSCredits float
ATDPCredits float
SubmittedOn datetime
FK SubmittedBy int
FK Status int
CreatedOn datetime
FK CreatedBy int
UpdatedOn datetime
FK UpdatedBy int
TZEVAnnualCredits
PK Id int
ReportingYear int
ExecutiveOrderNumber nvarchar
ModelYear int
Make nvarchar
Model nvarchar
TestGroup nvarchar
BasicPZEVAllowance float
EAER float
RCDA float
UF float
TotalVMT float
US06Allowance float
AdvCompAllow float
H2ICEAllowance float
HEVType nvarchar
HEVTypeCredit float
TotalPZevCredit float
VehiclesDelivered int
FK Status int
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstTotalCredit float
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ZEV_AER_UDDS_POST2018 float
ZEV_URB_AER_UDDS_POST2018 float
UserAccounts
PK Id int
FK UserId int
FK AccountId int
FK ConsultingComapnyId int
Title nvarchar(100)
IsDefault bit
IsSecondarySameAsPrimarybit
IsExecutiveSameAsPrimarybit
FK UserTypeId int
FK StatusId int
FK RoleId int
AcceptTermsAndConditionsbit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
IsActive bit
IsConsultingCompany bit
UserAccounts
PK Id int
FK UserId int
FK AccountId int
FK ConsultingComapnyId int
Title nvarchar(100)
IsDefault bit
IsSecondarySameAsPrimary bit
IsExecutiveSameAsPrimary bit
FK UserTypeId int
FK StatusId int
FK RoleId int
AcceptTermsAndConditions bit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
IsActive bit
IsConsultingCompany bit
UFTables
PK Id int
Distance int
UFValue float
Users
PK Id int
FirstName nvarchar(30)
MI nvarchar(1)
LastName nvarchar(30)
Email nvarchar
Phone nvarchar(30)
Fax nvarchar(30)
Address nvarchar(100)
Password nvarchar
Token nvarchar
IsActive bit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
IsDeleted bit
UserStates
PK Id int
FK UserId int
FK ZEVStateId int
FK RoleId int
Title nvarchar(100)
IsActive bit
IsStateExecutive bit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
UserStatus
PK Id int
Name nvarchar
UserSystemNotifications
PK Id int
FK UserId int
FK SystemNotificationId int
IsRead bit
UserTypes
PK Id int
Name nvarchar
VehicleClassLookups
PK Id int
Value nvarchar
VehicleTypes
PK Id int
VehicleType nvarchar
Description nvarchar
ModelYearFrom int
ModelYearTo int
FK AccountTypeID int
Status int
CreatedBy int
CreatedOn datetime
UpdatedBy int
UpdatedOn datetime
VINModelYearMappingLookUps
PK Id int
Value nvarchar
ModelYear nvarchar
VINModelYearMappingLookUps
PK Id int
Value nvarchar
ModelYear nvarchar
VolumeStatus
PK Id int
VolumeStatusName nvarchar
YearEndBalances
PK Id int
ComplianceYear int
FK AccountId int
FK StateId int
FK AccountTypeId int
StandardCredits float
TransSystemCredits float
AdvDemoCredits float
PreProgramCredits float
FK TransactionTypeId int
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
ZEV_FCVAnnualCredit
PK Id int
ReportingYear int
VIN nvarchar(17)
ExecutiveOrderNumber nvarchar
Make nvarchar
Model nvarchar
ModelYear int
TestGroup nvarchar
Delivered bit
DateDelivered datetime
DeliveryState nvarchar(2)
Placed bit
DatePlaced datetime
PlacementState nvarchar(2)
GovtPlacement int
AgencyName nvarchar
AgencyContact nvarchar
ContactEmail nvarchar
UDDSRange float
FK Status int
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ZEV_Non_FCVAnnualCredit
PK Id int
ReportingYear int
ExecutiveOrderNumber nvarchar
ModelYear int
Make nvarchar
Model nvarchar
TestGroup nvarchar
UDDSRange float
VehiclesDelivered int
FK Status int
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ZEVAnnualCredits
PK Id int
ReportingYear int
VIN nvarchar(17)
ExecutiveOrderNumber nvarchar
Make nvarchar
Model nvarchar
TestGroup nvarchar
FK Tier int
ModelYear int
Delivered bit
DateDelivered datetime
DeliveryState nvarchar(2)
Placed bit
DatePlaced datetime
PlacementState nvarchar
GovtPlacement int
AgencyName nvarchar
AgencyContact nvarchar
ContactEmail nvarchar
FK Status int
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
ZevCreditStatus
PK Id int
Name nvarchar
ZevCreditsValues
PK Id int
ModelYearFrom int
ModelYearTo int
FK ZevTier int
DeliveryCredit float
TotalCredits float
Status bit
CreatedOn datetime
CreatedBy int
UpdatedBy int
UpdatedOn datetime
ExecutiveOrderNumber nvarchar
TestGroup nvarchar
ZEVStates
PK id int
FK StateId int
SalesDataDeadlineMonth int
SalesDataDeadlineDay int
SupplementalDataDeadlineMonth int
SupplementalDataDeadlineDay int
FK PoolingRegionId int
Status int
FK CreatedBy int
CreatedOn datetime
FK ModifiedBy int
ModifiedOn datetime
ZevTransportAnnualCredits
PK Id int
ReportingYear int
VIN nvarchar(17)
ExecutiveOrderNumber nvarchar
ModelYear int
Make nvarchar
Model nvarchar
FK Tier int
TestGroup nvarchar
DatePlacedFrom datetime
DatePlacedTo datetime
SharedUsedIntelligence bit
Linkage bit
CreditValue float
FK Status int
FK StateId int
FK AccountId int
FK VehicleTypeId int
EstimatedCredits float
RequestRevisionType int
RequestRevisionCode int
RequestRevisionComment nvarchar
RequestRevisionCommentLog nvarchar
RejectionType int
RejectionCode int
RejectionComment nvarchar
RejectionCommentLog nvarchar
IsBalanceApplied bit
EarnedCredits float
CreatedOn datetime
CreatedBy int
UpdatedOn datetime
UpdatedBy int
| ZEV_ERD_2024apr10 |
| Page 1 |
File details come from the government source that posted it. Updated .