ITM_TP_FA_AWRDS

(SQL View)
 Index Back

Item Type Options for Awards

Used as a prompt record for Item Types in Award Entry.

SELECT a.setid , a.aid_year , a.item_type , a.pass_anticip_aid , a.antcp_aid_exp_days , a.fa_round_option , a.round_direction , a.remainder_rule , a.fee_remainder_rule , a.truncate_fee , a.inst_ovrawrd_rule , a.fed_ovrawrd_rule , a.ovrawd_tolerance , a.fed_or_inst , a.package_limit_rule , a.meet_need_cost , a.fin_aid_type , a.aggregate_area , a.auto_cancel_type , a.need_based , a.parent_item_type , a.fa_source , a.loan_program , a.federal_id , a.award_period , a.lock_award_flag , a.disb_protection , a.sequence_override , a.print_ltr_option , a.fa_ss_accept , a.fa_ss_decline , a.fa_ss_redux , a.sfa_mpn_required , a.sfa_lntransit_flag , a.award_msg_cd , a.disburse_method FROM PS_ITEM_TYPE_FA a WHERE a.effdt = ( SELECT MAX (b.effdt) FROM PS_ITEM_TYPE_FA b WHERE a.setid = b.setid AND a.item_type = b.item_type AND a.aid_year = b.aid_year AND b.effdt <= %CurrentDateIn AND b.eff_status = 'A' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
3 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: ITEM_TYPE_FA_VW

4 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
5 ANTCP_AID_EXP_DAYS Number(3,0) SMALLINT NOT NULL Anticip Aid Expiration Days
6 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
7 ROUND_DIRECTION Character(1) VARCHAR2(1) NOT NULL Round Direction
D=Round Down
N=Round Nearest
U=Round Up
8 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
9 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
10 TRUNCATE_FEE Character(1) VARCHAR2(1) NOT NULL Truncate Fees
11 INST_OVRAWRD_RULE Character(1) VARCHAR2(1) NOT NULL Overaward Rule(Inst)
1=Allow
2=Prevent Awarding
12 FED_OVRAWRD_RULE Character(1) VARCHAR2(1) NOT NULL Overaward Rule(Fed)
1=Allow
2=Prevent Awarding
13 OVRAWD_TOLERANCE Number(5,0) INTEGER NOT NULL Overaward Tolerance
14 FED_OR_INST Character(1) VARCHAR2(1) NOT NULL Fed/Inst Affected
B=Both Fed and Inst
F=Federal Only
I=Institutional Only
15 PACKAGE_LIMIT_RULE Character(1) VARCHAR2(1) NOT NULL Package Limit
C=Cost of Attendance
E=EFC/COA lessor
N=Need
U=No Limit
16 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
17 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
18 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
19 AUTO_CANCEL_TYPE Character(12) VARCHAR2(12) NOT NULL Auto Cancel Item Type
20 NEED_BASED Character(1) VARCHAR2(1) NOT NULL Need Based
21 PARENT_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Parent Item Type
22 FA_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
F=Federal
G=Government
I=Institutional
O=Other
P=Private
S=State
23 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
24 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
25 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
26 LOCK_AWARD_FLAG Character(1) VARCHAR2(1) NOT NULL Lock Award

Y/N Table Edit

27 DISB_PROTECTION Character(1) VARCHAR2(1) NOT NULL Disbursement Protection
28 SEQUENCE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Auto assign lowest sequence
29 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
30 FA_SS_ACCEPT Character(1) VARCHAR2(1) NOT NULL Accept
31 FA_SS_DECLINE Character(1) VARCHAR2(1) NOT NULL Decline
32 FA_SS_REDUX Character(1) VARCHAR2(1) NOT NULL Reduce
33 SFA_MPN_REQUIRED Character(1) VARCHAR2(1) NOT NULL MPN Required
34 SFA_LNTRANSIT_FLAG Character(1) VARCHAR2(1) NOT NULL Adjust while in transit

Y/N Table Edit

35 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message
36 DISBURSE_METHOD Character(1) VARCHAR2(1) NOT NULL Disbursement Method
A=Student Account
N=No