Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This View stores the Unit Sections for self service applications. |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.UNIT_CD
, A.VERSION_NUMBER
, A.UNIT_STATUS
, A.TITLE
, A.SHORT_TITLE
, A.TITLE_OVERRIDE_IND
, A.ABBREVIATION
, A.OWNER_ORG_UNIT_CD
, B.UOO_ID
, B.CAL_TYPE
, B.CI_SEQUENCE_NUMBER
, B.CALL_NUMBER
, B.UNIT_SECTION_STATUS
, B.UNIT_CLASS
, B.LOCATION_CD
, B.ENROLLMENT_ACTUAL
, B.WAITLIST_ACTUAL
, B.UNIT_SECTION_START_DATE
, B.UNIT_SECTION_END_DATE
, TO_CHAR(C.START_DT
, 'DD-MON-YYYY') START_DATE
, TO_CHAR(C.END_DT
, 'DD-MON-YYYY') END_DATE
, C.DESCRIPTION TEACH_CAL_DESCRIPTION
, NVL(D.ENROLLMENT_MINIMUM
, A.ENROLLMENT_MINIMUM)
, NVL(D.ENROLLMENT_MAXIMUM
, A.ENROLLMENT_MAXIMUM)
, NVL( D.MAX_STUDENTS_PER_WAITLIST
, NVL(E.MAX_STUDENTS_PER_WAITLIST
, IGS_SS_ENR_DETAILS.GET_MAX_STD_WAIT_ORG_LEVEL(A.OWNER_ORG_UNIT_CD
, B.CAL_TYPE
, B.CI_SEQUENCE_NUMBER))) MAX_STUDENTS_PER_WAITLIST
, B.SS_DISPLAY_IND
, B.SS_ENROL_IND
, B.AUDITABLE_IND
, B.SUP_UOO_ID
, B.RELATION_TYPE
, A.PRACTICAL_IND
, B.NON_STD_USEC_IND NON_STD_USEC_FLAG
FROM IGS_PS_UNIT_VER A
, IGS_PS_UNIT_OFR_OPT B
, IGS_CA_INST C
, IGS_PS_USEC_LIM_WLST D
, IGS_PS_UNIT_OFR_PAT E
WHERE B.UNIT_CD = A.UNIT_CD
AND B.VERSION_NUMBER = A.VERSION_NUMBER
AND B.CAL_TYPE = C.CAL_TYPE
AND B.CI_SEQUENCE_NUMBER = C.SEQUENCE_NUMBER
AND D.UOO_ID(+) = B.UOO_ID
AND B.UNIT_CD = E.UNIT_CD
AND B.VERSION_NUMBER = E.VERSION_NUMBER
AND B.CAL_TYPE = E.CAL_TYPE
AND B.CI_SEQUENCE_NUMBER = E.CI_SEQUENCE_NUMBER
AND E.DELETE_FLAG = 'N'