Results for “igs_pr_stat_type”

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

Overview

IGS_PR_STAT_TYPE is a reference (setup) table in the IGS — Student System product family of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its documented description states that it "Defines the Statistics Types which will be used for a Particular Installation." In practical terms, the table acts as the installation-level control list of statistical category codes that the institution recognises when collecting, aggregating, and reporting student population statistics — for example counts used in regulatory returns, internal management information, and cohort or organisation-level statistical reporting. Because it is a definition table rather than a transactional one, its rows are low in volume, stable over time, and typically maintained by a functional administrator rather than by end-user processes.

From a Data Vault modelling perspective, the mined relationship metadata classifies this object as hub-leaning. The rationale is visible in the FK structure: IGS_PR_STAT_TYPE is the referenced parent in six separate foreign keys and is not itself dependent on any other table for its identity. That pattern is characteristic of a hub — a stable, uniquely keyed list of business concepts around which satellites (descriptive attributes) and links (associations to transactional facts) are built. This is a modelling suggestion only; the physical object remains a conventional EBS setup table.

Key Information Stored

The table is documented with nine columns in the 12.1.1 physical schema. The most significant are:

• STAT_TYPE — the statistics type code. This is both the primary key column of constraint IGS_PR_STAT_TYPE_PK and the single column of unique index IGS_PR_STAT_TYPE_U1, making it the definitive business key of the table. Every dependent table joins on this column.
• DESCRIPTION — the user-facing name of the statistics type, used in list-of-values displays and reports.
• CLOSED_IND — an active/inactive flag that allows a statistics type to be retired from selection without deleting it, preserving historical references.
• DERIVATION — a descriptive or rule-related attribute associated with the statistics type, distinguishing how the statistic is produced or qualified.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit/WHO columns maintained automatically by the application for row-level traceability of who created and last amended each definition.

The surrogate-versus-business-key distinction is straightforward: STAT_TYPE functions as the natural business key and is enforced by the unique index, while the audit columns carry no identifying role.

Common Use Cases and Queries

Typical usage centres on validating and resolving statistics type codes before they are consumed by dependent setups or reporting. A basic validation query is:

• SELECT stat_type, description, closed_ind FROM igs_pr_stat_type WHERE closed_ind = 'N' ORDER BY stat_type; — populates a list of values with only active statistics types.
• Joining to dependent statistics tables to report what has actually been recorded per type, for example aggregating IGS_PR_INST_STAT or IGS_PR_STU_ACAD_STAT rows grouped by STAT_TYPE and joining back to DESCRIPTION for presentation.
• Auditing orphan or obsolete references: querying IGS_PR_COHORT, IGS_PR_ORG_STAT, and similar tables for STAT_TYPE values that no longer exist in IGS_PR_STAT_TYPE.
• Reporting on configuration completeness, for example identifying statistics types that are defined but never referenced by any dependent table.

Related Objects

The following objects reference IGS_PR_STAT_TYPE through the documented foreign keys, all joining on STAT_TYPE:

• IGS_PR_STA_TYPE_ELE (IGS_PR_STA_TYPE_ELE.STAT_TYPE) — child records holding the elements or breakdowns belonging to a statistics type.
• IGS_DA_CNFG_STAT (IGS_DA_CNFG_STAT.STAT_TYPE) — configuration of statistics used in the data administration/statistics area.
• IGS_PR_COHORT (IGS_PR_COHORT.STAT_TYPE) — associates cohorts with the statistics types collected against them.
• IGS_PR_INST_STAT (IGS_PR_INST_STAT.STAT_TYPE) — institution-level statistical values or definitions.
• IGS_PR_ORG_STAT (IGS_PR_ORG_STAT.STAT_TYPE) — organisational-unit-level statistical records.
• IGS_PR_STU_ACAD_STAT (IGS_PR_STU_ACAD_STAT.STAT_TYPE) — student academic statistics captured per statistics type.

Together these confirm the hub role of IGS_PR_STAT_TYPE: it supplies the governed vocabulary of statistics types consumed across cohort, institution, organisation, student, and configuration contexts within the Student System.