SAP ABAP Table RN2GL_PATH_SCR (Patient Pathway - Screen)
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-HMED (Application Component) Clinical System
⤷ NMED_GL (Package) IS-H*MED: Treatment Pathways
⤷ IS-HMED (Application Component) Clinical System
⤷ NMED_GL (Package) IS-H*MED: Treatment Pathways
Basic Data
Table Category | INTTAB | Structure |
Structure | RN2GL_PATH_SCR | Table Relationship Diagram |
Short Description | Patient Pathway - Screen |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | pathways Patient Pathway | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | SCHEDULE_ID | N2GL_TM_ID | SYSUUID_C | CHAR | 32 | 0 | Patient Pathway Key | ||
4 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | * | |
5 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | ||
6 | TM_TITLE | N2GL_TM_TITLE | TEXT40 | CHAR | 40 | 0 | Title of Patient Pathway | ||
7 | TM_STATE | N2GL_TM_STATE | N2GL_TM_STATE | CHAR | 2 | 0 | Status of Patient Pathway | ||
8 | TM_DONE_STATE | N2GL_TM_DONE_STATE | N2GL_TM_DONE_STATE | CHAR | 2 | 0 | Patient Pathway Completion Status | ||
9 | STATE_MED_USE | N2GL_MED_STATE | N2GL_MED_STATE | CHAR | 2 | 0 | Medical Status of Treatment Pathway | ||
10 | GL_ID | N2GL_GL_ID | SYSUUID_C | CHAR | 32 | 0 | Treatment Pathway ID | ||
11 | SHORT_CODE | N2GL_SHORT_CODE | N2GL_SHORT_CODE | CHAR | 20 | 0 | Abbreviation of Treatment Pathway | ||
12 | VERSION | N2GL_VERSION | N2_VERS | NUMC | 3 | 0 | Version of Treatment Pathway | ||
13 | GL_VERSION_ID | N2GL_GL_ID | SYSUUID_C | CHAR | 32 | 0 | Treatment Pathway ID | ||
14 | NEXT_TODO_DATE | N2GL_NEXT_TODO_DATE | DATS | 8 | 0 | Date when next Step Is to Be Performed | |||
15 | NEXT_TODO_TIME | N2GL_NEXT_TODO_TIME | TIMS | 6 | 0 | Time when Next Step Is to Be Performed | |||
16 | TIMEUNIT | N2GL_TIMEUNIT | N2GL_TIMEUNIT | CHAR | 2 | 0 | Time Unit | ||
17 | PATH_IN_PAUSE | N2GL_PATH_IN_PAUSE | ISH_ON_OFF | CHAR | 1 | 0 | Patient Pathway Is in Treatment Pause | ||
18 | VDOC_ID | N2VD_KEY | N2VD_KEY | CHAR | 20 | 0 | PD: PD Key | N2VD | |
19 | ASSIGN_FALNR | N2GL_ASSIGN_FALNR | FALNR | CHAR | 10 | 0 | Case Number in Assignment of Pathway to Patient | * | |
20 | ASSIGN_DATE | N2GL_ASSIGN_DATE | DATS | 8 | 0 | Assignment Date of Pathway | |||
21 | ASSIGN_TIME | N2GL_ASSIGN_TIME | TIMS | 6 | 0 | Assignment Time of Pathway | |||
22 | ASSIGN_EMR | N2GL_VMA | RI_KUNNR | CHAR | 10 | 0 | Employee Responsible | * | |
23 | STARTDATE | N2GL_START_DATE | DATS | 8 | 0 | Start Date of Patient Pathway | |||
24 | STARTTIME | N2GL_START_TIME | TIMS | 6 | 0 | Patient Pathway Start Time | |||
25 | PLAN_ENDDATE | N2GL_PLAN_ENDDATE | DATS | 8 | 0 | Planned End Date of Patient Pathway | |||
26 | PLAN_ENDTIME | N2GL_PLAN_ENDTIME | TIMS | 6 | 0 | Planned End Time of Patient Pathway | |||
27 | NEW_PLAN_ENDDATE | N2GL_NEW_PLAN_ENDDATE | DATS | 8 | 0 | New Planned End Date of Patient Pathway | |||
28 | NEW_PLAN_ENDTIME | N2GL_NEW_PLAN_ENDTIME | TIMS | 6 | 0 | New Planned End Time of Patient Pathway | |||
29 | ENDDATE | N2GL_END_DATE | DATS | 8 | 0 | End Date of Patient Pathway | |||
30 | ENDTIME | N2GL_END_TIME | TIMS | 6 | 0 | End Time of Patient Pathway | |||
31 | CANCEL_EMR | N2GL_VMA | RI_KUNNR | CHAR | 10 | 0 | Employee Responsible | * | |
32 | RECALCULATED | N2GL_PATH_RECALCULATED | ISH_ON_OFF | CHAR | 1 | 0 | Patient Pathway Was Rescheduled | ||
33 | POSTPONED | N2GL_PATH_POSTPONED | ISH_ON_OFF | CHAR | 1 | 0 | Patient Pathway Postponed | ||
34 | URL_ID | N2GL_URL_ID | SYSUUID_C | CHAR | 32 | 0 | ID of URL | ||
35 | LAST_CHANGE | N2GL_LAST_CHANGE | TZNTSTMPL | DEC | 21 | 7 | Time Stamp of Last Change | ||
36 | SEARCH_STRATEGY | N2GL_SEARCH_STRATEGY | N2GL_SEARCH_STRATEGY | CHAR | 1 | 0 | i.s.h.med pathways Search Strategy | ||
37 | ASSIGN_ORGID | N2GL_ASSIGN_ORGID | ORGID | CHAR | 8 | 0 | pathways Organizational Unit of Pathway Assignment | * | |
38 | PATHWAYS_VERSION | N2GL_PATHWAYS_VERSION | N2GL_PATHWAYS_VERSION | NUMC | 3 | 0 | pathways Version (Internal Use) | ||
39 | ASSIGN_YEAR | N2GL_ASSIGN_YEAR | N2GL_YEAR | NUMC | 4 | 0 | pathways Year of Assignment of Pathway | ||
40 | ASSIGN_MONTH | N2GL_ASSIGN_MONTH | N2GL_MONTH | ACCP | 6 | 0 | pathways - Month in Which Assignment Was Made | ||
41 | DUR_PLANNED | N2GL_DURATION_PLANNED | N2GL_DURATION | INT4 | 10 | 0 | pathways Duration of Pathway Processing (Days) | ||
42 | DUR_START2END | N2GL_DURATION_START2END | N2GL_DURATION | INT4 | 10 | 0 | pathways Duration from Start to End (Days) | ||
43 | .INCLUDE | 0 | 0 | Date and User for Insert, Change, Delete | |||||
44 | INSDATE | N2GL_INSDATE | N2GL_DATE | DATS | 8 | 0 | Created On | ||
45 | INSUSER | N2GL_INSUSER | N2GL_USER | CHAR | 12 | 0 | User who Created Data Record | ||
46 | UPDDATE | N2GL_UPDDATE | N2GL_DATE | DATS | 8 | 0 | Date on Which Record Was Last Changed | ||
47 | UPDUSER | N2GL_UPDUSER | N2GL_USER | CHAR | 12 | 0 | User who Last Changed Record | ||
48 | DELDATE | N2GL_DELDATE | N2GL_DATE | DATS | 8 | 0 | Date, on Which Deletion Indicator Was Set | ||
49 | DELUSER | N2GL_DELUSER | N2GL_USER | CHAR | 12 | 0 | User Who Set Deletion Indicator | ||
50 | DELFLAG | N2GL_DELFLAG | ISH_ON_OFF | CHAR | 1 | 0 | Deletion Indicator | ||
51 | RECALCULATED_ICON | N2GL_PATH_RECALCULATED_ICON | N2GL_ICON | CHAR | 66 | 0 | 'Patient Pathway Was Rescheduled' Icon | ||
52 | RECALCULATED_ICONNAME | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
53 | RECALCULATED_TXT | N2GL_PATH_RECALCULATED_TXT | DDTEXT | CHAR | 60 | 0 | Text 'Patient Pathway Was Rescheduled' | ||
54 | PATH_CURR_STATE_ICON | N2GL_PATH_CURR_STATE_ICON | N2GL_ICON | CHAR | 66 | 0 | 'Patient Pathway Status' Icon | ||
55 | PATH_CURR_STATE_ICONNAME | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
56 | PATH_CURR_STATE_TXT | N2GL_TM_STATE_TXT | DDTEXT | CHAR | 60 | 0 | 'Status of Patient Pathway' Text | ||
57 | PATH_DONE_STATE_ICON | N2GL_TM_DONE_STATE_ICON | N2GL_ICON | CHAR | 66 | 0 | 'Patient Pathway Completion Status' Icon | ||
58 | PATH_DONE_STATE_ICONNAME | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
59 | PATH_DONE_STATE_TXT | N2GL_TM_DONE_STATE_TXT | DDTEXT | CHAR | 60 | 0 | 'Patient Pathway Completion Status' Text | ||
60 | TODO_STATE | N2GL_PATHWAY_STATE | N2GL_PATHWAY_STATE | CHAR | 6 | 0 | Patient Path Status | ||
61 | TODO_STATE_ICON | N2GL_PATH_TODO_STATE_ICON | N2GL_ICON | CHAR | 66 | 0 | 'Open Steps on Patient Pathway' Icon | ||
62 | TODO_STATE_ICONNAME | ICONNAME | ICONNAME | CHAR | 30 | 0 | Name of an Icon | ||
63 | TODO_STATE_TXT | N2GL_PATH_TODO_STATE_TXT | DDTEXT | CHAR | 60 | 0 | 'Open Steps on Patient Pathway' Text | ||
64 | TODO_PROFESSIONS | N2GL_PROFESSIONS | TEXT100 | CHAR | 100 | 0 | Occupational Groups which Have Open Steps |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RN2GL_PATH_SCR | VDOC_ID | N2VD | VDKEY |
History
Last changed by/on | SAP | 20070917 |
SAP Release Created in | 600 |