| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SYCLO/MSG01 | Syclo Mobile Data Unit Message Queue (Outbound) | 23 | CANCEL_FLAG | Active Flag | nvarchar | 1 | 0 | | |
| 2 | TN11S | Locks for Building Units | 15 | CANCEL_FLAG | IS-H: Cancellation Indicator | nvarchar | 1 | 0 | | |
| TOPClinical System |
| 3 | N2AD_ALLERGY | Allergy Documentation - Allergies | 36 | CANCEL_FLAG | IS-H: Cancellation Indicator | nvarchar | 1 | 0 | | |
| 4 | N2AD_PAT | Allergy Documentation - Overall Allergy Status (OAS) | 23 | CANCEL_FLAG | IS-H: Cancellation Indicator | nvarchar | 1 | 0 | | |
| 5 | N2AD_REACT | Allergy Documentation - Reactions | 22 | CANCEL_FLAG | IS-H: Cancellation Indicator | nvarchar | 1 | 0 | | |
| TOPDSD Connector |
| 6 | /DSD/ME_PAYM_HD | DSD CN: Payments or Cash Collection received from Customer | 16 | CANCEL_FLAG | DSD Connector: Cancel flag | nvarchar | 1 | 0 | | |
| 7 | /DSD/ME_REVN_HD | DSD CN: Payments or Cash Collection received from Customer | 16 | CANCEL_FLAG | DSD Connector: Cancel flag | nvarchar | 1 | 0 | | |
| TOPGlobal Trade |
| 8 | WB2_D_ASSGMT | Assignments | 24 | CANCEL_FLAG | Cancel | nvarchar | 1 | 0 | | |
| 9 | WB2_D_SHD_ITEM | Shadow Items | 30 | CANCEL_FLAG | Cancel | nvarchar | 1 | 0 | | |
| TOPPatient Management |
| 10 | NDRG | IS-H: Table Containing Case-Related DRGs | 25 | CANCEL_FLAG | IS-H: Cancellation Indicator | nvarchar | 1 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 11 | NAPX_DRG | IS-H: Appendix DRG Table | 24 | CANCEL_FLAG | IS-H: Cancellation Indicator | nvarchar | 1 | 0 | | |
