SAP ABAP Table N2GL_TM_STEP (pathways Step of 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_STEP	Table Relationship Diagram
Short Description	pathways Step of 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	STEP_ID	☑	N2GL_STEP_ID	SYSUUID_C	CHAR	32	0	Step Key
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
5	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
6	GROUP_ID	☐	N2GL_GROUP_ID	SYSUUID_C	CHAR	32	0	Group ID
7	GROUP_NAME	☐	N2GL_TITLE_GROUP	N2GL_ITEM_TITLE	CHAR	80	0	Name of the Group
8	SEQUENCE_NUMBER	☐	N2GL_SEQUENCE_NUMBER	N2GL_SEQUENCE_NUMBER	INT4	10	0	Sequence Number
9	ITEM_ID	☐	N2GL_ITEM_ID	SYSUUID_C	CHAR	32	0	Item ID
10	STEP_STATE	☐	N2GL_STEP_STATE	N2GL_STEP_STATE	CHAR	2	0	Status of Step
11	STEP_NOTE_ID	☐	N2VD_KEY	N2VD_KEY	CHAR	20	0	PD: PD Key	N2VDNOTE
12	ANSWER_TEXT	☐	N2GL_ANSWER_TEXT	TEXT200	CHAR	200	0	Response Text
13	DURATION	☐	N2GL_DURATION		INT4	10	0	Duration
14	ROLE_ID	☐	N2GL_ROLE_ID	N1VORGANG	CHAR	4	0	pathways Responsibility ID	*
15	ROLE_TXT	☐	N2GL_ROLE_TXT	N1C030	CHAR	30	0	Responsibility
16	REASON_ID	☐	N2GL_NEWPLAN_REASON	CHAR3	CHAR	3	0	Reason for Rescheduling ID (Obsolete)
17	ITEMTYPE	☐	N2GL_ITEMTYPE	N2GL_ITEMTYPE	CHAR	2	0	Item Type
18	TM_NAME	☐	N2GL_STEP_NAME	N2GL_TM_NAME	CHAR	80	0	Name of a Step in Patient Pathway
19	PATH_RELEVANT	☐	N2GL_PATHRELEVANT	ISH_ON_OFF	CHAR	1	0	Pathway Relevance
20	ACTION_TYPE	☐	N2GL_ACTION_TYPE	N2GL_ACT_TYPE	CHAR	10	0	Action Type
21	BASE_ITEM_ID	☐	N2GL_BASEITEM_ID	SYSUUID_C	CHAR	32	0	Base Items: Base Item Internal Key
22	ACTION_EXECUTED	☐	N2GL_ACTION_EXECUTED	ISH_ON_OFF	CHAR	1	0	Action Was Executed
23	HAS_CORRESP_STEP	☐	N2GL_HAS_CORRESP	ISH_ON_OFF	CHAR	1	0	Step Has Connected Step
24	HAS_DEPEND_STEP	☐	N2GL_HAS_DEPENDENT	ISH_ON_OFF	CHAR	1	0	Step Is Dependent on Step
25	PLAN_DATE	☐	N2GL_PLAN_DATE		DATS	8	0	Step Planned Date (Original Planning)
26	PLAN_TIME	☐	N2GL_PLAN_TIME		TIMS	6	0	Step Planned Time (Original Planning)
27	NEW_PLAN_DATE	☐	N2GL_NEW_PLAN_DATE		DATS	8	0	Step Planned Date: Sequence Calculation
28	NEW_PLAN_TIME	☐	N2GL_NEW_PLAN_TIME		TIMS	6	0	Step Planned Time: Sequence Calculation
29	DONE_PLAN_DATE	☐	N2GL_DONE_PLAN_DATE		DATS	8	0	Planned Step Date on Processing
30	DONE_PLAN_TIME	☐	N2GL_DONE_PLAN_TIME		TIMS	6	0	Planned Step Time on Processing
31	DONE_DATE	☐	N2GL_DONE_DATE		DATS	8	0	Step Processing Date
32	DONE_TIME	☐	N2GL_DONE_TIME		TIMS	6	0	Step Processing Time
33	DONE_STATE	☐	N2GL_DONE_STATE	N2GL_DONE_STATE	CHAR	2	0	Completion Status of Step
34	EMR	☐	N2GL_VMA	RI_KUNNR	CHAR	10	0	Employee Responsible	*
35	UNPLANNED_STEP	☐	N2GL_STEP_UNPLANNED	ISH_ON_OFF	CHAR	1	0	Plan Time of Step not yet Determined
36	URL_ID	☐	N2GL_URL_ID	SYSUUID_C	CHAR	32	0	ID of URL
37	.INCLUDE	☐				0	0	Date and User for Insert, Change, Delete
38	INSDATE	☐	N2GL_INSDATE	N2GL_DATE	DATS	8	0	Created On
39	INSUSER	☐	N2GL_INSUSER	N2GL_USER	CHAR	12	0	User who Created Data Record
40	UPDDATE	☐	N2GL_UPDDATE	N2GL_DATE	DATS	8	0	Date on Which Record Was Last Changed
41	UPDUSER	☐	N2GL_UPDUSER	N2GL_USER	CHAR	12	0	User who Last Changed Record
42	DELDATE	☐	N2GL_DELDATE	N2GL_DATE	DATS	8	0	Date, on Which Deletion Indicator Was Set
43	DELUSER	☐	N2GL_DELUSER	N2GL_USER	CHAR	12	0	User Who Set Deletion Indicator
44	DELFLAG	☐	N2GL_DELFLAG	ISH_ON_OFF	CHAR	1	0	Deletion Indicator
45	LAST_CHANGE	☐	N2GL_LAST_CHANGE	TZNTSTMPL	DEC	21	7	Time Stamp of Last Change
46	ACTION_BEHAVIOR	☐	N2GL_ACTION_BEHAVIOR	N2GL_ACTION_BEHAVIOR	CHAR	2	0	Action Behavior When Confirming a Step
47	DIFF_PLAN_DONE	☐	N2GL_DIFFERENCE_PLAN_DONE	N2GL_DIFFERENCE	INT4	10	0	pathways Difference Completion Date/Original Date Planned

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N2GL_TM_STEP	STEP_NOTE_ID	N2VDNOTE	NOTEKEY

History

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