FANLTR_DEFAULTS (SQL Table)	Index Back
Award Letter Defaults Financial Aid Award Notification Letter Run Control Default values.

FANLTR_DEFAULTS

(SQL Table)

Award Letter Defaults

Financial Aid Award Notification Letter Run Control Default values.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Prompt Table: AID_YEAR_TBL

3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine

4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_TBL

5 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage
Prompt Table: ADDR_USAGE_TBL

6 AID_APP_STATUS Character(1) VARCHAR2(1) NOT NULL Aid Application Status
A=Application Active for All Aid
C=Application Canceled
R=Apply for Restricted Aid Only

7 AWARD_STATUS Character(1) VARCHAR2(1) NOT NULL Award Status
A=Accepted
C=Cancelled
D=Declined
O=Offered

8 DISP_COA_ONLY Character(1) VARCHAR2(1) NOT NULL Display COA Only Display Cost Of Attendance Only a Y/N field indicating whether or not to display cost of attendance only.
Y/N Table Edit
Default Value: N

9 DISP_CUST_MSGS Character(1) VARCHAR2(1) NOT NULL Display Customized Messages a Y/N field indicating whether or not to display customized messages.
Y/N Table Edit
Default Value: N

10 DISP_FORM_NAME Character(1) VARCHAR2(1) NOT NULL Display Form Name Y - Do display the Form Name. N - Do not display the Form Name.
Y/N Table Edit
Default Value: N

11 DISP_NOTIF_NBR Character(1) VARCHAR2(1) NOT NULL Display Notification Number a Y/N field indicating whether or not to display the notification number.
Y/N Table Edit
Default Value: N

12 EQUATION_NAME Character(12) VARCHAR2(12) NOT NULL Equation Name
Prompt Table: FANLTR_EQTN_SEL

13 FANLTR_FORM_TYPE Number(9,0) DECIMAL(9) NOT NULL Fin Aid Award Notification Form Type
Prompt Table: FANLTR_FORM_TYP

14 INCLUDE_REVISIONS Character(1) VARCHAR2(1) NOT NULL Include Revisions a Y/N field indicating whether or not to include revisions.
Y/N Table Edit
Default Value: N

15 METHODOLOGY Character(2) VARCHAR2(2) NOT NULL Packaging Methodology
FM=Federal Methodology
IM=Institutional Methodology

16 NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Name Usage
Prompt Table: NAME_USAGE_VW

17 PACKAGING_METHOD Character(1) VARCHAR2(1) NOT NULL Aid Packaging Method
0=Not Packaged
5=Auto Packaged
9=Counselor Packaged

18 PKG_AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Package Plan Award Period
A=Academic
B=Both Academic & Non Std
N=Non Standard

19 PRINT_CANCELS Character(1) VARCHAR2(1) NOT NULL Print Cancels Y - Do print cancels N - Don't print cancels.
Y/N Table Edit
Default Value: N

20 PRINT_DECLINES Character(1) VARCHAR2(1) NOT NULL Print Declines Y - Do print declines. N - Don't print declines.
Y/N Table Edit
Default Value: N

21 PROCESSING_STATUS Character(1) VARCHAR2(1) NOT NULL Aid Package Processing Status
0=No Electronic Application
1=Applied
2=Ready For Counselor Review
3=Ready for Packaging
4=Repackage
9=Packaging Completed

22 RETENTION_PERIOD Number(9,0) DECIMAL(9) NOT NULL Retention Period how many of the retention units worth of time should the subject be retained. An expiration date can be calculated from that.

23 RETENTION_UNITS Character(1) VARCHAR2(1) NOT NULL Retention Units - units of the retention period.
D=Days
M=Months
Y=Years

24 RUN_SIMULATION Character(1) VARCHAR2(1) NOT NULL Run Simulation Y/N field indicating whether to run a simulation.
Y/N Table Edit
Default Value: N

25 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact
Prompt Table: SRVC_IMPACT_TBL

26 SORT_NAME Character(18) VARCHAR2(18) NOT NULL Sort Name is the name of a sort order.
Prompt Table: SORT_NAME_TBL

27 FAN_BUDGET_TYPE Character(1) VARCHAR2(1) NOT NULL Fin Aid Award Notification Letter Budget Type Indicates how the budget will be formatted on the award notification.
B=Budget Categories
P=Pell Categories

28 PRINTER_NAME Character(127) VARCHAR2(127) NOT NULL Printer Name
Prompt Table: PRINTER_TBL

29 DUPLEX Character(1) VARCHAR2(1) NOT NULL Duplex - print both sides
Y/N Table Edit
Default Value: Y

30 PRINT_VIA_SCRIPT Character(1) VARCHAR2(1) NOT NULL Boolean to indicate whether or not to print via a script, as opposed to printing directly to the printer.
Y/N Table Edit
Default Value: N

