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_VER_HIST_V

Product:	IGS - Student System (Obsolete)
Description:	This view is used to merge program version history with the current program 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 CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, CVH1.HIST_START_DT
, CVH1.HIST_END_DT
, CVH1.HIST_WHO
, NVL( CVH1.START_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'START_DT'
, CVH1.HIST_END_DT))
, CV1.START_DT))
, NVL( CVH1.REVIEW_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'REVIEW_DT'
, CVH1.HIST_END_DT))
, CV1.REVIEW_DT))
, NVL( CVH1.EXPIRY_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'EXPIRY_DT'
, CVH1.HIST_END_DT))
, CV1.EXPIRY_DT))
, NVL( CVH1.END_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'END_DT'
, CVH1.HIST_END_DT))
, CV1.END_DT))
, NVL( CVH1.COURSE_STATUS
, NVL( SUBSTR(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'COURSE_STATUS'
, CVH1.HIST_END_DT)
, 1
, 10)
, CV1.COURSE_STATUS))
, NVL( CVH1.TITLE
, NVL( SUBSTR(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'TITLE'
, CVH1.HIST_END_DT)
, 1
, 90)
, CV1.TITLE))
, NVL( CVH1.SHORT_TITLE
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'SHORT_TITLE'
, CVH1.HIST_END_DT)
, 1
, 40)
, CV1.SHORT_TITLE))
, NVL( CVH1.ABBREVIATION
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'ABBREVIATION'
, CVH1.HIST_END_DT)
, 1
, 20)
, CV1.ABBREVIATION))
, NVL( CVH1.SUPP_EXAM_PERMITTED_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'SUPP_EXAM_PERMITTED_IND'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.SUPP_EXAM_PERMITTED_IND))
, NVL( CVH1.GENERIC_COURSE_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'GENERIC_COURSE_IND'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.GENERIC_COURSE_IND))
, NVL( CVH1.GRADUATE_STUDENTS_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'GRADUATE_STUDENTS_IND'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.GRADUATE_STUDENTS_IND))
, NVL( CVH1.COUNT_INTRMSN_IN_TIME_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'COUNT_INTRMSN_IN_TIME_IND'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.COUNT_INTRMSN_IN_TIME_IND))
, NVL( CVH1.INTRMSN_ALLOWED_IND
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'INTRMSN_ALLOWED_IND'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.INTRMSN_ALLOWED_IND))
, NVL( CVH1.COURSE_TYPE
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'COURSE_TYPE'
, CVH1.HIST_END_DT)
, 1
, 10)
, CV1.COURSE_TYPE))
, NVL( CVH1.CT_DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'CT_DESCRIPTION'
, CVH1.HIST_END_DT)
, 1
, 60)
, CT1.DESCRIPTION))
, NVL( CVH1.RESPONSIBLE_ORG_UNIT_CD
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'RESPONSIBLE_ORG_UNIT_CD'
, CVH1.HIST_END_DT)
, 1
, 10)
, CV1.RESPONSIBLE_ORG_UNIT_CD))
, NVL( CVH1.RESPONSIBLE_OU_START_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'RESPONSIBLE_OU_START_DT'
, CVH1.HIST_END_DT))
, CV1.RESPONSIBLE_OU_START_DT))
, NVL( CVH1.OU_DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'OU_DESCRIPTION'
, CVH1.HIST_END_DT)
, 1
, 60)
, OU1.PARTY_NAME))
, NVL( CVH1.GOVT_SPECIAL_COURSE_TYPE
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'GOVT_SPECIAL_COURSE_TYPE'
, CVH1.HIST_END_DT)
, 1
, 2)
, CV1.GOVT_SPECIAL_COURSE_TYPE))
, NVL( CVH1.GSCT_DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'GSCT_DESCRIPTION'
, CVH1.HIST_END_DT)
, 1
, 60)
, GSCT1.DESCRIPTION))
, NVL( CVH1.QUALIFICATION_RECENCY
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'QUALIFICATION_RECENCY'
, CVH1.HIST_END_DT))
, CV1.QUALIFICATION_RECENCY))
, NVL( CVH1.EXTERNAL_ADV_STND_LIMIT
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'EXTERNAL_ADV_STND_LIMIT'
, CVH1.HIST_END_DT))
, CV1.EXTERNAL_ADV_STND_LIMIT))
, NVL( CVH1.INTERNAL_ADV_STND_LIMIT
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'INTERNAL_ADV_STND_LIMIT'
, CVH1.HIST_END_DT))
, CV1.EXTERNAL_ADV_STND_LIMIT))
, NVL( CVH1.CONTACT_HOURS
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'CONTACT_HOURS'
, CVH1.HIST_END_DT))
, CV1.CONTACT_HOURS))
, NVL( CVH1.CREDIT_POINTS_REQUIRED
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'CREDIT_POINTS_REQUIRED'
, CVH1.HIST_END_DT))
, CV1.CREDIT_POINTS_REQUIRED))
, NVL( CVH1.GOVT_COURSE_LOAD
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'GOVT_COURSE_LOAD'
, CVH1.HIST_END_DT))
, CV1.GOVT_COURSE_LOAD))
, NVL( CVH1.STD_ANNUAL_LOAD
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'STD_ANNUAL_LOAD'
, CVH1.HIST_END_DT))
, CV1.STD_ANNUAL_LOAD))
, NVL( CVH1.ANNUAL_INSTRUCTION_TIME
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'ANNUAL_INSTRUCTION_TIME'
, CVH1.HIST_END_DT))
, CV1.ANNUAL_INSTRUCTION_TIME))
, NVL( CVH1.COURSE_TOTAL_EFTSU
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'COURSE_TOTAL_EFTSU'
, CVH1.HIST_END_DT))
, CV1.COURSE_TOTAL_EFTSU))
, NVL( CVH1.STD_FT_COMPLETION_TIME
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'STD_FT_COMPLETION_TIME'
, CVH1.HIST_END_DT))
, CV1.STD_FT_COMPLETION_TIME))
, NVL( CVH1.STD_PT_COMPLETION_TIME
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'STD_PT_COMPLETION_TIME'
, CVH1.HIST_END_DT))
, CV1.STD_PT_COMPLETION_TIME))
, NVL( CVH1.MAX_INTRMSN_DURATION
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'MAX_INTRMSN_DURATION'
, CVH1.HIST_END_DT))
, CV1.MAX_INTRMSN_DURATION))
, NVL( CVH1.NUM_OF_UNITS_BEFORE_INTRMSN
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'NUM_OF_UNITS_BEFORE_INTRMSN'
, CVH1.HIST_END_DT))
, CV1.NUM_OF_UNITS_BEFORE_INTRMSN))
, NVL( CVH1.MIN_SBMSN_PERCENTAGE
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'MIN_SBMSN_PERCENTAGE'
, CVH1.HIST_END_DT))
, CV1.MIN_SBMSN_PERCENTAGE))
, NVL( CVH1.MIN_CP_PER_CALENDAR
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'MIN_CP_PER_CALENDAR'
, CVH1.HIST_END_DT))
, CV1.MIN_CP_PER_CALENDAR))
, NVL( CVH1.APPROVAL_DATE
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'APPROVAL_DATE'
, CVH1.HIST_END_DT))
, CV1.APPROVAL_DATE))
, NVL( CVH1.EXTERNAL_APPROVAL_DATE
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'EXTERNAL_APPROVAL_DATE'
, CVH1.HIST_END_DT))
, CV1.EXTERNAL_APPROVAL_DATE))
, NVL( CVH1.FEDERAL_FINANCIAL_AID
, NVL(SUBSTR(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'FEDERAL_FINANCIAL_AID'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.FEDERAL_FINANCIAL_AID))
, NVL( CVH1.INSTITUTIONAL_FINANCIAL_AID
, NVL(SUBSTR(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'INSTITUTIONAL_FINANCIAL_AID'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.INSTITUTIONAL_FINANCIAL_AID))
, NVL( CVH1.MAX_CP_PER_TEACHING_PERIOD
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'MAX_CP_PER_TEACHING_PERIOD'
, CVH1.HIST_END_DT))
, CV1.MAX_CP_PER_TEACHING_PERIOD))
, NVL( CVH1.RESIDENCY_CP_REQUIRED
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'RESIDENCY_CP_REQUIRED'
, CVH1.HIST_END_DT))
, CV1.RESIDENCY_CP_REQUIRED))
, NVL( CVH1.STATE_FINANCIAL_AID
, NVL(SUBSTR(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'STATE_FINAINCIAL_AID'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.STATE_FINANCIAL_AID))
, NVL( CVH1.PRIMARY_PROGRAM_RANK
, NVL(SUBSTR(IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'PRIMARY_PROGRAM_RANK'
, CVH1.HIST_END_DT)
, 1
, 1)
, CV1.PRIMARY_PROGRAM_RANK))
, CVH1.CREATED_BY
, CVH1.CREATION_DATE
, CVH1.LAST_UPDATED_BY
, CVH1.LAST_UPDATE_DATE
, CVH1.LAST_UPDATE_LOGIN
, NVL( CVH1.MAX_WLST_PER_STUD
, NVL( IGS_GE_NUMBER.TO_NUM( IGS_AU_GEN_002.AUDP_GET_CVH_COL( CVH1.COURSE_CD
, CVH1.VERSION_NUMBER
, 'MAX_WLST_PER_STUD'
, CVH1.HIST_END_DT))
, CV1.MAX_WLST_PER_STUD)) FROM IGS_PS_VER_HIST CVH1
, IGS_PS_VER CV1
, IGS_PS_TYPE CT1
, IGS_PS_GOVT_SPL_TYPE GSCT1
, IGS_OR_INST_ORG_BASE_V OU1
WHERE CV1.COURSE_CD = CVH1.COURSE_CD
AND CV1.VERSION_NUMBER = CVH1.VERSION_NUMBER
AND CV1.COURSE_TYPE = CT1.COURSE_TYPE
AND CV1.GOVT_SPECIAL_COURSE_TYPE = GSCT1.GOVT_SPECIAL_COURSE_TYPE
AND CV1.RESPONSIBLE_ORG_UNIT_CD = OU1.PARTY_NUMBER
AND CV1.RESPONSIBLE_OU_START_DT = OU1.START_DT UNION ALL SELECT CV2.COURSE_CD
, CV2.VERSION_NUMBER
, NVL( MAX(CVH2.HIST_END_DT)
, CV2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, CV2.LAST_UPDATED_BY
, CV2.START_DT
, CV2.REVIEW_DT
, CV2.EXPIRY_DT
, CV2.END_DT
, CV2.COURSE_STATUS
, CV2.TITLE
, CV2.SHORT_TITLE
, CV2.ABBREVIATION
, CV2.SUPP_EXAM_PERMITTED_IND
, CV2.GENERIC_COURSE_IND
, CV2.GRADUATE_STUDENTS_IND
, CV2.COUNT_INTRMSN_IN_TIME_IND
, CV2.INTRMSN_ALLOWED_IND
, CV2.COURSE_TYPE
, CT2.DESCRIPTION
, CV2.RESPONSIBLE_ORG_UNIT_CD
, CV2.RESPONSIBLE_OU_START_DT
, OU2.PARTY_NAME DESCRIPTION
, CV2.GOVT_SPECIAL_COURSE_TYPE
, GSCT2.DESCRIPTION
, CV2.QUALIFICATION_RECENCY
, CV2.EXTERNAL_ADV_STND_LIMIT
, CV2.INTERNAL_ADV_STND_LIMIT
, CV2.CONTACT_HOURS
, CV2.CREDIT_POINTS_REQUIRED
, CV2.GOVT_COURSE_LOAD
, CV2.STD_ANNUAL_LOAD
, CV2.ANNUAL_INSTRUCTION_TIME
, CV2.COURSE_TOTAL_EFTSU
, CV2.STD_FT_COMPLETION_TIME
, CV2.STD_PT_COMPLETION_TIME
, CV2.MAX_INTRMSN_DURATION
, CV2.NUM_OF_UNITS_BEFORE_INTRMSN
, CV2.MIN_SBMSN_PERCENTAGE
, CV2.MIN_CP_PER_CALENDAR
, CV2.APPROVAL_DATE
, CV2.EXTERNAL_APPROVAL_DATE
, CV2.FEDERAL_FINANCIAL_AID
, CV2.INSTITUTIONAL_FINANCIAL_AID
, CV2.MAX_CP_PER_TEACHING_PERIOD
, CV2.RESIDENCY_CP_REQUIRED
, CV2.STATE_FINANCIAL_AID
, CV2.PRIMARY_PROGRAM_RANK
, CV2.CREATED_BY
, CV2.CREATION_DATE
, CV2.LAST_UPDATED_BY
, CV2.LAST_UPDATE_DATE
, CV2.LAST_UPDATE_LOGIN
, CV2.MAX_WLST_PER_STUD FROM IGS_PS_VER_HIST CVH2
, IGS_PS_VER CV2
, IGS_PS_TYPE CT2
, IGS_PS_GOVT_SPL_TYPE GSCT2
, IGS_OR_INST_ORG_BASE_V OU2 WHERE CV2.COURSE_CD = CVH2.COURSE_CD (+)
AND CV2.VERSION_NUMBER = CVH2.VERSION_NUMBER (+)
AND CV2.COURSE_TYPE = CT2.COURSE_TYPE
AND CV2.GOVT_SPECIAL_COURSE_TYPE = GSCT2.GOVT_SPECIAL_COURSE_TYPE
AND CV2.RESPONSIBLE_ORG_UNIT_CD = OU2.PARTY_NUMBER
AND CV2.RESPONSIBLE_OU_START_DT = OU2.START_DT GROUP BY CV2.COURSE_CD
, CV2.VERSION_NUMBER
, CV2.START_DT
, CV2.REVIEW_DT
, CV2.EXPIRY_DT
, CV2.END_DT
, CV2.COURSE_STATUS
, CV2.TITLE
, CV2.SHORT_TITLE
, CV2.ABBREVIATION
, CV2.SUPP_EXAM_PERMITTED_IND
, CV2.GENERIC_COURSE_IND
, CV2.GRADUATE_STUDENTS_IND
, CV2.COUNT_INTRMSN_IN_TIME_IND
, CV2.INTRMSN_ALLOWED_IND
, CV2.COURSE_TYPE
, CT2.DESCRIPTION
, CV2.RESPONSIBLE_ORG_UNIT_CD
, CV2.RESPONSIBLE_OU_START_DT
, OU2.PARTY_NAME
, CV2.GOVT_SPECIAL_COURSE_TYPE
, GSCT2.DESCRIPTION
, CV2.QUALIFICATION_RECENCY
, CV2.EXTERNAL_ADV_STND_LIMIT
, CV2.INTERNAL_ADV_STND_LIMIT
, CV2.CONTACT_HOURS
, CV2.CREDIT_POINTS_REQUIRED
, CV2.GOVT_COURSE_LOAD
, CV2.STD_ANNUAL_LOAD
, CV2.ANNUAL_INSTRUCTION_TIME
, CV2.COURSE_TOTAL_EFTSU
, CV2.STD_FT_COMPLETION_TIME
, CV2.STD_PT_COMPLETION_TIME
, CV2.MAX_INTRMSN_DURATION
, CV2.NUM_OF_UNITS_BEFORE_INTRMSN
, CV2.MIN_SBMSN_PERCENTAGE
, CV2.MIN_CP_PER_CALENDAR
, CV2.APPROVAL_DATE
, CV2.EXTERNAL_APPROVAL_DATE
, CV2.FEDERAL_FINANCIAL_AID
, CV2.INSTITUTIONAL_FINANCIAL_AID
, CV2.MAX_CP_PER_TEACHING_PERIOD
, CV2.RESIDENCY_CP_REQUIRED
, CV2.STATE_FINANCIAL_AID
, CV2.PRIMARY_PROGRAM_RANK
, CV2.CREATED_BY
, CV2.CREATION_DATE
, CV2.LAST_UPDATED_BY
, CV2.LAST_UPDATE_DATE
, CV2.LAST_UPDATE_LOGIN
, CV2.MAX_WLST_PER_STUD

Columns

Name
COURSE_CD
VERSION_NUMBER
HIST_START_DT
HIST_END_DT
HIST_WHO
START_DT
REVIEW_DT
EXPIRY_DT
END_DT
COURSE_STATUS
TITLE
SHORT_TITLE
ABBREVIATION
SUPP_EXAM_PERMITTED_IND
GENERIC_COURSE_IND
GRADUATE_STUDENTS_IND
COUNT_INTRMSN_IN_TIME_IND
INTRMSN_ALLOWED_IND
COURSE_TYPE
CT_DESCRIPTION
RESPONSIBLE_ORG_UNIT_CD
RESPONSIBLE_OU_START_DT
OU_DESCRIPTION
GOVT_SPECIAL_COURSE_TYPE
GSCT_DESCRIPTION
QUALIFICATION_RECENCY
EXTERNAL_ADV_STND_LIMIT
INTERNAL_ADV_STND_LIMIT
CONTACT_HOURS
CREDIT_POINTS_REQUIRED
GOVT_COURSE_LOAD
STD_ANNUAL_LOAD
ANNUAL_INSTRUCTION_TIME
COURSE_TOTAL_EFTSU
STD_FT_COMPLETION_TIME
STD_PT_COMPLETION_TIME
MAX_INTRMSN_DURATION
NUM_OF_UNITS_BEFORE_INTRMSN
MIN_SBMSN_PERCENTAGE
MIN_CP_PER_CALENDAR
APPROVAL_DATE
EXTERNAL_APPROVAL_DATE
FEDERAL_FINANCIAL_AID
INSTITUTIONAL_FINANCIAL_AID
MAX_CP_PER_TEACHING_PERIOD
RESIDENCY_CP_REQUIRED
STATE_FINANCIAL_AID
PRIMARY_PROGRAM_RANK
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
MAX_WLST_PER_STUD