eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGS_PS_UNIT_VER_HIST_V

Source

View Text - Preformatted


SELECT uvh1.unit_cd, uvh1.version_number, uvh1.hist_start_dt, uvh1.hist_end_dt, uvh1.hist_who, NVL( uvh1.start_dt, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'START_DT', uvh1.hist_end_dt)), uv1.start_dt)), NVL( uvh1.review_dt, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'REVIEW_DT', uvh1.hist_end_dt)), uv1.review_dt)), NVL( uvh1.expiry_dt, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'EXPIRY_DT', uvh1.hist_end_dt)),uv1.expiry_dt)), NVL( uvh1.end_dt, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'END_DT', uvh1.hist_end_dt)), uv1.end_dt)), NVL( uvh1.unit_status, NVL( SUBSTR(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'UNIT_STATUS', uvh1.hist_end_dt),1,10), uv1.unit_status)), NVL( uvh1.title, NVL( SUBSTR(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'TITLE', uvh1.hist_end_dt), 1, 90), uv1.title)), NVL( uvh1.short_title, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SHORT_TITLE', uvh1.hist_end_dt), 1, 40), uv1.short_title)), NVL( uvh1.title_override_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'TITLE_OVERRIDE_IND', uvh1.hist_end_dt), 1, 1), uv1.title_override_ind)), NVL( uvh1.abbreviation, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ABBREVIATION', uvh1.hist_end_dt), 1, 20), uv1.abbreviation)), NVL( uvh1.unit_level, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'UNIT_LEVEL', uvh1.hist_end_dt), 1, 1), uv1.unit_level)), NVL( uvh1.ul_description, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'UL_DESCRIPTION', uvh1.hist_end_dt), 1, 60), ul1.description)), NVL( uvh1.credit_point_descriptor, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CREDIT_POINT_DESCRIPTOR', uvh1.hist_end_dt), 1, 10), uv1.credit_point_descriptor)), NVL( uvh1.enrolled_credit_points, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ENROLLED_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.enrolled_credit_points)), NVL( uvh1.points_override_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'POINTS_OVERRIDE_IND', uvh1.hist_end_dt), 1, 1), uv1.points_override_ind)), NVL( uvh1.supp_exam_permitted_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SUPP_EXAM_PERMITTED_IND', uvh1.hist_end_dt), 1, 1),uv1.supp_exam_permitted_ind)), NVL( uvh1.coord_person_id, NVL( IGS_GE_NUMBER.to_num(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'COORD_PERSON_ID', uvh1.hist_end_dt)), uv1.coord_person_id)), NVL( uvh1.owner_org_unit_cd, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'OWNER_ORG_UNIT_CD', uvh1.hist_end_dt), 1, 30), uv1.owner_org_unit_cd)), NVL( uvh1.owner_ou_start_dt, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'OWNER_OU_START_DT', uvh1.hist_end_dt)), uv1.owner_ou_start_dt)), NVL( uvh1.ou_description, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'OU_DESCRIPTION', uvh1.hist_end_dt), 1, 60), ou1.party_name)), NVL( uvh1.award_course_only_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'AWARD_COURSE_ONLY_IND', uvh1.hist_end_dt), 1, 1), uv1.award_course_only_ind)), NVL( uvh1.research_unit_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'RESEARCH_UNIT_IND', uvh1.hist_end_dt), 1, 1), uv1.research_unit_ind)), NVL(uvh1.sub_unit_allowed_ind,uv1.sub_unit_allowed_ind), NVL(uvh1.sup_unit_allowed_ind,uv1.sup_unit_allowed_ind), NVL( uvh1.industrial_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'INDUSTRIAL_IND', uvh1.hist_end_dt), 1, 1), uv1.industrial_ind)), NVL( uvh1.practical_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'PRACTICAL_IND', uvh1.hist_end_dt), 1, 1), uv1.practical_ind)), NVL( uvh1.repeatable_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'REPEATABLE_IND', uvh1.hist_end_dt), 1, 1), uv1.repeatable_ind)), NVL( uvh1.assessable_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ASSESSABLE_IND', uvh1.hist_end_dt), 1, 1), uv1.assessable_ind)), NVL( uvh1.achievable_credit_points, NVL( IGS_GE_NUMBER.to_num(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ACHIEVABLE_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.achievable_credit_points)), NVL( uvh1.points_increment, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'POINTS_INCREMENT', uvh1.hist_end_dt)), uv1.points_increment)), NVL( uvh1.points_min, NVL( IGS_GE_NUMBER.to_num(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'POINTS_MIN', uvh1.hist_end_dt)), uv1.points_min)), NVL( uvh1.points_max, NVL( IGS_GE_NUMBER.to_num(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'POINTS_MAX', uvh1.hist_end_dt)), uv1.points_max)), NVL( uvh1.unit_int_course_level_cd, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'UNIT_INT_COURSE_LEVEL_CD', uvh1.hist_end_dt), 1, 10), uv1.unit_int_course_level_cd)), NVL( uvh1.uicl_description, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'UICL_DESCRIPTION', uvh1.hist_end_dt), 1, 60), uicl1.description)), NVL( uvh1.work_load_other, NVL( IGS_GE_NUMBER.to_num(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'WORK_LOAD_OTHER', uvh1.hist_end_dt)), uv1.work_load_other)), NVL( uvh1.contact_hrs_lecture, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CONTACT_HRS_LECTURE', uvh1.hist_end_dt)), uv1.contact_hrs_lecture)), NVL( uvh1.contact_hrs_lab, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CONTACT_HRS_LAB', uvh1.hist_end_dt)), uv1.contact_hrs_lab)), NVL( uvh1.contact_hrs_other, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CONTACT_HRS_OTHER', uvh1.hist_end_dt)), uv1.contact_hrs_other)), NVL( uvh1.billing_hrs, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'BILLING_HRS', uvh1.hist_end_dt)), uv1.Billing_hrs)), NVL( uvh1.non_schd_required_hrs, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'NON_SCHD_REQUIRED_HRS', uvh1.hist_end_dt)), uv1.non_schd_required_hrs)), NVL( uvh1.fin_aid_cp, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'FIN_AID_CP', uvh1.hist_end_dt)), uv1.fin_aid_cp)), NVL( uvh1.fin_aid_hrs, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'FIN_AID_HRS', uvh1.hist_end_dt)), uv1.fin_aid_hrs)), NVL( uvh1.exclude_from_max_cp_limit, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'EXCLUDE_FROM_MAX_CP_LIMIT', uvh1.hist_end_dt), 1, 1), uv1.exclude_from_max_cp_limit)), NVL( uvh1.record_exclusion_flag, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'RECORD_EXCLUSION_FLAG', uvh1.hist_end_dt), 1, 1), uv1.record_exclusion_flag)), NVL( uvh1.SS_DISPLAY_IND, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SS_DISPLAY_IND', uvh1.hist_end_dt), 1, 1), uv1.ss_display_ind)), NVL( uvh1.cal_type_enrol_load_cal, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CAL_TYPE_ENROL_LOAD_CAL', uvh1.hist_end_dt), 1, 10), uv1.cal_type_enrol_load_cal)), NVL( uvh1.sequence_num_enrol_load_cal, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SEQUENCE_NUM_ENROL_LOAD_CAL', uvh1.hist_end_dt)), uv1.sequence_num_enrol_load_cal)), NVL( uvh1.cal_type_offer_load_cal, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CAL_TYPE_OFFER_LOAD_CAL', uvh1.hist_end_dt), 1, 10), uv1.cal_type_offer_load_cal)), NVL( uvh1.sequence_num_offer_load_cal, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SEQUENCE_NUM_OFFER_LOAD_CAL', uvh1.hist_end_dt)), uv1.sequence_num_offer_load_cal)), NVL( uvh1.curriculum_id, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CURRICULUM_ID', uvh1.hist_end_dt), 1, 10), uv1.curriculum_id)), NVL( uvh1.override_enrollment_max, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'OVERRIDE_ENROLLMENT_MAX', uvh1.hist_end_dt)), uv1.override_enrollment_max)), NVL( uvh1.rpt_fmly_id, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'RPT_FMLY_ID', uvh1.hist_end_dt)), uv1.rpt_fmly_id)), NVL( uvh1.unit_type_id, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'UNIT_TYPE_ID', uvh1.hist_end_dt)), uv1.unit_type_id)), NVL( uvh1.Repeat_code, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'REPEAT_CODE', uvh1.hist_end_dt), 1, 10), urf.Repeat_code)), NVL( uvh1.level_code, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'LEVEL_CODE', uvh1.hist_end_dt), 1, 10), ul.Level_code)), NVL(uvh1.advance_maximum, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ADVANCE_MAXIMUM', uvh1.hist_end_dt)), uv1.Advance_maximum)), NVL( uvh1.approval_date, NVL( IGS_GE_DATE.IGSDATE( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'APPROVAL_DATE', uvh1.hist_end_dt)),uv1.approval_date)), NVL( uvh1.billing_credit_points, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'BILLING_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.Billing_credit_points)), NVL( uvh1.continuing_education_units, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CONTINUING_EDUCATION_UNITS', uvh1.hist_end_dt)), uv1.Continuing_education_units)), NVL( uvh1.enrollment_expected, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ENROLLMENT_EXPECTED', uvh1.hist_end_dt)), uv1.Enrollment_expected)), NVL( uvh1.enrollment_maximum, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ENROLLMENT_MAXIMUM', uvh1.hist_end_dt)), uv1.Enrollment_maximum)), NVL( uvh1.enrollment_minimum, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'ENROLLMENT_MINIMUM', uvh1.hist_end_dt)), uv1.Enrollment_minimum)), NVL( uvh1.federal_financial_aid, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'FEDERAL_FINANCIAL_AID', uvh1.hist_end_dt), 1, 1), uv1.Federal_financial_aid)), NVL( uvh1.institutional_financial_aid, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'INSTITUTIONAL_FINANCIAL_AID', uvh1.hist_end_dt), 1, 1), uv1.Institutional_financial_aid)), NVL( uvh1.lab_credit_points, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'LAB_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.Lab_credit_points)), NVL( uvh1.lecture_credit_points, NVL( IGS_GE_NUMBER.to_num(IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'LECTURE_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.Lecture_credit_points)), DECODE( NVL( uvh1.repeatable_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'REPEATABLE_IND', uvh1.hist_end_dt ), 1, 1), uv1.repeatable_ind)), 'N', NVL( uvh1.max_repeats_for_credit, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'MAX_REPEATS_FOR_CREDIT', uvh1.hist_end_dt)), uv1.Max_repeats_for_credit)),NULL), DECODE( NVL( uvh1.repeatable_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'REPEATABLE_IND', uvh1.hist_end_dt ), 1, 1), uv1.repeatable_ind)), 'Y', NVL( uvh1.max_repeats_for_credit, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'MAX_REPEATS_FOR_CREDIT', uvh1.hist_end_dt)), uv1.Max_repeats_for_credit)),NULL), NVL( uvh1.max_repeats_for_funding, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'MAX_REPEATS_FOR_FUNDING', uvh1.hist_end_dt)), uv1.Max_repeats_for_funding)), NVL( uvh1.max_repeat_credit_points, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'MAX_REPEAT_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.Max_repeat_credit_points)), NVL( uvh1.clock_hours, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CLOCK_HOURS', uvh1.hist_end_dt)), uv1.Clock_hours)), NVL( uvh1.other_credit_points, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'OTHER_CREDIT_POINTS', uvh1.hist_end_dt)), uv1.Other_credit_points)), NVL( uvh1.same_teaching_period, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SAME_TEACHING_PERIOD', uvh1.hist_end_dt), 1, 1), uv1.Same_teaching_period)), NVL( uvh1.same_teach_period_repeats, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SAME_TEACH_PERIOD_REPEATS', uvh1.hist_end_dt)), uv1.Same_teach_period_repeats)), NVL( uvh1.same_teach_period_repeats_cp, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SAME_TEACH_PERIOD_REPEATS_CP', uvh1.hist_end_dt)), uv1.Same_teach_period_repeats_cp)), NVL( uvh1.state_financial_aid, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'STATE_FINANCIAL_AID', uvh1.hist_end_dt), 1, 1), uv1.State_financial_aid)), NVL( uvh1.work_load_cp_lab, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'WORK_LOAD_CP_LAB', uvh1.hist_end_dt)), uv1.Work_load_cp_lab)), NVL( uvh1.work_load_cp_lecture, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'WORK_LOAD_CP_LECTURE', uvh1.hist_end_dt)), uv1.Work_load_cp_lecture)), NVL( uvh1.subtitle_id, NVL( IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SUBTITLE_ID', uvh1.hist_end_dt)), uv1.subtitle_id)), NVL( uvh1.subtitle, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SUBTITLE', uvh1.hist_end_dt), 1, 90), uvsb.subtitle)), NVL( uvh1.subtitle_modifiable_flag, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SUBTITLE_MODIFIABLE_FLAG', uvh1.hist_end_dt), 1, 1), uv1.subtitle_modifiable_flag)), NVL( uvh1.special_permission_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SPECIAL_PERMISSION_IND', uvh1.hist_end_dt), 1, 1), uv1.special_permission_ind)), NVL( uvh1.ivr_enrol_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'IVR_ENROL_IND', uvh1.hist_end_dt), 1, 1), uv1.ivr_enrol_ind)), NVL( uvh1.ss_enrol_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'SS_ENROL_IND', uvh1.hist_end_dt), 1, 1), uv1.ss_enrol_ind)), NVL( uvh1.claimable_hours, NVL( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'CLAIMABLE_HOURS', uvh1.hist_end_dt), uv1.claimable_hours)), uvh1.created_by, uvh1.creation_date, uvh1.last_updated_by, uvh1.last_update_date, uvh1.last_update_login, NVL( uvh1.auditable_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'AUDITABLE_IND', uvh1.hist_end_dt), 1, 1), uv1.auditable_ind)), NVL( uvh1.audit_permission_ind, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'AUDIT_PERMISSION_IND', uvh1.hist_end_dt), 1, 1), uv1.audit_permission_ind)), NVL( uvh1.max_auditors_allowed, NVL(IGS_GE_NUMBER.to_num( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'MAX_AUDITORS_ALLOWED', uvh1.hist_end_dt)), uv1.max_auditors_allowed)), NVL( uvh1.ovrd_wkld_val_flag, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'OVRD_WKLD_VAL_FLAG', uvh1.hist_end_dt), 1, 1), uv1.ovrd_wkld_val_flag)), NVL( uvh1.workload_val_code, NVL( SUBSTR( IGS_AU_GEN_004.audp_get_uvh_col( uvh1.unit_cd, uvh1.version_number, 'WORKLOAD_VAL_CODE', uvh1.hist_end_dt), 1, 30), uv1.workload_val_code)) FROM IGS_PS_UNIT_VER_HIST uvh1, IGS_PS_UNIT_VER uv1, IGS_PS_UNIT_LEVEL ul1, IGS_PS_UNIT_INT_LVL uicl1, IGS_OR_INST_ORG_BASE_V ou1, IGS_PS_UNIT_TYPE_LVL ul, IGS_PS_RPT_FMLY_ALL urf, IGS_PS_UNIT_SUBTITLE uvsb WHERE uv1.unit_cd = uvh1.unit_cd AND uv1.version_number = uvh1.version_number AND uv1.unit_level = ul1.unit_level (+) AND uv1.unit_int_course_level_cd = uicl1.unit_int_course_level_cd(+) AND uv1.owner_org_unit_cd = ou1.party_number (+) AND uv1.owner_ou_start_dt = ou1.start_dt (+) AND uv1.rpt_fmly_id = urf.rpt_fmly_id(+) AND uv1.unit_type_id = ul.unit_type_id (+) AND uv1.subtitle_id = uvsb.subtitle_id(+) UNION ALL SELECT uv2.unit_cd, uv2.version_number, NVL( MAX(uvh2.hist_end_dt), uv2.last_update_date), TO_DATE(NULL), uv2.last_updated_by, uv2.start_dt, uv2.review_dt, uv2.expiry_dt, uv2.end_dt, uv2.unit_status, uv2.title, uv2.short_title, uv2.title_override_ind, uv2.abbreviation, uv2.unit_level, ul2.description, uv2.credit_point_descriptor, uv2.enrolled_credit_points, uv2.points_override_ind, uv2.supp_exam_permitted_ind, uv2.coord_person_id, uv2.owner_org_unit_cd, uv2.owner_ou_start_dt, ou2.party_name, uv2.award_course_only_ind, uv2.research_unit_ind, uv2.sub_unit_allowed_ind, uv2.sup_unit_allowed_ind, uv2.industrial_ind, uv2.practical_ind, uv2.repeatable_ind, uv2.assessable_ind, uv2.achievable_credit_points, uv2.points_increment, uv2.points_min, uv2.points_max, uv2.unit_int_course_level_cd, uicl2.description, uv2.work_load_other, uv2.contact_hrs_lecture, uv2.contact_hrs_lab, uv2.contact_hrs_other, uv2.billing_hrs, uv2.non_schd_required_hrs, uv2.fin_aid_cp, uv2.fin_aid_hrs, uv2.exclude_from_max_cp_limit, uv2.record_exclusion_flag, uv2.ss_display_ind, uv2.cal_type_enrol_load_cal, uv2.sequence_num_enrol_load_cal, uv2.cal_type_offer_load_cal, uv2.sequence_num_offer_load_cal, uv2.curriculum_id, uv2.override_enrollment_max, uv2.rpt_fmly_id, uv2.unit_type_id, urf.repeat_code, ul.level_code, uv2.advance_maximum, uv2.approval_date, uv2.billing_credit_points, uv2.continuing_education_units, uv2.enrollment_expected, uv2.enrollment_maximum, uv2.enrollment_minimum, uv2.federal_financial_aid, uv2.institutional_financial_aid, uv2.lab_credit_points, uv2.lecture_credit_points, DECODE(uv2.repeatable_ind,'N', uv2.max_repeats_for_credit,NULL), DECODE(uv2.repeatable_ind,'Y', uv2.max_repeats_for_credit,NULL), uv2.max_repeats_for_funding, uv2.max_repeat_credit_points, uv2.clock_hours, uv2.other_credit_points, uv2.same_teaching_period, uv2.same_teach_period_repeats, uv2.same_teach_period_repeats_cp, uv2.state_financial_aid, uv2.work_load_cp_lab, uv2.work_load_cp_lecture, uv2.subtitle_id, uvsb.subtitle, uv2.subtitle_modifiable_flag, uv2.special_permission_ind, uv2.ivr_enrol_ind, uv2.ss_enrol_ind, uv2.claimable_hours, uv2.created_by, uv2.creation_date, uv2.last_updated_by, uv2.last_update_date, uv2.last_update_login, uv2.auditable_ind, uv2.audit_permission_ind, uv2.max_auditors_allowed, uv2.OVRD_WKLD_VAL_FLAG, uv2.WORKLOAD_VAL_CODE FROM IGS_PS_UNIT_VER_HIST uvh2, IGS_PS_UNIT_VER uv2, IGS_PS_UNIT_LEVEL ul2, IGS_PS_UNIT_INT_LVL uicl2, IGS_OR_INST_ORG_BASE_V ou2, IGS_PS_UNIT_TYPE_LVL ul, IGS_PS_RPT_FMLY_ALL urf, IGS_PS_UNIT_SUBTITLE uvsb WHERE uv2.unit_cd = uvh2.unit_cd (+) AND uv2.version_number = uvh2.version_number (+) AND uv2.unit_level = ul2.unit_level (+) AND uv2.unit_int_course_level_cd = uicl2.unit_int_course_level_cd (+) AND uv2.owner_org_unit_cd = ou2.party_number (+) AND uv2.owner_ou_start_dt = ou2.start_dt (+) AND uv2.rpt_fmly_id = urf.rpt_fmly_id (+) AND uv2.unit_type_id = ul.unit_type_id (+) AND uv2.subtitle_id = uvsb.subtitle_id (+) GROUP BY uv2.unit_cd, uv2.version_number, uv2.start_dt, uv2.review_dt, uv2.expiry_dt, uv2.end_dt, uv2.unit_status, uv2.title, uv2.short_title, uv2.title_override_ind, uv2.abbreviation, uv2.unit_level, ul2.description, uv2.credit_point_descriptor, uv2.enrolled_credit_points, uv2.points_override_ind, uv2.supp_exam_permitted_ind, uv2.coord_person_id, uv2.owner_org_unit_cd, uv2.owner_ou_start_dt, ou2.party_name, uv2.award_course_only_ind, uv2.research_unit_ind, uv2.sub_unit_allowed_ind, uv2.sup_unit_allowed_ind, uv2.industrial_ind, uv2.practical_ind, uv2.repeatable_ind, uv2.assessable_ind, uv2.achievable_credit_points, uv2.points_increment, uv2.points_min, uv2.points_max, uv2.unit_int_course_level_cd, uicl2.description, uv2.work_load_other, uv2.contact_hrs_lecture, uv2.contact_hrs_lab, uv2.contact_hrs_other, uv2.billing_hrs, uv2.non_schd_required_hrs, uv2.fin_aid_cp, uv2.fin_aid_hrs, uv2.exclude_from_max_cp_limit, uv2.record_exclusion_flag, uv2.ss_display_ind, uv2.cal_type_enrol_load_cal, uv2.sequence_num_enrol_load_cal, uv2.cal_type_offer_load_cal, uv2.sequence_num_offer_load_cal, uv2.curriculum_id, uv2.override_enrollment_max, uv2.rpt_fmly_id, uv2.unit_type_id, urf.repeat_code, ul.level_code, uv2.advance_maximum, uv2.approval_date, uv2.billing_credit_points, uv2.continuing_education_units, uv2.enrollment_expected, uv2.enrollment_maximum, uv2.enrollment_minimum, uv2.federal_financial_aid, uv2.institutional_financial_aid, uv2.lab_credit_points, uv2.lecture_credit_points, uv2.max_repeats_for_credit, uv2.max_repeats_for_funding, uv2.max_repeat_credit_points, uv2.clock_hours, uv2.other_credit_points, uv2.same_teaching_period, uv2.same_teach_period_repeats, uv2.same_teach_period_repeats_cp, uv2.state_financial_aid, uv2.work_load_cp_lab, uv2.work_load_cp_lecture, uv2.subtitle_id, uvsb.subtitle, uv2.subtitle_modifiable_flag, uv2.special_permission_ind, uv2.ivr_enrol_ind, uv2.ss_enrol_ind, uv2.claimable_hours, uv2.created_by, uv2.creation_date, uv2.last_updated_by, uv2.last_update_date, uv2.last_update_login, uv2.auditable_ind, uv2.audit_permission_ind, uv2.max_auditors_allowed, uv2.OVRD_WKLD_VAL_FLAG, uv2.WORKLOAD_VAL_CODE

