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_PELL_YTD_DISBURSEMENTS

Object Details

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

View Type

A Business Intelligence System view

Base View for the Entity that holds the information about the year to date disbursement data

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INST_CROSS_REF_CODE	VARCHAR2	(30)		Contains cross reference information useful to institution for internally identifying student records
_LA:ACTION_CODE	CHAR	(65)		Lookup tag for Code indicating action to be taken
DISBURSEMENT_REFERENCE_NUMBER	VARCHAR2	(30)	Yes	Number of disbursement
DISBURSEMENT_ACCPTED_AMOUNT	NUMBER	(12)	Yes	Amount of disbursement for student
DEBIT_CREDIT_FLAG	VARCHAR2	(1)		Indicates if disbursement amount is positive or negative
DISBURSEMENT_DATE	DATE			Date disbursement is made to student
PAYMENT_PERD_START_DATE	DATE		Yes	Begin date of payment period
DISBURSEMENT_BATCH_ID	VARCHAR2	(30)		Number generated by institution to identify batch of disbursement records
ORIGINATION_ID	NUMBER		Yes	Unique code for each origination
YTDDS_ID	VARCHAR2	(30)		Identifier for each year to date origination record
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

Query Text

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


SELECT INST_CROSS_REF_CODE
,      _LA:ACTION_CODE
,      DISBURSEMENT_REFERENCE_NUMBER
,      DISBURSEMENT_ACCPTED_AMOUNT
,      DEBIT_CREDIT_FLAG
,      DISBURSEMENT_DATE
,      PAYMENT_PERD_START_DATE
,      DISBURSEMENT_BATCH_ID
,      ORIGINATION_ID
,      YTDDS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_PELL_YTD_DISBURSEMENTS;

Dependencies

[top of page]

APPS.IGFBV_PELL_YTD_DISBURSEMENTS references the following:

APPS: IGF_GR_YTD_DISB_ALL

APPS.IGFBV_PELL_YTD_DISBURSEMENTS is not referenced by any database object