| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Record is Active or Not | bit | |
| Code | UniFormat Code | nvarchar | |
| CpElement1Code | UniFormat Level 1 Code | nvarchar | |
| CpElement1Description | UniFormat Level 1 Description | nvarchar | |
| CpElement1Id | UniFormat Level 1 Id | int | vr_cpElement |
| CpElement2Code | UniFormat Level 2 Code | nvarchar | |
| CpElement2Description | UniFormat Level 2 Description | nvarchar | |
| CpElement2Id | UniFormat Level 2 Id | int | vr_cpElement |
| CpElement3Code | UniFormat Level 3 Code | nvarchar | |
| CpElement3Description | UniFormat Level 3 Description | nvarchar | |
| CpElement3Id | UniFormat Level 3 Id | int | vr_cpElement |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| Description | UniFormat Description | nvarchar | |
| HasChildren | Indicates if the UniFormat Level Has Children (i.e. UniFormat Level 2 would have UniFormat Level 3 Tied to it) | bit | |
| Id | UniFormat Id | int | |
| Level | UniFormat Level Value (I.e. 2) | int | |
| LevelDescription | UniFormat Level Description | nvarchar | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| ParentId | UniFormat Parent Id | int | vr_cpElement |
| SourceId | Source Id | int |