SAP ABAP Table RN2GL_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	INTTAB	Structure
Structure	RN2GL_GUIDELINE	Table Relationship Diagram
Short Description	Pathways: Treatment Pathway

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 Treatment Pathway
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GL_VERSION_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	GL_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
6	SHORT_CODE	☐	N2GL_SHORT_CODE	N2GL_SHORT_CODE	CHAR	20	0	Abbreviation of Treatment Pathway
7	VERSION	☐	N2GL_VERSION	N2_VERS	NUMC	3	0	Version of Treatment Pathway
8	TITLE_CLIN	☐	N2GL_TITLE	TEXT40	CHAR	40	0	Title of Treatment Pathway
9	TITLE_PAT	☐	N2GL_TITLE_PAT	TEXT40	CHAR	40	0	Title of Pathway in Patient Information
10	SHORT_DES	☐	N2GL_DESCR	N2GL_DESCR	CHAR	255	0	Description
11	STATE	☐	N2GL_STATE	N2GL_STATE	CHAR	2	0	Technical Status of Treatment Pathway
12	DES_ID_CLIN	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
13	DES_ID_PAT	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
14	DES_ID_TECH	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
15	DES_ID_SVG	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
16	URL_ID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
17	STATE_MED_USE	☐	N2GL_MED_STATE	N2GL_MED_STATE	CHAR	2	0	Medical Status of Treatment Pathway
18	VALID_FROM	☐	N2GL_VALID_FROM	N2GL_DATE	DATS	8	0	Start of Validity of Treatment Pathway
19	VALID_TO	☐	N2GL_VALID_TO	N2GL_DATE	DATS	8	0	End of Validity of Treatment Pathway
20	CHECK_DATE	☐	N2GL_CHECK_DATE	N2GL_DATE	DATS	8	0	Check Date of Treatment Pathway
21	CHECK_OVERDUE	☐	N2GL_OVERDUE	N2GL_OVERDUE	CHAR	4	0	Availability After Check Date
22	TIMEUNIT	☐	N2GL_TIMEUNIT	N2GL_TIMEUNIT	CHAR	2	0	Time Unit
23	IS_MODULE	☐	N2GL_MODULE	ISH_ON_OFF	CHAR	1	0	Use as Module
24	IS_PATHWAY	☐	N2GL_GL_USABLE	ISH_ON_OFF	CHAR	1	0	Use as Treatment Pathway
25	MODEL_TOOL_USED	☐	N2GL_MODELTOOL		CHAR	4	0	Editor for Creating Treatment Pathway
26	MODEL_TOOL_VERS	☐	N2GL_MODELTOOLV		CHAR	12	0	Version of Graphical Editor
27	IS_H_RELEASE	☐	SAPRELEASE	CHAR10	CHAR	10	0	SAP Release
28	IS_H_LEVEL	☐	SAPPATCHLV	CHAR10	CHAR	10	0	Patch Level of a Software Component
29	USER_FIELD	☐	N2GL_USER_FIELD	N2GL_USER_FIELD	CHAR	32	0	Customer Parameter (free usage by customer)
30	DES_ID_AUTH	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
31	RESPONS_PERSON	☐	N2GL_REPONS_PERSON	N2GL_CONTACT_TEXT	CHAR	40	0	Person Responsible for Content
32	CONTACT_PERSON	☐	N2GL_CONTACT_PERSON	N2GL_CONTACT_TEXT	CHAR	40	0	Contact Person
33	CONTACT_PHONE	☐	N2GL_CONTACT_PHONE	N2GL_PHONE	CHAR	30	0	Telephone Number of Contact Person
34	CONTACT_EMAIL	☐	N2GL_CONTACT_EMAIL	N2GL_EMAIL	CHAR	255	0	E-Mail Address of Contact Partner
35	KEYWORD_A	☐	N2GL_KEYWORD	N2GL_KEYWORD	CHAR	40	0	Keyword	TN2GL_KEYWORD
36	KEYWORD_B	☐	N2GL_KEYWORD	N2GL_KEYWORD	CHAR	40	0	Keyword	TN2GL_KEYWORD
37	GRAPH_CHECKED	☐	N2GL_VALID_GRAPH	ISH_ON_OFF	CHAR	1	0	Validity of Clinical Algorithm
38	.INCLUDE	☐				0	0	Date and User for Insert, Change, Delete
39	INSDATE	☐	N2GL_INSDATE	N2GL_DATE	DATS	8	0	Created On
40	INSUSER	☐	N2GL_INSUSER	N2GL_USER	CHAR	12	0	User who Created Data Record
41	UPDDATE	☐	N2GL_UPDDATE	N2GL_DATE	DATS	8	0	Date on Which Record Was Last Changed
42	UPDUSER	☐	N2GL_UPDUSER	N2GL_USER	CHAR	12	0	User who Last Changed Record
43	DELDATE	☐	N2GL_DELDATE	N2GL_DATE	DATS	8	0	Date, on Which Deletion Indicator Was Set
44	DELUSER	☐	N2GL_DELUSER	N2GL_USER	CHAR	12	0	User Who Set Deletion Indicator
45	DELFLAG	☐	N2GL_DELFLAG	ISH_ON_OFF	CHAR	1	0	Deletion Indicator
46	PAT_UNIQUE	☐	N2GL_PATIENT_UNIQUE	ISH_ON_OFF	CHAR	1	0	Pathways: Unique Indicator for Patient
47	CATSET_ID	☐	N2CAT_SET	N2CAT_SET	CHAR	6	0	Categories: Category Set Key	TN2CATSET
48	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	RN2GL_GUIDELINE	CATSET_ID	TN2CATSET	CATSET_ID	KEY
2	RN2GL_GUIDELINE	EINRI	TN01	EINRI	REF	1	CN
3	RN2GL_GUIDELINE	KEYWORD_A	TN2GL_KEYWORD	KEYWORD
4	RN2GL_GUIDELINE	KEYWORD_B	TN2GL_KEYWORD	KEYWORD
5	RN2GL_GUIDELINE	MANDT	T000	MANDT

History

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