This API provides access to a comprehensive dataset of NNSA projects, including various assessments, benchmarks, and financial data relevant to project management and oversight.
To access the API, users must include a valid x-api-key in the request headers. Requests without a valid API key will receive a 401 Unauthorized response. Contact PARS Support to get an API key.
GET https://pars.doe.gov/api/v2/nnsa: Retrieves a list of NNSA projects along with detailed project attributes.
x-api-key: A unique API key required for request authentication.These data tables are included in the JSON response, which will look like the following, with each array containing a row of data. Data fields are included at the end of this document.
{
"Aggr_OA": [],
"Aggr_OA_Aux": [],
"Aggr_EV_Data": [],
"OA_Benchmark": [],
"OA_Benchmark_FIMS": [],
"Prev_Project_ESAAB_Assessments": [],
"Prev_Project_FPD_Assessments": [],
"Prev_Project_PMOA_Assessments": [],
"Prev_Project_Program_Assessments": [],
"Project_Balance_Of_Projects": [],
"Project_KPP": [],
"Project_On_Hold": [],
"Project_Management_Reserve": [],
"Project_Other_Direct_Cost": [],
"Project_Schedule_Contingency": [],
"Project_TBN_Other": []
}
| Table Name | Description |
|---|---|
| Aggr_OA | Aggregated Oversight and assessment data, includes most project information, dates, and other details. Contains some calculated fields used in PARS reports. |
| Aggr_OA_Aux | Less used fields that are not included in Aggr_OA, like obscure CD dates or contacts |
| Aggr_EV_Data | Aggregated EV data, including rollups and historical data. |
| OA_Benchmark | Benchmarking data |
| OA_Benchmark_FIMS | Benchmarking data FIMS mappings |
| Prev_Project_ESAAB_Assessments | Historical ESAAB Assessments (current are in Aggr_OA) |
| Prev_Project_FPD_Assessments | Historical FPD Assessments (current are in Aggr_OA) |
| Prev_Project_PMOA_Assessments | Historical PM Assessments (current are in Aggr_OA) |
| Prev_Project_Program_Assessments | Historical Program Assessments (current are in Aggr_OA) |
| Project_Balance_Of_Projects | Tracks funding stored in a parent project before it is allocated to subprojects |
| Project_KPP | KPP list |
| Project_On_Hold | Information about when a project was put on hold |
| Project_Management_Reserve | FPD Toolbox: Management Reserve |
| Project_Other_Direct_Cost | FPD Toolbox: ODCs |
| Project_Schedule_Contingency | FPD Toolbox: Schedule Contingency |
| Project_TBN_Other | FPD Toolbox: TBN Other (funding allocated to other contracts that aren't the primary) |
| Project_Fee | FPD Toolbox: Project Fee |
| Project_Fee_Awarded | FPD Toolbox: Project Fee Awarded |
401 Unauthorized: Returned when the API key is invalid.500 Internal Server Error: Returned when an unexpected error occurs on the server. Contact PARS Support for helpimport requests
url = "https://pars.doe.gov/api/v2/nnsa"
headers = {
'x-api-key': 'your_api_key_here'
}
response = requests.get(url, headers=headers)
print(response.json()) #you might not want to do this, it's a lot of data
$apiUrl = 'https://pars.doe.gov/api/v2/nnsa'
# Your API key (you should read this from an environment variable or secure location)
$apiKey = 'your_api_key_here'
# Headers to include in the request
$headers = @{
'x-api-key' = $apiKey
'Content-Type' = 'application/json'
}
# Function to fetch NNSA projects
function Fetch-NNSAProjects {
try {
# Send the GET request
$response = Invoke-RestMethod -Uri $apiUrl -Method Get -Headers $headers
# Output the response data
Write-Output "NNSA Project Data:"
Write-Output $response
} catch {
# Handle errors (e.g., network issues, invalid response)
Write-Error "Failed to fetch NNSA projects: $_"
}
}
# Call the function to fetch the project data
Fetch-NNSAProjects
The below data definitions are taken from the PARS data schema used for Prisma queries and represent the current state of the database tables.
model Aggr_EV_Data {
Table_Updated_Date DateTime? @db.DateTime
PARSID Int @unique
OA_Status_Date DateTime? @db.DateTime
CPP_Status_Date DateTime? @db.DateTime
WBS_Top_Level String? @db.VarChar(50)
INC_BCWS Float?
INC_BCWP Float?
INC_ACWP Float?
CUM_INC_BCWS Float?
CUM_INC_BCWP Float?
CUM_INC_ACWP Float?
BAC Float?
EAC Float?
ETC Float?
PercentComplete Float?
PercentPlannedComplete Float?
PercentBudgetSpent Float?
CV Float?
CV_Percentage Float?
SV Float?
SV_Percentage Float?
CPI Float?
SPI Float?
CPI_reset Float?
SPI_reset Float?
CPI_Less_LOE Float?
SPI_Less_LOE Float?
INC_CV Float?
INC_CV_Percentage Float?
INC_SV Float?
INC_SV_Percentage Float?
INC_CPI Float?
INC_SPI Float?
INC_CPI_Less_LOE Float?
INC_SPI_Less_LOE Float?
CUM_BCWS_Top_Level_format1 Float?
CUM_BCWP_Top_Level_format1 Float?
CUM_ACWP_Top_Level_format1 Float?
BAC_format1 Float?
EAC_format1 Float?
UB_BGT Float?
UB_EST Float?
MR_Remaining Float?
Current_Perf_Mgmt_Budget Float?
Contractor_Estimate_At_Completion Float?
VAC Float?
EAC_BEST_IPMR Float?
EAC_WORST_IPMR Float?
EAC_LIKELY_IPMR Float?
VAC_PM Float?
VAC_CAM Float?
SPA_Potential String? @db.VarChar(3)
iEAC_CPI Float?
INC_BCWS_UNITS Float?
INC_BCWP_UNITS Float?
INC_ACWP_UNITS Float?
CUM_INC_BCWS_UNITS Float?
CUM_INC_BCWP_UNITS Float?
CUM_INC_ACWP_UNITS Float?
ETC_UNITS Float?
}
model Aggr_OA {
Table_Updated_Date DateTime? @db.DateTime
PARSID Int @unique
Project_Status String? @db.VarChar(50)
Program String? @db.VarChar(50)
Project_Name String? @db.VarChar(200)
Project_Acronym String? @db.VarChar(50)
DOE_Project_Number String? @db.VarChar(50)
Project_Type String? @db.VarChar(50)
Funding_Type String? @db.VarChar(50)
Budget_Program String? @db.VarChar(100)
Program_Office String? @db.VarChar(100)
Contract_Number String? @db.VarChar(50)
Site_Code String? @db.VarChar(50)
Project_Description String? @db.VarChar(Max)
CD0_Forecasted_Planned_Date DateTime? @db.Date
CD1_Forecasted_Planned_Date DateTime? @db.Date
CD3A_Forecasted_Planned_Date DateTime? @db.Date
CD2_Forecasted_Planned_Date DateTime? @db.Date
CD3_Forecasted_Planned_Date DateTime? @db.Date
CD4_Forecasted_Planned_Date DateTime? @db.Date
Closeout_Forecasted_Planned_Date DateTime? @db.Date
CD3_Lessons_Learned_Report_Received_Date DateTime? @db.Date
CD4_Lessons_Learned_Report_Received_Date DateTime? @db.Date
CD4_Primary_Closeout_Report_Received_Date DateTime? @db.Date
Last_Peer_Review_Date DateTime? @db.Date
Nuclear_Non_Nuclear String? @db.VarChar(50)
PMRC String? @db.VarChar(5)
CPP_Upload_Requirements String? @db.VarChar(50)
Project_of_Special_Interest String? @db.VarChar(3)
Success_Metric String? @db.VarChar(150)
Initial_Entered_Date DateTime? @db.Date
Next_Status String? @db.VarChar(50)
Information_Technology String? @db.VarChar(5)
PM_Oversight String? @db.VarChar(5)
Cancelled_Status String? @db.VarChar(10)
Increment String? @db.VarChar(5)
Parent String? @db.VarChar(5)
Operational_Release String? @db.VarChar(5)
CUI_Data Int
PARSID_Parent Int?
Parent_Project_Name String? @db.VarChar(213)
Assigned_PM20_Analyst String @db.VarChar(250)
Assigned_PM20_Analyst_Date DateTime? @db.Date
Assigned_PM20_Analyst_Unassigned_Date DateTime? @db.Date
Assigned_PM30_Analyst String @db.VarChar(250)
Assigned_PM30_Analyst_Date DateTime? @db.Date
Assigned_PM30_Analyst_Unassigned_Date DateTime? @db.Date
Assigned_FPD String @db.VarChar(250)
Assigned_FPD_Date DateTime? @db.Date
Assigned_FPD_Certification String @db.VarChar(250)
Assigned_FPD_Project_Role String? @db.VarChar(150)
Assigned_FPD_Unassigned_Date DateTime? @db.Date
Assigned_FPM String @db.VarChar(250)
Assigned_FPM_Date DateTime? @db.Date
Assigned_FPM_Certification String? @db.VarChar(250)
Assigned_FPM_Unassigned_Date DateTime? @db.Date
Assigned_Prime_Contractor String @db.VarChar(250)
Assigned_Prime_Contractor_Date DateTime? @db.Date
Assigned_Prime_Contractor_EVMS_Certification String? @db.VarChar(250)
Assigned_Prime_Contractor_Unassigned_Date DateTime? @db.Date
Assigned_CE_PME String @db.VarChar(250)
Assigned_CE_PME_Date DateTime? @db.Date
Assigned_CE_PME_Certification String? @db.VarChar(250)
Assigned_CE_PME_Unassigned_Date DateTime? @db.Date
Assigned_Project_Owner String @db.VarChar(250)
Assigned_Project_Owner_Date DateTime? @db.Date
Assigned_Project_Owner_Certification String? @db.VarChar(250)
Assigned_Project_Owner_Unassigned_Date DateTime? @db.Date
CD0_Approved_Date DateTime? @db.Date
CD0_Approved_By String? @db.VarChar(250)
CD0_Approval_Notes String? @db.VarChar(Max)
CD0_TPC_High Float? @db.Money
CD0_TPC_Low Float? @db.Money
CD0_CD4_Date_High DateTime? @db.Date
CD0_CD4_Date_Low DateTime? @db.Date
CD0_CD1_Original_Planned_Date DateTime? @db.Date
CD0_CD2_Original_Planned_Date DateTime? @db.Date
CD0_CD3_Original_Planned_Date DateTime? @db.Date
CD0_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R_Max_Number String? @db.VarChar(10)
CD0R_Max_Approved_Date DateTime? @db.Date
CD0R_Max_Approved_By String? @db.VarChar(250)
CD0R_Max_Approval_Notes Float? @db.Money
CD0R_Max_TPC_High Float? @db.Money
CD0R_Max_TPC_Low Float? @db.Money
CD0R_Max_CD4_Date_High DateTime? @db.Date
CD0R_Max_CD4_Date_Low DateTime? @db.Date
CD0R_Max_CD1_Original_Planned_Date DateTime? @db.Date
CD0R_Max_CD2_Original_Planned_Date DateTime? @db.Date
CD0R_Max_CD3_Original_Planned_Date DateTime? @db.Date
CD0R_Max_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R_Max_Initial_Entered_Date DateTime? @db.Date
CD1_Approved_Date DateTime? @db.Date
CD1_Approved_By String? @db.VarChar(250)
CD1_Approval_Notes String? @db.VarChar(Max)
CD1_TPC_High Float? @db.Money
CD1_TPC_Low Float? @db.Money
CD1_CD4_Date_High DateTime? @db.Date
CD1_CD4_Date_Low DateTime? @db.Date
CD1_CD2_Original_Planned_Date DateTime? @db.Date
CD1_CD3_Original_Planned_Date DateTime? @db.Date
CD1_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R_Max_Number String? @db.VarChar(10)
CD1R_Max_Approved_Date DateTime? @db.Date
CD1R_Max_Approved_By String? @db.VarChar(250)
CD1R_Max_Approval_Notes String? @db.VarChar(Max)
CD1R_Max_TPC_High Float? @db.Money
CD1R_Max_TPC_Low Float? @db.Money
CD1R_Max_CD4_Date_High DateTime? @db.Date
CD1R_Max_CD4_Date_Low DateTime? @db.Date
CD1R_Max_CD2_Original_Planned_Date DateTime? @db.Date
CD1R_Max_CD3_Original_Planned_Date DateTime? @db.Date
CD1R_Max_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R_Max_Initial_Entered_Date DateTime? @db.Date
CD3A_Approved_Date DateTime? @db.Date
CD3A_Approved_By String? @db.VarChar(250)
CD3A_Approval_Notes String? @db.VarChar(Max)
CD3A_Approved_Cost Float? @db.Money
CD3A_Approved_Scope String? @db.VarChar(Max)
CD2_Approved_Date DateTime? @db.Date
CD2_Approved_By String? @db.VarChar(250)
CD2_Approval_Notes String? @db.VarChar(Max)
CD2_TPC_Approved Float? @db.Money
CD2_Calculated_TPC Float? @db.Money
CD2_CD4_Approved_Date DateTime? @db.Date
CD2_CD3_Original_Planned_Date DateTime? @db.Date
CD2_Original_DOE_Schedule_Contingency Int?
CD2_Original_Contractor_MR Float? @db.Money
CD2_Original_Contractor_Fee_Profit Float? @db.Money
CD2_Original_DOE_Cost_Contingency Float? @db.Money
CD2_DOE_ODCs Float? @db.Money
CD2_PMB Float? @db.Money
CD2_Delta Float? @db.Money
CD3_Approved_Date DateTime? @db.Date
CD3_Approval_Notes String? @db.VarChar(Max)
CD3_Approved_By String? @db.VarChar(250)
CD4_Date_at_CD3 DateTime? @db.Date
TPC_at_CD3 Float? @db.Money
BCP_Max_Integer Int?
BCP_Max_Number String? @db.VarChar(10)
BCP_Max_Descriptive_Title String? @db.VarChar(250)
BCP_Max_Approved_Date DateTime? @db.Date
BCP_Max_Approved_By String? @db.VarChar(250)
BCP_Max_Approval_Notes String? @db.VarChar(Max)
BCP_Max_TPC_Approved Float? @db.Money
BCP_Max_CD4_Approved_Date DateTime? @db.Date
BCP_Max_Change_in_Scope String? @db.VarChar(50)
BCP_Max_Directed_Change Int?
BCP_Max_DOE_Schedule_Contingency Int?
BCP_Max_Original_Contractor_MR Float? @db.Money
BCP_Max_Original_Contractor_Fee_Profit Float? @db.Money
BCP_Max_Original_DOE_Cost_Contingency Float? @db.Money
BCP_Max_DOE_ODCs Float? @db.Money
BCP_Max_PMB Float? @db.Money
BCP_Max_Calculated_TPC Float? @db.Money
BCP_Max_Delta Float? @db.Money
CD4_Approved_Date DateTime? @db.Date
CD4_Approved_By String? @db.VarChar(250)
CD4_Approval_Notes String? @db.VarChar(Max)
CD4_KPP_Scope_Complete String? @db.VarChar(50)
CD4_Estimated_Final_TPC Float? @db.Money
Closeout_Approved_Date DateTime? @db.Date
Closeout_Approved_By String? @db.VarChar(250)
Closeout_Approval_Notes String? @db.VarChar(Max)
Closeout_Actual_Cost_At_Financial_Closeout Float? @db.Money
Current_CD_Approved String? @db.NVarChar(20)
Current_CD_Approved_Date DateTime? @db.Date
Current_TPC_Approved Float? @db.Money
TPC_Approved Float? @db.Money
Current_CD4_Approved_Date DateTime? @db.Date
Current_CD_Incl_BCP_Approved String? @db.NVarChar(20)
Current_CD_Approved_Date_Incl_BCP_Approved DateTime? @db.Date
CD_Next_Level String? @db.NVarChar(20)
CD_Next_Forecasted_Date DateTime? @db.Date
CD_Next_Planned_Date DateTime? @db.Date
Cost_Contingency_Current_Approved Float @db.Money
Cost_Contingency_Remaining_Balance Float? @db.Money
Fee_Contingency_Current_Approved Float @db.Money
Fee_Contingency_Remaining_Balance Float? @db.Money
ODC_Current_Approved Float @db.Money
ODC_Remaining_Balance Float? @db.Money
Schedule_Contingency_Current_Approved Int
Schedule_Contingency_Remaining_Balance Float? @db.Money
Contractor_MR_Current_Approved Float @db.Money
EV_Latest_Contractor_MR_Balance_Remaining Float? @db.Money
EV_Latest_CPP_Status_Date DateTime? @db.DateTime
EV_OA_Current_CPP_Status_Date DateTime? @db.DateTime
EV_OA_Previous_CPP_Status_Date DateTime? @db.DateTime
OA_Status_Date DateTime? @db.DateTime
OA_Status_Date_Previous DateTime? @db.DateTime
Cost_Contingency_Latest_Mod_Date DateTime? @db.DateTime
Fee_Latest_Mod_Date DateTime? @db.DateTime
Other_Direct_Cost_Latest_Mod_Date DateTime? @db.DateTime
Schedule_Contingency_Latest_Mod_Date DateTime? @db.DateTime
FPD_Assessment_Status_Date DateTime? @db.Date
FPD_Assessment_Status String? @db.VarChar(10)
FPD_Assessment_Forecast_Completion DateTime? @db.Date
FPD_Assessment_Forecast_for_TPC Float? @db.Money
FPD_Assessment_Narrative String? @db.VarChar(Max)
FPD_Overall_RYG String? @db.VarChar(10)
Program_Assessment_Status_Date DateTime? @db.Date
Program_Assessment_Status String? @db.VarChar(10)
Program_Assessment_Forecast_Completion DateTime? @db.Date
Program_Assessment_Forecast_for_TPC Float? @db.Money
Program_Assessment_Narrative String? @db.VarChar(Max)
Program_RYG_Overall String? @db.VarChar(10)
PM_Assessment_Status_Date DateTime? @db.Date
PM_Assessment_Assessment_Status String? @db.VarChar(10)
PM_Assessment_Forecast_Status String? @db.VarChar(15)
PM_Assessment_Adjusted_Percent_Complete Float?
PM_Assessment_Forecast_Completion DateTime? @db.Date
PM_Assessment_Forecast_for_TPC Float? @db.Money
PM_Assessment_Cost_Narrative String? @db.VarChar(Max)
PM_Assessment_Schedule_Narrative String? @db.VarChar(Max)
PM_Assessment_Scope_Narrative String? @db.VarChar(Max)
PM_Assessment_Overall_Narrative String? @db.VarChar(Max)
PM_Assessment_RYG_Overall String? @db.VarChar(10)
PM_Assessment_RYG_Cost String? @db.VarChar(10)
PM_Assessment_RYG_Schedule String? @db.VarChar(10)
PM_Assessment_RYG_Scope String? @db.VarChar(10)
Upload_Type String? @db.NVarChar(20)
EV_Latest_Contractor_Estimate_At_Completion Float? @db.Money
EV_Latest_EAC_LIKELY_IPMR Float? @db.Money
EV_Latest_EAC_BEST_IPMR Float? @db.Money
EV_Latest_EAC_WORST_IPMR Float? @db.Money
Post_CD2 Int?
CostToGo_CD0_To_Go_Prepared_By String? @db.VarChar(15)
CostToGo_CD0_To_Go_Cost_Next_CD Float? @db.Money
CostToGo_CD0_Program_Index String? @db.VarChar(15)
CostToGo_CD1_To_Go_Prepared_By String? @db.VarChar(15)
CostToGo_CD1_To_Go_Cost_Next_CD Float? @db.Money
CostToGo_CD1_Program_Index String? @db.VarChar(15)
CostToGo_CD2_To_Go_Prepared_By String? @db.VarChar(15)
CostToGo_CD2_To_Go_Cost_Next_CD Float? @db.Money
CostToGo_CD2_Program_Index String? @db.VarChar(15)
CostToGo_CD3_Current_TPC_Prepared_By String? @db.VarChar(15)
Forecasted_EIR_Final_Report_Date DateTime? @db.Date
Forecasted_ICE_ICR_Final_Report_Date DateTime? @db.Date
Forecasted_Next_IPR_PPR_Final_Report_Date DateTime? @db.Date
Forecasted_EVMS_Review_Final_Report_Date DateTime? @db.Date
CD3B_Forecasted_Planned_Date DateTime? @db.Date
CD3C_Forecasted_Planned_Date DateTime? @db.Date
CD3D_Forecasted_Planned_Date DateTime? @db.Date
CD3E_Forecasted_Planned_Date DateTime? @db.Date
CD3F_Forecasted_Planned_Date DateTime? @db.Date
CD4A_Forecasted_Planned_Date DateTime? @db.Date
CD4B_Forecasted_Planned_Date DateTime? @db.Date
CD4C_Forecasted_Planned_Date DateTime? @db.Date
CD4D_Forecasted_Planned_Date DateTime? @db.Date
CD4E_Forecasted_Planned_Date DateTime? @db.Date
Process_Start_Time DateTime? @db.DateTime
Process_End_Time Int?
Process_Duration_ms Int?
}
model Aggr_OA_Aux {
Table_Updated_Date DateTime? @db.DateTime
PARSID Int @unique
Assigned_Contracting_Officer String @db.VarChar(250)
Assigned_Contracting_Officer_Date DateTime? @db.Date
Assigned_Contracting_Officer_Certification String @db.VarChar(250)
Assigned_Contracting_Officer_Unassigned_Date DateTime? @db.Date
Assigned_Contractor_PM String @db.VarChar(250)
Assigned_Contractor_PM_Date DateTime? @db.Date
Assigned_Contractor_PM_Certification String @db.VarChar(250)
Assigned_Contractor_PM_Unassigned_Date DateTime? @db.Date
Assigned_FPD_Deputy String @db.VarChar(250)
Assigned_FPD_Deputy_Date DateTime? @db.Date
Assigned_FPD_Deputy_Certification String @db.VarChar(250)
Assigned_FPD_Deputy_Unassigned_Date DateTime? @db.Date
Assigned_FPD_Deputy_Secondary String? @db.VarChar(250)
Assigned_FPD_Deputy_Secondary_Date String? @db.VarChar(250)
Assigned_FPD_Deputy_Secondary_Certification String? @db.VarChar(250)
Assigned_FPD_Deputy_Secondary_Unassigned_Date DateTime? @db.Date
Assigned_FPD_Interim String @db.VarChar(250)
Assigned_FPD_Interim_Date DateTime? @db.Date
Assigned_FPD_Interim_Certification String @db.VarChar(250)
Assigned_FPD_Interim_Unassigned_Date DateTime? @db.Date
Assigned_FPM_Deputy String @db.VarChar(250)
Assigned_FPM_Deputy_Date DateTime? @db.Date
Assigned_FPM_Deputy_Certification String @db.VarChar(250)
Assigned_FPM_Deputy_Unassigned_Date DateTime? @db.Date
Assigned_Project_Integrator String @db.VarChar(250)
Assigned_Project_Integrator_Date DateTime? @db.Date
Assigned_Project_Integrator_Certification String @db.VarChar(250)
Assigned_Project_Integrator_Unassigned_Date DateTime? @db.Date
Assigned_Post_CD4_FPD_POC String @db.VarChar(250)
Assigned_Post_CD4_FPD_POC_Date DateTime? @db.Date
Assigned__Post_CD4_FPD_POC_Certification String @db.VarChar(250)
Assigned_Post_CD4_FPD_POC_Unassigned_Date DateTime? @db.Date
Assigned_Federal_POC String @db.VarChar(250)
Assigned_Federal_POC_Date DateTime? @db.Date
Assigned_Federal_POC_Certification String @db.VarChar(250)
Assigned_Federal_POC_Unassigned_Date DateTime? @db.Date
Assigned_Mission_Unit_POC String @db.VarChar(250)
Assigned_Mission_Unit_POC_Date DateTime? @db.Date
Assigned_Mission_Unit_POC_Certification String @db.VarChar(250)
Assigned_Mission_Unit_POC_Unassigned_Date DateTime? @db.Date
CD0_Modified DateTime? @db.DateTime
CD0_Modified_By String? @db.VarChar(250)
CD1_Modified DateTime? @db.DateTime
CD1_Modified_By String? @db.VarChar(250)
CD2_Modified DateTime? @db.DateTime
CD2_Modified_By String? @db.VarChar(250)
CD3_Modified DateTime? @db.DateTime
CD3_Modified_By String? @db.VarChar(250)
CD3A_Modified DateTime? @db.DateTime
CD3A_Modified_By String? @db.VarChar(250)
CD4_Modified DateTime? @db.DateTime
CD4_Modified_By String? @db.VarChar(250)
Closeout_Modified DateTime? @db.DateTime
Closeout_Modified_By String? @db.VarChar(250)
CD3A_Initial_Entered_Date DateTime? @db.Date
CD3A_Description String? @db.VarChar(Max)
CD3B_Approved_Date DateTime? @db.Date
CD3B_Approved_By String? @db.VarChar(250)
CD3B_Approved_Cost Float? @db.Money
CD3B_Approved_Scope String? @db.VarChar(Max)
CD3B_Approval_Notes String? @db.VarChar(Max)
CD3B_Modified DateTime? @db.DateTime
CD3B_Modified_By String? @db.VarChar(250)
CD3B_Initial_Entered_Date DateTime? @db.Date
CD3B_Description String? @db.VarChar(Max)
CD3C_Approved_Date DateTime? @db.Date
CD3C_Approved_By String? @db.VarChar(250)
CD3C_Approved_Cost Float? @db.Money
CD3C_Approved_Scope String? @db.VarChar(Max)
CD3C_Approval_Notes String? @db.VarChar(Max)
CD3C_Modified DateTime? @db.DateTime
CD3C_Modified_By String? @db.VarChar(250)
CD3C_Initial_Entered_Date DateTime? @db.Date
CD3C_Description String? @db.VarChar(Max)
CD3D_Approved_Date DateTime? @db.Date
CD3D_Approved_By String? @db.VarChar(250)
CD3D_Approved_Cost Float? @db.Money
CD3D_Approved_Scope String? @db.VarChar(Max)
CD3D_Approval_Notes String? @db.VarChar(Max)
CD3D_Modified DateTime? @db.DateTime
CD3D_Modified_By String? @db.VarChar(250)
CD3D_Initial_Entered_Date DateTime? @db.Date
CD3D_Description String? @db.VarChar(Max)
CD3E_Approved_Date DateTime? @db.Date
CD3E_Approved_By String? @db.VarChar(250)
CD3E_Approved_Cost Float? @db.Money
CD3E_Approved_Scope String? @db.VarChar(Max)
CD3E_Approval_Notes String? @db.VarChar(Max)
CD3E_Modified DateTime? @db.DateTime
CD3E_Modified_By String? @db.VarChar(250)
CD3E_Initial_Entered_Date DateTime? @db.Date
CD3E_Description String? @db.VarChar(Max)
CD3F_Approved_Date DateTime? @db.Date
CD3F_Approved_By String? @db.VarChar(250)
CD3F_Approved_Cost Float? @db.Money
CD3F_Approved_Scope String? @db.VarChar(Max)
CD3F_Approval_Notes String? @db.VarChar(Max)
CD3F_Modified DateTime? @db.DateTime
CD3F_Modified_By String? @db.VarChar(250)
CD3F_Initial_Entered_Date DateTime? @db.Date
CD3F_Description String? @db.VarChar(Max)
BCP_Max_Modified DateTime? @db.DateTime
BCP_Max_Modified_By String? @db.VarChar(250)
CD0R_Max_Modified DateTime? @db.DateTime
CD0R_Max_Modified_By String? @db.VarChar(250)
CD1R_Max_Modified DateTime? @db.DateTime
CD1R_Max_Modified_By String? @db.VarChar(250)
CostToGo_Modified DateTime? @db.DateTime
CostToGo_Modified_By String? @db.VarChar(250)
BCP1_Integer Int?
BCP1_Number String? @db.VarChar(10)
BCP1_Descriptive_Title String? @db.VarChar(250)
BCP1_Approved_Date DateTime? @db.Date
BCP1_Approved_By String? @db.VarChar(250)
BCP1_Approval_Notes String? @db.VarChar(Max)
BCP1_TPC_Approved Float? @db.Money
BCP1_CD4_Approved_Date DateTime? @db.Date
BCP1_Change_in_Scope String? @db.VarChar(50)
BCP1_Directed_Change Int?
BCP1_DOE_Schedule_Contingency Int?
BCP1_Original_Contractor_MR Float? @db.Money
BCP1_Original_Contractor_Fee_Profit Float? @db.Money
BCP1_Original_DOE_Cost_Contingency Float? @db.Money
BCP1_DOE_ODCs Float? @db.Money
BCP1_PMB Float? @db.Money
BCP1_Calculated_TPC Float? @db.Money
BCP1_Delta Float? @db.Money
BCP1_Modified DateTime? @db.DateTime
BCP1_Modified_By String? @db.VarChar(250)
BCP2_Integer Int?
BCP2_Number String? @db.VarChar(10)
BCP2_Descriptive_Title String? @db.VarChar(250)
BCP2_Approved_Date DateTime? @db.Date
BCP2_Approved_By String? @db.VarChar(250)
BCP2_Approval_Notes String? @db.VarChar(Max)
BCP2_TPC_Approved Float? @db.Money
BCP2_CD4_Approved_Date DateTime? @db.Date
BCP2_Change_in_Scope String? @db.VarChar(50)
BCP2_Directed_Change Int?
BCP2_DOE_Schedule_Contingency Int?
BCP2_Original_Contractor_MR Float? @db.Money
BCP2_Original_Contractor_Fee_Profit Float? @db.Money
BCP2_Original_DOE_Cost_Contingency Float? @db.Money
BCP2_DOE_ODCs Float? @db.Money
BCP2_PMB Float? @db.Money
BCP2_Calculated_TPC Float? @db.Money
BCP2_Delta Float? @db.Money
BCP2_Modified DateTime? @db.DateTime
BCP2_Modified_By String? @db.VarChar(250)
BCP3_Integer Int?
BCP3_Number String? @db.VarChar(10)
BCP3_Descriptive_Title String? @db.VarChar(250)
BCP3_Approved_Date DateTime? @db.Date
BCP3_Approved_By String? @db.VarChar(250)
BCP3_Approval_Notes String? @db.VarChar(Max)
BCP3_TPC_Approved Float? @db.Money
BCP3_CD4_Approved_Date DateTime? @db.Date
BCP3_Change_in_Scope String? @db.VarChar(50)
BCP3_Directed_Change Int?
BCP3_DOE_Schedule_Contingency Int?
BCP3_Original_Contractor_MR Float? @db.Money
BCP3_Original_Contractor_Fee_Profit Float? @db.Money
BCP3_Original_DOE_Cost_Contingency Float? @db.Money
BCP3_DOE_ODCs Float? @db.Money
BCP3_PMB Float? @db.Money
BCP3_Calculated_TPC Float? @db.Money
BCP3_Delta Float? @db.Money
BCP3_Modified DateTime? @db.DateTime
BCP3_Modified_By String? @db.VarChar(250)
BCP4_Integer Int?
BCP4_Number String? @db.VarChar(10)
BCP4_Descriptive_Title String? @db.VarChar(250)
BCP4_Approved_Date DateTime? @db.Date
BCP4_Approved_By String? @db.VarChar(250)
BCP4_Approval_Notes String? @db.VarChar(Max)
BCP4_TPC_Approved Float? @db.Money
BCP4_CD4_Approved_Date DateTime? @db.Date
BCP4_Change_in_Scope String? @db.VarChar(50)
BCP4_Directed_Change Int?
BCP4_DOE_Schedule_Contingency Int?
BCP4_Original_Contractor_MR Float? @db.Money
BCP4_Original_Contractor_Fee_Profit Float? @db.Money
BCP4_Original_DOE_Cost_Contingency Float? @db.Money
BCP4_DOE_ODCs Float? @db.Money
BCP4_PMB Float? @db.Money
BCP4_Calculated_TPC Float? @db.Money
BCP4_Delta Float? @db.Money
BCP4_Modified DateTime? @db.DateTime
BCP4_Modified_By String? @db.VarChar(250)
BCP5_Integer Int?
BCP5_Number String? @db.VarChar(10)
BCP5_Descriptive_Title String? @db.VarChar(250)
BCP5_Approved_Date DateTime? @db.Date
BCP5_Approved_By String? @db.VarChar(250)
BCP5_Approval_Notes String? @db.VarChar(Max)
BCP5_TPC_Approved Float? @db.Money
BCP5_CD4_Approved_Date DateTime? @db.Date
BCP5_Change_in_Scope String? @db.VarChar(50)
BCP5_Directed_Change Int?
BCP5_DOE_Schedule_Contingency Int?
BCP5_Original_Contractor_MR Float? @db.Money
BCP5_Original_Contractor_Fee_Profit Float? @db.Money
BCP5_Original_DOE_Cost_Contingency Float? @db.Money
BCP5_DOE_ODCs Float? @db.Money
BCP5_PMB Float? @db.Money
BCP5_Calculated_TPC Float? @db.Money
BCP5_Delta Float? @db.Money
BCP5_Modified DateTime? @db.DateTime
BCP5_Modified_By String? @db.VarChar(250)
CD0R1_Approved_Date DateTime? @db.Date
CD0R1_Approved_By String? @db.VarChar(250)
CD0R1_TPC_High Float? @db.Money
CD0R1_TPC_Low Float? @db.Money
CD0R1_Approval_Notes String? @db.VarChar(Max)
CD0R1_CD4_Date_High DateTime? @db.Date
CD0R1_CD4_Date_Low DateTime? @db.Date
CD0R1_CD1_Original_Planned_Date DateTime? @db.Date
CD0R1_CD2_Original_Planned_Date DateTime? @db.Date
CD0R1_CD3_Original_Planned_Date DateTime? @db.Date
CD0R1_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R1_Initial_Entered_Date DateTime? @db.Date
CD0R2_Approved_Date DateTime? @db.Date
CD0R2_Approved_By String? @db.VarChar(250)
CD0R2_TPC_High Float? @db.Money
CD0R2_TPC_Low Float? @db.Money
CD0R2_Approval_Notes String? @db.VarChar(Max)
CD0R2_CD4_Date_High DateTime? @db.Date
CD0R2_CD4_Date_Low DateTime? @db.Date
CD0R2_CD1_Original_Planned_Date DateTime? @db.Date
CD0R2_CD2_Original_Planned_Date DateTime? @db.Date
CD0R2_CD3_Original_Planned_Date DateTime? @db.Date
CD0R2_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R2_Initial_Entered_Date DateTime? @db.Date
CD0R3_Approved_Date DateTime? @db.Date
CD0R3_Approved_By String? @db.VarChar(250)
CD0R3_TPC_High Float? @db.Money
CD0R3_TPC_Low Float? @db.Money
CD0R3_Approval_Notes String? @db.VarChar(Max)
CD0R3_CD4_Date_High DateTime? @db.Date
CD0R3_CD4_Date_Low DateTime? @db.Date
CD0R3_CD1_Original_Planned_Date DateTime? @db.Date
CD0R3_CD2_Original_Planned_Date DateTime? @db.Date
CD0R3_CD3_Original_Planned_Date DateTime? @db.Date
CD0R3_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R3_Initial_Entered_Date DateTime? @db.Date
CD0R4_Approved_Date DateTime? @db.Date
CD0R4_Approved_By String? @db.VarChar(250)
CD0R4_TPC_High Float? @db.Money
CD0R4_TPC_Low Float? @db.Money
CD0R4_Approval_Notes String? @db.VarChar(Max)
CD0R4_CD4_Date_High DateTime? @db.Date
CD0R4_CD4_Date_Low DateTime? @db.Date
CD0R4_CD1_Original_Planned_Date DateTime? @db.Date
CD0R4_CD2_Original_Planned_Date DateTime? @db.Date
CD0R4_CD3_Original_Planned_Date DateTime? @db.Date
CD0R4_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R4_Initial_Entered_Date DateTime? @db.Date
CD0R5_Approved_Date DateTime? @db.Date
CD0R5_Approved_By String? @db.VarChar(250)
CD0R5_TPC_High Float? @db.Money
CD0R5_TPC_Low Float? @db.Money
CD0R5_Approval_Notes String? @db.VarChar(Max)
CD0R5_CD4_Date_High DateTime? @db.Date
CD0R5_CD4_Date_Low DateTime? @db.Date
CD0R5_CD1_Original_Planned_Date DateTime? @db.Date
CD0R5_CD2_Original_Planned_Date DateTime? @db.Date
CD0R5_CD3_Original_Planned_Date DateTime? @db.Date
CD0R5_CD3A_Original_Planned_Date DateTime? @db.Date
CD0R5_Initial_Entered_Date DateTime? @db.Date
CD1R1_Approved_Date DateTime? @db.Date
CD1R1_Approval_Notes String? @db.VarChar(Max)
CD1R1_Approved_By String? @db.VarChar(250)
CD1R1_CD4_Date_High DateTime? @db.Date
CD1R1_CD4_Date_Low DateTime? @db.Date
CD1R1_TPC_High Float? @db.Money
CD1R1_TPC_Low Float? @db.Money
CD1R1_CD2_Original_Planned_Date DateTime? @db.Date
CD1R1_CD3_Original_Planned_Date DateTime? @db.Date
CD1R1_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R1_Initial_Entered_Date DateTime? @db.Date
CD1R2_Approved_Date DateTime? @db.Date
CD1R2_Approval_Notes String? @db.VarChar(Max)
CD1R2_Approved_By String? @db.VarChar(250)
CD1R2_CD4_Date_High DateTime? @db.Date
CD1R2_CD4_Date_Low DateTime? @db.Date
CD1R2_TPC_High Float? @db.Money
CD1R2_TPC_Low Float? @db.Money
CD1R2_CD2_Original_Planned_Date DateTime? @db.Date
CD1R2_CD3_Original_Planned_Date DateTime? @db.Date
CD1R2_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R2_Initial_Entered_Date DateTime? @db.Date
CD1R3_Approved_Date DateTime? @db.Date
CD1R3_Approval_Notes String? @db.VarChar(Max)
CD1R3_Approved_By String? @db.VarChar(250)
CD1R3_CD4_Date_High DateTime? @db.Date
CD1R3_CD4_Date_Low DateTime? @db.Date
CD1R3_TPC_High Float? @db.Money
CD1R3_TPC_Low Float? @db.Money
CD1R3_CD2_Original_Planned_Date DateTime? @db.Date
CD1R3_CD3_Original_Planned_Date DateTime? @db.Date
CD1R3_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R3_Initial_Entered_Date DateTime? @db.Date
CD1R4_Approved_Date DateTime? @db.Date
CD1R4_Approval_Notes String? @db.VarChar(Max)
CD1R4_Approved_By String? @db.VarChar(250)
CD1R4_CD4_Date_High DateTime? @db.Date
CD1R4_CD4_Date_Low DateTime? @db.Date
CD1R4_TPC_High Float? @db.Money
CD1R4_TPC_Low Float? @db.Money
CD1R4_CD2_Original_Planned_Date DateTime? @db.Date
CD1R4_CD3_Original_Planned_Date DateTime? @db.Date
CD1R4_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R4_Initial_Entered_Date DateTime? @db.Date
CD1R5_Approved_Date DateTime? @db.Date
CD1R5_Approval_Notes String? @db.VarChar(Max)
CD1R5_Approved_By String? @db.VarChar(250)
CD1R5_CD4_Date_High DateTime? @db.Date
CD1R5_CD4_Date_Low DateTime? @db.Date
CD1R5_TPC_High Float? @db.Money
CD1R5_TPC_Low Float? @db.Money
CD1R5_CD2_Original_Planned_Date DateTime? @db.Date
CD1R5_CD3_Original_Planned_Date DateTime? @db.Date
CD1R5_CD3A_Original_Planned_Date DateTime? @db.Date
CD1R5_Initial_Entered_Date DateTime? @db.Date
CD4A_Approved_Date DateTime? @db.Date
CD4A_Approved_By String? @db.VarChar(250)
CD4A_Approval_Notes String? @db.VarChar(Max)
CD4A_KPP_Scope_Complete String? @db.VarChar(50)
CD4A_Estimated_Final_TPC Float? @db.Money
CD4A_Estimate_to_CD4_Days String? @db.VarChar(3)
CD4A_Estimate_to_CD4_Cost Float? @db.Money
CD4A_Initial_Entered_Date DateTime? @db.Date
CD4A_Modified DateTime? @db.DateTime
CD4A_Modified_By String? @db.VarChar(250)
CD4B_Approved_Date DateTime? @db.Date
CD4B_Approved_By String? @db.VarChar(250)
CD4B_Approval_Notes String? @db.VarChar(Max)
CD4B_KPP_Scope_Complete String? @db.VarChar(50)
CD4B_Estimated_Final_TPC Float? @db.Money
CD4B_Estimate_to_CD4_Days String? @db.VarChar(3)
CD4B_Estimate_to_CD4_Cost Float? @db.Money
CD4B_Initial_Entered_Date DateTime? @db.Date
CD4B_Modified DateTime? @db.DateTime
CD4B_Modified_By String? @db.VarChar(250)
CD4C_Approved_Date DateTime? @db.Date
CD4C_Approved_By String? @db.VarChar(250)
CD4C_Approval_Notes String? @db.VarChar(Max)
CD4C_KPP_Scope_Complete String? @db.VarChar(50)
CD4C_Estimated_Final_TPC Float? @db.Money
CD4C_Estimate_to_CD4_Days String? @db.VarChar(3)
CD4C_Estimate_to_CD4_Cost Float? @db.Money
CD4C_Initial_Entered_Date DateTime? @db.Date
CD4C_Modified DateTime? @db.DateTime
CD4C_Modified_By String? @db.VarChar(250)
CD4D_Approved_Date DateTime? @db.Date
CD4D_Approved_By String? @db.VarChar(250)
CD4D_Approval_Notes String? @db.VarChar(Max)
CD4D_KPP_Scope_Complete String? @db.VarChar(50)
CD4D_Estimated_Final_TPC Float? @db.Money
CD4D_Estimate_to_CD4_Days String? @db.VarChar(3)
CD4D_Estimate_to_CD4_Cost Float? @db.Money
CD4D_Initial_Entered_Date DateTime? @db.Date
CD4D_Modified DateTime? @db.DateTime
CD4D_Modified_By String? @db.VarChar(250)
CD4E_Approved_Date DateTime? @db.Date
CD4E_Approved_By String? @db.VarChar(250)
CD4E_Approval_Notes String? @db.VarChar(Max)
CD4E_KPP_Scope_Complete String? @db.VarChar(50)
CD4E_Estimated_Final_TPC Float? @db.Money
CD4E_Estimate_to_CD4_Days String? @db.VarChar(3)
CD4E_Estimate_to_CD4_Cost Float? @db.Money
CD4E_Initial_Entered_Date DateTime? @db.Date
CD4E_Modified DateTime? @db.DateTime
CD4E_Modified_By String? @db.VarChar(250)
Process_Start_Time DateTime? @db.DateTime
Process_End_Time Int?
Process_Duration_ms Int?
}
model OA_Benchmark {
id_OA_Benchmark Int @id(map: "PK_OA_Benchmark") @default(autoincrement())
PARSID Int
Hazard_Category String? @db.VarChar(100)
Hazard_Category_Source_Type String? @db.VarChar(6)
Hazard_Category_Source String? @db.VarChar(550)
Hazard_Category_Source_Notes String? @db.VarChar(550)
Gross_Square_Feet Int?
Gross_Square_Feet_Source_Type String? @db.VarChar(6)
Gross_Square_Feet_Source String? @db.VarChar(550)
Gross_Square_Feet_Source_Notes String? @db.VarChar(550)
Useable_Square_Feet Int?
Useable_Square_Feet_Source_Type String? @db.VarChar(6)
Useable_Square_Feet_Source String? @db.VarChar(550)
Useable_Square_Feet_Source_Notes String? @db.VarChar(550)
Equipment_Cost Float? @db.Money
Equipment_Cost_Source_Type String? @db.VarChar(6)
Equipment_Cost_Source String? @db.VarChar(550)
Equipment_Cost_Source_Notes String? @db.VarChar(550)
Gloveboxes Int?
Gloveboxes_Source_Type String? @db.VarChar(6)
Gloveboxes_Source String? @db.VarChar(550)
Gloveboxes_Source_Notes String? @db.VarChar(550)
Glovebox_Unit_Cost Float? @db.Money
Glovebox_Unit_Cost_Source_Type String? @db.VarChar(6)
Glovebox_Unit_Cost_Source String? @db.VarChar(550)
Glovebox_Unit_Cost_Source_Notes String? @db.VarChar(550)
Notes String? @db.VarChar(2000)
Modified_by String @db.VarChar(250)
Modified DateTime @db.DateTime
}
model OA_Benchmark_FIMS {
id_OA_Benchmark_FIMS Int @id(map: "PK_OA_Benchmark_FIMS") @default(autoincrement())
PARSID Int
FIMS_ID Int
Square_Feet Int?
Modified_by String @db.VarChar(250)
Modified DateTime @db.DateTime
}
model Prev_Project_ESAAB_Assessments {
PrevESAABID Int @id(map: "PK_Prev_Project_ESAAB_Assessments") @default(autoincrement())
ID Int?
ESAABID Int?
PARSID Int
Assessment_Status String? @db.VarChar(10)
Status_Date DateTime @db.Date
ESAAB_Narrative String? @db.VarChar(Max)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
ESAAB_Narrative_contentState String? @db.VarChar(Max)
}
model Prev_Project_FPD_Assessments {
PrevFPDID Int @id(map: "PK_Prev_Project_FPD_Assessment") @default(autoincrement())
ID Int?
FPDID Int?
PARSID Int
Assessment_Status String? @db.VarChar(10)
Forecast_Completion DateTime? @db.Date
Forecast_for_TPC Float? @db.Money
Narrative String? @db.NVarChar(Max)
RYG_Overall String? @db.VarChar(10)
Status_Date DateTime @db.Date
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
NonHtml_Narrative String? @db.VarChar(Max)
Narrative_contentState String? @db.VarChar(Max)
}
model Prev_Project_PMOA_Assessments {
PrevPMOAID Int @id(map: "PK_Prev_Project_PMOA_Assessment") @default(autoincrement())
ID Int?
PMOAID Int?
PARSID Int
Assessment_Status String? @db.VarChar(10)
Forecast_Status String? @db.VarChar(15)
Adjusted_Percent_Complete Float?
Adjusted_Percent_Spent Float?
Forecast_Completion DateTime? @db.Date
Forecast_for_TPC Float? @db.Money
Cost_Narrative String? @db.NVarChar(Max)
Schedule_Narrative String? @db.NVarChar(Max)
Scope_Narrative String? @db.NVarChar(Max)
Overall_Narrative String? @db.NVarChar(Max)
RYG_Overall String? @db.VarChar(10)
RYG_Cost String? @db.VarChar(10)
RYG_Schedule String? @db.VarChar(10)
RYG_Scope String? @db.VarChar(10)
Status_Date DateTime @db.Date
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
NonHtml_Cost_Narrative String? @db.VarChar(Max)
NonHtml_Schedule_Narrative String? @db.VarChar(Max)
NonHtml_Scope_Narrative String? @db.VarChar(Max)
NonHtml_Overall_Narrative String? @db.VarChar(Max)
Cost_Narrative_contentState String? @db.VarChar(Max)
Schedule_Narrative_contentState String? @db.VarChar(Max)
Scope_Narrative_contentState String? @db.VarChar(Max)
Overall_Narrative_contentState String? @db.VarChar(Max)
}
model Prev_Project_Program_Assessments {
PrevProgramID Int @id(map: "PK_Prev_Project_Program_Assessment") @default(autoincrement())
ID Int?
ProgramID Int?
PARSID Int
Assessment_Status String? @db.VarChar(10)
Forecast_Completion DateTime? @db.Date
Forecast_for_TPC Float? @db.Money
Narrative String? @db.NVarChar(Max)
RYG_Overall String? @db.VarChar(10)
Status_Date DateTime @db.Date
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
NonHtml_Narrative String? @db.VarChar(Max)
Narrative_contentState String? @db.VarChar(Max)
}
model Project_Balance_Of_Projects {
ID Int @id(map: "PK_Project_Balance_Of_Projects") @default(autoincrement())
PARSID Int
bop_PARSID_parent Int
first_record_bop_PARSID_parent String @db.VarChar(3)
User_Name String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Type String? @db.VarChar(50)
Project_Name String? @db.VarChar(200)
Credit Float? @db.Money
Debit Float? @db.Money
Notes String? @db.VarChar(Max)
Notes_contentState String? @db.VarChar(Max)
NonHtml_Notes String? @db.VarChar(Max)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
}
model Project_Fee {
ID Int @id(map: "PK_Project_Fee") @default(autoincrement())
FeeID Int
PARSID Int
Fee_Transaction_Type String @db.VarChar(50)
Cost_Type String? @db.VarChar(50)
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Credit Float? @db.Money
Debit Float? @db.Money
Reference String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Narrative String? @db.VarChar(Max)
Transaction_Title String? @db.VarChar(250)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
Transaction_Narrative_contentState String? @db.VarChar(Max)
NonHtml_Transaction_Narrative String? @db.VarChar(Max)
}
model Project_Fee_Awarded {
ID Int @id(map: "PK_Project_Profit_Fee_Awarded") @default(autoincrement())
PARSID Int
Fee_Awarded_Transaction_Type String @db.VarChar(50)
Cost_Type String? @db.VarChar(50)
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Credit Float? @db.Money
Debit Float? @db.Money
Reference String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Narrative String? @db.VarChar(Max)
Transaction_Title String? @db.VarChar(250)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
Transaction_Narrative_contentState String? @db.VarChar(Max)
NonHtml_Transaction_Narrative String? @db.VarChar(Max)
}
model Project_Management_Reserve {
ID Int @id(map: "PK_Project_Management_Reserve") @default(autoincrement())
ManagementReserveID Int
PARSID Int
Cost_Contingency_Transaction_Type String? @db.VarChar(50)
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Initial_Deposit Float? @db.Money
Credit Float? @db.Money
Debit Float? @db.Money
Reference String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Narrative String? @db.VarChar(Max)
Title String? @db.VarChar(250)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
}
model Project_On_Hold {
ID Int @id(map: "PK_Project_On_Hold") @default(autoincrement())
OnHoldID Int
PARSID Int
Approved_By String @db.VarChar(250)
Approved_Date DateTime @db.Date
Date_Certified DateTime @db.Date
Date_Reactivated DateTime? @db.Date
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Modified DateTime @db.DateTime
Modified_By String @db.VarChar(250)
}
model Project_Other_Direct_Cost {
ID Int @id(map: "PK_Project_ODC") @default(autoincrement())
ODCID Int
PARSID Int
ODC_Transaction_Type String @db.VarChar(50)
Cost_Type String? @db.VarChar(50)
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Credit Float? @db.Money
Debit Float? @db.Money
Reference String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Narrative String? @db.VarChar(Max)
Transaction_Title String? @db.VarChar(250)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
Transaction_Narrative_contentState String? @db.VarChar(Max)
NonHtml_Transaction_Narrative String? @db.VarChar(Max)
}
model Project_Schedule_Contingency {
ID Int @id(map: "PK_Project_Schedule_Contingency") @default(autoincrement())
ScheduleContingencyID Int
PARSID Int
Schedule_Contingency_Transaction_Type String @db.VarChar(50)
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Credit Float? @db.Money
Debit Float? @db.Money
Reference String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Narrative String? @db.VarChar(Max)
Transaction_Title String? @db.VarChar(250)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
Transaction_Narrative_contentState String? @db.VarChar(Max)
NonHtml_Transaction_Narrative String? @db.VarChar(Max)
}
model Project_TBN_Other {
ID Int @id(map: "PK_Project_TBN_Other") @default(autoincrement())
PARSID Int
TBN_Other_Transaction_Type String @db.VarChar(50)
Cost_Type String? @db.VarChar(50)
Created DateTime @db.Date
Created_By String @db.VarChar(250)
Credit Float? @db.Money
Debit Float? @db.Money
EAC_Adjustment Float? @db.Money
Reference String? @db.VarChar(250)
Transaction_Date DateTime? @db.Date
Transaction_Narrative String? @db.VarChar(Max)
Transaction_Title String? @db.VarChar(250)
Modified DateTime? @db.DateTime
Modified_By String? @db.VarChar(250)
Transaction_Narrative_contentState String? @db.VarChar(Max)
NonHtml_Transaction_Narrative String? @db.VarChar(Max)
}