SFA_LN_CNSL_FVW

(SQL View)
 Index Back

Loan Counseling View


SELECT A.INSTITUTION ,A.EMPLID ,A.AID_YEAR ,A.SFA_LOAN_CODE ,A.SFA_LN_CNSL_TYPE ,A.SFA_LN_CNSL_REQ ,A.SFA_LN_CNSL_STATUS ,A.SFA_LN_CNSL_CMP_DT ,A.SFA_LN_CNSL_MSG ,B.SFA_LN_SOURCE ,B.SFA_LOAN_TYPE ,B.SFA_ENTRANCE_TYPE ,B.SFA_ENTRANCE_URL ,B.SFA_EXIT_TYPE ,B.SFA_EXIT_URL ,B.SFA_EXIT_DATE_TYPE ,B.SFA_EXIT_DATE_CALC ,B.SFA_EXIT_DATE FROM PS_SFA_LN_CNSL_TBL A , PS_SFA_LN_CNSL_SU 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: FED_AID_YR_TBL

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

Prompt Table: SFA_LN_CNSL_LVW

5 SFA_LN_CNSL_TYPE Character(1) VARCHAR2(1) NOT NULL Counseling Type
1=Entrance
2=Exit
6 SFA_LN_CNSL_REQ Character(1) VARCHAR2(1) NOT NULL Counseling Requirement
A=Required Annually
M=Required Once
7 SFA_LN_CNSL_STATUS Character(1) VARCHAR2(1) NOT NULL Status
C=Completed
I=Incomplete
P=Pending

Default Value: P

8 SFA_LN_CNSL_CMP_DT Date(10) DATE Date Completed
9 SFA_LN_CNSL_MSG Character(254) VARCHAR2(254) NOT NULL Comment
10 SFA_LN_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
F=Federal
I=Institutional
P=Private
S=State
11 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
12 SFA_ENTRANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Entrance Requirement
A=Required Annually
M=Required Once

Default Value: M

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

Default Value: M

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

Y/N Table Edit

Default Value: Y

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

Default Value: 30

18 SFA_EXIT_DATE Date(10) DATE Exit Date

Default Value: %date