Results for “external_calc_ind”
9 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_HE_UT_CALC_TYPE is a reference (lookup) table in the Oracle E-Business Suite Student System (IGS) product family, specifically within the Higher Education UCAS Tariff subsystem. It holds the set of UCAS Tariff Calculation Types — the coded rules by which tariff points are computed from a student's qualifications during admissions and progression processing. The table acts as the master definition list for tariff calculation logic, and downstream tariff processing tables inherit their calculation-type context by foreign key reference to this table rather than duplicating descriptive attributes.
The table resides in the IGS schema and is documented as VALID in both EBS 12.1.1 and 12.2.2. It exposes ten physical columns on the documented 12.1.1 schema. From a Data Vault modeling perspective, the FK topology is hub-leaning: the primary key TARIFF_CALC_TYPE_CD is referenced by four separate child tables without carrying transaction or context detail of its own, which is consistent with a hub entity pattern. This classification is a modeling suggestion only and does not reflect a shipped Data Vault implementation.
Key Information Stored
The table is keyed by the unique index IGS_HE_UT_CALC_TYPE_PK on the single column TARIFF_CALC_TYPE_CD. Under the documented access path this column functions as the business-key candidate, and in EBS 12.1.1 the IGS product tables conventionally carry no separate surrogate key column, so TARIFF_CALC_TYPE_CD serves as both the business and effective primary key.
- TARIFF_CALC_TYPE_CD — the code identifying the tariff calculation type. This is the unique, primary-key column and the value propagated to all dependent tables.
- TARIFF_CALC_TYPE_DESC — the descriptive name of the calculation type, used for display in forms, LOVs, and reports.
- EXTERNAL_CALC_IND — indicates whether the calculation is performed by an external (non-IGS) process or source, allowing the institution to distinguish internally executed tariff rules from externally supplied ones.
- CLOSED_IND — flags the calculation type as closed or inactive, preventing further selection in new tariff setups while preserving history.
- REPORT_ALL_HIERARCHY_FLAG — controls whether all levels of the tariff hierarchy, rather than only the qualifying levels, are reported for this calculation type.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN record standard EBS row-level audit metadata and support change tracking and concurrency control.
Common Use Cases and Queries
Typical applications include validating tariff configuration before an admissions cycle, reporting the active calculation types available to users, and joining calculation types to their level detail and person-level tariff results. A standard lookup of active rows:
SELECT tariff_calc_type_cd, tariff_calc_type_desc, external_calc_ind FROM igs_he_ut_calc_type WHERE closed_ind = 'N';- Join to level definitions:
SELECT c.tariff_calc_type_cd, c.tariff_calc_type_desc, l.* FROM igs_he_ut_calc_type c, igs_he_ut_calc_lvl l WHERE c.tariff_calc_type_cd = l.tariff_calc_type_cd; - Join to person tariff calculations for result analysis:
... igs_he_ut_prs_calcs p WHERE c.tariff_calc_type_cd = p.tariff_calc_type_cd;
Because the table is small and slowly changing, it is well suited as a reporting dimension and as a validation source in inbound interface programs that load tariff data.
Related Objects
Four documented tables carry a foreign key on TARIFF_CALC_TYPE_CD to this table, forming the tariff configuration and processing cluster:
- IGS_HE_UT_CALC_LVL — tariff calculation levels, joined on TARIFF_CALC_TYPE_CD.
- IGS_HE_UT_EXCL_QALS — qualifications excluded from a given tariff calculation type.
- IGS_HE_UT_PRS_CALCS — person-level tariff calculation records.
- IGS_HE_UT_PRT_AWARD — part award definitions tied to a calculation type.
Together with IGS_HE_UT_CALC_TYPE these objects form the core UCAS Tariff reference and calculation model in the IGS Student System. No separate public API is documented for this table; maintenance is performed through the IGS Higher Education tariff setup forms, which enforce the CLOSED_IND and EXTERNAL_CALC_IND constraints at validation time.
-
Holds the UCAS Tariff Calculation Types
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.