| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAuthentication and SSO |
1 | USR01 | User master record (runtime data) | 3 | STCOD | Start menu (old, replaced by XUSTART) | nvarchar | 20 | 0 | | |
TOPDenmark |
2 | T5M16 | Official DA Statistics - Job Keys (DK) | 2 | STCOD | Official DA job key (DK) | nvarchar | 6 | 0 | | |
3 | T5M17 | DA Statistics - Job Descriptions (DK) | 3 | STCOD | Official DA job key (DK) | nvarchar | 6 | 0 | | |
4 | T5M8U | Hierarchy Structure for DA Statistics Job Key | 1 | STCOD | Official DA job key (DK) | nvarchar | 6 | 0 | | |
5 | T5M8V | Hierarchy Structure Texts for DA Statistics Job Key | 2 | STCOD | Official DA job key (DK) | nvarchar | 6 | 0 | | |
6 | T5M9K | Hierarchy Structure for DA Statistics Job Key | 2 | STCOD | Official DA job key (DK) | nvarchar | 6 | 0 | | |
7 | T5M9L | Hierarchy Structure Texts for DA Statistics Job Key | 3 | STCOD | Official DA job key (DK) | nvarchar | 6 | 0 | | |
8 | T5M9M | Hierarchy Structure for DS Statistics Training Key | 2 | STCOD | Official DA training key (DK) | nvarchar | 6 | 0 | | |
9 | T5M9N | Hierarchy Structure Texts for DS Statistics Work Center Key | 3 | STCOD | Official DA training key (DK) | nvarchar | 6 | 0 | | |
TOPMalaysia |
10 | T5LSC | Table to maintain state codes for EPF download formats | 3 | STCOD | State codes for internet download formats | nvarchar | 2 | 0 | | |