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: APPS.IGSBV_HIGH_ED_PROG_VERSIONS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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