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

Object Details

Object Name:	CSC_HZ_EMPLOYMENT_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_HZ_EMPLOYMENT_HISTORY_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYMENT_HISTORY_ID	NUMBER	(15)	Yes	Employment history identifier
BEGIN_DATE	DATE			The date that the employment officially began.
PARTY_ID	NUMBER	(15)	Yes	Party identifier. FK to HZ_PARTIES
EMPLOYED_AS_TITLE	VARCHAR2	(60)		The formal name for the position at that place of employment
EMPLOYED_BY_DIVISION_NAME	VARCHAR2	(60)		The common name of a division or an organization in which the PERSON was employed.
EMPLOYED_BY_NAME_COMPANY	VARCHAR2	(60)		The name of the organization at which the person was employeed. Note that the name
END_DATE	DATE			A date that the employment officially ended.
SUPERVISOR_NAME	VARCHAR2	(60)		The full name of the person to whom the person reported.
BRANCH	VARCHAR2	(80)		Military branch code
MILITARY_RANK	VARCHAR2	(240)		The person's rank in the branch
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
SERVED	VARCHAR2	(240)		Where the person served while working for the branch
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
STATION	VARCHAR2	(240)		Station name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
WH_UPDATE_DATE	DATE			Warehouse update date when record was recorded or changed
RESPONSIBILITY	VARCHAR2	(240)		Job Responsibility of the Person Party in the Company.
STATUS	VARCHAR2	(0)		Record status flag
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number for locking purpose

Query Text

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


SELECT EMPLOYMENT_HISTORY_ID
,      BEGIN_DATE
,      PARTY_ID
,      EMPLOYED_AS_TITLE
,      EMPLOYED_BY_DIVISION_NAME
,      EMPLOYED_BY_NAME_COMPANY
,      END_DATE
,      SUPERVISOR_NAME
,      BRANCH
,      MILITARY_RANK
,      CREATED_BY
,      CREATION_DATE
,      SERVED
,      LAST_UPDATE_LOGIN
,      STATION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      RESPONSIBILITY
,      STATUS
,      OBJECT_VERSION_NUMBER
FROM APPS.CSC_HZ_EMPLOYMENT_HISTORY_V;

Dependencies

[top of page]

APPS.CSC_HZ_EMPLOYMENT_HISTORY_V references the following:

APPS: HZ_EMPLOYMENT_HISTORY

APPS.CSC_HZ_EMPLOYMENT_HISTORY_V is not referenced by any database object