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_FFELP_REJECTS

Object Details

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

View Type

A Business Intelligence System view

Base view for the entity that holds Financial Aid FFELP Rejects

[View Source]

Columns

Name	Datatype	Length	Comments
LOAN_NUMBER	VARCHAR2	(30)	Indicates loan identification number for loan, for which errors have occurred
_LA:ORIGINATION_CHANGE_CODE	CHAR	(73)	Indicates origination change code. Values are edits while sending or originating loan, edits from loan origination response file, edits while processing loan changes, or edits from loan change response file
_LA:REJECT_ERROR_CODE	VARCHAR2	(64)	Indicates reject codes from loan origination center or external processor
_LA:REJECTED_FIELD_NAME	CHAR	(63)	Indicates field name for which error occurred
REJECTED_FIELD_VALUE	VARCHAR2	(4000)	Indicates value contained in field
ACCEPTED_LOAN_AMOUNT	NUMBER	(12)	Total award amount accepted
LOAN_PERIOD_BEGIN_DATE	DATE		Indicates loan period start date
LOAN_PERIOD_END_DATE	DATE		Indicates loan period end date
_LA:LOAN_RECORD_STATUS	CHAR	(65)	Indicates loan status
LOAN_STATUS_DATE	DATE		Indicates date on which loan status changed
LOAN_IS_ACTIVE	VARCHAR2	(1)	Indicator that specifies whether loan is active. Setting check box to inactive prevents use of loan in new or modified records
LOAN_IS_ACTIVE_DATE	DATE		Indicates date on which loan was activated or inactivated
AWARD_CALENDAR_TYPE	VARCHAR2	(10)	Indicates code for award year calendar type. Used within operating unit
AWARD_YEAR_SEQUENCE_NUMBER	NUMBER	(6)	Indicates unique identifier for award year calendar instance
INTERNAL_LOAN_ID	NUMBER	(15)	Identifier for the loan
BASE_ID	NUMBER	(10)	Unique identifier for student financial aid record
PERSON_ID	NUMBER	(15)	Person Identifier
EDIT_RECORD_ID	NUMBER	(15)	Identifier for edit records
CREATED_BY	NUMBER	(15)	Standard WHO column
CREATION_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column

Query Text

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


SELECT LOAN_NUMBER
,      _LA:ORIGINATION_CHANGE_CODE
,      _LA:REJECT_ERROR_CODE
,      _LA:REJECTED_FIELD_NAME
,      REJECTED_FIELD_VALUE
,      ACCEPTED_LOAN_AMOUNT
,      LOAN_PERIOD_BEGIN_DATE
,      LOAN_PERIOD_END_DATE
,      _LA:LOAN_RECORD_STATUS
,      LOAN_STATUS_DATE
,      LOAN_IS_ACTIVE
,      LOAN_IS_ACTIVE_DATE
,      AWARD_CALENDAR_TYPE
,      AWARD_YEAR_SEQUENCE_NUMBER
,      INTERNAL_LOAN_ID
,      BASE_ID
,      PERSON_ID
,      EDIT_RECORD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_FFELP_REJECTS;

Dependencies

[top of page]

APPS.IGFBV_FFELP_REJECTS references the following:

APPS: IGF_AP_FA_BASE_REC_ALL; IGF_AW_AWARD_ALL; IGF_AW_FUND_CAT_ALL; IGF_AW_FUND_MAST_ALL; IGF_SL_EDIT_REPORT_ALL; IGF_SL_LOANS_ALL

APPS.IGFBV_FFELP_REJECTS is not referenced by any database object