View: IGS_PS_VER_V

View Text

SELECT PV.ROWID ROW_ID
, PV.COURSE_CD COURSE_CD
, PV.VERSION_NUMBER VERSION_NUMBER
, PV.START_DT START_DT
, PV.REVIEW_DT REVIEW_DT
, PV.EXPIRY_DT EXPIRY_DT
, PV.END_DT END_DT
, PV.COURSE_STATUS COURSE_STATUS
, PV.TITLE TITLE
, PV.SHORT_TITLE SHORT_TITLE
, PV.ABBREVIATION ABBREVIATION
, PV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERMITTED_IND
, PV.GENERIC_COURSE_IND GENERIC_COURSE_IND
, PV.GRADUATE_STUDENTS_IND GRADUATE_STUDENTS_IND
, PV.COUNT_INTRMSN_IN_TIME_IND COUNT_INTRMSN_IN_TIME_IND
, PV.INTRMSN_ALLOWED_IND INTRMSN_ALLOWED_IND
, PV.COURSE_TYPE COURSE_TYPE
, PV.RESPONSIBLE_ORG_UNIT_CD RESPONSIBLE_ORG_UNIT_CD
, PV.RESPONSIBLE_OU_START_DT RESPONSIBLE_OU_START_DT
, PV.GOVT_SPECIAL_COURSE_TYPE GOVT_SPECIAL_COURSE_TYPE
, PV.QUALIFICATION_RECENCY QUALIFICATION_RECENCY
, PV.EXTERNAL_ADV_STND_LIMIT EXTERNAL_ADV_STND_LIMIT
, PV.INTERNAL_ADV_STND_LIMIT INTERNAL_ADV_STND_LIMIT
, PV.CONTACT_HOURS CONTACT_HOURS
, PV.CREDIT_POINTS_REQUIRED CREDIT_POINTS_REQUIRED
, PV.GOVT_COURSE_LOAD GOVT_COURSE_LOAD
, PV.STD_ANNUAL_LOAD STD_ANNUAL_LOAD
, PV.ANNUAL_INSTRUCTION_TIME ANNUAL_INSTRUCTION_TIME
, PV.COURSE_TOTAL_EFTSU COURSE_TOTAL_EFTSU
, PV.STD_FT_COMPLETION_TIME STD_FT_COMPLETION_TIME
, PV.STD_PT_COMPLETION_TIME STD_PT_COMPLETION_TIME
, PV.MAX_INTRMSN_DURATION MAX_INTRMSN_DURATION
, PV.NUM_OF_UNITS_BEFORE_INTRMSN NUM_OF_UNITS_BEFORE_INTRMSN
, PV.MIN_SBMSN_PERCENTAGE MIN_SBMSN_PERCENTAGE
, PV.MAX_CP_PER_TEACHING_PERIOD MAX_CP_PER_TEACHING_PERIOD
, PV.MIN_CP_PER_CALENDAR MIN_CP_PER_CALENDAR
, PV.APPROVAL_DATE APPROVAL_DATE
, PV.EXTERNAL_APPROVAL_DATE EXTERNAL_APPROVAL_DATE
, PV.RESIDENCY_CP_REQUIRED RESIDENCY_CP_REQUIRED
, PV.STATE_FINANCIAL_AID STATE_FINANCIAL_AID
, PV.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID
, PV.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID
, PV.REV_ACCOUNT_CD
, PV.PRIMARY_PROGRAM_RANK PRIMARY_PROGRAM_RANK
, PV.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PV.ATTRIBUTE2 ATTRIBUTE2
, PV.ATTRIBUTE1 ATTRIBUTE1
, PV.ATTRIBUTE3 ATTRIBUTE3
, PV.ATTRIBUTE4 ATTRIBUTE4
, PV.ATTRIBUTE5 ATTRIBUTE5
, PV.ATTRIBUTE6 ATTRIBUTE6
, PV.ATTRIBUTE7 ATTRIBUTE7
, PV.ATTRIBUTE8 ATTRIBUTE8
, PV.ATTRIBUTE9 ATTRIBUTE9
, PV.ATTRIBUTE10 ATTRIBUTE10
, PV.ATTRIBUTE11 ATTRIBUTE11
, PV.ATTRIBUTE12 ATTRIBUTE12
, PV.ATTRIBUTE13 ATTRIBUTE13
, PV.ATTRIBUTE14 ATTRIBUTE14
, PV.ATTRIBUTE15 ATTRIBUTE15
, PV.ATTRIBUTE16 ATTRIBUTE16
, PV.ATTRIBUTE17 ATTRIBUTE17
, PV.ATTRIBUTE18 ATTRIBUTE18
, PV.ATTRIBUTE19 ATTRIBUTE19
, PV.ATTRIBUTE20 ATTRIBUTE20
, PV.CREATED_BY CREATED_BY
, PV.CREATION_DATE CREATION_DATE
, PV.LAST_UPDATED_BY LAST_UPDATED_BY
, PV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PV.MAX_WLST_PER_STUD MAX_WLST_PER_STUD
FROM IGS_PS_VER PV

Columns