| 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 | ENDDT | End date of this Employment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P08_ENDDA | Allow NULL? |
| 6 | STDAT | Start date of this employment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P08_BEGDA | Allow NULL? |
| 7 | STDET | HR GB: Starter Declaration | char | 1 | 0 | NUMC | (N'0') | Yes | | P08_P46CLS | Allow NULL? |
| 8 | SLIND | Student Loan Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_SLIND | Allow NULL? |
| 9 | SLRPE | Student loan repayment | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_SLRPE | |
| 10 | SLRPP | Student Loan repayment in this pay period | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_SLRPP | |
| 11 | EXPAT | HR GB: Starter Declaration | char | 1 | 0 | NUMC | (N'0') | Yes | | P08_P46CLS | Allow NULL? |
| 12 | EEACC | Residence status Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_EEACC | Allow NULL? |
| 13 | EPMSC | EPM6(Modified) Scheme indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_EPMSC | Allow NULL? |
| 14 | OPWID | HR GB: Retiring on Pension Recently Bereaved Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_PENWIDI | Allow NULL? |
| 15 | OPAMT | HR GB: Pension Amount Paid by employer Annually to Employee | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_PENAMT | |
| 16 | SPWID | HR GB: Retiring on Pension Recently Bereaved Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_PENWIDI | Allow NULL? |
| 17 | SPAMT | HR GB: Pension Amount Paid by employer Annually to Employee | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_PENAMT | |
| 18 | EPCNP | Employee Net Pension | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_EPCNP | |
| 19 | EPCP | employee pension contributions | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_EPCP | |
| 20 | IREMP | Irregular Payments Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_IREMP | Allow NULL? |
| 21 | TPYEM | Taxable pay to date in this employment | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_TPYEM | |
| 22 | TXPEM | Total tax to date in this employment | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_TXPEM | |
| 23 | TXDRP | Tax deducted or refunded from this payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_TXDRP | |
| 24 | TPYPE | Taxable pay in this pay period | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_TPYPE | |
| 25 | ERPER | NI calculation period | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P08_NIPER | Allow NULL? |
| 26 | LTPYI | Late payment after notification Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_LTPYI | Allow NULL? |
| 27 | PYTXN | Net Additions | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_PYTXN | |
| 28 | DEDPP | Net deductions | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_DEDPP | |
| 29 | PADED | RTI Net pay | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_PADED | |
| 30 | BNTXP | Benefits taxed via the payroll | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_BNTXP | |
| 31 | BNNIP | Amount of the benefits subject to Class 1 NIC | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_BNNIP | |
| 32 | BNNNI | Amount of the benefits not subject to Class 1 NIC | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_BNNNI | |
| 33 | ISCNI | Items subject to Class 1 NIC not taxed excluding pension | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_ISCNI | |
| 34 | DIRAP | Director appointment Week/Month | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DIRAP | Allow NULL? |
| 35 | GLBID | HR B2A: Global Object ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PC_B2A_GLBID | Allow NULL? |
| 36 | RTIND | RTI Indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P08_INDI | Allow NULL? |
| 37 | SSPYD | Statutory Sick Pay (SSP) year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_SSPY | |
| 38 | SMPYD | Statutory Maternity pay (SMP) year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_SMPY | |
| 39 | OSSPY | Ordinary Statutory Paternity pay (SPP) year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_OSSPY | |
| 40 | SAPYD | Statutory Adoption pay (SAP) year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_SAPY | |
| 41 | ASPPY | Additional Statutory Paternity pay /SSPP year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_ASPPY | |
| 42 | NHWKD | Number of normal hours worked | decimal | 5 | 2 | DEC | ((0)) | Yes | | P08_NHWK | |
| 43 | DIRFB | NI director indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | DIRFB | Allow NULL? |
| 44 | PENID | HR-GB: MM2 Pension indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_PENID | Allow NULL? |
| 45 | BNTXY | Value of benefits taxed via payroll year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_BNTXY | |
| 46 | EPCNY | Pension paid NOT under Net pay arranement year to date | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_EPCNY | |
| 47 | EPCPY | Value of pension paid under Net pay arrangement YTD | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_EPCPY | |
| 48 | UAIND | Indicator that an individual has been on an unpaid absence | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_UAIND | Allow NULL? |
| 49 | PYTNI | Payment to non individual | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_PYTNI | Allow NULL? |
| 50 | TCOPY | Trivial commutation payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | P08_TCOPY | |
| 51 | TCOPT | Trivial commutation payment type | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_TCOPT | Allow NULL? |
| 52 | PYIND | HR GB: Payroll ID Change Indiator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08_PAYCHIND | Allow NULL? |
| 53 | ADJUST | Adjustment of calculations flag | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_ADJST | Allow NULL? |
| 54 | P60FLG | HR:GB RTI - P60 Issued flag | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_P60FLAG | Allow NULL? |
| 55 | PSCHID | RTI: Pension Scheme ID for SCON | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | P08_PSCHM | Allow NULL? |
