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.

[Home] [Help]

View: IGS_PE_NONIMG_EMPL_V

Product:	IGS - Student System (Obsolete)
Description:	View for IGS_PE_NONIMG_EMPL
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PV.ROWID ROW_ID
, PV.NONIMG_EMPL_ID
, PV.NONIMG_FORM_ID
, PV.EMPL_TYPE
, L1.MEANING EMPL_TYPE_DESC
, PV.RECOMMEND_EMPL
, PV.RESCIND_EMPL
, PV.REMARKS
, PV.EMPL_START_DATE
, PV.EMPL_END_DATE
, PV.COURSE_RELEVANCE
, PV.EMPL_TIME
, L2.MEANING EMPL_TIME_DESC
, PV. EMPL_PARTY_ID
, EP.PARTY_NAME EMPL_PARTY_NAME
, PV.CREATION_DATE
, PV.CREATED_BY
, PV.LAST_UPDATED_BY
, PV.LAST_UPDATE_DATE
, PV.LAST_UPDATE_LOGIN
, PV.ACTION_CODE
FROM IGS_PE_NONIMG_EMPL PV
, IGS_LOOKUP_VALUES L1
, IGS_LOOKUP_VALUES L2
, HZ_PARTIES EP
WHERE PV.EMPL_TYPE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PE_SV_EMPL_TYPE'
AND PV.EMPL_TIME = L2.LOOKUP_CODE(+)
AND L2.LOOKUP_TYPE(+) = 'PE_SV_EMPL_TIME'
AND PV.EMPL_PARTY_ID = EP.PARTY_ID (+)

Columns

Name
ROW_ID
NONIMG_EMPL_ID
NONIMG_FORM_ID
EMPL_TYPE
EMPL_TYPE_DESC
RECOMMEND_EMPL
RESCIND_EMPL
REMARKS
EMPL_START_DATE
EMPL_END_DATE
COURSE_RELEVANCE
EMPL_TIME
EMPL_TIME_DESC
EMPL_PARTY_ID
EMPL_PARTY_NAME
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ACTION_CODE