Search Results igf_sl_pe_citi_map




Overview
Explore in AI Chat

Overview

The IGF_SL_PE_CITI_MAP table belongs to the IGF – Financial Aid product family, which Oracle has classified as Obsolete in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The table's documented purpose is to store the mapping between Oracle Student System (OSS) and Financial Aid (FA) data for the Citizenship Code. In practical terms, it functions as a reference or crosswalk table that allows Financial Aid processing logic to translate a citizenship status value captured within the Student System into the corresponding citizenship status value understood by the Financial Aid subsystem.

The ETRM metadata records that this object is not implemented in the database. It is documented structurally but does not exist as a physical segment in a standard installation, meaning queries against it will fail unless a custom or legacy implementation created it. This is consistent with the Obsolete product classification.

Applying a heuristic Data Vault classification derived from the foreign key structure, the table is satellite-leaning. Its composite primary key combines a reference to a calendar instance together with a status code, and its payload columns record the mapped attribute values. Under a Data Vault model, this pattern suggests a satellite attached to a calendar-instance hub, carrying descriptive citizenship mapping attributes rather than defining an independent business entity.

Key Information Stored

The documented physical schema contains nine columns. The most significant are described below.

  • CI_CAL_TYPE – Calendar type identifier. Part of the primary key and a foreign key candidate.
  • CI_SEQUENCE_NUMBER – Calendar instance sequence number, completing the calendar reference in the primary key.
  • PE_CITI_STAT_CODE – The PeopleSoft/Student System citizenship status code; the third component of the primary key and the OSS-side value being mapped.
  • FA_CITI_STAT_CODE – The corresponding Financial Aid citizenship status code; the principal business payload column holding the mapped value.
  • CREATED_BY, CREATION_DATE – Standard WHO audit columns recording row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns recording the most recent modification and the login/session that performed it.

The surrogate primary key is IGF_SL_PE_CITI_MAP_PK, defined over the composite of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and PE_CITI_STAT_CODE. All three columns are therefore business-key candidates; no separate single-column surrogate identifier is documented.

Common Use Cases and Queries

Because the table is obsolete and not implemented, its principal use is historical or investigative: DBAs and technical consultants inspect it when reverse-engineering legacy Financial Aid customizations, or when reconciling 11i-era data conversions into R12. A typical diagnostic query confirms existence and structure:

  • SELECT COUNT(*) FROM IGF.IGF_SL_PE_CITI_MAP; – returns an error (ORA-00942) if the object is absent, confirming the "not implemented" status.
  • SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'IGF_SL_PE_CITI_MAP' AND OWNER = 'IGF'; – verifies the nine documented columns.
  • SELECT ci_cal_type, ci_sequence_number, pe_citi_stat_code, fa_citi_stat_code FROM igf.igf_sl_pe_citi_map WHERE pe_citi_stat_code = :b1; – retrieves the mapped Financial Aid code for a given Student System citizenship value.

Reporting scenarios, where an implementation exists, include auditing citizenship mapping coverage across calendar instances, validating that every Student System code resolves to exactly one Financial Aid code, and tracing conversion mismatches between source and target aid systems.

Related Objects

The documented foreign key relationship anchors this table to the academic calendar instance structure.

  • IGS_CA_INST_ALL – Referenced via IGF_SL_PE_CITI_MAP.CI_CAL_TYPE joined to the calendar type column, and via CI_SEQUENCE_NUMBER. This is the primary dependency.
  • IGF_SL_PE_* mapping tables – Sibling Financial Aid to Student System crosswalk tables sharing the same design pattern and PK columns.
  • IGS_PE_CITI_STAT – The likely lookup source for PE_CITI_STAT_CODE values on the Student System side.
  • IGF_FA_CITI_STAT – The likely validation source for FA_CITI_STAT_CODE values on the Financial Aid side.
  • FA-related citizenship validation logic – Application code that consumes this mapping during aid eligibility determination.