| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TN11S | Locks for Building Units | 13 | CANCEL_DATE | Date of Cancellation | nvarchar | 8 | 0 | | |
| TOPClinical System |
| 2 | N2AD_ALLERGY | Allergy Documentation - Allergies | 32 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | |
| 3 | N2AD_PAT | Allergy Documentation - Overall Allergy Status (OAS) | 19 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | |
| 4 | N2AD_REACT | Allergy Documentation - Reactions | 18 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | |
| 5 | N2VDNOTE | IS-H*MED PD: Progress Entry | 12 | CANCEL_DATE | Date of Cancellation | nvarchar | 8 | 0 | | |
| TOPPatient Management |
| 6 | NDRG | IS-H: Table Containing Case-Related DRGs | 21 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | |
| TOPProduction Orders |
| 7 | AFSPREL | Relation Between Orders in an Order Split | 20 | CANCEL_DATE | Cancellation Date Order Split | nvarchar | 8 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 8 | NAPX_DRG | IS-H: Appendix DRG Table | 20 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | |
