vr_CpElement

Field NameField DescriptionData TypeFK Join
ActiveIndicates if the Record is Active or Notbit 
CodeUniFormat Codenvarchar 
CpElement1CodeUniFormat Level 1 Codenvarchar 
CpElement1DescriptionUniFormat Level 1 Descriptionnvarchar 
CpElement1IdUniFormat Level 1 Idintvr_cpElement
CpElement2CodeUniFormat Level 2 Codenvarchar 
CpElement2DescriptionUniFormat Level 2 Descriptionnvarchar 
CpElement2IdUniFormat Level 2 Idintvr_cpElement
CpElement3CodeUniFormat Level 3 Codenvarchar 
CpElement3DescriptionUniFormat Level 3 Descriptionnvarchar 
CpElement3IdUniFormat Level 3 Idintvr_cpElement
CreatedDateRecord Creation Datedatetime 
CreatorIdUser Id (Record Creator)intvr_users
DescriptionUniFormat Descriptionnvarchar 
HasChildrenIndicates if the UniFormat Level Has Children (i.e. UniFormat Level 2 would have UniFormat Level 3 Tied to it)bit 
IdUniFormat Idint 
LevelUniFormat Level Value (I.e. 2)int 
LevelDescriptionUniFormat Level Descriptionnvarchar 
ModifiedDateLast Modified Datedatetime 
ModifierIdUser Id (Record Modifier)intvr_users
ParentIdUniFormat Parent Idintvr_cpElement
SourceIdSource Idint 
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Announcing WebTMA + Workday Integration
To Learn More, Click Here!
2026 Webinar Training Schedule - Register now!
See the full list of web training events.
TMA Systems - TMA Connect 2026 Registration
Register Now by clicking here!