SAP ABAP Table N2GL_GUIDELINE (pathways Treatment 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_GUIDELINE	Table Relationship Diagram
Short Description	pathways Treatment Pathway

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_VERSION_ID	☑	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
3	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
4	GL_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
5	SHORT_CODE	☐	N2GL_SHORT_CODE	N2GL_SHORT_CODE	CHAR	20	0	Abbreviation of Treatment Pathway
6	VERSION	☐	N2GL_VERSION	N2_VERS	NUMC	3	0	Version of Treatment Pathway
7	TITLE_CLIN	☐	N2GL_TITLE	TEXT40	CHAR	40	0	Title of Treatment Pathway
8	TITLE_PAT	☐	N2GL_TITLE_PAT	TEXT40	CHAR	40	0	Title of Pathway in Patient Information
9	SHORT_DES	☐	N2GL_DESCR	N2GL_DESCR	CHAR	255	0	Description
10	STATE	☐	N2GL_STATE	N2GL_STATE	CHAR	2	0	Technical Status of Treatment Pathway
11	DES_ID_CLIN	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
12	DES_ID_PAT	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
13	DES_ID_TECH	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
14	DES_ID_SVG	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
15	URL_ID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
16	STATE_MED_USE	☐	N2GL_MED_STATE	N2GL_MED_STATE	CHAR	2	0	Medical Status of Treatment Pathway
17	VALID_FROM	☐	N2GL_VALID_FROM	N2GL_DATE	DATS	8	0	Start of Validity of Treatment Pathway
18	VALID_TO	☐	N2GL_VALID_TO	N2GL_DATE	DATS	8	0	End of Validity of Treatment Pathway
19	CHECK_DATE	☐	N2GL_CHECK_DATE	N2GL_DATE	DATS	8	0	Check Date of Treatment Pathway
20	CHECK_OVERDUE	☐	N2GL_OVERDUE	N2GL_OVERDUE	CHAR	4	0	Availability After Check Date
21	TIMEUNIT	☐	N2GL_TIMEUNIT	N2GL_TIMEUNIT	CHAR	2	0	Time Unit
22	IS_MODULE	☐	N2GL_MODULE	ISH_ON_OFF	CHAR	1	0	Use as Module
23	IS_PATHWAY	☐	N2GL_GL_USABLE	ISH_ON_OFF	CHAR	1	0	Use as Treatment Pathway
24	MODEL_TOOL_USED	☐	N2GL_MODELTOOL		CHAR	4	0	Editor for Creating Treatment Pathway
25	MODEL_TOOL_VERS	☐	N2GL_MODELTOOLV		CHAR	12	0	Version of Graphical Editor
26	IS_H_RELEASE	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
27	IS_H_LEVEL	☐	SAPPATCHLV	CHAR10	CHAR	10	0	Patch Level of a Software Component
28	USER_FIELD	☐	N2GL_USER_FIELD	N2GL_USER_FIELD	CHAR	32	0	Customer Parameter (free usage by customer)
29	DES_ID_AUTH	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
30	RESPONS_PERSON	☐	N2GL_REPONS_PERSON	N2GL_CONTACT_TEXT	CHAR	40	0	Person Responsible for Content
31	CONTACT_PERSON	☐	N2GL_CONTACT_PERSON	N2GL_CONTACT_TEXT	CHAR	40	0	Contact Person
32	CONTACT_PHONE	☐	N2GL_CONTACT_PHONE	N2GL_PHONE	CHAR	30	0	Telephone Number of Contact Person
33	CONTACT_EMAIL	☐	N2GL_CONTACT_EMAIL	N2GL_EMAIL	CHAR	255	0	E-Mail Address of Contact Partner
34	KEYWORD_A	☐	N2GL_KEYWORD	N2GL_KEYWORD	CHAR	40	0	Keyword	TN2GL_KEYWORD
35	KEYWORD_B	☐	N2GL_KEYWORD	N2GL_KEYWORD	CHAR	40	0	Keyword	TN2GL_KEYWORD
36	GRAPH_CHECKED	☐	N2GL_VALID_GRAPH	ISH_ON_OFF	CHAR	1	0	Validity of Clinical Algorithm
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	PAT_UNIQUE	☐	N2GL_PATIENT_UNIQUE	ISH_ON_OFF	CHAR	1	0	Pathways: Unique Indicator for Patient
46	CATSET_ID	☐	N2CAT_SET	N2CAT_SET	CHAR	6	0	Categories: Category Set Key	TN2CATSET
47	ACTIVE_CHANGED	☐	N2GL_ACTIVE_CHANGED	ISH_ON_OFF	CHAR	1	0	Treatment Pathway Changed After Activation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N2GL_GUIDELINE	CATSET_ID	TN2CATSET	CATSET_ID	KEY
2	N2GL_GUIDELINE	EINRI	TN01	EINRI	REF	1	CN
3	N2GL_GUIDELINE	KEYWORD_A	TN2GL_KEYWORD	KEYWORD
4	N2GL_GUIDELINE	KEYWORD_B	TN2GL_KEYWORD	KEYWORD
5	N2GL_GUIDELINE	MANDT	T000	MANDT

History

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