RUN_CNTL_FANLTR (SQL Table)	Index Back
Award Notification Batch Financial Aid Notification Letter

RUN_CNTL_FANLTR

(SQL Table)

Award Notification Batch

Financial Aid Notification Letter

Parent Record Of RUNCNTL_FAN_IDS RUNCNTL_FAN_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

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

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

6 EXPIRATION_DATE Date(10) DATE NOT NULL Expiration Date

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

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

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

10 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

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

12 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

13 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

14 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

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

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

17 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

18 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

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

20 DUPLEX Character(1) VARCHAR2(1) NOT NULL Duplex - print both sides
Y/N Table Edit

21 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

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

23 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ADDR_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Address Usage Prompt Table: ADDR_USAGE_TBL
4	NAME_USAGE	Character(10)	VARCHAR2(10) NOT NULL	Name Usage Prompt Table: NAME_USAGE_VW
5	SORT_NAME	Character(18)	VARCHAR2(18) NOT NULL	Sort Name is the name of a sort order. Prompt Table: SORT_NAME_TBL
6	EXPIRATION_DATE	Date(10)	DATE NOT NULL	Expiration Date
7	SERVICE_IMPACT	Character(5)	VARCHAR2(5) NOT NULL	Service Impact Prompt Table: SRVC_IMPACT_TBL
8	RUN_SIMULATION	Character(1)	VARCHAR2(1) NOT NULL	Run Simulation Y/N field indicating whether to run a simulation. Y/N Table Edit
9	METHODOLOGY	Character(2)	VARCHAR2(2) NOT NULL	Packaging Methodology FM=Federal Methodology IM=Institutional Methodology
10	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
11	FANLTR_FORM_TYPE	Number(9,0)	DECIMAL(9) NOT NULL	Fin Aid Award Notification Form Type Prompt Table: FANLTR_FORM_TYP
12	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
13	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
14	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
15	PRINT_CANCELS	Character(1)	VARCHAR2(1) NOT NULL	Print Cancels Y - Do print cancels N - Don't print cancels. Y/N Table Edit
16	PRINT_DECLINES	Character(1)	VARCHAR2(1) NOT NULL	Print Declines Y - Do print declines. N - Don't print declines. Y/N Table Edit
17	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
18	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
19	PRINTER_NAME	Character(127)	VARCHAR2(127) NOT NULL	Printer Name Prompt Table: PRINTER_TBL
20	DUPLEX	Character(1)	VARCHAR2(1) NOT NULL	Duplex - print both sides Y/N Table Edit
21	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
22	SFA_DISPLAY_NID	Character(1)	VARCHAR2(1) NOT NULL	Display National ID Y/N Table Edit Default Value: N
23	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.