SAP ABAP Table N2GL_ACT (pathways Activity)

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_ACT	Table Relationship Diagram
Short Description	pathways Activity

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	ACT_ID	☑	N2GL_ACT_ID	N2GL_ID	CHAR	32	0	i.s.h.med pathways Activity Key
3	PATH_ID	☐	N2GL_TM_ID	SYSUUID_C	CHAR	32	0	Patient Pathway Key
4	STEP_ID	☐	N2GL_STEP_ID	SYSUUID_C	CHAR	32	0	Step Key
5	GL_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
6	GL_VERSION_ID	☐	N2GL_GL_ID	SYSUUID_C	CHAR	32	0	Treatment Pathway ID
7	ORGID	☐	N2GL_ORGID	ORGID	CHAR	8	0	i.s.h.med pathways Organizational Unit	*
8	EMR	☐	N2GL_VMA	RI_KUNNR	CHAR	10	0	Employee Responsible	*
9	ACT_DATE	☐	N2GL_ACT_DATE	DATUM	DATS	8	0	Pathways: Date of Activity
10	ACT_TIME	☐	N2GL_ACT_TIME	UZEIT	TIMS	6	0	Pathways: Time of Activity
11	ACT_TYPE	☐	N2GL_ACT_TYP	N2CAT_CONT	CHAR	6	0	pathways Activity Type	TN2CATCONT
12	ACT_MCAT	☐	N2GL_ACT_MCAT	N2CAT_CAT	CHAR	6	0	pathways Main Category of Activity	*
13	ACT_CAT	☐	N2GL_ACT_CAT	N2CAT_CAT	CHAR	6	0	pathways Category of Activity	*
14	ACT_HAS_NOTE	☐	N2GL_ACT_HAS_NOTE	ISH_ON_OFF	CHAR	1	0	i.s.h.med pathways Notes Exist for Activity
15	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
16	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
17	ACT_UNDO	☐	N2GL_ACT_UNDO	ISH_ON_OFF	CHAR	1	0	i.s.h.med pathways Activity Was Undone
18	ACT_MONTH	☐	N2GL_ACT_MONTH	N2GL_MONTH	ACCP	6	0	pathways - Month in Which Activity Was Executed
19	.INCLUDE	☐				0	0	Date and User for Insert, Change, Delete
20	INSDATE	☐	N2GL_INSDATE	N2GL_DATE	DATS	8	0	Created On
21	INSUSER	☐	N2GL_INSUSER	N2GL_USER	CHAR	12	0	User who Created Data Record
22	UPDDATE	☐	N2GL_UPDDATE	N2GL_DATE	DATS	8	0	Date on Which Record Was Last Changed
23	UPDUSER	☐	N2GL_UPDUSER	N2GL_USER	CHAR	12	0	User who Last Changed Record
24	DELDATE	☐	N2GL_DELDATE	N2GL_DATE	DATS	8	0	Date, on Which Deletion Indicator Was Set
25	DELUSER	☐	N2GL_DELUSER	N2GL_USER	CHAR	12	0	User Who Set Deletion Indicator
26	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_ACT	ACT_TYPE	TN2CATCONT	CATCONT	REF

History

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