Results for “show_on_bill”
44 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_FI_PLN_CREDITS_V is a reporting view that belongs to the IGS (Student System) product family within Oracle E-Business Suite, specifically the financial aid and award disbursement sub-area. In release 12.1.1 and 12.2.2 documentation the object is flagged as obsolete, and the ETRM record explicitly states "Not implemented in this database," meaning the view is documented for reference but is not created in a standard installation of the current release. The name suggests a planning-oriented credit view: it collapses award disbursement records into a flat, billable-credit projection combining disbursement amounts, fund classification, and calendar-instance context.
Its primary role is read-only reporting. Consolidating award, fund, calendar, and disbursement data into a single row per disbursement allows downstream reports — billing, fund credit posting, and fee-assessment reconciliation — to consume student award credits without traversing the normalized award schema. The presence of DISB_NET_AMT as a projected column is significant: it is the net disbursement amount (gross award disbursement less adjustments), and it is the field most often searched by users seeking to reconcile posted credits against expected disbursements.
Underlying Base Objects
Although the metadata lists no documented base objects, the embedded view text shows the definition joins seven tables:
- IGF_AW_AWD_DISB (DISB) — the driving disbursement table, providing amount, date, transaction type, and bill flag.
- IGF_AW_AWARD (AWD) — the parent award, filtered to AWARD_STATUS = 'ACCEPTED'.
- IGF_AP_FA_BASE_REC (BASE) — the financial-aid base record that supplies PERSON_ID.
- IGF_AW_FUND_MAST (FMAST) — the fund master, supplying FUND_CODE, FUND_ID, and CREDIT_TYPE_ID.
- IGS_CA_INST_REL (CIR) and IGS_CA_TYPE (CT) — relate the load calendar to its superior (fee) calendar, with CT.S_CAL_CAT = 'FEE'.
- IGS_CA_INST (CA) — the fee calendar instance, supplying START_DT and END_DT.
- IGF_AP_BATCH_AW_MAP (BM) — the award-year batch mapping, filtered to AWARD_YEAR_STATUS_CODE = 'O' (open).
The joins on the calendar-relationship and calendar-instance tables are outer joins, so disbursements without a mapped fee calendar still return rows, with START_DT and END_DT null.
Key Columns
- ROW_ID / AWARD_ID / PERSON_ID — identifiers linking the credit back to the disbursement, award, and student.
- DISB_NUM / DISB_DATE — disbursement sequence and effective date.
- DISB_NET_AMT — the net credit amount, the principal monetary measure of the view.
- SHOW_ON_BILL / TRANS_TYPE — filters restricting the view to billable, payment-type ('P') disbursements.
- LD_CAL_TYPE / LD_SEQUENCE_NUMBER — the load calendar instance tied to the disbursement.
- FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER / START_DT / END_DT — the derived fee (superior) calendar context and its date range.
- FUND_CODE / FUND_ID / SUBACCOUNT_ID / CREDIT_TYPE_ID — fund and credit classification used by subledger posting logic.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
The view is typically used to report billable award credits for open award years and to reconcile net disbursements by fund and person. A representative query retrieving net credits for a student is:
SELECT person_id, award_id, disb_num, disb_net_amt, disb_date, fund_code, credit_type_id FROM igs_fi_pln_credits_v WHERE person_id = :person_id ORDER BY disb_date;
Aggregation by fund supports financial-aid cash planning:
SELECT fund_code, SUM(disb_net_amt) FROM igs_fi_pln_credits_v WHERE start_dt BETWEEN :from_dt AND :to_dt GROUP BY fund_code;
Because the view is documented as obsolete and not implemented in the database, these patterns should be validated against the underlying IGF_AW_AWD_DISB and related tables, reproducing the filter conditions (TRANS_TYPE = 'P', SHOW_ON_BILL = 'Y', AWARD_STATUS = 'ACCEPTED', AWARD_YEAR_STATUS_CODE = 'O', and CT.S_CAL_CAT = 'FEE') directly in custom SQL.
-
View: IGS_FI_PLN_CREDITS_V 12.1.1
APPS.IGS_FI_PLN_CREDITS_V·↳ IGF_AP_BATCH_AW_MAP·↳ IGF_AP_FA_BASE_REC·↳ IGF_AW_AWARD·Explore IGS module →
-
View: IGF_SP_FUND_MAST_V 12.1.1
Stores Details and the properties of all the funds
APPS.IGF_SP_FUND_MAST_V·↳ IGF_AP_BATCH_AW_MAP·↳ IGF_AW_FUND_CAT·↳ IGF_AW_FUND_MAST·Explore IGF module →
-
View: IGF_AW_FUND_MAST 12.1.1
APPS.IGF_AW_FUND_MAST·↳ IGF_AW_FUND_MAST_ALL·Explore IGF module →
-
View: IGF_AW_AWD_DISB_V 12.1.1
Stores details of each disbursement
APPS.IGF_AW_AWD_DISB_V·↳ IGF_AW_AWD_DISB·↳ IGF_AW_AWD_RVSN_RSN·↳ IGF_AW_GEN·Explore IGF module →
-
View: IGF_SE_AWD_DISB_V 12.1.1
Retrives all the award disbursement details for the student employment awards
APPS.IGF_SE_AWD_DISB_V·↳ IGF_AW_AWD_DISB_ALL·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_AWD_DISB 12.1.1
APPS.IGF_AW_AWD_DISB·↳ IGF_AW_AWD_DISB_ALL·Explore IGF module →
-
Displays details of each disbursement
-
View: IGF_AW_FUND_MAST_V 12.1.1
Stores all the details and the properties for each fund
APPS.IGF_AW_FUND_MAST_V·↳ HZ_PARTIES·↳ IGF_AW_FUND_CAT·↳ IGF_AW_FUND_MAST·Explore IGF module →
-
Stores all the details and the properties for each fund
-
VIEW: APPS.IGF_SE_AWD_DISB_V 12.1.1
-
View: IGS_FI_PLN_CREDITS_V 12.2.2
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGF_AW_AWD_DISB 12.1.1
-
View: IGF_SE_AWD_DISB_V 12.2.2
Retrives all the award disbursement details for the student employment awards
Not implemented in this database·Explore IGF module →
-
VIEW: APPS.IGF_AW_AWD_DISB_V 12.1.1
-
View: IGF_AW_AWD_DISB 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_AWD_DISB_V 12.2.2
Stores details of each disbursement
Not implemented in this database·Explore IGF module →
-
PACKAGE: APPS.IGF_SP_AWARD 12.1.1
-
View: IGF_AW_FUND_MAST 12.2.2
Not implemented in this database·Explore IGF module →
-
View: IGF_SP_FUND_MAST_V 12.2.2
Stores Details and the properties of all the funds
Not implemented in this database·Explore IGF module →
-
View: IGF_AW_FUND_MAST_V 12.2.2
Stores all the details and the properties for each fund
Not implemented in this database·Explore IGF module →
-
PACKAGE: APPS.IGF_AW_GEN_003 12.1.1
-
VIEW: APPS.IGF_AW_FUND_MAST 12.1.1
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.