Search Results igs_ad_doc_stat_pk

Overview

IGS_AD_DOC_STAT is a reference (lookup) table in the Oracle EBS Student System (IGS) product, owned by the IGS schema. It describes user-defined admission documentation statuses and maps each of them to a system-defined admission documentation status. In the Oracle EBS 12.1.1 and 12.2.2 data models, this table serves as the controlled vocabulary that governs the lifecycle state of admission documentation requirements associated with a prospective applicant's checklist. Because admission documentation statuses propagate into applicant-facing and admissions-office-facing processes, the table acts as an authoritative code list rather than a transactional entity.

From a Data Vault modeling perspective, the heuristics derived from the foreign key structure classify this object as hub-leaning. This is a modeling suggestion rather than a physical design statement: the table holds a stable, unique business key (ADM_DOC_STATUS) that is referenced by other tables, which is the defining characteristic of a hub. The descriptive attributes (DESCRIPTION, S_ADM_DOC_STATUS, SYSTEM_DEFAULT_IND, CLOSED_IND) and the standard WHO/audit columns behave as satellite-style attributes attached to that hub key. Analysts building a dimensional or Data Vault representation of Student System data can therefore treat IGS_AD_DOC_STAT as a small dimension or hub-plus-satellite construct.

Key Information Stored

The table contains 10 documented columns. The most significant are:

• ADM_DOC_STATUS — The primary key column, enforced by the IGS_AD_DOC_STAT_PK constraint and also defined as a unique index (IGS_AD_DOC_STAT_U1). It carries the user-defined status code that uniquely identifies each documentation status row. This column is both the surrogate primary key and the business-key candidate.
• DESCRIPTION — The user-facing label or description of the documentation status, used in forms, reports, and validation error messages.
• S_ADM_DOC_STATUS — The system-defined admission documentation status to which the user-defined status maps. This mapping is the core purpose of the table: it allows institutions to define local nomenclature while preserving the seeded behavior expected by the Student System.
• SYSTEM_DEFAULT_IND — An indicator flag identifying whether the status is the system default, typically used when a documentation requirement is created without an explicit status.
• CLOSED_IND — An indicator flag denoting whether the status represents a closed (completed or terminal) state, which affects processing logic for admission documentation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS WHO columns capturing audit trail information about who created and last modified each status record and when.

The distinction between the surrogate primary key and the business key is minimal here because ADM_DOC_STATUS serves both roles; the unique index IGS_AD_DOC_STAT_U1 reinforces its uniqueness.

Common Use Cases and Queries

Typical reporting and configuration scenarios include listing all active documentation statuses, locating the system-defined equivalent of a user-defined status, and identifying the default or closed statuses. Standard query patterns include:

• Enumerating valid statuses for a lookup or LOV: SELECT adm_doc_status, description FROM igs.igs_ad_doc_stat ORDER BY description;
• Resolving the system-defined mapping: SELECT adm_doc_status, s_adm_doc_status FROM igs.igs_ad_doc_stat WHERE adm_doc_status = :status;
• Finding the default status: SELECT adm_doc_status FROM igs.igs_ad_doc_stat WHERE system_default_ind = 'Y';
• Identifying closed statuses for filtering completed documentation: SELECT adm_doc_status FROM igs.igs_ad_doc_stat WHERE closed_ind = 'Y';
• Joining to applicant documentation instances to report on status by applicant.

Related Objects

The documented foreign key relationship establishes that IGS_AD_PS_APPL_INST_ALL.ADM_DOC_STATUS references IGS_AD_DOC_STAT, meaning admission documentation rows on the applicant instance table are validated against and joined to this status table. This is the most significant dependency. In practice, related objects include the admission documentation requirement and checklist functionality within the Student System, plus the forms and concurrent programs that maintain and consume admission documentation statuses. The join pattern igs_ad_ps_appl_inst_all.adm_doc_status = igs_ad_doc_stat.adm_doc_status is the canonical linkage. Because the table is a low-volume reference object, its role is primarily to constrain and interpret values held in the larger admission documentation transaction tables.