SAP ABAP Table RN1PO_CORDER (IS-H*Med: Patient Organizer Structure CORDER + VKG)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED-MRO (Application Component) Medical Patient Data Organization (Patient Organizer)
     ⤷ N1PORG_MED (Package) IS-H*MED: Patient Organizer

Basic Data

Table Category	INTTAB	Structure
Structure	RN1PO_CORDER	Table Relationship Diagram
Short Description	IS-H*Med: Patient Organizer Structure CORDER + VKG

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

History

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