| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPI18N Unicode |
1 | UMGHISTORY | Data used for the Unicode migration of the system | 4 | HISTORY_DATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
TOPWorkforce Management Application |
2 | WFAFC_FG_TAGDAYS | A map of dates to similiar multiple historical dates | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
3 | WFAFC_FIXHIST_D | Fixed History- Obsolete as of 5.0 | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
4 | WFAFC_TAGDAY_GLB | Tag History Global Dates | 3 | HISTORY_DATE | Tag History Date | nvarchar | 8 | 0 | | |
5 | WFAFC_TAGDAY_GLO | Tagged History - Obsolete as of 5.0 | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
6 | WFAFC_TAGDAY_LOC | Tag History - Location specific settings | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
TOPWorkforce Management Core |
7 | WFMFC_FG_TAGDAYS | A map of dates to similiar multiple historical dates | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
8 | WFMFC_FIXHIST_D | Fixed History- Obsolete as of 5.0 | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
9 | WFMFC_TAGDAY_GLB | Tag History Global Dates | 3 | HISTORY_DATE | Tag History Date | nvarchar | 8 | 0 | | |
10 | WFMFC_TAGDAY_GLO | Tagged History - Obsolete as of 5.0 | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |
11 | WFMFC_TAGDAY_LOC | Tag History - Location specific settings | 4 | HISTORY_DATE | Historical Tagging Date | nvarchar | 8 | 0 | | |