Results for “s_admission_process_type”

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

Overview

IGS_AD_PRCS_CAT_LTR is a table within the IGS (Student System) product family of Oracle E-Business Suite, a module classified as obsolete in the documented 12.1.1 ETRM corpus and marked as not implemented in the reference database. The table describes system letters produced for specific admission process categories, functioning as a cross-reference that binds an admission category to an admission process type and a correspondence (letter) type. In EBS deployments where the legacy Student System admissions functionality was licensed, this table drove the automated generation of correspondence — such as offer letters, rejection notices, or acknowledgement letters — tied to a given category and process combination.

Under the heuristic Data Vault classification mined from its foreign-key structure, the table is best modeled as a link. This is consistent with its shape: the primary key IGS_AD_PRCS_CAT_LTR_PK is composed entirely of foreign-key-referencing business columns (ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, CORRESPONDENCE_TYPE), which is the classic signature of a many-to-many association rather than a descriptive hub or satellite. Practitioners designing a Data Vault layer over legacy IGS data should treat it as such, registering it as a link table with the referenced hubs on either side.

Key Information Stored

The documented physical schema contains nine columns, of which the meaningful business content is concentrated in the following:

• ADMISSION_CAT — the admission category identifier. Part of the composite primary key and a foreign key to IGS_AD_PRCS_CAT_ALL. Identifies the category of admission (for example, undergraduate, postgraduate, or transfer) to which the letter assignment applies.
• S_ADMISSION_PROCESS_TYPE — the admission process type (system-defined lookup). Part of the composite primary key and the second segment identifying which process the letter belongs to.
• CORRESPONDENCE_TYPE — the correspondence or letter type. Part of the composite primary key and the third segment; determined by the FK relationship to the correspondence reference table.
• LETTER_REFERENCE_NUMBER — the reference number used to identify the actual system letter generated. This is the primary descriptive payload of the link row, and it also participates in the foreign key documented to the correspondence type lookup.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS "WHO" audit columns, which record the creating user and timestamp, the last modifying user and timestamp, and the login that performed the update. These support audit reporting and change tracking but carry no admissions business semantics.

The surrogate/business key distinction is important here: there is no single numeric surrogate key column. Instead, the unique index IGS_AD_PRCS_CAT_LTR_U1 on (ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, CORRESPONDENCE_TYPE) serves as the business-key candidate, and the primary key IGS_AD_PRCS_CAT_LTR_PK mirrors it. Any integration or de-duplication logic should use this three-column combination rather than assuming a generated ID.

Common Use Cases and Queries

Typical use cases include reporting on which letter templates are configured per admission category and process, auditing coverage gaps where a category/process combination has no letter assigned, and migrating legacy correspondence configuration to a modern student system. A representative query joining the primary table to its category parent would read:

SELECT l.ADMISSION_CAT, l.S_ADMISSION_PROCESS_TYPE, l.CORRESPONDENCE_TYPE, l.LETTER_REFERENCE_NUMBER
FROM IGS_AD_PRCS_CAT_LTR l, IGS_AD_PRCS_CAT_ALL c
WHERE l.ADMISSION_CAT = c.ADMISSION_CAT
ORDER BY l.ADMISSION_CAT, l.S_ADMISSION_PROCESS_TYPE;

Because the table is documented as obsolete and not implemented in the reference database, such queries are primarily of historical or migration value. Auditors may still run them against archived copies to reconstruct which letters a legacy applicant would have received, and data-warehouse teams use the same join to populate a link in a Data Vault model.

Related Objects

The following objects are the most significant relationships documented for this table:

• IGS_AD_PRCS_CAT_ALL — the parent admission process category table. Joined on ADMISSION_CAT; supplies the descriptive category information for each letter assignment.
• IGS_AD_PRCS_CAT_LTR (self-referencing entry for CORRESPONDENCE_TYPE / LETTER_REFERENCE_NUMBER) — the correspondence type lookup, referenced by CORRESPONDENCE_TYPE and LETTER_REFERENCE_NUMBER, which resolves the letter type and reference number to descriptive text.
• IGS_AD_PRCS_CAT_LTR_PK — the primary key constraint on (ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, CORRESPONDENCE_TYPE), enforcing uniqueness of each category/process/letter combination.
• IGS_AD_PRCS_CAT_LTR_U1 — the unique index that duplicates the business key and is the preferred join column set for integration queries.

Together, these objects form the narrow slice of the legacy IGS admissions configuration that governed system letter generation, and any reconstruction of that behaviour must begin from the join between IGS_AD_PRCS_CAT_LTR and IGS_AD_PRCS_CAT_ALL.