31 SFA_DISPLAY_NID Character(1) VARCHAR2(1) NOT NULL Display National ID
Y/N Table Edit
Default Value: N

32 SFA_DTTM_FMT_OVRD Character(100) VARCHAR2(100) NOT NULL Override the date time format that will be used by the function Date Time To Localized String.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Prompt Table: AID_YEAR_TBL
3	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_TBL
5	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Address Usage Prompt Table: ADDR_USAGE_TBL
6	AID_APP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Aid Application Status A=Application Active for All Aid C=Application Canceled R=Apply for Restricted Aid Only
7	AWARD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Award Status A=Accepted C=Cancelled D=Declined O=Offered
8	DISP_COA_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Display COA Only Display Cost Of Attendance Only a Y/N field indicating whether or not to display cost of attendance only. Y/N Table Edit Default Value: N
9	DISP_CUST_MSGS	Character(1)	VARCHAR2(1) NOT NULL	Display Customized Messages a Y/N field indicating whether or not to display customized messages. Y/N Table Edit Default Value: N
10	DISP_FORM_NAME	Character(1)	VARCHAR2(1) NOT NULL	Display Form Name Y - Do display the Form Name. N - Do not display the Form Name. Y/N Table Edit Default Value: N
11	DISP_NOTIF_NBR	Character(1)	VARCHAR2(1) NOT NULL	Display Notification Number a Y/N field indicating whether or not to display the notification number. Y/N Table Edit Default Value: N
12	EQUATION_NAME	Character(12)	VARCHAR2(12) NOT NULL	Equation Name Prompt Table: FANLTR_EQTN_SEL
13	FANLTR_FORM_TYPE	Number(9,0)	DECIMAL(9) NOT NULL	Fin Aid Award Notification Form Type Prompt Table: FANLTR_FORM_TYP
14	INCLUDE_REVISIONS	Character(1)	VARCHAR2(1) NOT NULL	Include Revisions a Y/N field indicating whether or not to include revisions. Y/N Table Edit Default Value: N
15	METHODOLOGY	Character(2)	VARCHAR2(2) NOT NULL	Packaging Methodology FM=Federal Methodology IM=Institutional Methodology
16	NAME_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Name Usage Prompt Table: NAME_USAGE_VW
17	PACKAGING_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Aid Packaging Method 0=Not Packaged 5=Auto Packaged 9=Counselor Packaged
18	PKG_AWARD_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Package Plan Award Period A=Academic B=Both Academic & Non Std N=Non Standard
19	PRINT_CANCELS	Character(1)	VARCHAR2(1) NOT NULL	Print Cancels Y - Do print cancels N - Don't print cancels. Y/N Table Edit Default Value: N
20	PRINT_DECLINES	Character(1)	VARCHAR2(1) NOT NULL	Print Declines Y - Do print declines. N - Don't print declines. Y/N Table Edit Default Value: N
21	PROCESSING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Aid Package Processing Status 0=No Electronic Application 1=Applied 2=Ready For Counselor Review 3=Ready for Packaging 4=Repackage 9=Packaging Completed
22	RETENTION_PERIOD	Number(9,0)	DECIMAL(9) NOT NULL	Retention Period how many of the retention units worth of time should the subject be retained. An expiration date can be calculated from that.
23	RETENTION_UNITS	Character(1)	VARCHAR2(1) NOT NULL	Retention Units - units of the retention period. D=Days M=Months Y=Years
24	RUN_SIMULATION	Character(1)	VARCHAR2(1) NOT NULL	Run Simulation Y/N field indicating whether to run a simulation. Y/N Table Edit Default Value: N
25	SERVICE_IMPACT	Character(5)	VARCHAR2(5) NOT NULL	Service Impact Prompt Table: SRVC_IMPACT_TBL
26	SORT_NAME	Character(18)	VARCHAR2(18) NOT NULL	Sort Name is the name of a sort order. Prompt Table: SORT_NAME_TBL
27	FAN_BUDGET_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Fin Aid Award Notification Letter Budget Type Indicates how the budget will be formatted on the award notification. B=Budget Categories P=Pell Categories
28	PRINTER_NAME	Character(127)	VARCHAR2(127) NOT NULL	Printer Name Prompt Table: PRINTER_TBL
29	DUPLEX	Character(1)	VARCHAR2(1) NOT NULL	Duplex - print both sides Y/N Table Edit Default Value: Y
30	PRINT_VIA_SCRIPT	Character(1)	VARCHAR2(1) NOT NULL	Boolean to indicate whether or not to print via a script, as opposed to printing directly to the printer. Y/N Table Edit Default Value: N
31	SFA_DISPLAY_NID	Character(1)	VARCHAR2(1) NOT NULL	Display National ID Y/N Table Edit Default Value: N
32	SFA_DTTM_FMT_OVRD	Character(100)	VARCHAR2(100) NOT NULL	Override the date time format that will be used by the function Date Time To Localized String.