VIEW: APPS.IGSFV_HIGH_ED_PROG_VERSIONS

Source

View Text - Preformatted

SELECT PSV.COURSE_CD PROGRAM_CODE, PSV.VERSION_NUMBER, PSV.START_DT START_DATE, PSV.REVIEW_DT REVIEW_DATE, PSV.EXPIRY_DT EXPIRY_DATE, PSV.END_DT END_DATE, PSV.COURSE_STATUS PROGRAM_STATUS, PSV.TITLE, PSV.SHORT_TITLE, PSV.ABBREVIATION, PSV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERM_INDICATOR, PSV.GENERIC_COURSE_IND GENERIC_PROGRAM_INDICATOR, PSV.GRADUATE_STUDENTS_IND GRADUATE_STUDENTS_INDICATOR, PSV.COUNT_INTRMSN_IN_TIME_IND COUNT_INTERMISSION_INDICATOR, PSV.INTRMSN_ALLOWED_IND INTERMISSION_ALLOWED_INDICATOR, PSV.COURSE_TYPE PROGRAM_TYPE, PSV.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE, PSV.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE, PSV.GOVT_SPECIAL_COURSE_TYPE GOVT_SPECIAL_PROGRAM_TYPE, PSV.QUALIFICATION_RECENCY, PSV.EXTERNAL_ADV_STND_LIMIT, PSV.INTERNAL_ADV_STND_LIMIT, PSV.CONTACT_HOURS, PSV.CREDIT_POINTS_REQUIRED, PSV.GOVT_COURSE_LOAD GOVT_PROGRAM_LOAD, PSV.STD_ANNUAL_LOAD, PSV.ANNUAL_INSTRUCTION_TIME, PSV.COURSE_TOTAL_EFTSU PROGRAM_TOTAL_EFTSU, PSV.MAX_INTRMSN_DURATION MAX_INTERMISSION_DURATION, PSV.NUM_OF_UNITS_BEFORE_INTRMSN NUM_OF_UNITS_BEFORE_INTRMSN, PSV.MIN_SBMSN_PERCENTAGE MIN_SUBMISSION_PERCENTAGE, PSV.MAX_CP_PER_TEACHING_PERIOD MAX_CP_PER_TEACH_PERIOD, PSV.APPROVAL_DATE, PSV.EXTERNAL_APPROVAL_DATE EXTERNAL_APPROVAL_DATE, PSV.RESIDENCY_CP_REQUIRED RESIDENCY_CP_REQUIRED, PSV.STATE_FINANCIAL_AID, PSV.FEDERAL_FINANCIAL_AID, PSV.INSTITUTIONAL_FINANCIAL_AID, '_DF:IGS:IGS_PS_PRG_VER_FLEX:PSV', PSV.MIN_CP_PER_CALENDAR MINIMUM_CP_PER_CALENDAR, PSV.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE, PSV.PRIMARY_PROGRAM_RANK, PSS.DESCRIPTION PROGRAM_STATUS_DESC, PST.DESCRIPTION PROGRAM_TYPE_DESC, HP.PARTY_NAME RESP_ORG_UNIT_DESC, PSG.DESCRIPTION GOVT_SP_PROG_TYPE_DESC, IGA.DESCRIPTION REVENUE_ACCOUNT_DESC, PSV.CREATED_BY, PSV.CREATION_DATE, PSV.LAST_UPDATED_BY, PSV.LAST_UPDATE_DATE, PSV.MAX_WLST_PER_STUD FROM IGS_PS_VER_ALL PSV, IGS_PS_STAT PSS, IGS_PS_TYPE_ALL PST, IGS_PS_GOVT_SPL_TYPE PSG, IGS_FI_ACC_ALL IGA, HZ_PARTIES HP WHERE PSV.COURSE_TYPE = PST.COURSE_TYPE AND PSV.COURSE_STATUS = PSS.COURSE_STATUS AND PSV.GOVT_SPECIAL_COURSE_TYPE = PSG.GOVT_SPECIAL_COURSE_TYPE AND PSV.REV_ACCOUNT_CD = IGA.ACCOUNT_CD (+) AND PSV.RESPONSIBLE_ORG_UNIT_CD = HP.PARTY_NUMBER AND HP.STATUS='A' WITH READ ONLY

View Text - HTML Formatted

