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.
-
This table describes a program grouping of program types relating to the way DEET funds (approved EFTSU) programs. E.g. Higher Degree by Research, Higher Degree by Coursework, Other Postgraduate.
-
TABLE: IGS.IGS_PS_TYPE_GRP 12.1.1
-
Table: IGS_PS_TYPE_GRP 12.2.2
This table describes a program grouping of program types relating to the way DEET funds (approved EFTSU) programs. E.g. Higher Degree by Research, Higher Degree by Coursework, Other Postgraduate.
Not implemented in this database·Explore IGS module →
-
This is a base view, which describes a grouping of program
APPS.IGSBV_HIGH_EDU_PRG_TYP_GROUPS·↳ IGS_PS_TYPE_GRP·Explore IGS module →
-
This is a full view, which describes a grouping of program types
APPS.IGSFV_HIGH_EDU_PRG_TYP_GROUPS·↳ IGS_PS_TYPE_GRP·Explore IGS module →
-
View: IGS_EN_TIMESLOT_PARA_V 12.1.1
To capture the Timeslot Parameters of running the process.
APPS.IGS_EN_TIMESLOT_PARA_V·↳ IGS_CA_INST·↳ IGS_CA_TYPE·↳ IGS_EN_TIMESLOT_PARA·Explore IGS module →
-
View: IGS_EN_TIMESLOT_STUP_V 12.1.1
This view is used to capture all the details regarding a Timeslot Setup.
APPS.IGS_EN_TIMESLOT_STUP_V·↳ IGS_CA_INST·↳ IGS_CA_TYPE·↳ IGS_EN_TIMESLOT_STUP·Explore IGS module →
-
PACKAGE: APPS.IGS_PS_VAL_CTY 12.1.1
-
Table: IGS_AD_SBMAO_FN_CTTT 12.2.2
Describes submission period academic organizational unit targets
Not implemented in this database·Explore IGS module →
-
This is a base view, which describes a grouping of program
Not implemented in this database·Explore IGS module →
-
This is a full view, which describes a grouping of program types
Not implemented in this database·Explore IGS module →
-
Table: IGS_PS_TYPE_ALL 12.2.2
This entity describes the university set of program types. This set is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_TIMESLOT_PARA_V 12.2.2
To capture the Timeslot Parameters of running the process.
Not implemented in this database·Explore IGS module →
-
View: IGS_EN_TIMESLOT_STUP_V 12.2.2
This view is used to capture all the details regarding a Timeslot Setup.
Not implemented in this database·Explore IGS module →
-
This entity is used to capture details regarding the setup details of timeslot.
-
To capture the Timeslot Parameters of running the process.
-
Describes submission period academic organizational unit targets
-
This entity describes the university set of program types. This set is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
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'.
-
12.1.1 DBA Data 12.1.1
-
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'.