Product: | IGS - Student System (Obsolete) |
---|---|
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: | Not implemented in this database |
SELECT PSV.UNIT_CD UNIT_CODE
, PSV.VERSION_NUMBER
, PSV.START_DT START_DATE
, PSV.REVIEW_DT REVIEW_DATE
, PSV.EXPIRY_DT EXPIRY_DATE
, PSV.END_DT END_DATE
, PSV.UNIT_STATUS
, PSV.TITLE
, PSV.SHORT_TITLE
, PSV.TITLE_OVERRIDE_IND TITLE_OVERRIDE_INDICATOR
, PSV.ABBREVIATION
, PSV.UNIT_LEVEL
, PSV.CREDIT_POINT_DESCRIPTOR
, PSV.ENROLLED_CREDIT_POINTS
, PSV.POINTS_OVERRIDE_IND POINTS_OVERRIDE_INDICATOR
, PSV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERM_INDICATOR
, PSV.COORD_PERSON_ID
, PSV.OWNER_ORG_UNIT_CD
, PSV.OWNER_OU_START_DT OWNER_ORG_UNIT_START_DATE
, PSV.AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_INDICATOR
, PSV.RESEARCH_UNIT_IND RESEARCH_UNIT_INDICATOR
, PSV.SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_INDICATOR
, PSV.SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_INDICATOR
, PSV.INDUSTRIAL_IND INDUSTRIAL_INDICATOR
, PSV.PRACTICAL_IND PRACTICAL_INDICATOR
, PSV.REPEATABLE_IND REPEATABLE_INDICATOR
, PSV.ASSESSABLE_IND ASSESSABLE_INDICATOR
, PSV.ACHIEVABLE_CREDIT_POINTS
, PSV.POINTS_INCREMENT
, PSV.POINTS_MIN POINTS_MINIMUM
, PSV.POINTS_MAX POINTS_MAXIMUM
, PSV.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CODE
, PSV.SUBTITLE
, PSV.SUBTITLE_MODIFIABLE_FLAG
, PSV.APPROVAL_DATE
, PSV.LECTURE_CREDIT_POINTS
, PSV.LAB_CREDIT_POINTS
, PSV.OTHER_CREDIT_POINTS
, PSV.BILLING_CREDIT_POINTS
, PSV.CLOCK_HOURS
, PSV.WORK_LOAD_CP_LECTURE
, PSV.WORK_LOAD_CP_LAB
, PSV.CONTINUING_EDUCATION_UNITS
, PSV.ENROLLMENT_EXPECTED
, PSV.ENROLLMENT_MINIMUM
, PSV.ENROLLMENT_MAXIMUM
, PSV.ADVANCE_MAXIMUM
, PSV.BILLING_HRS BILLABLE_CREDIT_POINTS
, PSV.STATE_FINANCIAL_AID
, PSV.FEDERAL_FINANCIAL_AID
, PSV.INSTITUTIONAL_FINANCIAL_AID
, PSV.SAME_TEACHING_PERIOD
, PSV.MAX_REPEATS_FOR_CREDIT MAXIMUM_CREDITS_FOR_REPEAT
, PSV.MAX_REPEATS_FOR_FUNDING MAXIMUM_CREDITS_FOR_FUNDING
, PSV.MAX_REPEAT_CREDIT_POINTS MAXIMUM_REPEAT_CREDIT_POINTS
, PSV.SAME_TEACH_PERIOD_REPEATS
, PSV.SAME_TEACH_PERIOD_REPEATS_CP
, '_DF:IGS:IGS_PS_UNIT_VER_FLEX:PSV'
, PSV.IVR_ENROL_IND IVR_ENROL_INDICATOR
, PSV.SS_ENROL_IND SS_ENROL_INDICATOR
, PSV.SUBTITLE_ID
, PSV.WORK_LOAD_OTHER
, PSV.CONTACT_HRS_LECTURE CONTACT_HOURS_LECTURE
, PSV.CONTACT_HRS_LAB CONTACT_HOURS_LABORATORY
, PSV.CONTACT_HRS_OTHER CONTACT_HOURS_OTHER
, PSV.NON_SCHD_REQUIRED_HRS NON_SCHED_REQUIRED_HOURS
, PSV.EXCLUDE_FROM_MAX_CP_LIMIT
, PSV.RECORD_EXCLUSION_FLAG
, PSV.SS_DISPLAY_IND SS_DISP_INDICATOR
, PSV.CAL_TYPE_ENROL_LOAD_CAL ENROL_LOAD_CALENDAR_TYPE
, PSV.SEQUENCE_NUM_ENROL_LOAD_CAL ENROL_LOAD_CAL_SEQ_NUMBER
, PSV.CAL_TYPE_OFFER_LOAD_CAL OFFERED_LOAD_CALENDAR_TYPE
, PSV.SEQUENCE_NUM_OFFER_LOAD_CAL OFFERED_LOAD_CAL_SEQ_NUMBER
, PSV.CURRICULUM_ID
, PSV.OVERRIDE_ENROLLMENT_MAX OVERRIDE_ENROL_MAXIMUM
, PSV.RPT_FMLY_ID REPORTING_FAMILY_ID
, PSV.UNIT_TYPE_ID
, PSV.SPECIAL_PERMISSION_IND SPL_PERMISSION_INDICATOR
, PSV.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, PSV.CLAIMABLE_HOURS
, PSV.ANON_UNIT_GRADING_IND ANON_UNITS_GRADING_INDICATOR
, PSV.ANON_ASSESS_GRADING_IND ANON_ASSESS_GRADING_INDICATOR
, PSV.AUDITABLE_IND AUDITABLE_INDICATOR
, PSV.AUDIT_PERMISSION_IND AUDIT_PERMISSION_INDICATOR
, PSV.MAX_AUDITORS_ALLOWED MAXIMUM_AUDITORS_ALLOWED
, PSV.OVRD_WKLD_VAL_FLAG WORKLOAD_VALIDATION_FLAG
, PUS.DESCRIPTION UNIT_STATUS_DESCRIPTION
, PSL.DESCRIPTION UNIT_LEVEL_DESCRIPTION
, HP2.PARTY_NAME COORD_PERSON_NAME
, HP.PARTY_NAME OWNER_ORG_UNIT_DESC
, LVL.DESCRIPTION UNIT_INT_COURSE_LEVEL_DESC
, CAI1.DESCRIPTION ENROL_LOAD_CAL_DESC
, CAI2.DESCRIPTION OFFERED_LOAD_CAL_DESC
, PUC.DESCRIPTION CURRICULUM_DESCRIPTION
, FMY.DESCRIPTION REPORTING_FAMILY_DESC
, UTL.DESCRIPTION UNIT_TYPE_DESCRIPTION
, IGA.DESCRIPTION REVENUE_ACCOUNT_DESC
, '_LA:CREDIT_POINT_DESCRIPTOR:IGS_LOOKUP_VALUES:CREDIT_POINT_DSCR:MEANING'
, '_LA:WORKLOAD_VAL_CODE:IGS_LOOKUP_VALUES:WKLD_VAL_TYPE:MEANING'
, PSV.CREATED_BY
, PSV.CREATION_DATE
, PSV.LAST_UPDATED_BY
, PSV.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_VER_ALL PSV
, IGS_PS_UNIT_STAT PUS
, IGS_CA_INST_ALL CAI1
, IGS_CA_INST_ALL CAI2
, IGS_FI_ACC_ALL IGA
, IGS_PS_RPT_FMLY_ALL FMY
, IGS_PS_UNIT_INT_LVL LVL
, IGS_PS_UNIT_LEVEL_ALL PSL
, IGS_PS_UNIT_TYPE_LVL UTL
, IGS_PS_UNT_CRCLM_ALL PUC
, IGS_OR_INST_ORG_BASE_V HP
, HZ_PARTIES HP2
WHERE PSV.UNIT_STATUS=PUS.UNIT_STATUS
AND PSV.OWNER_ORG_UNIT_CD=HP.PARTY_NUMBER
AND PSV.COORD_PERSON_ID=HP2.PARTY_ID
AND PSV.CAL_TYPE_ENROL_LOAD_CAL=CAI1.CAL_TYPE(+)
AND PSV.SEQUENCE_NUM_ENROL_LOAD_CAL=CAI1.SEQUENCE_NUMBER(+)
AND PSV.CAL_TYPE_OFFER_LOAD_CAL=CAI2.CAL_TYPE(+)
AND PSV.SEQUENCE_NUM_OFFER_LOAD_CAL=CAI2.SEQUENCE_NUMBER(+)
AND PSV.REV_ACCOUNT_CD=IGA.ACCOUNT_CD(+)
AND PSV.RPT_FMLY_ID=FMY.RPT_FMLY_ID(+)
AND PSV.UNIT_INT_COURSE_LEVEL_CD=LVL.UNIT_INT_COURSE_LEVEL_CD(+)
AND PSV.UNIT_LEVEL=PSL.UNIT_LEVEL(+)
AND PSV.UNIT_TYPE_ID=UTL.UNIT_TYPE_ID(+)
AND PSV.CURRICULUM_ID=PUC.CURRICULUM_ID(+) WITH READ ONLY