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_AWARD_DISBURSEMENTS

Object Details

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

View Type

A Business Intelligence System view

Base View for the Entity that holds the information of each disbursement.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_ID	NUMBER	(15)	Yes	Identifier for awards
DISBURSEMENT_NUMBER	NUMBER	(15)	Yes	Identifier for disbursements
DISBURSEMENT_GROSS_AMOUNT	NUMBER		Yes	Gross amount of the disbursement ( This will be the same as the offered amount )
DL_FFELP_ORIGINATION_FEE	NUMBER			Origination fees in case of Direct Loan lender fees or CommonLine
FFELP_GUARANTEE_FEE	NUMBER			Guarantor fees in case of CommonLine
DISBURSEMENT_NET_AMOUNT	NUMBER		Yes	Disbursement net amount( DISB_GROSS_AMT - FEE_1 - FEE_2 + FEE_PAID_1 + FEE_PAID_2)
DISBURSEMENT_DATE	DATE		Yes	Disbursement date
_LA:TRANSACTION_TYPE	CHAR	(61)		Indicates if transaction type is planned or actual
_LA:ELIGIBILITY_STATUS	CHAR	(63)		Indicates student's eligibility status at time of disbursement
ELIGIBILITY_STATUS_DATE	DATE			Indicates date on which eligibility check was done
_LA:AFFIRMATION_FLAG	CHAR	(58)		Indicates whether student has confirmed for disbursement
_LA:HOLD_RELEASE_INDICATOR	CHAR	(71)		Indicates hold or release for disbursement
_LA:MANUAL_HOLD_INDICATOR	CHAR	(62)		Used by disbursements to hold up disbursements
DISBURSEMENT_STATUS	VARCHAR2	(30)		Indicates disbursement status for CommonLine loans
DISBURSEMENT_STATUS_DATE	DATE			Disbursement status date
_LA:LATE_DISBURSE_INDICATOR	CHAR	(60)		Indicates when disbursement is issued. Updated from CommonLine roster file
_LA:FUND_DISBURSEMENT_METHOD	CHAR	(75)		Indicates method used to release funds. Updated from CommonLine roster file
_LA:PREV_REPORTED_INDICATOR	CHAR	(64)		Indicates if disbursement was indicated on previous disbursement roster
FUND_RELEASE_DATE	DATE			Indicates date on which funds are released to school
_LA:FUND_STATUS	CHAR	(69)		Indicates whether funds have been transferred for disbursement. Updated from CommonLine roster file.
FUND_STATUS_DATE	DATE			Date on which disbursement roster was updated
ORIGINATION_FEE_PAID	NUMBER			Origination fees paid
GUARANTEE_FEE_PAID	NUMBER			Guarantee fees paid
CHECK_NUMBER	VARCHAR2	(30)		Check number
DISBURSEMENT_ACCEPTED_AMOUNT	NUMBER	(13)		Disbursement Accepted Amount
DISBURSEMENT_PAID_AMOUNT	NUMBER	(13)		Disbursement Paid amount
INTEREST_REBATE_AMOUNT	NUMBER	(15)		Interest rebate amount as calculated for the loan amount
_LA:FORCE_DISBURSEMENT_FLAG	CHAR	(57)		Indicates if the disbursement was forced.
CUMULATIVE_CREDIT_POINTS	NUMBER	(7)		Indicates the minimum credit point requirement for the disbursement
DISBURSEMENT_EXPIRATION_DATE	DATE			Indicates the date on which the disbursement will expire
VERIFICATION_ENFORCEMENT_DATE	DATE			Indicates the date on which the verification should be enforced
NOTIFICATION_SENT_FLAG	VARCHAR2	(0)		No longer used.
NOTIFICATION_DATE	VARCHAR2	(0)		No longer used.
AUTHORIZATION_DATE	VARCHAR2	(0)		No longer used.
_LA:PAYS_ONLY_FEE_CLASS	CHAR	(53)		Pays only fee class
_LA:INCLUD_AS_PLANNED_CREDIT	CHAR	(59)		Indicates if the notification should be shown on the bill.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Unique identification number
PERSON_NAME	VARCHAR2	(360)	Yes	Person's name
AWARD_YEAR	VARCHAR2	(10)		Alternate short reference code for identifying a Load calendar instance
AWARD_YEAR_DESCRIPTION	VARCHAR2	(30)		Description for the Calendar Instance
REVISION_REASON	NUMBER	(15)		Revision Code referenced from Revision Table
AUTHORIZATION_ID	NUMBER	(15)		Unique Authorization Identifier. Authorization is a set of information of the student sent in context of student work-study. There will be one authorization sent for a student, award of type FWS and Term.
TEACH_PERD_CALENDAR_TYPE	VARCHAR2	(10)		Indicates code for teaching period calendar type. Used within operating unit
TEACH_PERD_SEQUENCE_NUMBER	NUMBER	(6)		Indicates unique identifier for teaching calendar instance
LOAD_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar type for the Term
LOAD_CALENDAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Term / Load calendar sequence number
CREATED_BY	NUMBER	(15)	Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column
LAST_UPDATE_DATE	DATE		Yes	WHO column
PERSON_ID	NUMBER	(15)	Yes	Person identifier

