Results for “create_method”

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

Overview

IGS_PE_TYP_INSTANCES_ALL is a core table in the Oracle EBS Student System (IGS) product family. It stores the individual person type instances assigned to a person record, allowing the same individual to simultaneously or sequentially hold multiple institutional roles such as applicant, student, prospect, alumnus, or staff member. Each row represents one distinct person type instance, identified by a surrogate key and qualified by type code, effective dating, and optional admissions or course context.

Given its foreign key structure — referencing HZ_PARTIES and IGS_AD_PS_APPL_INST_ALL through PERSON_ID and IGS_PE_PERSON_TYPES through PERSON_TYPE_CODE — the ETRM heuristic Data Vault classification is a link table. It resolves many-to-many relationships between parties, person type definitions, and admission or course entities rather than acting as a pure hub or satellite.

Key Information Stored

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

• TYPE_INSTANCE_ID — the surrogate primary key (IGS_PE_TYPE_INSTANCES_PK), uniquely identifying each person type instance. A unique index, IGS_PE_TYP_INSTANCES_U1, also exists on this column, marking it as the sole documented business-key candidate.
• PERSON_TYPE_CODE — foreign key to IGS_PE_PERSON_TYPES, defining which role or classification the instance represents.
• PERSON_ID — foreign key to HZ_PARTIES, identifying the individual to whom the type instance belongs.
• COURSE_CD and CC_VERSION_NUMBER — foreign key components pointing to IGS_PS_VER_ALL, used when the instance is tied to a specific course version.
• FUNNEL_STATUS — indicates the person type's current stage in the admissions or student lifecycle funnel.
• ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, NCC_VERSION_NUMBER, and SEQUENCE_NUMBER — link the instance to admission application records in IGS_AD_PS_APPL_INST_ALL.
• START_DATE and END_DATE — effective dating for the type instance, supporting historical tracking.
• ENDED_BY and END_METHOD — capture who or what terminated the instance and the termination method.
• CREATE_METHOD — records how the instance was created (manual versus system-generated).
• ORG_ID — the operating unit, supporting multi-organization security and reporting.
• EMPLMNT_CATEGORY_CODE — employment category, relevant when the person type reflects a staff or employment relationship.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

Typical reporting scenarios include identifying all current students, finding applicants and their funnel status, and auditing historical person type assignments. Because the table is effective-dated, queries frequently filter on START_DATE and END_DATE to isolate active instances.

A representative query returning all active person type instances for a given party:

• SELECT t.TYPE_INSTANCE_ID, t.PERSON_TYPE_CODE, p.PERSON_TYPE_NAME, t.START_DATE, t.END_DATE FROM IGS_PE_TYP_INSTANCES_ALL t, IGS_PE_PERSON_TYPES p WHERE t.PERSON_TYPE_CODE = p.PERSON_TYPE_CODE AND t.PERSON_ID = :person_id AND NVL(t.END_DATE, SYSDATE) >= SYSDATE AND t.ORG_ID = :org_id;

For funnel reporting, joining to admission applications via ADMISSION_APPL_NUMBER and SEQUENCE_NUMBER allows counts of applicants by FUNNEL_STATUS. For student rosters, joining to IGS_PS_VER_ALL on COURSE_CD and CC_VERSION_NUMBER narrows results to a specific course version. Multi-organization deployments must consistently bind ORG_ID to enforce operating unit security.

Related Objects

The following objects are most directly associated with IGS_PE_TYP_INSTANCES_ALL through documented foreign keys or reciprocal dependencies:

• HZ_PARTIES — joined via PERSON_ID; the master party record for the individual.
• IGS_PE_PERSON_TYPES — joined via PERSON_TYPE_CODE; defines each available person type.
• IGS_AD_PS_APPL_INST_ALL — joined via PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, and SEQUENCE_NUMBER; the admission application instance.
• IGS_PS_VER_ALL — joined via COURSE_CD and CC_VERSION_NUMBER; the course version definition.
• IGS_PE_TYP_INSTANCES_U1 — the unique index on TYPE_INSTANCE_ID, confirming the business key.
• IGS_PE_TYPE_INSTANCES_PK — the primary key constraint governing the surrogate identifier.

These relationships establish the table as the central linkage between party identity, person type classification, admissions processing, and course context within the IGS Student System.