| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /ATL/HOLIDAYS | Holidays Administration | 1 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
| 2 | THOC | Public Holiday Calendar | 3 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 3 | THOCD | Public holiday definitions | 3 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 4 | THOL | Public Holidays | 1 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 5 | THOLT | Public holiday texts | 1 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 6 | THOLU | Dates of movable public holidays | 1 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| TOPReuse Services for Country Development |
| 7 | T5F99PHR | Public Holiday Calendar replacements | 3 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 8 | T5F99PHS | Public Holiday Substitutions | 4 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| TOPWorkforce Management Application |
| 9 | ITC_CALCRULE_HOL | Holiday Type Calculation Rule Attributes | 5 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 10 | WFAC_HOLASSIGN_D | Holiday Cost Profile Assigment - Data | 5 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 11 | WFA_ACT_BENF | Actual imported benefits table | 8 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 12 | WFA_SCHE_BENF | Actual imported benefits table | 6 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| TOPWorkforce Management Core |
| 13 | WFMCAS_ACT_BENF | Actual imported benefits table | 8 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 14 | WFMCAS_HOL_HIST | Holiday History table (OBSOLETE) | 6 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 15 | WFMCAS_SCHE_BENF | Actual imported benefits table | 6 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
| 16 | WFMC_HOLASSIGN_D | Holiday Cost Profile Assigment - Data | 5 | FTGID | Public holiday key | nvarchar | 3 | 0 | | |
