Results for “igs_ps_type_grp”

49 results




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

Overview

IGS_PS_TYPE_GRP is a reference (lookup) table within the Oracle E-Business Suite IGS – Student System module. It describes a program grouping of program types relating to the manner in which DEET funds (approved EFTSU) programs are classified. Representative groupings include Higher Degree by Research, Higher Degree by Coursework, and Other Postgraduate. The table serves as the parent of a controlled vocabulary that drives how individual program types are rolled up into funding-relevant categories, and it is referenced by both the program type definitions and the DEET funding aggregation structures.

The ETRM metadata records the object with the note "Not implemented in this database," indicating that in the documented environment the table was not physically created or was excluded from the installed schema. It is nevertheless catalogued as an obsolete Student System object with a documented physical schema in ETRM 12.1.1 (owner IGS, 8 columns). Under the heuristic Data Vault classification mined from its foreign-key structure, IGS_PS_TYPE_GRP is assessed as hub-leaning: it holds a single, stable business key (COURSE_TYPE_GROUP_CD) that is referenced by dependent tables, which is characteristic of a hub entity rather than a transactional link or descriptive satellite.

Key Information Stored

The documented physical schema comprises eight columns. The most significant are:

  • COURSE_TYPE_GROUP_CD – The program grouping code. This is both the primary key column (via IGS_PS_TYPE_GRP_PK) and the unique business-key candidate (via unique index IGS_PS_TYPE_GRP_U1). It is the value propagated into every dependent table.
  • DESCRIPTION – The descriptive label for the grouping, such as "Higher Degree by Research" or "Other Postgraduate." This is the attribute most commonly surfaced in reports and LOVs.
  • CLOSED_IND – A status indicator that flags whether the grouping is closed to new use, allowing obsolete groupings to be retired without deletion.
  • CREATED_BY, CREATION_DATE – Standard Oracle who/audit columns recording the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle audit columns recording the most recent modifying user, timestamp, and login session.

No surrogate (system-generated) key is documented; the primary key is the natural business key COURSE_TYPE_GROUP_CD itself, and the auditing columns are the only non-key attributes beyond DESCRIPTION and CLOSED_IND.

Common Use Cases and Queries

The primary use case is reporting and validation of DEET/EFTSU funding groupings. Typical patterns include resolving the description for a given grouping code, validating that a program type's grouping is still open, and producing funding category breakdowns.

  • Listing active groupings for a value set or LOV: SELECT course_type_group_cd, description FROM igs_ps_type_grp WHERE closed_ind = 'N';
  • Joining to program types to label each program: SELECT a.course_type_cd, g.description FROM igs_ps_type_all a JOIN igs_ps_type_grp g ON a.course_type_group_cd = g.course_type_group_cd;
  • Funding roll-up reporting: group approved programs by COURSE_TYPE_GROUP_CD to obtain EFTSU totals per DEET funding category.
  • Audit and data-governance review of when a grouping code was created or last changed, using the audit columns.

Related Objects

The following objects reference or depend on IGS_PS_TYPE_GRP via the documented foreign-key relationships:

  • IGS_PS_TYPE_ALL – The program (course) type table; its COURSE_TYPE_GROUP_CD column is a foreign key to IGS_PS_TYPE_GRP.COURSE_TYPE_GROUP_CD.
  • IGS_AD_SBMAO_FN_CTTT – A DEET funding aggregation/staging structure whose COURSE_TYPE_GROUP_CD column is a foreign key back to IGS_PS_TYPE_GRP.COURSE_TYPE_GROUP_CD.

Together these two dependent tables define both the operational use of the grouping (classification of program types) and its analytical use (DEET/EFTSU funding aggregation), confirming the table's role as a hub-style reference entity within the Student System data model.