Search Results fa_citi_stat_code

Overview

IGF.IGF_SL_PE_CITI_MAP is a mapping table within the Oracle E-Business Suite student systems (IGF/IGS) schema. It stores the relationship between Citizenship Status Codes used in the Oracle Student System (OSS) "PE" side and the corresponding codes used in Financial Aid (FA) processing. The table effectively acts as a cross-reference between the citizenship status values held in the student records and the values required for financial aid eligibility and award processing.

The table is owned by the IGF schema, resides in the APPS_TS_TX_DATA tablespace, and holds an FND Design Data registration (IGF.IGF_SL_PE_CITI_MAP). It has nine documented columns, of which the core business content consists of the calendar context and the two citizenship code columns. The remaining columns are standard Who columns used for audit and concurrency tracing across all Oracle EBS transactional tables.

Based on heuristic analysis of the foreign key structure, this object is satellite-leaning in a Data Vault model. It carries descriptive mapping attributes (the FA and PE citizenship codes) that depend on a driving key from another table, rather than acting as a hub of unique entities or a link between two independent hubs. The single documented foreign key references IGS_CA_INST_ALL, indicating that records are scoped to a specific calendar instance.

Key Information Stored

The primary key is IGF_SL_PE_CITI_MAP_PK, defined across three columns:

• CI_CAL_TYPE (VARCHAR2(10), mandatory) — the calendar type of the Award Year calendar instance. Part of the primary key and the foreign key reference to IGS_CA_INST_ALL.
• CI_SEQUENCE_NUMBER (NUMBER, mandatory) — the calendar number, uniquely identifying the calendar instance within the calendar type. Part of the primary key.
• PE_CITI_STAT_CODE (VARCHAR2(30), mandatory) — the OSS citizenship status code, forming the third component of the primary key and the business-key candidate paired with the financial aid code.
• FA_CITI_STAT_CODE (VARCHAR2(30)) — the Financial Aid citizenship status code that the OSS code maps to. This is the principal payload of the mapping row.

The user search for fa_citi_stat_code corresponds directly to the FA_CITI_STAT_CODE column, which is the target value consumers query when resolving a student's financial aid citizenship status. The standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit lineage but carry no business semantics.

The combination of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and PE_CITI_STAT_CODE constitutes the unique business key, with FA_CITI_STAT_CODE as the dependent descriptive attribute. This structure suggests the mapping is versioned or scoped by Award Year calendar instance, allowing different code translations across academic or award periods.

Common Use Cases and Queries

The primary use case is translating an OSS citizenship status code to its Financial Aid equivalent during award processing and eligibility determination. A typical lookup filters by calendar instance and the PE code to return the FA code:

• Resolve FA code for a student's citizenship status: SELECT FA_CITI_STAT_CODE FROM IGF.IGF_SL_PE_CITI_MAP WHERE CI_CAL_TYPE = :cal_type AND CI_SEQUENCE_NUMBER = :seq AND PE_CITI_STAT_CODE = :pe_code;
• Inventory all mappings for an Award Year: reporting the complete translation set for validation and code-setup review.
• Reverse lookup: locating the OSS code that corresponds to a given FA_CITI_STAT_CODE for reconciliation between the two systems.
• Setup validation/discrepancy reporting: detecting unmapped citizenship codes that would cause financial aid processing failures.
• Custom reporting join: combining this table with IGS_CA_INST_ALL on calendar type and sequence number to associate mappings with the Award Year calendar definition.

Because the mapping is calendar-scoped, queries should generally constrain CI_CAL_TYPE and CI_SEQUENCE_NUMBER to avoid returning rows for unrelated Award Years.

Related Objects

The dependency metadata identifies the following significant relationships:

• IGF.IGF_SL_PE_CITI_MAP (APPS synonym) — the APPS-level synonym exposing the table to application code and concurrent programs, referenced by the table owner entity.
• IGS_CA_INST_ALL — the calendar instance table referenced by the CI_CAL_TYPE foreign key; joins on CI_CAL_TYPE (and the calendar sequence) to resolve the Award Year calendar instance.

Both relationships are documented explicitly. Additional downstream consumers such as Financial Aid citizenship validation logic and OSS-to-FA integration routines are not enumerated in the provided metadata; the table itself does not reference any other database object. Administrators extending or reporting on this mapping should treat IGS_CA_INST_ALL as the authoritative join partner for calendar context and apply the primary key columns as the retrieval predicate for any code-translation query.