FAN_ITMTYPFA_VW

(SQL View)
 Index Back

Item Type Fin Aid View

View of Item Types for Financial Aid. This is a view of this table used for Fin Aid Award Notification Letter equation selection processing.

SELECT A.SETID ,A.ITEM_TYPE ,A.AID_YEAR ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT ,A.PAY_ACROSS_TERMS ,A.FA_SOURCE ,A.FEDERAL_ID ,A.LOAN_PROGRAM ,A.TITLE_IV ,A.AWARD_LETTER_PRINT ,A.PRINT_LTR_OPTION ,A.FAN_PRINT_SPECS ,A.FIN_AID_TYPE ,A.FED_OR_INST ,A.PACKAGE_LIMIT_RULE ,A.NEED_BASED ,A.MEET_NEED_COST ,A.DISBURSE_METHOD ,A.AGGREGATE_AREA ,A.FA_ROUND_OPTION ,A.ROUND_DIRECTION ,A.REMAINDER_RULE ,A.FEE_REMAINDER_RULE ,A.TRUNCATE_FEE ,A.LOAN_INTEREST_ATTR ,A.PASS_ANTICIP_AID ,A.ANTCP_AID_EXP_DAYS ,A.PACKAGING_FEED ,A.EQUITY_AWARD ,A.INST_OVRAWRD_RULE ,A.FED_OVRAWRD_RULE ,A.OVRAWD_TOLERANCE ,A.REPORT_CODE ,A.AWARD_MSG_CD ,A.SIGNATURE_RELEASE ,A.AUTO_CANCEL_TYPE ,A.MANUAL_AUTH_IND ,A.LINE_REASON_CD ,A.PARENT_ITEM_TYPE ,A.SELECTION_CRITERIA ,A.METHODOLOGY ,A.SELF_HELP_AWARD ,A.LOCK_AWARD_FLAG ,A.AWARD_PERIOD ,A.ONE_INSTANCE_ITEM ,A.MISSING_TERM_SPLIT ,A.DISB_PROTECTION ,A.SEQUENCE_OVERRIDE ,A.INCLUDE_IN_TSCRPT ,A.FA_SS_ACCEPT ,A.FA_SS_DECLINE ,A.FA_SS_REDUX FROM PS_ITEM_TYPE_FA A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ITEM_TYPE_FA B WHERE B.SETID = A.SETID AND B.ITEM_TYPE = A.ITEM_TYPE AND B.AID_YEAR = A.AID_YEAR AND B.EFFDT <= %CurrentDateIn )

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 PAY_ACROSS_TERMS Character(1) VARCHAR2(1) NOT NULL Pay Fin Aid Across Terms

Y/N Table Edit

8 FA_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
F=Federal
G=Government
I=Institutional
O=Other
P=Private
S=State
9 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
10 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
11 TITLE_IV Character(1) VARCHAR2(1) NOT NULL Title IV Aid

Y/N Table Edit

12 AWARD_LETTER_PRINT Character(3) VARCHAR2(3) NOT NULL Award Letter Print

Prompt Table: STANDRD_LTR_TBL

13 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
14 FAN_PRINT_SPECS Character(1) VARCHAR2(1) NOT NULL FAN Print Specification
A=Print as Award Item
O=Print as Other Resource
15 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
16 FED_OR_INST Character(1) VARCHAR2(1) NOT NULL Fed/Inst Affected
B=Both Fed and Inst
F=Federal Only
I=Institutional Only
17 PACKAGE_LIMIT_RULE Character(1) VARCHAR2(1) NOT NULL Package Limit
C=Cost of Attendance
E=EFC/COA lessor
N=Need
U=No Limit
18 NEED_BASED Character(1) VARCHAR2(1) NOT NULL Need Based

Y/N Table Edit

19 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
20 DISBURSE_METHOD Character(1) VARCHAR2(1) NOT NULL Disbursement Method
A=Student Account
N=No
21 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area

Prompt Table: ITEM_TP_FA_AGGR

22 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
23 ROUND_DIRECTION Character(1) VARCHAR2(1) NOT NULL Round Direction
D=Round Down
N=Round Nearest
U=Round Up
24 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
25 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
26 TRUNCATE_FEE Character(1) VARCHAR2(1) NOT NULL Truncate Fees

Y/N Table Edit

27 LOAN_INTEREST_ATTR Character(1) VARCHAR2(1) NOT NULL Loan Interest Attribute
S=Subsidized
U=Unsubsidized
28 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
29 ANTCP_AID_EXP_DAYS Number(3,0) SMALLINT NOT NULL Anticip Aid Expiration Days
30 PACKAGING_FEED Character(1) VARCHAR2(1) NOT NULL Auto Package

Y/N Table Edit

31 EQUITY_AWARD Character(1) VARCHAR2(1) NOT NULL Equity Award

Y/N Table Edit

32 INST_OVRAWRD_RULE Character(1) VARCHAR2(1) NOT NULL Overaward Rule(Inst)
1=Allow
2=Prevent Awarding
33 FED_OVRAWRD_RULE Character(1) VARCHAR2(1) NOT NULL Overaward Rule(Fed)
1=Allow
2=Prevent Awarding
34 OVRAWD_TOLERANCE Number(5,0) INTEGER NOT NULL Overaward Tolerance
35 REPORT_CODE Character(4) VARCHAR2(4) NOT NULL Institution Reporting Cd
36 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message

Prompt Table: AWD_MESSAGE_VW

37 SIGNATURE_RELEASE Character(1) VARCHAR2(1) NOT NULL Signature Required

Y/N Table Edit

38 AUTO_CANCEL_TYPE Character(12) VARCHAR2(12) NOT NULL Auto Cancel Item Type

Prompt Table: ITEM_TP_FA_VW

39 MANUAL_AUTH_IND Character(1) VARCHAR2(1) NOT NULL Manual Authorization

Y/N Table Edit

40 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
41 PARENT_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Parent Item Type

Y/N Table Edit

42 SELECTION_CRITERIA Character(12) VARCHAR2(12) NOT NULL Selection Criteria

Prompt Table: SFA_PKGEQTNS_VW

43 METHODOLOGY Character(2) VARCHAR2(2) NOT NULL Packaging Methodology
FM=Federal Methodology
IM=Institutional Methodology
44 SELF_HELP_AWARD Character(1) VARCHAR2(1) NOT NULL Self Help Award

Y/N Table Edit

45 LOCK_AWARD_FLAG Character(1) VARCHAR2(1) NOT NULL Lock Award

Y/N Table Edit

46 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
47 ONE_INSTANCE_ITEM Character(1) VARCHAR2(1) NOT NULL Package Only Once
48 MISSING_TERM_SPLIT Character(1) VARCHAR2(1) NOT NULL Even split across valid terms

Y/N Table Edit

49 DISB_PROTECTION Character(1) VARCHAR2(1) NOT NULL Disbursement Protection

Y/N Table Edit

50 SEQUENCE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Auto assign lowest sequence

Y/N Table Edit

51 INCLUDE_IN_TSCRPT Character(1) VARCHAR2(1) NOT NULL Include in Transcript
52 FA_SS_ACCEPT Character(1) VARCHAR2(1) NOT NULL Accept

Y/N Table Edit

53 FA_SS_DECLINE Character(1) VARCHAR2(1) NOT NULL Decline

Y/N Table Edit

54 FA_SS_REDUX Character(1) VARCHAR2(1) NOT NULL Reduce

Y/N Table Edit