Results for “igs_pr_org_stat_u1”

6 results




Overview
Explore in AI Chat

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

Overview

The IGS.IGS_PR_ORG_STAT table is a transactional configuration table in the Oracle E-Business Suite Intelligent Grants System (IGS) schema, which supports the Student Systems and Grants/Proposals product family. It defines the details of what a particular user-defined Organizational Unit Statistic Type includes, and how that statistic is presented and used within inquiry forms and reporting. Each row represents the association between an organizational unit and a statistic type, together with control flags governing which unit populations are included in the statistic computation.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning. In Data Vault modeling terms, this suggests the table behaves largely as a descriptive satellite — carrying attributes and control flags that describe a business key rather than acting as an independent hub of unique identities. The composite primary key IGS_PR_ORG_STAT_PK (ORG_UNIT_CD, STAT_TYPE) reflects the combination of organizational unit and statistic type that anchors each configuration record.

Key Information Stored

Of the 16 documented columns, the following are the most significant. The table is physically stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

  • ORG_UNIT_CD (VARCHAR2, 30) — Organizational Unit code; part of the composite primary key and both unique indexes.
  • STAT_TYPE (VARCHAR2, 50) — Statistic Type; the second component of the primary key and a foreign key to IGS_PR_STAT_TYPE.
  • DISPLAY_ORDER (NUMBER) — Controls the display ordering of the statistic type, and forms the business-key candidate IGS_PR_ORG_STAT_U2 when combined with ORG_UNIT_CD.
  • TIMEFRAME (VARCHAR2, 50) — Indicates whether the statistic is Period, Cumulative, or Both.
  • STANDARD_IND (VARCHAR2) — Flags whether the row is used as a Standard Statistic (Y/N).
  • DISPLAY_IND (VARCHAR2) — Controls whether the statistic is displayed in the Inquiry Form.
  • INCLUDE_STANDARD_IND (VARCHAR2) — Whether standard units are included (Y/N).
  • INCLUDE_LOCAL_IND (VARCHAR2) — Whether local institution advanced units are included (Y/N).
  • INCLUDE_OTHER_IND (VARCHAR2) — Whether other institution advanced units are included (Y/N).
  • PROGRESSION_IND and FIN_AID_IND — Both documented as OBSOLETE and should not be relied upon in new development.
  • The standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — provide audit and concurrency metadata.

The surrogate-style business keys are represented by the unique indexes: IGS_PR_ORG_STAT_U1 (ORG_UNIT_CD, STAT_TYPE) and IGS_PR_ORG_STAT_U2 (ORG_UNIT_CD, DISPLAY_ORDER), the latter of which is the index the user's search term "igs_pr_org_stat_u2" refers to.

Common Use Cases and Queries

This table is primarily queried to determine how statistics are configured for a given organizational unit, including their ordering, timeframe, and inclusion flags. A typical pattern retrieves all statistics for an org unit in display order:

  • Statistic configuration review: SELECT STAT_TYPE, DISPLAY_ORDER, TIMEFRAME FROM IGS.IGS_PR_ORG_STAT WHERE ORG_UNIT_CD = :org_unit ORDER BY DISPLAY_ORDER;
  • Inquiry form display: Filtering on DISPLAY_IND = 'Y' to build the list of statistics rendered in inquiry screens.
  • Standard vs. local analysis: Joining to institution unit tables and filtering on the INCLUDE_STANDARD_IND, INCLUDE_LOCAL_IND, and INCLUDE_OTHER_IND flags to determine source populations.
  • Data validation: Confirming the uniqueness enforced by IGS_PR_ORG_STAT_U2 so that no two statistics share a display order for the same org unit.

Related Objects

The FK and dependency metadata identify the most significant related objects:

  • IGS.IGS_PR_STAT_TYPE — Referenced by IGS_PR_ORG_STAT.STAT_TYPE; the parent statistic type definition.
  • IGS.IGS_PR_ORG_STAT_REF — References this table via ORG_UNIT_CD; a dependent reference table.
  • APPS.IGS_PR_ORG_STAT — The APPS-layer synonym/view exposing the same object to application code.

These relationships confirm the table's role as a configuration satellite linking organizational units to statistic types and their presentation rules.