VIEW: HR.PAY_GB_EPS_DETAILS#

Source

View Text - Preformatted

select EPS_RECORD_ID EPS_RECORD_ID, EMP_PAYE_REFERENCE EMP_PAYE_REFERENCE, ACCOUNT_OFFICE_NUMBER ACCOUNT_OFFICE_NUMBER, EMPLOYER_NAME EMPLOYER_NAME, ECON_NUMBER ECON_NUMBER, EFFECTIVE_DATE EFFECTIVE_DATE, RELATED_TAX_YEAR RELATED_TAX_YEAR, SMP_SAP_SPP_RECOVERY SMP_SAP_SPP_RECOVERY, SSP_RECOVERY SSP_RECOVERY, NIC_RECOVERY NIC_RECOVERY, TAX_FREE_PYMT TAX_FREE_PYMT, EMP_THIRD_PARTY EMP_THIRD_PARTY, EXP_BEN_OTHERS EXP_BEN_OTHERS, P11D_DUE P11D_DUE, EMP_OUTSIDE_UK EMP_OUTSIDE_UK, PAYMENT_DUE PAYMENT_DUE, FINAL_SUBMISSION_CEASED FINAL_SUBMISSION_CEASED, FINAL_SUBMISSION_YEAR FINAL_SUBMISSION_YEAR, SERVICE_COMPANY SERVICE_COMPANY, SMP_AMT_RECOVERED SMP_AMT_RECOVERED, SAP_AMT_RECOVERED SAP_AMT_RECOVERED, OSPP_AMT_RECOVERED OSPP_AMT_RECOVERED, ASPP_AMT_RECOVERED ASPP_AMT_RECOVERED, SSP_AMT_RECOVERED SSP_AMT_RECOVERED, NIC_COMP_SMP NIC_COMP_SMP, NIC_COMP_SAP NIC_COMP_SAP, NIC_COMP_OSPP NIC_COMP_OSPP, NIC_COMP_ASPP NIC_COMP_ASPP, NIC_COMP_SSP NIC_COMP_SSP, SMP_AMT_RECOVERED_CALC SMP_AMT_RECOVERED_CALC, SAP_AMT_RECOVERED_CALC SAP_AMT_RECOVERED_CALC, OSPP_AMT_RECOVERED_CALC OSPP_AMT_RECOVERED_CALC, ASPP_AMT_RECOVERED_CALC ASPP_AMT_RECOVERED_CALC, SSP_AMT_RECOVERED_CALC SSP_AMT_RECOVERED_CALC, NIC_COMP_SMP_CALC NIC_COMP_SMP_CALC, NIC_COMP_SAP_CALC NIC_COMP_SAP_CALC, NIC_COMP_OSPP_CALC NIC_COMP_OSPP_CALC, NIC_COMP_ASPP_CALC NIC_COMP_ASPP_CALC, NIC_COMP_SSP_CALC NIC_COMP_SSP_CALC, CIS_DEDUCTIONS_STUFF CIS_DEDUCTIONS_STUFF, NIC_HOLIDAY_VAL NIC_HOLIDAY_VAL, ADV_FROM_HMRC ADV_FROM_HMRC, CREATED_DATE CREATED_DATE, LAST_UPDATED_DATE LAST_UPDATED_DATE, STATUS STATUS, USER_ID USER_ID, APPROVER_ID APPROVER_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DATE_SCHEME_CEASED DATE_SCHEME_CEASED, NO_PAYMENT_DATE_FROM NO_PAYMENT_DATE_FROM, NO_PAYMENT_DATE_TO NO_PAYMENT_DATE_TO, PERIOD_OF_INACTIVITY_FROM PERIOD_OF_INACTIVITY_FROM, PERIOD_OF_INACTIVITY_TO PERIOD_OF_INACTIVITY_TO from "HR"."PAY_GB_EPS_DETAILS"

View Text - HTML Formatted

