| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7HK11 | General information of the IR56 forms | 30 | MGTXT | 30 Characters | nvarchar | 30 | 0 | | |
TOPAustralia |
2 | T5QSM | Superannuation Highlight Messages Australia | 3 | MGTXT | Superannuation Fund Message Text | nvarchar | 24 | 0 | | |
TOPNew Zealand |
3 | T7NZSM | Superannuation Highlight Messages NZ | 4 | MGTXT | Superannuation Fund Highlight Message Text NZ | nvarchar | 24 | 0 | | |
TOPPersonnel Administration |
4 | T530T | Reason for Action Texts | 5 | MGTXT | Name of reason for action | nvarchar | 30 | 0 | | |
TOPWorkforce Management Application |
5 | WFAEM_ACTION_MAP | Mapping table for action types | 5 | MGTXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
6 | WFAEM_VAL530_T | Text table for reason code | 5 | MGTXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPWorkforce Management Core |
7 | WFMEM_ACTION_MAP | Mapping table for action types | 5 | MGTXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
8 | WFMEM_VAL530_T | Text table for reason code | 5 | MGTXT | Text (30 Characters) | nvarchar | 30 | 0 | | |