Results for “igs_re_sprvsr_type”

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

Overview

IGS_RE_SPRVSR_TYPE is a reference (lookup) table within the Oracle E-Business Suite IGS — Student System product family. Its documented purpose is to describe the various types of supervisors associated with research students. In practice, the table acts as a controlled vocabulary that classifies supervisor roles (for example, principal supervisor versus co-supervisor), allowing the institution to categorize each supervisor assignment recorded against a research student.

From a data-modeling perspective, the ETRM metadata classifies this object as hub-leaning under a heuristic Data Vault analysis mined from its foreign-key structure. This classification should be treated as a modeling suggestion rather than a definitive architectural statement. The table functions as the authoritative source of supervisor type codes, referenced by the transactional supervisor assignment entity. Notably, the ETRM documentation states that the table is not implemented in the current database, and the product is marked obsolete, so DBAs should verify physical existence in their specific instance before relying on it.

Key Information Stored

The table is documented with nine physical columns in the ETRM 12.1.1 schema (owner: IGS). The most significant columns are:

• RESEARCH_SUPERVISOR_TYPE — the business-key column and the primary key of the table. It carries the code that identifies the category of supervisor. It is also the single column in the unique index IGS_RE_SPRVSR_TYPE_U1, confirming it as the natural/business key candidate.
• DESCRIPTION — the descriptive text associated with the supervisor type code, used for display and reporting.
• PRINCIPAL_SUPERVISOR_IND — an indicator flagging whether the type represents a principal (primary) supervisor, enabling rules that distinguish the lead supervisor from supporting supervisors.
• CLOSED_IND — an indicator denoting whether the supervisor type is closed (inactive) and therefore no longer available for new assignments.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, which capture standard Oracle EBS who/when tracking for each row.

The surrogate primary key is defined by the constraint IGS_RE_SPRVSR_TYPE_PK, which maps to RESEARCH_SUPERVISOR_TYPE in the documented structure. The unique index IGS_RE_SPRVSR_TYPE_U1 reinforces this column as the business-key candidate.

Common Use Cases and Queries

Typical usage centers on validating and decoding supervisor type values stored on supervisor records. A common reporting query joins the lookup to the supervisor assignment table to translate codes into descriptions:

• Listing active supervisor types: SELECT research_supervisor_type, description FROM igs_re_sprvsr_type WHERE NVL(closed_ind,'N') = 'N';
• Identifying principal supervisor types: SELECT research_supervisor_type, description FROM igs_re_sprvsr_type WHERE principal_supervisor_ind = 'Y';
• Decoding assignments: join to IGS_RE_SPRVSR on RESEARCH_SUPERVISOR_TYPE to display the type description alongside each supervisor record.

Because the object is documented as obsolete and not implemented, queries should be validated against the target instance; in databases where the table is absent, equivalent lookups may reside in a replacement or consolidated setup entity.

Related Objects

The principal dependent object is IGS_RE_SPRVSR, which records supervisor assignments. The documented foreign key relationship is IGS_RE_SPRVSR.RESEARCH_SUPERVISOR_TYPE referencing IGS_RE_SPRVSR_TYPE, establishing a master-detail dependency on the lookup. All other documented relationships are internal constraints: the primary key IGS_RE_SPRVSR_TYPE_PK and unique index IGS_RE_SPRVSR_TYPE_U1 on RESEARCH_SUPERVISOR_TYPE. No additional foreign tables are documented in the provided metadata.