| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/D_TOBJEC | Technical Object | 6 | EXTERNAL_KEY | Technical Object External Key | nvarchar | 60 | 0 | | |
2 | GRACMITMSMPVALI | Mitigation Assignment Workflow Validation | 9 | EXTERNAL_KEY | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
3 | GRFNMWRTINST | MSMP Runtime - Instance Header Info | 4 | EXTERNAL_KEY | External Key | nvarchar | 50 | 0 | | |
4 | GRFNMWRTINSTWI | MSMP Runtime - Work Item execution context cache | 7 | EXTERNAL_KEY | External Key | nvarchar | 50 | 0 | | |
5 | N1MCI_MSG | Message Log | 10 | EXTERNAL_KEY | External Key of a Message | nvarchar | 50 | 0 | | |
6 | N1TPI_ELINK | Assignment of Object to External Key | 6 | EXTERNAL_KEY | External Key of a Message | nvarchar | 50 | 0 | | |
7 | N1TPI_HISTORY | Management Message Date for External Key and Object Type | 3 | EXTERNAL_KEY | External Key of a Message | nvarchar | 50 | 0 | | |
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector |
8 | SATC_RT_RUN | Movement data (runtime repository) - Header | 15 | EXTERNAL_KEY | External key - Of no particular meaning to ATC itself | nvarchar | 8 | 0 | | |
TOPProduct Lifecycle Management |
9 | ACO_ADMIN_OTYPE | Object Categories with Authorization Assignment by Sys. Adm. | 3 | EXTERNAL_KEY | Search Help Parameter That Displays the External Key | nvarchar | 30 | 0 | | |
TOPSearch |
10 | /PLMB/SEA_QUERY | Search query head | 3 | EXTERNAL_KEY | Search Query | nvarchar | 22 | 0 | | |
TOPWorkforce Management Application |
11 | WFAC_COSTN | Costs: External key | 2 | EXTERNAL_KEY | Schedule Priority ID | nvarchar | 20 | 0 | | |
12 | WFAC_COSTN_D | Costs | 3 | EXTERNAL_KEY | Schedule Priority ID | nvarchar | 20 | 0 | | |
13 | WFAC_COSTN_T | Costs: External Key Text | 2 | EXTERNAL_KEY | Schedule Priority ID | nvarchar | 20 | 0 | | |
14 | WFAC_DAYSHIFTN | Day Shift Definition | 4 | EXTERNAL_KEY | Week Breaker ID | nvarchar | 20 | 0 | | |
15 | WFAC_DAYSHIFTN_T | Week/day breaker: External Key Text | 2 | EXTERNAL_KEY | Week Breaker ID | nvarchar | 20 | 0 | | |
16 | WFAC_LOCSETTN | General Location Settings | 3 | EXTERNAL_KEY | External Key for General Location Settings | nvarchar | 20 | 0 | | |
17 | WFAC_LOCSETTN_T | Gen. Location Settings Translation Table | 2 | EXTERNAL_KEY | External Key for General Location Settings | nvarchar | 20 | 0 | | |
18 | WFAC_SCHDEXCPN | Schedule Exceptions: External key | 2 | EXTERNAL_KEY | Schedule Exceptions ID | nvarchar | 20 | 0 | | |
19 | WFAC_SCHDEXCPN_D | Schedule Exceptions | 3 | EXTERNAL_KEY | Schedule Exceptions ID | nvarchar | 20 | 0 | | |
20 | WFAC_SCHDEXCPN_T | Schedule Exceptions: External Key Text | 2 | EXTERNAL_KEY | Schedule Exceptions ID | nvarchar | 20 | 0 | | |
21 | WFAC_SNPRFN | Seniority Date Profile | 4 | EXTERNAL_KEY | Seniority Date Preference ID | nvarchar | 20 | 0 | | |
22 | WFAC_SNPRFN_T | Seniority Date Profile: External Key Text | 2 | EXTERNAL_KEY | Seniority Date Preference ID | nvarchar | 20 | 0 | | |
23 | WFAC_WKNDDAYSN | Weekend Days | 4 | EXTERNAL_KEY | Weekend Days ID | nvarchar | 20 | 0 | | |
24 | WFAC_WKNDDAYSN_T | Weekend Days: External Key Text | 2 | EXTERNAL_KEY | Weekend Days ID | nvarchar | 20 | 0 | | |
25 | WFAC_WKRLDFLTN | Default work rules : External key | 2 | EXTERNAL_KEY | Default Work Rule ID | nvarchar | 20 | 0 | | |
26 | WFAC_WKRLDFLTN_D | Work Rules Default | 3 | EXTERNAL_KEY | Default Work Rule ID | nvarchar | 20 | 0 | | |
27 | WFAC_WKRLDFLTN_T | Default work rules: External Key Text | 2 | EXTERNAL_KEY | Default Work Rule ID | nvarchar | 20 | 0 | | |
28 | WFAC_WKRLINTVN_D | Work Rule Interval | 3 | EXTERNAL_KEY | Default Work Rule ID | nvarchar | 20 | 0 | | |
29 | WFAC_WRD_MAXPERI | Period Rule Type | 3 | EXTERNAL_KEY | Default Work Rule ID | nvarchar | 20 | 0 | | |
30 | WFAC_WRD_RESTPER | Maximum Type for a Period | 3 | EXTERNAL_KEY | Default Work Rule ID | nvarchar | 20 | 0 | | |
31 | WFAFC_BUDGET_SET | Budget constraint | 2 | EXTERNAL_KEY | Budget constraint | nvarchar | 20 | 0 | | |
32 | WFAFC_FCSTCFGN | Forecasting Configuration Parameters for Location Profile | 4 | EXTERNAL_KEY | External key for forecast parameter | nvarchar | 20 | 0 | | |
33 | WFAFC_FCSTCFGN_T | Seniority Date Profile: External Key Text | 2 | EXTERNAL_KEY | External key for forecast parameter | nvarchar | 20 | 0 | | |
TOPWorkforce Management Core |
34 | WFD_ATS_000 | General Attribute Set data | 4 | EXTERNAL_KEY | External Key | nvarchar | 32 | 0 | | |
35 | WFMC_COSTN | Costs: External key | 2 | EXTERNAL_KEY | Schedule Priority ID | nvarchar | 20 | 0 | | |
36 | WFMC_COSTN_D | Costs | 3 | EXTERNAL_KEY | Schedule Priority ID | nvarchar | 20 | 0 | | |
37 | WFMC_COSTN_T | Costs: External Key Text | 2 | EXTERNAL_KEY | Schedule Priority ID | nvarchar | 20 | 0 | | |
38 | WFMC_DAYSHIFTN | Day Shift Definition | 4 | EXTERNAL_KEY | Week Breaker ID | nvarchar | 20 | 0 | | |
39 | WFMC_DAYSHIFTN_T | Week/day breaker: External Key Text | 2 | EXTERNAL_KEY | Week Breaker ID | nvarchar | 20 | 0 | | |
40 | WFMC_LOCSETTN | General Location Settings | 3 | EXTERNAL_KEY | External Key for General Location Settings | nvarchar | 20 | 0 | | |
41 | WFMC_LOCSETTN_T | Gen. Location Settings Translation Table | 2 | EXTERNAL_KEY | External Key for General Location Settings | nvarchar | 20 | 0 | | |
42 | WFMC_SCHDEXCPN | Schedule Exceptions: External key | 2 | EXTERNAL_KEY | Schedule Exceptions ID | nvarchar | 20 | 0 | | |
43 | WFMC_SCHDEXCPN_D | Schedule Exceptions | 3 | EXTERNAL_KEY | Schedule Exceptions ID | nvarchar | 20 | 0 | | |
44 | WFMC_SCHDEXCPN_T | Schedule Exceptions: External Key Text | 2 | EXTERNAL_KEY | Schedule Exceptions ID | nvarchar | 20 | 0 | | |
45 | WFMC_SNPRFN | Seniority Date Profile | 4 | EXTERNAL_KEY | Seniority Date Preference ID | nvarchar | 20 | 0 | | |
46 | WFMC_SNPRFN_T | Seniority Date Profile: External Key Text | 2 | EXTERNAL_KEY | Seniority Date Preference ID | nvarchar | 20 | 0 | | |
47 | WFMC_WKNDDAYSN | Weekend Days | 4 | EXTERNAL_KEY | Weekend Days ID | nvarchar | 20 | 0 | | |
48 | WFMC_WKNDDAYSN_T | Weekend Days: External Key Text | 2 | EXTERNAL_KEY | Weekend Days ID | nvarchar | 20 | 0 | | |
49 | WFMC_WKRLDFLTN | Default work rules : External key | 2 | EXTERNAL_KEY | External key for default work rules | nvarchar | 20 | 0 | | |
50 | WFMC_WKRLDFLTN_D | Work Rules Default | 3 | EXTERNAL_KEY | External key for default work rules | nvarchar | 20 | 0 | | |
51 | WFMC_WKRLDFLTN_T | Default work rules: External Key Text | 2 | EXTERNAL_KEY | External key for default work rules | nvarchar | 20 | 0 | | |
52 | WFMC_WKRLINTVN_D | Work Rule Interval | 3 | EXTERNAL_KEY | External key for default work rules | nvarchar | 20 | 0 | | |
53 | WFMFC_BUDGET_SET | Budget constraint | 2 | EXTERNAL_KEY | Budget constraint | nvarchar | 20 | 0 | | |
54 | WFMFC_FCSTCFGN | Forecasting Configuration Parameters for Location Profile | 4 | EXTERNAL_KEY | External key for forecast parameter | nvarchar | 20 | 0 | | |
55 | WFMFC_FCSTCFGN_T | Seniority Date Profile: External Key Text | 2 | EXTERNAL_KEY | External key for forecast parameter | nvarchar | 20 | 0 | | |