Results for “letter_parameter_type”

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

Overview

IGS_AD_APPL_LTR_PHR is a table in the Oracle EBS IGS — Student System product family, documented in the ETRM (E-Business Tables and Relationships) reference for releases 12.1.1 and 12.2.2. Its documented purpose is to describe the special phrases used in correspondence produced for an admission application. In functional terms, the table stores the individual, parameterized text fragments that are merged into admissions letters — for example, greeting lines, conditional paragraphs, or boilerplate clauses that vary by correspondence type and applicant.

The object carries an Obsolete status marker in the ETRM metadata. The notation "Not implemented in this database" indicates that the table is defined in the Oracle EBS data model but is not physically installed in every environment, and in many 12.1.1 / 12.2.2 instances it will not exist at all. Any query or interface referencing this table should therefore be guarded by an existence check or treated as legacy-only.

From a Data Vault modeling perspective, the metadata's heuristic classification is link. The table resolves relationships between an application-letter header, a phrase definition, and a letter-parameter type, rather than acting purely as a descriptive hub or a passive satellite.

Key Information Stored

The table is documented with 14 columns. The documented primary key is IGS_AD_APPL_LTR_PHR_PK, composed of PERSON_ID, ADMISSION_APPL_NUMBER, CORRESPONDENCE_TYPE, AAL_SEQUENCE_NUMBER, and SEQUENCE_NUMBER. A unique index, IGS_AD_APPL_LTR_PHR_U1, mirrors the same five-column combination, so no separate artificial business key exists — the primary key is the business key for this object.

• PERSON_ID — identifies the applicant (person) for whom the correspondence is generated; also the leading FK column into IGS_AD_APPL_LTR.
• ADMISSION_APPL_NUMBER — the admission application number, tying the phrase to a specific application.
• CORRESPONDENCE_TYPE — the category of letter/correspondence in which the phrase is used.
• AAL_SEQUENCE_NUMBER — sequence number of the parent application-letter record; part of the FK to IGS_AD_APPL_LTR.
• SEQUENCE_NUMBER — ordering sequence of the phrase within the parent letter record.
• PHRASE_CD — code identifying the special phrase; FK to IGS_CO_LTR_PHR.
• PHRASE_ORDER_NUMBER — controls the display/print order of the phrase within the letter.
• LETTER_PARAMETER_TYPE — parameter type governing substitution into the phrase; FK to IGS_CO_LTR_PARM_TYPE.
• PHRASE_TEXT — the actual phrase content, including any runtime-substituted parameters.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns recording insert and update provenance.

Common Use Cases and Queries

The primary use case is reconstructing or auditing the phrase content of generated admissions correspondence. A reporting query joins the phrase rows to their parent letter to list all phrases for a given application, ordered by sequence:

SELECT p.ADMISSION_APPL_NUMBER, p.CORRESPONDENCE_TYPE,
       p.AAL_SEQUENCE_NUMBER, p.PHRASE_ORDER_NUMBER,
       p.PHRASE_CD, p.LETTER_PARAMETER_TYPE, p.PHRASE_TEXT
FROM   IGS_AD_APPL_LTR_PHR p
WHERE  p.PERSON_ID = :person_id
ORDER  BY p.AAL_SEQUENCE_NUMBER, p.PHRASE_ORDER_NUMBER;

Other scenarios include verifying that every phrase code resolves to a valid definition in IGS_CO_LTR_PHR (referential-integrity audit), and extracting phrase text for correspondence templates that were migrated or re-implemented. Because the table is obsolete, an existence pre-check is advisable:

SELECT COUNT(*) FROM all_tables
WHERE  table_name = 'IGS_AD_APPL_LTR_PHR';

Related Objects

The FK metadata identifies three direct parent tables and one dependent context:

• IGS_AD_APPL_LTR — parent letter header; joined on PERSON_ID, ADMISSION_APPL_NUMBER, CORRESPONDENCE_TYPE, and AAL_SEQUENCE_NUMBER.
• IGS_CO_LTR_PHR — phrase definition repository; joined on PHRASE_CD.
• IGS_CO_LTR_PARM_TYPE — letter parameter type lookup; joined on LETTER_PARAMETER_TYPE.
• IGS_AD_APPL_LTR_PHR_PK / _U1 — the primary key constraint and unique index enforcing the five-column business key.

Together these form the correspondence-generation link chain: letter header → phrase instance → phrase definition → parameter type. Reporting solutions should treat the table as legacy and confirm physical presence before relying on it.