Results for “program_status_desc”
5 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view IGSFV_HIGH_ED_PROG_VERSIONS belongs to the IGS — Student System (Obsolete) product family in Oracle E-Business Suite. It exposes higher-education Program Version records — the versioned definitions of academic programs offered by an institution — together with their associated administrative attributes. These attributes include intermission (leave-of-absence) rules, financial-aid eligibility, supplemental examination permissions, and minimum and maximum credit-point thresholds required for program completion.
The view is a reporting and integration artifact. Its column aliases are deliberately presentation-oriented, mapping legacy IGS base columns such as COURSE_CD, COURSE_STATUS, and COURSE_TYPE to friendlier names such as PROGRAM_CODE, PROGRAM_STATUS, and PROGRAM_TYPE. A user searching for program_status will find that term surfaced here as the PROGRAM_STATUS column, aliased from PSV.COURSE_STATUS, and supplemented by a decoded description column, PROGRAM_STATUS_DESC, sourced from the lookup table aliased PSS.
The ETRM metadata records this object as not implemented in this database for the queried environment, and lists no referenced base objects. It is therefore best treated as a legacy, product-specific view whose availability depends on whether the IGS Student System schema is installed and licensed.
Underlying Base Objects
The documented ETRM record states that no base objects are documented for this view, and that it is not implemented in the current database. The view text, however, reveals the driving table through its column prefix PSV, which corresponds to the IGS Program Version entity (the IGS_PS_PRG_VER family). The view joins this driving entity to several supporting and lookup structures:
- PSV — the primary program-version record supplying program code, version number, dates, status, credit points, intermission rules, and financial-aid flags.
- PSS — a status lookup supplying
PROGRAM_STATUS_DESC. - PST — a type lookup supplying
PROGRAM_TYPE_DESC. - HP — a party/party-name structure supplying
RESP_ORG_UNIT_DESCfor the responsible organisational unit. - PSG — a government special-program-type lookup supplying
GOVT_SP_PROG_TYPE_DESC.
The view also embeds a descriptive flexfield reference, '_DF:IGS:IGS_PS_PRG_VER_FLEX:PSV', indicating that program-version DFF segments are exposed inline alongside the standard columns.
Key Columns
The columns most relevant to reporting and to the program_status search term include:
- PROGRAM_CODE, VERSION_NUMBER — identify the program and its version.
- PROGRAM_STATUS (
COURSE_STATUS) and PROGRAM_STATUS_DESC — the operational status of the version and its decoded meaning; the primary answer to a program-status query. - START_DATE, REVIEW_DATE, EXPIRY_DATE, END_DATE — the version lifecycle dates.
- TITLE, SHORT_TITLE, ABBREVIATION — program naming attributes.
- SUPP_EXAM_PERM_INDICATOR, GENERIC_PROGRAM_INDICATOR, GRADUATE_STUDENTS_INDICATOR — permission and classification flags.
- COUNT_INTERMISSION_INDICATOR, INTERMISSION_ALLOWED_INDICATOR, MAX_INTERMISSION_DURATION, NUM_OF_UNITS_BEFORE_INTRMSN — intermission rules.
- CREDIT_POINTS_REQUIRED, MINIMUM_CP_PER_CALENDAR, MAX_CP_PER_TEACH_PERIOD, RESIDENCY_CP_REQUIRED — credit-point thresholds and limits.
- STATE_FINANCIAL_AID, FEDERAL_FINANCIAL_AID, INSTITUTIONAL_FINANCIAL_AID — financial-aid eligibility flags.
- PROGRAM_TYPE / PROGRAM_TYPE_DESC, RESP_ORG_UNIT_CODE / RESP_ORG_UNIT_DESC — classification and ownership.
Common Use Cases and Queries
Typical usage centres on status reporting, curriculum administration, and integration extracts. A straightforward status query would be:
SELECT program_code, version_number, program_status, program_status_desc FROM igsfv_high_ed_prog_versions WHERE program_status = :p_status;- Filtering active versions by date:
... WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE); - Financial-aid reporting:
... WHERE federal_financial_aid = 'Y'; - Intermission-rule audits:
... WHERE intermission_allowed_indicator = 'Y';
Because the metadata flags the view as obsolete and not implemented, developers should verify its presence in ALL_VIEWS before relying on it, and prefer supported replacements where the IGS product has been superseded.
-
This entity describes Program Versions including information about the intermission, financial aid, supplemental exams , minimum and maximum credit points.
APPS.IGSFV_HIGH_ED_PROG_VERSIONS·↳ HZ_PARTIES·↳ IGS_FI_ACC_ALL·↳ IGS_PS_GOVT_SPL_TYPE·Explore IGS module →
-
This entity describes Program Versions including information about the intermission, financial aid, supplemental exams , minimum and maximum credit points.
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.