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_STUDENT_BASE_RECORDS

Object Details

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

View Type

A Business Intelligence System view

Base View for the Entity that holds the summarized information of all the financial aid processes for a student for an academic year

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_YEAR_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Indicates code for award year calendar type.
AWARD_YEAR_CAL_SEQ_NUMBER	NUMBER	(6)	Yes	Indicates unique identifier for award year calendar instance
FEDERAL_EFC_AMOUNT	NUMBER	(10)		Denotes student's EFC as per calculations made by federal methodology
INSTITUTIONAL_EFC_AMOUNT	NUMBER	(10)		Denotes student's EFC as per calculations made by institutional methodology
FEDERAL_NEED_AMOUNT	NUMBER	(10)		Denotes need calculated as per federal method
INSTITUTIONAL_NEED_AMOUNT	NUMBER	(10)		Denotes need calculated as per institutional method
_LA:VERIFICATION_PROCESS_RUN	CHAR	(72)		Lookup tag to indicate whether verification selection process has been run on financial aid base record
INST_VERIFICATION_STATUS_DATE	DATE			Indicates date on which institutional verification flag is set
_LA:FEDERAL_VERIF_STATUS	CHAR	(72)		Lookup tag to indicate whether selected for federal verification process
FEDERAL_VERIF_STATUS_DATE	DATE			Date when federal verification status is set
_LA:INSTITUTION_VERIF_STATUS	CHAR	(74)		Lookup tag to indicate whether selected for institutional verification
NSLDS_ELIGIBLE_FLAG	VARCHAR2	(30)		Indicates eligibility for nslds loans
EDE_CORRECTION_BATCH_ID	VARCHAR2	(25)		Denotes electronic data exchange correction batch identifier
FA_PROCESS_STATUS_DATE	DATE			Denotes date of overall processing status of financial aid record
_LA:ISIR_CORRECTION_STATUS	CHAR	(66)		Lookup tag to indicate status of corrections made to payment isir indicated on financial aid base record
ISIR_CORRECTION_STATUS_DATE	DATE			Denotes date on which correction status for payment isir is updated
_LA:ISIR_STATUS	CHAR	(61)		Lookup tag to indicate status of payment isir
ISIR_STATUS_DATE	DATE			Denotes date on which isir status was set
PROFILE_STATUS	VARCHAR2	(30)		Stores the status of profile record added for the student
PROFILE_STATUS_DATE	DATE			Stores the date on which the status of profile record added for the student
PROFILE_FAMILY_CONTRIBUTION	NUMBER	(15)		Holds the family contribution from profile records
COA_FIXED_AMOUNT	NUMBER	(12)		Denotes cost of attendance for fixed items
COA_FEDERAL_AMOUNT	NUMBER	(12)		Denotes cost of attendance for student calculated as per federal methodology
COA_INSTITUTIONAL_AMOUNT	NUMBER	(12)		Denotes cost of attendance for student calculated as per institutional methodology
COA_PELL_AMOUNT	NUMBER	(12)		Denotes cost of attendance for pell grant
DISBURSEMENT_HOLD	VARCHAR2	(30)		Indicates whether disbursements are to be put on hold
_LA:FA_PROCESS_STATUS	CHAR	(74)		Lookup tag to indicate overall processing status of financial aid student
_LA:NOTIFICATION_STATUS	CHAR	(73)		Lookup tag to indicate status of award notification
NOTIFICATION_STATUS_DATE	DATE			Indicates date on which award notification status was set
_LA:NSLDS_DATA_OVERRIDE_FLAG	CHAR	(71)		Lookup tag to indicate whether student data mentioned in nslds files can be overridden at time of loan processing
_LA:PACKAGING_STATUS	CHAR	(71)		Lookup tag to indicate packaging status
PACKAGING_STATUS_DATE	DATE			Indicates date on which packaging status was set
PAYMENT_ISIR_ID	NUMBER	(15)		Indicates isir identifier that is marked for consideration in packaging process
TARGET_GROUP	VARCHAR2	(30)		Indicates cost of attendance group to which student belongs
TOTAL_PACKAGE_ACCEPTED_AMOUNT	NUMBER	(11)		Indicates total package accepted
TOTAL_PACKAGE_OFFERED_AMOUNT	NUMBER	(11)		Indicates total package offered
TOLERANCE_AMOUNT	NUMBER	(15)		Indicates extent to which any difference in isir amount and verification amount is ignored
_LA:MANUAL_DISBURSEMENT_HOLD	CHAR	(64)		Lookup tag to indicate whether the hold disbursement for manual re-award checkbox is checked or not
PELL_ALTERNATE_EXPENSE	NUMBER	(15)		Alternate pell expense calculated for the student
ASSOCIATED_ORGANIZATION_UNIT	NUMBER			Associated Organization Unit for a Person in an Award Year
_LA:AWARD_FMLY_CONTRIB_TYPE	CHAR	(93)		To identify whether the Family contribution is Primary or Secondary EFC Type
_DF	CHAR	(40)		Descriptive flex field qualifier
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Person identifier
BASE_ID	NUMBER	(10)	Yes	Unique identifier for student Financial Aid 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 AWARD_YEAR_CALENDAR_TYPE
,      AWARD_YEAR_CAL_SEQ_NUMBER
,      FEDERAL_EFC_AMOUNT
,      INSTITUTIONAL_EFC_AMOUNT
,      FEDERAL_NEED_AMOUNT
,      INSTITUTIONAL_NEED_AMOUNT
,      _LA:VERIFICATION_PROCESS_RUN
,      INST_VERIFICATION_STATUS_DATE
,      _LA:FEDERAL_VERIF_STATUS
,      FEDERAL_VERIF_STATUS_DATE
,      _LA:INSTITUTION_VERIF_STATUS
,      NSLDS_ELIGIBLE_FLAG
,      EDE_CORRECTION_BATCH_ID
,      FA_PROCESS_STATUS_DATE
,      _LA:ISIR_CORRECTION_STATUS
,      ISIR_CORRECTION_STATUS_DATE
,      _LA:ISIR_STATUS
,      ISIR_STATUS_DATE
,      PROFILE_STATUS
,      PROFILE_STATUS_DATE
,      PROFILE_FAMILY_CONTRIBUTION
,      COA_FIXED_AMOUNT
,      COA_FEDERAL_AMOUNT
,      COA_INSTITUTIONAL_AMOUNT
,      COA_PELL_AMOUNT
,      DISBURSEMENT_HOLD
,      _LA:FA_PROCESS_STATUS
,      _LA:NOTIFICATION_STATUS
,      NOTIFICATION_STATUS_DATE
,      _LA:NSLDS_DATA_OVERRIDE_FLAG
,      _LA:PACKAGING_STATUS
,      PACKAGING_STATUS_DATE
,      PAYMENT_ISIR_ID
,      TARGET_GROUP
,      TOTAL_PACKAGE_ACCEPTED_AMOUNT
,      TOTAL_PACKAGE_OFFERED_AMOUNT
,      TOLERANCE_AMOUNT
,      _LA:MANUAL_DISBURSEMENT_HOLD
,      PELL_ALTERNATE_EXPENSE
,      ASSOCIATED_ORGANIZATION_UNIT
,      _LA:AWARD_FMLY_CONTRIB_TYPE
,      _DF
,      PERSON_IDENTIFIER
,      BASE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_STUDENT_BASE_RECORDS;

Dependencies

[top of page]

APPS.IGFBV_STUDENT_BASE_RECORDS references the following:

APPS: IGF_AP_FA_BASE_REC_ALL

APPS.IGFBV_STUDENT_BASE_RECORDS is not referenced by any database object