View: CSC_HZ_EMPLOYMENT_HISTORY_V

Product:	CSC - Customer Care
Description:	View of HZ_EMPLOYEE_HISTORY. This view is used to get employee history details.
Implementation/DBA Data:	APPS.CSC_HZ_EMPLOYMENT_HISTORY_V

View Text

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
, NULL
FROM HZ_EMPLOYMENT_HISTORY

Columns