Product: | IGS - Student System |
---|---|
Description: | This entity describes the Unit version details with title information, important dates, maximum/minimum/increment points, details regarding enrolment with enrolment/offered load calendar types and sequence numbers. |
Implementation/DBA Data: | APPS.IGSBV_HIGH_ED_UNIT_VERSIONS |
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