| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2UN_DSBP | Duty Station basic pay split extension | 11 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
2 | P2UN_RS | UN Rental Subsidy internal structure | 48 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
3 | T7UNCMT_HSFA | CMT Interface: Hardship Element | 3 | DSCAT | | nvarchar | 1 | 0 | | |
4 | T7UNCMT_MBFA | CMT Interface: Mobility Element | 3 | DSCAT | | nvarchar | 1 | 0 | | |
5 | T7UNCMT_NRFA | CMT Interface: Non Removal Element | 3 | DSCAT | | nvarchar | 1 | 0 | | |
TOPNon Profit Organizations |
6 | T7UNPAD_DS1P | Duty Station Main Time-Dependent Information | 6 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
7 | T7UNPAD_DSCA | Duty Station Hardship Classification | 3 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
8 | T7UNPAD_DSCA_T | Text for Duty Station Hardship Classification | 4 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
9 | T7UNPAD_DSHE | Duty Station Hardship Element | 3 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
10 | T7UNPAD_DSME | Duty Station Mobility Element | 3 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
11 | T7UNPAD_DSRE | Duty Station Removal/Non-Removal Element | 3 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
12 | T7UNPAD_HSFA | Hardship flat amounts | 5 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
13 | T7UNPAD_MBFA | Mobility Flat amounts | 5 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |
14 | T7UNPAD_NRFA | Removal/Non Removal Flat amounts | 5 | DSCAT | Duty Station Hardship Classification | nvarchar | 1 | 0 | | |