Results for “prev_inst_left_date”

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

Overview

IGS_UC_DEFAULTS is a configuration table in the Oracle E-Business Suite Student System (IGS) product module. It stores the default values that are applied to UCAS (Universities and Colleges Admissions Service) application records as they are imported into Oracle Student System (OSS). The table serves as a single-row parameter repository: by design it always holds exactly one record at any given time, which functions as a global default set for the inbound UCAS interface. In the context of EBS 12.1.1 and 12.2.2, this object is a setup-owned table rather than a transactional one; its lifecycle is driven by implementation configuration rather than day-to-day business activity.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. Its primary key, IGS_UC_DEFAULTS_PK, is defined on the SYSTEM_CODE column alone, and the table carries a mixture of descriptive attributes and foreign-key references. The single-row constraint means the object functions less like a classical hub (a set of long-lived, uniquely identified business entities) and more like a persistent satellite attached to the UCAS import process, supplying defaults consumed during data staging and validation. That classification is offered as a modeling suggestion, not as an enforced Oracle construct.

Key Information Stored

The table carries 39 documented columns. The most operationally significant fall into three groups: cycle and calendar defaults, outcome and decision defaults, and process control values.

• SYSTEM_CODE — the surrogate primary key defining IGS_UC_DEFAULTS_PK; also the column that all dependent UCAS tables reference.
• CURRENT_CYCLE and CONFIGURED_CYCLE — the active and configured UCAS admissions cycles applied to imported applications.
• ADM_CAL_TYPE, ADM_CAL_SEQ_NO, ADM_CAL_ALT_ID — the admission calendar instance used for imported applications, with corresponding ACA_CAL_* columns defining the academic calendar.
• DEF_ADM_CAL_* and DEF_ACA_CAL_* — the default variants of the above calendars, used when no explicit calendar is supplied by the inbound record.
• APPLICATION_TYPE — foreign key to IGS_AD_SS_APPL_TYP, setting the default application type assigned to a UCAS import.
• DECISION_MAKE_ID — foreign key to HZ_PARTIES, identifying the default decision-making party or organization.
• DECISION_REASON_ID — foreign key to IGS_AD_CODE_CLASSES, supplying the default decision reason code.
• PENDING_OUTCOME_STATUS, REJECTED_OUTCOME_STATUS, OBSOLETE_OUTCOME_STATUS — each a foreign key to IGS_AD_OU_STAT, defining the outcome status assigned when a UCAS record is pending, rejected, or obsolete.
• NI_NUMBER_ALT_PERS_TYPE — foreign key to IGS_PE_PERSON_ID_TYP, mapping national insurance number handling to a person identifier type.
• CURRENT_INST_CODE, UCAS_ID_FORMAT, UCAS_SECURITY_KEY — identifiers and formatting controls for the UCAS interface.
• ADM_PROC_CAT, ADM_PROC_TYPE, PREV_INST_LEFT_DATE — process categorization and previous-institution data used during import.
• COPY_UCAS_ID, TEST_APP_NO, TEST_CHOICE_NO, TEST_TRANSACTION_TYPE — controls governing identifier copying and test-mode import behavior.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and descriptive columns (NAME, DESCRIPTION) are also present. SYSTEM_CODE is the only documented unique index and therefore the sole business-key candidate; all other columns are attributes.

Common Use Cases and Queries

Because the table holds a single row, reporting is typically a straight lookup rather than an aggregation. A common query retrieves the current default set for verification during interface setup or troubleshooting:

• SELECT * FROM igs.igs_uc_defaults; — returns the single configuration record.
• Verifying which outcome statuses are applied on import: SELECT pending_outcome_status, rejected_outcome_status, obsolete_outcome_status FROM igs.igs_uc_defaults;
• Confirming the active cycle and calendar assignments: SELECT current_cycle, adm_cal_type, adm_cal_seq_no, aca_cal_type FROM igs.igs_uc_defaults;
• Resolving foreign keys to descriptive values, for example joining DECISION_REASON_ID to IGS_AD_CODE_CLASSES to obtain the code meaning.

Operationally, the table is referenced during UCAS import runs, when the interface reads defaults from this row to populate staging and applicant records. Auditors and implementation teams commonly use it to confirm that cycle, calendar, and outcome defaults match the institution's configured admissions policy. Because only one row exists, any query returning more or fewer than one record signals a setup integrity issue.

Related Objects

The dependency relationships documented for IGS_UC_DEFAULTS are entirely keyed on SYSTEM_CODE, making it the parent of a set of UCAS processing tables and a child of several reference tables.

• IGS_UC_APPLICANTS — references IGS_UC_DEFAULTS.SYSTEM_CODE; stores imported UCAS applicant records.
• IGS_UC_CRSE_DETS — references SYSTEM_CODE; holds UCAS course detail records.
• IGS_UC_CYC_DEFAULTS — references SYSTEM_CODE; cycle-level default values.
• IGS_UC_SYS_CALNDRS — references SYSTEM_CODE; UCAS system calendar definitions.
• IGS_UC_SYS_DECISION — references SYSTEM_CODE; UCAS decision records.
• IGS_UC_TRANSACTIONS — references SYSTEM_CODE; transaction staging for the interface.
• IGS_UC_UCAS_CONTROL — references SYSTEM_CODE; UCAS control configuration.
• HZ_PARTIES — referenced via DECISION_MAKE_ID, supplying party identity for the default decision maker.
• IGS_AD_OU_STAT — referenced three times (PENDING_, REJECTED_, OBSOLETE_OUTCOME_STATUS), the source of outcome status codes.
• IGS_AD_SS_APPL_TYP and IGS_AD_CODE_CLASSES — referenced via APPLICATION_TYPE and DECISION_REASON_ID respectively.

Together these relationships confirm the table's role as the configuration anchor for the entire UCAS import subsystem within the IGS Student System.