R_FANLTR_BDGT (SQL Table)	Index Back
Work Table - FAN Budget Data This records holds the budget data that is printed on the student's award notification letter.

R_FANLTR_BDGT

(SQL Table)

Work Table - FAN Budget Data

This records holds the budget data that is printed on the student's award notification letter.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

3 PELL_CATEGORY Character(1) VARCHAR2(1) NOT NULL Pell Category
B=Books and Supplies
C=Dependent Child Care
D=Disability Expenses
F=Student Activities Fees
H=Housing
L=Loan Fees
P=Personal/Miscellaneous
S=Transportation
T=Tuition

4 BUDGET_ITEM_AMOUNT Number(8,2) DECIMAL(7,2) NOT NULL Budget Item Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
3	PELL_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Pell Category B=Books and Supplies C=Dependent Child Care D=Disability Expenses F=Student Activities Fees H=Housing L=Loan Fees P=Personal/Miscellaneous S=Transportation T=Tuition
4	BUDGET_ITEM_AMOUNT	Number(8,2)	DECIMAL(7,2) NOT NULL	Budget Item Amount