Query Text

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


SELECT AWARD_ID
,      DISBURSEMENT_NUMBER
,      DISBURSEMENT_GROSS_AMOUNT
,      DL_FFELP_ORIGINATION_FEE
,      FFELP_GUARANTEE_FEE
,      DISBURSEMENT_NET_AMOUNT
,      DISBURSEMENT_DATE
,      _LA:TRANSACTION_TYPE
,      _LA:ELIGIBILITY_STATUS
,      ELIGIBILITY_STATUS_DATE
,      _LA:AFFIRMATION_FLAG
,      _LA:HOLD_RELEASE_INDICATOR
,      _LA:MANUAL_HOLD_INDICATOR
,      DISBURSEMENT_STATUS
,      DISBURSEMENT_STATUS_DATE
,      _LA:LATE_DISBURSE_INDICATOR
,      _LA:FUND_DISBURSEMENT_METHOD
,      _LA:PREV_REPORTED_INDICATOR
,      FUND_RELEASE_DATE
,      _LA:FUND_STATUS
,      FUND_STATUS_DATE
,      ORIGINATION_FEE_PAID
,      GUARANTEE_FEE_PAID
,      CHECK_NUMBER
,      DISBURSEMENT_ACCEPTED_AMOUNT
,      DISBURSEMENT_PAID_AMOUNT
,      INTEREST_REBATE_AMOUNT
,      _LA:FORCE_DISBURSEMENT_FLAG
,      CUMULATIVE_CREDIT_POINTS
,      DISBURSEMENT_EXPIRATION_DATE
,      VERIFICATION_ENFORCEMENT_DATE
,      NOTIFICATION_SENT_FLAG
,      NOTIFICATION_DATE
,      AUTHORIZATION_DATE
,      _LA:PAYS_ONLY_FEE_CLASS
,      _LA:INCLUD_AS_PLANNED_CREDIT
,      PERSON_NUMBER
,      PERSON_NAME
,      AWARD_YEAR
,      AWARD_YEAR_DESCRIPTION
,      REVISION_REASON
,      AUTHORIZATION_ID
,      TEACH_PERD_CALENDAR_TYPE
,      TEACH_PERD_SEQUENCE_NUMBER
,      LOAD_CALENDAR_TYPE
,      LOAD_CALENDAR_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PERSON_ID
FROM APPS.IGFBV_AWARD_DISBURSEMENTS;

Dependencies

[top of page]

APPS.IGFBV_AWARD_DISBURSEMENTS references the following:

APPS: HZ_PARTIES; IGF_AP_FA_BASE_REC_ALL; IGF_AW_AWARD_ALL; IGF_AW_AWD_DISB_ALL; IGS_CA_INST_ALL

APPS.IGFBV_AWARD_DISBURSEMENTS is not referenced by any database object