SAP ABAP Table N1VKG (IS-H: Item of Clinical Order (Preregistration))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N1VKG	Table Relationship Diagram
Short Description	IS-H: Item of Clinical Order (Preregistration)

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	T000
2	VKGID	☑	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
3	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
4	ORGID	☐	N1PRGTROU	ORGID	CHAR	8	0	Treatment Unit in Preregistration	NORG
5	ANFTY	☐	ANFTY	ANFTY	CHAR	6	0	Request Type	N1ANFTYP
6	ETRBY	☐	NPRGETRBY	NPRGETRBY	CHAR	1	0	IS-H: Preregistration Initiated By
7	ETROE	☐	N1ETROE	ORGID	CHAR	8	0	Initiating Organizational Unit	NORG
8	ETRGP	☐	NPRGETRGP	RI_KUNNR	CHAR	10	0	IS-H: Initiating Employee/Business Partner	NGPA
9	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
10	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
11	KANAM	☐	N1VKANAM	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Short Anamnesis in Clinical Order
12	KALTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
13	DITXT	☐	N1VKDIA	TEXT50	CHAR	50	0	IS-H: Preregistration Diagnosis
14	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
15	EARNR	☐	N1EARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician	NGPA
16	WUZPI	☐	N1ZPI_INT	N1ZPI_INT	CHAR	2	0	Time Interpretation - Internal Format
17	WUMNT	☐	N1WUMNT	N1MONAT	CHAR	2	0	Desired Time (Month)
18	WUJHR	☐	N1WUJHR	N1C004	CHAR	4	0	Desired Time (Year)
19	PBGDT	☐	N1VKPDT	DATS	DATS	8	0	IS-H: Planned Date of Preregistration
20	PBZT	☐	N1VKPZT	UHRZT	TIMS	6	0	IS-H: Planned Time of Preregistration
21	BMVKG	☐	N1BMVKG	TEXT50	CHAR	50	0	IS-H: Comment for Preregistration
22	BMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
23	AFNDT	☐	N1AFNDT	RI_DATUM	DATS	8	0	Expected Admission Date
24	AFNOE	☐	N1AFNOE	ORGID	CHAR	8	0	Organizational Unit to which Patient Is Admitted	NORG
25	WLPRI	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management	TN14P
26	PVPAT	☐	N1PVPAT	XFELD	CHAR	1	0	IS-H: Preregistered as Private Patient
27	WLTYP	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List	TN42A
28	WLREM	☐	ISH_WLSTREMO	XFELD	CHAR	1	0	IS-H: Preregistration Status "Inactive" Indicator
29	WLRDT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
30	WLRRN	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List	TN42B
31	WLSTA	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status	TN42C
32	WLHSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital	*
33	WLADT	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
34	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
35	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
36	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
37	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
38	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
39	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
40	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
41	STOID	☐	N1STOID_PRG	N1STOID	CHAR	3	0	IS-H: Cancellation Reason for Preregistration	N1STGR
42	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
43	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number	NPAP
44	EXTKH	☐	N1EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Referring Hospital	NGPA
45	UARNR	☐	N1UARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician (Outpatients)	NGPA
46	HARNR	☐	N1HARNR	RI_KUNNR	CHAR	10	0	IS-H: Family Physician	NGPA
47	ORGFA	☐	N1VKGFA	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit in Preregistration	*
48	BEWAR	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
49	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	*
50	AUFDS	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
51	RFSRC	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type	TN14H
52	AUSPR	☐	N1PRGAUSPR	N1PRGAUSPR	CHAR	8	0	IS-H: CORD/PREG: Specification of the Clinical Order
53	PRTID	☐	NPRTID	CHAR10	CHAR	10	0	IS-H: Preregistration Type Identification	NPRT
54	PRGNR	☐	NPRGNR	NPRGNR	CHAR	10	0	IS-H: Preregistration Number
55	ICPMK	☐	ICPM_ID	TARID	CHAR	2	0	IS-H: Identification of Surgical Procedure Coding Catalog	*
56	ICPML	☐	ICPM_LS	TARLS	CHAR	10	0	IS-H: Surgical Procedure Code (Service)	*
57	TRDRN	☐	ISH_APTIME_PDF	ISH_DZEIT	NUMC	4	0	IS-H: Default Duration for a Treatment Appointment
58	TRDRNX	☐	ISH_APTIME_MAN	XFELD	CHAR	1	0	IS-H: Duration of Treatment Appt Changed Manually
59	TROOM	☐	ISH_TR_ROOM_PDF	BAUID	CHAR	8	0	IS-H: Default Room for a Treatment Appointment	NBAU
60	TROOMX	☐	ISH_TR_ROOM_MAN	XFELD	CHAR	1	0	IS-H: Room for Treatment Appointment Changed Manually
61	USER1	☐	ISH_PREGUSER1	ISH_PREGUSER1	CHAR	20	0	IS-H: User-Defined Field 1
62	USER2	☐	ISH_PREGUSER2	ISH_PREGUSER2	CHAR	20	0	IS-H: User-Defined Field 2
63	USER3	☐	ISH_PREGUSER3	ISH_PREGUSER3	DATS	8	0	IS-H: User-Defined Field 3
64	USER4	☐	ISH_PREGUSER4	ISH_PREGUSER4	DATS	8	0	IS-H: User-Defined Field 4
65	USER5	☐	ISH_PREGUSER5	ISH_PREGUSER5	CHAR	50	0	IS-H: User-Defined Field 5
66	USER6	☐	ISH_PREGUSER6	ISH_PREGUSER6	CHAR	1	0	IS-H: User-Defined Field 6
67	USER7	☐	ISH_PREGUSER7	ISH_PREGUSER7	CHAR	1	0	IS-H: User-Defined Field 7
68	CORDERID	☐	N1CORDID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of a Clinical Order
69	POSNR	☐	N1CORDPOSNR	N1POSNR	NUMC	3	0	Clinical Order Item Number
70	APCNID	☐	N1APCNID	SYSUUID_C	CHAR	32	0	IS-H: Identification of an Appointment Template
71	CORDTYPID	☐	N1COTID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of the Clinical Order Type
72	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
73	PREREG	☐	N1CORDPREREG	ISH_ON_OFF	CHAR	1	0	IS-H: CORD/PREG: Clinical Order Preregistered
74	TRTBY	☐	N1CORDTRTBY	N1CORDTRTBY	CHAR	1	0	IS-H: CORD/PREG: Clinical Order Filled By
75	TRTOE	☐	N1CORDTRTOE	ORGID	CHAR	8	0	IS-H: CORD/PREG: Order Filler (Org. Unit)	*
76	TRTGP	☐	N1CORDTRTGP	RI_KUNNR	CHAR	10	0	Filler (Business Partner)	*
77	BEKATX	☐	N1CORDBEKAT_MAN	XFELD	CHAR	1	0	IS-H: Treatment Category Changed Manually
78	TPAE	☐	N1TPAE	N1TPAE	CHAR	2	0	Transport Type	*
79	ERTIM	☐	ISH_ERTIM	UHRZT	TIMS	6	0	IS-H: Time when Data Record Created
80	UPTIM	☐	ISH_UPTIM	UHRZT	TIMS	6	0	IS-H: Time Data Record was Last Changed
81	STTIM	☐	ISH_STORN_TIM	UHRZT	TIMS	6	0	Time of Cancellation
82	REQCOMPID	☐	N1REQCOMPID	N1REQCOMPID	NUMC	8	0	IS-H: CORD/PREG: Identification of a Request in CORD
83	REQCOMPNR	☐	N1REQCOMPNR	N1REQCOMPNR	CHAR	8	0	IS-H: CORD/PREG: Request Number in Clinical Order
84	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
85	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
86	CORDPTYPID	☐	N1COTID_PROF	SYSUUID_C	CHAR	32	0	Identification of a Profile Type
87	NOCORDPTYP	☐	NOCORDPTYP		NUMC	2	0	Item Number of Profile Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N1VKG	AFNOE	NORG	ORGID	REF	C	CN
2	N1VKG	ANFTY	N1ANFTYP	ANFTY	KEY	1	CN
3	N1VKG	EARNR	NGPA	GPART	REF	C	CN
4	N1VKG	EINRI	TN01	EINRI	KEY	1	CN
5	N1VKG	ETRGP	NGPA	GPART	REF	1	CN
6	N1VKG	ETROE	NORG	ORGID	REF	1	CN
7	N1VKG	EXTKH	NGPA	GPART	KEY	1	CN
8	N1VKG	FALNR	NFAL	FALNR	REF	C	CN
9	N1VKG	FATYP	TN15C	CASETY	KEY	1	CN
10	N1VKG	HARNR	NGPA	GPART	KEY	1	CN
11	N1VKG	MANDT	T000	MANDT	KEY	1	CN
12	N1VKG	ORGID	NORG	ORGID	KEY	1	CN
13	N1VKG	PAPID	NPAP	PAPID	REF	C	CN
14	N1VKG	PATNR	NPAT	PATNR	REF	C	CN
15	N1VKG	PRTID	NPRT	PRTID	KEY	1	CN
16	N1VKG	RFSRC	TN14H	REFSRC	KEY	C	CN
17	N1VKG	STOID	N1STGR	STOID	REF	1	CN
18	N1VKG	TROOM	NBAU	BAUID	REF	1	CN
19	N1VKG	UARNR	NGPA	GPART	KEY	1	CN
20	N1VKG	WLPRI	TN14P	WLPRI	REF	C	CN
21	N1VKG	WLRRN	TN42B	WLRRN	REF	C	CN
22	N1VKG	WLSTA	TN42C	WLSTA	REF	C	CN
23	N1VKG	WLTYP	TN42A	WLTYP	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in