| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | CNTR1 | SI split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | JUPER | Legal Person | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | KVKZ1 | Indicator for Health Insurance | char | 1 | 0 | | | | Allow NULL? |
| 10 | RVKZ1 | Indicator: Pension Insurance | char | 1 | 0 | | | | Allow NULL? |
| 11 | AVKZ1 | Indicator: Unemployment Insurance | char | 1 | 0 | | | | Allow NULL? |
| 12 | RVNUM | Pension Insurance Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | KVSFR | HI Fund Key for Compulsory Health Insurance Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | KVGST | HI Fund Branch Office | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | KVBKL | Contribution Scale | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | KVFBT | HI Amount | decimal | 7 | 2 | | | | |
| 17 | ZUSKA | Additional Health Insurance Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | SONKV | SI Special Rule HI | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | SONRV | SI Special Rule PI | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | SONAV | SI Special Rule SI | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | SELKV | Indicator Self-Payer HI | char | 1 | 0 | | | | Allow NULL? |
| 22 | SELRV | Self-Payer Pension Insurance | char | 1 | 0 | | | | Allow NULL? |
| 23 | MITNR | Membership Number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 24 | MAXKV | Maximum HI Gross for Pensioners | decimal | 7 | 2 | | | | |
| 25 | KVBAT | HI Contribution Distribution | char | 1 | 0 | | | | Allow NULL? |
| 26 | RVBAT | PI Contribution Distribution | char | 1 | 0 | | | | Allow NULL? |
| 27 | AVBAT | UI Contribution Distribution | char | 1 | 0 | | | | Allow NULL? |
| 28 | SVA01 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | SVA02 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | SVA03 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | SVA04 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | SVA05 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | SVA06 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | SVA07 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | SVA08 | SI Attribute | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | PVKZ1 | Care Insurance Indicator | char | 1 | 0 | | | | Allow NULL? |
| 37 | PVBKL | CI Contribution Scale for Voluntarily Insured Persons | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | PVFBT | Care Insurance Amount | decimal | 7 | 2 | | | | |
| 39 | SONPV | SI Special Rule CI | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | SELPV | Indicator Self-Payer CI | char | 1 | 0 | | | | Allow NULL? |
| 41 | PVBAT | CI Contribution Distribution | char | 1 | 0 | | | | Allow NULL? |
| 42 | MAXPV | Maxiumum CI Gross for Pensioners | decimal | 7 | 2 | | | | |
