| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 3 |
SS_FA_ALLOW_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Access to This Aid Year
Y/N Table Edit
Default Value: Y
|
| 4 |
SS_FA_VIEW_DFLT |
Character(4) |
VARCHAR2(4) NOT NULL |
View Summary By
A=Award Period
Y=Aid Year
Default Value: Y
|
| 5 |
SS_FA_VIEW_METH |
Character(4) |
VARCHAR2(4) NOT NULL |
Need Methodology
F=Federal
I=Institutional
Default Value: F
|
| 6 |
SS_FA_SHOW_NEED |
Character(1) |
VARCHAR2(1) NOT NULL |
Remaining Need
Y/N Table Edit
Default Value: Y
|
| 7 |
SS_FA_SHOW_AWD_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Detail
Y/N Table Edit
Default Value: Y
|
| 8 |
SS_FA_SHOW_CANCELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Canceled Awards
Y/N Table Edit
Default Value: N
|
| 9 |
SS_FA_SHOW_DECLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Declined Awards
Y/N Table Edit
Default Value: Y
|
| 10 |
SS_FA_SHOW_ERR |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorization Messages
Y/N Table Edit
Default Value: N
|
| 11 |
SS_FA_SORT_ORDER1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending/Descending
A=Ascending
D=Descending
Default Value: A
|
| 12 |
SS_FA_SORT_ORDER2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending/Descending
A=Ascending
D=Descending
Default Value: D
|
| 13 |
SS_FA_SORT_ORDER3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending/Descending
A=Ascending
D=Descending
Default Value: A
|
| 14 |
SS_FA_AY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate description for Academic Year to be displayed on Self-Service pages
Default Value: Academic Year
|
| 15 |
SS_FA_NS_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate description for Non-Standard Award Period to be displayed on Self-Service pages
Default Value: Non Standard Per.
|
| 16 |
URL_ADDRESS |
Character(254) |
VARCHAR2(254) NOT NULL |
URL Address
|
| 17 |
SS_FA_USE_URL |
Character(1) |
VARCHAR2(1) NOT NULL |
Always use default
Y/N Table Edit
Default Value: Y
|
| 18 |
SS_FA_SHOW_SUMMARY |
Character(1) |
VARCHAR2(1) NOT NULL |
EFC/COA/Need Summary Page
C=COA Detail Only
N=Do Not Show Link
U=User-defined Page
Y=Summary Page
Default Value: Y
|
| 19 |
SS_FA_LINK_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined Label
|
| 20 |
SS_FA_AWDPER_SORT |
Character(4) |
VARCHAR2(4) NOT NULL |
Sort order for Award Period (which should appear first) on the FA Self-Service pages
ACAD=Academic Year First
EARL=Earliest Period First
LATE=Latest Period First
NONS=Non-Standard Period First
Default Value: ACAD
|
| 21 |
SS_FA_AWD_FILTER01 |
Character(1) |
VARCHAR2(1) NOT NULL |
FA Application Status
Y/N Table Edit
Default Value: N
|
| 22 |
SS_FA_AWD_FILTER02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Status
Y/N Table Edit
Default Value: N
|
| 23 |
SS_FA_AWD_FILTER03 |
Character(1) |
VARCHAR2(1) NOT NULL |
FED Verification Process
Y/N Table Edit
Default Value: N
|
| 24 |
SS_FA_AWD_FILTER04 |
Character(1) |
VARCHAR2(1) NOT NULL |
INST Verification Process
Y/N Table Edit
Default Value: N
|
| 25 |
SS_FA_AWD_FILTER05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Satisfactory Academic Progress
Y/N Table Edit
Default Value: N
|
| 26 |
SS_FA_AWD_FILTER06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Notifcation Complete
Y/N Table Edit
Default Value: N
|
| 27 |
SS_FA_AWD_FILTER07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Service Indicators
Y/N Table Edit
Default Value: N
|
| 28 |
SS_FA_AWD_FILTER08 |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Checklist Items
Y/N Table Edit
Default Value: N
|
| 29 |
SS_FA_AWD_FILTER09 |
Character(1) |
VARCHAR2(1) NOT NULL |
SS FA Filter 09
Y/N Table Edit
Default Value: N
|
| 30 |
SS_FA_AWD_FILTER10 |
Character(1) |
VARCHAR2(1) NOT NULL |
SS FA Filter 10
Y/N Table Edit
Default Value: N
|
| 31 |
SS_FA_AWD_OPR01 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 01
<>=Not Equal
==Equal to
|
| 32 |
SS_FA_AWD_OPR02 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 02
<>=Not Equal
==Equal to
|
| 33 |
SS_FA_AWD_OPR03 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 03
<>=Not Equal
==Equal to
|
| 34 |
SS_FA_AWD_OPR04 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 04
<>=Not Equal
==Equal to
|
| 35 |
SS_FA_AWD_OPR05 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 05
<>=Not Equal
==Equal to
|
| 36 |
SS_FA_AWD_OPR06 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 06
<>=Not Equal
==Equal to
|
| 37 |
SS_FA_AWD_OPR07 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 07
<>=Not Equal
==Equal to
|
| 38 |
SS_FA_AWD_OPR08 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 08
<>=Not Equal
==Equal to
|
| 39 |
SS_FA_AWD_OPR09 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 09
|
| 40 |
SS_FA_AWD_OPR10 |
Character(2) |
VARCHAR2(2) NOT NULL |
SS FA Operator 10
|
| 41 |
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
|
| 42 |
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
|
| 43 |
VERIFICATON_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
ED Verification Status
C=ED Verification Complete
N=Not Required
P=Verification Pending
R=Required to be Performed
|
| 44 |
SFA_REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
C=Review Complete
I=Incomplete
|
| 45 |
SAT_ACADEMIC_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used on Packaging Status Summary to note current Satisfactory Academic Progress status.
A=Academic Plan
N=Not Meeting Satis Acad Prgrs
P=Probation
U=SAP Undetermined
W=Warning
Y=Meeting Satis Acad Progress
|
| 46 |
COMM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table:
FA_COMM_CATG_VW
|
| 47 |
COMM_CONTEXT |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Context
Prompt Table:
FA_COMM_CTX_VW
|
| 48 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table:
FA_COMM_LTR_VW
|
| 49 |
FA_SS_PROCESS_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Option
B=Batch
R=Real time
Default Value: B
|
| 50 |
FA_URL_CONS_INFO |
Character(254) |
VARCHAR2(254) NOT NULL |
Consumer Information URL
|
| 51 |
FA_URL_INTERVIEW |
Character(254) |
VARCHAR2(254) NOT NULL |
Entrance Interview URL
|
| 52 |
SFA_EMPN_AUTH_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Authentication Method
BDT=Birthdate
NID=National ID Number
NOA=No Authentication
PIN=Personal Identification Number
|
| 53 |
SFA_EMPN_OPT_REF |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional References
0=None
1=One
2=Two
3=Three
|
| 54 |
SFA_SS_AWDNTF_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Easily customizable label for the link to view the award notification letter.
|
| 55 |
SFA_DISPLAY_AWDNTF |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Award Notification Letter.
Y/N Table Edit
Default Value: N
|
| 56 |
SS_LN_CNSL_ENTRNCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Entrance Interview URL
Y/N Table Edit
Default Value: N
|
| 57 |
SS_LN_CNSL_EXIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Exit Interview URL
Y/N Table Edit
Default Value: N
|
| 58 |
SFA_LN_DISP_S_LNDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Lender Selection
Y/N Table Edit
Default Value: N
|
| 59 |
SFA_SS_LNDR_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Lender Sort Option
1=Random
2=Sequence Number
Default Value: 1
|
| 60 |
SFA_EASS_AWDACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
External Award Self Service access from Accept/Decline page.
Y/N Table Edit
Default Value: N
|
| 61 |
SFA_EASS_HIDE_LINK |
Character(1) |
VARCHAR2(1) NOT NULL |
FA SS option to hide link if no active aid years found.
Y/N Table Edit
Default Value: Y
|
| 62 |
SFA_EASS_INQACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
External award self service access from FA Inquiry page.
Y/N Table Edit
Default Value: N
|
| 63 |
SFA_EASS_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Label for external award self reporting hyperlink.
|
| 64 |
SFA_EASS_SCACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
External Award Self Service access from Student Center.
Y/N Table Edit
Default Value: N
|
| 65 |
SFA_EASS_SFACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
External awards self service access from student financial's Account Inquiry page.
Y/N Table Edit
Default Value: N
|
| 66 |
SFA_EASS_VW_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Text for List View
|
| 67 |
SFA_SAP_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Satisfactory Academic Progress
Y/N Table Edit
|
| 68 |
SS_FA_SAP_LNK_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Hyper Link field that navigates to the Satisfactory Academic Progress Self Service status page.
|
| 69 |
SFA_SHOW_DISB_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Amounts
Y/N Table Edit
Default Value: N
|
| 70 |
SFA_DISB_AMT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disb Amount Options
A=Authorized
D=Disbursed
|
| 71 |
SFA_SHOW_DISB_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Status and Date
Y/N Table Edit
Default Value: N
|
| 72 |
SFA_DISB_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbursement Date Options
A=Authorized
D=Disbursed
S=Scheduled
|
| 73 |
SFA_DATE_PROGR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Progression Options
1=Progression
2=Ignore Authorized
|
| 74 |
SFA_SHOW_GT_TODAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Date if Passed
Y/N Table Edit
Default Value: N
|
| 75 |
SS_FA_SAP_FMI_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Satisfactory Academic Progress Self Service field. Holds the For More Information URL.
|
| 76 |
SFA_SS_EA_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Student-level access control to external award self service.
N=Deny
Y=Allow
|