SFA_CRC_ACTN_CD

(SQL Table)
Index Back

Loan Action Code Table

Table for maintaining Loan Action Codes (Loan Status) used in the processing of FFELP, Direct Loans, Alternative Loans. Contains standard CommonLine, Direct Loan, and user-defined action codes.

# 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

Default Value: F

2 SFA_CR_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Loan Action Type
C=Credit
D=Disbursement
E=Error
G=Guarantor
L=Lender
O=Origination
P=Promissory Note
3 SFA_CR_ACTION_CODE Character(4) VARCHAR2(4) NOT NULL Loan Action Code
4 SFA_DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
5 SFA_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 LN_ACTION_CTGRY Character(1) VARCHAR2(1) NOT NULL Loan Action Category
A=Accept - Allow Processing
R=Reject - Hold Processing
S=Status - Information Only