[Home] [Help]
View: IGS_PR_RUL_OUTAPPL_V
Product: | IGS - Student System (Obsolete) |
Description: | This view contains description about the prg calendar. It is the combination of cal type, alternate code, start dt,end dt, cal type,abbreviation etc. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RPAD(RPAD(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD (CI.CAL_TYPE
, CI.SEQUENCE_NUMBER)||'/'|| NVL(CI.ALTERNATE_CODE
, CI.CAL_TYPE)
, 21)||''|| TO_CHAR(CI.START_DT
, 'DD/MM/YYYY')||'-'|| TO_CHAR(CI.END_DT
, 'DD/MM/YYYY')||''||CT.ABBREVIATION
, 100)|| RPAD(CI.CAL_TYPE
, 10)||TO_CHAR(CI.SEQUENCE_NUMBER
, '999990') PRGCAL
, CI.START_DT
, CI.END_DT
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_STAT CS
WHERE CI.CAL_TYPE=CT.CAL_TYPE
AND CT.S_CAL_CAT ='PROGRESS'
AND CI.CAL_STATUS=CS.CAL_STATUS
AND CS.S_CAL_STATUS='ACTIVE'
Columns
Name |
PRGCAL |
START_DT |
END_DT |