| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | WORKITEM_ID | Radiological Task Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 3 | WORKITEM_TYPE | Radiological Task Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | WORKITEM_STATE | Completion Status of a Radiological Task | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | STATE_SET_BY | User Who Last Changed Status | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | STATE_SET_DATE | Date on Which Record Was Last Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | SCHEDULED | Due Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | DELETE_FLAG | Deletion Indicator for a Rad. Task (Deletion Flag) | char | 1 | 0 | | | | Allow NULL? |
| 9 | EXPIRATION_DATE | Expiration Date of a Task with Deletion Flag | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | WORKITEM_PRIOR | Prioritization for Request/Movement (Internal) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | DESCRIPTION | Name of a Radiological Task | nvarchar | 40 | 0 | | | | Allow NULL? |
| 12 | EMPLOYEE_RESP | Employee Responsible | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | INSTITUTION | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | PROCEDURE_STEP | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | DOKAR | Document Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | DOKNR | Document number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 17 | DOKVR | Document Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | DOKTL | Document Part | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | PACS_ID | PACS Key | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | INSDATE | Date of Creation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | INSUSER | User who Created Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | UPDDATE | Date on Which Record Was Last Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |