FANLTR_AET(SQL Table) |
Index Back |
---|---|
FAN LETTER AE STATE RECFinancial Aid Notification Letter Application Engine State Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 | 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 | 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 | 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. |