View Text - HTML Formatted

SELECT UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, UVH1.HIST_START_DT
, UVH1.HIST_END_DT
, UVH1.HIST_WHO
, NVL( UVH1.START_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'START_DT'
, UVH1.HIST_END_DT))
, UV1.START_DT))
, NVL( UVH1.REVIEW_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'REVIEW_DT'
, UVH1.HIST_END_DT))
, UV1.REVIEW_DT))
, NVL( UVH1.EXPIRY_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'EXPIRY_DT'
, UVH1.HIST_END_DT))
, UV1.EXPIRY_DT))
, NVL( UVH1.END_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'END_DT'
, UVH1.HIST_END_DT))
, UV1.END_DT))
, NVL( UVH1.UNIT_STATUS
, NVL( SUBSTR(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'UNIT_STATUS'
, UVH1.HIST_END_DT)
, 1
, 10)
, UV1.UNIT_STATUS))
, NVL( UVH1.TITLE
, NVL( SUBSTR(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'TITLE'
, UVH1.HIST_END_DT)
, 1
, 90)
, UV1.TITLE))
, NVL( UVH1.SHORT_TITLE
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SHORT_TITLE'
, UVH1.HIST_END_DT)
, 1
, 40)
, UV1.SHORT_TITLE))
, NVL( UVH1.TITLE_OVERRIDE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'TITLE_OVERRIDE_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.TITLE_OVERRIDE_IND))
, NVL( UVH1.ABBREVIATION
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ABBREVIATION'
, UVH1.HIST_END_DT)
, 1
, 20)
, UV1.ABBREVIATION))
, NVL( UVH1.UNIT_LEVEL
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'UNIT_LEVEL'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.UNIT_LEVEL))
, NVL( UVH1.UL_DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'UL_DESCRIPTION'
, UVH1.HIST_END_DT)
, 1
, 60)
, UL1.DESCRIPTION))
, NVL( UVH1.CREDIT_POINT_DESCRIPTOR
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CREDIT_POINT_DESCRIPTOR'
, UVH1.HIST_END_DT)
, 1
, 10)
, UV1.CREDIT_POINT_DESCRIPTOR))
, NVL( UVH1.ENROLLED_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ENROLLED_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.ENROLLED_CREDIT_POINTS))
, NVL( UVH1.POINTS_OVERRIDE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'POINTS_OVERRIDE_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.POINTS_OVERRIDE_IND))
, NVL( UVH1.SUPP_EXAM_PERMITTED_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SUPP_EXAM_PERMITTED_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.SUPP_EXAM_PERMITTED_IND))
, NVL( UVH1.COORD_PERSON_ID
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'COORD_PERSON_ID'
, UVH1.HIST_END_DT))
, UV1.COORD_PERSON_ID))
, NVL( UVH1.OWNER_ORG_UNIT_CD
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'OWNER_ORG_UNIT_CD'
, UVH1.HIST_END_DT)
, 1
, 30)
, UV1.OWNER_ORG_UNIT_CD))
, NVL( UVH1.OWNER_OU_START_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'OWNER_OU_START_DT'
, UVH1.HIST_END_DT))
, UV1.OWNER_OU_START_DT))
, NVL( UVH1.OU_DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'OU_DESCRIPTION'
, UVH1.HIST_END_DT)
, 1
, 60)
, OU1.PARTY_NAME))
, NVL( UVH1.AWARD_COURSE_ONLY_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'AWARD_COURSE_ONLY_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.AWARD_COURSE_ONLY_IND))
, NVL( UVH1.RESEARCH_UNIT_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'RESEARCH_UNIT_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.RESEARCH_UNIT_IND))
, NVL(UVH1.SUB_UNIT_ALLOWED_IND
, UV1.SUB_UNIT_ALLOWED_IND)
, NVL(UVH1.SUP_UNIT_ALLOWED_IND
, UV1.SUP_UNIT_ALLOWED_IND)
, NVL( UVH1.INDUSTRIAL_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'INDUSTRIAL_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.INDUSTRIAL_IND))
, NVL( UVH1.PRACTICAL_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'PRACTICAL_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.PRACTICAL_IND))
, NVL( UVH1.REPEATABLE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'REPEATABLE_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.REPEATABLE_IND))
, NVL( UVH1.ASSESSABLE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ASSESSABLE_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.ASSESSABLE_IND))
, NVL( UVH1.ACHIEVABLE_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ACHIEVABLE_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.ACHIEVABLE_CREDIT_POINTS))
, NVL( UVH1.POINTS_INCREMENT
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'POINTS_INCREMENT'
, UVH1.HIST_END_DT))
, UV1.POINTS_INCREMENT))
, NVL( UVH1.POINTS_MIN
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'POINTS_MIN'
, UVH1.HIST_END_DT))
, UV1.POINTS_MIN))
, NVL( UVH1.POINTS_MAX
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'POINTS_MAX'
, UVH1.HIST_END_DT))
, UV1.POINTS_MAX))
, NVL( UVH1.UNIT_INT_COURSE_LEVEL_CD
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'UNIT_INT_COURSE_LEVEL_CD'
, UVH1.HIST_END_DT)
, 1
, 10)
, UV1.UNIT_INT_COURSE_LEVEL_CD))
, NVL( UVH1.UICL_DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'UICL_DESCRIPTION'
, UVH1.HIST_END_DT)
, 1
, 60)
, UICL1.DESCRIPTION))
, NVL( UVH1.WORK_LOAD_OTHER
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'WORK_LOAD_OTHER'
, UVH1.HIST_END_DT))
, UV1.WORK_LOAD_OTHER))
, NVL( UVH1.CONTACT_HRS_LECTURE
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CONTACT_HRS_LECTURE'
, UVH1.HIST_END_DT))
, UV1.CONTACT_HRS_LECTURE))
, NVL( UVH1.CONTACT_HRS_LAB
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CONTACT_HRS_LAB'
, UVH1.HIST_END_DT))
, UV1.CONTACT_HRS_LAB))
, NVL( UVH1.CONTACT_HRS_OTHER
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CONTACT_HRS_OTHER'
, UVH1.HIST_END_DT))
, UV1.CONTACT_HRS_OTHER))
, NVL( UVH1.BILLING_HRS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'BILLING_HRS'
, UVH1.HIST_END_DT))
, UV1.BILLING_HRS))
, NVL( UVH1.NON_SCHD_REQUIRED_HRS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'NON_SCHD_REQUIRED_HRS'
, UVH1.HIST_END_DT))
, UV1.NON_SCHD_REQUIRED_HRS))
, NVL( UVH1.FIN_AID_CP
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'FIN_AID_CP'
, UVH1.HIST_END_DT))
, UV1.FIN_AID_CP))
, NVL( UVH1.FIN_AID_HRS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'FIN_AID_HRS'
, UVH1.HIST_END_DT))
, UV1.FIN_AID_HRS))
, NVL( UVH1.EXCLUDE_FROM_MAX_CP_LIMIT
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'EXCLUDE_FROM_MAX_CP_LIMIT'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.EXCLUDE_FROM_MAX_CP_LIMIT))
, NVL( UVH1.RECORD_EXCLUSION_FLAG
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'RECORD_EXCLUSION_FLAG'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.RECORD_EXCLUSION_FLAG))
, NVL( UVH1.SS_DISPLAY_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SS_DISPLAY_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.SS_DISPLAY_IND))
, NVL( UVH1.CAL_TYPE_ENROL_LOAD_CAL
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CAL_TYPE_ENROL_LOAD_CAL'
, UVH1.HIST_END_DT)
, 1
, 10)
, UV1.CAL_TYPE_ENROL_LOAD_CAL))
, NVL( UVH1.SEQUENCE_NUM_ENROL_LOAD_CAL
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SEQUENCE_NUM_ENROL_LOAD_CAL'
, UVH1.HIST_END_DT))
, UV1.SEQUENCE_NUM_ENROL_LOAD_CAL))
, NVL( UVH1.CAL_TYPE_OFFER_LOAD_CAL
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CAL_TYPE_OFFER_LOAD_CAL'
, UVH1.HIST_END_DT)
, 1
, 10)
, UV1.CAL_TYPE_OFFER_LOAD_CAL))
, NVL( UVH1.SEQUENCE_NUM_OFFER_LOAD_CAL
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SEQUENCE_NUM_OFFER_LOAD_CAL'
, UVH1.HIST_END_DT))
, UV1.SEQUENCE_NUM_OFFER_LOAD_CAL))
, NVL( UVH1.CURRICULUM_ID
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CURRICULUM_ID'
, UVH1.HIST_END_DT)
, 1
, 10)
, UV1.CURRICULUM_ID))
, NVL( UVH1.OVERRIDE_ENROLLMENT_MAX
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'OVERRIDE_ENROLLMENT_MAX'
, UVH1.HIST_END_DT))
, UV1.OVERRIDE_ENROLLMENT_MAX))
, NVL( UVH1.RPT_FMLY_ID
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'RPT_FMLY_ID'
, UVH1.HIST_END_DT))
, UV1.RPT_FMLY_ID))
, NVL( UVH1.UNIT_TYPE_ID
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'UNIT_TYPE_ID'
, UVH1.HIST_END_DT))
, UV1.UNIT_TYPE_ID))
, NVL( UVH1.REPEAT_CODE
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'REPEAT_CODE'
, UVH1.HIST_END_DT)
, 1
, 10)
, URF.REPEAT_CODE))
, NVL( UVH1.LEVEL_CODE
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'LEVEL_CODE'
, UVH1.HIST_END_DT)
, 1
, 10)
, UL.LEVEL_CODE))
, NVL(UVH1.ADVANCE_MAXIMUM
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ADVANCE_MAXIMUM'
, UVH1.HIST_END_DT))
, UV1.ADVANCE_MAXIMUM))
, NVL( UVH1.APPROVAL_DATE
, NVL( IGS_GE_DATE.IGSDATE( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'APPROVAL_DATE'
, UVH1.HIST_END_DT))
, UV1.APPROVAL_DATE))
, NVL( UVH1.BILLING_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'BILLING_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.BILLING_CREDIT_POINTS))
, NVL( UVH1.CONTINUING_EDUCATION_UNITS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CONTINUING_EDUCATION_UNITS'
, UVH1.HIST_END_DT))
, UV1.CONTINUING_EDUCATION_UNITS))
, NVL( UVH1.ENROLLMENT_EXPECTED
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ENROLLMENT_EXPECTED'
, UVH1.HIST_END_DT))
, UV1.ENROLLMENT_EXPECTED))
, NVL( UVH1.ENROLLMENT_MAXIMUM
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ENROLLMENT_MAXIMUM'
, UVH1.HIST_END_DT))
, UV1.ENROLLMENT_MAXIMUM))
, NVL( UVH1.ENROLLMENT_MINIMUM
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'ENROLLMENT_MINIMUM'
, UVH1.HIST_END_DT))
, UV1.ENROLLMENT_MINIMUM))
, NVL( UVH1.FEDERAL_FINANCIAL_AID
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'FEDERAL_FINANCIAL_AID'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.FEDERAL_FINANCIAL_AID))
, NVL( UVH1.INSTITUTIONAL_FINANCIAL_AID
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'INSTITUTIONAL_FINANCIAL_AID'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.INSTITUTIONAL_FINANCIAL_AID))
, NVL( UVH1.LAB_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'LAB_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.LAB_CREDIT_POINTS))
, NVL( UVH1.LECTURE_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'LECTURE_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.LECTURE_CREDIT_POINTS))
, DECODE( NVL( UVH1.REPEATABLE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'REPEATABLE_IND'
, UVH1.HIST_END_DT )
, 1
, 1)
, UV1.REPEATABLE_IND))
, 'N'
, NVL( UVH1.MAX_REPEATS_FOR_CREDIT
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'MAX_REPEATS_FOR_CREDIT'
, UVH1.HIST_END_DT))
, UV1.MAX_REPEATS_FOR_CREDIT))
, NULL)
, DECODE( NVL( UVH1.REPEATABLE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'REPEATABLE_IND'
, UVH1.HIST_END_DT )
, 1
, 1)
, UV1.REPEATABLE_IND))
, 'Y'
, NVL( UVH1.MAX_REPEATS_FOR_CREDIT
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'MAX_REPEATS_FOR_CREDIT'
, UVH1.HIST_END_DT))
, UV1.MAX_REPEATS_FOR_CREDIT))
, NULL)
, NVL( UVH1.MAX_REPEATS_FOR_FUNDING
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'MAX_REPEATS_FOR_FUNDING'
, UVH1.HIST_END_DT))
, UV1.MAX_REPEATS_FOR_FUNDING))
, NVL( UVH1.MAX_REPEAT_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'MAX_REPEAT_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.MAX_REPEAT_CREDIT_POINTS))
, NVL( UVH1.CLOCK_HOURS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CLOCK_HOURS'
, UVH1.HIST_END_DT))
, UV1.CLOCK_HOURS))
, NVL( UVH1.OTHER_CREDIT_POINTS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'OTHER_CREDIT_POINTS'
, UVH1.HIST_END_DT))
, UV1.OTHER_CREDIT_POINTS))
, NVL( UVH1.SAME_TEACHING_PERIOD
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SAME_TEACHING_PERIOD'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.SAME_TEACHING_PERIOD))
, NVL( UVH1.SAME_TEACH_PERIOD_REPEATS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SAME_TEACH_PERIOD_REPEATS'
, UVH1.HIST_END_DT))
, UV1.SAME_TEACH_PERIOD_REPEATS))
, NVL( UVH1.SAME_TEACH_PERIOD_REPEATS_CP
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SAME_TEACH_PERIOD_REPEATS_CP'
, UVH1.HIST_END_DT))
, UV1.SAME_TEACH_PERIOD_REPEATS_CP))
, NVL( UVH1.STATE_FINANCIAL_AID
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'STATE_FINANCIAL_AID'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.STATE_FINANCIAL_AID))
, NVL( UVH1.WORK_LOAD_CP_LAB
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'WORK_LOAD_CP_LAB'
, UVH1.HIST_END_DT))
, UV1.WORK_LOAD_CP_LAB))
, NVL( UVH1.WORK_LOAD_CP_LECTURE
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'WORK_LOAD_CP_LECTURE'
, UVH1.HIST_END_DT))
, UV1.WORK_LOAD_CP_LECTURE))
, NVL( UVH1.SUBTITLE_ID
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SUBTITLE_ID'
, UVH1.HIST_END_DT))
, UV1.SUBTITLE_ID))
, NVL( UVH1.SUBTITLE
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SUBTITLE'
, UVH1.HIST_END_DT)
, 1
, 90)
, UVSB.SUBTITLE))
, NVL( UVH1.SUBTITLE_MODIFIABLE_FLAG
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SUBTITLE_MODIFIABLE_FLAG'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.SUBTITLE_MODIFIABLE_FLAG))
, NVL( UVH1.SPECIAL_PERMISSION_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SPECIAL_PERMISSION_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.SPECIAL_PERMISSION_IND))
, NVL( UVH1.IVR_ENROL_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'IVR_ENROL_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.IVR_ENROL_IND))
, NVL( UVH1.SS_ENROL_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'SS_ENROL_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.SS_ENROL_IND))
, NVL( UVH1.CLAIMABLE_HOURS
, NVL( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'CLAIMABLE_HOURS'
, UVH1.HIST_END_DT)
, UV1.CLAIMABLE_HOURS))
, UVH1.CREATED_BY
, UVH1.CREATION_DATE
, UVH1.LAST_UPDATED_BY
, UVH1.LAST_UPDATE_DATE
, UVH1.LAST_UPDATE_LOGIN
, NVL( UVH1.AUDITABLE_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'AUDITABLE_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.AUDITABLE_IND))
, NVL( UVH1.AUDIT_PERMISSION_IND
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'AUDIT_PERMISSION_IND'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.AUDIT_PERMISSION_IND))
, NVL( UVH1.MAX_AUDITORS_ALLOWED
, NVL(IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'MAX_AUDITORS_ALLOWED'
, UVH1.HIST_END_DT))
, UV1.MAX_AUDITORS_ALLOWED))
, NVL( UVH1.OVRD_WKLD_VAL_FLAG
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'OVRD_WKLD_VAL_FLAG'
, UVH1.HIST_END_DT)
, 1
, 1)
, UV1.OVRD_WKLD_VAL_FLAG))
, NVL( UVH1.WORKLOAD_VAL_CODE
, NVL( SUBSTR( IGS_AU_GEN_004.AUDP_GET_UVH_COL( UVH1.UNIT_CD
, UVH1.VERSION_NUMBER
, 'WORKLOAD_VAL_CODE'
, UVH1.HIST_END_DT)
, 1
, 30)
, UV1.WORKLOAD_VAL_CODE))
FROM IGS_PS_UNIT_VER_HIST UVH1
, IGS_PS_UNIT_VER UV1
, IGS_PS_UNIT_LEVEL UL1
, IGS_PS_UNIT_INT_LVL UICL1
, IGS_OR_INST_ORG_BASE_V OU1
, IGS_PS_UNIT_TYPE_LVL UL
, IGS_PS_RPT_FMLY_ALL URF
, IGS_PS_UNIT_SUBTITLE UVSB
WHERE UV1.UNIT_CD = UVH1.UNIT_CD
AND UV1.VERSION_NUMBER = UVH1.VERSION_NUMBER
AND UV1.UNIT_LEVEL = UL1.UNIT_LEVEL (+)
AND UV1.UNIT_INT_COURSE_LEVEL_CD = UICL1.UNIT_INT_COURSE_LEVEL_CD(+)
AND UV1.OWNER_ORG_UNIT_CD = OU1.PARTY_NUMBER (+)
AND UV1.OWNER_OU_START_DT = OU1.START_DT (+)
AND UV1.RPT_FMLY_ID = URF.RPT_FMLY_ID(+)
AND UV1.UNIT_TYPE_ID = UL.UNIT_TYPE_ID (+)
AND UV1.SUBTITLE_ID = UVSB.SUBTITLE_ID(+) UNION ALL SELECT UV2.UNIT_CD
, UV2.VERSION_NUMBER
, NVL( MAX(UVH2.HIST_END_DT)
, UV2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, UV2.LAST_UPDATED_BY
, UV2.START_DT
, UV2.REVIEW_DT
, UV2.EXPIRY_DT
, UV2.END_DT
, UV2.UNIT_STATUS
, UV2.TITLE
, UV2.SHORT_TITLE
, UV2.TITLE_OVERRIDE_IND
, UV2.ABBREVIATION
, UV2.UNIT_LEVEL
, UL2.DESCRIPTION
, UV2.CREDIT_POINT_DESCRIPTOR
, UV2.ENROLLED_CREDIT_POINTS
, UV2.POINTS_OVERRIDE_IND
, UV2.SUPP_EXAM_PERMITTED_IND
, UV2.COORD_PERSON_ID
, UV2.OWNER_ORG_UNIT_CD
, UV2.OWNER_OU_START_DT
, OU2.PARTY_NAME
, UV2.AWARD_COURSE_ONLY_IND
, UV2.RESEARCH_UNIT_IND
, UV2.SUB_UNIT_ALLOWED_IND
, UV2.SUP_UNIT_ALLOWED_IND
, UV2.INDUSTRIAL_IND
, UV2.PRACTICAL_IND
, UV2.REPEATABLE_IND
, UV2.ASSESSABLE_IND
, UV2.ACHIEVABLE_CREDIT_POINTS
, UV2.POINTS_INCREMENT
, UV2.POINTS_MIN
, UV2.POINTS_MAX
, UV2.UNIT_INT_COURSE_LEVEL_CD
, UICL2.DESCRIPTION
, UV2.WORK_LOAD_OTHER
, UV2.CONTACT_HRS_LECTURE
, UV2.CONTACT_HRS_LAB
, UV2.CONTACT_HRS_OTHER
, UV2.BILLING_HRS
, UV2.NON_SCHD_REQUIRED_HRS
, UV2.FIN_AID_CP
, UV2.FIN_AID_HRS
, UV2.EXCLUDE_FROM_MAX_CP_LIMIT
, UV2.RECORD_EXCLUSION_FLAG
, UV2.SS_DISPLAY_IND
, UV2.CAL_TYPE_ENROL_LOAD_CAL
, UV2.SEQUENCE_NUM_ENROL_LOAD_CAL
, UV2.CAL_TYPE_OFFER_LOAD_CAL
, UV2.SEQUENCE_NUM_OFFER_LOAD_CAL
, UV2.CURRICULUM_ID
, UV2.OVERRIDE_ENROLLMENT_MAX
, UV2.RPT_FMLY_ID
, UV2.UNIT_TYPE_ID
, URF.REPEAT_CODE
, UL.LEVEL_CODE
, UV2.ADVANCE_MAXIMUM
, UV2.APPROVAL_DATE
, UV2.BILLING_CREDIT_POINTS
, UV2.CONTINUING_EDUCATION_UNITS
, UV2.ENROLLMENT_EXPECTED
, UV2.ENROLLMENT_MAXIMUM
, UV2.ENROLLMENT_MINIMUM
, UV2.FEDERAL_FINANCIAL_AID
, UV2.INSTITUTIONAL_FINANCIAL_AID
, UV2.LAB_CREDIT_POINTS
, UV2.LECTURE_CREDIT_POINTS
, DECODE(UV2.REPEATABLE_IND
, 'N'
, UV2.MAX_REPEATS_FOR_CREDIT
, NULL)
, DECODE(UV2.REPEATABLE_IND
, 'Y'
, UV2.MAX_REPEATS_FOR_CREDIT
, NULL)
, UV2.MAX_REPEATS_FOR_FUNDING
, UV2.MAX_REPEAT_CREDIT_POINTS
, UV2.CLOCK_HOURS
, UV2.OTHER_CREDIT_POINTS
, UV2.SAME_TEACHING_PERIOD
, UV2.SAME_TEACH_PERIOD_REPEATS
, UV2.SAME_TEACH_PERIOD_REPEATS_CP
, UV2.STATE_FINANCIAL_AID
, UV2.WORK_LOAD_CP_LAB
, UV2.WORK_LOAD_CP_LECTURE
, UV2.SUBTITLE_ID
, UVSB.SUBTITLE
, UV2.SUBTITLE_MODIFIABLE_FLAG
, UV2.SPECIAL_PERMISSION_IND
, UV2.IVR_ENROL_IND
, UV2.SS_ENROL_IND
, UV2.CLAIMABLE_HOURS
, UV2.CREATED_BY
, UV2.CREATION_DATE
, UV2.LAST_UPDATED_BY
, UV2.LAST_UPDATE_DATE
, UV2.LAST_UPDATE_LOGIN
, UV2.AUDITABLE_IND
, UV2.AUDIT_PERMISSION_IND
, UV2.MAX_AUDITORS_ALLOWED
, UV2.OVRD_WKLD_VAL_FLAG
, UV2.WORKLOAD_VAL_CODE
FROM IGS_PS_UNIT_VER_HIST UVH2
, IGS_PS_UNIT_VER UV2
, IGS_PS_UNIT_LEVEL UL2
, IGS_PS_UNIT_INT_LVL UICL2
, IGS_OR_INST_ORG_BASE_V OU2
, IGS_PS_UNIT_TYPE_LVL UL
, IGS_PS_RPT_FMLY_ALL URF
, IGS_PS_UNIT_SUBTITLE UVSB
WHERE UV2.UNIT_CD = UVH2.UNIT_CD (+)
AND UV2.VERSION_NUMBER = UVH2.VERSION_NUMBER (+)
AND UV2.UNIT_LEVEL = UL2.UNIT_LEVEL (+)
AND UV2.UNIT_INT_COURSE_LEVEL_CD = UICL2.UNIT_INT_COURSE_LEVEL_CD (+)
AND UV2.OWNER_ORG_UNIT_CD = OU2.PARTY_NUMBER (+)
AND UV2.OWNER_OU_START_DT = OU2.START_DT (+)
AND UV2.RPT_FMLY_ID = URF.RPT_FMLY_ID (+)
AND UV2.UNIT_TYPE_ID = UL.UNIT_TYPE_ID (+)
AND UV2.SUBTITLE_ID = UVSB.SUBTITLE_ID (+) GROUP BY UV2.UNIT_CD
, UV2.VERSION_NUMBER
, UV2.START_DT
, UV2.REVIEW_DT
, UV2.EXPIRY_DT
, UV2.END_DT
, UV2.UNIT_STATUS
, UV2.TITLE
, UV2.SHORT_TITLE
, UV2.TITLE_OVERRIDE_IND
, UV2.ABBREVIATION
, UV2.UNIT_LEVEL
, UL2.DESCRIPTION
, UV2.CREDIT_POINT_DESCRIPTOR
, UV2.ENROLLED_CREDIT_POINTS
, UV2.POINTS_OVERRIDE_IND
, UV2.SUPP_EXAM_PERMITTED_IND
, UV2.COORD_PERSON_ID
, UV2.OWNER_ORG_UNIT_CD
, UV2.OWNER_OU_START_DT
, OU2.PARTY_NAME
, UV2.AWARD_COURSE_ONLY_IND
, UV2.RESEARCH_UNIT_IND
, UV2.SUB_UNIT_ALLOWED_IND
, UV2.SUP_UNIT_ALLOWED_IND
, UV2.INDUSTRIAL_IND
, UV2.PRACTICAL_IND
, UV2.REPEATABLE_IND
, UV2.ASSESSABLE_IND
, UV2.ACHIEVABLE_CREDIT_POINTS
, UV2.POINTS_INCREMENT
, UV2.POINTS_MIN
, UV2.POINTS_MAX
, UV2.UNIT_INT_COURSE_LEVEL_CD
, UICL2.DESCRIPTION
, UV2.WORK_LOAD_OTHER
, UV2.CONTACT_HRS_LECTURE
, UV2.CONTACT_HRS_LAB
, UV2.CONTACT_HRS_OTHER
, UV2.BILLING_HRS
, UV2.NON_SCHD_REQUIRED_HRS
, UV2.FIN_AID_CP
, UV2.FIN_AID_HRS
, UV2.EXCLUDE_FROM_MAX_CP_LIMIT
, UV2.RECORD_EXCLUSION_FLAG
, UV2.SS_DISPLAY_IND
, UV2.CAL_TYPE_ENROL_LOAD_CAL
, UV2.SEQUENCE_NUM_ENROL_LOAD_CAL
, UV2.CAL_TYPE_OFFER_LOAD_CAL
, UV2.SEQUENCE_NUM_OFFER_LOAD_CAL
, UV2.CURRICULUM_ID
, UV2.OVERRIDE_ENROLLMENT_MAX
, UV2.RPT_FMLY_ID
, UV2.UNIT_TYPE_ID
, URF.REPEAT_CODE
, UL.LEVEL_CODE
, UV2.ADVANCE_MAXIMUM
, UV2.APPROVAL_DATE
, UV2.BILLING_CREDIT_POINTS
, UV2.CONTINUING_EDUCATION_UNITS
, UV2.ENROLLMENT_EXPECTED
, UV2.ENROLLMENT_MAXIMUM
, UV2.ENROLLMENT_MINIMUM
, UV2.FEDERAL_FINANCIAL_AID
, UV2.INSTITUTIONAL_FINANCIAL_AID
, UV2.LAB_CREDIT_POINTS
, UV2.LECTURE_CREDIT_POINTS
, UV2.MAX_REPEATS_FOR_CREDIT
, UV2.MAX_REPEATS_FOR_FUNDING
, UV2.MAX_REPEAT_CREDIT_POINTS
, UV2.CLOCK_HOURS
, UV2.OTHER_CREDIT_POINTS
, UV2.SAME_TEACHING_PERIOD
, UV2.SAME_TEACH_PERIOD_REPEATS
, UV2.SAME_TEACH_PERIOD_REPEATS_CP
, UV2.STATE_FINANCIAL_AID
, UV2.WORK_LOAD_CP_LAB
, UV2.WORK_LOAD_CP_LECTURE
, UV2.SUBTITLE_ID
, UVSB.SUBTITLE
, UV2.SUBTITLE_MODIFIABLE_FLAG
, UV2.SPECIAL_PERMISSION_IND
, UV2.IVR_ENROL_IND
, UV2.SS_ENROL_IND
, UV2.CLAIMABLE_HOURS
, UV2.CREATED_BY
, UV2.CREATION_DATE
, UV2.LAST_UPDATED_BY
, UV2.LAST_UPDATE_DATE
, UV2.LAST_UPDATE_LOGIN
, UV2.AUDITABLE_IND
, UV2.AUDIT_PERMISSION_IND
, UV2.MAX_AUDITORS_ALLOWED
, UV2.OVRD_WKLD_VAL_FLAG
, UV2.WORKLOAD_VAL_CODE