| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| biFormula_code | Work Element Risk Formula Code | nvarchar | |
| biFormula_description | Work Element Risk Formula Description | nvarchar | |
| biFormula_pk | Work Element Risk Formula Id | int | |
| cfgFormula_code | Capital Planning Project Request Formula Code | nvarchar | |
| cfgFormula_description | Capital Planning Project Request Formula Description | nvarchar | |
| cfgFormula_pk | Capital Planning Project Request Formula Id | int | |
| cps_advanceBudgetYear | Advance Budget Year | bit | |
| cps_averageInflation | Average Inflation | decimal | |
| cps_bi_formula_fk | Work Element Risk Formula Id | int | |
| cps_budgetMidPoint | Budget Mid Point | datetime | |
| cps_budgetYear | Budget Year | int | |
| cps_cfg_formula_fk | Capital Planning Project Request Formula Id | int | |
| cps_code | Setup Code | nvarchar | |
| cps_createdDate | Record Creation Date | datetime | |
| cps_creator_fk | User Id (Record Creator) | int | vr_users |
| cps_defaultInflationRate | Default Inflation Rate | decimal | |
| cps_description | Setup Description | nvarchar | |
| cps_goal | Goal | decimal | |
| cps_lastBudgetYear | Last Budget Year | int | |
| cps_modifiedDate | Last Modified Date | datetime | |
| cps_modifier_fk | User Id (Record Modifier) | int | vr_users |
| cps_month | Month | int | |
| cps_nextBudgetYear | Next Budget Year | int | |
| cps_pk | Capital Planning Setup Id | int | |
| cps_projectNumberPrefix | Project Number Prefix | nvarchar | |
| cps_projectNumberStartingPoint | Project Number Starting Point | int | |
| cps_projectNumberSuffix | Project Number Suffix | nvarchar | |
| cps_pt_fk | Project Type Id | int | vr_ProjectType |
| cps_rc_fk | Repair Center Id | int | vr_RepairCenter |
| cps_tenYear | Ten year | int | |
| cps_yearSpan | Year Span | int | |
| Id | Capital Planning Setup Id | int | |
| pt_code | Project Type Code | nvarchar | |
| pt_description | Project Type Description | nvarchar | |
| pt_pk | Project Type Id | int | vr_ProjectType |
| rc_code | Repair Center Code | nvarchar | |
| rc_name | Repair Center Name | nvarchar | |
| rc_pk | Repair Center Id | int | vr_RepairCenter |