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.PER_HU_EMPLOYMENT_CERT_V

Object Details

Object Name:	PER_HU_EMPLOYMENT_CERT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_HU_EMPLOYMENT_CERT_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View is used in Employment Certificate Web ADI Report.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	System generated primary key.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	The system generated primary key.
ORGANIZATION_ID	VARCHAR2	(240)		System generated primary key.
EMPLOYER_LOCATION_NAME	VARCHAR2	(240)		Employer Location Name
EMPLOYER_LOCATION_TYPE	VARCHAR2	(240)		Employer Location Type
EMPLOYER_STREET_NO	VARCHAR2	(240)		Employer Street Number
EMPLOYER_TOWN	VARCHAR2	(240)		Employer Town
EMPLOYER_COUNTY	VARCHAR2	(240)		Employer County
EMPLOYER_POSTAL_CODE	VARCHAR2	(240)		Employer Postal Code
EMPLOYER_BUILDING	VARCHAR2	(240)		ok fine.
EMPLOYER_STAIRWAY	VARCHAR2	(240)		Employer Stairway
EMPLOYER_FLOOR	VARCHAR2	(240)		Employer Floor
EMPLOYER_DOOR	VARCHAR2	(240)		Employer Door
PERSON_ID	VARCHAR2	(240)		System generated primary key.
COMPANY_NAME	VARCHAR2	(240)		Company Name
FULL_NAME	VARCHAR2	(240)		Full Name
MAIDEN_NAME	VARCHAR2	(240)		Maidan Name
TAJ_CODE	VARCHAR2	(240)		TAJ Code
PLACE_OF_BIRTH	VARCHAR2	(240)		Place of Birth
DATE_OF_BIRTH	VARCHAR2	(240)		Date of Birth
MOTHER_MAIDEN_NAME	VARCHAR2	(240)		Mother Maiden Name
HIRE_DATE	VARCHAR2	(240)		Hire Date
TERMINATION_DATE	VARCHAR2	(240)		Termination Date
SICKNESS_HOLIDAY	VARCHAR2	(240)		Sickness Holiday
RAILWAY_BENEFIT	VARCHAR2	(240)		Railway Benefit
PENSION_FUND_DATE_OF_ENTRANCE	VARCHAR2	(240)		Pension Fund Date of Entrance
PRIVATE_PENSION_FUND_CODE	VARCHAR2	(240)		Private Pension Fund Code
PRIVATE_PENSION_FUND_NAME	VARCHAR2	(240)		Private Pension Fund Name
PRIVATE_PENSION_FUND_ADDRESS	VARCHAR2	(240)		Private Pension Fund Address
PRIVATE_PENSION_FUND_ACC_NO	VARCHAR2	(240)		Private Pension Fund Account Number
VOLUNTARY_PENSION_FUND_NAME1	VARCHAR2	(240)		Voluntary Pension Fund Name1
VOLUNTARY_PENSION_FUND_NAME2	VARCHAR2	(240)		Voluntary Pension Fund Name2
VOLUNTARY_PENSION_FUND_NAME3	VARCHAR2	(240)		Voluntary Pension Fund Name3
VOLUNTARY_PENSION_FUND_NAME4	VARCHAR2	(240)		Voluntary Pension Fund Name4
VOLUNTARY_PENSION_FUND_NAME5	VARCHAR2	(240)		Voluntary Pension Fund Name5
ISSUE_DATE	VARCHAR2	(240)		Issue Date
EMPLOYEE_LOCATION_NAME	VARCHAR2	(240)		Employee Location Name
EMPLOYEE_LOCATION_TYPE	VARCHAR2	(240)		Employee Location Type
EMPLOYEE_STREET_NO	VARCHAR2	(240)		Employee Street No
EMPLOYEE_TOWN	VARCHAR2	(240)		Employee Town
EMPLOYEE_POSTAL_CODE	VARCHAR2	(240)		Employee Postal Code
EMPLOYEE_BUILDING	VARCHAR2	(240)		Employee Building
EMPLOYEE_STAIRWAY	VARCHAR2	(240)		Employee Stairway
EMPLOYEE_FLOOR	VARCHAR2	(240)		Employee Stairway
EMPLOYEE_DOOR	VARCHAR2	(240)		Employee Door
SETTLEMENT_PAID	CHAR	(1)		Settlement Paid

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYROLL_ACTION_ID
,      REQUEST_ID
,      ASSIGNMENT_ACTION_ID
,      ORGANIZATION_ID
,      EMPLOYER_LOCATION_NAME
,      EMPLOYER_LOCATION_TYPE
,      EMPLOYER_STREET_NO
,      EMPLOYER_TOWN
,      EMPLOYER_COUNTY
,      EMPLOYER_POSTAL_CODE
,      EMPLOYER_BUILDING
,      EMPLOYER_STAIRWAY
,      EMPLOYER_FLOOR
,      EMPLOYER_DOOR
,      PERSON_ID
,      COMPANY_NAME
,      FULL_NAME
,      MAIDEN_NAME
,      TAJ_CODE
,      PLACE_OF_BIRTH
,      DATE_OF_BIRTH
,      MOTHER_MAIDEN_NAME
,      HIRE_DATE
,      TERMINATION_DATE
,      SICKNESS_HOLIDAY
,      RAILWAY_BENEFIT
,      PENSION_FUND_DATE_OF_ENTRANCE
,      PRIVATE_PENSION_FUND_CODE
,      PRIVATE_PENSION_FUND_NAME
,      PRIVATE_PENSION_FUND_ADDRESS
,      PRIVATE_PENSION_FUND_ACC_NO
,      VOLUNTARY_PENSION_FUND_NAME1
,      VOLUNTARY_PENSION_FUND_NAME2
,      VOLUNTARY_PENSION_FUND_NAME3
,      VOLUNTARY_PENSION_FUND_NAME4
,      VOLUNTARY_PENSION_FUND_NAME5
,      ISSUE_DATE
,      EMPLOYEE_LOCATION_NAME
,      EMPLOYEE_LOCATION_TYPE
,      EMPLOYEE_STREET_NO
,      EMPLOYEE_TOWN
,      EMPLOYEE_POSTAL_CODE
,      EMPLOYEE_BUILDING
,      EMPLOYEE_STAIRWAY
,      EMPLOYEE_FLOOR
,      EMPLOYEE_DOOR
,      SETTLEMENT_PAID
FROM APPS.PER_HU_EMPLOYMENT_CERT_V;

Dependencies

[top of page]

APPS.PER_HU_EMPLOYMENT_CERT_V references the following:

APPS: PAY_ACTION_INFORMATION; PAY_ASSIGNMENT_ACTIONS; PAY_PAYROLL_ACTIONS

APPS.PER_HU_EMPLOYMENT_CERT_V is not referenced by any database object