| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RELID | | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | SRTFD | | nvarchar | 40 | 0 | | | | Allow NULL? |
| 4 | HISTO | Historical Record Flag | char | 1 | 0 | | | | Allow NULL? |
| 5 | ERROR | | char | 1 | 0 | | | | Allow NULL? |
| 6 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | SENDSTAT | | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | DATOD | Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | ELDPPORT | | char | 1 | 0 | | | | Allow NULL? |
| 11 | IDSOUB | | nvarchar | 30 | 0 | | | | Allow NULL? |
| 12 | PREGI | Sequence number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | HPERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | REGION | Region number of CSSZ | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | ACTION | Action (register/deregister/change/correction/...) | char | 1 | 0 | | | | Allow NULL? |
| 16 | DATRE | Date of creation Insured Register | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | DAOPR | Date of validity/Date of creation correction item | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 19 | NACHN | Last Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 20 | NACHN_ALL | All previos surname | nvarchar | 100 | 0 | | | | Allow NULL? |
| 21 | VORNA | First Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 22 | TITEL | Title | nvarchar | 15 | 0 | | | | Allow NULL? |
| 23 | GBDAT | Date of Birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | BORNA | Name at Birth | nvarchar | 40 | 0 | | | | Allow NULL? |
| 25 | GBORT | Birthplace | nvarchar | 40 | 0 | | | | Allow NULL? |
| 26 | GENDER | Gender | char | 1 | 0 | | | | Allow NULL? |
| 27 | CNDTN | Family status | char | 1 | 0 | | | | Allow NULL? |
| 28 | NATIO | Nationality | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | ANZKD | Number of Children | decimal | 3 | 0 | | | | |
| 30 | STRAS | Street and House Number | nvarchar | 60 | 0 | | | | Allow NULL? |
| 31 | HSNMR | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | PSTLZ | Postal Code | nvarchar | 11 | 0 | | | | Allow NULL? |
| 33 | ORT01 | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 34 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | STRAS_CZ | Street and House Number | nvarchar | 60 | 0 | | | | Allow NULL? |
| 36 | HSNMR_CZ | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | PSTLZ_CZ | Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | ORT01_CZ | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 39 | VS | Account Number of Bank Account At Post Office | nvarchar | 16 | 0 | | | | Allow NULL? |
| 40 | ADR_ALL | Name of organization | nvarchar | 100 | 0 | | | | Allow NULL? |
| 41 | ADR_B | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 42 | ADR_C | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 43 | ADR_D | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 44 | ADR_E | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 45 | ADR_I | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 46 | ADR_H | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 47 | ADR_Q | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 48 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 50 | DRVCI | Contract type for pension | char | 1 | 0 | | | | Allow NULL? |
| 51 | LAND1_WRK | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | WOSTD | Hours per week | decimal | 5 | 2 | | | | |
| 53 | WKWDY | Weekly Workdays | decimal | 4 | 2 | | | | |
| 54 | BETRG | Wage Type Amount for Payments | decimal | 13 | 2 | | | | |
| 55 | TXT02 | Name of foreign health insurance | nvarchar | 100 | 0 | | | | Allow NULL? |
| 56 | STRAS_CZP | Street of foreign health insurance | nvarchar | 48 | 0 | | | | Allow NULL? |
| 57 | HSNMR_CZP | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 58 | PSTLZ_CZP | Post code for CZP | nvarchar | 11 | 0 | | | | Allow NULL? |
| 59 | ORT01_CZP | Place CZP | nvarchar | 48 | 0 | | | | Allow NULL? |
| 60 | LAND1_CZP | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 61 | MITNF | Membership number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 62 | DRUHD | Pension type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 63 | DATVY | Start date of pension payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 64 | POSTA | Post for ELDP/ONZ | nvarchar | 5 | 0 | | | | Allow NULL? |
| 65 | POSTA_CZ | Post for ELDP/ONZ | nvarchar | 5 | 0 | | | | Allow NULL? |
| 66 | STRAS_KA | Street and House Number | nvarchar | 60 | 0 | | | | Allow NULL? |
| 67 | HSNMR_KA | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 68 | PSTLZ_KA | Postal Code | nvarchar | 11 | 0 | | | | Allow NULL? |
| 69 | ORT01_KA | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 70 | POSTA_KA | Post for ELDP/ONZ | nvarchar | 5 | 0 | | | | Allow NULL? |
| 71 | LAND1_KA | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 72 | NVS | | nvarchar | 16 | 0 | | | | Allow NULL? |
| 73 | KVSPE | Specification of foreign insurance | char | 1 | 0 | | | | Allow NULL? |
| 74 | KVSFR | Health insurance key for compulsory HI fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 75 | KVPHI | Authority for health insurance | nvarchar | 100 | 0 | | | | Allow NULL? |
| 76 | KVAHI | Authority for health insurance | nvarchar | 100 | 0 | | | | Allow NULL? |
| 77 | SVA09 | Small Range Employment | char | 1 | 0 | | | | Allow NULL? |
| 78 | E101 | Competency for CZ legal regulations | char | 1 | 0 | | | | Allow NULL? |
| 79 | OKRES | Region CSSZ | nvarchar | 42 | 0 | | | | Allow NULL? |
| 80 | YEARE | | nvarchar | 4 | 0 | | | | Allow NULL? |