SFA_CRC_LOAD_VW

(SQL View)
 Index Back

SELECT A.SFA_CR_DOCUMENT_ID , A.SFA_CR_DEST_ID , B.SFA_CR_ATT_SCHL_ID , B.SFA_CR_STUDENT_ID , B.SFA_CR_AWARD_TYPE , B.SFA_CR_AWARD_YEAR , B.SFA_CR_AWARD_SEQ , B.SFA_CR_AWARD_AMT , B.SFA_CR_GUAR_ST_CD , B.SFA_CR_AWARD_STAT , B.LN_CL_ERROR_RSN_CD , C.SFA_CR_AWARD_ID , B.SFA_CR_GUAR_ST_DTM , B.SFA_CR_LNDR_ST_CD , B.SFA_CR_LNDR_ST_DTM , B.SFA_CR_PNT_STAT_CD , B.SFA_CR_PNT_ST_DTTM , B.SFA_CR_CRD_STAT_CD , B.SFA_CR_CRD_ST_DTTM , B.SFA_CR_ALT_LOAN_CD , A.SFA_CR_DOC_TYPE FROM PS_SFA_CRC_DOCUMNT A , PS_SFA_CRC_AWARD B , PS_SFA_CRC_LN_INFO C WHERE A.SFA_CR_DOCUMENT_ID = B.SFA_CR_DOCUMENT_ID AND A.SFA_CR_RECIP_ID = B.SFA_CR_RECIP_ID AND B.SFA_CR_DOCUMENT_ID = C.SFA_CR_DOCUMENT_ID AND B.SFA_CR_RECIP_ID = C.SFA_CR_RECIP_ID AND B.SFA_CR_ATT_SCHL_ID = C.SFA_CR_ATT_SCHL_ID AND B.SFA_CR_STUDENT_ID = C.SFA_CR_STUDENT_ID AND B.SFA_CR_LOAN_KEY = C.SFA_CR_LOAN_KEY

# 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_DEST_ID Character(8) VARCHAR2(8) NOT NULL Destination 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_AWARD_AMT Character(12) VARCHAR2(12) NOT NULL Award Amount
9 SFA_CR_GUAR_ST_CD Character(2) VARCHAR2(2) NOT NULL Guarantor Status Code
10 SFA_CR_AWARD_STAT Character(4) VARCHAR2(4) NOT NULL Award Status Code
E=Error
P=Processing Complete
S=Skipped Record
U=Unprocessed
11 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
12 SFA_CR_AWARD_ID Character(21) VARCHAR2(21) NOT NULL Award ID
13 SFA_CR_GUAR_ST_DTM Character(23) VARCHAR2(23) NOT NULL Guarantor Status Date Time
14 SFA_CR_LNDR_ST_CD Character(2) VARCHAR2(2) NOT NULL Lender Status Code
15 SFA_CR_LNDR_ST_DTM Character(23) VARCHAR2(23) NOT NULL Lender Status Date Time
16 SFA_CR_PNT_STAT_CD Character(2) VARCHAR2(2) NOT NULL Promissory Note Status Code
17 SFA_CR_PNT_ST_DTTM Character(23) VARCHAR2(23) NOT NULL Promissory Note Stat Date Time
18 SFA_CR_CRD_STAT_CD Character(2) VARCHAR2(2) NOT NULL Credit Status Code
19 SFA_CR_CRD_ST_DTTM Character(23) VARCHAR2(23) NOT NULL Credit Status Date Time
20 SFA_CR_ALT_LOAN_CD Character(3) VARCHAR2(3) NOT NULL Alternative Loan Program Code
21 SFA_CR_DOC_TYPE Character(35) VARCHAR2(35) NOT NULL Document Type