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_STUDENT_FWS_AWAD_DETAILS

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds Student Work Study Award Details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DISBURSEMENT_OFFERED_AMOUNT	NUMBER		Yes	Gross amount of the disbursement ( This will be the same as the offered amount )
DISBURSEMENT_ACCEPTED_AMOUNT	NUMBER	(13)		Disbursement Accepted Amount
LOAD_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar type for the Term
LOAD_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Term / Load calendar sequence number
LIMIT_NOTIFICATION_SENT	VARCHAR2	(1)		Indicates whether a Notification was sent for the fund, in this term for the student. A Notification is sent when the student's paid amount for the term increases the threshold as set for the Fund.
LIMIT_NOTIFICATION_SENT_DATE	DATE			Date on which Notification was sent. A Notification is sent when the student's paid amount for the term increases the threshold as set for the Fund.
DISBURSEMENT_REMAINING_AMOUNT	NUMBER			Remaining amount to be paid
DISBURSEMENT_EARNED_TILL_DATE	NUMBER	(13)		Disbursement Paid amount
TOTAL_PERCENT_EARNED_LIMIT	NUMBER			Percentage of amount paid
AUTHORIZATION_DATE	DATE			Date on which the Authorization was created or updated
AWARD_YEAR	VARCHAR2	(10)		Awarding Year
LOAD_CALENDAR	VARCHAR2	(10)		Load Calendar
FUND_CODE	VARCHAR2	(30)	Yes	Fund Code
FUND_DESCRIPTION	VARCHAR2	(80)		Fund Code Description
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
AWARD_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Indicates code for award year calendar type. Used within operating unit
AWARD_YEAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates unique identifier for award year calendar instance
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
PERSON_ID	NUMBER	(15)	Yes	Person identifier
BASE_ID	NUMBER	(10)	Yes	Unique identifier for student financial aid record
FUND_ID	NUMBER	(15)	Yes	Unique identifier for the fund
AWARD_ID	NUMBER	(15)	Yes	Identifier for awards
DISBURSEMENT_NUMBER	NUMBER	(15)	Yes	Identifier for disbursements
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_OFFERED_AMOUNT
,      DISBURSEMENT_ACCEPTED_AMOUNT
,      LOAD_CALENDAR_TYPE
,      LOAD_SEQUENCE_NUMBER
,      LIMIT_NOTIFICATION_SENT
,      LIMIT_NOTIFICATION_SENT_DATE
,      DISBURSEMENT_REMAINING_AMOUNT
,      DISBURSEMENT_EARNED_TILL_DATE
,      TOTAL_PERCENT_EARNED_LIMIT
,      AUTHORIZATION_DATE
,      AWARD_YEAR
,      LOAD_CALENDAR
,      FUND_CODE
,      FUND_DESCRIPTION
,      PERSON_NUMBER
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      AWARD_CALENDAR_TYPE
,      AWARD_YEAR_SEQUENCE_NUMBER
,      AUTHORIZATION_ID
,      PERSON_ID
,      BASE_ID
,      FUND_ID
,      AWARD_ID
,      DISBURSEMENT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS;

Dependencies

[top of page]

APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS 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; IGS_CA_INST_ALL

APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS is not referenced by any database object