| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7UNCMT_HSFA | CMT Interface: Hardship Element | 9 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
2 | T7UNCMT_MBFA | CMT Interface: Mobility Element | 10 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
3 | T7UNCMT_NRFA | CMT Interface: Non Removal Element | 9 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
TOPNon Profit Organizations |
4 | T7UNCMT_CNTY | CMT Interface: Country | 27 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
5 | T7UNCMT_CURR | CMT Interface: Country | 13 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
6 | T7UNCMT_DEPA | CMT Interface: Dependency Allowed | 24 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
7 | T7UNCMT_DSSG | CMT Interface: Staff Assessment Grade Range | 17 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
8 | T7UNCMT_DUTX | CMT Interface: Duty Station | 6 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
9 | T7UNCMT_DUTY | CMT Interface: Duty Station | 32 | F_ADLH_TRAN_SER | | nvarchar | 8 | 0 | | |
10 | T7UNCMT_EGEN | CMT Interface: Education Grant Entitlement | 27 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
11 | T7UNCMT_EXCH | CMT Interface: Exchange Rate | 5 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
12 | T7UNCMT_HDSC | CMT Hardship Classification | 6 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
13 | T7UNCMT_HDSP | CMT Hardship Element | 9 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
14 | T7UNCMT_HRDC | CMT Hardship Classification | 6 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
15 | T7UNCMT_LNGA | CMT Interface: Language Allowance | 12 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
16 | T7UNCMT_MBLT | CMT Interface: Mobility Element | 11 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
17 | T7UNCMT_NNRM | CMT Interface: Non-Removal Element | 9 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
18 | T7UNCMT_PADJ | CMT Interface: Post Adjustment | 13 | F_ADLH_TRAN_SER | | nvarchar | 8 | 0 | | |
19 | T7UNCMT_PENR | CMT Interface: Pensionable Renumeration | 15 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
20 | T7UNCMT_RGNT | CMT Interface: Repatriation Grant | 11 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
21 | T7UNCMT_RMBR | CMT Interface: Reimbursible Percentage | 11 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
22 | T7UNCMT_RMXR | CMT Interface: Rental Subsidy Maximum Rent | 12 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
23 | T7UNCMT_RNGR | CMT Interface: Rental Subsidy Global Reference | 12 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
24 | T7UNCMT_RNSE | CMT Interface: Subsidy/Deduction Entitlement | 15 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
25 | T7UNCMT_RNTE | CMT Interface: Subsidy/Deduction Entitlement | 15 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |
26 | T7UNCMT_STFA | CMT Interface: Salary and Staff Assessment | 19 | F_ADLH_TRAN_SER | | nvarchar | 12 | 0 | | |