SAP ABAP Table P05T_CVZ_REG_DAT ((De)registration data for HCIB)

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PY-NL-RP (Application Component) Reporting
     ⤷ P05T (Package) HR Payroll: The Netherlands

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	P05T_CVZ_REG_DAT	Table Relationship Diagram
Short Description	(De)registration data for HCIB

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	JUPER	☑	P05_REPER	P05_REPER	CHAR	4	0	Representing Legal Person	T5N9P
3	PABRJ	☑	P05T_CVZ_ANPRJ	GJAHR	NUMC	4	0	HCIB for year period
4	PABRP	☑	P05T_CVZ_ANPRP	PABRP	NUMC	2	0	HCIB for period
5	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
6	SEQNO	☑	P05T_CVZ_SEQNO	CHAR4	CHAR	4	0	Alphanumeric symbol for HCIB files
7	MUTATIE	☑	P05T_CVZ_MUTATIE	P05T_CVZ_MUTATIE	NUMC	1	0	Health Care Insurance Board amendment code
8	GESLACHT	☐	P05T_CVZ_GESLACHT	P05T_CVZ_GESLACHT	CHAR	1	0	Gender of insured person
9	VOORLETTERS	☐	P05T_CVZ_VOORLETTERS	TEXT6	CHAR	6	0	Initials
10	VOORVOEGSEL	☐	P05T_CVZ_VOORVOEGSEL	TEXT10	CHAR	10	0	Name Prefix
11	ACHTERNAAM	☐	P05T_CVZ_ACHTERNAAM	TEXT70	CHAR	70	0	Last Name
12	PARTNERNAAM	☐	P05T_CVZ_PARTNERNAAM	TEXT35	CHAR	35	0	Partner Name
13	GEBOORTEDATUM	☐	P05T_CVZ_GEBOORTEDATUM	P05T_CVZ_DATUM	CHAR	10	0	Date of Birth for HCIB
14	ADRES	☐	P05T_CVZ_ADRES_REG	TEXT40	CHAR	40	0	Address for Health Care Insurance Board (De)Registration
15	HUISNUMMER	☐	P05T_CVZ_HUISNUMMER	NUM5	NUMC	5	0	House Number for HCIB (de)registration
16	TOEVOEGING	☐	P05T_CVZ_TOEVOEGING	TEXT10	CHAR	10	0	House Number Supplement for HCIB
17	POSTCODE	☐	P05T_CVZ_POSTCODE	CHAR8	CHAR	8	0	Postal Code for HCIB
18	WOONPLAATS	☐	P05T_CVZ_WOONPLAATS	TEXT24	CHAR	24	0	City for HCIB
19	PROVINCIE	☐	P05T_CVZ_PROVINCIE	TEXT20	CHAR	20	0	Province for HCIB
20	WOONLAND	☐	P05T_CVZ_LAND	CHAR2	CHAR	2	0	Country indicator for HCIB
21	SOFINUMMER	☐	P05T_CVZ_SOFINUMMER	NUM9	NUMC	9	0	Social Security Number for HCIB
22	ORGANISATIENR	☐	P05T_CVZ_ORGCDE	CHAR12	CHAR	12	0	Organizational key for HCIB
23	POLISNR	☐	P05T_CVZ_REGISTRATIENR	CHAR20	CHAR	20	0	External registration number
24	REGISTRATIENR	☐	P05T_CVZ_REGISTRATIENR	CHAR20	CHAR	20	0	External registration number
25	STARTDATUM	☐	P05T_CVZ_DT_START_REG	P05T_CVZ_DATUM	CHAR	10	0	Effective Date End of Benefit, Relocation Date
26	ADRES2	☐	P05T_CVZ_ADRES_REG	TEXT40	CHAR	40	0	Address for Health Care Insurance Board (De)Registration
27	REDEN_MELDING	☐	P05T_CVZ_REDEN_MELDING	P05T_CVZ_REDEN_MELDING	NUMC	2	0	Notification Reason

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05T_CVZ_REG_DAT	JUPER	T5N9P	REPER	KEY	1	CN
2	P05T_CVZ_REG_DAT	MANDT	T000	MANDT	KEY	1	CN
3	P05T_CVZ_REG_DAT	PERNR	PA0003	PERNR	KEY	1	CN

History

Last changed by/on	SAP	20080505
SAP Release Created in	700