Results for “igs_or_org_alt_ids”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_OR_ORG_ALT_IDS is a table within the IGS (Student System) product family of Oracle E-Business Suite, documented against releases 12.1.1 and 12.2.2. It stores alternate identifiers assigned to institutions or organizational units, allowing the same organization record to be recognized under multiple external or legacy identifiers. In the ETRM metadata the object is explicitly flagged as obsolete and, in the sampled environment, is not implemented in the database. Its presence in the data dictionary therefore serves reference and migration-planning purposes rather than active application support.
Functionally, the table acts as a cross-reference between an internal organizational structure record and one or more alternate identification schemes. This pattern is common where an institution must reconcile its internal organizational hierarchy with external reporting bodies, accreditation registries, or legacy systems that use different keys. From a heuristic Data Vault perspective, the mined foreign-key structure classifies this entity as a link, connecting organization structure references to alternate identifier type definitions.
Key Information Stored
The documented physical schema for 12.1.1 records the owner as IGS with 11 columns. The most significant columns are:
- ORG_STRUCTURE_ID — identifier of the organizational structure or institution record being aliased; participates in both the primary key and the foreign key to IGS_AD_LOCATION_ALL.
- ORG_STRUCTURE_TYPE — discriminator indicating the category of organizational structure referenced.
- ORG_ALTERNATE_ID_TYPE — classification of the alternate identifier, validated against IGS_OR_ORG_ALT_IDTYP.
- ORG_ALTERNATE_ID — the actual alternate identifier value held for the organization.
- START_DATE and END_DATE — effective dating that bounds the validity of the alternate identifier.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — standard Oracle EBS audit columns capturing who created or modified the row and when.
The primary key constraint is IGS_OR_ORG_ALTERNATE_IDS_PK, spanning ORG_STRUCTURE_ID, ORG_STRUCTURE_TYPE, ORG_ALTERNATE_ID_TYPE, ORG_ALTERNATE_ID, and START_DATE. A unique index, IGS_OR_ORG_ALT_IDS_U1, carries the identical column list, making it the business-key candidate that enforces uniqueness of an alternate identifier per structure, type, and effective start date. Because the composite key and unique index share the same columns, no separate surrogate key column is documented.
Common Use Cases and Queries
Where the table is populated, the most frequent requirement is resolving an alternate identifier back to its organization, typically during interface or conversion work. A representative pattern joins the base table to the identifier type lookup:
- Resolve an external identifier:
SELECT ORG_STRUCTURE_ID FROM IGS_OR_ORG_ALT_IDS WHERE ORG_ALTERNATE_ID = :id AND ORG_ALTERNATE_ID_TYPE = :type AND TRUNC(SYSDATE) BETWEEN START_DATE AND NVL(END_DATE, TRUNC(SYSDATE)); - List all aliases for an organization: filter on ORG_STRUCTURE_ID and ORG_STRUCTURE_TYPE, joining IGS_OR_ORG_ALT_IDTYP for a descriptive type name.
- Effective-dating audits: identify overlapping or expired identifiers using START_DATE and END_DATE, which supports reconciliation and data-cleansing reports.
Since the object is obsolete and not implemented in the sampled database, these queries should be treated as migration reference patterns rather than production reporting statements.
Related Objects
The documented foreign keys establish the primary relationships for this entity:
- IGS_AD_LOCATION_ALL — referenced on ORG_STRUCTURE_ID, supplying the organization or institution record associated with each alternate identifier.
- IGS_OR_ORG_ALT_IDTYP — referenced on ORG_ALTERNATE_ID_TYPE, providing the valid alternate identifier types and their descriptions.
These two relationships define the link structure of the table and are the joins most likely required in any query against it. Broader IGS organization and student-system objects that model the parent organizational hierarchy are the natural consumers of these mappings, though they fall outside the FK set recorded here.
-
This entity contains alternate IDs for institutions or organizational units.
-
Table: IGS_OR_ORG_ALT_IDS 12.2.2
This entity contains alternate IDs for institutions or organizational units.
Not implemented in this database·Explore IGS module →
-
Table: IGS_OR_ORG_ALT_IDTYP 12.2.2
This entity stores user defined other agencies or systems for which alternate ID codes are maintained.
Not implemented in this database·Explore IGS module →
-
XML element InstitutionTypeGets the Institution codes for the requested Institution. Base on the institution_cd passed in the XML whereclase.
APPS.IGS_DA_XML_INSTITUTION_V·↳ HZ_PARTIES·↳ IGS_DA_SETUP·↳ IGS_OR_ORG_ALT_IDS·Explore IGS module →
-
This entity contains alternate IDs for institutions or organizational unit
APPS.IGSFV_ORG_ALTERNATE_IDS·↳ HZ_PARTIES·↳ IGS_OR_ORG_ALT_IDS·↳ IGS_OR_ORG_ALT_IDTYP·Explore IGS module →
-
This entity contains alternate IDs for institutions or organizational
APPS.IGSBV_ORG_ALTERNATE_IDS·↳ IGS_OR_ORG_ALT_IDS·↳ IGS_OR_ORG_ALT_IDTYP·Explore IGS module →
-
View: IGF_AP_SCHOOL_OPEID_V 12.1.1
Holds distinct OPE ID codes and their descriptions
APPS.IGF_AP_SCHOOL_OPEID_V·↳ HZ_PARTIES·↳ IGF_LOOKUPS_VIEW·↳ IGS_OR_ORG_ALT_IDS·Explore IGF module →
-
XML element InstitutionTypeGets the Institution codes for the requested Institution. Base on the institution_cd passed in the XML whereclase.
Not implemented in this database·Explore IGS module →
-
View: IGF_SL_SCHOOL_CODES_V 12.1.1
View that retrieves all active Financial Aid Offices in the system.
APPS.IGF_SL_SCHOOL_CODES_V·↳ HZ_PARTIES·↳ IGS_OR_ORG_ALT_IDS·↳ IGS_OR_ORG_ALT_IDTYP·Explore IGF module →
-
View: IGS_OR_ORG_ALT_IDS_V 12.1.1
APPS.IGS_OR_ORG_ALT_IDS_V·↳ IGS_OR_ORG_ALT_IDS·↳ IGS_OR_ORG_ALT_IDTYP·Explore IGS module →
-
Table: IGS_AD_LOCATION_ALL 12.2.2
Describes available geographic locations at which programs and units may be offered or taught
Not implemented in this database·Explore IGS module →
-
IGS_PE_HZ_PARTIES describes the attribites of a person
APPS.IGSFV_ORGANIZATION_UNIT_PARTY·↳ HZ_PARTIES·↳ IGS_OR_ORG_ALT_IDS·↳ IGS_OR_ORG_ALT_IDTYP·Explore IGS module →
-
View: IGS_OR_UNIT_V 12.1.1
APPS.IGS_OR_UNIT_V·↳ HZ_PARTIES·↳ IGS_LOOKUP_VALUES·↳ IGS_OR_ORG_ALT_IDS·Explore IGS module →
-
View: IGS_OR_UNIT 12.1.1
APPS.IGS_OR_UNIT·↳ HZ_PARTIES·↳ IGS_LOOKUP_VALUES·↳ IGS_OR_ORG_ALT_IDS·Explore IGS module →
-
View: IGS_DA_FTR_VAL_V 12.1.1
This view is to be created so that all information about all the feature values that have been defined for the features defined
APPS.IGS_DA_FTR_VAL_V·↳ FND_PROFILE·↳ IGS_CA_INST_ALL·↳ IGS_CA_STAT·Explore IGS module →
-
View: IGS_OR_UNIT_OUTER_V 12.1.1
This entity queries the Organization Records.
APPS.IGS_OR_UNIT_OUTER_V·↳ HZ_PARTIES·↳ IGS_LOOKUP_VALUES·↳ IGS_OR_ORG_ALT_IDS·Explore IGS module →
-
View: IGS_OR_INSTITUTION 12.1.1
Describes the institution Details
APPS.IGS_OR_INSTITUTION·↳ HZ_PARTIES·↳ IGS_AD_CODE_CLASSES·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGS_OR_ORG_ALT_IDS_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGF_AP_SCHOOL_OPEID_V 12.2.2
Holds distinct OPE ID codes and their descriptions
Not implemented in this database·Explore IGF module →
-
View: IGS_OR_INST_OUTER_V 12.1.1
The entity retrieves all the records that are Institutions that are either created in the OSS subsystem or from the Oracle Receivables system.
APPS.IGS_OR_INST_OUTER_V·↳ HZ_PARTIES·↳ IGS_AD_CODE_CLASSES·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGF_SL_SCHOOL_CODES_V 12.2.2
View that retrieves all active Financial Aid Offices in the system.
Not implemented in this database·Explore IGF module →
-
This entity contains alternate IDs for institutions or organizational unit
Not implemented in this database·Explore IGS module →
-
IGS_PE_HZ_PARTIES describes the attribites of a person
Not implemented in this database·Explore IGS module →