| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPersonnel Time Management |
1 | T554R | Day Rules for Absence Valuation | 9 | TGTYP | Eligibility string for day type on current day | nvarchar | 10 | 0 | | |
2 | T554X | Rules for Attendance/Absence Counting and Leave Deduction | 10 | TGTYP | Permissibility string for day type | nvarchar | 10 | 0 | | |
TOPWork Clearance Management |
3 | WCACH | WCM: (Temporary) Log for Tagging/Untagging (Time-Frame) | 7 | TGTYP | Operational Type | nvarchar | 3 | 0 | | |
4 | WCACI | WCM: (Temporary) Log for Tagging/Untagging (Conflict Check) | 12 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |
5 | WCACQ | WCM: Log for Tagging/Untagging (Conflict Check) | 13 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |
6 | WCAIT | WCM: Work Clearance Document (Item) | 15 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |
7 | WCAME | WCM: (Temporary) Log of Operational Lists (Items) | 17 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |
8 | WCAMI | WCM: Log of Operational Lists (Items) | 17 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |
9 | WCCA | WCM: Switching Data | 5 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |
10 | WCCC | WCM: Operational Type | 2 | TGTYP | Operational Type | nvarchar | 3 | 0 | | |
11 | WCCCT | WCM: Operational Type (Texts) | 2 | TGTYP | Operational Type | nvarchar | 3 | 0 | | |
12 | WCCI | WCM: Tag <-> (Operational Group, Operational Type; Test Tag) | 5 | TGTYP | Tagging Type | nvarchar | 3 | 0 | | |