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