Results for “igf_sl_cl_chg_issue_codes”
7 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.IGF_SL_CLCHSN_DTLS_V is a reporting and integration view within the Oracle E-Business Suite Financial Aid subsystem, specifically the Student Loan (SL) module of the U.S. Department of Education's Title IV processing framework delivered through the Oracle Financial Aid (IGF) product family. The view exposes the detailed contents of change (CLCHSN) records that the institution generates and transmits to lenders, guarantors, and the Common Origination and Disbursement (COD) system. Each row represents a discrete change-record line associated with a loan version, capturing the field that changed, its prior and revised values, and the processing status of the change notification.
The view is primarily consumed by concurrent program extract processes, letter and correspondence generation, and operational reporting queries that must reconcile institution-side change activity against external acknowledgements. It is a runtime view rather than a stored table, so its contents always reflect the current state of the underlying detail table at the moment of query.
Underlying Base Objects
The view is defined over two documented base objects:
- IGF_SL_CLCHSN_DTLS (aliased CLCHGSND) — the change-detail transaction table that holds one row per changed field or disbursement event, keyed by CLCHGSND_ID and linked to a loan version through CL_VERSION_CODE.
- IGF_SL_CL_CHG_REC_TYPES (aliased CLCHRTS) — the change-record-type reference table, joined on CL_VERSION_CODE, supplying the human-readable change code description and record description text.
The view is a simple equi-join between these two tables. In addition, several columns are resolved at query time through calls to IGF_AW_GEN.LOOKUP_DESC, which translates stored lookup codes into their descriptive values using the lookup types IGF_SL_CL_CHG_ISSUE_CODES, IGF_SL_CL_CHANGE_FIELDS, IGF_SL_CL_CHG_REINST_CODES, IGF_SL_CL_CHG_REISSUE_CODES, IGF_SL_CL_DB_FUND_DISB_METH, IGF_SL_CL_CHG_RESP_STATUS, and IGF_SL_CL_CHG_REC_STATUS. Because these lookups are function-based, they are evaluated per row and are not indexed.
Key Columns
- CLCHGSND_ID — Primary key of the change-detail record.
- CL_VERSION_CODE / AWARD_ID / LOAN_NUMBER_TXT — Identifiers tying the change to a specific loan version and award.
- DISBURSEMENT_NUMBER, DISBURSEMENT_DATE — The disbursement affected by the change.
- CHANGE_ISSUE_CODE, CHANGE_CODE_TXT, CHANGE_FIELD_CODE — Classification of the change, with decoded description from the lookup types.
- OLD_VALUE_TXT, NEW_VALUE_TXT, OLD_AMT, NEW_AMT, OLD_DATE, NEW_DATE — Before-and-after values for the changed element.
- DISBURSEMENT_CANCEL_AMT, DISBURSEMENT_CANCEL_DATE, DISBURSEMENT_RETURN_AMT, DISBURSEMENT_RETURN_DATE, DISBURSEMENT_REVISED_AMT, DISBURSEMENT_REVISED_DATE — Disbursement adjustment amounts and effective dates.
- RESPONSE_STATUS_CODE — Decoded through lookup type IGF_SL_CL_CHG_RESP_STATUS to indicate the external party's response.
- STATUS_CODE, STATUS_DATE — The internal processing status of the change record, decoded through lookup type IGF_SL_CL_CHG_REC_STATUS. This is the column that answers searches such as "igf_sl_cl_chg_rec_status" — that string is the lookup type name whose description is returned alongside the raw status code.
- VALIDATION_EDIT_TXT, SEND_RECORD_TXT, GUARANTOR_USE_TXT, LENDER_USE_TXT, SCHOOL_USE_TXT — Free-text validation and party-specific use fields.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID, and related program metadata.
Common Use Cases and Queries
Typical usage includes identifying change records still awaiting transmission, tracking responses from external parties, and producing disbursement adjustment reconciliations.
SELECT clchgsnd_id,
loan_number_txt,
disbursement_number,
change_code_txt,
old_value_txt,
new_value_txt,
status_code,
status_date
FROM apps.igf_sl_clchsn_dtls_v
WHERE status_code = 'PENDING'
ORDER BY creation_date DESC;
To list all open change records grouped by response status:
SELECT response_status_code,
COUNT(*)
FROM apps.igf_sl_clchsn_dtls_v
WHERE response_status_code NOT IN ('ACCEPTED','REJECTED')
GROUP BY response_status_code;
Because the view performs lookup decoding and a reference-table join, queries that filter on decoded description text rather than the stored code incur additional processing. Filtering on the stored code columns (STATUS_CODE, RESPONSE_STATUS_CODE, CHANGE_ISSUE_CODE) is the recommended practice for large extracts.
-
CommonLine Change Issues Codes
-
CommonLine Change Issues Codes
-
View: IGF_SL_CLCHSN_DTLS_V 12.2.2
Stores all the change records for Loan record for CommonLine Release 4 Version.
Not implemented in this database·Explore IGF module →
-
View: IGF_SL_CLCHSN_DTLS_V 12.1.1
Stores all the change records for Loan record for CommonLine Release 4 Version.
APPS.IGF_SL_CLCHSN_DTLS_V·↳ IGF_AW_GEN·↳ IGF_SL_CLCHSN_DTLS·↳ IGF_SL_CL_CHG_REC_TYPES·Explore IGF module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2