SELECT PSV.COURSE_CD PROGRAM_CODE
, PSV.VERSION_NUMBER
, PSV.START_DT START_DATE
, PSV.REVIEW_DT REVIEW_DATE
, PSV.EXPIRY_DT EXPIRY_DATE
, PSV.END_DT END_DATE
, PSV.COURSE_STATUS PROGRAM_STATUS
, PSV.TITLE
, PSV.SHORT_TITLE
, PSV.ABBREVIATION
, PSV.SUPP_EXAM_PERMITTED_IND SUPP_EXAM_PERM_INDICATOR
, PSV.GENERIC_COURSE_IND GENERIC_PROGRAM_INDICATOR
, PSV.GRADUATE_STUDENTS_IND GRADUATE_STUDENTS_INDICATOR
, PSV.COUNT_INTRMSN_IN_TIME_IND COUNT_INTERMISSION_INDICATOR
, PSV.INTRMSN_ALLOWED_IND INTERMISSION_ALLOWED_INDICATOR
, PSV.COURSE_TYPE PROGRAM_TYPE
, PSV.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE
, PSV.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE
, PSV.GOVT_SPECIAL_COURSE_TYPE GOVT_SPECIAL_PROGRAM_TYPE
, PSV.QUALIFICATION_RECENCY
, PSV.EXTERNAL_ADV_STND_LIMIT
, PSV.INTERNAL_ADV_STND_LIMIT
, PSV.CONTACT_HOURS
, PSV.CREDIT_POINTS_REQUIRED
, PSV.GOVT_COURSE_LOAD GOVT_PROGRAM_LOAD
, PSV.STD_ANNUAL_LOAD
, PSV.ANNUAL_INSTRUCTION_TIME
, PSV.COURSE_TOTAL_EFTSU PROGRAM_TOTAL_EFTSU
, PSV.MAX_INTRMSN_DURATION MAX_INTERMISSION_DURATION
, PSV.NUM_OF_UNITS_BEFORE_INTRMSN NUM_OF_UNITS_BEFORE_INTRMSN
, PSV.MIN_SBMSN_PERCENTAGE MIN_SUBMISSION_PERCENTAGE
, PSV.MAX_CP_PER_TEACHING_PERIOD MAX_CP_PER_TEACH_PERIOD
, PSV.APPROVAL_DATE
, PSV.EXTERNAL_APPROVAL_DATE EXTERNAL_APPROVAL_DATE
, PSV.RESIDENCY_CP_REQUIRED RESIDENCY_CP_REQUIRED
, PSV.STATE_FINANCIAL_AID
, PSV.FEDERAL_FINANCIAL_AID
, PSV.INSTITUTIONAL_FINANCIAL_AID
, '_DF:IGS:IGS_PS_PRG_VER_FLEX:PSV'
, PSV.MIN_CP_PER_CALENDAR MINIMUM_CP_PER_CALENDAR
, PSV.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, PSV.PRIMARY_PROGRAM_RANK
, PSS.DESCRIPTION PROGRAM_STATUS_DESC
, PST.DESCRIPTION PROGRAM_TYPE_DESC
, HP.PARTY_NAME RESP_ORG_UNIT_DESC
, PSG.DESCRIPTION GOVT_SP_PROG_TYPE_DESC
, IGA.DESCRIPTION REVENUE_ACCOUNT_DESC
, PSV.CREATED_BY
, PSV.CREATION_DATE
, PSV.LAST_UPDATED_BY
, PSV.LAST_UPDATE_DATE
, PSV.MAX_WLST_PER_STUD
FROM IGS_PS_VER_ALL PSV
, IGS_PS_STAT PSS
, IGS_PS_TYPE_ALL PST
, IGS_PS_GOVT_SPL_TYPE PSG
, IGS_FI_ACC_ALL IGA
, HZ_PARTIES HP
WHERE PSV.COURSE_TYPE = PST.COURSE_TYPE
AND PSV.COURSE_STATUS = PSS.COURSE_STATUS
AND PSV.GOVT_SPECIAL_COURSE_TYPE = PSG.GOVT_SPECIAL_COURSE_TYPE
AND PSV.REV_ACCOUNT_CD = IGA.ACCOUNT_CD (+)
AND PSV.RESPONSIBLE_ORG_UNIT_CD = HP.PARTY_NUMBER
AND HP.STATUS='A' WITH READ ONLY