| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPWork Clearance Management |
1 | WCACH | WCM: (Temporary) Log for Tagging/Untagging (Time-Frame) | 9 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
2 | WCACI | WCM: (Temporary) Log for Tagging/Untagging (Conflict Check) | 4 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
3 | WCACN | WCM: (Temporary) Log (Tag/Test Tag) | 11 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
4 | WCACNQ | WCM: Log (Operational Tag) | 12 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
5 | WCACO | WCM: (Temporary) Log for Tagging/Untagging (Ref. Object) | 4 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
6 | WCACQ | WCM: Log for Tagging/Untagging (Conflict Check) | 5 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
7 | WCAF | WCM: Order Operation <-> Work Clearance Document | 4 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
8 | WCAFQ | WCM: Log (Order Operation <-> Work Clearance Document) | 4 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
9 | WCAHE | WCM: Work Clearance Document (Header) | 2 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
10 | WCAIT | WCM: Work Clearance Document (Item) | 2 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
11 | WCAMC | WCM: Log of Operational Lists (Header Data) | 2 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
12 | WCAME | WCM: (Temporary) Log of Operational Lists (Items) | 2 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
13 | WCAMI | WCM: Log of Operational Lists (Items) | 2 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |
14 | WCAR | WCM: Operational Step | 3 | WCNR | Work Clearance Document | nvarchar | 12 | 0 | | |