eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_CA_EOY_RL1_REG_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CA_EOY_RL1_REG_V

View Text

SELECT PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_QUEBEC_BN') QUEBEC_BUSINESS_NUMBER
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_PRE_ORG_ID') PROV_REPORTING_EST
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_TAXATION_YEAR') TAXATION_YEAR
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_NAME') EMPLOYER_NAME
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE1') EMPLR_ADDRESS_LINE1
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE2') EMPLR_ADDRESS_LINE2
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_ADDRESS_LINE3') EMPLR_ADDRESS_LINE3
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_CITY') EMPLR_CITY
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_PROVINCE') EMPLR_PROVINCE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_COUNTRY') EMPLR_COUNTRY
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(PPA.PAYROLL_ACTION_ID
, 'CAEOY_RL1_EMPLOYER_POSTAL_CODE') EMPLR_POSTAL_CODE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_SIN') SIN
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_LAST_NAME') EMPLOYEE_SURNAME
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_FIRST_NAME') EMPLOYEE_FIRSTNAME
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_INITIAL') EMPLOYEE_INITIAL
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE1') EMP_ADDRESS_LINE1
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE2') EMP_ADDRESS_LINE2
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE3') EMP_ADDRESS_LINE3
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_CITY') EMP_CITY
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_PROVINCE') EMP_PROVINCE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_COUNTRY') EMP_COUNTRY
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_POSTAL_CODE') EMP_POSTAL_CODE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_NUMBER') EMP_NUMBER
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_GROSS_EARNINGS_PER_JD_YTD') GROSS_EARNINGS
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_QPP_EE_WITHHELD_PER_JD_YTD') QPP_EE_WITHHELD
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EI_EE_WITHHELD_PER_JD_YTD') EI_EE_WITHHELD
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXD_PER_JD_YTD') BOXD
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_PROV_WITHHELD_PER_JD_YTD') BOXE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXF_PER_JD_YTD') BOXF
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_QPP_REDUCED_SUBJECT_PER_JD_YTD') BOXG
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXH_PER_JD_YTD') BOXH
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXI_PER_JD_YTD') BOXI
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXJ_PER_JD_YTD') BOXJ
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXK_PER_JD_YTD') BOXK
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXL_PER_JD_YTD') BOXL
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXM_PER_JD_YTD') BOXM
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXN_PER_JD_YTD') BOXN
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXO_PER_JD_YTD') BOXO
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXP_PER_JD_YTD') BOXP
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXQ_PER_JD_YTD') BOXQ
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXR_PER_JD_YTD') BOXR
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXS_PER_JD_YTD') BOXS
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXT_PER_JD_YTD') BOXT
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXU_PER_JD_YTD') BOXU
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_PPIP_EE_WITHHELD_PER_JD_YTD') BOXV
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_PPIP_EE_TAXABLE_PER_JD_YTD') BOXW
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT') PROVINCE_OF_EMPLOYMENT
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_PERSON_ID') PERSON_ID
, PPA.BUSINESS_GROUP_ID
, PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, FAI.CONTEXT1 ASSIGNMENT_ACTION_ID
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_SLIP_NUMBER')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_BOXO_CODE_PER_JD_YTD') SOURCE_O
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_CPP_EE_WITHHELD_PER_YTD') CPP_WITHHELD
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_NUMBER') EMPLOYEE_NUMBER
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_DATE_OF_BIRTH') DATE_OF_BIRTH
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_HIRE_DATE') HIRE_DATE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_TERMINATION_DATE') TERMINATION_DATE
, PPA.REPORT_TYPE REPORT_TYPE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_RL1_NEGATIVE_BALANCE_EXISTS') NEGATIVE_BALANCE_FLAG
FROM FF_ARCHIVE_ITEMS FAI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE='X'||''
AND PPA.REPORT_TYPE IN ('RL1'
, 'CAEOY_RL1_AMEND_PP')
AND PPA.ACTION_STATUS='C'||''
AND PAA.ASSIGNMENT_ACTION_ID=FAI.CONTEXT1 GROUP BY FAI.CONTEXT1
, PPA.PAYROLL_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, PPA.REPORT_TYPE

Columns

Name
QUEBEC_BUSINESS_NUMBER
PROV_REPORTING_EST
TAXATION_YEAR
EMPLOYER_NAME
EMPLR_ADDRESS_LINE1
EMPLR_ADDRESS_LINE2
EMPLR_ADDRESS_LINE3
EMPLR_CITY
EMPLR_PROVINCE
EMPLR_COUNTRY
EMPLR_POSTAL_CODE
SIN
EMPLOYEE_SURNAME
EMPLOYEE_FIRSTNAME
EMPLOYEE_INITIAL
EMP_ADDRESS_LINE1
EMP_ADDRESS_LINE2
EMP_ADDRESS_LINE3
EMP_CITY
EMP_PROVINCE
EMP_COUNTRY
EMP_POSTAL_CODE
EMP_NUMBER
GROSS_EARNINGS
QPP_EE_WITHHELD
EI_EE_WITHHELD
BOXD
BOXE
BOXF
BOXG
BOXH
BOXI
BOXJ
BOXK
BOXL
BOXM
BOXN
BOXO
BOXP
BOXQ
BOXR
BOXS
BOXT
BOXU
BOXV
BOXW
PROVINCE_OF_EMPLOYMENT
PERSON_ID
BUSINESS_GROUP_ID
PAYROLL_ACTION_ID
ASSIGNMENT_ACTION_ID
RL1_SLIP_NUMBER
SOURCE_O
CPP_WITHHELD
EMPLOYEE_NUMBER
DATE_OF_BIRTH
HIRE_DATE
TERMINATION_DATE
REPORT_TYPE
NEGATIVE_BALANCE_FLAG