[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 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