[Home] [Help]
View: IGS_PE_TYP_EMP_CAT_V
Product: | IGS - Student System (Obsolete) |
Description: | View to obtain the active Employment Category from IGS_PE_TYP_INSTANCES_ALL |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TYP.ROWID ROW_ID
, TYP.PERSON_ID
, TYP. EMPLMNT_CATEGORY_CODE
, LKUP1.MEANING EMP_CATEGORY_MEANING
, TYP.CREATED_BY
, TYP.CREATION_DATE
, TYP.LAST_UPDATED_BY
, TYP.LAST_UPDATE_DATE
, TYP.LAST_UPDATE_LOGIN
FROM IGS_PE_TYP_INSTANCES_ALL TYP
, IGS_PE_PERSON_TYPES SYSTYP
, IGS_LOOKUP_VALUES LKUP1
WHERE TYP.PERSON_TYPE_CODE = SYSTYP.PERSON_TYPE_CODE
AND SYSTYP.SYSTEM_TYPE IN ('FACULTY'
, 'STAFF')
AND SYSDATE BETWEEN START_DATE
AND NVL(END_DATE
, SYSDATE)
AND LKUP1.LOOKUP_TYPE = 'PE_EMP_CATEGORIES'
AND LKUP1.LOOKUP_CODE = TYP. EMPLMNT_CATEGORY_CODE
Columns
Name |
ROW_ID |
PERSON_ID |
EMPLMNT_CATEGORY_CODE |
EMP_CATEGORY_MEANING |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |