FANLTR_AET

(SQL Table)
Index Back

FAN LETTER AE STATE REC

Financial Aid Notification Letter Application Engine State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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
3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_TBL

4 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
12 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
13 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
14 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
15 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
16 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
17 COUNTY Character(30) VARCHAR2(30) NOT NULL County
18 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

19 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
20 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
21 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

22 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
23 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
24 AID_YEAR_DESCR Character(30) VARCHAR2(30) NOT NULL Financial Aid Year
25 AWARD_LETTER_PRINT Character(3) VARCHAR2(3) NOT NULL Award Letter Print
26 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message
27 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
28 AWARD_STATUS Character(1) VARCHAR2(1) NOT NULL Award Status
A=Accepted
C=Cancelled
D=Declined
O=Offered
29 CHAR_1 Character(1) VARCHAR2(1) NOT NULL Character
30 CHAR_VALUE Character(1) VARCHAR2(1) NOT NULL Character Value
31 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
32 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
33 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
34 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
35 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan
36 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

37 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

38 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

39 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

40 DISP_REPRINT_STAT Character(1) VARCHAR2(1) NOT NULL Display Reprint Status a Y/N field indicating whether or not to display reprint status.

Y/N Table Edit

41 DUPLEX Character(1) VARCHAR2(1) NOT NULL Duplex - print both sides
42 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
43 EQUATION_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Equation Instance. A process instance to be used by an equation.
44 EQUATION_NAME Character(12) VARCHAR2(12) NOT NULL Equation Name
45 EXPIRATION_DATE Date(10) DATE Expiration Date
46 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
47 FAN_PRINT_SPECS Character(1) VARCHAR2(1) NOT NULL FAN Print Specification
A=Print as Award Item
O=Print as Other Resource
48 FAN_SEL_CRIT_TYPE Character(1) VARCHAR2(1) NOT NULL FANLTR selection criteria type
B=Basic Selection
E=Equation Selection
S=Student Override

Default Value: B

49 FANLTR_FORM_TYPE Number(9,0) DECIMAL(9) NOT NULL Fin Aid Award Notification Form Type

Prompt Table: FANLTR_FORM_TYP

50 FANLTR_PRT_COUNT Number(9,0) DECIMAL(9) NOT NULL Award Notification Count. How many award notifications were produced.
51 FANLTR_RETURN_CD Number(2,0) SMALLINT NOT NULL Fin Aid Award Notification Letter Return Code
52 FANLTR_SEQ Number(3,0) SMALLINT NOT NULL FANLTR Sequence
53 FANLTR_STATUS Character(4) VARCHAR2(4) NOT NULL Fin Aid Award Notification Letter (FANLTR) Status
HOLD=Hold
INIT=Initial
PRTD=Printed
REV=Revised
54 FORM_COLLATE_KEY Character(250) VARCHAR2(250) NOT NULL Form Collate Key is the overall sort order key for the output of a set of forms, typically within a single FORM_PROC_INST.
55 FORM_FIELD_C040 Character(40) VARCHAR2(40) NOT NULL Form field char 40 holds all 40 char or less fields to be placed onto a form.
56 FORM_FIELD_C128 Character(128) VARCHAR2(128) NOT NULL Form field char 128 holds all 128 char to 41 char fields to be placed onto a form.
57 FORM_FIELD_C254 Character(254) VARCHAR2(254) NOT NULL Form field char 254 holds all 254 char to 129 char fields to be placed onto a form.
58 FORM_FIELD_LTYPE Character(4) VARCHAR2(4) NOT NULL Form Field Length Type indicates which child form data table contains the data, depending on the length type (xlat).
C040=Char 40
C128=Char 128
C254=Char 254
CLNG=Char Long
59 FORM_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Form Field Name corresponds to a page field name, only for a printed form instead of an online page.
60 FORM_GROUP_DESCR Character(30) VARCHAR2(30) NOT NULL Descr field from record FANLTR_FORM_TYP.
61 FORM_GROUP_ID Character(18) VARCHAR2(18) NOT NULL Form Group ID groups forms together.
62 FORM_GROUP_SEQ Number(9,0) DECIMAL(9) NOT NULL Form Group Sequence enables the sequencing of form groups within a FORM_PROC_INST. Each time a group of forms begins to print, this value is incremented and stays the same within that form group. If the same form group prints again, it is incremented again, so that it is not the same value if the same form group prints twice.
63 FORM_GROUP_SUB_SEQ Number(7,0) INTEGER NOT NULL Form Group Sub Sequence is a sequence number within a form group, one per form. When a new form group begins to print, this sequence number starts back at one.
64 FORM_INPUT_INST Number(10,0) DECIMAL(10) NOT NULL Form Input Instance is the process instance of the job that appended or initially loaded data into a set of output forms being grouped by the same FORM_PROC_INST.
65 FORM_NAME Character(18) VARCHAR2(18) NOT NULL Form Name is the unique id of the form. This corresponds to a page name.
66 FORM_PROC_INST Number(31,0) DECIMAL(31) NOT NULL Form Process Instance collects one or more input jobs (or process instances) into a single output collection for processing. Typically, one form process instance is one batch of output to be printed together.
67 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

68 INST_ADDR1 Character(55) VARCHAR2(55) NOT NULL Institutional address line 1
69 INST_ADDR2 Character(55) VARCHAR2(55) NOT NULL Institutional address 2
70 INST_ADDR3 Character(55) VARCHAR2(55) NOT NULL Institutional address 3
71 INST_DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Institution Formal Description
72 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
73 IS_SCHEDULED_PROC Character(1) VARCHAR2(1) NOT NULL Boolean Y/N indicates whether this is a scheduled process. Y -> it IS a scheduled process. N -> it is NOT a scheduled process. (e.g. remote call).

Y/N Table Edit

74 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
75 ITEM_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Item Type Description
76 LAST_FORM_GRP_SEQ Number(9,0) DECIMAL(9) NOT NULL Last Form Group Sequence.
77 METHODOLOGY Character(2) VARCHAR2(2) NOT NULL Packaging Methodology
FM=Federal Methodology
IM=Institutional Methodology
78 NAME_USAGE Character(10) VARCHAR2(10) NOT NULL Name Usage
79 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

Default Value: OPR_DEF_TBL_HR.COUNTRY_NM_FORMAT

Prompt Table: NAME_FORMAT_TBL

80 NAME Character(50) VARCHAR2(50) NOT NULL Name
81 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
82 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

Prompt Table: NAME_PREFIX_TBL

83 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

Prompt Table: NAME_SUFFIX_TBL

84 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

Prompt Table: NM_ROYPREF_GBL

85 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix

Prompt Table: NM_ROYSUFF_GBL

86 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title

Prompt Table: TITLE_TBL

87 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
88 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
89 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
90 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
91 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
92 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
93 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
94 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
95 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
96 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
97 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

Prompt Table: NM_ROYPREF_GBL

98 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner

Default Value: 1

99 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
100 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
101 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
102 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
103 OPER_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Operator Institution is the Institution associated with the OperId.
104 OPERINSTDESCR Character(30) VARCHAR2(30) NOT NULL Operator Institution Descr
105 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
106 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
107 OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
0=Any
1=(None)
10=Postscript (*.lis)
11=Crystal Report (*.rpt)
12=Rich Text File (*.rtf)
13=SQR Portable Format (*.spf)
14=Text Files (*.txt)
15=Other
16=Default
17=XML Format(*.xml)
18=Data Mover Data File (*.dat)
19=Crystal Report Explorer(*.rpt)
2=Acrobat (*.pdf)
20=XMLP
21=Atom
22=Transformation
23=Printer Command Lang. (*.pcl)
24=PostScript (*.ps)
3=Comma delimited (*.csv)
4=HP Format (*.lis)
5=HTML Documents (*.htm)
6=Line Printer Format (*.lis)
7=Lotus 1-2-3 Files (*.wks)
8=Microsoft Excel Files (*.xls)
9=Microsoft Word (*.doc)
108 OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
109 PACKAGING_METHOD Character(1) VARCHAR2(1) NOT NULL Aid Packaging Method
0=Not Packaged
5=Auto Packaged
9=Counselor Packaged
110 PKG_AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Package Plan Award Period
A=Academic
B=Both Academic & Non Std
N=Non Standard
111 PRINT_CANCELS Character(1) VARCHAR2(1) NOT NULL Print Cancels Y - Do print cancels N - Don't print cancels.

Y/N Table Edit

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

Y/N Table Edit

113 PRINT_LTR_OPTION Character(1) VARCHAR2(1) NOT NULL Print Letter Option
C=Print on Custom Letter
N=Never print on letter
P=Print on Award Letter
114 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.
115 PRINTER_NAME Character(127) VARCHAR2(127) NOT NULL Printer Name
116 PRINTER_NAME_HOLD Character(127) VARCHAR2(127) NOT NULL Printer Name Hold Save the old printer name here for later restoration.
117 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
118 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
119 RUN_SIMULATION Character(1) VARCHAR2(1) NOT NULL Run Simulation Y/N field indicating whether to run a simulation.

Y/N Table Edit

120 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
121 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

Prompt Table: SRVC_IMPACT_TBL

122 SETID Character(5) VARCHAR2(5) NOT NULL SetID
123 SFA_DISPLAY_NID Character(1) VARCHAR2(1) NOT NULL Display National ID
124 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.
125 SORT_NAME Character(18) VARCHAR2(18) NOT NULL Sort Name is the name of a sort order.

Prompt Table: SORT_NAME_TBL

126 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
127 STRM Character(4) VARCHAR2(4) NOT NULL Term
128 STRM_DESCR Character(30) VARCHAR2(30) NOT NULL Term Description
129 STRM_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short description of student term.