| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | NOTEKEY | PD: PD Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | STATUS | PD: Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | DESCR | PD:Short Description | nvarchar | 64 | 0 | | | | Allow NULL? |
| 5 | ADDED_NOTE | PD: Supplement Indicator for an Entry | char | 1 | 0 | | | | Allow NULL? |
| 6 | RESP | Employee Responsible | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | DOC_UNIT | Documenting Organizational Unit | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ACTION_DATE | PD: Reference Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | ACTION_TIME | PD: Reference Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | CANCELLED | IS-H: Cancellation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 11 | CANCEL_USR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | CANCEL_DATE | Date of Cancellation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | INSTITUTION | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | CANCEL_CAUSE | Reason for Canceling Medical Object | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | N8CRUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | N8CRDATE | IS-H: Date when Record Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | N8CRTIME | IS-H: Time Record Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | N8UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | N8UPDATE | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | N8UPTIME | IS-H: Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | N8DLFLAG | Deletion Flag/Indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | N8DLUSR | User Who Deleted Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | N8DLDATE | Date of Deletion | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | N8DLTIME | Deletion Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | DOC_UNIT2 | PD: Documenting Org. Unit 2 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | CHART_RELEVANT | "Display Note in Chart" Indicator | char | 1 | 0 | | | | Allow NULL? |
| 27 | OCCUP_GROUP | Occupational Group | nvarchar | 4 | 0 | | | | Allow NULL? |
