[Home] [Help] [Dependency Information]
Object Name: | PAY_HK_IR56_EMPLOYEE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_HK_IR56_EMPLOYEE_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 |
---|---|---|---|---|
PERSON_ID | NUMBER | (10) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
EMPLOYER_RETURN_FILE_NO | VARCHAR2 | (150) | ||
DESIGNATION | VARCHAR2 | (150) | ||
DESIGNATION_NAME | VARCHAR2 | (150) | ||
EMPLOYER_RETURN_LAST_8 | VARCHAR2 | (150) | ||
EMPLOYER_NAME | VARCHAR2 | (240) | Yes | |
EMPLOYER_ADDRESS | VARCHAR2 | (818) | ||
TITLE | VARCHAR2 | (30) | ||
FULL_NAME | VARCHAR2 | (150) | ||
LAST_NAME | VARCHAR2 | (150) | Yes | |
MAIDEN_NAME | VARCHAR2 | (150) | ||
EMPLOYEE_TAX_FILE_NO | VARCHAR2 | (150) | ||
HK_ID_CARD_NO | VARCHAR2 | (30) | ||
PASSPORT_NUMBER | VARCHAR2 | (231) | ||
SEX | VARCHAR2 | (1) | ||
MARITAL_STATUS | NUMBER | |||
SPOUSE_NAME | VARCHAR2 | (364) | ||
SPOUSE_HK_ID_CARD_NO | VARCHAR2 | (30) | ||
SPOUSE_PASSPORT_NUMBER | VARCHAR2 | (231) | ||
RESIDENTIAL_ADDRESS | VARCHAR2 | (900) | ||
CORRESPONDENCE_ADDRESS | VARCHAR2 | (900) | ||
CAPACITY_EMPLOYED | VARCHAR2 | (150) | ||
LEGAL_EMPLOYER_ID | VARCHAR2 | (60) | ||
PRINCIPAL_EMPLOYER_NAME | VARCHAR2 | (60) | ||
EXPECTED_CESSATION_DATE | VARCHAR2 | (10) | ||
EMPLOYMENT_PERIOD | VARCHAR2 | (24) | ||
LEAVING_REASON | VARCHAR2 | (80) | ||
NEW_EMPLOYER_NAME_ADDRESS | VARCHAR2 | (150) | ||
FUTURE_CORRESPONDENCE_ADDRESS | VARCHAR2 | (658) | ||
DEPARTURE_DATE | VARCHAR2 | (150) | ||
DEPARTURE_REASON | VARCHAR2 | (80) | ||
DEPARTURE_REASON_SELECT | VARCHAR2 | (150) | ||
RETURN_TO_HK | VARCHAR2 | (150) | ||
PROBABLE_RETURN_DATE | VARCHAR2 | (150) | ||
SALARIES_TAX_BORNE_BY_EMPLOYER | VARCHAR2 | (150) | ||
COUNTRY_RETURNING_TO | VARCHAR2 | (150) | ||
SECONDED_TO | VARCHAR2 | (150) | ||
MONIES_HELD_SECTION52 | VARCHAR2 | (60) | ||
AMOUNT_MONIES_HELD_SECTION52 | VARCHAR2 | (60) | ||
REASON_NO_HOLD_SECTION52 | VARCHAR2 | (60) | ||
SERVICE_DATE_START | DATE | Yes | ||
SERVICE_TERMINATION_DATE | DATE | |||
FINAL_PROCESS_DATE | DATE | |||
SERVICE_TAX_REPORTING_YEAR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, ASSIGNMENT_ID
, EMPLOYER_RETURN_FILE_NO
, DESIGNATION
, DESIGNATION_NAME
, EMPLOYER_RETURN_LAST_8
, EMPLOYER_NAME
, EMPLOYER_ADDRESS
, TITLE
, FULL_NAME
, LAST_NAME
, MAIDEN_NAME
, EMPLOYEE_TAX_FILE_NO
, HK_ID_CARD_NO
, PASSPORT_NUMBER
, SEX
, MARITAL_STATUS
, SPOUSE_NAME
, SPOUSE_HK_ID_CARD_NO
, SPOUSE_PASSPORT_NUMBER
, RESIDENTIAL_ADDRESS
, CORRESPONDENCE_ADDRESS
, CAPACITY_EMPLOYED
, LEGAL_EMPLOYER_ID
, PRINCIPAL_EMPLOYER_NAME
, EXPECTED_CESSATION_DATE
, EMPLOYMENT_PERIOD
, LEAVING_REASON
, NEW_EMPLOYER_NAME_ADDRESS
, FUTURE_CORRESPONDENCE_ADDRESS
, DEPARTURE_DATE
, DEPARTURE_REASON
, DEPARTURE_REASON_SELECT
, RETURN_TO_HK
, PROBABLE_RETURN_DATE
, SALARIES_TAX_BORNE_BY_EMPLOYER
, COUNTRY_RETURNING_TO
, SECONDED_TO
, MONIES_HELD_SECTION52
, AMOUNT_MONIES_HELD_SECTION52
, REASON_NO_HOLD_SECTION52
, SERVICE_DATE_START
, SERVICE_TERMINATION_DATE
, FINAL_PROCESS_DATE
, SERVICE_TAX_REPORTING_YEAR
FROM APPS.PAY_HK_IR56_EMPLOYEE_V;
|
|
|