View: IGS_PS_UNIT_VER_V

View Text

SELECT PUV.ROWID ROW_ID
, PUV.UNIT_CD UNIT_CD
, PUV.VERSION_NUMBER VERSION_NUMBER
, PUV.START_DT START_DT
, PUV.REVIEW_DT REVIEW_DT
, PUV.EXPIRY_DT EXPIRY_DT
, PUV.END_DT END_DT
, PUV.UNIT_STATUS UNIT_STATUS
, PUV.TITLE TITLE
, PUV.SHORT_TITLE SHORT_TITLE
, PUV.TITLE_OVERRIDE_IND TITLE_OVERRIDE_IND
, PUV.ABBREVIATION ABBREVIATION
, PUV.UNIT_LEVEL UNIT_LEVEL
, PUV.CREDIT_POINT_DESCRIPTOR CREDIT_POINT_DESCRIPTOR
, LK.MEANING CPD_DESCRIPTION
, PUV.ENROLLED_CREDIT_POINTS ENROLLED_CREDIT_POINTS
, PUV.POINTS_OVERRIDE_IND POINTS_OVERRIDE_IND
, PUV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND
, PUV.COORD_PERSON_ID COORD_PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, PUV.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, PUV.OWNER_OU_START_DT OWNER_OU_START_DT
, PUV.AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_IND
, PUV.RESEARCH_UNIT_IND RESEARCH_UNIT_IND
, PUV.SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_IND
, PUV.SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_IND
, PUV.INDUSTRIAL_IND INDUSTRIAL_IND
, PUV.PRACTICAL_IND PRACTICAL_IND
, PUV.REPEATABLE_IND REPEATABLE_IND
, PUV.ASSESSABLE_IND ASSESSABLE_IND
, PUV.ACHIEVABLE_CREDIT_POINTS ACHIEVABLE_CREDIT_POINTS
, PUV.POINTS_INCREMENT POINTS_INCREMENT
, PUV.POINTS_MIN POINTS_MIN
, PUV.POINTS_MAX POINTS_MAX
, PUV.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD
, UVS.SUBTITLE SUBTITLE
, PUV.SUBTITLE_ID SUBTITLE_ID
, PUV.SUBTITLE_MODIFIABLE_FLAG SUBTITLE_MODIFIABLE_FLAG
, PUV.APPROVAL_DATE APPROVAL_DATE
, PUV.LECTURE_CREDIT_POINTS LECTURE_CREDIT_POINTS
, PUV.LAB_CREDIT_POINTS LAB_CREDIT_POINTS
, PUV.OTHER_CREDIT_POINTS OTHER_CREDIT_POINTS
, PUV.CLOCK_HOURS CLOCK_HOURS
, PUV.BILLING_CREDIT_POINTS BILLING_CREDIT_POINTS
, PUV.WORK_LOAD_CP_LECTURE WORK_LOAD_CP_LECTURE
, PUV.WORK_LOAD_CP_LAB WORK_LOAD_CP_LAB
, PUV.CONTINUING_EDUCATION_UNITS CONTINUING_EDUCATION_UNITS
, PUV.ENROLLMENT_EXPECTED ENROLLMENT_EXPECTED
, PUV.ENROLLMENT_MINIMUM ENROLLMENT_MINIMUM
, PUV.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM
, PUV.ADVANCE_MAXIMUM ADVANCE_MAXIMUM
, PUV.STATE_FINANCIAL_AID STATE_FINANCIAL_AID
, PUV.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID
, PUV.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID
, PUV.SAME_TEACHING_PERIOD SAME_TEACHING_PERIOD
, PUV.MAX_REPEATS_FOR_CREDIT MAX_REPEATS_FOR_CREDIT
, PUV.MAX_REPEATS_FOR_FUNDING MAX_REPEATS_FOR_FUNDING
, PUV.MAX_REPEAT_CREDIT_POINTS MAX_REPEAT_CREDIT_POINTS
, PUV.SAME_TEACH_PERIOD_REPEATS_CP SAME_TEACH_PERIOD_REPEATS_CP
, PUV.SAME_TEACH_PERIOD_REPEATS SAME_TEACH_PERIOD_REPEATS
, PUV.WORK_LOAD_OTHER WORK_LOAD_OTHER
, PUV.CONTACT_HRS_LECTURE CONTACT_HRS_LECTURE
, PUV.CONTACT_HRS_LAB CONTACT_HRS_LAB
, PUV.CONTACT_HRS_OTHER CONTACT_HRS_OTHER
, ( PUV.CONTACT_HRS_LECTURE+PUV.CONTACT_HRS_LAB+PUV.CONTACT_HRS_OTHER ) DSP_CONTACT_HRS_TOTAL
, PUV.BILLING_HRS BILLING_HRS
, PUV.NON_SCHD_REQUIRED_HRS NON_SCHD_REQUIRED_HRS
, PUV.FIN_AID_CP FIN_AID_CP
, PUV.FIN_AID_HRS FIN_AID_HRS
, PUV.EXCLUDE_FROM_MAX_CP_LIMIT EXCLUDE_FROM_MAX_CP_LIMIT
, PUV.RECORD_EXCLUSION_FLAG RECORD_EXCLUSION_FLAG
, PUV.SS_DISPLAY_IND SS_DISPLAY_IND
, PUV.CAL_TYPE_ENROL_LOAD_CAL CAL_TYPE_ENROL_LOAD_CAL
, PUV.SEQUENCE_NUM_ENROL_LOAD_CAL SEQUENCE_NUM_ENROL_LOAD_CAL
, PUV.CAL_TYPE_OFFER_LOAD_CAL CAL_TYPE_OFFER_LOAD_CAL
, PUV.SEQUENCE_NUM_OFFER_LOAD_CAL SEQUENCE_NUM_OFFER_LOAD_CAL
, SUBSTR (IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(PUV.CAL_TYPE_ENROL_LOAD_CAL
, PUV.SEQUENCE_NUM_ENROL_LOAD_CAL)
, 1
, 10) || '/' || PUV.CAL_TYPE_ENROL_LOAD_CAL DSP_LAST_CALENDAR_ENROLLED
, SUBSTR (IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(PUV.CAL_TYPE_OFFER_LOAD_CAL
, PUV.SEQUENCE_NUM_OFFER_LOAD_CAL)
, 1
, 10) || '/' || PUV.CAL_TYPE_OFFER_LOAD_CAL DSP_LAST_CALENDAR_OFFERED
, PUV.CURRICULUM_ID CURRICULUM_ID
, PUV.OVERRIDE_ENROLLMENT_MAX OVERRIDE_ENROLLMENT_MAX
, PUV.RPT_FMLY_ID RPT_FMLY_ID
, PUV.UNIT_TYPE_ID UNIT_TYPE_ID
, UTYL.LEVEL_CODE LEVEL_CODE
, PUV.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_IND
, PUV.SS_ENROL_IND SS_ENROL_IND
, PUV.IVR_ENROL_IND IVR_ENROL_IND
, PUV.REV_ACCOUNT_CD
, PUV.CLAIMABLE_HOURS
, PUV.ANON_UNIT_GRADING_IND
, PUV.ANON_ASSESS_GRADING_IND
, PUV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PUV.ATTRIBUTE1 ATTRIBUTE1
, PUV.ATTRIBUTE2 ATTRIBUTE2
, PUV.ATTRIBUTE3 ATTRIBUTE3
, PUV.ATTRIBUTE4 ATTRIBUTE4
, PUV.ATTRIBUTE5 ATTRIBUTE5
, PUV.ATTRIBUTE6 ATTRIBUTE6
, PUV.ATTRIBUTE7 ATTRIBUTE7
, PUV.ATTRIBUTE8 ATTRIBUTE8
, PUV.ATTRIBUTE9 ATTRIBUTE9
, PUV.ATTRIBUTE10 ATTRIBUTE10
, PUV.ATTRIBUTE11 ATTRIBUTE11
, PUV.ATTRIBUTE12 ATTRIBUTE12
, PUV.ATTRIBUTE13 ATTRIBUTE13
, PUV.ATTRIBUTE14 ATTRIBUTE14
, PUV.ATTRIBUTE15 ATTRIBUTE15
, PUV.ATTRIBUTE16 ATTRIBUTE16
, PUV.ATTRIBUTE17 ATTRIBUTE17
, PUV.ATTRIBUTE18 ATTRIBUTE18
, PUV.ATTRIBUTE19 ATTRIBUTE19
, PUV.ATTRIBUTE20 ATTRIBUTE20
, PUV.CREATED_BY CREATED_BY
, PUV.CREATION_DATE CREATION_DATE
, PUV.LAST_UPDATED_BY LAST_UPDATED_BY
, PUV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PUV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PUV.AUDITABLE_IND
, PUV.AUDIT_PERMISSION_IND
, PUV.MAX_AUDITORS_ALLOWED
, PUV.OVRD_WKLD_VAL_FLAG
, PUV.WORKLOAD_VAL_CODE
FROM IGS_PS_UNIT_VER PUV
, HZ_PARTIES PE
, IGS_LOOKUP_VALUES LK
, IGS_PS_UNIT_SUBTITLE UVS
, IGS_PS_UNIT_TYPE_LVL UTYL
WHERE PUV.COORD_PERSON_ID = PE.PARTY_ID
AND PUV.CREDIT_POINT_DESCRIPTOR = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'CREDIT_POINT_DSCR'
AND PUV.SUBTITLE_ID = UVS.SUBTITLE_ID(+)
AND PUV.UNIT_TYPE_ID = UTYL.UNIT_TYPE_ID

Columns