| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/VERSIONS | Contry Versions - Versions Administration | 3 | UPDATE_DATE | Date | nvarchar | 8 | 0 | | |
2 | TN11S | Locks for Building Units | 11 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
TOPClinical System |
3 | N2AD_ALLERGY | Allergy Documentation - Allergies | 29 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
4 | N2AD_PAT | Allergy Documentation - Overall Allergy Status (OAS) | 16 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
5 | N2AD_REACT | Allergy Documentation - Reactions | 15 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
6 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 23 | UPDATE_DATE | VIM IE Monitor: data_element for update date | nvarchar | 8 | 0 | | |
7 | /OPT/VIM_HD_NPO | VIM IE Monitor: Header Data for Parked NPO Invoices | 30 | UPDATE_DATE | VIM IE Monitor: data_element for update date | nvarchar | 8 | 0 | | |
8 | /OPT/VIM_HD_PO | VIM IE Monitor: Header Data for Parked PO Invoices | 33 | UPDATE_DATE | VIM IE Monitor: data_element for update date | nvarchar | 8 | 0 | | |
9 | /OPT/VIM_NPO_WID | VIM IE Monitortable: WI Header Data for NPO Invoices | 18 | UPDATE_DATE | Date | nvarchar | 8 | 0 | | |
10 | /OPT/VIM_NPO_WIH | VIM IE Monitortable: WI Header Data for NPO Invoices | 18 | UPDATE_DATE | VIM IE Monitor: data_element for update date | nvarchar | 8 | 0 | | |
11 | /OPT/VIM_PO_WID | VIM Report: WI Header Data for PO Invoices | 19 | UPDATE_DATE | Date | nvarchar | 8 | 0 | | |
12 | /OPT/VIM_PO_WIH | VIM Report: WI Header Data for PO Invoices | 19 | UPDATE_DATE | VIM IE Monitor: data_element for update date | nvarchar | 8 | 0 | | |
TOPFunds Management |
13 | FMUD | Override FM Update Date | 4 | UPDATE_DATE | Override Update Date | nvarchar | 8 | 0 | | |
TOPIntegration Builder - Configuration |
14 | SXISLDAEC | XI: Cache for Adapter Engine Data from the SLD | 9 | UPDATE_DATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
TOPPatient Management |
15 | NDRG | IS-H: Table Containing Case-Related DRGs | 18 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
TOPSales and Distribution |
16 | ZZDEA_MST | Drug Enforcement Administration (DEA) | 18 | UPDATE_DATE | Date | nvarchar | 8 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
17 | NAPX_DRG | IS-H: Appendix DRG Table | 17 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
18 | TCORT_CODCO | Deal: Conditions | 18 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | |
19 | TCORT_CODCOFO | Deal: Condition's Formula | 17 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | |
20 | TCORT_CODMD | Deal: Main Data | 14 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | |
21 | TCORT_CODPI | Deal: Payment Information | 14 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | |
22 | TCORT_CODULCO | Deal : Underlying's Conditions | 19 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | |
23 | TCORT_CODULCOFO | Deal: Underlying's Formula | 19 | UPDATE_DATE | Changed on | nvarchar | 8 | 0 | | |
TOPTransport Organizer |
24 | METHODTR | STATUS: Method Execution | 5 | UPDATE_DATE | Cuzstomer Enhancement/Modification: Date of Last Change | nvarchar | 8 | 0 | | |
25 | STAT_XPRA | STATUS: XPRAs | 5 | UPDATE_DATE | Cuzstomer Enhancement/Modification: Date of Last Change | nvarchar | 8 | 0 | | |