View: IGS_PR_SPRC_SCA_V

View Text

SELECT SPRC.PERSON_ID
, SPRC.COURSE_CD
, SPRC.PRG_CAL_TYPE
, SPRC.PRG_CI_SEQUENCE_NUMBER
, SPRC.RULE_CHECK_DT
, SPRC.PROGRESSION_RULE_CAT
, SPRC.PRA_SEQUENCE_NUMBER
, PE.PARTY_NUMBER
FROM IGS_PR_SDT_PR_RU_CK SPRC
, HZ_PARTIES PE
WHERE PE.PARTY_ID = SPRC.PERSON_ID UNION SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, TO_DATE(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, PE.PARTY_NUMBER FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_CA_TYPE CAT
, IGS_CA_INST CI
, HZ_PARTIES PE
WHERE CI.CAL_TYPE = CAT.CAL_TYPE AND CAT.S_CAL_CAT = 'PROGRESS' AND PE.PARTY_ID = SCA.PERSON_ID

Columns