| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TOBJ_D_ARC | Batch History: Archiving Batch History | 9 | ARCHIVABLE | Checkbox | nvarchar | 1 | 0 | | |
| TOPActual Update and Commitment Update |
| 2 | GTR_TRANSLATOR | Grantor: Translator of CRM and ERP Integration Attributes | 12 | ARCHIVABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | nvarchar | 1 | 0 | | |
| TOPAdvanced Returns Management |
| 3 | MSR_D_HEAD | Advanced Returns Management - Tracking Header Data | 12 | ARCHIVABLE | Checkbox | nvarchar | 1 | 0 | | |
| TOPArchiving Engine |
| 4 | TARESTAT01 | Archiving Monitor: Events | 6 | ARCHIVABLE | Number of Archivable Objects | int | 10 | 0 | | |
| 5 | TARESTAT04 | Archiving Monitor: InfoCube Packages | 8 | ARCHIVABLE | Number of Archivable Objects | int | 10 | 0 | | |
| 6 | TARPACKAGES | Archiving Engine: Packages | 7 | ARCHIVABLE | Number of Archivable Objects | int | 10 | 0 | | |
| TOPControlling |
| 7 | IAOM_EXT_OBJ_HST | General Information on External Object: History | 14 | ARCHIVABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | nvarchar | 1 | 0 | | |
| 8 | IAOM_EXT_OBJ_INF | General Information on External Object - See Documentation | 12 | ARCHIVABLE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Application |
| 9 | WFAFC_FORECAST | Forecasting master table | 13 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 10 | WFAFC_SAMPLE2 | Forecasting Sample | 15 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 11 | WFA_ACT_BENF | Actual imported benefits table | 15 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 12 | WFA_ACT_SHIFT | Actual header table | 8 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 13 | WFA_ACT_SUMM | Actual summary hours, total paid hours and total pay | 13 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 14 | WFA_CALCST | Calculation Status | 22 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 15 | WFA_SCHEDULE | Schedule Table | 15 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 16 | WFA_SCHED_SUMM | Schedule summary hours, total paid hours and total pay | 13 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 17 | WFA_TIMOFFREQ | Time off Requests | 24 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Core |
| 18 | WFMCAS_ACT_BENF | Actual imported benefits table | 15 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 19 | WFMCAS_ACT_SHIFT | Actual header table | 8 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 20 | WFMCAS_ACT_SUMM | Actual summary hours, total paid hours and total pay | 13 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 21 | WFMCAS_CALCST | Calculation Status | 22 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 22 | WFMCAS_SCHEDULE | Schedule Table | 15 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 23 | WFMCAS_TIMOFFREQ | Time off Requests | 23 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 24 | WFMFC_FORECAST | Forecasting master table | 13 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
| 25 | WFMFC_SAMPLE2 | Forecasting Sample | 15 | ARCHIVABLE | Record is Archivable | nvarchar | 1 | 0 | | |
