GPGB_FPS_RECON(SQL Table) |
Index Back |
|---|---|
FPS Reconciliation RecordFPS Reconciliation Record holding Payroll Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 6 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 7 | GPGB_TAX_BGN_YR |
Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 8 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 9 | HIRE_DT |
Date(10) | DATE | First Start Date |
| 10 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 11 | GPGB_NI_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL | NI Category Code |
| 12 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 13 | PRC_ORD_TS | DateTime(26) | TIMESTAMP | Process Order Timestamp |
| 14 | PYMT_DT | Date(10) | DATE | Payment Date |
| 15 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 16 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 17 | GPGB_LEL_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL PTD |
| 18 | GPGB_LELET_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above LEL up to ET PTD |
| 19 | GPGB_ETUEL_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL PTD |
| 20 | GPGB_ETUAP_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL PTD |
| 21 | GPGB_UAPUEL_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL PTD |
| 22 | GPGB_ER_NIC_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's contributions PTD |
| 23 | GPGB_ER_RBT_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's rebate PTD |
| 24 | GPGB_EE_NIC_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL PTD |
| 25 | GPGB_EE_RBT_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee's rebate PTD |
| 26 | GPGB_SMP_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SMP PTD |
| 27 | GPGB_SSP_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SSP PTD |
| 28 | GPGB_SPPA_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPA PTD |
| 29 | GPGB_SPPB_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPB PTD |
| 30 | GPGB_SAP_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SAP PTD |
| 31 | GPGB_EE_GROSS_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL PTD |
| 32 | GPGB_EE_TAX_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax PTD |
| 33 | GPGB_EE_SL_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Student loans PTD |
| 34 | GPGB_EE_TC_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Tax credits PTD |
| 35 | GPGB_ASPPA_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ASPPA PTD : Additional Stat Paternity Pay Adoption |
| 36 | GPGB_ASPPB_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ASPPB PTD : Additional Stat Paternity Pay Birth |
| 37 | GPGB_SHPPA_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | SHPPA PTD : Shared Parental Pay Adoption |
| 38 | GPGB_SHPPB_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | SHPPB PTD : Shared Parental Pay Birth |
| 39 | GPGB_TAXABLE_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Taxable Pay PTD |
| 40 | GPGB_NIABLE_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Niable PTD used for RTI |
| 41 | GPGB_BEN_KIND_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Used to store BEN IN KIND accumulator value used in RTI |
| 42 | GPGB_EE_PEN_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Pension Ded PTD |
| 43 | GPGB_EE_PEN2_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Pension Contributions not under 'Net Pay' |
| 44 | GPGB_NON_TAX_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Non Tax PTD |
| 45 | GPGB_STAT_DED_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing statutory deduction value for RTI |
| 46 | GPGB_DEDNETPAY_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Used to store dedecution from net pay used in RTI |
| 47 | GPGB_NETPAY_PTD | Number(19,6) | DECIMAL(18,6) NOT NULL | NetPay PTD for RTI |
| 48 | GPGB_BEN_TAX_PTD | Number(19,6) | DECIMAL(18,6) NOT NULL | Used for RTI,Benefit taxed via Payroll |
| 49 | GPGB_NIC_CLAS1_PTD | Number(19,6) | DECIMAL(18,6) NOT NULL | Used in RTI ,Benefits contributing NIC for Class1 |
| 50 | GPGB_NIC_NONTX_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Benefits subjected to NIC Non Tax PTD |
| 51 | GPGB_NOT_NIC_PTD | Number(19,6) | DECIMAL(18,6) NOT NULL | Used in RTI,Benefit not subjected to NIC CLASS 1 |
| 52 | GPGB_TRIV_COMA_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 53 | GPGB_TRIV_COMB_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 54 | GPGB_TRIV_COMC_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 55 | GPGB_FORE_TX_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GPGB Foreign tax PTD |
| 56 | GPGB_FLX_TAX_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Flexible Drawdown Taxable Payment |
| 57 | GPGB_FLX_NTAX_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Flexible Drawdown Non-Taxable Payment |
| 58 | GPGB_TER_ER_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GP UK Termination Payment |
| 59 | GPGB_DSGSED_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Disguised Remuneration PTD |
| 60 | GPGB_PG_LOAN_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Post Graduate Loan PTD |
| 61 | GPGB_SPBP_PTD | Number(12,2) | DECIMAL(11,2) NOT NULL | GP UK Termination Payment |
| 62 | GPGB_LEL_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings at LEL |
| 63 | GPGB_LELET_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above LEL up to ET |
| 64 | GPGB_ETUEL_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 65 | GPGB_ETUAP_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 66 | GPGB_UAPUEL_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Earnings above ET up to UEL |
| 67 | GPGB_ER_NIC_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's contributions |
| 68 | GPGB_ER_RBT_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employer's rebate |
| 69 | GPGB_EE_NIC_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Employee NIC |
| 70 | GPGB_EE_RBT_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total Employee's rebate |
| 71 | GPGB_SMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SMP |
| 72 | GPGB_SSP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SSP |
| 73 | GPGB_SPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPA |
| 74 | GPGB_SPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPB |
| 75 | GPGB_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SAP |
| 76 | GPGB_EE_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total gross |
| 77 | GPGB_FORGN_TAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Foreign Tax |
| 78 | GPGB_WIDOW | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Widow |
| 79 | GPGB_LIFE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Life |
| 80 | GPGB_EE_TAX | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax |
| 81 | GPGB_EE_SL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Student loans |
| 82 | GPGB_EE_TC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Tax credits |
| 83 | GPGB_ASPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ASPPA YTD : Additional Stat Paternity Pay Adoption |
| 84 | GPGB_ASPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ASPPB YTD : Additional Stat Paternity Pay Birth |
| 85 | GPGB_NIABLE_YTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Niable YTD used for RTI |
| 86 | GPGB_BEN_TAX_YTD | Number(19,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 87 | GPGB_PEN_DED_YTD | Number(19,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 88 | GPGB_ST_PENS_YTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | State Pension YTD |
| 89 | GPGB_PEN2DED_YTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | State Pension YTD |
| 90 | GPGB_SHPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shared Parental Adoption |
| 91 | GPGB_SHPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | SHared Parental Birth |
| 92 | GPGB_TER_ER_YTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GP UK Termination Payment |
| 93 | GPGB_PG_LOAN_YTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Post Graduate Loan YTD |
| 94 | GPGB_SPBP_YTD | Number(12,2) | DECIMAL(11,2) NOT NULL | GP UK Termination Payment |
| 95 | GPGB_TRIV_COMM_A | Character(1) | VARCHAR2(1) NOT NULL |
Trivial Commutation Payment Type for Pensioners
A=Trivial Commutation Lump sums B=Lump Sum - Personal Pension C=Lump Sum -Occupational Pension |
| 96 | GPGB_TRIV_COMM_B | Character(1) | VARCHAR2(1) NOT NULL |
Trivial Commutation Payment Type for Pensioners
A=Trivial Commutation Lump sums B=Lump Sum - Personal Pension C=Lump Sum -Occupational Pension |
| 97 | GPGB_TRIV_COMM_C | Character(1) | VARCHAR2(1) NOT NULL |
Trivial Commutation Payment Type for Pensioners
A=Trivial Commutation Lump sums B=Lump Sum - Personal Pension C=Lump Sum -Occupational Pension |
| 98 | RTO_PRC_ID | Character(10) | VARCHAR2(10) NOT NULL | Retro Process Definition ID |