SAP ABAP Table RNIRS (IS-H: Insurance Relationship - Case- and Patient-Related)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	RNIRS	Table Relationship Diagram
Short Description	IS-H: Insurance Relationship - Case- and Patient-Related

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	KOSTR	☐	KH_KOSTR	RI_KUNNR	CHAR	10	0	IS-H: Insurance Provider	*
2	PATKZ	☐	ISH_PATKZ	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer Insurance Relationship
3	MGART	☐	MITART_VER	MITART_VER	CHAR	1	0	IS-H: Type of Insurance Coverage	TN16M
4	UNTGR	☐	UNTGR	UNTGR	CHAR	2	0	IS-H: Insurance Subgroup	TN16C
5	VERAB	☐	BEGDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-From Date of Insurance Relationship
6	VERBI	☐	ENDDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-to Date of Insurance Relationship
7	RANGF	☐	ISH_RANGF	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
8	VKVST	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
9	VKVSE	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
10	VKNRA	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
11	VKNUM	☐	ISH_VK_KNR	TEXT7	CHAR	7	0	Healthcare Smart Card - Health Insurer Number
12	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
13	VKMAN	☐	ISH_KVMAN	XFELD	CHAR	1	0	IS-H: Indicator that HCSC Data Entered Manually
14	VCEND	☐	ISH_VK_END	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Validity
15	PCARD	☐	ISH_VK_PKV	XFELD	CHAR	1	0	IS-H: HC smart card - private card indicator (CfP)
16	VERNR	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
17	VERGE	☐	VERGE	GSCHL	CHAR	1	0	IS-H: Sex of Person Insured
18	VERNN	☐	VERNN	TEXT30	CHAR	30	0	Last Name of Insured Person
19	VERVN	☐	VERVN	TEXT30	CHAR	30	0	First Name of Insured Person
20	VERAN	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	TN17U
21	VERTI	☐	VERTI	TITEL	CHAR	15	0	Title of Insured Person	T535N
22	VERNZ	☐	VERNZ	TITEL	CHAR	15	0	Name Affix of Insured Person	T535N
23	VERVW	☐	VERVW	TITEL	CHAR	15	0	Name Prefix of Insured Person	T535N
24	VERGB	☐	VERGB	RI_DATUM	DATS	8	0	IS-H: Date of Birth of Person Insured
25	VERNA	☐	ISH_NATIO	LAND1	CHAR	3	0	IS-H: Nationality of Person	T005
26	VERSV	☐	VERSV	ISH_SVNUM	CHAR	20	0	Social Insurance Number of Insured Person
27	VERVV	☐	N1HVD	N1HVV	CHAR	1	0	IS-H: Relationship to Main Insured	TNVVA
28	VERGN	☐	VERGN	TEXT30	CHAR	30	0	IS-H: Name at Birth of Person Insured
29	VERSN	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
30	ADNHV	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
31	ADOHV	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
32	BERUF	☐	BERUF	TEXT25	CHAR	25	0	IS-H: Patient Occupation
33	AGNUM	☐	KH_ARBGEB	RI_KUNNR	CHAR	10	0	IS-H: Employer	NGPA
34	AGNAM	☐	VERAGNA	TEXT30	CHAR	30	0	Name of Insured Person's Employer
35	ADNAG	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	*
36	ADOAG	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
37	SZDEB	☐	SZ_DEBNR	KUNNR	CHAR	10	0	IS-H: Customer Number of Self-Payer in Financial Accounting	*
38	ABREE	☐	ABWREMPF	XFELD	CHAR	1	0	Indicator Whether Alternative Invoice Recipient Exists
39	KZTXT	☐	TEXT_VVP	TEXT50	CHAR	50	0	IS-H: Comment on Patient-Related Insurance Relationship
40	LGTXT	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
41	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
42	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
43	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
44	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
45	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
46	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
47	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
48	VTRTY	☐	ISH_VTRTY	ISH_VTRTY	CHAR	6	0	IS-H: Insurance Contract Scheme	TN16
49	VSCOD	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
50	ADRNR	☐	ISH_CADRNR	CADRNR	CHAR	10	0	IS-H: Number of Address in General Address Management	*
51	CPDKT	☐	ISH_CPDKTO	KUNNR	CHAR	10	0	IS-H: One-Time Account for Alternative Invoice Recipient	*
52	VAL_QUARTER	☐	ISH_VAL_QUARTER_BEGIN		DATS	8	0	IS-H: Validity Quarter Start Date
53	VKZML	☐	ISH_VK_ZML	NUM3	NUMC	3	0	IS-H: Health Insurance Card - Mobile Card Reader License No.
54	VKTITEL	☐	ISH_VK_TIT	TEXT15	CHAR	15	0	IS-H: Healthcare smart card - title
55	VKVNAM	☐	ISH_VK_VNM	TEXT28	CHAR	28	0	Healthcare Smart Card - First Name
56	VKNZU	☐	ISH_VK_NZU	TEXT15	CHAR	15	0	IS-H: Healthcare Smart Card - Name Affix
57	VKNNAM	☐	ISH_VK_NAM	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - last name
58	VKGBDAT	☐	ISH_VK_GBD	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Date of Birth
59	VKSTRAS	☐	ISH_VK_STR	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - street
60	VKLAND	☐	ISH_VK_LAN	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Country
61	VKPLZ	☐	ISH_VK_PLZ	TEXT7	CHAR	7	0	IS-H: Healthcare Smart Card - Postal Code
62	VKORT	☐	ISH_VK_ORT	TEXT23	CHAR	23	0	IS-H: Healthcare Smart Card - City
63	LNCRD	☐	ISH_LNCARD	ISH_LNCARD	NUMC	10	0	Sequence Number of Health Insurance Card
64	LNCRD_PAT	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
65	LNCRD_INS	☐	ISH_LNCARD_DET		NUMC	5	0	Sequential Details of Health Insurance Card
66	VKUNKNOWN_GBDAT	☐	ISH_VK_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Healthcare Smart Card: Exact Birthdate Unknown
67	VERNR_KVK	☐	ISH_VERNR_KVK	CHAR20	CHAR	20	0	Insurance Number PPA Card
68	.INCLUDE	☐				0	0	IS-H Vers.verh. fall- und pat.bezogen (Zusatzfelder CH)
69	MCDKZ	☐	NWCH_MCDKZ	NWCH_MCDKZ	CHAR	1	0	MCD Versandoption

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNIRS	AGNUM	NGPA	GPART	REF	1	CN
2	RNIRS	LGTXT	T002	SPRAS
3	RNIRS	MGART	TN16M	MGART	REF	1	CN
4	RNIRS	UNTGR	TN16C	UNTGR	REF	1	CN
5	RNIRS	VERAN	TN17U	ANRDS	REF	1	CN
6	RNIRS	VERNA	T005	LAND1	REF	1	CN
7	RNIRS	VERNZ	T535N	TITEL	REF	1	CN
8	RNIRS	VERTI	T535N	TITEL	REF	1	CN
9	RNIRS	VERVV	TNVVA	VERVA	REF	1	CN
10	RNIRS	VERVW	T535N	TITEL	REF	1	CN
11	RNIRS	VTRTY	TN16	VTRTY

History

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