GPGB_EYUXL1_TBL(SQL Table) |
Index Back |
|---|---|
EYU XML Employment TableEYU XML Employment Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | USER_KEY1 |
Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 5 | HIRE_DT | Date(10) | DATE | First Start Date |
| 6 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 7 | GPGB_P46_STATMNTA | Character(1) | VARCHAR2(1) NOT NULL |
P46 - Statement A
A=A (This is my first job). B=B (This is my only job). C=C (I have another job/pension) |
| 8 | GPGB_EE_SL_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Student loans |
| 9 | CHAR1_01 | Character(1) | VARCHAR2(1) NOT NULL | Values used for ACA processing |
| 10 | CHAR1_02 | Character(1) | VARCHAR2(1) NOT NULL | Values used for ACA processing |
| 11 | CHAR1_03 | Character(1) | VARCHAR2(1) NOT NULL | Values used for ACA processing |
| 12 | GPGB_CITIZEN | Character(1) | VARCHAR2(1) NOT NULL | To determine if European Economic Area or Commoweath citizen |
| 13 | GPGB_EPM6_IND | Character(1) | VARCHAR2(1) NOT NULL | EPM6 (Modified Scheme) Indicator |
| 14 | CHAR1_04 | Character(1) | VARCHAR2(1) NOT NULL | Values used for ACA processing |
| 15 | CHAR1_05 | Character(1) | VARCHAR2(1) NOT NULL | Values used for ACA processing |
| 16 | CHAR1_06 | Character(1) | VARCHAR2(1) NOT NULL | Values used for ACA processing |
| 17 | GPGB_PAYROLLID | Character(30) | VARCHAR2(30) NOT NULL | Payroll ID |
| 18 | GPGB_ANUL_PENSION | Number(11,2) | DECIMAL(10,2) NOT NULL | annual pension for p46 pension |
| 19 | GPGB_RTI_ADDLINF_2 | Character(1) | VARCHAR2(1) NOT NULL |
Stores Additional information required on employee level data
0=On Strike 1=Unpaid Absence 2=Payment to Non-Individual |
| 20 | GPGB_PEN_FLX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flexi Accessing Pension Indicator
N=No Y=Yes |
| 21 | GPGB_DEATH_BEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pension Death Benefit Indicator
N=No Y=Yes |
| 22 | GPGB_HELTH_SUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pension Death Benefit Indicator
N=No Y=Yes |
| 23 | GPGB_TAXABLE_PAY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | RTI Adjustment Submissions - Taxable Pay |
| 24 | GPGB_EE_TAX_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - Total tax |
| 25 | GPGB_SAP_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SAP |
| 26 | GPGB_SSP_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SSP |
| 27 | GPGB_SHPP_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shared Parental Pay |
| 28 | GPGB_SMP_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SMP |
| 29 | GPGB_ORD_SPP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | RTI Adjustment Submissions - Ordinary Statutory Paternity Pay |
| 30 | GPGB_ADD_SPP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | RTI Adjustment Submissions - Additional Statutory Paternity Pay |
| 31 | GPGB_PEN2DED_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | State Pension YTD |
| 32 | GPGB_PEN_DED_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Pension Deductions for EYU |
| 33 | GPGB_BEN_TAX_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Benefit Tax Adjustment |
| 34 | GPGB_DSGS_RMN_EYU | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Disguised Remuneration |
| 35 | GPGB_FLX_NTAX_PMTC | Character(15) | VARCHAR2(15) NOT NULL | RTI 17 Changes |
| 36 | GPGB_FLX_TAX_PYMTC | Character(15) | VARCHAR2(15) NOT NULL | RTI 17 Changes |
| 37 | TAX_CODE_UK | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 38 | TAX_CODE_UK_1 | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 39 | TAX_CODE_UK_2 | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 40 | TAX_CODE_UK_3 | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 41 | GPGB_TRIV_COMA_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 42 | GPGB_TRIV_COMB_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 43 | GPGB_TRIV_COMC_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Storing TRIV AC COMM PTD A for RTI |
| 44 | FREQUENCY_ID | Character(5) | VARCHAR2(5) NOT NULL | Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. |
| 45 | GPGB_TAX_PERIOD | Number(3,0) | SMALLINT NOT NULL | Tax Period |
| 46 | GPGB_TAX_M_PERIOD | Number(3,0) | SMALLINT NOT NULL | Tax Period |
| 47 | PYMT_DT | Date(10) | DATE | Payment Date |
| 48 | GPGB_PENTYP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the pension type is Occupational or State Pension
0=Occupational Pension 1=State Pension |
| 49 | GPGB_DIRECTORS_NI2 | Character(2) | VARCHAR2(2) NOT NULL | Directors NI |
| 50 | GPGB_IRG_PYMT_IND | Character(1) | VARCHAR2(1) NOT NULL | Irregular Employment Payment Pattern |
| 51 | GPGB_EARN_PRD | Number(3,0) | SMALLINT NOT NULL | Used to store earning period |
| 52 | GPGB_PMT_LEAV_IND | Character(1) | VARCHAR2(1) NOT NULL | RTI XML Payment Leave indicator |
| 53 | GPGB_STD_HRS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Standard hour type for RTI |
| 54 | GPGB_RTI_ADDLINF_0 | Character(1) | VARCHAR2(1) NOT NULL |
Stores Additional information required on employee level data
0=On Strike 1=Unpaid Absence 2=Payment to Non-Individual |
| 55 | GPGB_RTI_ADDLINF_1 | Character(1) | VARCHAR2(1) NOT NULL |
Stores Additional information required on employee level data
0=On Strike 1=Unpaid Absence 2=Payment to Non-Individual |
| 56 | GPGB_OLD_ID_IND | Character(1) | VARCHAR2(1) NOT NULL | RTI XML Old Payroll ID Indicator |
| 57 | GPGB_RTI_OLD_ID | Character(30) | VARCHAR2(30) NOT NULL | Firld to store Old Pyroll ID for RTI |
| 58 | GPGB_DIR_TX_PRD | Character(2) | VARCHAR2(2) NOT NULL | Director Appointment Tax Period used in RTI |
| 59 | TAX_CODE_UK_4 | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 60 | TAX_CODE_UK_5 | Character(15) | VARCHAR2(15) NOT NULL | Tax Code for UK |
| 61 | GPGB_PG_LOAN_PTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Post Graduate Loan PTD |
| 62 | GPGB_SPBP_EYU | Number(12,2) | DECIMAL(11,2) NOT NULL | GP UK Statutory Parental Bereavement Pay Adjustment |
| 63 | GPGB_TER_ER_YTD | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GP UK Termination Payment |