Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains the employment information of a person. |
Implementation/DBA Data: | Not implemented in this database |
SELECT EH.PARTY_ID
, EH.BEGIN_DATE
, EH.END_DATE
, EH.SUPERVISOR_NAME
, EH.EMPLOYED_AS_TITLE
, EH.EMPLOYED_BY_NAME_COMPANY
, EH.EMPLOYED_BY_DIVISION_NAME
, EH.BRANCH
, EH.MILITARY_RANK
, EH.SERVED
, EH.STATION
, '_LA:EH.EMPLOYMENT_TYPE_CODE:AR_LOOKUPS:HZ_EMPLOYMENT_TYPE:MEANING'
, EH.FRACTION_OF_TENURE FRACTION_OF_EMPLOYMENT
, '_LA:EH.TENURE_CODE:AR_LOOKUPS:HZ_TENURE_CODE:MEANING'
, HED.OCCUPATIONAL_TITLE_CODE
, EH.WEEKLY_WORK_HOURS
, EH.COMMENTS
, EH.REASON_FOR_LEAVING
, EH.EMPLOYED_BY_PARTY_ID
, HED.HZ_EMP_DTL_ID
, EH.EMPLOYMENT_HISTORY_ID
, EH.CREATED_BY
, EH.CREATION_DATE
, EH.LAST_UPDATED_BY
, EH.LAST_UPDATE_DATE
FROM IGS_AD_HZ_EMP_DTL HED
, HZ_EMPLOYMENT_HISTORY EH
WHERE EH.EMPLOYMENT_HISTORY_ID=HED.EMPLOYMENT_HISTORY_ID WITH READ ONLY