Results for “igs_as_anon_method”

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

Overview

IGS_AS_ANON_METHOD is a reference table in the Oracle E-Business Suite Student System (IGS) product family. It holds the configuration of anonymous assessment methods defined for different load calendar types. In the context of Oracle EBS 12.1.1 and 12.2.2, the table governs how anonymous marking, anonymous grading, or anonymous assessment processes behave for a given teaching period or load calendar, allowing institutions to define which assessment type is processed under a specific method.

The table is owned by the IGS schema and is documented as VALID. It contains eight physical columns in the ETRM 12.1.1 schema. The primary key is IGS_AS_ANON_METHOD_PK, defined on the LOAD_CAL_TYPE column. A unique index, IGS_AS_ANON_METHOD_U1, is also defined on LOAD_CAL_TYPE, confirming that column as the business-key candidate. The metadata's Data Vault classification, mined heuristically from the foreign key structure, suggests this object behaves as a link — it connects a load calendar type to an assessment type and carries the associated method value.

Key Information Stored

The documented columns describe a compact configuration record. The most significant columns are:

• LOAD_CAL_TYPE — The load calendar type identifier. This is both the primary key column (IGS_AS_ANON_METHOD_PK) and the unique business-key candidate (IGS_AS_ANON_METHOD_U1), and it also carries a foreign key to IGS_CA_TYPE.
• METHOD — Stores the anonymous assessment method defined for the associated load calendar type. This is the descriptive payload of the configuration record.
• ASSESSMENT_TYPE — The assessment type identifier linked to the record, carrying a foreign key to IGS_AS_ASSESSMNT_TYP.
• CREATED_BY — The user who created the row, following standard EBS WHO column conventions.
• CREATION_DATE — The date and time the row was created.
• LAST_UPDATED_BY — The user who most recently updated the row.
• LAST_UPDATE_DATE — The date and time of the most recent update, used for incremental extraction and auditing.
• LAST_UPDATE_LOGIN — The login identifier associated with the most recent update session.

No surrogate sequence-generated identifier is documented beyond the LOAD_CAL_TYPE-based primary key; LOAD_CAL_TYPE therefore serves as the effective business key. The WHO audit columns support standard EBS concurrency and audit reporting requirements.

Common Use Cases and Queries

Typical use cases involve validating or reporting the anonymous assessment configuration per load calendar. A reporting query joining the table to its lookup parents might take the following form:

• Listing all anonymous assessment methods with their calendar and assessment type descriptions:
  SELECT m.LOAD_CAL_TYPE, m.METHOD, m.ASSESSMENT_TYPE, a.DESCRIPTION
FROM IGS.IGS_AS_ANON_METHOD m, IGS.IGS_AS_ASSESSMNT_TYP a
WHERE m.ASSESSMENT_TYPE = a.ASSESSMENT_TYPE;
• Determining the configured method for a specific load calendar type:
  SELECT METHOD FROM IGS.IGS_AS_ANON_METHOD WHERE LOAD_CAL_TYPE = :load_cal_type;
• Identifying recently changed configuration using the audit columns:
  SELECT LOAD_CAL_TYPE, METHOD, LAST_UPDATED_BY, LAST_UPDATE_DATE
FROM IGS.IGS_AS_ANON_METHOD
WHERE LAST_UPDATE_DATE >= :since_date;

Extract-transform-load processes commonly use LAST_UPDATE_DATE as the high-water mark for incremental loads into reporting or data warehouse environments.

Related Objects

The foreign key relationships documented in the ETRM metadata identify the principal related objects:

• IGS_CA_TYPE — Referenced by IGS_AS_ANON_METHOD.LOAD_CAL_TYPE. Provides the load calendar type definition and description.
• IGS_AS_ASSESSMNT_TYP — Referenced by IGS_AS_ANON_METHOD.ASSESSMENT_TYPE. Provides the assessment type definition used in the anonymous method configuration.
• IGS_AS_ANON_METHOD_PK — The primary key constraint enforcing uniqueness on LOAD_CAL_TYPE.
• IGS_AS_ANON_METHOD_U1 — The unique index on LOAD_CAL_TYPE, reinforcing the business-key rule.

Because LOAD_CAL_TYPE is both the primary key and a foreign key to IGS_CA_TYPE, the table maintains a one-row-per-load-calendar-type cardinality, making it a straightforward configuration lookup within the IGS Student System assessment and calendar subsystems.