Search Results igs_as_entry_conf_u1

Overview

IGS.IGS_AS_ENTRY_CONF is a seed-data configuration table in the Oracle E-Business Suite Student Systems (IGS) schema. The table stores the entry configuration parameters that govern how marks and grades are captured, validated, and processed during academic result entry. Its scope spans manual keying through the results entry form (ASSF5330), electronic result upload processing, and self-service result submission. Each row represents a discrete configuration record identified by a system control number, allowing multiple configuration profiles to coexist within a single deployment.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its single unique index, IGS_AS_ENTRY_CONF_U1, is held in APPS_TS_TX_IDX. The table is documented under FND Design Data as IGS.IGS_AS_ENTRY_CONF and carries a VALID status in the ETRM release metadata.

From a Data Vault modeling perspective, the mined relationship data classifies this object as standalone, with no dependent foreign key links. A heuristic classification would therefore treat IGS_AS_ENTRY_CONF as a reference or configuration satellite keyed by S_CONTROL_NUM rather than a hub or link. The absence of foreign key dependencies reinforces that this table functions as an independent control repository, not as a transactional or event-bearing entity.

Key Information Stored

The table's primary key is IGS_AS_ENTRY_CONF_PK, defined on S_CONTROL_NUM, which is also exposed as the unique business-key candidate through index IGS_AS_ENTRY_CONF_U1. The documented physical schema contains 34 columns in ETRM 12.1.1. The most significant configuration indicators are:

• S_CONTROL_NUM — Surrogate system control number and primary key; drives row uniqueness.
• KEY_ALLOW_INVALID_IND — Permits entry of invalid mark or grade combinations where a keyed mark falls outside the range associated with the entered grade.
• KEY_COLLECT_MARK_IND — Controls whether the Mark column is displayed in ASSF5330 and whether marks may be captured at all.
• KEY_GRADE_DERIVE_IND — Determines whether the grade is automatically derived from the entered mark using the grading schema's mark range.
• KEY_MARK_MNDTRY_IND — Enforces that a mark must be supplied whenever the entered grade carries a mark range, including during electronic result upload.
• KEY_DERIVE_UNIT_GRADE_FLAG — Governs derivation of unit-level grades, relevant to the searched term key_derive_unit_grade_flag.
• KEY_ALLOW_INST_FINALIZE_FLAG — Controls whether institutions may finalize results under the active configuration.
• KEY_AI_COLLECT_MARK_FLAG, KEY_AI_MARK_MNDTRY_FLAG, KEY_AI_GRADE_DERIVE_FLAG, KEY_AI_ALLOW_INVALID_FLAG — Assessment-item variants mirroring the primary mark and grade controls.
• KEY_AI_MARK_ENTRY_DEC_POINTS, KEY_MARK_ENTRY_DEC_POINTS — Define decimal precision for mark entry at assessment-item and general level.
• KEY_SS_GRADE_MNDTRY_IND, KEY_ADM_GRADE_MNDTRY_IND — Mandatory-grade rules for self-service and admissions contexts respectively.
• UPLD_* columns — A family of upload validation switches covering non-existent persons, unenrolled courses or units, discontinued units, and existing or invalid grades.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Administrators query this table to audit the active entry configuration before a results cycle, to diagnose why the Mark column is hidden or why grade derivation is not occurring, and to verify that upload validation switches align with institutional policy. A typical inspection query retrieves the controlling flags for a given profile:

• SELECT s_control_num, key_collect_mark_ind, key_grade_derive_ind, key_mark_mndtry_ind, key_allow_invalid_ind, key_derive_unit_grade_flag FROM igs.igs_as_entry_conf WHERE s_control_num = :p_control_num;
• SELECT s_control_num, key_ai_collect_mark_flag, key_ai_grade_derive_flag, key_ai_mark_mndtry_flag FROM igs.igs_as_entry_conf;

Reporting use cases include documenting which configuration permits invalid grade entry, correlation of upload failure counts against UPLD_* switches, and change-tracking via LAST_UPDATED_BY and LAST_UPDATE_DATE for audit trails.

Related Objects

Because the mined relationship data classifies this object as standalone, no direct foreign keys are documented. Related objects are those that consume the configuration at runtime or through the APIs that drive result processing:

• IGS_AS_ENTRY_CONF_PK / IGS_AS_ENTRY_CONF_U1 — Primary key and unique index on S_CONTROL_NUM; join on S_CONTROL_NUM for all lookups.
• ASSF5330 — Results entry form; reads KEY_COLLECT_MARK_IND and related switches to render the Mark column.
• Electronic result upload validation process — Consumes the UPLD_* indicators and KEY_MARK_MNDTRY_IND during file validation.
• Grading schema and mark range definitions — Referenced implicitly by KEY_GRADE_DERIVE_IND and KEY_ALLOW_INVALID_IND when deriving grades from marks.
• Self-service result submission — Governed by KEY_SS_GRADE_MNDTRY_IND and KEY_PRTL_SBMN_ALLOWED_IND.
• Invalid grades report — Used to manually resolve invalid mark or grade combinations permitted by KEY_ALLOW_INVALID_IND.

Collectively, these objects form the configuration and validation layer that the IGS results-entry subsystem depends upon.