| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| bi_elm_fk | Capital Planning Element Id | int | vr_cpElement |
| bi_fd_fk | Facility Id | int | vr_Facility |
| bi_number | Work Element Number | int | |
| bi_title | Work Element Title | nvarchar | |
| bi_wet_fk | Work Element Type Id | int | |
| cgrpbi_bi_fk | Work Element Id | int | vr_CPWorkElement |
| cgrpbi_cgrp_fk | Capital Planning Group Id | int | |
| cgrpbi_clnt_fk | Obsolete Column (No Longer Used) | int | |
| cgrpbi_createdDate | Record Creation Date | datetime | |
| cgrpbi_creator_fk | User Id (Record Creator) | int | vr_users |
| cgrpbi_modifiedDate | Last Modified Date | datetime | |
| cgrpbi_modifier_fk | User Id (Record Modifier) | int | vr_users |
| cps_code | Capital Planning Setup Code | nvarchar | |
| cps_description | Capital Planning Setup Description | nvarchar | |
| elm_code | Capital Planning Element Code | nvarchar | |
| fd_name | Facility Name | nvarchar | |
| Id | Work Element Id | int | vr_CPWorkElement |
| wet_description | Work Element Type Description | nvarchar |