[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity describes the Unit offering options with details about the unit section, grading schema details, attendance requirements, special permission and grading indicators. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT UOO.UNIT_CD UNIT_CODE
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER CAL_INST_SEQUENCE_NUMBER
, UOO.LOCATION_CD LOCATION_CODE
, UOO.UNIT_CLASS
, UOO.IVRS_AVAILABLE_IND IVR_AVAILABLE_INDICATOR
, UOO.CALL_NUMBER
, '_LA:UNIT_SECTION_STATUS:IGS_LOOKUP_VALUES:UNIT_SECTION_STATUS:MEANING'
, '_LA:RELATION_TYPE:IGS_LOOKUP_VALUES:UOO_RELATION_TYPE:MEANING'
, UOO.UNIT_SECTION_START_DATE
, UOO.UNIT_SECTION_END_DATE
, UOO.ENROLLMENT_ACTUAL
, UOO.WAITLIST_ACTUAL
, UOO.OFFERED_IND OFFERED_INDICATOR
, UOO.STATE_FINANCIAL_AID
, UOO.FEDERAL_FINANCIAL_AID
, UOO.UNIT_QUOTA
, UOO.UNIT_QUOTA_RESERVED_PLACES
, UOO.INSTITUTIONAL_FINANCIAL_AID
, UOO.GRADING_SCHEMA_PRCDNCE_IND GR_SCHEMA_PRECEDENCE_INDICATOR
, UOO.UNIT_CONTACT UNIT_CONTACT_PERSON_ID
, UOO.SS_ENROL_IND SELF_SERVICE_ENROL_INDICATOR
, UOO.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CODE
, UOO.ATTENDANCE_REQUIRED_IND ATTENDANCE_REQUIRED_INDICATOR
, UOO.RESERVED_SEATING_ALLOWED
, UOO.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_INDICATOR
, UOO.SS_DISPLAY_IND SELF_SERVICE_DISPLAY_INDICATOR
, UOO.AUDITABLE_IND AUDITABLE_INDICATOR
, UOO.AUDIT_PERMISSION_IND AUDIT_PERMISSION_INDICATOR
, UOO.NOT_MULTIPLE_SECTION_FLAG NOT_MULTIPLE_SECTION_FLAG
, UOO.DEFAULT_ENROLL_FLAG DEFAULT_ENROLL_FLAG
, UOO.DIR_ENROLLMENT DIRECT_ENROLLMENT
, UOO.ENR_FROM_WLST ENROLLED_FROM_WAITLIST
, UOO.INQ_NOT_WLST INQ_NOT_WAITLIST
, UOO.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, UOO.ABORT_FLAG ABORT_FLAG
, PSV.TITLE UNIT_DESCRIPTION
, CAI.DESCRIPTION CAL_DESCRIPTION
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, UCL.DESCRIPTION UNIT_CLASS_DESCRIPTION
, HP1.PARTY_NAME UNIT_CONTACT_PERSON_NAME
, HP.PARTY_NAME OWNER_ORG_UNIT_DESC
, IGA.DESCRIPTION REVENUE_ACCOUNT_DESC
, UOO.ANON_UNIT_GRADING_IND ANON_UNIT_GRADING_INDICATOR
, UOO.ANON_ASSESS_GRADING_IND ANON_ASSESS_GRADING_INDICATOR
, UOO.NON_STD_USEC_IND NON_STANDARD_USEC_INDICATOR
, UOO.UOO_ID UNIT_SECTION_ID
, UOO.SUP_UOO_ID SUPERIOR_UNIT_SECTION_ID
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_PS_UNIT_VER_ALL PSV
, IGS_CA_INST_ALL CAI
, IGS_AD_LOCATION_ALL LOC
, IGS_AS_UNIT_CLASS_ALL UCL
, IGS_FI_ACC_ALL IGA
, IGS_OR_INST_ORG_BASE_V HP
, HZ_PARTIES HP1
WHERE UOO.CAL_TYPE = CAI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CAI.SEQUENCE_NUMBER
AND UOO.UNIT_CD = PSV.UNIT_CD
AND UOO.VERSION_NUMBER = PSV.VERSION_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UCL.UNIT_CLASS
AND UOO.REV_ACCOUNT_CD = IGA.ACCOUNT_CD (+)
AND UOO.OWNER_ORG_UNIT_CD = HP.PARTY_NUMBER
AND UOO.UNIT_CONTACT = HP1.PARTY_ID (+) WITH READ ONLY