SFA_SHS_INTR_WH

(SQL Table)
Index Back

Shopping sheet setup for Inter

Shopping sheet setup for Interest Rates and Work Hours

# 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 SFA_SS_GROUP Character(10) VARCHAR2(10) NOT NULL Group
4 SFA_SHS_FED_SLOAN Number(5,2) DECIMAL(4,2) NOT NULL Fed Direct Subsidized Loan
5 SFA_SHS_FED_USLOAN Number(5,2) DECIMAL(4,2) NOT NULL Fed Direct Unsubsidized Loan
6 SFA_SHS_PRVT_LOAN Number(5,2) DECIMAL(4,2) NOT NULL Private Loan
7 SFA_SHS_INST_LOAN Number(5,2) DECIMAL(4,2) NOT NULL Institutional Loan
8 SFA_SHS_PPLUS_LOAN Number(5,2) DECIMAL(4,2) NOT NULL Parent Plus Federal Loan
9 SFA_SHS_WRK_HRS Number(2,0) SMALLINT NOT NULL Hours Per Week
10 SFA_SHS_FED_GPLOAN Number(5,2) DECIMAL(4,2) NOT NULL Grad Plus Federal Loan
11 SFA_SHS_HRSA_LOAN Number(5,2) DECIMAL(4,2) NOT NULL HRSA Loan
12 SFA_SHS_FSUB_ORIG Number(5,2) DECIMAL(4,2) NOT NULL Fed Direct Sub Loan Orig Fee
13 SFA_SHS_FUSUB_ORIG Number(5,2) DECIMAL(4,2) NOT NULL Fed Direct Unsub Loan Orig Fee
14 SFA_SHS_GPLN_ORIG Number(5,2) DECIMAL(4,2) NOT NULL Grad Plus Loan Orig Fee
15 SFA_SHS_HRSA_ORIG Number(5,2) DECIMAL(4,2) NOT NULL HRSA Loan Orig Fee
16 SFA_SHS_IMLN_ORIG Number(5,2) DECIMAL(4,2) NOT NULL Institutional Loan Orig Fee
17 SFA_SHS_PP_LN_ORIG Number(5,2) DECIMAL(4,2) NOT NULL Parent Plus Loan Orig Fee
18 SFA_SHS_PERCNT_INC Number(5,2) DECIMAL(4,2) NOT NULL Percentage of Income
19 SFA_SHS_NO_MNTHS Number(3,0) SMALLINT NOT NULL Number of Months