Results for “igs_ps_ver_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_VER_ALL is the version-level master table within the Oracle E-Business Suite Student System (IGS) product family. It describes the versions of programs offered by an institution, covering both award and non-award programs. In EBS 12.1.1 and 12.2.2, this table functions as the authoritative record of a program (course) version, holding the descriptive, regulatory, financial-aid, and load characteristics that govern how a program version is admitted, delivered, assessed, and reported. The table is owned by the IGS schema and is documented as VALID in ETRM for 12.1.1 with 71 columns.

The heuristic Data Vault classification mined from the foreign-key structure is hub-leaning. This suggests a modeling interpretation in which IGS_PS_VER_ALL behaves as a business hub keyed by the program version, around which numerous satellite-like descriptive attributes and dependent link tables cluster. In practical EBS terms, it is the parent entity from which admissions, enrolment, award, fee, and advanced-standing records branch.

Key Information Stored

The primary key is IGS_PS_VER_PK, defined on the composite business columns COURSE_CD and VERSION_NUMBER. A unique index, IGS_PS_VER_ALL_U1, also covers (COURSE_CD, VERSION_NUMBER), confirming that this pair is the natural business key. COURSE_CD identifies the program and VERSION_NUMBER distinguishes successive versions of that program. There is no separate meaningless surrogate column; the composite key itself is the identifying structure.

The most significant columns include:

• COURSE_CD, VERSION_NUMBER — composite primary key and business key identifying the program version.
• COURSE_STATUS — status of the program version; foreign key to IGS_PS_STAT.
• COURSE_TYPE — classification of the program; foreign key to IGS_PS_TYPE_ALL.
• TITLE, SHORT_TITLE, ABBREVIATION — descriptive naming attributes for the program version.
• START_DT, END_DT, REVIEW_DT, EXPIRY_DT — effective-dating and lifecycle milestones for the version.
• RESPONSIBLE_ORG_UNIT_CD, RESPONSIBLE_OU_START_DT — owning organisational unit and its effective date.
• GOVT_SPECIAL_COURSE_TYPE — government special course classification; foreign key to IGS_PS_GOVT_SPL_TYPE.
• CREDIT_POINTS_REQUIRED, RESIDENCY_CP_REQUIRED — credit-point thresholds for program completion and residency.
• STATE_FINANCIAL_AID, FEDERAL_FINANCIAL_AID, INSTITUTIONAL_FINANCIAL_AID — financial-aid eligibility flags.
• REV_ACCOUNT_CD — revenue account; foreign key to IGS_FI_ACC_ALL.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard EBS descriptive-flexfield columns.
• ORG_ID — multi-org operating unit identifier.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centres on retrieving current program-version information for admissions, enrolment, and reporting. A common pattern joins the version table to its status and type lookups:

• Listing active program versions: SELECT v.course_cd, v.version_number, v.title, v.course_status FROM igs_ps_ver_all v WHERE v.course_status = :status AND SYSDATE BETWEEN v.start_dt AND NVL(v.end_dt, SYSDATE);
• Enriching versions with type and status descriptions by joining IGS_PS_TYPE_ALL on COURSE_TYPE and IGS_PS_STAT on COURSE_STATUS.
• Financial-aid reporting that filters on STATE_FINANCIAL_AID, FEDERAL_FINANCIAL_AID, or INSTITUTIONAL_FINANCIAL_AID.
• Admissions analysis joining IGS_AD_PS_APPL_INST_ALL on COURSE_CD and CRV_VERSION_NUMBER.
• Enrolment counts joining IGS_EN_STDNT_PS_ATT_ALL on COURSE_CD and VERSION_NUMBER.
• Fee and award reconciliation joining IGS_PS_AWARD and IGS_FI_FEE_AS_RATE on COURSE_CD.

Related Objects

IGS_PS_VER_ALL is a heavily referenced parent. Its inbound foreign keys define the most significant dependents, joined on COURSE_CD (and VERSION_NUMBER where applicable):

• IGS_PS_COURSE — parent of COURSE_CD; the base program definition.
• IGS_PS_STAT — supplies COURSE_STATUS values.
• IGS_PS_TYPE_ALL — supplies COURSE_TYPE values.
• IGS_PS_OFR_ALL — program offerings referencing COURSE_CD and VERSION_NUMBER.
• IGS_PS_AWARD — awards granted against program versions.
• IGS_EN_STDNT_PS_ATT_ALL — student program attempts, joined on COURSE_CD.
• IGS_AD_PS_APPL_INST_ALL — admission application instances.
• IGS_PS_UNIT_LVL_ALL — unit-level rules for the program version.
• IGS_FI_FEE_AS_RATE — fee assessment rates tied to the program.
• IGS_PS_ACCTS_ALL — accounting associations for the program version.