SELECT EPS_RECORD_ID EPS_RECORD_ID
, EMP_PAYE_REFERENCE EMP_PAYE_REFERENCE
, ACCOUNT_OFFICE_NUMBER ACCOUNT_OFFICE_NUMBER
, EMPLOYER_NAME EMPLOYER_NAME
, ECON_NUMBER ECON_NUMBER
, EFFECTIVE_DATE EFFECTIVE_DATE
, RELATED_TAX_YEAR RELATED_TAX_YEAR
, SMP_SAP_SPP_RECOVERY SMP_SAP_SPP_RECOVERY
, SSP_RECOVERY SSP_RECOVERY
, NIC_RECOVERY NIC_RECOVERY
, TAX_FREE_PYMT TAX_FREE_PYMT
, EMP_THIRD_PARTY EMP_THIRD_PARTY
, EXP_BEN_OTHERS EXP_BEN_OTHERS
, P11D_DUE P11D_DUE
, EMP_OUTSIDE_UK EMP_OUTSIDE_UK
, PAYMENT_DUE PAYMENT_DUE
, FINAL_SUBMISSION_CEASED FINAL_SUBMISSION_CEASED
, FINAL_SUBMISSION_YEAR FINAL_SUBMISSION_YEAR
, SERVICE_COMPANY SERVICE_COMPANY
, SMP_AMT_RECOVERED SMP_AMT_RECOVERED
, SAP_AMT_RECOVERED SAP_AMT_RECOVERED
, OSPP_AMT_RECOVERED OSPP_AMT_RECOVERED
, ASPP_AMT_RECOVERED ASPP_AMT_RECOVERED
, SSP_AMT_RECOVERED SSP_AMT_RECOVERED
, NIC_COMP_SMP NIC_COMP_SMP
, NIC_COMP_SAP NIC_COMP_SAP
, NIC_COMP_OSPP NIC_COMP_OSPP
, NIC_COMP_ASPP NIC_COMP_ASPP
, NIC_COMP_SSP NIC_COMP_SSP
, SMP_AMT_RECOVERED_CALC SMP_AMT_RECOVERED_CALC
, SAP_AMT_RECOVERED_CALC SAP_AMT_RECOVERED_CALC
, OSPP_AMT_RECOVERED_CALC OSPP_AMT_RECOVERED_CALC
, ASPP_AMT_RECOVERED_CALC ASPP_AMT_RECOVERED_CALC
, SSP_AMT_RECOVERED_CALC SSP_AMT_RECOVERED_CALC
, NIC_COMP_SMP_CALC NIC_COMP_SMP_CALC
, NIC_COMP_SAP_CALC NIC_COMP_SAP_CALC
, NIC_COMP_OSPP_CALC NIC_COMP_OSPP_CALC
, NIC_COMP_ASPP_CALC NIC_COMP_ASPP_CALC
, NIC_COMP_SSP_CALC NIC_COMP_SSP_CALC
, CIS_DEDUCTIONS_STUFF CIS_DEDUCTIONS_STUFF
, NIC_HOLIDAY_VAL NIC_HOLIDAY_VAL
, ADV_FROM_HMRC ADV_FROM_HMRC
, CREATED_DATE CREATED_DATE
, LAST_UPDATED_DATE LAST_UPDATED_DATE
, STATUS STATUS
, USER_ID USER_ID
, APPROVER_ID APPROVER_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DATE_SCHEME_CEASED DATE_SCHEME_CEASED
, NO_PAYMENT_DATE_FROM NO_PAYMENT_DATE_FROM
, NO_PAYMENT_DATE_TO NO_PAYMENT_DATE_TO
, PERIOD_OF_INACTIVITY_FROM PERIOD_OF_INACTIVITY_FROM
, PERIOD_OF_INACTIVITY_TO PERIOD_OF_INACTIVITY_TO
FROM "HR"."PAY_GB_EPS_DETAILS"