Results for “igf_ap_batch_aw_map_all”

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

Overview

IGS_CA_INST_ALL is the calendar instance table within the Oracle E-Business Suite Student System (IGS) product family. It describes a specific instance of a calendar type, representing a concrete, dated occurrence (such as a term, academic period, admissions cycle, or fee period) derived from a calendar type definition. Because the Student System was deprecated and replaced by Oracle Student Cloud, the product is flagged as obsolete in current EBS documentation. In ETRM 12.1.1 and 12.2.2 the table is documented as not implemented in the database supplied with the ETRM reference environment, although its schema and relationships are fully documented.

From a Data Vault modeling perspective, the FK structure mined from the metadata classifies IGS_CA_INST_ALL as a hub. This is consistent with its role: the table carries the durable business key of a calendar instance and is referenced by well over one hundred dependent tables, including financial aid, admissions, enrollment, fees, and progression objects. It also contains a self-referencing foreign key on CAL_TYPE and a foreign key to IGS_CA_STAT on CAL_STATUS, so a conventional relational reading treats it as both a hub for the calendar instance business key and a link to status and prior-instance references.

Key Information Stored

The table is documented with 21 physical columns. The most significant are:

• CAL_TYPE – the calendar type code, the highest-level discriminator identifying which calendar (academic, admissions, fee, etc.) the instance belongs to.
• SEQUENCE_NUMBER – the sequence of the instance within its calendar type, distinguishing multiple instances of the same type.
• START_DT – start date of the calendar instance.
• END_DT – end date of the calendar instance.
• CAL_STATUS – status of the instance, foreign-keyed to IGS_CA_STAT.
• PRIOR_CI_SEQUENCE_NUMBER – the preceding instance sequence, supporting calendar rollover and self-referencing relationships.
• ALTERNATE_CODE – an alternate identifier used for external or displayed references.
• ORG_ID – the operating unit, enabling multi-org partitioning of calendar data.
• SUP_CAL_STATUS_DIFFER_IND – indicates whether the superior calendar status differs from this instance’s status.
• SS_DISPLAYED, IVR_DISPLAY_IND, PLANNING_FLAG, SCHEDULE_FLAG, ADMIN_FLAG – control flags governing display and functional behavior.
• TERM_INSTRUCTION_TIME, DESCRIPTION – instructional time and descriptive text.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard EBS audit columns.

No single surrogate column is documented as the primary key. Instead, the documented unique indexes serve as business-key candidates: IGS_CA_INST_ALL_U1 on (CAL_TYPE, SEQUENCE_NUMBER) and IGS_CA_INST_ALL_U3 on (CAL_TYPE, START_DT, END_DT). The metadata also lists CI_UK1, CI_UK2, and IGS_CA_INST_PK composite keys, all built from the same CAL_TYPE, SEQUENCE_NUMBER, START_DT, and END_DT columns. The user’s search term, igf_aw_awd_cert_resps, corresponds to a dependent financial aid table that references this object through CI_CAL_TYPE and CI_SEQUENCE_NUMBER.

Common Use Cases and Queries

Typical uses include resolving a calendar instance to its date range, joining dependent objects to a term or period, and reporting on calendar status or rollover lineage. The following pattern retrieves active instances for a given calendar type:

• SELECT cal_type, sequence_number, start_dt, end_dt, cal_status FROM igs_ca_inst_all WHERE cal_type = :cal_type AND TRUNC(SYSDATE) BETWEEN start_dt AND end_dt;
• SELECT a.*, s.description status_description FROM igs_ca_inst_all a, igs_ca_stat s WHERE a.cal_status = s.cal_status AND a.org_id = :org_id;
• SELECT r.ci_cal_type, r.ci_sequence_number, i.start_dt, i.end_dt FROM igf_aw_awd_cert_resps r, igs_ca_inst_all i WHERE r.ci_cal_type = i.cal_type AND r.ci_sequence_number = i.sequence_number;

Reporting scenarios commonly aggregate awards, disbursements, attendance, or fees by term by joining dependent financial aid and enrollment tables back to IGS_CA_INST_ALL on the CAL_TYPE and SEQUENCE_NUMBER pair, replacing the sequence with START_DT and END_DT when date-range validation is required.

Related Objects

The following dependent objects are among the most significant consumers of this hub table:

• IGF_AW_AWD_CERT_RESPS – the object referenced in the user’s search; joins via CI_CAL_TYPE and CI_SEQUENCE_NUMBER.
• IGF_AW_AWD_DISB_ALL – award disbursements, joining on TP_CAL_TYPE/TP_SEQUENCE_NUMBER and LD_CAL_TYPE/LD_SEQUENCE_NUMBER.
• IGF_AP_ATTEND_MAP_ALL – attendance mapping, joined on CAL_TYPE and SEQUENCE_NUMBER.
• IGF_AW_LOAN_LIMIT_ALL – loan limit configuration, joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER.
• IGS_AD_PS_APPL_INST_ALL – admissions application instances, joined on ADM_CAL_TYPE/ADM_CI_SEQUENCE_NUMBER and related deferred or future calendar columns.
• IGS_CA_STAT – status lookup referenced by CAL_STATUS.
• IGS_CA_INST_REL – calendar instance relationships, joined on SUB_CAL_TYPE and SUP_CAL_TYPE.
• IGS_EN_SU_ATTEMPT_ALL and IGS_AS_SC_ATMPT_ENR – enrollment and attempt records keyed to CAL_TYPE.

These relationships confirm the table’s role as a central reference point for term, period, and cycle identity across the Student System and financial aid modules.