Results for “igs_ps_ent_pt_ref_cd”

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

Overview

IGS.IGS_PS_ENT_PT_REF_CD is a Student System (IGS) transactional table that stores external and internal reference codes associated with a program offering entry point. In Oracle E-Business Suite 12.1.1 and 12.2.2, this object supports the capture of identifiers such as TAC codes and CRICOS codes — regulatory, marketing, or statutory references that must be published against a specific entry point of a program offering. The table is a dependent child of the offering option structure and exists because a single entry point may legitimately carry multiple reference codes across several reference types.

The ETRM metadata records 18 columns and one unique index, IGS_PS_ENT_PT_REF_CD_U1, which mirrors the primary key constraint IGS_PS_ENT_PT_REF_CD_PK. Under the heuristic Data Vault classification mined from the foreign-key structure, the object is best modelled as a link — it connects the program offering option context to external reference code definitions and, where populated, to unit sets. This is a modelling suggestion rather than a declared property of the delivered schema.

Key Information Stored

The table carries no single surrogate key column; the primary key is composite and business-meaningful, spanning COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, REFERENCE_CD_TYPE, and SEQUENCE_NUMBER. Together these identify the offering entry point and the specific reference entry within it. The unique index IGS_PS_ENT_PT_REF_CD_U1 covers the same column list, confirming it as the business-key candidate.

• COURSE_CD and VERSION_NUMBER — identify the program version to which the entry point belongs.
• CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE — the offering option attributes that qualify the entry point context.
• REFERENCE_CD_TYPE — the category of reference code (for example TAC or CRICOS); foreign key to IGS_GE_REF_CD.
• SEQUENCE_NUMBER — orders multiple reference entries within the same type.
• REFERENCE_CD — the actual external code value being recorded.
• COO_ID — links the row to the parent offering option record in IGS_PS_OFR_OPT_ALL.
• UNIT_SET_CD and US_VERSION_NUMBER — optional linkage to a unit set in IGS_EN_UNIT_SET_ALL.
• DESCRIPTION — free-text description of the reference code entry.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centres on regulatory reporting and publication of offering identifiers. Admissions and compliance teams extract CRICOS or TAC codes for a given course and calendar type, while integration interfaces push these values to external portals. A representative query joins the reference code definition table to filter by type:

SELECT r.COURSE_CD, r.VERSION_NUMBER, r.REFERENCE_CD_TYPE,
       r.REFERENCE_CD, r.SEQUENCE_NUMBER
FROM   IGS.IGS_PS_ENT_PT_REF_CD r
WHERE  r.COURSE_CD = :course_cd
AND    r.CAL_TYPE  = :cal_type;

Reporting patterns commonly aggregate a count of reference codes per offering option, or validate that every published entry point carries at least one CRICOS code. Reconciliation reports compare IGS_PS_ENT_PT_REF_CD against the offering option parent to detect orphaned references.

Related Objects

• IGS_PS_OFR_OPT_ALL — parent offering option; joined on COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, and via COO_ID.
• IGS_GE_REF_CD — reference code definition; joined on REFERENCE_CD_TYPE and REFERENCE_CD to resolve descriptions.
• IGS_EN_UNIT_SET_ALL — optional unit set association via UNIT_SET_CD and US_VERSION_NUMBER.
• IGS_PS_ENT_PT_REF_CD_U1 — unique index enforcing the composite business key.
• IGS_PS_ENT_PT_REF_CD_PK — primary key constraint over the same column set.