SAP ABAP Table RNWP_PREREG_LIST (IS-H: Field Catalog Prereg./Waiting List (View Type 010))

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	INTTAB	Structure
Structure	RNWP_PREREG_LIST	Table Relationship Diagram
Short Description	IS-H: Field Catalog Prereg./Waiting List (View Type 010)

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	CORDERID	☐	N1CORDID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of a Clinical Order
2	VKGID	☑	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
3	PRGNR	☐	NPRGNR	NPRGNR	CHAR	10	0	IS-H: Preregistration Number
4	PRTSN	☐	N1COTTSN	TEXT10	CHAR	10	0	Clinical Order Type Short Name
5	PRTNM	☐	N1COTTNAME	TEXT30	CHAR	30	0	IS-H: CORD/PREG: Clinical Order Type Name
6	PNAMEC	☐	ISH_PNAMEC	TEXT50	CHAR	50	0	IS-H: Compound Patient Name
7	PNAMEC1	☐	ISH_NAME_SEX_AGE	TEXT50	CHAR	50	0	IS-H: Output String 'Patient Name, Sex and Age'
8	GSCHLE	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	*
9	AGEPAT	☐	ISH_AGE	ISH_AGE	INT2	5	0	IS-H: Patient Age
10	NO_TC_ICON	☐	ISH_NO_TC_ICON	TEXT50	CHAR	50	0	Symbol 'Treatment Authorization Not Issued for Patient/Case'
11	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number	*
12	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
13	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
14	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
15	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	*
16	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
17	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
18	FALARE	☐	FALLARTE	FALLARTE	CHAR	1	0	IS-H: Case Type - User-Specific	*
19	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	*
20	FATYPTXT	☐	ISH_CASETYPETXT	TEXT25	CHAR	25	0	IS-H: Text for Case Category
21	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
22	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
23	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
24	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
25	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
26	GBNAMS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
27	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
28	TELNR	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
29	PVPAT	☐	N1PVPAT	XFELD	CHAR	1	0	IS-H: Preregistered as Private Patient
30	PRIVP_ICON	☐	ISH_PRIVP_ICON	TEXT50	CHAR	50	0	IS-H: "Private Patient" Icon
31	IPID1	☐	ISH_IPID	ISH_IPID	CHAR	12	0	Health Insurer Number in Insurance Relationship
32	IPID2	☐	ISH_IPID	ISH_IPID	CHAR	12	0	Health Insurer Number in Insurance Relationship
33	KNAME1	☐	ISH_IPNA_PROV	TEXT70	CHAR	70	0	IS-H: Insurance Relationship - Name of Health Insurer
34	KNAME2	☐	ISH_IPNA_PROV	TEXT70	CHAR	70	0	IS-H: Insurance Relationship - Name of Health Insurer
35	VZUZA	☐	ISH_VZUZAH	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer/Copayer Ins. Relatshp
36	ORGFA	☐	N1VKGFA	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit in Preregistration	*
37	ORGFAKB	☐	ISH_PATOKF	TEXT12	CHAR	12	0	IS-H: Short Text for Patient's Current Dept. Org. Unit
38	TRAPPOU	☐	ISH_ATTOU	ORGID	CHAR	8	0	Treatment Organizational Unit	*
39	TRAPPOUSN	☐	ISH_ATTOU_SN	TEXT12	CHAR	12	0	IS-H: Short Name of Treatment Organizational Unit
40	TRAPPD	☐	N1_APP_DATE	DATE	DATS	8	0	IS-H: Surgery/Treatment Appointment - Date
41	TRAPPT	☐	N1_APP_TIME	UHRZT	TIMS	6	0	IS-H: Surgery/Treatment Appointment - Time
42	TRAPPRO	☐	ISH_TREATM_ROOM	BAUID	CHAR	8	0	IS-H: Treatment Room	*
43	TRAPPROSN	☐	ISH_TREATM_ROOM_SN	TEXT12	CHAR	12	0	IS-H: Short Name of Treatment Room
44	ATTPERS	☐	ISH_ATTPERS	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of the Attending Person	*
45	ATTPERSN	☐	ISH_APERSC	TEXT50	CHAR	50	0	IS-H: Compound Name of Attending Person
46	TRAPPPT	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	*
47	TRAPPPTNA	☐	ISH_DTXT	TEXT15	CHAR	15	0	IS-H: Text for Scheduling Type
48	TRAPPDR	☐	ISH_APTIME	ISH_DZEIT	NUMC	4	0	IS-H: Duration in Minutes for Treatment Appointment
49	ADAPPOU	☐	ISH_ADAPPOU	ORGID	CHAR	8	0	IS-H: Admitting OU (Care Unit)	*
50	ADAPPOUSN	☐	ISH_ADAPPOU_SN	TEXT12	CHAR	12	0	IS-H: Short Name of Admitting OU (Care Unit)
51	ADAPPPT	☐	N1PTINP	ISH_DSPTC8	CHAR	8	0	IS-H: Inpatient Scheduling Type	*
52	ADAPPPTNA	☐	N1PTINT	N1PTINT	CHAR	15	0	Description of Scheduling Type for Inpatient Appointments
53	ADAPPD	☐	N1_ARR_APP_DATE	DATE	DATS	8	0	IS-H: Admission Appointment - Date
54	ADAPPT	☐	N1_ARR_APP_TIME	UHRZT	TIMS	6	0	IS-H: Admission Appointment - Time
55	ADAPPR	☐	ISH_ADAPPR	BAUID	CHAR	8	0	IS-H: Planned Room for Inpatient Preregistration	*
56	ADAPPRSD	☐	ISH_ADAPPRSD	CHAR8	CHAR	8	0	IS-H: Room Identifier for Inpatient Preregistration
57	ADAPPB	☐	ISH_ADAPPB	BAUID	CHAR	8	0	IS-H: Planned Bed for Inpatient Preregistration	*
58	ADAPPBSD	☐	ISH_ADAPPBSD	CHAR8	CHAR	8	0	IS-H: Bed Identifier for Inpatient Preregistration
59	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
60	BWATX	☐	BEWARTXT	TEXT15	CHAR	15	0	IS-H: Text for Movement Type
61	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	*
62	BEKTX	☐	BK_BKTXT	TEXT15	CHAR	15	0	IS-H: Short Text for Treatment Category
63	ETROE	☐	N1ETROE	ORGID	CHAR	8	0	Initiating Organizational Unit	*
64	ETRMA	☐	NPRGETRGP	RI_KUNNR	CHAR	10	0	IS-H: Initiating Employee/Business Partner	*
65	ETRMANA	☐	NPRGETRGPNM	TEXT50	CHAR	50	0	IS-H: Preregistration: Name of Initiating Employee/Bus.Part.
66	KANAM	☐	N1VKANAM	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Short Anamnesis in Clinical Order
67	KALTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
68	DITXT	☐	N1VKDIA	TEXT50	CHAR	50	0	IS-H: Preregistration Diagnosis
69	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
70	WUZPE	☐	ISH_ZPIE	N1ZPIE	CHAR	5	0	IS-H: Desired Treatment Time
71	WZRFG	☐	N1ZPIRFG	NUMC2	NUMC	2	0	Sequence of Time Interpretation
72	WUMNT	☐	N1WUMNT	N1MONAT	CHAR	2	0	Desired Time (Month)
73	WUMNTT	☐	ISH_WUMNT_TXT	TEXT10	CHAR	10	0	IS-H: Desired Month (Name of Month)
74	WUJHR	☐	N1WUJHR	N1C004	CHAR	4	0	Desired Time (Year)
75	WDATE	☐	N1APCNWDATE		DATS	8	0	Desired Date
76	WTIME	☐	N1APCNWTIME		TIMS	6	0	Desired Time
77	BMVKG	☐	N1BMVKG	TEXT50	CHAR	50	0	IS-H: Comment for Preregistration
78	BMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
79	WLPRI	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management	*
80	WLPRIT	☐	ISH_PRITXT	TEXT15	CHAR	15	0	IS-H: Text for Priority
81	WLTYP	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List
82	WLTYPT	☐	ISH_WLTYPETX	TEXT25	CHAR	25	0	IS-H: Text for Waiting List
83	WLTIME	☐	ISH_WLDUR	NUMC04	NUMC	4	0	IS-H: Wait Time (in Days) for Waiting List Management
84	VKGST	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status
85	VKGSTT	☐	ISH_WLSTATTX	TEXT20	CHAR	20	0	IS-H: Text for Preregistration Status
86	WLRDT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
87	WLRRN	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List
88	WLRRNT	☐	ISH_WLRRSNTX	TEXT60	CHAR	60	0	IS-H: Text for Reason for Removal From Waiting List
89	WLHSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital	*
90	WLHSPN	☐	ISH_WLHOSPN	TEXT50	CHAR	50	0	IS-H: Name of Postdischarge Hospital
91	WLADT	☐	ISH_WLADMDT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
92	ABSBDT	☑	ISH_ABSBDT	DATE	DATS	8	0	IS-H: Start Date of Waiting List Absence
93	ABSEDT	☐	ISH_ABSEDT	DATE	DATS	8	0	IS-H: End Date of Waiting List Absence
94	ABSRSN	☐	ISH_ABSRSN	ISH_ABSRSN	CHAR	3	0	IS-H: Reason for Temporary Absence From Waiting List
95	ABSRST	☐	ISH_ABSRSNTX	TEXT30	CHAR	30	0	IS-H: Text Describing Reason for Absence From Waiting List
96	RFSRC	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type	*
97	RFSRCT	☐	ISH_REFTXT	TEXT15	CHAR	15	0	Is-H: Text for Referral, Postdischarge Treatment Type
98	EXTKH	☐	N1EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Referring Hospital	*
99	EXTKHN	☐	N1EKNAM	TEXT50	CHAR	50	0	IS-H: Name of Referring Hospital
100	HARNR	☐	N1HARNR	RI_KUNNR	CHAR	10	0	IS-H: Family Physician	*
101	HANAM	☐	N1HANAM	TEXT50	CHAR	50	0	IS-H: Name of Family Physician
102	EUGPA	☐	N1UEGPA	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician or Hospital	*
103	EUGPN	☐	N1UEGPN	TEXT50	CHAR	50	0	IS-H: Name of Referring Physician or Hospital
104	AUFDS	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
105	VKINF	☐	N1VKINF	TEXT75	CHAR	75	0	Addtl Info for Prereg.
106	CORDTITLE	☐	N1CORDTITLE	N1CORDTITLE	CHAR	30	0	IS-H: CORD/PREG: Title of Clinical Order
107	RCKRUF	☐	N1CORDRCKRUF	N1CORDRCKRUF	CHAR	30	0	Clinical Order - Callback Number
108	FRAGE	☐	N1CORDFRAGE	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Questions
109	FRLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
110	CXTYPSN1	☐	NCXTYPSN	TEXT15	CHAR	15	0	IS-H: Context Identifier
111	CXTYPSN2	☐	ISH_CXTYPSN2	TEXT15	CHAR	15	0	IS-H: Identifier for Context 2
112	CXTYPSN3	☐	ISH_CXTYPSN3	TEXT15	CHAR	15	0	IS-H: Identifier for Context 3
113	CXTYPNM1	☐	NCXTYPNM	TEXT30	CHAR	30	0	IS-H: Name of Context
114	CXTYPNM2	☐	ISH_CXTYPNM2	TEXT30	CHAR	30	0	IS-H: Text Context 2
115	CXTYPNM3	☐	ISH_CXTYPNM3	TEXT30	CHAR	30	0	IS-H: Text Context 3
116	CXSTANM1	☐	NCXSTANM	TEXT20	CHAR	20	0	IS-H: Name of Context Status
117	CXSTANM2	☐	ISH_CXSTANM2	TEXT20	CHAR	20	0	IS-H: Text Context Status 2
118	CXSTANM3	☐	ISH_CXSTANM3	TEXT20	CHAR	20	0	IS-H: Text Context Status 3
119	CXSICON1	☐	NCXSICON	ICON	CHAR	4	0	IS-H: Icon for Context Status	*
120	CXSICON2	☐	ISH_CXSICON2	ICONNAME	CHAR	30	0	IS-H: Icon for Context Status 2
121	CXSICON3	☐	ISH_CXSICON3	ICONNAME	CHAR	30	0	IS-H: Icon for Context Status 3
122	CXVALD1	☐	NCXVALD	DATE	DATS	8	0	IS-H: Expiry Date of Findings in the Context
123	CXVALD2	☐	ISH_CXVALD2	DATE	DATS	8	0	IS-H: Expiry Date of Findings in Context 2
124	CXVALD3	☐	ISH_CXVALD3	DATE	DATS	8	0	IS-H: Expiry Date of Findings in Context 3
125	DIATXT	☐	ISH_DIATXT_PREREG	TEXT200	CHAR	200	0	IS-H: Diagnosis Texts in Preregistration List
126	ICPMC	☐	ISH_ICPMC_PREREG	TEXT80	CHAR	80	0	IS-H: Procedure Codes in Preregistration List
127	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
128	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
129	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
130	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
131	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
132	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
133	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
134	STOID	☐	N1STOID_PRG	N1STOID	CHAR	3	0	IS-H: Cancellation Reason for Preregistration	*
135	STOSN	☐	N1STOTX	N1C015	CHAR	15	0	Text for Cancellation Reason
136	USER1	☐	ISH_PREGUSER1	ISH_PREGUSER1	CHAR	20	0	IS-H: User-Defined Field 1
137	USER2	☐	ISH_PREGUSER2	ISH_PREGUSER2	CHAR	20	0	IS-H: User-Defined Field 2
138	USER3	☐	ISH_PREGUSER3	ISH_PREGUSER3	DATS	8	0	IS-H: User-Defined Field 3
139	USER4	☐	ISH_PREGUSER4	ISH_PREGUSER4	DATS	8	0	IS-H: User-Defined Field 4
140	USER5	☐	ISH_PREGUSER5	ISH_PREGUSER5	CHAR	50	0	IS-H: User-Defined Field 5
141	USER6	☐	ISH_PREGUSER6	ISH_PREGUSER6	CHAR	1	0	IS-H: User-Defined Field 6
142	USER7	☐	ISH_PREGUSER7	ISH_PREGUSER7	CHAR	1	0	IS-H: User-Defined Field 7
143	CT	☐	LVC_T_DRDR		TTYP	0	0
144	CO	☐	LVC_T_SCOL		TTYP	0	0
145	.INCLUDE	☐				0	0	IS-H*MED: Field Catalog Preregistration List (View Type 10)
146	AFNOEAKT	☐	N1AFNOEAKT	ORGID	CHAR	8	0	Current Admitting Organizational Unit	*
147	VISOEAKT	☐	N1VISOEAKT	ORGID	CHAR	8	0	OU of Current Visit	*
148	AFNOEAKT_KB	☐	N1AFNOEAKT_KB	TEXT12	CHAR	12	0	Admitting Org. Unit Current (Short Description)
149	VISOEAKT_KB	☐	N1VISOEAKT_KB	TEXT12	CHAR	12	0	OU of Current Visit (Short Description)
150	AFNOEAKT_K	☐	N1AFNOEAKT_K	ORGKZ	CHAR	5	0	Admitting Org. Unit Current (Identifier)
151	VISOEAKT_K	☐	N1VISOEAKT_K	ORGKZ	CHAR	5	0	OU of Current Visit (Identifier)
152	ICON_ANF	☐	N1ANFV_ICON	TEXT50	CHAR	50	0	Clinical Orders/Requests Exist (Icon)
153	ICON_DOC	☐	N1DOKV_ICON	TEXT50	CHAR	50	0	Document Exists (Icon)
154	MEDDOK_ICON	☐	N1MEDDOKV_ICON	TEXT50	CHAR	50	0	Medical Document Exists (Icon)
155	LABDOK_ICON	☐	N1LABDOKV_ICON	TEXT50	CHAR	50	0	Laboratory Document Exists (Icon)
156	VKLEI	☐	N1VKLEI	CHAR75	CHAR	75	0	Services
157	LKTAR	☐	N1LKPTARID	TARID	CHAR	2	0	Service Group - Catalog Identification	*
158	LKLST	☐	N1LKPTARLS	TARLS	CHAR	10	0	Service Group - Identification	*
159	LKBEZ	☐	N1LKPTARKTXT1	LEIKTXT	CHAR	40	0	First Service Text of Service
160	VKLEIBEZ	☐	N1VKLEITXT1	CHAR75	CHAR	75	0	Description of Services
161	PREREGRO	☐	N1PREREGRO	BAUID	CHAR	8	0	Treatment Room	*
162	PREREGROSN	☐	N1PREREGROSN	TEXT12	CHAR	12	0	Short Name of Treatment Room
163	PREREGDR	☐	N1PREREGDR	ISH_DZEIT	NUMC	4	0	Duration in Minutes for a Treatment Appointment
164	RISK_ICON	☐	N1RISK_ICON	TEXT50	CHAR	50	0	Risk Factors Exist (Icon)
165	STATUS	☐	N1STATUS_K	TEXT4	CHAR	4	0	Status (Short Form)
166	STATUS_TEXT	☐	N1STATUS_TXT	ISH_TEXT30	CHAR	30	0	Status Name
167	TRTGP	☐	N1CORDTRTGP	RI_KUNNR	CHAR	10	0	Filler (Business Partner)	*
168	TRTGP_TXT	☐	N1TRTGP_TXT	TEXT50	CHAR	50	0	Name of Order Filler (Employee/Business Partner)
169	PRIO	☐	N1PRI	CHAR3	CHAR	3	0	Priority
170	APRIE	☐	N1PRI	CHAR3	CHAR	3	0	Priority
171	APRITXT	☐	N1PRIOTXT	TEXT15	CHAR	15	0	Texts for Priorities

History

Last changed by/on	SAP	20130529
SAP Release Created in	463B