Results for “phrase_cd”

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

Overview

IGS_CO_LTR_PHR is a reference (setup) table in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to describe the letter phrases used on system letters — the reusable text segments that are assembled into applicant, student, and other institutional correspondence generated by the Student System. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the IGS schema and is marked VALID in the data dictionary, meaning it is an actively maintained application object rather than a deprecated or stub artifact.

From a dimensional or Data Vault modeling perspective, the provided metadata classifies this object as hub-leaning. This is a modeling suggestion derived heuristically from the foreign-key topology: the table is referenced by other tables through a single business key (PHRASE_CD) and is not itself dependent on another parent key. In practice, this means IGS_CO_LTR_PHR behaves as a stable list of phrase definitions, while downstream transactional or association tables carry the references to those definitions.

Key Information Stored

The table is documented with nine physical columns. The most significant are:

• PHRASE_CD — the primary key column and the unique business-key candidate. It is enforced by the unique index IGS_CO_LTR_PHR_U1 as well as the primary-key constraint IGS_CO_LTR_PHR_PK. This is the value that all dependent tables store as a foreign key.
• DESCRIPTION — the short, human-readable label for the phrase, typically used in setup forms, list-of-values windows, and lookup reports.
• PHRASE_TEXT — the actual text content of the letter phrase, which is what ultimately appears (or is merged) into a generated system letter.
• CLOSED_IND — an active/inactive flag indicating whether the phrase remains available for selection on new letter definitions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns that record audit and ownership information for each row.

Because the unique index and the primary key are both defined on PHRASE_CD, the surrogate/primary key and the business-key candidate coincide here; no separate generated identifier is documented.

Common Use Cases and Queries

The most common use of this table is validation and reporting of letter phrase definitions. A typical setup or administration query lists all active phrases:

• SELECT PHRASE_CD, DESCRIPTION, PHRASE_TEXT FROM IGS.IGS_CO_LTR_PHR WHERE CLOSED_IND = 'N';
• Joining phrases to their usage records in IGS_AD_APPL_LTR_PHR to identify which phrases are actually assigned to letters: SELECT p.PHRASE_CD, p.DESCRIPTION FROM IGS.IGS_CO_LTR_PHR p, IGS.IGS_AD_APPL_LTR_PHR a WHERE p.PHRASE_CD = a.PHRASE_CD;
• Audit queries using LAST_UPDATE_DATE and LAST_UPDATED_BY to determine when a phrase's text was last revised.

Other practical scenarios include generating phrase inventory reports for admissions and student-record letters, checking for orphaned or duplicate phrase text, and extracting PHRASE_TEXT for migration or reconciliation exercises between environments.

Related Objects

The documented foreign-key relationship identifies the following dependent object:

• IGS_AD_APPL_LTR_PHR — references IGS_CO_LTR_PHR through IGS_AD_APPL_LTR_PHR.PHRASE_CD. This association table links letter phrases to applicant letters and is the primary consumer of the phrase definitions held here.
• IGS_CO_LTR_PHR_PK — the primary-key constraint on PHRASE_CD, the anchor for all dependent references.
• IGS_CO_LTR_PHR_U1 — the unique index on PHRASE_CD, confirming uniqueness of the business key.
• IGS schema letter-definition and correspondence objects — related IGS letter and correspondence tables that resolve PHRASE_CD values at runtime to render letter content.

Because the supplied metadata documents only one referencing table, the relationships above should be treated as the authoritative set; additional dependencies may exist within the broader IGS letter infrastructure.