Results for “retro_dai_sequence_number”

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

Overview

IGS_FI_F_CAT_CA_INST is a table within the IGS (Student System) product family of Oracle E-Business Suite, historically used in higher-education and student-administration deployments. Its documented purpose is to describe the periods of fee assessment — fee calendar instances — that are applicable to a given fee category. In effect, the table binds each fee category to one or more calendar instances that define when assessments for that category are valid, thereby establishing the temporal scope in which fee rules operate.

The ETRM metadata records this object as obsolete and notes that it is not implemented in the reference database. Consequently, it should be treated as a legacy or retained definition rather than an active runtime object; any forward-engineering effort should confirm whether the table population still exists in the target instance. The heuristic Data Vault classification derived from the foreign-key topology is satellite-leaning, suggesting that the table behaves as a descriptive, context-dependent attachment to core fee and calendar hubs rather than as a standalone hub or a pure transactional link.

Key Information Stored

The documented physical schema comprises nineteen columns owned by IGS. The most significant columns are the following:

• FEE_CAT — the fee category to which the calendar instance applies; part of the primary key and the unique business-key candidate.
• FEE_CAL_TYPE — the fee calendar type identifying the calendar family; part of the primary key.
• FEE_CI_SEQUENCE_NUMBER — the sequence number of the specific calendar instance within that type; part of the primary key.
• FEE_CAT_CI_STATUS — the status of the fee category calendar instance, referencing a fee status definition.
• START_DT_ALIAS and START_DAI_SEQUENCE_NUMBER — the date alias and its instance sequence defining the assessment start point.
• END_DT_ALIAS and END_DAI_SEQUENCE_NUMBER — the date alias and instance sequence defining the assessment end point.
• RETRO_DT_ALIAS and RETRO_DAI_SEQUENCE_NUMBER — the date alias and sequence governing retroactive assessment behavior.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS auditing columns recording who created and last modified the row.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the process that last touched the record.

The surrogate primary key is IGS_FI_F_CAT_CA_INST_PK, defined over (FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER). A unique index, IGS_FI_F_CAT_CA_INST_U1, covers the same three columns, confirming that this triplet is the natural business key and that no duplicate category-calendar combination may exist. There is no separately documented synthetic identifier beyond this composite key.

Common Use Cases and Queries

This table is principally consulted when determining which fee categories are active for a given calendar instance, and when resolving the date-alias boundaries that drive assessment, refund, and retroactive processing. A typical query retrieves all calendar instances for a category:

• SELECT a.fee_cat, a.fee_cal_type, a.fee_ci_sequence_number, a.fee_cat_ci_status FROM igs_fi_f_cat_ca_inst a WHERE a.fee_cat = :fee_cat;
• Joining to IGS_CA_INST_ALL to obtain instance dates: ... FROM igs_fi_f_cat_ca_inst a, igs_ca_inst_all c WHERE a.fee_cal_type = c.cal_type AND a.fee_ci_sequence_number = c.sequence_number;
• Resolving start and end boundaries through the date-alias instance table by matching START_DT_ALIAS and START_DAI_SEQUENCE_NUMBER (and the corresponding end columns) to IGS_CA_DA_INST.

Reporting use cases include fee assessment period audits, verification that a category has a defined and enabled instance before running assessment, and retroactive fee adjustments where the RETRO_DT_ALIAS values are inspected. Status filtering against FEE_CAT_CI_STATUS supports identification of suspended or inactive configurations.

Related Objects

The table participates in a dense foreign-key network. The most significant related objects and their join columns are:

• IGS_FI_FEE_CAT_ALL — parent fee category definition, joined on FEE_CAT.
• IGS_CA_INST_ALL — calendar instance master, joined on FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER.
• IGS_CA_DA_INST — date-alias instance table, referenced three times through START_DT_ALIAS/START_DAI_SEQUENCE_NUMBER, END_DT_ALIAS/END_DAI_SEQUENCE_NUMBER, and RETRO_DT_ALIAS/RETRO_DAI_SEQUENCE_NUMBER.
• IGS_FI_FEE_STR_STAT — status lookup for FEE_CAT_CI_STATUS.
• IGS_FI_F_CAT_FEE_LBL_ALL — fee label definitions linked by FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER.
• IGS_FI_FEE_ENCMB — encumbrance rules keyed to the same triplet.
• IGS_FI_FEE_PAY_SCHD — payment schedule definitions referencing this table.
• IGS_FI_FEE_RET_SCHD and IGS_FI_F_RET_SCHD_HT_ALL — retention schedule definitions and history referencing the same key columns.