| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollateral Management System |
1 | TCMS_ATT_ID_CT | Attribute Indicator category | 1 | INDICATOR_ID | Attribute Indicator ID | nvarchar | 6 | 0 | | |
2 | TCMS_ATT_ID_CT_T | Attribute Indicator category -text table | 1 | INDICATOR_ID | Attribute Indicator ID | nvarchar | 6 | 0 | | |
3 | TCMS_ATT_ID_TY | Attribute Indicator type | 2 | INDICATOR_ID | Attribute Indicator ID | nvarchar | 6 | 0 | | |
4 | TCMS_ATT_ID_TY_T | Attribute Indicator type - Text Table | 2 | INDICATOR_ID | Attribute Indicator ID | nvarchar | 6 | 0 | | |
TOPReal Estate |
5 | TCMS_OMS_ID_CT | Attribute Indicator category | 1 | INDICATOR_ID | Attribute indicator ID | nvarchar | 6 | 0 | | |
6 | TCMS_OMS_ID_CT_T | Attribute Indicator category - Text table | 1 | INDICATOR_ID | Attribute indicator ID | nvarchar | 6 | 0 | | |
7 | TCMS_OMS_ID_TY | Attribute Indicator type | 2 | INDICATOR_ID | Attribute indicator ID | nvarchar | 6 | 0 | | |
8 | TCMS_OMS_ID_TY_T | Attribute Indicator type - Text Table | 2 | INDICATOR_ID | Attribute indicator ID | nvarchar | 6 | 0 | | |
TOPWorkforce Management Application |
9 | WFAFC_GRP_IND_MP | Indicator Group/ Indicator Mapping | 4 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
10 | WFAFC_INDCATOR | Indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
11 | WFAFC_INDCATOR_T | Indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
12 | WFAFC_IND_ATTRIB | Indicator Attributes | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
13 | WFAFC_IND_RELATE | Indicator Related | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
14 | WFAFC_IND_TDATA | Time relative data associated with an indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
15 | WFAFC_LINK | Link between Step and Indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
16 | WFAFC_NETIND_MAP | Net Indicator Configuration | 3 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
17 | WFAFC_OBJ_STAT | Object Stat for Configuration | 7 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
18 | WFAFC_STAT | Stat | 4 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
19 | WFA_WORK_LOAD | Workload Attributes | 10 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
TOPWorkforce Management Core |
20 | WFMCAS_WORK_LOAD | Workload Attributes | 10 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
21 | WFMFC_GRP_IND_MP | Indicator Group/ Indicator Mapping | 4 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
22 | WFMFC_INDCATOR | Indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
23 | WFMFC_INDCATOR_T | Indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
24 | WFMFC_IND_ATTRIB | Indicator Attributes | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
25 | WFMFC_IND_RELATE | Indicator Related | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
26 | WFMFC_LINK | Link between Step and Indicator | 2 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
27 | WFMFC_OBJ_STAT | Object Stat for Configuration | 7 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |
28 | WFMFC_STAT | Stat | 4 | INDICATOR_ID | Indicator Id | nvarchar | 32 | 0 | | |