| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N2GL_TM_ID | Allow NULL? |
| 3 | STEP_ID | Step Key | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N2GL_STEP_ID | Allow NULL? |
| 4 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EINRI | Allow NULL? |
| 5 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 6 | GROUP_ID | Group ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N2GL_GROUP_ID | Allow NULL? |
| 7 | GROUP_NAME | Name of Group | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | N2GL_TITLE_GROUP | Allow NULL? |
| 8 | SEQUENCE_NUMBER | Sequence Number | int | 10 | 0 | INT4 | ((0)) | Yes | | N2GL_SEQUENCE_NUMBER | Allow NULL? |
| 9 | ITEM_ID | Item ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N2GL_ITEM_ID | Allow NULL? |
| 10 | STEP_STATE | Status of Step | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N2GL_STEP_STATE | Allow NULL? |
| 11 | STEP_NOTE_ID | PD: PD Key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | N2VDNOTE | N2VD_KEY | Allow NULL? |
| 12 | ANSWER_TEXT | Response Text | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | N2GL_ANSWER_TEXT | Allow NULL? |
| 13 | DURATION | Duration | int | 10 | 0 | INT4 | ((0)) | Yes | | N2GL_DURATION | Allow NULL? |
| 14 | ROLE_ID | pathways Responsibility ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | N2GL_ROLE_ID | Allow NULL? |
| 15 | ROLE_TXT | Responsibility | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N2GL_ROLE_TXT | Allow NULL? |
| 16 | REASON_ID | Reason for Rescheduling ID (Obsolete) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | N2GL_NEWPLAN_REASON | Allow NULL? |
| 17 | ITEMTYPE | Item Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N2GL_ITEMTYPE | Allow NULL? |
| 18 | TM_NAME | Name of a Step in Patient Pathway | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | N2GL_STEP_NAME | Allow NULL? |
| 19 | PATH_RELEVANT | Pathway Relevance | char | 1 | 0 | CHAR | (N' ') | Yes | | N2GL_PATHRELEVANT | Allow NULL? |
| 20 | ACTION_TYPE | Action Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N2GL_ACTION_TYPE | Allow NULL? |
| 21 | BASE_ITEM_ID | Base Items: Base Item Internal Key | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N2GL_BASEITEM_ID | Allow NULL? |
| 22 | ACTION_EXECUTED | Action Was Executed | char | 1 | 0 | CHAR | (N' ') | Yes | | N2GL_ACTION_EXECUTED | Allow NULL? |
| 23 | HAS_CORRESP_STEP | Step Has Connected Step | char | 1 | 0 | CHAR | (N' ') | Yes | | N2GL_HAS_CORRESP | Allow NULL? |
| 24 | HAS_DEPEND_STEP | Step Is Dependent on Step | char | 1 | 0 | CHAR | (N' ') | Yes | | N2GL_HAS_DEPENDENT | Allow NULL? |
| 25 | PLAN_DATE | Step Planned Date (Original Planning) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_PLAN_DATE | Allow NULL? |
| 26 | PLAN_TIME | Step Planned Time (Original Planning) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N2GL_PLAN_TIME | Allow NULL? |
| 27 | NEW_PLAN_DATE | Step Planned Date: Current Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_NEW_PLAN_DATE | Allow NULL? |
| 28 | NEW_PLAN_TIME | Step Planned Time: Current Calculation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N2GL_NEW_PLAN_TIME | Allow NULL? |
| 29 | DONE_PLAN_DATE | Planned Step Date on Processing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_DONE_PLAN_DATE | Allow NULL? |
| 30 | DONE_PLAN_TIME | Planned Step Time on Processing | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N2GL_DONE_PLAN_TIME | Allow NULL? |
| 31 | DONE_DATE | Step Processing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_DONE_DATE | Allow NULL? |
| 32 | DONE_TIME | Step Processing Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N2GL_DONE_TIME | Allow NULL? |
| 33 | DONE_STATE | Completion Status of Step | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N2GL_DONE_STATE | Allow NULL? |
| 34 | EMR | Employee Responsible | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | N2GL_VMA | Allow NULL? |
| 35 | UNPLANNED_STEP | Plan Time of Step not yet Determined | char | 1 | 0 | CHAR | (N' ') | Yes | | N2GL_STEP_UNPLANNED | Allow NULL? |
| 36 | URL_ID | ID of URL | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N2GL_URL_ID | Allow NULL? |
| 37 | INSDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_INSDATE | Allow NULL? |
| 38 | INSUSER | User who Created Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | N2GL_INSUSER | Allow NULL? |
| 39 | UPDDATE | Date on Which Record Was Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_UPDDATE | Allow NULL? |
| 40 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | N2GL_UPDUSER | Allow NULL? |
| 41 | DELDATE | Date, on Which Deletion Indicator Was Set | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2GL_DELDATE | Allow NULL? |
| 42 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | N2GL_DELUSER | Allow NULL? |
| 43 | DELFLAG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N2GL_DELFLAG | Allow NULL? |
| 44 | LAST_CHANGE | Time Stamp of Last Change | decimal | 21 | 7 | DEC | ((0)) | Yes | | N2GL_LAST_CHANGE | |
| 45 | ACTION_BEHAVIOR | Action Behavior When Confirming a Step | nvarchar | 2 | 0 | CHAR | (N' ') | No | | N2GL_ACTION_BEHAVIOR | Allow NULL? |
| 46 | DIFF_PLAN_DONE | pathways Difference Completion Date/Original Date Planned | int | 10 | 0 | INT4 | ((0)) | No | | N2GL_DIFFERENCE_PLAN_DONE | Allow NULL? |
