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: IGS_PS_UNIT_VER_HIST_V

Product:	IGS - Student System (Obsolete)
Description:	Merges the Unit Version History details with the Current Unit Version Details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
UNIT_CD
VERSION_NUMBER
HIST_START_DT
HIST_END_DT
HIST_WHO
START_DT
REVIEW_DT
EXPIRY_DT
END_DT
UNIT_STATUS
TITLE
SHORT_TITLE
TITLE_OVERRIDE_IND
ABBREVIATION
UNIT_LEVEL
UL_DESCRIPTION
CREDIT_POINT_DESCRIPTOR
ENROLLED_CREDIT_POINTS
POINTS_OVERRIDE_IND
SUPP_EXAM_PERMITTED_IND
COORD_PERSON_ID
OWNER_ORG_UNIT_CD
OWNER_OU_START_DT
OU_DESCRIPTION
AWARD_COURSE_ONLY_IND
RESEARCH_UNIT_IND
SUB_UNIT_ALLOWED_IND
SUP_UNIT_ALLOWED_IND
INDUSTRIAL_IND
PRACTICAL_IND
REPEATABLE_IND
ASSESSABLE_IND
ACHIEVABLE_CREDIT_POINTS
POINTS_INCREMENT
POINTS_MIN
POINTS_MAX
UNIT_INT_COURSE_LEVEL_CD
UICL_DESCRIPTION
WORK_LOAD_OTHER
CONTACT_HRS_LECTURE
CONTACT_HRS_LAB
CONTACT_HRS_OTHER
BILLING_HRS
NON_SCHD_REQUIRED_HRS
FIN_AID_CP
FIN_AID_HRS
EXCLUDE_FROM_MAX_CP_LIMIT
RECORD_EXCLUSION_FLAG
SS_DISPLAY_IND
CAL_TYPE_ENROL_LOAD_CAL
SEQUENCE_NUM_ENROL_LOAD_CAL
CAL_TYPE_OFFER_LOAD_CAL
SEQUENCE_NUM_OFFER_LOAD_CAL
CURRICULUM_ID
OVERRIDE_ENROLLMENT_MAX
RPT_FMLY_ID
UNIT_TYPE_ID
REPEAT_CODE
LEVEL_CODE
ADVANCE_MAXIMUM
APPROVAL_DATE
BILLING_CREDIT_POINTS
CONTINUING_EDUCATION_UNITS
ENROLLMENT_EXPECTED
ENROLLMENT_MAXIMUM
ENROLLMENT_MINIMUM
FEDERAL_FINANCIAL_AID
INSTITUTIONAL_FINANCIAL_AID
LAB_CREDIT_POINTS
LECTURE_CREDIT_POINTS
MAX_REPEATS_FOR_CREDIT
MAX_REENROLL_FOR_CREDIT
MAX_REPEATS_FOR_FUNDING
MAX_REPEAT_CREDIT_POINTS
CLOCK_HOURS
OTHER_CREDIT_POINTS
SAME_TEACHING_PERIOD
SAME_TEACH_PERIOD_REPEATS
SAME_TEACH_PERIOD_REPEATS_CP
STATE_FINANCIAL_AID
WORK_LOAD_CP_LAB
WORK_LOAD_CP_LECTURE
SUBTITLE_ID
SUBTITLE
SUBTITLE_MODIFIABLE_FLAG
SPECIAL_PERMISSION_IND
IVR_ENROL_IND
SS_ENROL_IND
CLAIMABLE_HOURS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
AUDITABLE_IND
AUDIT_PERMISSION_IND
MAX_AUDITORS_ALLOWED
OVRD_WKLD_VAL_FLAG
WORKLOAD_VAL_CODE