SS_FA_LOAN_STAT (SQL Table)	Index Back
Self-Service Loan Status Tbl This table allows users to store custom descriptions for combinations of Loan Program, Loan Processing Status, and Loan Orig Trans. The custom description is used for the FA self-service pages.

SS_FA_LOAN_STAT

(SQL Table)

Self-Service Loan Status Tbl

This table allows users to store custom descriptions for combinations of Loan Program, Loan Processing Status, and Loan Orig Trans. The custom description is used for the FA self-service pages.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 LOAN_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Loan Process Status
C=Canceled
H=Hold
N=Offered And Not Accepted
O=Origination Pending
S=In Service
X=Terminated

3 LN_ORIG_TRANS Character(1) VARCHAR2(1) NOT NULL Loan Orig Trans Stat
A=Accepted
C=Change Pending Transmission
E=Error
O=Orig Pending Transmission
T=Transmitted

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	LOAN_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Loan Process Status C=Canceled H=Hold N=Offered And Not Accepted O=Origination Pending S=In Service X=Terminated
3	LN_ORIG_TRANS	Character(1)	VARCHAR2(1) NOT NULL	Loan Orig Trans Stat A=Accepted C=Change Pending Transmission E=Error O=Orig Pending Transmission T=Transmitted
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description