VIEW: APPS.IGSBV_HIGH_ED_UNIT_VERSIONS

Source

View Text - Preformatted

SELECT UNIT_CD UNIT_CODE, VERSION_NUMBER, START_DT START_DATE, REVIEW_DT REVIEW_DATE, EXPIRY_DT EXPIRY_DATE, END_DT END_DATE, UNIT_STATUS, TITLE, SHORT_TITLE, TITLE_OVERRIDE_IND TITLE_OVERRIDE_INDICATOR, ABBREVIATION, UNIT_LEVEL, CREDIT_POINT_DESCRIPTOR, ENROLLED_CREDIT_POINTS, POINTS_OVERRIDE_IND POINTS_OVERRIDE_INDICATOR, SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERM_INDICATOR, COORD_PERSON_ID, OWNER_ORG_UNIT_CD , OWNER_OU_START_DT OWNER_ORG_UNIT_START_DATE, AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_INDICATOR, RESEARCH_UNIT_IND RESEARCH_UNIT_INDICATOR, SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_INDICATOR, SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_INDICATOR, INDUSTRIAL_IND INDUSTRIAL_INDICATOR, PRACTICAL_IND PRACTICAL_INDICATOR, REPEATABLE_IND REPEATABLE_INDICATOR, ASSESSABLE_IND ASSESSABLE_INDICATOR, ACHIEVABLE_CREDIT_POINTS, POINTS_INCREMENT, POINTS_MIN POINTS_MINIMUM, POINTS_MAX POINTS_MAXIMUM, UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CODE, SUBTITLE, SUBTITLE_MODIFIABLE_FLAG, APPROVAL_DATE, LECTURE_CREDIT_POINTS, LAB_CREDIT_POINTS, OTHER_CREDIT_POINTS, BILLING_CREDIT_POINTS, CLOCK_HOURS, WORK_LOAD_CP_LECTURE, WORK_LOAD_CP_LAB, CONTINUING_EDUCATION_UNITS, ENROLLMENT_EXPECTED, ENROLLMENT_MINIMUM, ENROLLMENT_MAXIMUM, ADVANCE_MAXIMUM, BILLING_HRS BILLABLE_CREDIT_POINTS, STATE_FINANCIAL_AID, FEDERAL_FINANCIAL_AID, INSTITUTIONAL_FINANCIAL_AID, SAME_TEACHING_PERIOD, MAX_REPEATS_FOR_CREDIT MAXIMUM_CREDITS_FOR_REPEAT, MAX_REPEATS_FOR_FUNDING MAXIMUM_CREDITS_FOR_FUNDING, MAX_REPEAT_CREDIT_POINTS MAXIMUM_REPEAT_CREDIT_POINTS, SAME_TEACH_PERIOD_REPEATS, SAME_TEACH_PERIOD_REPEATS_CP, IVR_ENROL_IND IVR_ENROL_INDICATOR, SS_ENROL_IND SS_ENROL_INDICATOR, SUBTITLE_ID, WORK_LOAD_OTHER, CONTACT_HRS_LECTURE CONTACT_HOURS_LECTURE, CONTACT_HRS_LAB CONTACT_HOURS_LABORATORY, CONTACT_HRS_OTHER CONTACT_HOURS_OTHER, NON_SCHD_REQUIRED_HRS NON_SCHED_REQUIRED_HOURS, EXCLUDE_FROM_MAX_CP_LIMIT, RECORD_EXCLUSION_FLAG, SS_DISPLAY_IND SS_DISP_INDICATOR, CAL_TYPE_ENROL_LOAD_CAL ENROL_LOAD_CALENDAR_TYPE, SEQUENCE_NUM_ENROL_LOAD_CAL ENROL_LOAD_CAL_SEQ_NUMBER, CAL_TYPE_OFFER_LOAD_CAL OFFERED_LOAD_CALENDAR_TYPE, SEQUENCE_NUM_OFFER_LOAD_CAL OFFERED_LOAD_CAL_SEQ_NUMBER, CURRICULUM_ID, OVERRIDE_ENROLLMENT_MAX OVERRIDE_ENROL_MAXIMUM, RPT_FMLY_ID, UNIT_TYPE_ID, SPECIAL_PERMISSION_IND SPL_PERMISSION_INDICATOR, REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE, CLAIMABLE_HOURS, ANON_UNIT_GRADING_IND ANON_UNITS_GRADING_INDICATOR, ANON_ASSESS_GRADING_IND ANON_ASSESS_GRADING_INDICATOR, AUDITABLE_IND AUDITABLE_INDICATOR, AUDIT_PERMISSION_IND AUDIT_PERMISSION_INDICATOR, MAX_AUDITORS_ALLOWED MAXIMUM_AUDITORS_ALLOWED, OVRD_WKLD_VAL_FLAG WORKLOAD_VALIDATION_FLAG, '_LA:CREDIT_POINT_DESCRIPTOR:IGS_LOOKUP_VALUES:CREDIT_POINT_DSCR:MEANING', '_LA:WORKLOAD_VAL_CODE:IGS_LOOKUP_VALUES:WKLD_VAL_TYPE:MEANING', CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS_PS_UNIT_VER_ALL WITH READ ONLY

