Results for “teach_calendar_type”

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

Overview

The view IGSBV_AS_ANONYMOUS_ID_UNITS belongs to the IGS – Student System product family, which Oracle classifies as obsolete within the EBS 12.1.1 and 12.2.2 release stacks. It presents a denormalized, read-only projection of anonymous identifier assignments made to students (parties) for unit sections delivered under a specific teaching calendar. Its principal purpose is to surface the person to whom an anonymous ID has been allocated for the method SECTION, joining identifying party data, course and unit version titles, teaching calendar instances, load calendar instances, unit offering options, locations, and unit class descriptions into a single horizontal row.

Because the consumer-facing columns carry business-friendly aliases (PERSON_NAME, UNIT_TITLE, LOCATION_DESCRIPTION, TEACH_CALENDAR_DESCRIPTION), the view is intended for reporting and integration rather than for transactional use. Its read-only definition, declared via WITH READ ONLY, prevents DML through the view and enforces its role as a query surface.

Underlying Base Objects

The view text documents joins across the following tables: HZ_PARTIES, IGS_AS_ANON_ID_US, IGS_PS_VER_ALL, IGS_PS_UNIT_VER_ALL, IGS_CA_INST_ALL, IGS_PS_UNIT_OFR_OPT_ALL, IGS_AD_LOCATION_ALL, IGS_AS_UNIT_CLASS_ALL, and IGS_EN_STDNT_PS_ATT_ALL. The central driving object is IGS_AS_ANON_ID_US (aliased ASEC), the anonymous ID assignment table, which supplies ANONYMOUS_ID, TEACH_CAL_TYPE, TEACH_CI_SEQUENCE_NUMBER, LOAD_CAL_TYPE, LOAD_CI_SEQUENCE_NUMBER, UOO_ID, and PERSON_ID.

HZ_PARTIES links via ASEC.PERSON_ID = HP.PARTY_ID to resolve PERSON_NAME and PERSON_NUMBER. Teaching calendar instance details are resolved through IGS_CA_INST_ALL on the composite of CAL_TYPE and SEQUENCE_NUMBER. Unit offering option, unit version, location, and unit class attributes are joined through UOO_ID and associated code columns. The student program attempt table IGS_EN_STDNT_PS_ATT_ALL is included to constrain the assignment to a valid enrolment record and to supply course version linkage for the course title. Note that the ETRM documentation records no separate referenced base objects for this view and does not list an owner, and the view is reported as not implemented in the reference database.

Key Columns

• PERSON_NAME / PERSON_NUMBER – Party identification of the student holding the anonymous ID.
• ANONYMOUS_ID – The assigned anonymous identifier value.
• "_LA:SYSTEM_GENERATED_IND" – Lookup-derived indicator resolving the SYSTEM_GENERATED_IND flag through IGS_LOOKUP_VALUES against the YES_NO lookup type.
• PROGRAM_CODE / PROGRAM_TITLE – Course version code and title from IGS_PS_VER_ALL.
• UNIT_CODE / UNIT_TITLE – Unit version code and title from IGS_PS_UNIT_VER_ALL.
• LOCATION_CODE / LOCATION_DESCRIPTION – Delivery location attributes.
• TEACH_CALENDAR_TYPE – The teaching calendar type, mapped from ASEC.TEACH_CAL_TYPE, and the column most commonly referenced when searching for "teach_calendar_type".
• TEACH_CI_SEQUENCE_NUMBER – Sequence number of the teaching calendar instance.
• TEACH_CALENDAR_DESCRIPTION – Instance description from IGS_CA_INST_ALL.
• UNIT_CLASS / UNIT_CLASS_DESCRIPTION – Class code and description.
• LOAD_CALENDAR_TYPE / LOAD_CI_SEQUENCE_NUMBER – Load calendar identification.
• PERSON_ID / UNIT_SECTION_ID (UOO_ID) – Surrogate keys supporting further joins.
• Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical usage centers on anonymous grading workflows and audits for section-based assessment. A report may filter by teaching calendar to list all anonymized students in a given period:

SELECT person_name, person_number, anonymous_id, unit_code, unit_title, teach_calendar_type, teach_ci_sequence_number FROM igsbv_as_anonymous_id_units WHERE teach_calendar_type = :p_cal_type ORDER BY unit_code, person_name;

A second pattern reconciles anonymous IDs against a specific teaching calendar instance:

SELECT anonymous_id, person_name, teach_calendar_description, location_code, unit_class_description FROM igsbv_as_anonymous_id_units WHERE teach_cal_type = :p_cal_type AND teach_ci_sequence_number = :p_seq;

Integrations exposing anonymized rosters to external grading tools typically select PERSON_ID, ANONYMOUS_ID, UNIT_SECTION_ID, and the calendar keys. Because the product is obsolete and the view may be absent in later environments, consumers should confirm its availability before relying on it in production interfaces.