Results for “igs_ps_govt_type”
27 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_GOVT_TYPE is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product. It stores the government-defined classification of program or course types — that is, the codes that a regulatory or governmental body recognises for categorising academic programs. The table is owned by the IGS schema and holds status VALID in releases 12.1.1 and 12.2.2, where it is queried as IGS.IGS_PS_GOVT_TYPE.
Its role is definitional rather than transactional. It provides the permissible set of government course type codes that other IGS entities reference when they must record a government-reported classification. Two access paths are documented: a primary key, IGS_PS_GOVT_TYPE_PK, and a unique business-key index, IGS_PS_GOVT_TYPE_U1, both on the GOVT_COURSE_TYPE column. Because the unique index and the primary key cover the same column, GOVT_COURSE_TYPE functions simultaneously as the primary key and the natural business key.
Under the heuristic Data Vault classification mined from the foreign-key structure, this table is described as hub-leaning. As a modelling suggestion, it is best treated as a hub: a small set of stable, distinct business keys (the government course types) with no dependent child links or satellites documented within the ETRM extract. Its descriptive attributes are limited to a description and an active/closed indicator.
Key Information Stored
The documented physical schema exposes eight columns for the table in 12.1.1. The most significant are:
- GOVT_COURSE_TYPE — the primary key column (via IGS_PS_GOVT_TYPE_PK) and the business-key candidate covered by the unique index IGS_PS_GOVT_TYPE_U1. It carries the government course type code itself and is the column through which all foreign keys in other tables resolve.
- DESCRIPTION — the human-readable name or explanation of the government course type, used in list-of-values displays and reports.
- CLOSED_IND — an active/inactive flag indicating whether the government course type remains selectable. Closed values are retained for historical data integrity but should not be offered on new entries.
- CREATED_BY, CREATION_DATE — the standard Oracle EBS WHO columns capturing the user and timestamp that inserted the row.
- LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO columns capturing the most recent update, its timestamp and the originating login for audit traceability.
No surrogate sequence-generated identifier is documented; the business code GOVT_COURSE_TYPE serves directly as the primary key. This makes the table effectively self-describing and simplifies joins, since referring tables store the readable code rather than an abstract number.
Common Use Cases and Queries
Typical use is validation and lookup: populating a list of values during program or course setup, enforcing that only government-approved type codes are recorded, and producing regulatory extracts that map internal program types to government classifications.
A common validation query confirms that a supplied code is open and valid:
SELECT govt_course_type, description FROM igs_ps_govt_type WHERE govt_course_type = :code AND NVL(closed_ind,'N') = 'N';
For a complete pick-list of selectable values, filter on the closed indicator and order by description. To audit records that are still referenced but have since been closed, join to the referencing table:
SELECT g.govt_course_type, g.closed_ind, t.* FROM igs_ps_govt_type g JOIN igs_ps_type_all t ON t.govt_course_type = g.govt_course_type ORDER BY g.govt_course_type;
Reporting scenarios include the count of program types per government classification and identification of orphaned codes — government types that no program references. Because the table is small, it is frequently extracted in full into reporting and data-warehouse layers as a conformed dimension.
Related Objects
The documented foreign-key relationship is narrow but central. The principal dependent object is:
- IGS_PS_TYPE_ALL — the entity that records program (course) types across the Student System. Its column IGS_PS_TYPE_ALL.GOVT_COURSE_TYPE references IGS_PS_GOVT_TYPE, making this table the parent of IGS_PS_TYPE_ALL. Any query or extract combining internal program types with government classifications joins these two tables on GOVT_COURSE_TYPE.
Beyond this documented link, the table is exposed through the standard IGS Student System Windows and list-of-values definitions, and it is reached indirectly by the program, unit and enrolment function Setups that consume program type data. Administrators maintain its rows through the government course type maintenance form, and the rows are then inherited by every downstream entity that stores a program type. In practice, the significance of IGS_PS_GOVT_TYPE lies less in the number of objects that reference it than in the breadth of reporting that traverses those references.
-
This entity describes the Government set of program types.
-
TABLE: IGS.IGS_PS_GOVT_TYPE 12.1.1
-
Table: IGS_PS_GOVT_TYPE 12.2.2
This entity describes the Government set of program types.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_PS_VAL_CTY 12.1.1
-
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 →
-
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.
-
PACKAGE: APPS.IGS_EN_GEN_005 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA 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'.