[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity describes Program Versions including information about the intermission, financial aid, supplemental exams , minimum and maximum credit points. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT COURSE_CD PROGRAM_CODE
, VERSION_NUMBER
, START_DT START_DATE
, REVIEW_DT REVIEW_DATE
, EXPIRY_DT EXPIRY_DATE
, END_DT END_DATE
, COURSE_STATUS PROGRAM_STATUS
, TITLE
, SHORT_TITLE
, ABBREVIATION
, SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERM_INDICATOR
, GENERIC_COURSE_IND GENERIC_PROGRAM_INDICATOR
, GRADUATE_STUDENTS_IND GRADUATE_STUDENTS_INDICATOR
, COUNT_INTRMSN_IN_TIME_IND COUNT_INTERMISSION_INDICATOR
, INTRMSN_ALLOWED_IND INTERMISSION_ALLOWED_INDICATOR
, COURSE_TYPE PROGRAM_TYPE
, RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE
, RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE
, GOVT_SPECIAL_COURSE_TYPE GOVT_SPECIAL_PROGRAM_TYPE
, QUALIFICATION_RECENCY
, EXTERNAL_ADV_STND_LIMIT
, INTERNAL_ADV_STND_LIMIT
, CONTACT_HOURS
, CREDIT_POINTS_REQUIRED
, GOVT_COURSE_LOAD GOVT_PROGRAM_LOAD
, STD_ANNUAL_LOAD
, ANNUAL_INSTRUCTION_TIME
, COURSE_TOTAL_EFTSU PROGRAM_TOTAL_EFTSU
, MAX_INTRMSN_DURATION MAX_INTERMISSION_DURATION
, NUM_OF_UNITS_BEFORE_INTRMSN NUM_OF_UNITS_BEFORE_INTRMSN
, MIN_SBMSN_PERCENTAGE MIN_SUBMISSION_PERCENTAGE
, MAX_CP_PER_TEACHING_PERIOD MAX_CP_PER_TEACH_PERIOD
, APPROVAL_DATE
, EXTERNAL_APPROVAL_DATE EXTERNAL_APPROVAL_DATE
, RESIDENCY_CP_REQUIRED RESIDENCY_CP_REQUIRED
, STATE_FINANCIAL_AID
, FEDERAL_FINANCIAL_AID
, INSTITUTIONAL_FINANCIAL_AID
, MIN_CP_PER_CALENDAR MINIMUM_CP_PER_CALENDAR
, REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, PRIMARY_PROGRAM_RANK
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, MAX_WLST_PER_STUD
FROM IGS_PS_VER_ALL WITH READ ONLY