| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /XFT/EPA_B0001 | Checklists | 3 | LIST_ID | Checklist ID | nvarchar | 5 | 0 | | |
2 | /XFT/EPA_T0012 | Checklists | 2 | LIST_ID | Checklist ID | nvarchar | 5 | 0 | | |
3 | /XFT/EPA_T0012S | Checklists | 2 | LIST_ID | Checklist ID | nvarchar | 5 | 0 | | |
4 | /XFT/EPA_T0013 | Checklists: Visibility | 2 | LIST_ID | Checklist ID | nvarchar | 5 | 0 | | |
5 | /XFT/EPA_T0014 | Checklists: Authorization Visibility | 3 | LIST_ID | Checklist ID | nvarchar | 5 | 0 | | |
6 | /XFT/EPA_TPROT | Log | 23 | LIST_ID | Checklist ID | nvarchar | 5 | 0 | | |
7 | PAOCFEC_LIST_ID | Default List IDs for GDT Codes | 1 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
8 | PAOCFEC_MAP | code mapping | 2 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
9 | PAOCFEC_MAP_C | code mapping (customer specific) | 2 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
10 | PAOCFEC_MAP_CC | code mapping (customer client specific) | 3 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
11 | PAOCFEC_MAP_MOD | Mapping for defaulted ListIDs of GDTs | 6 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
12 | T77SFEC_LIST_ID | Default List IDs for GDT Codes | 1 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
13 | T77SFEC_MAP | code mapping | 2 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
14 | T77SFEC_MAP_C | code mapping (customer specific) | 3 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
15 | T77SFEC_MAP_CC | code mapping (customer client specific) | 3 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
16 | T77SFEC_MAP_MOD | Mapping for defaulted ListIDs of GDTs | 6 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
TOPAdvertising Management |
17 | TJHVKL | IS-M/AM: List Format for Header | 2 | LIST_ID | IS-M/AM: Display Variant for List Tool | nvarchar | 18 | 0 | | |
18 | TJHVKLT | IS-M/AM: List Format for Header Texts | 3 | LIST_ID | IS-M/AM: Display Variant for List Tool | nvarchar | 18 | 0 | | |
19 | TJHVKLT0 | IS-M/AM: Display Variants List Tool | 3 | LIST_ID | IS-M/AM: Display Variant for List Tool | nvarchar | 18 | 0 | | |
20 | TJHVKLT1 | IS-M/AM: Display Variants List Tool Text Table | 4 | LIST_ID | IS-M/AM: Display Variant for List Tool | nvarchar | 18 | 0 | | |
21 | TJHVPL | IS-M/AM: Field Selection for List Format | 2 | LIST_ID | IS-M/AM: Display Variant for List Tool | nvarchar | 18 | 0 | | |
22 | TJHVPLT | IS-M/AM: Field Selection For Display Variants List Tool | 3 | LIST_ID | List name for variable lists | nvarchar | 18 | 0 | | |
TOPClinical System |
23 | N2HIT_LI_EN | HL: Findings Hit List: Assignment: Entry - Hit List | 4 | LIST_ID | Hit List ID | nvarchar | 15 | 0 | | |
TOPLocalization |
24 | EPIC_AS_APPR | Approval Step: List of Possible Approvers | 2 | LIST_ID | Payment Release List ID | nvarchar | 10 | 0 | | |
TOPPayment Transactions |
25 | FPRL_HEADER | List Header Data | 2 | LIST_ID | Payment Release List ID | nvarchar | 10 | 0 | | |
26 | FPRL_ITEM | Item Data | 3 | LIST_ID | Payment Release List ID | nvarchar | 10 | 0 | | |
27 | FPRL_LOG | List Log | 7 | LIST_ID | Payment Release List ID | nvarchar | 10 | 0 | | |
28 | FPRL_WARNINGS | System Warning Messages | 4 | LIST_ID | Payment Release List ID | nvarchar | 10 | 0 | | |
TOPPeople Centric UI Framework |
29 | CRM_BSP_LIST | CRM PCUI Lists | 2 | LIST_ID | List ID | nvarchar | 32 | 0 | | |
30 | CRM_BSP_LIST_OBJ | CRM PCUI List Objects and Attributes | 2 | LIST_ID | List ID | nvarchar | 32 | 0 | | |
TOPRecipe Development |
31 | /PLMI/LBL_UI_LIS | List Titles on the Labels | 2 | LIST_ID | List ID | nvarchar | 10 | 0 | | |
32 | /PLMI/LBL_UI_LIT | List Titles on the Labels | 3 | LIST_ID | List ID | nvarchar | 10 | 0 | | |
TOPSAP Utilities |
33 | ESECODELISTVAL | Codes of ISU Specific Codelists values | 3 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
34 | ESECODELISTVALT | Text table: Codes and names of ISU Specific Codelists | 4 | LIST_ID | Code list ID | nvarchar | 60 | 0 | | |
TOPValue Mapping |
35 | MDGC_VM_CODELIST | Assign Code Lists to Elements and Systems | 7 | LIST_ID | List ID | nvarchar | 60 | 0 | | |
36 | MDGD_CMAPCONTEXT | Specifies Mapping Contexts of code-mapping(client dependent) | 5 | LIST_ID | List ID | nvarchar | 60 | 0 | | |
37 | MDGD_MAPCONTEXT | Specifies Mapping Contexts of code-mapping | 4 | LIST_ID | List ID | nvarchar | 60 | 0 | | |