| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5PPBS3B | Assignment/competency for Jobs objects | 3 | ACTYPE | Attribution/competency type/activity | nvarchar | 1 | 0 | | |
2 | T5PPBS3BT | Assignment/competency for Jobs objects text table | 4 | ACTYPE | Attribution/competency type/activity | nvarchar | 1 | 0 | | |
TOPCanada |
3 | T5KB1 | Definition of Business Number, Canada | 4 | ACTYPE | Business Number account type | nvarchar | 2 | 0 | | |
4 | T5KB2 | Canadian tax reporting units | 4 | ACTYPE | Business Number account type | nvarchar | 2 | 0 | | |
TOPIndustrial Hygiene and Safety |
5 | CCIHC_AC01 | EHS: Safety Measure Types | 2 | ACTYPE | Safety Measure Type | nvarchar | 4 | 0 | | |
6 | CCIHC_AC02 | EHS: Safety Measure Type - Language-Dependent Name | 3 | ACTYPE | Safety Measure Type | nvarchar | 4 | 0 | | |
7 | CCIHC_AC09 | EHS: Safety Measure Category-Safety Measure Type Assignment | 3 | ACTYPE | Safety Measure Type | nvarchar | 4 | 0 | | |
8 | CCIHT_ACH | EHS: Safety Measures - Header | 21 | ACTYPE | Safety Measure Type | nvarchar | 4 | 0 | | |
TOPWaste Management |
9 | EHSWAC_EAFOFCAT | Functions per Document Category in Disposal Processing | 3 | ACTYPE | Activity | nvarchar | 2 | 0 | | |