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