View Text - HTML Formatted

SELECT UNIT_CD UNIT_CODE
, VERSION_NUMBER
, START_DT START_DATE
, REVIEW_DT REVIEW_DATE
, EXPIRY_DT EXPIRY_DATE
, END_DT END_DATE
, UNIT_STATUS
, TITLE
, SHORT_TITLE
, TITLE_OVERRIDE_IND TITLE_OVERRIDE_INDICATOR
, ABBREVIATION
, UNIT_LEVEL
, CREDIT_POINT_DESCRIPTOR
, ENROLLED_CREDIT_POINTS
, POINTS_OVERRIDE_IND POINTS_OVERRIDE_INDICATOR
, SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERM_INDICATOR
, COORD_PERSON_ID
, OWNER_ORG_UNIT_CD
, OWNER_OU_START_DT OWNER_ORG_UNIT_START_DATE
, AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_INDICATOR
, RESEARCH_UNIT_IND RESEARCH_UNIT_INDICATOR
, SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_INDICATOR
, SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_INDICATOR
, INDUSTRIAL_IND INDUSTRIAL_INDICATOR
, PRACTICAL_IND PRACTICAL_INDICATOR
, REPEATABLE_IND REPEATABLE_INDICATOR
, ASSESSABLE_IND ASSESSABLE_INDICATOR
, ACHIEVABLE_CREDIT_POINTS
, POINTS_INCREMENT
, POINTS_MIN POINTS_MINIMUM
, POINTS_MAX POINTS_MAXIMUM
, UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CODE
, SUBTITLE
, SUBTITLE_MODIFIABLE_FLAG
, APPROVAL_DATE
, LECTURE_CREDIT_POINTS
, LAB_CREDIT_POINTS
, OTHER_CREDIT_POINTS
, BILLING_CREDIT_POINTS
, CLOCK_HOURS
, WORK_LOAD_CP_LECTURE
, WORK_LOAD_CP_LAB
, CONTINUING_EDUCATION_UNITS
, ENROLLMENT_EXPECTED
, ENROLLMENT_MINIMUM
, ENROLLMENT_MAXIMUM
, ADVANCE_MAXIMUM
, BILLING_HRS BILLABLE_CREDIT_POINTS
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, SAME_TEACHING_PERIOD
, MAX_REPEATS_FOR_CREDIT MAXIMUM_CREDITS_FOR_REPEAT
, MAX_REPEATS_FOR_FUNDING MAXIMUM_CREDITS_FOR_FUNDING
, MAX_REPEAT_CREDIT_POINTS MAXIMUM_REPEAT_CREDIT_POINTS
, SAME_TEACH_PERIOD_REPEATS
, SAME_TEACH_PERIOD_REPEATS_CP
, IVR_ENROL_IND IVR_ENROL_INDICATOR
, SS_ENROL_IND SS_ENROL_INDICATOR
, SUBTITLE_ID
, WORK_LOAD_OTHER
, CONTACT_HRS_LECTURE CONTACT_HOURS_LECTURE
, CONTACT_HRS_LAB CONTACT_HOURS_LABORATORY
, CONTACT_HRS_OTHER CONTACT_HOURS_OTHER
, NON_SCHD_REQUIRED_HRS NON_SCHED_REQUIRED_HOURS
, EXCLUDE_FROM_MAX_CP_LIMIT
, RECORD_EXCLUSION_FLAG
, SS_DISPLAY_IND SS_DISP_INDICATOR
, CAL_TYPE_ENROL_LOAD_CAL ENROL_LOAD_CALENDAR_TYPE
, SEQUENCE_NUM_ENROL_LOAD_CAL ENROL_LOAD_CAL_SEQ_NUMBER
, CAL_TYPE_OFFER_LOAD_CAL OFFERED_LOAD_CALENDAR_TYPE
, SEQUENCE_NUM_OFFER_LOAD_CAL OFFERED_LOAD_CAL_SEQ_NUMBER
, CURRICULUM_ID
, OVERRIDE_ENROLLMENT_MAX OVERRIDE_ENROL_MAXIMUM
, RPT_FMLY_ID
, UNIT_TYPE_ID
, SPECIAL_PERMISSION_IND SPL_PERMISSION_INDICATOR
, REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, CLAIMABLE_HOURS
, ANON_UNIT_GRADING_IND ANON_UNITS_GRADING_INDICATOR
, ANON_ASSESS_GRADING_IND ANON_ASSESS_GRADING_INDICATOR
, AUDITABLE_IND AUDITABLE_INDICATOR
, AUDIT_PERMISSION_IND AUDIT_PERMISSION_INDICATOR
, MAX_AUDITORS_ALLOWED MAXIMUM_AUDITORS_ALLOWED
, OVRD_WKLD_VAL_FLAG WORKLOAD_VALIDATION_FLAG
, '_LA:CREDIT_POINT_DESCRIPTOR:IGS_LOOKUP_VALUES:CREDIT_POINT_DSCR:MEANING'
, '_LA:WORKLOAD_VAL_CODE:IGS_LOOKUP_VALUES:WKLD_VAL_TYPE:MEANING'
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_PS_UNIT_VER_ALL WITH READ ONLY