| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWork Clearance Management |
1 | WCAAP | WCM: Application | 7 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
2 | WCAHE | WCM: Work Clearance Document (Header) | 7 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
3 | WCAIT | WCM: Work Clearance Document (Item) | 33 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
4 | WCAJ | WCM: Lineup | 19 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
5 | WCAK | WCM: Verification List (Header Data) | 6 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
6 | WCAME | WCM: (Temporary) Log of Operational Lists (Items) | 35 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
7 | WCAMI | WCM: Log of Operational Lists (Items) | 35 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
8 | WCAQ | WCM: Verification List (Items) | 15 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |
9 | WCAW | WCM: Work Approval | 6 | LFLG | Long Text Exists | nvarchar | 1 | 0 | | |