| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /AIF/MSG_SNAP_HD | Message statistics: snapshot header | 6 | EFFECTIVE_DATE | Date for Which Daily Snapshot Data Is Valid | nvarchar | 8 | 0 | | |
| 2 | /SAPPSSRM/MQ_DOC | IBU PS: "Maximum Quantity per Period" Documents in Periods | 8 | EFFECTIVE_DATE | Transaction was Created at this Time | decimal | 15 | 0 | | |
| 3 | /XLSO/ROLE_ASSGN | For assigning partner function after effective date | 8 | EFFECTIVE_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
| 4 | GRFNAU | Audit Proposal | 21 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 5 | GRFNAULOG | Audit Proposal Transfer Log | 22 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 6 | GRFNAUSTEP | Audit Proposal Steps | 14 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 7 | GRFNAUSTEPLOG | Audit Proposal Steps Transfer Log | 15 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 8 | HRAE_D_NOMINEES | Promotion Nominees | 8 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
| 9 | T7UNPF_HR_ADDR | Address | 6 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 10 | T7UNPF_HR_DS | Duty Station details | 7 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 11 | T7UNPF_HR_LANG | Language Allowance | 7 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 12 | T7UNPF_HR_PART | Parttime Details | 7 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 13 | T7UNPF_HR_SAL | Salary details | 6 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 14 | T7UNPF_HR_SEP | Staff Member Separation details | 6 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| 15 | TLRT_TARO_CNT | Trade Repository: Content | 46 | EFFECTIVE_DATE | Transaction Data: Effective Date | nvarchar | 8 | 0 | | |
| TOPBasic Functions |
| 16 | KNVP | Customer Master Partner Functions | 14 | EFFECTIVE_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
| TOPFinancial Accounting |
| 17 | BWPOSI | Valuations for Open Items | 27 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| TOPGovernance, Risk and Compliance |
| 18 | GRFNMDCR | Master Data Change Request | 5 | EFFECTIVE_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
| TOPHR Administrative Services |
| 19 | T5ASRPROCESSES | HR Administrative Services: Processes | 27 | EFFECTIVE_DATE | Effective Date | nvarchar | 8 | 0 | | |
| TOPRecords and Case Management |
| 20 | RMPSDOD_EVNTTYPE | Disposal Events | 5 | EFFECTIVE_DATE | Effective Disposal Date | nvarchar | 8 | 0 | | |
| 21 | RMPSPRO_EVNTTYPE | Disposal Events | 5 | EFFECTIVE_DATE | Effective Disposal Date | nvarchar | 8 | 0 | | |
| 22 | RMPSTNA_EVNTTYPE | Disposal Events | 5 | EFFECTIVE_DATE | Effective Disposal Date | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Application |
| 23 | WFATM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 4 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
| 24 | WFATM_SC_LOG | Audit Trail of WFM ESS Schedule Change | 4 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
| 25 | WFATM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 4 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Core |
| 26 | WFMTM_SC_AVA_TMP | TM Temp Table: Schedule - Availability | 4 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
| 27 | WFMTM_SC_LOG | Audit Trail of WFM ESS Schedule Change | 4 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
| 28 | WFMTM_SC_SEG_TMP | TM Temp Table: Schedule - Shift Segment | 4 | EFFECTIVE_DATE | Start Date | nvarchar | 8 | 0 | | |
