eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGFBV_DL_AWARD_DISBURSEMENTS

Object Details

Object Name:	IGFBV_DL_AWARD_DISBURSEMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGFBV_DL_AWARD_DISBURSEMENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Base view for the entity that holds Direct Loan Award Disbursements

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DISBURSEMENT_GROSS_AMT	NUMBER	(12)	Yes	Indicates disbursement gross amount
ORIGINATION_FEE	NUMBER	(12)		Indicates origination fees in case of Direct Loans and CommonLine loans
DISBURSEMENT_DATE	DATE		Yes	Indicates anticipated or actual disbursement date depending upon transaction type
DISBURSEMENT_NET_AMT	NUMBER	(12)	Yes	Indicates disbursement net amount
DISBURSEMENT_ADJUSTMENT_AMT	NUMBER	(12)		Identifies difference in new and previous disbursement net amounts at time of adjustment
_LA:DISBURSEMENT_STATUS	CHAR	(67)		Indicates status of adjustment for particular student availing Direct Loan
DISBURSEMENT_STATUS_DATE	DATE			Indicates the date on which the disbursement status was changed
_LA:DISBURSEMENT_ACTIVITY	CHAR	(67)		Indicates whether disbursement record stands for actual disbursement made, adjustments on disbursement net amount, or changes on disbursement date
DISBURSEMENT_BATCH_ID	VARCHAR2	(40)		Indicates batch identifier of disbursement file, which reported adjustment record. Updated by Direct Loan origination process
DISBURSEMENT_ACK_DATE	DATE			Indicates adjustment record's acknowledgment by LOC in case of Direct Loans. Updated by Direct Loan acknowledgment process
BOOKING_BATCH_ID	VARCHAR2	(40)		Indicates batch identifier of disbursement file, which reports booking notification. Updated by Direct Loan acknowledgment process
BOOKED_DATE	DATE			Indicates booking notification date of adjustment record. Updated by Direct Loan acknowledgment process
LOAN_NUMBER	VARCHAR2	(30)		Unique identifier for the loan
FUND_CODE	VARCHAR2	(30)	Yes	Fund Code
DESCRIPTION	VARCHAR2	(80)		Fund Code Description
_LA:TRANSACTION_TYPE	CHAR	(62)		Indicates if transaction type is planned or actual
INTEREST_REBATE_AMT	NUMBER	(15)		Interest rebate amount as calculated for the loan amount
_LA:AFFIRMATION_FLAG	CHAR	(59)		Indicates whether student has confirmed for disbursement
AWARD_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar Type for Award Calendar
AWARD_YEAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique Sequence Number for Award Calendar
INTERNAL_LOAN_ID	NUMBER	(15)	Yes	Identifier for loans
BASE_ID	NUMBER	(10)	Yes	Unique identifier for student in financial aid
PERSON_ID	NUMBER	(15)	Yes	Unique Person Identifier
AWARD_ID	NUMBER	(15)	Yes	Identifier for awards
DISBURSEMENT_NUMBER	NUMBER	(15)	Yes	Indicates disbursement number
DISBURSEMENT_SEQUENCE_NUMBER	NUMBER	(15)	Yes	Identifies sequence of change to disbursement amount or disbursement date
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DISBURSEMENT_GROSS_AMT
,      ORIGINATION_FEE
,      DISBURSEMENT_DATE
,      DISBURSEMENT_NET_AMT
,      DISBURSEMENT_ADJUSTMENT_AMT
,      _LA:DISBURSEMENT_STATUS
,      DISBURSEMENT_STATUS_DATE
,      _LA:DISBURSEMENT_ACTIVITY
,      DISBURSEMENT_BATCH_ID
,      DISBURSEMENT_ACK_DATE
,      BOOKING_BATCH_ID
,      BOOKED_DATE
,      LOAN_NUMBER
,      FUND_CODE
,      DESCRIPTION
,      _LA:TRANSACTION_TYPE
,      INTEREST_REBATE_AMT
,      _LA:AFFIRMATION_FLAG
,      AWARD_CALENDAR_TYPE
,      AWARD_YEAR_SEQUENCE_NUMBER
,      INTERNAL_LOAN_ID
,      BASE_ID
,      PERSON_ID
,      AWARD_ID
,      DISBURSEMENT_NUMBER
,      DISBURSEMENT_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_DL_AWARD_DISBURSEMENTS;

Dependencies

[top of page]

APPS.IGFBV_DL_AWARD_DISBURSEMENTS references the following:

APPS: IGF_AP_FA_BASE_REC_ALL; IGF_AW_AWARD_ALL; IGF_AW_AWD_DISB_ALL; IGF_AW_FUND_CAT_ALL; IGF_AW_FUND_MAST_ALL; IGF_DB_AWD_DISB_DTL_ALL; IGF_SL_AWD_DISB_LOC_ALL; IGF_SL_LOANS_ALL

APPS.IGFBV_DL_AWARD_DISBURSEMENTS is not referenced by any database object