| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SFA_CR_DOCUMENT_ID |
Character(34) |
VARCHAR2(34) NOT NULL |
Document ID
|
| 2 |
SFA_CR_RECIP_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
CRC Recipient ID
|
| 3 |
SFA_CR_ATT_SCHL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Attended School ID
|
| 4 |
SFA_CR_STUDENT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
School Assigned Student Id
|
| 5 |
SFA_CR_AWARD_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Award Type
|
| 6 |
SFA_CR_AWARD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Award Year
|
| 7 |
SFA_CR_AWARD_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Award Sequence Number
|
| 8 |
SFA_CR_LOAN_KEY |
Number(2,0) |
SMALLINT NOT NULL |
Loan Key
|
| 9 |
SFA_CR_DFLT_OVRPAY |
Character(3) |
VARCHAR2(3) NOT NULL |
Default/Overpay
|
| 10 |
SFA_CR_AWARD_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Award Number
|
| 11 |
SFA_CR_AWARD_AMT |
Character(12) |
VARCHAR2(12) NOT NULL |
Award Amount
|
| 12 |
SFA_CR_LDRAPRV_AMT |
Character(12) |
VARCHAR2(12) NOT NULL |
Lender Approved Amount
|
| 13 |
SFA_CR_GUAR_DT |
Character(10) |
VARCHAR2(10) NOT NULL |
Guarantee Date
|
| 14 |
SFA_CR_BLNKT_GR_DT |
Character(10) |
VARCHAR2(10) NOT NULL |
Blanket Guarantee Date
|
| 15 |
SFA_CR_AWD_UPD_DT |
Character(10) |
VARCHAR2(10) NOT NULL |
Financial Award Update Date
|
| 16 |
SFA_CR_REALLOC_ID |
Character(19) |
VARCHAR2(19) NOT NULL |
Reallocation Award ID
|
| 17 |
SFA_CR_GRSS_LN_AMT |
Character(12) |
VARCHAR2(12) NOT NULL |
Gross Loan Amount
|
| 18 |
SFA_CR_EXIT_DT |
Character(10) |
VARCHAR2(10) NOT NULL |
Exit Date
|
| 19 |
SFA_CR_SCHOOL_MSG |
Character(23) |
VARCHAR2(23) NOT NULL |
School Note Message
|
| 20 |
SFA_CR_GUAR_MSG |
Character(23) |
VARCHAR2(23) NOT NULL |
Guarantor Note Message
|
| 21 |
SFA_CR_LENDER_MSG |
Character(23) |
VARCHAR2(23) NOT NULL |
Lender Note Message
|
| 22 |
SFA_CR_GUAR_ST_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Guarantor Status Code
|
| 23 |
SFA_CR_GUAR_ST_DTM |
Character(23) |
VARCHAR2(23) NOT NULL |
Guarantor Status Date Time
|
| 24 |
SFA_CR_LNDR_ST_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Lender Status Code
|
| 25 |
SFA_CR_LNDR_ST_DTM |
Character(23) |
VARCHAR2(23) NOT NULL |
Lender Status Date Time
|
| 26 |
SFA_CR_PNT_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Promissory Note Status Code
|
| 27 |
SFA_CR_PNT_ST_DTTM |
Character(23) |
VARCHAR2(23) NOT NULL |
Promissory Note Stat Date Time
|
| 28 |
SFA_CR_CRD_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Status Code
|
| 29 |
SFA_CR_CRD_ST_DTTM |
Character(23) |
VARCHAR2(23) NOT NULL |
Credit Status Date Time
|
| 30 |
SFA_CR_ALT_LOAN_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Alternative Loan Program Code
|
| 31 |
SFA_CR_ALT_APP_VER |
Character(4) |
VARCHAR2(4) NOT NULL |
Alternative Loan App Version
|
| 32 |
SFA_CR_INT_RT_OPT |
Character(8) |
VARCHAR2(8) NOT NULL |
Interest Rate Option
|
| 33 |
SFA_CR_RPMT_OPT_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Repayment Option Code
|
| 34 |
SFA_CR_UNQ_VEND_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Unique Layout Vendor Code
|
| 35 |
SFA_CR_UNQ_ID_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Unique Layout Identifier Code
|
| 36 |
SFA_CR_UNQ_DATA |
Character(65) |
VARCHAR2(65) NOT NULL |
Unique Data
|
| 37 |
SFA_CR_SRV_TYPE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Service Type Code
|
| 38 |
SFA_CR_CURGUAR_AMT |
Character(12) |
VARCHAR2(12) NOT NULL |
Current Guarantee Amount
|
| 39 |
SFA_CR_GUAR_ADJUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Guarantee Adjustment Indicator
|
| 40 |
SFA_CR_GUAR_RED_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Guarantee Amount Reduction Cd
|
| 41 |
SFA_CR_REINST_AMT |
Character(12) |
VARCHAR2(12) NOT NULL |
Reinstatement Available Amount
|
| 42 |
SFA_CR_ACT_INT_RT |
Character(6) |
VARCHAR2(6) NOT NULL |
Actual Interest Rate
|
| 43 |
SFA_CR_REVNTE_GUAR |
Character(7) |
VARCHAR2(7) NOT NULL |
Revised Notice Of Guarantee
|
| 44 |
SFA_CR_RSP_TYPE_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Response Type Code
|
| 45 |
SFA_CR_TOT_NBR_DSB |
Character(2) |
VARCHAR2(2) NOT NULL |
Total Number Scheduled Disb
|
| 46 |
SFA_CR_AWD_CONF_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Fin Award Confirmation Code
|
| 47 |
SFA_CR_RESPONSE_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Response Code
|
| 48 |
SFA_CR_AWARD_STAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Award Status Code
E=Error
P=Processing Complete
S=Skipped Record
U=Unprocessed
|
| 49 |
LN_CL_ERROR_RSN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
CL Error Reason Code
A=Award Disbursement Discrepancy
C=Loan Certification Rqst
D=Destination Not Found
E=Processing Error
F=Disbursement not found
G=Invalid Award Id
H=Loan On Hold
I=Invalid Loan Type Code
J=Not Participating CR Destn
K=Invalid School Code
L=Loan Not Found
M=Loan Common Module Error
N=No Errors
P=Process Not Supported
S=Source Data Corruption
T=Loan Tolerance Amt Exceeded
U=Unknown or Invalid Loan Type
X=Uninitiated Change
Z=CL4 Conversion Error
|