[Home] [Help] [Dependency Information]
Object Name: | PAY_CA_EOY_REGISTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_CA_EOY_REGISTER_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SIN | VARCHAR2 | (4000) | ||
CPP_QPP_EXEMPT | VARCHAR2 | (4000) | ||
EI_EXEMPT | VARCHAR2 | (4000) | ||
EMPLOYMENT_CODE | VARCHAR2 | (4000) | ||
RPP_DPSP_REG_NO | VARCHAR2 | (4000) | ||
EMPLOYEE_SURNAME | VARCHAR2 | (4000) | ||
EMPLOYEE_FIRST_NAME | VARCHAR2 | (4000) | ||
EMPLOYEE_INITIAL | VARCHAR2 | (4000) | ||
EMP_ADDRESS_LINE1 | VARCHAR2 | (4000) | ||
EMP_ADDRESS_LINE2 | VARCHAR2 | (4000) | ||
EMP_ADDRESS_LINE3 | VARCHAR2 | (4000) | ||
EMP_CITY | VARCHAR2 | (4000) | ||
EMP_PROVINCE | VARCHAR2 | (4000) | ||
EMP_COUNTRY | VARCHAR2 | (4000) | ||
EMP_POSTAL_CODE | VARCHAR2 | (4000) | ||
ORGANIZATION_ID | VARCHAR2 | (4000) | ||
LOCATION_ID | VARCHAR2 | (4000) | ||
PERSON_ID | VARCHAR2 | (4000) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
TAX_UNIT_ID | NUMBER | (15) | ||
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
CONTEXT | VARCHAR2 | (30) | Yes | |
EMPLOYMENT_INCOME | VARCHAR2 | (4000) | ||
INCOME_TAX_DEDUCTED | VARCHAR2 | (4000) | ||
EMPLOYEES_CPP | VARCHAR2 | (4000) | ||
EMPLOYEES_QPP | VARCHAR2 | (4000) | ||
EMPLOYEES_EI | VARCHAR2 | (4000) | ||
RPP_CONTRIBUTION | VARCHAR2 | (4000) | ||
PENSION_ADJUSTMENT | VARCHAR2 | (4000) | ||
EI_INSURABLE_EARNINGS | VARCHAR2 | (4000) | ||
CPP_EARNINGS | VARCHAR2 | (4000) | ||
QPP_EARNINGS | VARCHAR2 | (4000) | ||
UNION_DUES | VARCHAR2 | (4000) | ||
CHARITABLE_DONATIONS | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_30 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_31 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_32 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_33 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_34 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_35 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_36 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_37 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_38 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_39 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_40 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_41 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_42 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_70 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_71 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_72 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_73 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_74 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_75 | VARCHAR2 | (4000) | ||
T4_OTHER_INFO_AMT_76 | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PAY_CA_EOY_REGISTER_V;
APPS.PAY_CA_EOY_REGISTER_V is not referenced by any database object
|
|
|