| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | WORK_ID | Situation Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | AREA | Work Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | WS_ID | Situation Template Key | nvarchar | 33 | 0 | | | | Allow NULL? |
| 7 | SHORT_CODE | Situation Identification | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | NAME | Situation Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | WORK_STATE | Situation Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | WORK_STARTED_ON | Start of Processing Date for this Situation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | WORK_STARTED_AT | Start of Processing Time for this Situation | nvarchar | 6 | 0 | | | | Allow NULL? |
| 12 | WORK_STARTED_BY | User who Started Situation | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | WORK_CLOSED_ON | Date When Situation Was Closed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | WORK_CLOSED_AT | Time When Situation Was Closed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | WORK_CLOSED_BY | User Who Closed Situation | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | INFO_MODE | Patient Viewer Setting for Situation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | INFO_ID | Info Item Code | nvarchar | 33 | 0 | | | | Allow NULL? |
| 18 | HAS_NOTE | Note Available | char | 1 | 0 | | | | Allow NULL? |
| 19 | CONTACT_PERSON | Name of Contact Person | nvarchar | 40 | 0 | | | | Allow NULL? |
| 20 | CONTACT_PHONE | Telephone Number of Contact Person | nvarchar | 30 | 0 | | | | Allow NULL? |
| 21 | CONTACT_EMAIL | e-mail Address of Contact Person | nvarchar | 53 | 0 | | | | Allow NULL? |
| 22 | SEL_VARIANT | ABAP: Name of variant (without program name) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 23 | FUN_VARIANT | Identification of Function Variant | nvarchar | 15 | 0 | | | | Allow NULL? |
| 24 | AUTO_CLOSE | Close Situation after Completion of All Tasks | char | 1 | 0 | | | | Allow NULL? |
| 25 | WORK_OFFSET | Setting for Closing and Deleting Situation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | ACCESS_OFFSET | No. of Days Situation Is Available After Closing | smallint | 5 | 0 | | | | |
| 27 | CLOSE_OFFSET | Days Until Work Situation Can Be Closed by System | smallint | 5 | 0 | | | | |
| 28 | DELETE_AFTER | Work Situation Can Be Deleted After this Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | INSDATE | Date of Creation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | INSUSER | User who Created Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | UPDDATE | Date on Which Record Was Last Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | WORK_PLAN_DATE | Planned Date of Situation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | TASK_CREATED | Situation Tasks Have Been Created | char | 1 | 0 | | | | Allow NULL? |
| 35 | CLIO_CONFIG_ID | Clinical Overview: Key of Web Dynpro Configuration | nvarchar | 32 | 0 | | | | Allow NULL? |
| 36 | CHART_CONFIG_ID | Charting: Chart Layout | nvarchar | 25 | 0 | | | | Allow NULL? |
| 37 | CLIO_MODE | Display Mode Clinical Overview | char | 1 | 0 | | | | Allow NULL? |
| 38 | PRODUCED_BY | Object Source | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | CHART_MODE | Display Mode for Chart | char | 1 | 0 | | | | Allow NULL? |
| 40 | WORK_HIDE | Hide Situation in Dialogs | char | 1 | 0 | | | | Allow NULL? |
