| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
ITEM_TYPE_FA_SH
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table:
FED_AID_YR_TBL
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
Default Value: ITEM_TYPE_TBL.DESCR
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: ITEM_TYPE_TBL.DESCRSHORT
|
| 8 |
PAY_ACROSS_TERMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Fin Aid Across Terms
Y/N Table Edit
|
| 9 |
FA_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source
F=Federal
G=Government
I=Institutional
O=Other
P=Private
S=State
|
| 10 |
FEDERAL_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Federal ID
ACG=Academic Competitiveness Grant
FWSP=Federal Work Study Program
GAAN=Grad Assistance in Natl Need
GPLS=Graduate PLUS Loan
HEAL=Health Education Assistance Ln
HPSL=Health Profession Student Loan
IASA=Iraq/Afghan Service Award
JVTS=Jacob K Javits Fellowship
LDS=Loans for Disadvantaged Stdnts
NIH=National Institute of Health
NSF=National Science Foundation
NURS=Nursing Loan
OTHR=Other Federal Fund
PCL=Primary Care Loan
PELL=Federal PELL Grant
PERK=Federal Perkins Loan Program
PLUS=Federal Stafford Loan, PLUS
SEOG=Federal SEOG
SMRT=National Smart Grant
STFS=Fed Stafford Loan - Subsidized
STFU=Fed Stafford Loan-Unsubsidized
TCH=TEACH Grant
|
| 11 |
LOAN_PROGRAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
|
| 12 |
TITLE_IV |
Character(1) |
VARCHAR2(1) NOT NULL |
Title IV Aid
Y/N Table Edit
|
| 13 |
AWARD_LETTER_PRINT |
Character(3) |
VARCHAR2(3) NOT NULL |
Award Letter Print
Prompt Table:
SCC_STN_LTR_TBL
|
| 14 |
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
|
| 15 |
FAN_PRINT_SPECS |
Character(1) |
VARCHAR2(1) NOT NULL |
FAN Print Specification
A=Print as Award Item
O=Print as Other Resource
Default Value: A
|
| 16 |
FIN_AID_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fin Aid Type
A=Athletic
B=Bursary
F=Fellowship
G=Grant
L=Loan
S=Scholarship
V=Waiver
W=Work/Study
|
| 17 |
FED_OR_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Fed/Inst Affected
B=Both Fed and Inst
F=Federal Only
I=Institutional Only
|
| 18 |
PACKAGE_LIMIT_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Package Limit
C=Cost of Attendance
E=EFC/COA lessor
N=Need
U=No Limit
Default Value: N
|
| 19 |
NEED_BASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Need Based
Y/N Table Edit
Default Value: N
|
| 20 |
MEET_NEED_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Meet Need/Cost
1=Straight Need/Cost
2=Need Only
3=Cost Only
4=Special Need/Cost
5=Conditional
6=No Effect
Default Value: 1
|
| 21 |
DISBURSE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbursement Method
A=Student Account
N=No
|
| 22 |
AGGREGATE_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
Aggregate Area
Prompt Table:
ITEM_TP_FA_AGGR
|
| 23 |
FA_ROUND_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Option
1=Round Even Dollar
2=5 Dollars
3=10 Dollars
4=100 Dollars
5=No Rounding
6=Commonline
Default Value: 1
|
| 24 |
ROUND_DIRECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Round Direction
D=Round Down
N=Round Nearest
U=Round Up
Default Value: N
|
| 25 |
REMAINDER_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Remainder Rule
1=First Disbursment - Cents
2=Last Disbursement - Cents
3=First Disbursement - Dollars
4=Last Disbursement - Dollars
Default Value: 1
|
| 26 |
FEE_REMAINDER_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fee Remainder Rule
1=First Disb - Cents
2=Last Disb - Cents
3=First Disb - Dollars
4=Last Disb - Dollars
|
| 27 |
TRUNCATE_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Truncate Fees
Y/N Table Edit
Default Value: N
|
| 28 |
LOAN_INTEREST_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Interest Attribute
S=Subsidized
U=Unsubsidized
|
| 29 |
PASS_ANTICIP_AID |
Character(1) |
VARCHAR2(1) NOT NULL |
Pass Anticipated Aid
1=Award Offered
2=Award Accepted
3=Award Authorized
4=No Anticipated Aid
Default Value: 4
|
| 30 |
ANTCP_AID_EXP_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Anticip Aid Expiration Days
Default Value: 30
|
| 31 |
PACKAGING_FEED |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Package
Y/N Table Edit
|
| 32 |
EQUITY_AWARD |
Character(1) |
VARCHAR2(1) NOT NULL |
Equity Award
Y/N Table Edit
|
| 33 |
INST_OVRAWRD_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overaward Rule(Inst)
1=Allow
2=Prevent Awarding
Default Value: 1
|
| 34 |
FED_OVRAWRD_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overaward Rule(Fed)
1=Allow
2=Prevent Awarding
Default Value: 1
|
| 35 |
OVRAWD_TOLERANCE |
Number(5,0) |
INTEGER NOT NULL |
Overaward Tolerance
|
| 36 |
REPORT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Institution Reporting Cd
|
| 37 |
AWARD_MSG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Award Message
Prompt Table:
AWD_MESSAGE_VW
|
| 38 |
SIGNATURE_RELEASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Signature Required
Y/N Table Edit
|
| 39 |
AUTO_CANCEL_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Auto Cancel Item Type
Prompt Table:
ITEM_TP_FA_VW
|
| 40 |
MANUAL_AUTH_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Authorization
Y/N Table Edit
Default Value: N
|
| 41 |
LINE_REASON_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Reason Code
|
| 42 |
PARENT_ITEM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Item Type
Y/N Table Edit
Default Value: N
|
| 43 |
SELECTION_CRITERIA |
Character(12) |
VARCHAR2(12) NOT NULL |
Selection Criteria
Prompt Table:
SFA_PKGEQTNS_VW
|
| 44 |
METHODOLOGY |
Character(2) |
VARCHAR2(2) NOT NULL |
Packaging Methodology
FM=Federal Methodology
IM=Institutional Methodology
|
| 45 |
SELF_HELP_AWARD |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Help Award
Y/N Table Edit
|
| 46 |
LOCK_AWARD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock Award
Y/N Table Edit
|
| 47 |
AWARD_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Period
A=Academic
N=Non Standard
|
| 48 |
ONE_INSTANCE_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Package Only Once
|
| 49 |
MISSING_TERM_SPLIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Even split across valid terms
Y/N Table Edit
Default Value: N
|
| 50 |
DISB_PROTECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbursement Protection
Y/N Table Edit
Default Value: N
|
| 51 |
SEQUENCE_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto assign lowest sequence
Y/N Table Edit
Default Value: N
|
| 52 |
INCLUDE_IN_TSCRPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Transcript
|
| 53 |
FA_SS_ACCEPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accept
Y/N Table Edit
Default Value: Y
|
| 54 |
FA_SS_DECLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Decline
Y/N Table Edit
Default Value: Y
|
| 55 |
FA_SS_REDUX |
Character(1) |
VARCHAR2(1) NOT NULL |
Reduce
Y/N Table Edit
Default Value: Y
|
| 56 |
SFA_MPN_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
MPN Required
Y/N Table Edit
|
| 57 |
SFA_LNTRANSIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust while in transit
Y/N Table Edit
Default Value: N
|
| 58 |
SFA_NO_RPKG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Don't Auto Repackage
Y/N Table Edit
Default Value: N
|
| 59 |
SFA_ASG_ACAD_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Level
0=1st Year - Never Attended
1=1st Year - Previously Attended
2=2nd Year
3=3rd Year
4=4th Year
5=5th Year
6=Grad/Professional - 1st Year
7=Grad/Professional - Continuing
|
| 60 |
SFA_ADDL_PELL_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Pell Eligibility
Y/N Table Edit
|
| 61 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|