SAP ABAP Table RNKAV3 (IS-H: Medical Record and Borrowing Data for Archive List)

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	RNKAV3	Table Relationship Diagram
Short Description	IS-H: Medical Record and Borrowing Data for Archive List

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	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
4	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
5	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
6	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
7	LFDDOK	☐	LFDDOK	INT4_NOS	INT4	10	0	Sequence Number of Document
8	MEDOK	☐	MEDOK	XFELD	CHAR	1	0	Indicator for a Medical Document
9	ORGFORM	☐	ORGFORM	ORGFORM	CHAR	1	0	IS-H: Organization Form for Medical Record Management
10	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
11	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
12	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
13	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
14	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
15	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
16	ORGDO	☐	ORGDO	ORGID	CHAR	8	0	Documenting Organizational Unit	NORG
17	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	NBEW
18	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
19	ARCHIV	☐	ARCHIV_ID	ORGID	CHAR	8	0	IS-H: Organizational ID of the medical record archive	NORG
20	STANDORT	☐	ISH_ARCHST	BAUID	CHAR	8	0	IS-H: Building ID of building unit in the 'archive' OU	NBAU
21	ROLLNO	☐	ISH_ROLLNO	CHAR10	CHAR	10	0	IS-H: Roll Number of a Micro Film
22	MICROF	☐	ISH_MICROF	XFELD	CHAR	1	0	IS-H: Patient's medical record is microfilmed
23	EXTNR	☐	ISH_DOCEXT	CHAR15	CHAR	15	0	IS-H: External Medical Record/Document ID
24	INFOMR	☐	ISH_INFOMR	TEXT50	CHAR	50	0	IS-H: Informational Text for Medical Record
25	TEMPMR	☐	ISH_TEMPMR	XFELD	CHAR	1	0	IS-H: Flags a Medical Record as Temporary Medical Record
26	ALBUM	☐	ISH_ALBUM	CHAR10	CHAR	10	0	IS-H: Album Id for microfilm
27	MFYEAR	☐	ISH_MFYEAR	NUMC4	NUMC	4	0	IS-H: Year Until when Data Archived on Microfilm
28	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
29	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
30	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
31	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
32	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
33	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
34	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
35	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
36	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
37	PATEX	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
38	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
39	REDO_KZ	☐	ISH_REDO_KZ	XFELD	CHAR	1	0	IS-H: Indicator for Renewable Document Management
40	ENTLEIHER	☐	ENTLEIHNR	ENTLNR	CHAR	10	0	Borrower for Document Management
41	ENTLTYP	☐	ENTLEIHTYP	ENTLEIHTYP	CHAR	2	0	IS-H: Borrower Category
42	LEIHDAT	☐	ISH_LEIDAT	RI_DATUM	DATS	8	0	IS-H: Date at which a Medical Record Is Borrowed/Requested
43	LEIZEIT	☐	ISH_LEIZEI	UHRZT	TIMS	6	0	IS-H: Borrowing time
44	ENTLEND	☐	ISH_ENTLEN	RI_DATUM	DATS	8	0	IS-H: Scheduled Borrowed-To Date
45	RUEKDAT	☐	ISH_RUEKDT	RI_DATUM	DATS	8	0	IS-H: Date Medical Record Returned
46	STATUS	☐	ISH_LEISTA	ISH_LEISTA	CHAR	1	0	IS-H: Borrowing Status
47	ANZMAH	☐	ISH_ANZMAH	INT2	INT2	5	0	IS-H: Number of Reminders for Medical Records
48	ERMAHN	☐	ISH_AKM1DT	RI_DATUM	DATS	8	0	IS-H: Date of 1st Reminder for Medical Record
49	LEMAHN	☐	ISH_AKM2DT	RI_DATUM	DATS	8	0	IS-H: Date of Last Reminder
50	ENTTEXT	☐	TEXTENT	TEXT50	CHAR	50	0	IS-H: Comment on Borrowing Episode
51	ENTZW	☐	ISH_ENTLZW	ISH_ENTLZW	CHAR	2	0	IS-H: Reason for Borrowing Medical Record/Document	*
52	VERANTW	☐	VERANTWORT	ENTLNR	CHAR	10	0	IS-H: Person Responsible for Medical Records/Documents
53	FILEMR	☐	ISH_FILE_MR	XFELD	CHAR	1	0	IS-H: Medical Record Has still to Be Stored
54	SORTMR	☐	ISH_SORTMR	CHAR10	CHAR	10	0	IS-H: String for user-def. sorting of lists in Med.Rcrd Mgmt

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNKAV3	ARCHIV	NORG	ORGID		1	CN
2	RNKAV3	DOKAR	TDWA	DOKAR	KEY	1	CN
3	RNKAV3	DOKNR	DRAW	DOKNR	KEY	1	CN
4	RNKAV3	EINRI	TN01	EINRI	KEY	1	CN
5	RNKAV3	FALNR	NFAL	FALNR	KEY	1	CN
6	RNKAV3	LFDBEW	NBEW	LFDNR	KEY	1	CN
7	RNKAV3	MANDT	T000	MANDT	KEY	1	CN
8	RNKAV3	ORGDO	NORG	ORGID	KEY	1	CN
9	RNKAV3	ORGFA	NORG	ORGID	KEY	1	CN
10	RNKAV3	ORGPF	NORG	ORGID	KEY	1	CN
11	RNKAV3	PATNR	NPAT	PATNR	KEY	1	CN
12	RNKAV3	STANDORT	NBAU	BAUID		1	CN

History

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