T5TREGTRANS - HRCZ - table for transfer items of Insured Register to SAP
HRCZ - table for transfer items of Insured Register to SAP information is stored in SAP table T5TREGTRANS.
It is part of development package PC18 in software component PY-CZ. This development package consists of objects that can be grouped under "HR payroll: Czech Republic".
It is part of development package PC18 in software component PY-CZ. This development package consists of objects that can be grouped under "HR payroll: Czech Republic".
Fields for table T5TREGTRANS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | * |
RELID | Session ID | X | P18_RELID | CHAR | 4 | |
SRTFD | PCL1/PCL2 key | X | P18_PCLKEY | CHAR | 80 | |
HISTO | Historical Record Flag | HISTO | CHAR | 2 | ||
ERROR | P18_WSL_ERROR | CHAR | 2 | |||
PERNR | Personnel Number | PERSNO | NUMC | 16 | * | |
SENDSTAT | ELDP/RP send status | P18_SENDSTAT | CHAR | 4 | ||
AEDTM | Last Changed On | AEDAT | DATS | 16 | ||
DATOD | Date | DATUM | DATS | 16 | ||
ELDPPORT | Uploaded via government agency portal | P18_ELDPPORT | CHAR | 2 | ||
IDSOUB | ID of a file sent via public sector admin.portal | P18_IDSOUB | CHAR | 60 | ||
PREGI | Sequence number | P18_NUM2 | NUMC | 4 | ||
HPERNR | Personnel Number | PERNR_D | NUMC | 16 | ||
REGION | Region number of CSSZ | P18_OKRCSSZ | CHAR | 6 | ||
ACTION | Action (register/deregister/change/correction/...) | P18_AKCE | CHAR | 2 | ||
DATRE | Date of creation Insured Register | P18_DATREG | DATS | 16 | ||
DAOPR | Date of validity/Date of creation correction item | P18_PLREG | DATS | 16 | ||
PERID | Personnel ID Number | PRDNI | CHAR | 40 | ||
NACHN | Last Name | PAD_NACHN | CHAR | 80 | ||
NACHN_ALL | All previos surname | P18_NACHNALL | CHAR | 200 | ||
VORNA | First Name | PAD_VORNA | CHAR | 80 | ||
TITEL | Title | TITEL | CHAR | 30 | * | |
GBDAT | Date of Birth | GBDAT | DATS | 16 | ||
BORNA | Name at Birth | PAD_NAME2 | CHAR | 80 | ||
GBORT | Birthplace | PAD_GBORT | CHAR | 80 | ||
GENDER | Gender | P18_GENDER | CHAR | 2 | ||
CNDTN | Family status | P18_CNDTN | NUMC | 2 | ||
NATIO | Nationality | NATSL | CHAR | 6 | * | |
ANZKD | Number of Children | ANZKD | DEC | 2 | ||
STRAS | Street and House Number | PAD_STRAS | CHAR | 120 | ||
HSNMR | House Number | PAD_HSNMR | CHAR | 20 | ||
PSTLZ | Postal code | P18_PSTLZ_HR | CHAR | 22 | ||
ORT01 | City | PAD_ORT01 | CHAR | 80 | ||
LAND1 | Country/Region Key | LAND1 | CHAR | 6 | * | |
STRAS_CZ | Street and House Number | PAD_STRAS | CHAR | 120 | ||
HSNMR_CZ | House Number | PAD_HSNMR | CHAR | 20 | ||
PSTLZ_CZ | Postal Code | PSTLZ_HR | CHAR | 20 | ||
ORT01_CZ | City | PAD_ORT01 | CHAR | 80 | ||
VS | PO Bank Current Acct No. or Building Society Ref. No. | PSKTO | CHAR | 32 | ||
ADR_ALL | Name of organization | P18_ADR_REG | CHAR | 200 | ||
ADR_B | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
ADR_C | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
ADR_D | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
ADR_E | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
ADR_I | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
ADR_H | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
ADR_Q | Address Text (Name, Street, City, Tel. No.) | ADRTX | CHAR | 80 | ||
BEGDA | Start Date | BEGDA | DATS | 16 | ||
ENDDA | End Date | ENDDA | DATS | 16 | ||
DRVCI | Economic activity type for insured person registry | P18_DRVCIR | CHAR | 2 | ||
LAND1_WRK | Country/Region Key | LAND1 | CHAR | 6 | * | |
WOSTD | Hours per week | WOSTD | DEC | 3 | ||
WKWDY | Weekly Workdays | WARST | DEC | 3 | ||
BETRG | Wage Type Amount for Payments | PAD_AMT7S | CURR | 7 | ||
TXT02 | Name of foreign health insurance | P18_CZP | CHAR | 200 | ||
STRAS_CZP | Street of foreign health insurance | P18_STRAS | CHAR | 96 | ||
HSNMR_CZP | House Number | PAD_HSNMR | CHAR | 20 | ||
PSTLZ_CZP | Post code for CZP | P18_PSTLZ | CHAR | 22 | ||
ORT01_CZP | Place CZP | P18_ORT01 | CHAR | 96 | ||
LAND1_CZP | Country/Region Key | LAND1 | CHAR | 6 | * | |
MITNF | Foreign insurance number | P18_MITNF | CHAR | 60 | ||
DRUHD | Pension type for registry of insured persons | P18_DRUHDR | CHAR | 4 | ||
DATVY | Start date of pension payment | P18_DATVY | DATS | 16 | ||
POSTA | Post for ELDP/ONZ | P18_POSTA | CHAR | 10 | ||
POSTA_CZ | Post for ELDP/ONZ | P18_POSTA | CHAR | 10 | ||
STRAS_KA | Street and House Number | PAD_STRAS | CHAR | 120 | ||
HSNMR_KA | House Number | PAD_HSNMR | CHAR | 20 | ||
PSTLZ_KA | Postal code | P18_PSTLZ_HR | CHAR | 22 | ||
ORT01_KA | City | PAD_ORT01 | CHAR | 80 | ||
POSTA_KA | Post for ELDP/ONZ | P18_POSTA | CHAR | 10 | ||
LAND1_KA | Country/Region Key | LAND1 | CHAR | 6 | * | |
NVS | New VS | P18_NVS | CHAR | 32 | ||
KVSPE | Specification of foreign insurance | P18_KVSTA | CHAR | 2 | ||
KVSFR | Health insurer number | P18_KVSCH | CHAR | 16 | * | |
KVPHI | Authority for health insurance | P18_ONP | CHAR | 200 | ||
KVAHI | Authority for health insurance | P18_ONP | CHAR | 200 | ||
SVA09 | Small Range Employment | P18_PMR | CHAR | 2 | ||
E101 | Competency for CZ legal regulations | P18_E101 | CHAR | 2 | ||
OKRES | Region CSSZ | P18_OKRESCSSZ | CHAR | 84 | ||
YEARE | ELDP/RP year | P18_YEAR | NUMC | 8 |