View: IGS_PS_UNIT_VER_HIST

View Text

SELECT TAB.ROWID ROW_ID
, TAB.UNIT_CD UNIT_CD
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.START_DT START_DT
, TAB.REVIEW_DT REVIEW_DT
, TAB.EXPIRY_DT EXPIRY_DT
, TAB.END_DT END_DT
, TAB.UNIT_STATUS UNIT_STATUS
, TAB.TITLE TITLE
, TAB.SHORT_TITLE SHORT_TITLE
, TAB.TITLE_OVERRIDE_IND TITLE_OVERRIDE_IND
, TAB.ABBREVIATION ABBREVIATION
, TAB.UNIT_LEVEL UNIT_LEVEL
, TAB.UL_DESCRIPTION UL_DESCRIPTION
, TAB.CREDIT_POINT_DESCRIPTOR CREDIT_POINT_DESCRIPTOR
, TAB.ENROLLED_CREDIT_POINTS ENROLLED_CREDIT_POINTS
, TAB.POINTS_OVERRIDE_IND POINTS_OVERRIDE_IND
, TAB.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND
, TAB.COORD_PERSON_ID COORD_PERSON_ID
, TAB.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, TAB.OWNER_OU_START_DT OWNER_OU_START_DT
, TAB.OU_DESCRIPTION OU_DESCRIPTION
, TAB.AWARD_COURSE_ONLY_IND AWARD_COURSE_ONLY_IND
, TAB.RESEARCH_UNIT_IND RESEARCH_UNIT_IND
, TAB.SUB_UNIT_ALLOWED_IND SUB_UNIT_ALLOWED_IND
, TAB.SUP_UNIT_ALLOWED_IND SUP_UNIT_ALLOWED_IND
, TAB.INDUSTRIAL_IND INDUSTRIAL_IND
, TAB.PRACTICAL_IND PRACTICAL_IND
, TAB.REPEATABLE_IND REPEATABLE_IND
, TAB.ASSESSABLE_IND ASSESSABLE_IND
, TAB.ACHIEVABLE_CREDIT_POINTS ACHIEVABLE_CREDIT_POINTS
, TAB.POINTS_INCREMENT POINTS_INCREMENT
, TAB.POINTS_MIN POINTS_MIN
, TAB.POINTS_MAX POINTS_MAX
, TAB.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD
, TAB.UICL_DESCRIPTION UICL_DESCRIPTION
, TAB.SS_ENROL_IND SS_ENROL_IND
, TAB.IVR_ENROL_IND IVR_ENROL_IND
, TAB.WORK_LOAD_OTHER
, TAB.CONTACT_HRS_LECTURE
, TAB.CONTACT_HRS_LAB
, TAB.CONTACT_HRS_OTHER
, TAB.BILLING_HRS
, TAB.NON_SCHD_REQUIRED_HRS
, TAB.FIN_AID_CP
, TAB.FIN_AID_HRS
, TAB.EXCLUDE_FROM_MAX_CP_LIMIT
, TAB.RECORD_EXCLUSION_FLAG
, TAB.SS_DISPLAY_IND
, TAB.CAL_TYPE_ENROL_LOAD_CAL
, TAB.SEQUENCE_NUM_ENROL_LOAD_CAL
, TAB.CAL_TYPE_OFFER_LOAD_CAL
, TAB.SEQUENCE_NUM_OFFER_LOAD_CAL
, TAB.CURRICULUM_ID
, TAB.OVERRIDE_ENROLLMENT_MAX
, TAB.RPT_FMLY_ID
, TAB.REPEAT_CODE
, TAB.UNIT_TYPE_ID
, TAB.LEVEL_CODE
, TAB.ADVANCE_MAXIMUM
, TAB.APPROVAL_DATE
, TAB.BILLING_CREDIT_POINTS
, TAB.CONTINUING_EDUCATION_UNITS
, TAB.ENROLLMENT_EXPECTED
, TAB.ENROLLMENT_MAXIMUM
, TAB.ENROLLMENT_MINIMUM
, TAB.FEDERAL_FINANCIAL_AID
, TAB.INSTITUTIONAL_FINANCIAL_AID
, TAB.LAB_CREDIT_POINTS
, TAB.LECTURE_CREDIT_POINTS
, TAB.MAX_REPEATS_FOR_CREDIT
, TAB.MAX_REPEATS_FOR_FUNDING
, TAB.MAX_REPEAT_CREDIT_POINTS
, TAB.CLOCK_HOURS
, TAB.OTHER_CREDIT_POINTS
, TAB.SAME_TEACHING_PERIOD
, TAB.SAME_TEACH_PERIOD_REPEATS
, TAB.SAME_TEACH_PERIOD_REPEATS_CP
, TAB.STATE_FINANCIAL_AID
, TAB.WORK_LOAD_CP_LAB
, TAB.WORK_LOAD_CP_LECTURE
, TAB.SUBTITLE_ID
, TAB.SUBTITLE
, TAB.SUBTITLE_MODIFIABLE_FLAG
, TAB.SPECIAL_PERMISSION_IND
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
, TAB.CLAIMABLE_HOURS
, TAB.AUDITABLE_IND AUDITABLE_IND
, TAB.AUDIT_PERMISSION_IND AUDIT_PERMISSION_IND
, TAB.MAX_AUDITORS_ALLOWED MAX_AUDITORS_ALLOWED
, TAB.OVRD_WKLD_VAL_FLAG
, TAB.WORKLOAD_VAL_CODE
FROM IGS_PS_UNIT_VER_HIST_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns