| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VT_WORKITE1 | Work Item Header Table - Copy of /opt/vt_workitem | 12 | UPDATE_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
2 | /OPT/VT_WORKITEM | Work Item Header Table | 12 | UPDATE_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
3 | GRPCDBBUFD | Dashboard buffer data | 4 | UPDATE_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPAuto-ID Infrastructure |
4 | /AIN/DM_AOBJ_CTX | Action Object Context (tag data history) | 6 | UPDATE_TIME | Time Stamp | decimal | 15 | 0 | | |
5 | /AIN/DM_DOC_CTX | Document Context Table | 8 | UPDATE_TIME | Time Stamp | decimal | 15 | 0 | | |
6 | /AIN/DM_OBJECT | Object | 21 | UPDATE_TIME | Update Time | decimal | 15 | 0 | | |
7 | /AIN/DM_OBJ_CTX | Object Context (object user data) | 5 | UPDATE_TIME | Time Stamp | decimal | 15 | 0 | | |
TOPClinical System |
8 | N2AD_ALLERGY | Allergy Documentation - Allergies | 30 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | |
9 | N2AD_PAT | Allergy Documentation - Overall Allergy Status (OAS) | 17 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | |
10 | N2AD_REACT | Allergy Documentation - Reactions | 16 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | |
TOPCross-Application Components |
11 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 24 | UPDATE_TIME | VIM IE Monitor: data_element for update time | nvarchar | 6 | 0 | | |
12 | /OPT/VIM_HD_NPO | VIM IE Monitor: Header Data for Parked NPO Invoices | 31 | UPDATE_TIME | VIM IE Monitor: data_element for update time | nvarchar | 6 | 0 | | |
13 | /OPT/VIM_HD_PO | VIM IE Monitor: Header Data for Parked PO Invoices | 34 | UPDATE_TIME | VIM IE Monitor: data_element for update time | nvarchar | 6 | 0 | | |
14 | /OPT/VIM_NPO_WID | VIM IE Monitortable: WI Header Data for NPO Invoices | 19 | UPDATE_TIME | Time | nvarchar | 6 | 0 | | |
15 | /OPT/VIM_NPO_WIH | VIM IE Monitortable: WI Header Data for NPO Invoices | 19 | UPDATE_TIME | VIM IE Monitor: data_element for update time | nvarchar | 6 | 0 | | |
16 | /OPT/VIM_PO_WID | VIM Report: WI Header Data for PO Invoices | 20 | UPDATE_TIME | Time | nvarchar | 6 | 0 | | |
17 | /OPT/VIM_PO_WIH | VIM Report: WI Header Data for PO Invoices | 20 | UPDATE_TIME | VIM IE Monitor: data_element for update time | nvarchar | 6 | 0 | | |
TOPFinancial Accounting |
18 | /OPT/VT_WORK | Work Item Header Table - Real Time | 12 | UPDATE_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPPatient Management |
19 | NDRG | IS-H: Table Containing Case-Related DRGs | 19 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | |
TOPSales and Distribution |
20 | ZZDEA_MST | Drug Enforcement Administration (DEA) | 19 | UPDATE_TIME | Time | nvarchar | 6 | 0 | | |
TOPSAP Business Partner |
21 | COMM_CLEAR_STACK | Data Cleansing Cases | 20 | UPDATE_TIME | Data Cleansing: Timestamp Processed | decimal | 15 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
22 | NAPX_DRG | IS-H: Appendix DRG Table | 18 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
23 | TCORT_CODCO | Deal: Conditions | 19 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | |
24 | TCORT_CODCOFO | Deal: Condition's Formula | 18 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | |
25 | TCORT_CODMD | Deal: Main Data | 15 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | |
26 | TCORT_CODPI | Deal: Payment Information | 15 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | |
27 | TCORT_CODULCO | Deal : Underlying's Conditions | 20 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | |
28 | TCORT_CODULCOFO | Deal: Underlying's Formula | 20 | UPDATE_TIME | Time changed | nvarchar | 6 | 0 | | |
TOPTransport Organizer |
29 | METHODTR | STATUS: Method Execution | 6 | UPDATE_TIME | Customer Enhancement/Modification: Time of Last Change | nvarchar | 6 | 0 | | |
30 | STAT_XPRA | STATUS: XPRAs | 6 | UPDATE_TIME | Customer Enhancement/Modification: Time of Last Change | nvarchar | 6 | 0 | | |