[Home] [Help] [Dependency Information]
Object Name: | PAY_CA_EOY_RL1_REG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_CA_EOY_RL1_REG_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 |
---|---|---|---|---|
QUEBEC_BUSINESS_NUMBER | VARCHAR2 | (4000) | ||
PROV_REPORTING_EST | VARCHAR2 | (4000) | ||
TAXATION_YEAR | VARCHAR2 | (4000) | ||
EMPLOYER_NAME | VARCHAR2 | (4000) | ||
EMPLR_ADDRESS_LINE1 | VARCHAR2 | (4000) | ||
EMPLR_ADDRESS_LINE2 | VARCHAR2 | (4000) | ||
EMPLR_ADDRESS_LINE3 | VARCHAR2 | (4000) | ||
EMPLR_CITY | VARCHAR2 | (4000) | ||
EMPLR_PROVINCE | VARCHAR2 | (4000) | ||
EMPLR_COUNTRY | VARCHAR2 | (4000) | ||
EMPLR_POSTAL_CODE | VARCHAR2 | (4000) | ||
SIN | VARCHAR2 | (4000) | ||
EMPLOYEE_SURNAME | VARCHAR2 | (4000) | ||
EMPLOYEE_FIRSTNAME | 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) | ||
EMP_NUMBER | VARCHAR2 | (4000) | ||
GROSS_EARNINGS | VARCHAR2 | (4000) | ||
QPP_EE_WITHHELD | VARCHAR2 | (4000) | ||
EI_EE_WITHHELD | VARCHAR2 | (4000) | ||
BOXD | VARCHAR2 | (4000) | ||
BOXE | VARCHAR2 | (4000) | ||
BOXF | VARCHAR2 | (4000) | ||
BOXG | VARCHAR2 | (4000) | ||
BOXH | VARCHAR2 | (4000) | ||
BOXI | VARCHAR2 | (4000) | ||
BOXJ | VARCHAR2 | (4000) | ||
BOXK | VARCHAR2 | (4000) | ||
BOXL | VARCHAR2 | (4000) | ||
BOXM | VARCHAR2 | (4000) | ||
BOXN | VARCHAR2 | (4000) | ||
BOXO | VARCHAR2 | (4000) | ||
BOXP | VARCHAR2 | (4000) | ||
BOXQ | VARCHAR2 | (4000) | ||
BOXR | VARCHAR2 | (4000) | ||
BOXS | VARCHAR2 | (4000) | ||
BOXT | VARCHAR2 | (4000) | ||
BOXU | VARCHAR2 | (4000) | ||
BOXV | VARCHAR2 | (4000) | ||
BOXW | VARCHAR2 | (4000) | ||
PROVINCE_OF_EMPLOYMENT | VARCHAR2 | (4000) | ||
PERSON_ID | VARCHAR2 | (4000) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
RL1_SLIP_NUMBER | VARCHAR2 | (4000) | ||
SOURCE_O | VARCHAR2 | (4000) | ||
CPP_WITHHELD | VARCHAR2 | (4000) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (4000) | ||
DATE_OF_BIRTH | VARCHAR2 | (4000) | ||
HIRE_DATE | VARCHAR2 | (4000) | ||
TERMINATION_DATE | VARCHAR2 | (4000) | ||
REPORT_TYPE | VARCHAR2 | (30) | ||
NEGATIVE_BALANCE_FLAG | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PAY_CA_EOY_RL1_REG_V;
|
|
|