Results for “record_cutoff_dt_alias”

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

Overview

IGS_EN_CAL_CONF is a configuration table in the Oracle E-Business Suite Student System (IGS) product family, present in both release 12.1.1 and 12.2.2. The table stores institution-defined date alias assignments that the Student System uses as default dates in certain data records and to drive the behaviour of enrollment and calendar-related processes. Rather than hard-coding dates, the institution selects an alias from the institutional calendar, allowing date-driven processing rules to remain valid across academic periods.

The object is owned by the IGS schema and holds 26 documented columns in the 12.1.1 physical schema. It carries a single primary key constraint, IGS_EN_CAL_CONF_PK, on S_CONTROL_NUM, and a unique index IGS_EN_CAL_CONF_U1 also on S_CONTROL_NUM. Because the row is defined solely by S_CONTROL_NUM and every other attribute is a reference to a date alias, the heuristic Data Vault classification of link is a reasonable modelling suggestion: the table records relationships between a control record and the set of date aliases that govern its behaviour, rather than describing a business entity in its own right.

Key Information Stored

S_CONTROL_NUM is the surrogate primary key and the single business-key candidate (unique index IGS_EN_CAL_CONF_U1). All remaining columns are foreign-key references to IGS_CA_DA, the institutional date alias table, and each one controls a specific default or process boundary:

• COMMENCE_CUTOFF_DT_ALIAS — cutoff alias applied to commencement processing.
• COMMENCEMENT_DT_ALIAS — default commencement date for relevant records.
• EFFECT_ENR_STRT_DT_ALIAS — effective enrollment start date used in enrollment rule evaluation.
• RECORD_OPEN_DT_ALIAS / RECORD_CUTOFF_DT_ALIAS — the opening and closing boundaries for record creation within a period.
• SUB_UNIT_DT_ALIAS — alias controlling sub-unit (subject) processing dates.
• VARIATION_CUTOFF_DT_ALIAS — cutoff for enrollment variation or amendment activity.
• ENR_FORM_DUE_DT_ALIAS — due date for enrollment forms.
• LOAD_EFFECT_DT_ALIAS — effective date applied when loading enrollment data.
• ENROLLED_RULE_CUTOFF_DT_ALIAS / INVALID_RULE_CUTOFF_DT_ALIAS — cutoffs governing which enrollment rules are considered enrolled versus invalid.
• LAPSE_DT_ALIAS — date at which an offer or enrollment lapses.
• ENR_CLEANUP_DT_ALIAS — cleanup boundary for stale enrollment rows.
• PLANNING_OPEN_DT_ALIAS / SCHEDULE_OPEN_DT_ALIAS — opening dates for planning and scheduling activity.
• AUDIT_STATUS_DT_ALIAS — alias used when auditing record status changes.

Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are also maintained. Three further alias columns — GRADING_SCHEMA_DT_ALIAS, BEGIN_TRANS_DT_ALIAS, and CLEAN_TRANS_DT_ALIAS — appear in the documented column list but are not enumerated among the documented foreign keys.

Common Use Cases and Queries

The primary use case is resolving which calendar date applies to a given process for a given control record. A typical reporting query joins the configuration row back to IGS_CA_DA to expose the actual date behind each alias:

• Retrieve the complete alias configuration for a control: SELECT * FROM igs_en_cal_conf WHERE s_control_num = :p_control_num;
• Resolve a single business date: SELECT d.date_value FROM igs_en_cal_conf c, igs_ca_da d WHERE c.record_cutoff_dt_alias = d.date_alias AND c.s_control_num = :p_control_num;
• Detect incomplete configuration by testing aliases for NULLs, which is useful before running enrollment rule or cleanup concurrent programs.
• Compare configurations across control records, or between environments, by pivoting alises into columns for audit reporting.

Because the table governs enrollments, scheduling, record cutoffs and rule evaluation, it is a common reference point when investigating unexpected enrollment timing, premature lapses, or cleanup processes firing on the wrong date.

Related Objects

The most significant dependency is IGS_CA_DA, the institutional date alias table to which the table holds seventeen documented foreign keys, including PLANNING_OPEN_DT_ALIAS, SCHEDULE_OPEN_DT_ALIAS, AUDIT_STATUS_DT_ALIAS, ENR_CLEANUP_DT_ALIAS, COMMENCEMENT_DT_ALIAS, COMMENCE_CUTOFF_DT_ALIAS, ENR_FORM_DUE_DT_ALIAS, EFFECT_ENR_STRT_DT_ALIAS, ENROLLED_RULE_CUTOFF_DT_ALIAS, INVALID_RULE_CUTOFF_DT_ALIAS, LAPSE_DT_ALIAS, LOAD_EFFECT_DT_ALIAS, ENR_PCKG_PROD_DT_ALIAS, RECORD_CUTOFF_DT_ALIAS, RECORD_OPEN_DT_ALIAS, SUB_UNIT_DT_ALIAS and VARIATION_CUTOFF_DT_ALIAS. Every join is of the form igs_en_cal_conf.<alias_column> = igs_ca_da.date_alias. Downstream, the resolved dates feed the Student System enrollment and calendar processes, and the control record itself is referenced by the product's enrollment rule and scheduling logic. Practitioners should also consult the IGS_CA_DA maintenance forms and the Student System concurrent programs that consume these aliases, since changes to alias definitions propagate into every process controlled by the corresponding configuration column.