SAP ABAP Table NIPP (IS-H: Provisional Insurance Relationship of 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	NIPP	Table Relationship Diagram
Short Description	IS-H: Provisional Insurance Relationship of 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	*
2	IPPNO	☑	ISH_IPPNO	ISH_IPPNO	NUMC	10	0	Internal Number of Provisional Insurance Relationship
3	VKGID	☐	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)	N1VKG
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
5	IPID	☐	ISH_IPID	ISH_IPID	CHAR	12	0	Health Insurer Number in Insurance Relationship
6	LFDVV	☐	LFDVV	LFDVV	NUMC	3	0	IS-H: Sequence Number of Insurance Relationship
7	KNAME	☐	ISH_IPNA_PROV	TEXT70	CHAR	70	0	IS-H: Insurance Relationship - Name of Health Insurer
8	VNUMM	☐	VERSNR	CHAR20	CHAR	20	0	IS-H: Patient Health Insurance Number
9	RANGF	☐	ISH_RANGF	ISH_RANGF	NUMC	2	0	IS-H: Ranking Order of Case-Rel. Insurance Relationships
10	MGART	☐	MITART_VER	MITART_VER	CHAR	1	0	IS-H: Type of Insurance Coverage	*
11	VZUZA	☐	ISH_VZUZAH	XFELD	CHAR	1	0	IS-H: Indicator for Self-Payer/Copayer Ins. Relatshp
12	VERBI	☐	ENDDTVVP	RI_DATUM	DATS	8	0	IS-H: Valid-to Date of Insurance Relationship
13	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
14	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
15	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
16	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
17	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
18	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
19	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
20	VKNR	☐	ISH_VK_VKN	TEXT5	CHAR	5	0	IS-H: Healthcare Smart Card - Directory of Health Ins. No's
21	VSTAT	☐	ISH_VK_VST	TEXT4	CHAR	4	0	Healthcare Smart Card - Status of Insured Person
22	VSTER	☐	ISH_VK_VSE	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Health Ins. Status Supplement
23	VSCOD	☐	ISH_VERSIONCODE	ISH_VERSIONCODE	CHAR	2	0	IS-H CA: Version Code for OHIP Health Number
24	KVDAT	☐	ISH_KVDAT	RI_DATUM	DATS	8	0	IS-H: Date Healthcare Smart Card Imported
25	PCARD	☐	ISH_VK_PKV	XFELD	CHAR	1	0	IS-H: HC smart card - private card indicator (CfP)
26	VKZML	☐	ISH_VK_ZML	NUM3	NUMC	3	0	IS-H: Health Insurance Card - Mobile Card Reader License No.
27	VKTITEL	☐	ISH_VK_TIT	TEXT15	CHAR	15	0	IS-H: Healthcare smart card - title
28	VKVNAM	☐	ISH_VK_VNM	TEXT28	CHAR	28	0	Healthcare Smart Card - First Name
29	VKNZU	☐	ISH_VK_NZU	TEXT15	CHAR	15	0	IS-H: Healthcare Smart Card - Name Affix
30	VKNNAM	☐	ISH_VK_NAM	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - last name
31	VKGBDAT	☐	ISH_VK_GBD	RI_DATUM	DATS	8	0	IS-H: Healthcare Smart Card - Date of Birth
32	VKSTRAS	☐	ISH_VK_STR	TEXT28	CHAR	28	0	IS-H: Healthcare smart card - street
33	VKLAND	☐	ISH_VK_LAN	TEXT3	CHAR	3	0	IS-H: Healthcare Smart Card - Country
34	VKPLZ	☐	ISH_VK_PLZ	TEXT7	CHAR	7	0	IS-H: Healthcare Smart Card - Postal Code
35	VKORT	☐	ISH_VK_ORT	TEXT23	CHAR	23	0	IS-H: Healthcare Smart Card - City
36	INSID	☐	ISH_VERS_NR		CHAR	10	0	DE: Eindeutige Versichertennummer (EGK)
37	VKUNKNOWN_GBDAT	☐	ISH_VK_UNKNOWN_GBDAT	ISH_UNKNOWN_GBDAT	CHAR	1	0	Healthcare Smart Card: Exact Birthdate Unknown

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NIPP	VKGID	N1VKG	VKGID	KEY	C	CN

History

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