[Home] [Help] [Dependency Information]
Object Name: | PAY_CA_EOY_T4A_REG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_CA_EOY_T4A_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 |
---|---|---|---|---|
SIN | VARCHAR2 | (4000) | ||
EMPLOYEE_NUMBER | 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 | |
T4A_BOX16 | VARCHAR2 | (4000) | ||
T4A_BOX18 | VARCHAR2 | (4000) | ||
T4A_BOX20 | VARCHAR2 | (4000) | ||
T4A_BOX22 | VARCHAR2 | (4000) | ||
T4A_BOX24 | VARCHAR2 | (4000) | ||
T4A_BOX26 | VARCHAR2 | (4000) | ||
T4A_BOX27 | VARCHAR2 | (4000) | ||
T4A_BOX28 | VARCHAR2 | (4000) | ||
T4A_BOX30 | VARCHAR2 | (4000) | ||
T4A_BOX32 | VARCHAR2 | (4000) | ||
T4A_BOX34 | VARCHAR2 | (4000) | ||
T4A_BOX36 | VARCHAR2 | (4000) | ||
T4A_BOX38 | VARCHAR2 | (4000) | ||
T4A_BOX40 | VARCHAR2 | (4000) | ||
T4A_BOX42 | VARCHAR2 | (4000) | ||
T4A_BOX46 | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT SIN
, EMPLOYEE_NUMBER
, 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
, T4A_BOX16
, T4A_BOX18
, T4A_BOX20
, T4A_BOX22
, T4A_BOX24
, T4A_BOX26
, T4A_BOX27
, T4A_BOX28
, T4A_BOX30
, T4A_BOX32
, T4A_BOX34
, T4A_BOX36
, T4A_BOX38
, T4A_BOX40
, T4A_BOX42
, T4A_BOX46
FROM APPS.PAY_CA_EOY_T4A_REG_V;
|
|
|