Search Results spl_perm

Overview

IGS.IGS_EN_STD_WARNINGS is a transactional table in the Oracle E-Business Suite 12.1.1 and 12.2.2 Advanced Benefits / Student System (IGS) schema that stores self-service warning details presented to a student during enrollment or unit planning. Each row captures a single validation outcome — a deny, warning, information, or pass message — generated when a student attempts to register for a course or unit section. The table is owned by the IGS schema and resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, consistent with high-churn transactional data.

From a dimensional modeling perspective, the mined Data Vault classification returned by the heuristic is standalone, meaning no foreign key relationships were detected in the FK structure. This suggests the object behaves as an independent transactional (satellite-style) record keyed by its own surrogate identifier rather than participating in a formal hub-and-link topology. Analysts should treat it as an event log of warning occurrences rather than a conformed dimension.

Key Information Stored

The table contains twenty documented columns. The most operationally significant are:

• WARNING_ID — Surrogate primary key, sequence-generated, enforced by the unique index IGS_EN_STD_WARNINGS_PK. This is the sole documented business-key candidate.
• PERSON_ID — Unique identifier for the person (student) in the system; the principal access path for student-centric reporting.
• COURSE_CD — Course code to which the warning applies.
• UOO_ID — Unique identifier for the unit attempt.
• TERM_CAL_TYPE and TERM_CI_SEQUENCE_NUMBER — Term calendar type and calendar instance sequence number in which the unit was planned. Together with PERSON_ID and COURSE_CD these form the composite business key indexed by IGS_EN_STD_WARNINGS_N1.
• MESSAGE_ICON — Single-character flag (D/W/I/P) denoting deny, warn, information, or pass; indexed by IGS_EN_STD_WARNINGS_N2.
• MESSAGE_NAME and MESSAGE_TEXT — The failed validation message identifier (up to 1000 characters, possibly a concatenation of two messages and tokens) and the rendered warning text (up to 4000 characters).
• MESSAGE_FOR — Holds the unit section for unit-step failures or the validation type for others.
• MESSAGE_ACTION, DESTINATION, and P_PARAMETERS — Control the action link rendered to the student (e.g., "Add Co-requisite", "Add Subordinate", "Request Permission"), the destination page, and the semicolon-separated parameter string passed to that page.
• STEP_TYPE — Identifies the warning category within the enrollment flow.
• SESSION_ID and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — Audit and session context for the generating transaction.

Common Use Cases and Queries

Because the user search term is term_ci_sequence_number, the most frequent access pattern targets warnings for a given student and term. The composite index IGS_EN_STD_WARNINGS_N1 on (PERSON_ID, COURSE_CD, TERM_CAL_TYPE, TERM_CI_SEQUENCE_NUMBER) supports this efficiently:

• Retrieve all warnings for a student in a term to render the self-service warning panel:
  SELECT warning_id, course_cd, message_icon, message_text FROM igs.igs_en_std_warnings WHERE person_id = :p_person_id AND term_cal_type = :p_term_cal_type AND term_ci_sequence_number = :p_term_ci_seq_num;
• Count deny-level blocks by course for a registration cycle: filter message_icon = 'D' and group by course_cd.
• Diagnostic reporting on which action links (MESSAGE_ACTION / DESTINATION) are surfaced most often, useful for usability tuning.
• Audit trails reconstructing what messages were displayed at a point in time using LAST_UPDATE_DATE and SESSION_ID.
• Feed processing that reconciles student-facing messages against validation rule configuration.

Related Objects

Although the heuristic classified the object as standalone (no FK-constrained relationships documented), several logical companions are referenced through shared columns:

• PER_ALL_PEOPLE_F on PERSON_ID — resolves the student identity behind each warning.
• IGS_EN_STD_WARNINGS-adjacent enrollment tables keyed by COURSE_CD and UOO_ID — the unit attempt and course catalog objects that originate the validation.
• IGS_CA_INST-style calendar instance tables on TERM_CAL_TYPE / TERM_CI_SEQUENCE_NUMBER — describe the term context.
• IGS Student System enrollment APIs that insert rows into this table during registration validation.
• Lookup tables resolving MESSAGE_ACTION and DESTINATION codes used by the action links.

Because the table is transactional and self-contained, joins should be driven from PERSON_ID, COURSE_CD, and the term calendar columns rather than relying on database-enforced referential integrity.