eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PAY_HK_IR56_EMPLOYEE_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)
RESIDENTIAL_TEL_NUMBER	VARCHAR2	(184)
CORRESPONDENCE_ADDRESS	VARCHAR2	(900)
CORRESPONDENCE_TEL_NUMBER	VARCHAR2	(184)
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

Query Text

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
,      RESIDENTIAL_TEL_NUMBER
,      CORRESPONDENCE_ADDRESS
,      CORRESPONDENCE_TEL_NUMBER
,      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;

Dependencies

[top of page]

APPS.PAY_HK_IR56_EMPLOYEE_V references the following:

APPS: FND_NUMBER - show dependent code; FND_TERRITORIES_VL; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_LOOKUPS; HR_ORGANIZATION_INFORMATION; HR_ORGANIZATION_UNITS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; HR_SOFT_CODING_KEYFLEX; PAY_HK_IR56_SPOUSE_DETAILS_V; PER_ADDRESSES; PER_ASSIGNMENTS_F; PER_ASSIGNMENT_EXTRA_INFO; PER_PEOPLE_F; PER_PERIODS_OF_SERVICE

APPS.PAY_HK_IR56_EMPLOYEE_V is not referenced by any database object