SS_FA_INSTL_CPY

(SQL View)
 Index Back

Copy Rec for FA SS Options


SELECT INSTITUTION ,AID_YEAR ,SS_FA_ALLOW_ACCESS ,SS_FA_VIEW_DFLT ,SS_FA_VIEW_METH ,SS_FA_SHOW_NEED ,SS_FA_SHOW_AWD_DTL ,SS_FA_SHOW_CANCELS ,SS_FA_SHOW_DECLINE ,SS_FA_SHOW_ERR ,SS_FA_SORT_ORDER1 ,SS_FA_SORT_ORDER2 ,SS_FA_SORT_ORDER3 ,SS_FA_AY_DESCR ,SS_FA_NS_DESCR ,URL_ADDRESS ,SS_FA_USE_URL ,SS_FA_SHOW_SUMMARY ,SS_FA_LINK_LBL ,SS_FA_AWDPER_SORT ,SS_FA_AWD_FILTER01 ,SS_FA_AWD_FILTER02 ,SS_FA_AWD_FILTER03 ,SS_FA_AWD_FILTER04 ,SS_FA_AWD_FILTER05 ,SS_FA_AWD_FILTER06 ,SS_FA_AWD_FILTER07 ,SS_FA_AWD_FILTER08 ,SS_FA_AWD_FILTER09 ,SS_FA_AWD_FILTER10 ,SS_FA_AWD_OPR01 ,SS_FA_AWD_OPR02 ,SS_FA_AWD_OPR03 ,SS_FA_AWD_OPR04 ,SS_FA_AWD_OPR05 ,SS_FA_AWD_OPR06 ,SS_FA_AWD_OPR07 ,SS_FA_AWD_OPR08 ,SS_FA_AWD_OPR09 ,SS_FA_AWD_OPR10 ,AID_APP_STATUS ,PROCESSING_STATUS ,VERIFICATON_STATUS ,SFA_REVIEW_STATUS ,SAT_ACADEMIC_PRG ,COMM_CATEGORY ,COMM_CONTEXT ,SCC_LETTER_CD ,FA_SS_PROCESS_MODE ,FA_URL_CONS_INFO ,FA_URL_INTERVIEW ,SFA_EMPN_AUTH_MTHD ,SFA_EMPN_OPT_REF ,SFA_SS_AWDNTF_LBL ,SFA_DISPLAY_AWDNTF ,SS_LN_CNSL_ENTRNCE ,SS_LN_CNSL_EXIT ,SFA_LN_DISP_S_LNDR ,SFA_SS_LNDR_SORT ,SFA_EASS_AWDACCESS ,SFA_EASS_HIDE_LINK ,SFA_EASS_INQACCESS ,SFA_EASS_LABEL ,SFA_EASS_SCACCESS ,SFA_EASS_SFACCESS ,SFA_EASS_VW_LBL ,SFA_SAP_LBL ,SS_FA_SAP_LNK_LBL ,SFA_SHOW_DISB_AMT ,SFA_DISB_AMT_OPT ,SFA_SHOW_DISB_DATE ,SFA_DISB_DATE_OPT ,SFA_DATE_PROGR_OPT ,SFA_SHOW_GT_TODAY ,SS_FA_SAP_FMI_URL ,SFA_SS_EA_ACCESS FROM PS_SS_FA_INSTALL

# 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

Prompt Table: AID_YEAR_TBL

3 SS_FA_ALLOW_ACCESS Character(1) VARCHAR2(1) NOT NULL Allow Access to This Aid Year
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: D

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
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
21 SS_FA_AWD_FILTER01 Character(1) VARCHAR2(1) NOT NULL FA Application Status
22 SS_FA_AWD_FILTER02 Character(1) VARCHAR2(1) NOT NULL Processing Status
23 SS_FA_AWD_FILTER03 Character(1) VARCHAR2(1) NOT NULL FED Verification Process
24 SS_FA_AWD_FILTER04 Character(1) VARCHAR2(1) NOT NULL INST Verification Process
25 SS_FA_AWD_FILTER05 Character(1) VARCHAR2(1) NOT NULL Satisfactory Academic Progress
26 SS_FA_AWD_FILTER06 Character(1) VARCHAR2(1) NOT NULL Award Notifcation Complete
27 SS_FA_AWD_FILTER07 Character(1) VARCHAR2(1) NOT NULL Negative Service Indicators
28 SS_FA_AWD_FILTER08 Character(1) VARCHAR2(1) NOT NULL Complete Checklist Items
29 SS_FA_AWD_FILTER09 Character(1) VARCHAR2(1) NOT NULL SS FA Filter 09
30 SS_FA_AWD_FILTER10 Character(1) VARCHAR2(1) NOT NULL SS FA Filter 10
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
47 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
48 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code
49 FA_SS_PROCESS_MODE Character(1) VARCHAR2(1) NOT NULL Processing Option
B=Batch
R=Real time
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
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