SFA_CR_DOCUMENT_IDSFA_CR_RECIP_IDSFA_CR_ATT_SCHL_IDSFA_CR_STUDENT_IDSFA_CR_LOAN_KEYSFA_CRC_LN_INFO(SQL Table) |
Index Back |
|---|---|
Loan InformationContains Loan Information. Each row is linked (via the Loan Key) to one or more rows in the Award Table. |
| # | 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_LOAN_KEY |
Number(2,0) | SMALLINT NOT NULL | Loan Key |
| 6 | SFA_CR_GRADE_LEVEL | Character(18) | VARCHAR2(18) NOT NULL | Student Level Code |
| 7 | SFA_CR_AWD_BEG_DT | Character(10) | VARCHAR2(10) NOT NULL | Award Begin Date |
| 8 | SFA_CR_AWD_END_DT | Character(10) | VARCHAR2(10) NOT NULL | Award End Date |
| 9 | SFA_CR_PRC_TYPE_CD | Character(2) | VARCHAR2(2) NOT NULL | Processing Type Code |
| 10 | SFA_CR_AWARD_ID | Character(21) | VARCHAR2(21) NOT NULL | Award ID |
| 11 | SFA_CR_ACAD_PGM_CD | Character(15) | VARCHAR2(15) NOT NULL | Academic Program Code |
| 12 | SFA_CR_ENROLL_STAT | Character(16) | VARCHAR2(16) NOT NULL | Enrollment Status Code |
| 13 | SFA_CR_GRAD_DT | Character(10) | VARCHAR2(10) NOT NULL | Graduation Date |
| 14 | SFA_CR_COA | Character(12) | VARCHAR2(12) NOT NULL | Attendance Cost |
| 15 | SFA_CR_EFA | Character(12) | VARCHAR2(12) NOT NULL | Estimated Financial Aid Amount |
| 16 | SFA_CR_EFC | Character(12) | VARCHAR2(12) NOT NULL | EFC |
| 17 | SFA_CR_AWD_CRE_DT | Character(10) | VARCHAR2(10) NOT NULL | Award Create Date |
| 18 | SFA_CR_AWD_AMT_RQD | Character(12) | VARCHAR2(12) NOT NULL | Award Amount Requested |
| 19 | SFA_CR_APP_FORM_CD | Character(1) | VARCHAR2(1) NOT NULL | Federal Application Form Code |
| 20 | SFA_CR_PNOTE_DLVRY | Character(5) | VARCHAR2(5) NOT NULL | Promissory Note Delivery Code |
| 21 | SFA_CR_SIGN_DT | Character(10) | VARCHAR2(10) NOT NULL | Signature Date |
| 22 | SFA_CR_SIGN_SRC_CD | Character(10) | VARCHAR2(10) NOT NULL | Signature Source Code |
| 23 | SFA_CR_ESIGN_IND | Character(5) | VARCHAR2(5) NOT NULL | eSignature Indicator |
| 24 | SFA_CR_ESIGN_TYPE | Character(8) | VARCHAR2(8) NOT NULL | eSignature Custodian |
| 25 | SFA_CR_ESIGN_OPEID | Character(8) | VARCHAR2(8) NOT NULL | eSignature OPEID |
| 26 | SFA_CR_ESIGN_BRNCH | Character(4) | VARCHAR2(4) NOT NULL | eSignature Branch ID |
| 27 | SFA_CR_GUAR_OPEID | Character(8) | VARCHAR2(8) NOT NULL | Guarantor OPEID |
| 28 | SFA_CR_GUAR_BRANCH | Character(4) | VARCHAR2(4) NOT NULL | Guarantor Branch ID |
| 29 | SFA_CR_PRF_LNDR_ID | Character(8) | VARCHAR2(8) NOT NULL | Preferred Borrower Lender |
| 30 | SFA_CR_LNDR_OPEID | Character(8) | VARCHAR2(8) NOT NULL | Lender OPEID |
| 31 | SFA_CR_LNDR_BRANCH | Character(4) | VARCHAR2(4) NOT NULL | Lender Branch ID |
| 32 | SFA_CR_DEFER_REQ | Character(5) | VARCHAR2(5) NOT NULL | Deferment Request Indicator |
| 33 | SFA_CR_BORR_INTRST | Character(5) | VARCHAR2(5) NOT NULL | Borrower Interest Indicator |
| 34 | SFA_CR_EFT_AUTH | Character(5) | VARCHAR2(5) NOT NULL | EFT Authorization Indicator |
| 35 | SFA_CR_BORR_REF | Character(5) | VARCHAR2(5) NOT NULL | Borrower References Indicator |
| 36 | SFA_CR_SERIAL_REQ | Character(5) | VARCHAR2(5) NOT NULL | Serial Loan Requested Ind |
| 37 | SFA_CR_OUTSTAND_LN | Character(5) | VARCHAR2(5) NOT NULL | Outstanding Loan Indicator |
| 38 | SFA_CR_REPRINT | Character(5) | VARCHAR2(5) NOT NULL | Reprint Indicator |
| 39 | SFA_CR_TERMINATE | Character(5) | VARCHAR2(5) NOT NULL | Terminate Indicator |
| 40 | SFA_CR_FULL_RSP_CD | Character(8) | VARCHAR2(8) NOT NULL | Full Response Flag |
| 41 | SFA_CR_RSP_TO_ORIG | Character(5) | VARCHAR2(5) NOT NULL | Response To Originator Ind |
| 42 | SFA_CR_LAST_RESORT | Character(5) | VARCHAR2(5) NOT NULL | Lender Of Last Resort Ind |
| 43 | SFA_CR_SERIAL_ACT | Character(5) | VARCHAR2(5) NOT NULL | Serial Loan Actual Indicator |
| 44 | SFA_CR_RESPONSE_CD | Character(15) | VARCHAR2(15) NOT NULL | Response Code |