VIEW: APPS.IGS_PS_VER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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