FND Design Data [Home] [Help]

View: PAY_CA_EOY_REGISTER_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAY_CA_EOY_REGISTER_V
View Text

SELECT PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_SIN')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_CPP_QPP_EXEMPT')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_EI_EXEMPT')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYMENT_CODE')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4_EMPLOYEE_REGISTRATION_NO')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_LAST_NAME')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_FIRST_NAME')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_INITIAL')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE1')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE2')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE3')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_CITY')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_PROVINCE')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_COUNTRY')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_POSTAL_CODE')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4_ORGANIZATION_ID')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4_LOCATION_ID')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_PERSON_ID')
, PPA.BUSINESS_GROUP_ID
, PAA.TAX_UNIT_ID
, PPA.PAYROLL_ACTION_ID
, FAI.CONTEXT1
, FAC.CONTEXT
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_FED_WITHHELD_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_CPP_EE_WITHHELD_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_QPP_EE_WITHHELD_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_BOX20_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_BOX52_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_CPP_EE_TAXABLE_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_QPP_EE_TAXABLE_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_BOX44_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_BOX46_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT30_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT31_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT32_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT33_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT34_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT35_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT36_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT37_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT38_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT39_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT40_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT41_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT42_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT70_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT71_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT72_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT73_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT74_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT75_PER_JD_GRE_YTD')
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, FAC.CONTEXT
, 'JURISDICTION_CODE'
, 'CAEOY_T4_OTHER_INFO_AMOUNT76_PER_JD_GRE_YTD')
FROM FF_CONTEXTS FC
, FF_ARCHIVE_ITEM_CONTEXTS FAC
, 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='T4'
AND PPA.ACTION_STATUS='C'
AND PAA.ASSIGNMENT_ACTION_ID=FAI.CONTEXT1
AND FAI.ARCHIVE_ITEM_ID = FAC.ARCHIVE_ITEM_ID
AND FAC.CONTEXT_ID=FC.CONTEXT_ID
AND FC.CONTEXT_NAME='JURISDICTION_CODE' GROUP BY FAI.CONTEXT1
, FAC.CONTEXT
, PPA.PAYROLL_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, PAA.TAX_UNIT_ID

Columns

Name
SIN
CPP_QPP_EXEMPT
EI_EXEMPT
EMPLOYMENT_CODE
RPP_DPSP_REG_NO
EMPLOYEE_SURNAME
EMPLOYEE_FIRST_NAME
EMPLOYEE_INITIAL
EMP_ADDRESS_LINE1
EMP_ADDRESS_LINE2
EMP_ADDRESS_LINE3
EMP_CITY
EMP_PROVINCE
EMP_COUNTRY
EMP_POSTAL_CODE
ORGANIZATION_ID
LOCATION_ID
PERSON_ID
BUSINESS_GROUP_ID
TAX_UNIT_ID
PAYROLL_ACTION_ID
ASSIGNMENT_ACTION_ID
CONTEXT
EMPLOYMENT_INCOME
INCOME_TAX_DEDUCTED
EMPLOYEES_CPP
EMPLOYEES_QPP
EMPLOYEES_EI
RPP_CONTRIBUTION
PENSION_ADJUSTMENT
EI_INSURABLE_EARNINGS
CPP_EARNINGS
QPP_EARNINGS
UNION_DUES
CHARITABLE_DONATIONS
T4_OTHER_INFO_AMT_30
T4_OTHER_INFO_AMT_31
T4_OTHER_INFO_AMT_32
T4_OTHER_INFO_AMT_33
T4_OTHER_INFO_AMT_34
T4_OTHER_INFO_AMT_35
T4_OTHER_INFO_AMT_36
T4_OTHER_INFO_AMT_37
T4_OTHER_INFO_AMT_38
T4_OTHER_INFO_AMT_39
T4_OTHER_INFO_AMT_40
T4_OTHER_INFO_AMT_41
T4_OTHER_INFO_AMT_42
T4_OTHER_INFO_AMT_70
T4_OTHER_INFO_AMT_71
T4_OTHER_INFO_AMT_72
T4_OTHER_INFO_AMT_73
T4_OTHER_INFO_AMT_74
T4_OTHER_INFO_AMT_75
T4_OTHER_INFO_AMT_76