| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N2AD_ALLERGY | Allergy Documentation - Allergies | 33 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | |
| 2 | N2AD_PAT | Allergy Documentation - Overall Allergy Status (OAS) | 20 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | |
| 3 | N2AD_REACT | Allergy Documentation - Reactions | 19 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | |
| TOPPatient Management |
| 4 | NDRG | IS-H: Table Containing Case-Related DRGs | 22 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | |
| TOPProduction Orders |
| 5 | AFSPREL | Relation Between Orders in an Order Split | 21 | CANCEL_TIME | Time of Cancellation | nvarchar | 6 | 0 | | |
| TOPSAP Healthcare - Industry-Specific Components for Hospitals |
| 6 | NAPX_DRG | IS-H: Appendix DRG Table | 21 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | |
| TOPTravel Planning |
| 7 | FTPT_CAR | Travel Request Item - Car Rental Service | 61 | CANCEL_TIME | Car rental reser.: Latest possible cancellation time | nvarchar | 5 | 0 | | |
| 8 | FTPT_HOTEL | Travel Request Item - Hotel Service | 64 | CANCEL_TIME | Hotel Reservation: Cancelation Deadline | nvarchar | 5 | 0 | | |
