Results for “cl_std_code”

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

Overview

The IGF_AP_CLASS_STD_MAP table is an Oracle E-Business Suite base table owned by the IGF schema, which supports the Financial Aid product family. It resides within the Shared Entities and Student Systems integration layer, bridging Oracle Student System (OSS) user-defined class standings to the Financial Aid grade level code recognized by the institution's awarding engine. In functional terms, the table acts as a cross-reference matrix: an OSS-defined class standing is mapped to the Financial Aid class standing value used during need analysis, fund packaging, and award eligibility determination.

The table is implemented at release levels 12.1.1 and 12.2.2 with the same physical footprint, verified as VALID in the IGF schema. Because its rows encode associations between two independent entities — a program type context and a class-standing definition — the heuristic Data Vault classification mined from the foreign-key structure is a link. This classification is offered as a modeling suggestion: the table behaves as a relationship or associative entity rather than as a standalone hub (which would hold a single business key) or a satellite (which would capture descriptive attributes changing over time). Its two natural unique keys reinforce that reading.

Key Information Stored

The table contains eleven documented columns. The most significant are summarized below.

• IPCS_ID — the surrogate primary key, enforced by the unique index IGF_AP_CLASS_STD_MAP_PK and reinforced by IGF_AP_CLASS_STD_MAP_U1. It is a system-generated identifier with no business meaning.
• PPT_ID — foreign key referencing IGF_AP_PR_PRG_TYPE. It ties each mapping row to an Award Program Type, scoping the mapping to a specific financial aid program context.
• IGS_PR_CSS_CLASS_STD_ID — foreign key referencing IGS_PR_CSS_CLASS_STD, the institution-defined class standing held in the Student System tables.
• AP_STD_CODE, DL_STD_CODE, and CL_STD_CODE — the three Financial Aid class standing / grade level code values. These suffixes indicate the distinct code variants applied by program track or career level, providing the translation targets for the OSS standing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — the standard EBS WHO columns that provide auditability and support change tracking.

The composite unique index IGF_AP_CLASS_STD_MAP_U2 on (PPT_ID, IGS_PR_CSS_CLASS_STD_ID) is the true business-key candidate, guaranteeing that a given OSS class standing maps to only one Financial Aid standing within a single program type.

Common Use Cases and Queries

The primary use case is resolution of class standing during award processing. When the financial aid engine evaluates an applicant, it reads the OSS class standing and must translate it into the grade level code used for budget and eligibility rules. A typical lookup pattern is:

• Join to IGS_PR_CSS_CLASS_STD on IGS_PR_CSS_CLASS_STD_ID to resolve the OSS-defined standing description, and to IGF_AP_PR_PRG_TYPE on PPT_ID to confirm the program scope.
• Filter by PPT_ID to restrict results to the active award program type, then select the appropriate code column (AP_STD_CODE, DL_STD_CODE, or CL_STD_CODE) based on the career level being processed.
• Reporting queries that audit unmapped or duplicate class standings typically perform an outer join from IGS_PR_CSS_CLASS_STD to this table to identify OSS standings that have no Financial Aid mapping, a common configuration defect found during implementation.
• Data-migration and setup validation scripts compare the count of distinct mappings per PPT_ID against expected configuration to detect gaps before go-live.

Related Objects

The following objects are the most significant dependencies:

• IGF_AP_PR_PRG_TYPE — referenced through PPT_ID; defines the award program type that scopes each mapping row.
• IGS_PR_CSS_CLASS_STD — referenced through IGS_PR_CSS_CLASS_STD_ID; supplies the OSS user-defined class standing.
• IGF_AP_CLASS_STD_MAP_PK and IGF_AP_CLASS_STD_MAP_U1 / U2 — the primary and unique indexes enforcing row identity and business-key uniqueness.
• Financial aid award-processing packages and grade-level validation routines in the IGF schema that consume the mapped standing codes.

Together these objects form the class-standing translation layer that keeps OSS configuration and Financial Aid award rules synchronized.