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]

TABLE: AR.HZ_EMPLOYMENT_HISTORY

Object Details

Object Name:	HZ_EMPLOYMENT_HISTORY
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_EMPLOYMENT_HISTORY
Subobject Name:
Status:	VALID

The HZ_EMPLOYMENT_HISTORY table stores information about the employment and military service history of a party of the PERSON type. For example, John Smith, an accountant, whose supervisor was Jane Doe, worked in the U.S. Operations division of Vision Corporation from July 12, 1994 to January 23, 2000.
.
The primary key for this table is EMPLOYMENT_HISTORY_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_EMPLOYMENT_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EMPLOYMENT_HISTORY_ID
HZ_EMPLOYMENT_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
HZ_EMPLOYMENT_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYED_BY_PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EMPLOYMENT_HISTORY_ID	NUMBER	(15)	Yes	Unique employment history identifier.
BEGIN_DATE	DATE			The date that the employment officially began.
PARTY_ID	NUMBER	(15)	Yes	Party identifier. Foreign key to the HZ_PARTIES table
EMPLOYED_AS_TITLE	VARCHAR2	(60)		Job position title assigned by an employer
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 should not include the division name.
END_DATE	DATE			The date that the employment officially ended.
SUPERVISOR_NAME	VARCHAR2	(60)		Full name of the person's manager
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 - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
SERVED	VARCHAR2	(240)		Where the person performed military service
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
STATION	VARCHAR2	(240)		Station name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
WH_UPDATE_DATE	DATE			Date when the record was entered or changed in a data warehouse
RESPONSIBILITY	VARCHAR2	(240)		Job responsibility of the person
STATUS	VARCHAR2	(1)		Record status flag
EMPLOYED_BY_PARTY_ID	NUMBER	(15)		Party identifier of the employer for situations in which the employer is represented as a party
REASON_FOR_LEAVING	VARCHAR2	(240)		Free-format text describing the reason for leaving
FACULTY_POSITION_FLAG	VARCHAR2	(1)		Y or N indicates whether the position is a faculty position or not
TENURE_CODE	VARCHAR2	(30)		Type of tenure for faculty positions
FRACTION_OF_TENURE	NUMBER			Fraction of tenure
EMPLOYMENT_TYPE_CODE	VARCHAR2	(30)		Indicates whether the employment is part-time or full-time
EMPLOYED_AS_TITLE_CODE	VARCHAR2	(30)		Code for the job title. If title cannot be represented by a code, then the EMPLOYED_AS_TITLE column should be used.
WEEKLY_WORK_HOURS	NUMBER			Usual number of hours worked per week
COMMENTS	VARCHAR2	(2000)		General comments about the employment history
OBJECT_VERSION_NUMBER	NUMBER			Version number for locking purposes
APPLICATION_ID	NUMBER	(15)		Unique identifier for the application that created this record
CREATED_BY_MODULE	VARCHAR2	(150)		Identifier for the source application module that created this record

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
,      EMPLOYED_BY_PARTY_ID
,      REASON_FOR_LEAVING
,      FACULTY_POSITION_FLAG
,      TENURE_CODE
,      FRACTION_OF_TENURE
,      EMPLOYMENT_TYPE_CODE
,      EMPLOYED_AS_TITLE_CODE
,      WEEKLY_WORK_HOURS
,      COMMENTS
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      CREATED_BY_MODULE
FROM AR.HZ_EMPLOYMENT_HISTORY;

Dependencies

[top of page]

AR.HZ_EMPLOYMENT_HISTORY does not reference any database object

AR.HZ_EMPLOYMENT_HISTORY is referenced by following:

AR: HZ_EMPLOYMENT_HISTORY#