[Home] [Help]
View: IGS_SV_EDT_OFF_EMPL_BLK_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | View for fetching the details about a Non-Immg Off-Campus Employment to edit the details |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT EMP_NEW.BATCH_ID
, EMP_NEW.PERSON_ID
, EMP_NEW.PRINT_FORM
, EMP_NEW.EMPL_START_DATE NEW_EMPL_START_DATE
, EMP_NEW.EMPL_END_DATE NEW_EMPL_END_DATE
, EMP_NEW.EMPL_TYPE NEW_EMPLOYMENT_TYPE
, EMP_NEW.REMARKS RECOMMENDATION
, EMP_NEW.RECOMMEND_EMPL RECOMMEND_EMPLOYMENT
, EMP_OLD.EMPL_START_DATE
, EMP_OLD.EMPL_END_DATE
, EMP_OLD.EMPL_TYPE EMPLOYMENT_TYPE
FROM IGS_SV_EMPL_INFO EMP_NEW
, IGS_SV_EMPL_INFO EMP_OLD
WHERE EMP_NEW.EMPL_REC_TYPE = 'F'
AND EMP_NEW.ACTION_CODE = 'E'
AND EMP_NEW.PERSON_ID = EMP_OLD.PERSON_ID
AND EMP_OLD.EMPL_REC_TYPE = 'F'
AND EMP_NEW.BATCH_ID <> EMP_OLD.BATCH_ID
AND EMP_OLD.BATCH_ID = (SELECT MAX(BATCH_ID)
FROM IGS_SV_EMPL_INFO
WHERE PERSON_ID = EMP_NEW.PERSON_ID
AND NONIMG_EMPL_ID = EMP_NEW.NONIMG_EMPL_ID
AND BATCH_ID < (SELECT MAX(BATCH_ID)
FROM IGS_SV_EMPL_INFO
WHERE PERSON_ID = EMP_NEW.PERSON_ID
AND NONIMG_EMPL_ID = EMP_NEW.NONIMG_EMPL_ID) )
Columns
| Name |
| BATCH_ID |
| PERSON_ID |
| PRINT_FORM |
| NEW_EMPL_START_DATE |
| NEW_EMPL_END_DATE |
| NEW_EMPLOYMENT_TYPE |
| RECOMMENDATION |
| RECOMMEND_EMPLOYMENT |
| EMPL_START_DATE |
| EMPL_END_DATE |
| EMPLOYMENT_TYPE |