Results for “igs_pe_usr_arg_all”

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

Overview

IGS_PE_USR_ARG_ALL is a table in the IGS (Student System) product family of Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the IGS schema and documented as VALID in the ETRM repository. Its description states that it "contains all the columns related to self service activity for record open and cutoff date alias and grading schema date alias." In practical terms, the table stores configuration parameters that govern how self-service academic record activity is presented and evaluated for a given person type within a given operating unit — specifically which date aliases drive record open, record cutoff, grading schema, and update-audit behavior. Rows are scoped by PERSON_TYPE and ORG_ID, making it a per-person-type, per-organization control table rather than a transactional ledger. From a heuristic Data Vault modeling perspective, the mined relationship structure suggests this object behaves as a link: it carries a surrogate identifier plus foreign-key references to independent reference and classification entities (IGS_CA_DA and IGS_PE_PERSON_TYPES) while holding descriptive configuration attributes. This classification is a modeling suggestion only; no formal Data Vault designation is published in the metadata.

Key Information Stored

The table documents twelve physical columns. The most significant are the following:

• USR_ACT_RE_GS_ID — the surrogate primary key, enforced by IGS_PE_USR_ARG_ALL_PK and additionally by unique index IGS_PE_USR_ARG_ALL_U1. This identifier is the internal handle for each configuration row.
• PERSON_TYPE — the person type the configuration applies to; part of the business-key candidate IGS_PE_USR_ARG_ALL_U2 together with ORG_ID, and a foreign key to IGS_PE_PERSON_TYPES.
• ORG_ID — the operating unit or organization context, completing the unique business key (PERSON_TYPE, ORG_ID).
• RECORD_OPEN_DT_ALIAS — date alias controlling when self-service record activity opens; foreign key to IGS_CA_DA.
• RECORD_CUTOFF_DT_ALIAS — date alias controlling when record activity closes; foreign key to IGS_CA_DA.
• GRAD_SCH_DT_ALIAS — date alias governing the grading schema date; foreign key to IGS_CA_DA.
• UPD_AUDIT_DT_ALIAS — date alias used for update-audit purposes; foreign key to IGS_CA_DA.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns recording row creation and last modification.

The distinction between the surrogate key (USR_ACT_RE_GS_ID) and the business-key candidates (USR_ACT_RE_GS_ID in U1; PERSON_TYPE and ORG_ID in U2) is important for integrations: external systems should normally resolve rows by person type and operating unit rather than by surrogate identifier.

Common Use Cases and Queries

Typical usage centers on resolving which date aliases apply to a given person type and organization before rendering self-service pages or running batch evaluations of record eligibility. A common query pattern joins to IGS_PE_PERSON_TYPES and IGS_CA_DA to translate alias identifiers into human-readable values:

• Lookup by business key: SELECT * FROM igs.igs_pe_usr_arg_all WHERE person_type = :p_type AND org_id = :org;
• Reporting join to the date-alias reference table on RECORD_OPEN_DT_ALIAS, RECORD_CUTOFF_DT_ALIAS, GRAD_SCH_DT_ALIAS, and UPD_AUDIT_DT_ALIAS to expose alias descriptions.
• Audit reconciliation of configuration changes using LAST_UPDATED_BY and LAST_UPDATE_DATE.
• Multi-organization comparison: grouping by ORG_ID to identify person types configured inconsistently across operating units.

Related Objects

• IGS_CA_DA — referenced four times through RECORD_OPEN_DT_ALIAS, RECORD_CUTOFF_DT_ALIAS, GRAD_SCH_DT_ALIAS, and UPD_AUDIT_DT_ALIAS; the primary reference/lookup table for alias resolution.
• IGS_PE_PERSON_TYPES — referenced through PERSON_TYPE; defines the person-type classifications this configuration applies to.
• IGS_PE_USR_ARG_ALL_PK / IGS_PE_USR_ARG_ALL_U1 / IGS_PE_USR_ARG_ALL_U2 — the primary key and unique index constraints that enforce row identity and the (PERSON_TYPE, ORG_ID) business key.