Search Results def_adm_ci_sequence_number

Overview

IGS.IGS_AD_OFFRESP_INT is the Offer Response Import interface table in the Oracle E-Business Suite Student System (Product: IGS, "Import Offer Response"). It is a public, active business entity table classified under the category IGS_ADM_APPLICATION. Its purpose is to hold offer response details for each person prior to import into the IGS_AD_PS_APPL_INST table by the Offer Response Import concurrent process. Rows are staged in the APPS_TS_INTERFACE tablespace, populated either manually or by external feeds, and then processed in batch.

From a data-modeling perspective, the ETRM relationship metadata classifies this table as satellite-leaning. This is consistent with its structure: it is a transactional staging record keyed by a surrogate identifier, holding descriptive attributes about an applicant's response to an admission offer, and pointing back to a batch header (IGS_AD_OFFRESP_BATCH) via BATCH_ID.

Key Information Stored

• OFFRESP_INT_ID — surrogate primary key (IGS_AD_OFFRESP_INT_PK, unique), uniquely identifying each interface row.
• BATCH_ID — batch identifier linking the row to its parent batch; supports the non-unique index IGS_AD_OFFRESP_INT_N1 for batch-oriented retrieval.
• PERSON_ID — identifier of the person (applicant) whose offer response is being imported.
• ADMISSION_APPL_NUMBER — admission application number the response pertains to.
• NOMINATED_COURSE_CD / SEQUENCE_NUMBER — program code and sequence number of the admission application.
• ADM_OFFER_RESP_STATUS — the applicant's offer response status.
• ACTUAL_OFFER_RESPONSE_DT — date the applicant responded to the offer.
• ATTENT_OTHER_INST_CD — code of another institution the applicant may attend.
• APPLICANT_ACPTNCE_CNDTN — free-text acceptance comments (up to 2000 characters).
• DEF_ADM_CAL_TYPE / DEF_ADM_CI_SEQUENCE_NUMBER — deferred admission calendar type and calendar instance sequence.
• DEF_ACAD_CAL_TYPE / DEF_ACAD_CI_SEQUENCE_NUMBER — deferred academic calendar type and instance sequence.
• STATUS — interface processing state: '1' Completed, '2' Pending (default on row creation), '3' Error.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and REQUEST_ID for audit and concurrent-request traceability.

Note that the def_adm_cal_type sought by the user is a defined column (DEF_ADM_CAL_TYPE) and its companion DEF_ADM_CI_SEQUENCE_NUMBER; these hold the deferred admission calendar type and instance, distinct from the deferred academic calendar type held in DEF_ACAD_CAL_TYPE.

Common Use Cases and Queries

Typical scenarios include monitoring pending interface rows, validating offer responses before import, and reconciling errored records. Sample patterns:

• Find pending rows awaiting processing: SELECT * FROM igs.igs_ad_offresp_int WHERE status = '2';
• Retrieve all rows in a batch: SELECT * FROM igs.igs_ad_offresp_int WHERE batch_id = :batch_id;
• Locate errored or deferred responses: SELECT ofrresp_int_id, person_id, def_adm_cal_type FROM igs.igs_ad_offresp_int WHERE status = '3';
• Report applicant responses by date: filter on ACTUAL_OFFER_RESPONSE_DT for reporting.

Related Objects

• IGS.IGS_AD_OFFRESP_BATCH — parent batch header; joined on BATCH_ID (FK from this table).
• IGS.IGS_AD_OFFRESP_ERR — error log referencing OFFRESP_INT_ID for the affected interface row.
• IGS.IGS_AD_PS_APPL_INST — target table populated by the Offer Response Import process after interface validation.
• The Offer Response Import concurrent program — the batch process that reads rows where STATUS = '2' and applies the offer response.