Results for “assessment_type”
50+ results
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.
-
Lookup Type: ASSESSMENT_TYPE 12.2.2
Lookup to define the type of Assessment Templates
-
Lookup Type: ASSESSMENT_TYPE 12.1.1
Lookup to define the type of Assessment Templates
-
Holds methods defined for different Load Calendar Types
-
The approved grading schemas for assessment types associated with unit and version are recorded. They can be defaulted so that on linking the assessment items to unit offering and sections the grading schema is associated with the assessmen
-
Describes possible types of assessment items
-
Describes a student unit attempt outcome
APPS.IGSFV_AS_ASSESSMENT_TYPES·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_SASSESS_TYPE·Explore IGS module →
-
Holds the person with the assigned Anonymous Id for the method ASSESSMENT
APPS.IGSBV_AS_ANONYMOUS_ID_ASSESS·↳ HZ_PARTIES·↳ IGS_AS_ANON_ID_ASS·↳ IGS_AS_ASSESSMNT_TYP·Explore IGS module →
-
View: IGS_AS_APPR_GRD_SCH_V 12.1.1
The view displays the approved grading schemas associated with assessment type for units.
APPS.IGS_AS_APPR_GRD_SCH_V·↳ IGS_AS_APPR_GRD_SCH·↳ IGS_AS_GRD_SCHEMA·Explore IGS module →
-
Describes occurrence of an application for special consideration.
APPS.IGSFV_AS_ANONYMOUS_ID_ASSESS·↳ HZ_PARTIES·↳ IGS_AS_ANON_ID_ASS·↳ IGS_AS_ASSESSMNT_TYP·Explore IGS module →
-
Holds the person with the assigned Anonymous Id for the method ASSESSMENT
-
Describes possible types of assessment items.
APPS.IGSBV_AS_ASSESSMENT_TYPES·↳ IGS_AS_ASSESSMNT_TYP·Explore IGS module →
-
Describes an item a student might be assessed.
APPS.IGSBV_AS_ASSESSMENT_ITEMS·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
View: IGS_AS_ANON_METHOD_V 12.1.1
This is stores anon methods
APPS.IGS_AS_ANON_METHOD_V·↳ IGS_AS_ANON_METHOD·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_GE_GEN_004·Explore IGS module →
-
Approved Assessment Item Grading Schema
APPS.IGSFV_AS_APPR_AST_ITM_GRD_SCHS·↳ IGS_AS_APPR_GRD_SCH·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_GRD_SCHEMA·Explore IGS module →
-
Approved Assessment Item Grading Schema
APPS.IGSBV_AS_APPR_AST_ITM_GRD_SCHS·↳ IGS_AS_APPR_GRD_SCH·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_GRD_SCHEMA·Explore IGS module →
-
View: IGS_AS_SUAAI_HIST_V 12.1.1
This view displays the context information for the student assessment items outcomes history.
APPS.IGS_AS_SUAAI_HIST_V·↳ FND_LOOKUP_VALUES·↳ HZ_PARTIES·↳ IGS_AS_ASSESSMNT_ITM·Explore IGS module →
-
View: IGS_AS_ASSESSMNT_ITM 12.1.1
APPS.IGS_AS_ASSESSMNT_ITM·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
View: IGS_AS_UGAI_ADI_V 12.1.1
Unit Grading / Assessment Item WebADI View
APPS.IGS_AS_UGAI_ADI_V·↳ HZ_PARTIES·↳ IGS_AS_ANON_GRD_PKG·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
Describes an item for which a student can be assessed
-
Created primarily for the assignment due dates summary report
APPS.IGS_AS_UNIT_ASSESSMENT_ITEM_V·↳ IGS_AS_ASSESSMNT_ITM·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_UNITASS_ITEM·Explore IGS module →
-
Describes an item a student might be assessed. All items are of a nominated type, as defined by the assessment type assigned. An assessment item can be either an examinable or non-examinable item. Examinable items may require scheduling dur
APPS.IGSFV_AS_ASSESSMENT_ITEMS·↳ IGS_AS_ASSESSMNT_ITM_ALL·↳ IGS_AS_ASSESSMNT_TYP·Explore IGS module →
-
View: IGS_AS_ASSITEM_ADI_V 12.1.1
Assessment Item WebADI View
APPS.IGS_AS_ASSITEM_ADI_V·↳ HZ_PARTIES·↳ IGS_AS_ANON_GRD_PKG·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
View: IGS_AS_UAI_FIND_V 12.1.1
This view is used for the Find Unit Assessment Item form. (ASSF2311)
APPS.IGS_AS_UAI_FIND_V·↳ IGS_AS_ASSESSMNT_ITM_ALL·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_GRD_SCHEMA·Explore IGS module →
-
View: IGS_AS_PROGUGAI_ADI_V 12.1.1
Assessment Progression/UnitGrade/AssessmentItem WebADI View
APPS.IGS_AS_PROGUGAI_ADI_V·↳ FND_DATE·↳ HZ_PARTIES·↳ IGS_AS_ANON_ID_PS·Explore IGS module →
-
Contains Items for which a student can be assessed
APPS.IGS_AS_ASSESSMENT_ITM_V·↳ IGS_AS_ASSESSMNT_ITM·↳ IGS_AS_ASSESSMNT_TYP·Explore IGS module →
-
Assessment Item Outcome Interface Table primarily used to import details entered in Web ADI for Assessment Item grades.
-
PACKAGE: APPS.IGS_AS_VAL_AI 12.1.1
-
View: IGS_AS_ASSESSMNT_ITM 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_AS_ASSESSMNT_TYP 12.2.2
Describes possible types of assessment items
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_ASSITEM_ADI_V 12.2.2
Assessment Item WebADI View
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_PROGUGAI_ADI_V 12.2.2
Assessment Progression/UnitGrade/AssessmentItem WebADI View
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_UGAI_ADI_V 12.2.2
Unit Grading / Assessment Item WebADI View
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_ANON_METHOD_V 12.2.2
This is stores anon methods
Not implemented in this database·Explore IGS module →
-
Describes possible types of assessment items.
Not implemented in this database·Explore IGS module →