| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7UNCMT_HSFA | CMT Interface: Hardship Element | 6 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
2 | T7UNCMT_MBFA | CMT Interface: Mobility Element | 7 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
3 | T7UNCMT_NRFA | CMT Interface: Non Removal Element | 6 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
TOPNon Profit Organizations |
4 | T7UNCMT_CNTY | CMT Interface: Country | 20 | F_CURR_CODE | | nvarchar | 3 | 0 | | |
5 | T7UNCMT_DEPA | CMT Interface: Dependency Allowed | 12 | F_CURR_CODE | | nvarchar | 3 | 0 | | |
6 | T7UNCMT_DS | United Nations CMT Duty Station | 27 | F_CURR_CODE | | nvarchar | 3 | 0 | | |
7 | T7UNCMT_DUTY | CMT Interface: Duty Station | 29 | F_CURR_CODE | | nvarchar | 3 | 0 | | |
8 | T7UNCMT_EGEN | CMT Interface: Education Grant Entitlement | 6 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
9 | T7UNCMT_EXCH | CMT Interface: Exchange Rate | 3 | F_CURR_CODE | | nvarchar | 3 | 0 | | |
10 | T7UNCMT_LNGA | CMT Interface: Language Allowance | 9 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
11 | T7UNCMT_PENR | CMT Interface: Pensionable Renumeration | 13 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
12 | T7UNCMT_RMXR | CMT Interface: Rental Subsidy Maximum Rent | 10 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
13 | T7UNCMT_RNGR | CMT Interface: Rental Subsidy Global Reference | 8 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
14 | T7UNCMT_RNSE | CMT Interface: Subsidy/Deduction Entitlement | 9 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
15 | T7UNCMT_RNTE | CMT Interface: Subsidy/Deduction Entitlement | 9 | F_CURR_CODE | | nvarchar | 5 | 0 | | |
16 | T7UNCMT_STFA | CMT Interface: Salary and Staff Assessment | 13 | F_CURR_CODE | | nvarchar | 5 | 0 | | |