View: AMS_LT_HZ_EMPLOYMENT_HISTORY

Product:	AMS - Marketing
Description:	Data Source view based on hz_employement_history
Implementation/DBA Data:	APPS.AMS_LT_HZ_EMPLOYMENT_HISTORY

View Text

SELECT EMPLOYMENT_HISTORY_ID
, BEGIN_DATE
, PARTY_ID
, EMPLOYED_AS_TITLE
, EMPLOYED_BY_DIVISION_NAME
, EMPLOYED_BY_NAME_COMPANY
, SUPERVISOR_NAME
, BRANCH
, MILITARY_RANK
, SERVED
, STATION
, RESPONSIBILITY
FROM HZ_EMPLOYMENT_HISTORY
WHERE END_DATE IS NULL
AND STATUS = 'A'

Columns