SFA_LN_CNSL_SVW

(SQL View)
 Index Back

Loan Counseling Setup

Loan Counseling Setup view

SELECT A.INSTITUTION ,A.AID_YEAR ,A.SFA_LOAN_CODE ,A.SFA_LN_SOURCE ,A.SFA_LOAN_TYPE ,A.SFA_ENTRANCE_TYPE ,A.SFA_ENTRANCE_URL ,A.SFA_EXIT_TYPE ,A.SFA_EXIT_URL ,A.SFA_EXIT_DATE_TYPE ,A.SFA_EXIT_DATE_CALC ,A.SFA_EXIT_DATE ,B.SETID ,B.ITEM_TYPE FROM PS_SFA_LN_CNSL_SU A , PS_SFA_LN_CNSL_SU2 B WHERE A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.SFA_LOAN_CODE = B.SFA_LOAN_CODE

# 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: FED_AID_YR_TBL

3 SFA_LOAN_CODE Character(4) VARCHAR2(4) NOT NULL Loan Code

Prompt Table: SFA_LN_CNSL_LVW

4 SFA_LN_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
F=Federal
I=Institutional
P=Private
S=State
5 SFA_LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type
GPLS=Graduate PLUS Loan
HEAL=Health Education Assistance Ln
HPSL=Health Profession Student Loan
LDS=Loan for Disadvantage Student
NURS=Nursing Loan
PCL=Primary Care Loan
PERK=Federal Perkins Loan Program
PLUS=Federal PLUS
STAF=Federal Stafford
6 SFA_ENTRANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Entrance Requirement
A=Required Annually
M=Required Once

Default Value: M

7 SFA_ENTRANCE_URL Character(254) VARCHAR2(254) NOT NULL Entrance Counseling URL
8 SFA_EXIT_TYPE Character(1) VARCHAR2(1) NOT NULL Exit Type
A=Required Annually
M=Required Once

Default Value: M

9 SFA_EXIT_URL Character(254) VARCHAR2(254) NOT NULL Exit Counseling URL
10 SFA_EXIT_DATE_TYPE Character(1) VARCHAR2(1) NOT NULL Use Default Exit Date

Y/N Table Edit

Default Value: Y

11 SFA_EXIT_DATE_CALC Character(2) VARCHAR2(2) NOT NULL Exit Date Calculation Choice

Default Value: 30

12 SFA_EXIT_DATE Date(10) DATE Exit Date

Default Value: %date

13 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

14 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: ITEM_TYPE_LN_VW