| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | STATE_TOTAL | Overall Allergy Status (OAS) | char | 1 | 0 | | | | Allow NULL? |
| 4 | STATE_COMMENT | Comment for Overall Allergy Status (OAS) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 5 | STATE_COMMENT_LT | Indicator that Long Text Exists | char | 1 | 0 | | | | Allow NULL? |
| 6 | NOA | Number of Allergies | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | DOKU_RESET | Allergy Documentation Reset | char | 1 | 0 | | | | Allow NULL? |
| 8 | DRUG_EXIST | Drug Allergy Exists | char | 1 | 0 | | | | Allow NULL? |
| 9 | PASS_EXIST | Allergy Passport Exists | char | 1 | 0 | | | | Allow NULL? |
| 10 | DIAG_EXIST | 'Allergy Diagnoses Exist' Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | RESPONSIBLE | Employee Responsible | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | EREASON | Change Reason, Code | char | 1 | 0 | | | | Allow NULL? |
| 13 | CREATE_DATE | IS-H: Date when Record Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | CREATE_TIME | IS-H: Time when Data Record Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | CREATE_USER | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | UPDATE_DATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | UPDATE_TIME | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | UPDATE_USER | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | CANCEL_DATE | IS-H: Cancellation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | CANCEL_TIME | IS-H: Time Data Record Canceled | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | CANCEL_USER | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | CANCEL_REASON | Cancellation Reason | char | 1 | 0 | | | | Allow NULL? |
| 23 | CANCEL_FLAG | IS-H: Cancellation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 24 | TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
