Results for “coa_duration_num”

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

Overview

IGF_AP_CSS_PROFILE_ALL is a Financial Aid (IGF) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores College Scholarship Service (CSS) PROFILE data as received from the College Board. The CSS PROFILE is the supplemental financial aid application used by many private institutions to determine institutional aid eligibility, and this table serves as the staging and persistence layer for the demographic, household, income, asset, and institutional reporting fields submitted through that application.

The table is owned by the IGF schema and is registered as VALID in the ETRM repository. It is a wide table, documented with 336 columns in the 12.1.1 physical schema, which reflects the breadth of the CSS PROFILE form and the substantial number of institution-specific supplementary questions it supports. From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. In practice, the table behaves as a descriptive satellite capturing profile attributes keyed to a base financial aid record, rather than as a hub of independent business entities or a pure link table resolving many-to-many associations. The presence of audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN is consistent with that satellite characterization.

Key Information Stored

The primary key is the surrogate identifier CSSP_ID, enforced through the IGF_AP_CSS_PROFILE_PK constraint. A separate unique index, IGF_AP_CSS_PROFILE_U1, is defined on CSSP_ID as well, confirming it as the documented business-key candidate for the row. The most significant columns include:

• CSSP_ID — surrogate primary key uniquely identifying each CSS PROFILE record.
• BASE_ID — foreign key linking the PROFILE data to the underlying financial aid base record in IGF_AP_FA_BASE_REC_ALL.
• ORG_ID — operating unit, the multi-org partitioning column.
• COLLEGE_CODE — the institution or College Board identifier to which the profile applies.
• ACADEMIC_YEAR — the award year the profile pertains to.
• CSS_ID_NUMBER — the College Board-assigned identifier for the applicant's CSS record.
• ACTIVE_PROFILE — indicates whether the record is the currently effective profile for the applicant.
• LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, DATE_OF_BIRTH, SOCIAL_SECURITY_NUMBER — core applicant demographic data.
• HOUSEHOLD_SIZE and NUMBER_IN_COLLEGE — key need-analysis inputs.
• ADJUSTED_GROSS_INC, TAX_FIGURES, US_TAX_PAID, ITEMIZED_DEDUCTIONS — income and tax figures used in the federal and institutional methodology calculations.
• CASH_SAV_CHECK, INVEST_VALUE, HOME_VALUE, BUS_FARM_VALUE — asset and net-worth fields feeding the Expected Family Contribution (EFC) computation.
• COA_DURATION_EFC_AMT and COA_DURATION_NUM — cost-of-attendance duration EFC amount and count retained for packaging reference.
• LEGACY_RECORD_FLAG — indicates records migrated or treated as legacy data.

The upper portion of the table carries applicant and parent profile fields; the lower portion carries the numbered QUESTION_n_NUMBER / QUESTION_n_SIZE / QUESTION_n_ANSWER triplets (n = 1..30) that accommodate institution-specific queries, alongside SCHOOL_CODE_n and HOUSING_CODE_n arrays for up to ten additional schools.

Common Use Cases and Queries

The table is primarily queried during need analysis and packaging, when the institution must retrieve the received CSS PROFILE data for a given applicant. A typical lookup by surrogate key is:

SELECT * FROM igf.igf_ap_css_profile_all WHERE cssp_id = :cssp_id;

More commonly, the table is joined back to the base record to reconcile the profile with the applicant's aid record:

SELECT p.cssp_id, p.css_id_number, p.academic_year, p.household_size, p.adjusted_gross_inc, b.base_id FROM igf.igf_ap_css_profile_all p, igf.igf_ap_fa_base_rec_all b WHERE p.base_id = b.base_id AND p.active_profile = 'Y' AND p.org_id = :org_id;

Reporting scenarios include active-profile-by-year extracts, EFC comparison reporting using COA_DURATION_EFC_AMT, reconciliation of received-versus-expected profile counts by COLLEGE_CODE, and audit trails on receipt dates such as REGISTRATION_RECEIPT_DATE and APPLICATION_RECEIPT_DATE. Because the table holds 336 columns, reports usually project a curated subset rather than selecting *.

Related Objects

• IGF_AP_FA_BASE_REC_ALL — parent base record table; join on IGF_AP_CSS_PROFILE_ALL.BASE_ID = IGF_AP_FA_BASE_REC_ALL.BASE_ID.
• IGF_AP_CSS_FNAR_ALL — child table of Financial Aid Need Analysis results; join on IGF_AP_CSS_FNAR_ALL.CSSP_ID = IGF_AP_CSS_PROFILE_ALL.CSSP_ID.
• IGF_AP_CSS_PROFILE_PK — primary key constraint on CSSP_ID.
• IGF_AP_CSS_PROFILE_U1 — unique index on CSSP_ID, confirming the business-key candidate.
• IGF schema — owning schema, relevant for grants and synonyms.

Because the table is satellite-leaning, the dominant access pattern is a keyed lookup from the base record or from the FNAR results table, rather than browsing the profile table independently.