Search Results igs_as_entry_conf




Overview
Explore in AI Chat

Overview

IGS_AS_ENTRY_CONF is a configuration table in the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. Its documented description states that it "stores seed data for entry configuration of marks and grades." In practical terms, the table functions as a control repository that governs how marks and grades are captured, derived, validated, and uploaded within the assessment and grading components of Oracle Student System. Each row represents a discrete configuration record identified by a control number, and the flag columns within that row determine the behavior of grade entry forms, self-service submission screens, and batch upload processes.

The ETRM metadata classifies this object as standalone under the heuristic Data Vault classification derived from foreign key mining. No inbound or outbound foreign key relationships were documented, and the only declared constraints are the primary key IGS_AS_ENTRY_CONF_PK and the unique index IGS_AS_ENTRY_CONF_U1, both defined on S_CONTROL_NUM. As a modeling suggestion, this object is therefore best treated as a reference or hub-style entity rather than a transactional satellite, since it holds relatively static configuration data consumed by application logic rather than capturing event history.

Key Information Stored

The table contains 34 documented physical columns in the 12.1.1 schema. The most significant of these are listed below.

Common Use Cases and Queries

Because the table holds configuration rather than transactional data, it is most often queried directly during implementation, troubleshooting, or setup validation. Administrators use it to confirm which entry behaviors are enabled before go-live, and support analysts inspect it when grade entry or upload processes behave unexpectedly.

A typical inspection query retrieves all flags for a given control number:

SELECT S_CONTROL_NUM, KEY_ALLOW_INVALID_IND, KEY_COLLECT_MARK_IND, KEY_GRADE_DERIVE_IND, KEY_MARK_MNDTRY_IND, KEY_MARK_ENTRY_DEC_POINTS, KEY_PRTL_SBMN_ALLOWED_IND FROM IGS.IGS_AS_ENTRY_CONF WHERE S_CONTROL_NUM = :control_num;

Reporting scenarios include auditing which configurations permit invalid grade entry, verifying that upload validation flags align with institutional policy, and comparing assessment-item flags (KEY_AI_*) against their keyed-entry counterparts to detect inconsistent setups. Change-tracking queries against LAST_UPDATED_BY and LAST_UPDATE_DATE help identify recently modified configurations.

Related Objects

The ETRM metadata documents no foreign key relationships for this table; the heuristic Data Vault classification is standalone, meaning no parent or child tables are joined through declared constraints. Consequently, related objects must be inferred from functional context within the IGS Student System rather than from FK data. The primary key and unique index IGS_AS_ENTRY_CONF_U1 both reference S_CONTROL_NUM, which is the natural join column if other tables in the assessment schema carry a matching control-number column. Consumer objects in practice are the grade entry forms, self-service grade submission pages, and the mark and grade upload processes of Oracle Student System, which read these flags at runtime to determine validation and derivation behavior. Where a join is required, it should be constructed on S_CONTROL_NUM rather than on an assumed foreign key, and any integration should be validated against the specific implementation's configuration before deployment.