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.IGFFV_FFELP_AWD_DISBURSEMENTS

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds FFELP Loan 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
GUARANTEE_FEE	NUMBER	(12)		Indicates guarantor fees in case of CommonLine loans
ORIGINATION_FEE_PAID	NUMBER	(12)		Indicates origination fees paid
GUARANTEE_FEE_PAID	NUMBER	(12)		Indicates guarantee fees paid
DISBURSEMENT_DATE	DATE		Yes	Indicates anticipated or actual disbursement date depending upon transaction type
DISBURSEMENT_NET_AMT	NUMBER	(12)	Yes	Indicates disbursement net amount
_LA:TRANSACTION_TYPE	CHAR	(62)		Indicates if transaction type is planned or actual
_LA:FUND_STATUS	CHAR	(70)		Indicates whether funds have been transferred for disbursement. Updated from CommonLine roster file
_LA:DISBURSEMENT_STATUS	CHAR	(67)		Indicates disbursement status for CommonLine loans
_LA:HOLD_RELEASE_INDICATOR	CHAR	(72)		Indicates hold or release for disbursement
_LA:FUND_DISTRIBUTION_TYPE	CHAR	(76)		Indicates method used to release funds. Updated from CommonLine roster file
_LA:PREVIOUS_REPORTED_IND	CHAR	(65)		Indicates if disbursement was indicated on previous disbursement roster
DISBURSEMENT_STATUS_DATE	DATE			Disbursement status date
LATE_DISBURSEMENT_INDICATOR	VARCHAR2	(30)		Indicates when disbursement is issued. Updated from CommonLine roster file
CHEQUE_NUMBER	VARCHAR2	(30)		Check number
LOAN_NUMBER	VARCHAR2	(30)		Unique identifier for the loan
AWARD_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar Type for Award Calendar
AWARD_YEAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique Sequence Number for Award Calendar
AWARD_YEAR	VARCHAR2	(10)		Awarding Year
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
FIRST_NAME	VARCHAR2	(150)		Person First Name
LAST_NAME	VARCHAR2	(150)		Person Last Name
MIDDLE_NAME	VARCHAR2	(60)		Person Middle Name
FUND_CODE	VARCHAR2	(30)	Yes	Fund Code
DESCRIPTION	VARCHAR2	(80)		Fund Code Description
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	Person Identifier
AWARD_ID	NUMBER	(15)	Yes	Identifier for awards
DISBURSEMENT_NUMBER	NUMBER	(15)	Yes	Indicates disbursement number
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
,      GUARANTEE_FEE
,      ORIGINATION_FEE_PAID
,      GUARANTEE_FEE_PAID
,      DISBURSEMENT_DATE
,      DISBURSEMENT_NET_AMT
,      _LA:TRANSACTION_TYPE
,      _LA:FUND_STATUS
,      _LA:DISBURSEMENT_STATUS
,      _LA:HOLD_RELEASE_INDICATOR
,      _LA:FUND_DISTRIBUTION_TYPE
,      _LA:PREVIOUS_REPORTED_IND
,      DISBURSEMENT_STATUS_DATE
,      LATE_DISBURSEMENT_INDICATOR
,      CHEQUE_NUMBER
,      LOAN_NUMBER
,      AWARD_CALENDAR_TYPE
,      AWARD_YEAR_SEQUENCE_NUMBER
,      AWARD_YEAR
,      PERSON_NUMBER
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      FUND_CODE
,      DESCRIPTION
,      INTERNAL_LOAN_ID
,      BASE_ID
,      PERSON_ID
,      AWARD_ID
,      DISBURSEMENT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_FFELP_AWD_DISBURSEMENTS;

Dependencies

[top of page]

APPS.IGFFV_FFELP_AWD_DISBURSEMENTS references the following:

APPS: HZ_PARTIES; 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_SL_AWD_DISB_LOC_ALL; IGF_SL_LOANS_ALL; IGS_CA_INST_ALL

APPS.IGFFV_FFELP_AWD_DISBURSEMENTS is not referenced by any database object