| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DMC_DW_FORMALP | Formal Parameters for Dynamic WHERE Clauses | 2 | TEMPLATE_KEY | DMC: Globally Unique Key (22 Characters) | nvarchar | 22 | 0 | | |
2 | DMC_DW_TEMPLATE | Dynamic WHERE Clause Templates | 1 | TEMPLATE_KEY | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | | |
3 | DMC_DW_TEMPLATET | WHERE Clause Template Description | 1 | TEMPLATE_KEY | DMC: Globally Unique Key (22 Characters) | nvarchar | 22 | 0 | | |
TOPNetwork and Activity |
4 | TCN41 | Network Defaults | 76 | TEMPLATE_KEY | Standard text key | nvarchar | 7 | 0 | | |
TOPOperative Structures |
5 | TCJ41 | Default Values for Work Breakdown Structure | 99 | TEMPLATE_KEY | Standard text key | nvarchar | 7 | 0 | | |
TOPStructures |
6 | CNLDST_SHORTTX | Table of Language-Dependent Short Texts | 9 | TEMPLATE_KEY | Standard text key | nvarchar | 7 | 0 | | |
TOPWorkforce Management Core |
7 | WFDBPC_RULE | WFD Template rules | 2 | TEMPLATE_KEY | Availability Template Key | nvarchar | 12 | 0 | | |
8 | WFDBPC_RULE_T | WFD Template rules description | 2 | TEMPLATE_KEY | Availability Template Key | nvarchar | 12 | 0 | | |
9 | WFDBPC_TEMPL | Availability template | 2 | TEMPLATE_KEY | Availability Template Key | nvarchar | 12 | 0 | | |
10 | WFDBPC_TEMPLT | Availability template description | 2 | TEMPLATE_KEY | Availability Template Key | nvarchar | 12 | 0 | | |
11 | WFD_ATS_050 | Availability template link | 4 | TEMPLATE_KEY | Availability Template Key | nvarchar | 12 | 0 | | |