Search Results awd_yr_ci_sequence_number

Overview

IGS_FI_CREDITS is a reporting and integration view within the Oracle E-Business Suite Student System (IGS) product family. In the ETRM 12.2.2 metadata it is classified under IGS - Student System (Obsolete), reflecting that the module is no longer actively enhanced in current releases, though it remains present in many 12.1.1 and 12.2.2 installations that were upgraded from earlier releases. The view exists purely as a multi-org filter flat view layered over the base table IGS_FI_CREDITS_ALL. Its primary role is to present student financial credit records — amounts credited to a student account, originating from receipts, invoices, waivers, charge cards, or other financial sources — while automatically restricting the result set to the organization (ORG_ID) that the current session has been set to through the multi-org mechanism. This makes it suitable for both concurrent program reporting and forms-based inquiry where operating unit isolation is mandatory.

Underlying Base Objects

The view is defined with a single SELECT statement against IGS_FI_CREDITS_ALL, the multi-org base table that physically stores all credit rows for every operating unit. The view does not join any additional tables; it exposes the base table's columns directly, including ROWID. The multi-org restriction is enforced through the standard Oracle Application Object Library client-info predicate, which decodes the ten-character organization identifier from USERENV('CLIENT_INFO') and compares it with the row's ORG_ID. Rows whose ORG_ID is null are compared with a default of -99, and the same default is applied when the client-info value cannot be resolved. The ETRM metadata documents no other base objects, and there is no view logic that aggregates, summarizes, or transforms the underlying data. Notably, at the time the ETRM record was captured, the view was reported as "Not implemented in this database", indicating the definition was catalogued from the product's shipped metadata rather than from a live instance. Because the view wraps a single multi-org table, it inherits that table's indexes, partitions, and any column-level security or audit columns present on IGS_FI_CREDITS_ALL.

Key Columns

The view exposes the full column list of IGS_FI_CREDITS_ALL. Core identifying and financial columns include CREDIT_ID, CREDIT_NUMBER, PARTY_ID, CREDIT_TYPE_ID, CREDIT_SOURCE, STATUS, AMOUNT, CURRENCY_CD, EXCHANGE_RATE, UNAPPLIED_AMOUNT, TRANSACTION_DATE, EFFECTIVE_DATE, GL_DATE, and ORG_ID. Reversal handling is supported through REVERSAL_DATE, REVERSAL_REASON_CODE, and REVERSAL_COMMENTS. Academic and fee context is carried by AWD_YR_CAL_TYPE, AWD_YR_CI_SEQUENCE_NUMBER, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. Receipt and payment detail appears in RECEIPT_LOCKBOX_NUMBER, CHECK_NUMBER, DEPOSIT_DATE, LOCKBOX_INTERFACE_ID, BATCH_NAME, MERCHANT_ID, and the CREDIT_CARD_* columns covering code, holder name, number, expiration, status, payee, tangible indicator, and approval code. TAX_YEAR_CODE — the term the user searched for — is a column contributed by the base table to record the tax year associated with a credit, which is relevant for statutory reporting, tax-deductible fee processing, and year-end student financial statements. The view also carries SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_TYPE, SOURCE_TRANSACTION_REF, SOURCE_INVOICE_ID, SUBACCOUNT_ID, WAIVER_NAME, the twenty ATTRIBUTE (DDF) columns, and the standard WHO audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical usage centers on operating-unit-scoped credit inquiries and reconciliations. Analysts filter by TAX_YEAR_CODE for tax reporting, by CREDIT_SOURCE or CREDIT_TYPE_ID for credit categorization, and by TRANSACTION_DATE or GL_DATE for period activity. A representative query follows.

• Credits for a tax year: SELECT CREDIT_NUMBER, PARTY_ID, AMOUNT, CURRENCY_CD, TAX_YEAR_CODE FROM IGS_FI_CREDITS WHERE TAX_YEAR_CODE = '2015' AND STATUS = 'A';
• Unapplied credits by source: SELECT CREDIT_ID, CREDIT_SOURCE, UNAPPLIED_AMOUNT FROM IGS_FI_CREDITS WHERE UNAPPLIED_AMOUNT > 0;
• Reversal analysis: SELECT CREDIT_ID, REVERSAL_DATE, REVERSAL_REASON_CODE FROM IGS_FI_CREDITS WHERE REVERSAL_DATE IS NOT NULL;
• Receipt linkage: SELECT CREDIT_NUMBER, RECEIPT_LOCKBOX_NUMBER, DEPOSIT_DATE FROM IGS_FI_CREDITS WHERE RECEIPT_LOCKBOX_NUMBER IS NOT NULL;
• Waiver reporting by award year: SELECT WAIVER_NAME, AWD_YR_CAL_TYPE, AWD_YR_CI_SEQUENCE_NUMBER, SUM(AMOUNT) FROM IGS_FI_CREDITS GROUP BY WAIVER_NAME, AWD_YR_CAL_TYPE, AWD_YR_CI_SEQUENCE_NUMBER;

Because the view applies the multi-org predicate automatically, queries return only rows for the session's active organization; report writers who need cross-organization output must iterate organizations or query IGS_FI_CREDITS_ALL directly with appropriate privileges.