Results for “igs_ps_type_all”

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

Overview

IGS_PS_TYPE_ALL is a reference data entity within the Oracle E-Business Suite Student System (IGS) product family. It stores the institution-defined set of program (course) types, providing the controlled vocabulary used to classify academic programs throughout the student lifecycle. The entity is documented as obsolete in the current EBS release but remains part of the historical 12.1.1 and 12.2.2 physical schema under the IGS owner, comprising 17 documented columns.

The description clarifies an important semantic nuance: the university's program type set is not restricted to the government (DEET) reporting set. Institution-specific values that must be reported to DEET are mapped onto their DEET-equivalent values through the GOVT_COURSE_TYPE foreign key, decoupling internal classification from statutory reporting codes.

Consistent with the foreign key structure, the entity exhibits strong hub characteristics. It carries a stable business key (COURSE_TYPE), is referenced by numerous dependent transactional and descriptive tables, and itself references only two parent reference tables. A Data Vault model would therefore treat IGS_PS_TYPE_ALL as a hub, with the mapping and usage relationships modeled as links or satellites depending on volatility.

Key Information Stored

The primary key is IGS_PS_TYPE_PK, defined on COURSE_TYPE, and a unique index IGS_PS_TYPE_ALL_U1 also exists on COURSE_TYPE, confirming it as the business-key candidate.

• COURSE_TYPE — surrogate/business identifier for the program type; the PK and unique key column, and the anchor for virtually all downstream references.
• DESCRIPTION — human-readable name of the program type.
• GOVT_COURSE_TYPE — foreign key to IGS_PS_GOVT_TYPE, mapping the internal value to its statutory reporting equivalent.
• COURSE_TYPE_GROUP_CD — foreign key to IGS_PS_TYPE_GRP, grouping program types into higher-level categories.
• AWARD_COURSE_IND — indicates whether the program type is award-bearing.
• TAC_COURSE_LEVEL — classification level used in admissions/testing contexts.
• RESEARCH_TYPE_IND — flags research-oriented program types.
• CLOSED_IND — indicates whether the type is closed to new use.
• PRIMARY_AUTO_SELECT — controls default selection behaviour.
• ENROLMENT_CAT — enrolment category associated with the program type.
• FIN_AID_PROGRAM_TYPE — links the type to financial-aid program classification.
• ORG_ID — multi-org operating unit discriminator.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage involves resolving program-type descriptions for reporting, validating allowed values against dependent records, and mapping internal types to government codes for statutory extracts. A common lookup pattern:

SELECT COURSE_TYPE, DESCRIPTION, GOVT_COURSE_TYPE
FROM   IGS_PS_TYPE_ALL
WHERE  CLOSED_IND = 'N';

Joining to the government mapping table produces DEET-equivalent values:

SELECT t.COURSE_TYPE, t.DESCRIPTION, g.DESCRIPTION govt_desc
FROM   IGS_PS_TYPE_ALL t, IGS_PS_GOVT_TYPE g
WHERE  t.GOVT_COURSE_TYPE = g.GOVT_COURSE_TYPE;

Referential-integrity checks against dependent tables such as IGS_PS_VER_ALL or IGS_PS_DEGREES use COURSE_TYPE and PROGRAM_TYPE respectively, and grouped reporting aggregates via COURSE_TYPE_GROUP_CD.

Related Objects

• IGS_PS_TYPE_GRP — parent group definition, joined on COURSE_TYPE_GROUP_CD.
• IGS_PS_GOVT_TYPE — parent government type, joined on GOVT_COURSE_TYPE.
• IGS_PS_VER_ALL — program versions reference COURSE_TYPE.
• IGS_PS_DEGREES — degrees reference PROGRAM_TYPE.
• IGS_PS_UNIT_LVL_ALL / IGS_PS_UNIT_LVL_HIST_ALL — unit-level rules keyed on COURSE_TYPE.
• IGS_PS_TYPE_FEE_TRG — fee trigger definitions keyed on COURSE_TYPE.
• IGS_AS_COURSE_TYPE_ALL / IGS_AS_STU_TRN_CMTS — admissions records referencing COURSE_TYPE.
• IGS_FI_1098T_PTS — 1098-T tax reporting points keyed on COURSE_TYPE.
• IGF_AP_FA_ANT_DATA / IGF_AW_COA_RATE_DET — financial-aid objects referencing PROGRAM_TYPE.