Results for “igs_ca_type_v”

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

Overview

IGS_CA_TYPE_V is a seeded Oracle E-Business Suite view owned by the APPS schema and shipped as part of the IGS — Student System (Student Records / Curriculum) product family. It exposes calendar type definitions maintained in the Institution Calendar structures of the Student System, enriching the base calendar type record with lookup-derived meaning and with attributes of any associated Arts Teaching calendar type. For implementers and technical consultants working on Oracle EBS 12.1.1 or 12.2.2, the view provides a denormalized, read-only projection of calendar type configuration that can be joined directly into reports, concurrent programs, OAF pages, and interface extracts without requiring consumers to resolve the CAL_CAT lookup or the Arts Teaching cross-reference manually.

The view is particularly relevant to the ARTS_TEACHING_CAL_TYPE_CD attribute, the column surfaced by the user search term arts_teaching_cal_type_cd. This column links a standard calendar type to a corresponding Arts Teaching calendar type, and the view resolves the description and closed indicator of that related record so that reporting can present the relationship in a single row.

Underlying Base Objects

The view is defined over three referenced objects:

• IGS_CA_TYPE CAT — the primary calendar type table; all core columns (calendar type code, description, category, abbreviation, notes, and audit columns) originate here.
• IGS_LOOKUPS_VIEW LKUP — the lookup view used to translate the calendar category code S_CAL_CAT into its descriptive MEANING; joined on LOOKUP_CODE = CAT.S_CAL_CAT with LOOKUP_TYPE = 'CAL_CAT'.
• IGS_CA_ARTS_TC_CA_CD ATCTC — the Arts Teaching calendar type cross-reference table; joined to IGS_CA_TYPE using an outer join so that calendar types without an associated Arts Teaching calendar type are still returned.

Because the join to ATCTC is expressed with the Oracle outer-join operator (+) on ATCTC.ARTS_TEACHING_CAL_TYPE_CD, records lacking an Arts Teaching mapping appear with null ATCTC_DESCRIPTION and ATCTC_CLOSED_IND values. The lookup join is an inner join, so any calendar type whose category code is not defined as a CAL_CAT lookup value is excluded from the result set.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_CA_TYPE row; useful for update or drill-back operations.
• CAL_TYPE — the unique calendar type code; the primary business key of the view.
• DESCRIPTION — the descriptive name of the calendar type.
• S_CAL_CAT / MEANING — the internal calendar category code and its lookup-derived meaning (for example, teaching or exam calendar categories).
• ABBREVIATION — the short form of the calendar type.
• ARTS_TEACHING_CAL_TYPE_CD — the code linking the calendar type to its associated Arts Teaching calendar type.
• ATCTC_DESCRIPTION / ATCTC_CLOSED_IND — the description and closed indicator of the referenced Arts Teaching calendar type, resolved from IGS_CA_ARTS_TC_CA_CD.
• CLOSED_IND — indicates whether the calendar type itself is closed for use.
• NOTES, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — free-text notes and standard EBS audit columns.

Common Use Cases and Queries

Typical usage includes validating calendar type configuration, producing listings of Arts Teaching calendar relationships, and filtering out closed calendar types before loading them into downstream reporting or interface logic. A representative query listing active calendar types with their Arts Teaching mapping is:

• SELECT cal_type, description, meaning, arts_teaching_cal_type_cd, atctc_description FROM igs_ca_type_v WHERE closed_ind = 'N';

To isolate records that reference an Arts Teaching calendar type:

• SELECT cal_type, description, arts_teaching_cal_type_cd FROM igs_ca_type_v WHERE arts_teaching_cal_type_cd IS NOT NULL;

Because the view resolves both the category meaning and the Arts Teaching attributes, it is also convenient as a lookup source in FND-based value sets or custom concurrent programs where a single fetch is preferable to multi-table joins.