SAP ABAP Table N2GL_TM_SCHEDULE (pathways Patient Pathway)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ NMED_GL (Package) IS-H*MED: Treatment Pathways

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N2GL_TM_SCHEDULE	Table Relationship Diagram
Short Description	pathways Patient Pathway

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SCHEDULE_ID	☑	N2GL_TM_ID	SYSUUID_C	CHAR	32	0	Patient Pathway Key
3	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
4	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
5	TM_TITLE	☐	N2GL_TM_TITLE	TEXT40	CHAR	40	0	Title of Patient Pathway
6	TM_STATE	☐	N2GL_TM_STATE	N2GL_TM_STATE	CHAR	2	0	Status of Patient Pathway
7	TM_DONE_STATE	☐	N2GL_TM_DONE_STATE	N2GL_TM_DONE_STATE	CHAR	2	0	Patient Pathway Completion Status
8	STATE_MED_USE	☐	N2GL_MED_STATE	N2GL_MED_STATE	CHAR	2	0	Medical Status of Treatment Pathway
9	GL_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
10	SHORT_CODE	☐	N2GL_SHORT_CODE	N2GL_SHORT_CODE	CHAR	20	0	Abbreviation of Treatment Pathway
11	VERSION	☐	N2GL_VERSION	N2_VERS	NUMC	3	0	Version of Treatment Pathway
12	GL_VERSION_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
13	NEXT_TODO_DATE	☐	N2GL_NEXT_TODO_DATE		DATS	8	0	Date when next Step Is to Be Performed
14	NEXT_TODO_TIME	☐	N2GL_NEXT_TODO_TIME		TIMS	6	0	Time when Next Step Is to Be Performed
15	TIMEUNIT	☐	N2GL_TIMEUNIT	N2GL_TIMEUNIT	CHAR	2	0	Time Unit
16	PATH_IN_PAUSE	☐	N2GL_PATH_IN_PAUSE	ISH_ON_OFF	CHAR	1	0	Patient Pathway Is in Treatment Pause
17	VDOC_ID	☐	N2VD_KEY	N2VD_KEY	CHAR	20	0	PD: PD Key	N2VD
18	ASSIGN_FALNR	☐	N2GL_ASSIGN_FALNR	FALNR	CHAR	10	0	Case Number in Assignment of Pathway to Patient	*
19	ASSIGN_DATE	☐	N2GL_ASSIGN_DATE		DATS	8	0	Assignment Date of Pathway
20	ASSIGN_TIME	☐	N2GL_ASSIGN_TIME		TIMS	6	0	Assignment Time of Pathway
21	ASSIGN_EMR	☐	N2GL_VMA	RI_KUNNR	CHAR	10	0	Employee Responsible	*
22	STARTDATE	☐	N2GL_START_DATE		DATS	8	0	Start Date of Patient Pathway
23	STARTTIME	☐	N2GL_START_TIME		TIMS	6	0	Patient Pathway Start Time
24	PLAN_ENDDATE	☐	N2GL_PLAN_ENDDATE		DATS	8	0	Planned End Date of Patient Pathway
25	PLAN_ENDTIME	☐	N2GL_PLAN_ENDTIME		TIMS	6	0	Planned End Time of Patient Pathway
26	NEW_PLAN_ENDDATE	☐	N2GL_NEW_PLAN_ENDDATE		DATS	8	0	New Planned End Date of Patient Pathway
27	NEW_PLAN_ENDTIME	☐	N2GL_NEW_PLAN_ENDTIME		TIMS	6	0	New Planned End Time of Patient Pathway
28	ENDDATE	☐	N2GL_END_DATE		DATS	8	0	End Date of Patient Pathway
29	ENDTIME	☐	N2GL_END_TIME		TIMS	6	0	End Time of Patient Pathway
30	CANCEL_EMR	☐	N2GL_VMA	RI_KUNNR	CHAR	10	0	Employee Responsible	*
31	RECALCULATED	☐	N2GL_PATH_RECALCULATED	ISH_ON_OFF	CHAR	1	0	Patient Pathway Was Rescheduled
32	POSTPONED	☐	N2GL_PATH_POSTPONED	ISH_ON_OFF	CHAR	1	0	Patient Pathway Postponed
33	URL_ID	☐	N2GL_URL_ID	SYSUUID_C	CHAR	32	0	ID of URL
34	LAST_CHANGE	☐	N2GL_LAST_CHANGE	TZNTSTMPL	DEC	21	7	Time Stamp of Last Change
35	SEARCH_STRATEGY	☐	N2GL_SEARCH_STRATEGY	N2GL_SEARCH_STRATEGY	CHAR	1	0	i.s.h.med pathways Search Strategy
36	ASSIGN_ORGID	☐	N2GL_ASSIGN_ORGID	ORGID	CHAR	8	0	pathways Organizational Unit of Pathway Assignment	*
37	PATHWAYS_VERSION	☐	N2GL_PATHWAYS_VERSION	N2GL_PATHWAYS_VERSION	NUMC	3	0	pathways Version (Internal Use)
38	ASSIGN_YEAR	☐	N2GL_ASSIGN_YEAR	N2GL_YEAR	NUMC	4	0	pathways Year of Assignment of Pathway
39	ASSIGN_MONTH	☐	N2GL_ASSIGN_MONTH	N2GL_MONTH	ACCP	6	0	pathways - Month in Which Assignment Was Made
40	DUR_PLANNED	☐	N2GL_DURATION_PLANNED	N2GL_DURATION	INT4	10	0	pathways Duration of Pathway Processing (Days)
41	DUR_START2END	☐	N2GL_DURATION_START2END	N2GL_DURATION	INT4	10	0	pathways Duration from Start to End (Days)
42	.INCLUDE	☐				0	0	Date and User for Insert, Change, Delete
43	INSDATE	☐	N2GL_INSDATE	N2GL_DATE	DATS	8	0	Created On
44	INSUSER	☐	N2GL_INSUSER	N2GL_USER	CHAR	12	0	User who Created Data Record
45	UPDDATE	☐	N2GL_UPDDATE	N2GL_DATE	DATS	8	0	Date on Which Record Was Last Changed
46	UPDUSER	☐	N2GL_UPDUSER	N2GL_USER	CHAR	12	0	User who Last Changed Record
47	DELDATE	☐	N2GL_DELDATE	N2GL_DATE	DATS	8	0	Date, on Which Deletion Indicator Was Set
48	DELUSER	☐	N2GL_DELUSER	N2GL_USER	CHAR	12	0	User Who Set Deletion Indicator
49	DELFLAG	☐	N2GL_DELFLAG	ISH_ON_OFF	CHAR	1	0	Deletion Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N2GL_TM_SCHEDULE	VDOC_ID	N2VD	VDKEY

History

Last changed by/on	SAP	20070917
SAP Release Created in	472