| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PAOCFEC_MAP | code mapping | 4 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
2 | PAOCFEC_MAP_C | code mapping (customer specific) | 4 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
3 | PAOCFEC_MAP_CC | code mapping (customer client specific) | 5 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
4 | PAOCFEC_MAP_MOD | Mapping for defaulted ListIDs of GDTs | 8 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
5 | T77SFEC_MAP | code mapping | 4 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
6 | T77SFEC_MAP_C | code mapping (customer specific) | 5 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
7 | T77SFEC_MAP_CC | code mapping (customer client specific) | 5 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
8 | T77SFEC_MAP_MOD | Mapping for defaulted ListIDs of GDTs | 8 | LIST_AGENCY_ID | LIST AGENCY ID | nvarchar | 60 | 0 | | |
TOPValue Mapping |
9 | MDGC_VM_CODELIST | Assign Code Lists to Elements and Systems | 6 | LIST_AGENCY_ID | List Agency ID | nvarchar | 60 | 0 | | |
10 | MDGD_CMAPCONTEXT | Specifies Mapping Contexts of code-mapping(client dependent) | 6 | LIST_AGENCY_ID | List Agency ID | nvarchar | 60 | 0 | | |
11 | MDGD_MAPCONTEXT | Specifies Mapping Contexts of code-mapping | 5 | LIST_AGENCY_ID | List Agency ID | nvarchar | 60 | 0 | | |