| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 5 | CNTR1 | SI split | varbinary | 1 | 0 | RAW | | Yes | | CNTR1 | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 8 | REGOF | Regular / Off-cycle | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PHR_REGOF | Allow NULL? |
| 9 | ETYPE | Employee type | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ETYPE | Allow NULL? |
| 10 | MUNCO | Municipality of work | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PHR_MUNC2 | Allow NULL? |
| 11 | TAX | Tax calculation for EE type | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_TAX | Allow NULL? |
| 12 | DEDPE | Personal tax deduction factor | decimal | 5 | 3 | DEC | ((0)) | Yes | | PHR_DEDPE | |
| 13 | DEDFA | Tax deduction factor | decimal | 5 | 3 | DEC | ((0)) | Yes | | PHR_DEDFA | |
| 14 | FCTTX | Factor for tax calculation | decimal | 5 | 3 | DEC | ((0)) | Yes | | PHR_FCTTX | |
| 15 | EEPEC | EE - Pension Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_EEPCA | Allow NULL? |
| 16 | EEPEI | EE Pension Increase to LL | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_EEPIL | Allow NULL? |
| 17 | ERPEC | ER Pension Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERPCA | Allow NULL? |
| 18 | ERPEI | ER Pension Increase to LL | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERPIL | Allow NULL? |
| 19 | ERHEC | ER Health Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERHCA | Allow NULL? |
| 20 | ERHEI | ER Health Increase to LL | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERHIL | Allow NULL? |
| 21 | ERHDC | ER Health insurance Detached EEs | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERHDC | Allow NULL? |
| 22 | EREMC | ER Employment Claculation | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERECA | Allow NULL? |
| 23 | EREMI | ER Employment Increase to LL | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_EREIL | Allow NULL? |
| 24 | ERINC | ER Injury Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERICA | Allow NULL? |
| 25 | ERINI | ER Injury Increase to LL | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERIIL | Allow NULL? |
| 26 | ERTAC | ER Trip Abroad Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_ERTCA | Allow NULL? |
| 27 | SILEV | Social insurance level type | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_SILEV | Allow NULL? |
| 28 | KATEG | Benefical category | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_KATEG | Allow NULL? |
| 29 | MUNCL | Municipality Code HR | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PHR_MUNCO | Allow NULL? |
| 30 | NHTYP | Newly-Hired employee type / Novozaposleni | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_NHTYP | Allow NULL? |
| 31 | DRREZ | Country of residence | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PHR_DRREZ | Allow NULL? |
| 32 | NOSTX | No surtax | char | 1 | 0 | CHAR | (N' ') | Yes | | PHR_NOSTX | Allow NULL? |
