| 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 | BDATE | Date of Birth | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GBDAT | Allow NULL? |
| 9 | SSNUM | Social security no. | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PPT_SSNUM | Allow NULL? |
| 10 | SSINS | Social security institution | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | PPT_SSINS | Allow NULL? |
| 11 | SSDTE | Social security enrolment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PPT_SSDTE | Allow NULL? |
| 12 | CTRIT | Interruptions in Social Security contributing period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PPT_CTRIT | Allow NULL? |
| 13 | SSRGM | Social security regime | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PPT_SSRGM | Allow NULL? |
| 14 | CTTYP | Contract type | char | 1 | 0 | CHAR | (N' ') | Yes | * | PPT_CTTYP | Allow NULL? |
| 15 | PSION | Code for pensioner status | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_PSION | Allow NULL? |
| 16 | BSAMT | Voluntary social insurance level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PPT_SFEAT | Allow NULL? |
| 17 | ADCVR | Social Security additional cover | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | PPT_ADCVR | Allow NULL? |
| 18 | PBAMT | Percentage of basis amount for pre-retired employees | decimal | 4 | 1 | DEC | ((0)) | Yes | | PPT_PBAMT | |
| 19 | PRCAT | Professional category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | PPT_PRCAT | Allow NULL? |
| 20 | PRCNP | Professional classification (CNP or CPP) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | PPT_PRCNP | Allow NULL? |
| 21 | PRPAR | Professional partitioning | char | 1 | 0 | NUMC | (N'0') | Yes | | PPT_PRPAR | Allow NULL? |
| 22 | PRSIT | Professional situation | char | 1 | 0 | NUMC | (N'0') | Yes | | PPT_PRSIT | Allow NULL? |
| 23 | AUSGR | Education/training categories | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | AUSGR | Allow NULL? |
| 24 | SNAME | Full name | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | PPT_FULNA | Allow NULL? |
| 25 | PRGRP | Professional group | char | 1 | 0 | NUMC | (N'0') | Yes | | PPT_PRGRP | Allow NULL? |
| 26 | PRFUN | Functional structure | char | 1 | 0 | NUMC | (N'0') | Yes | | PPT_PRFUN | Allow NULL? |
| 27 | RGCOD | Social security regime code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PPT_RGCOD | Allow NULL? |
| 28 | LMTLO | Enforce lower limit for contribution basis | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_LMTLO | Allow NULL? |
| 29 | LMTHI | Enforce upper limit for contribution basis | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_LMTHI | Allow NULL? |
| 30 | CVTBS | Conventional contribution basis amount | decimal | 3 | 1 | DEC | ((0)) | Yes | | PPT_CVTBS | |
| 31 | INCTV | Hiring incentive indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_INCTV | Allow NULL? |
| 32 | SSDIS | Permanent disability indicator (Social Security) | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_SSDIS | Allow NULL? |
| 33 | PRERT | Pre-retirement indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_PRERT | Allow NULL? |
| 34 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | PPT_PRCOD | Allow NULL? |
| 35 | JUPER | Legal Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JUPER | Allow NULL? |
| 36 | FLD1 | Not used (length 3) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PPT_MISC3 | Allow NULL? |
| 37 | FLD2 | Not used (length 2) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PPT_MISC2 | Allow NULL? |
| 38 | FLD3 | Not used (length 1) | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_MISC1 | Allow NULL? |
| 39 | FLD4 | Not used (length 1) | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_MISC1 | Allow NULL? |
| 40 | FLD5 | Not used (length 1) | char | 1 | 0 | CHAR | (N' ') | Yes | | PPT_MISC1 | Allow NULL? |
