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