| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ITTS_PERRES | Personnel Responsible in TTS | 5 | QUAL_ID | TTS Authorization | nvarchar | 4 | 0 | | |
2 | ITTS_REST | Personnel Responsible Description in TTS | 2 | QUAL_ID | TTS Authorization | nvarchar | 4 | 0 | | |
3 | TTS_PERRES | TTS Approver Authorizations | 6 | QUAL_ID | TTS Authorization | nvarchar | 4 | 0 | | |
4 | TTS_QUAL | TTS Authorization Master Data | 2 | QUAL_ID | TTS Authorization | nvarchar | 4 | 0 | | |
5 | TTS_QUALT | Personnel qualification in TTS(Texts) | 2 | QUAL_ID | TTS Authorization | nvarchar | 4 | 0 | | |
6 | TTS_QUAL_FCTRL | TTS Screen Fields Control for Authorizations | 3 | QUAL_ID | TTS Authorization | nvarchar | 4 | 0 | | |
TOPDocument Management Framework |
7 | SKWF_QUAL | KW Framework: Query Settings | 3 | QUAL_ID | KPro: General counter (uniqueness in DB) | nvarchar | 5 | 0 | | |
TOPWorkforce Management Application |
8 | WFA_CORE_SCHE | Core Scheduling | 12 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |
9 | WFA_SCEVT_QUL | Schedule Event - Qualifications Relationship | 5 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |
10 | WFA_WORK_LOAD | Workload Attributes | 7 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |
TOPWorkforce Management Core |
11 | WFMCAS_CORE_SCHE | Core Scheduling | 12 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |
12 | WFMCAS_SCEVT_QUL | Schedule Event - Qualifications Relationship | 5 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |
13 | WFMCAS_WORK_LOAD | Workload Attributes | 7 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |
14 | WFMCAS_WRK_COVER | Work Coverage Rule - OBSOLETE | 10 | QUAL_ID | Object ID | nvarchar | 8 | 0 | | |