SFA_CR_DOCUMENT_IDSFA_CR_ATT_SCHL_IDSFA_CR_AWARD_IDSFA_COD_CROF_VW(SQL View) |
Index Back |
|---|---|
COD CROF ViewUse to identify CROF records. |
| SELECT A.SFA_CR_DOCUMENT_ID ,B.SFA_CR_ATT_SCHL_ID ,D.SFA_CR_AWARD_ID ,D.SFA_CR_AWARD_NAME ,D.SFA_CR_AWARD_YEAR ,D.SFA_CR_AWARD_NBR ,B.SFA_CR_ID_SSN ,B.SFA_CR_ID_BIRTH_DT ,B.SFA_CR_ID_LAST_NAM ,B.SFA_CR_FIRST_NAME ,B.SFA_CR_MIDDLE_INIT ,C.SFA_CR_ORG_FEE_PCT ,C.SFA_CR_INT_REB_PCT ,C.SFA_CR_GRADE_LEVEL ,D.SFA_CR_AWARD_AMT ,E.SFA_CR_DISB_NBR ,E.SFA_CR_DISB_DT ,E.SFA_CR_DISB_AMT ,E.SFA_CR_DSB_NET_AMT ,E.SFA_CR_DSB_FEE_AMT ,E.SFA_CR_DSB_REB_AMT FROM PS_SFA_COD_DOCUMNT A ,PS_SFA_COD_STUDENT B ,PS_SFA_COD_LN_INFO C ,PS_SFA_COD_AWARD D ,PS_SFA_COD_DISB E WHERE A.SFA_CR_DOCUMENT_ID = B.SFA_CR_DOCUMENT_ID AND A.SFA_CR_DOC_TYPE = 'OF' AND B.SFA_CR_DOCUMENT_ID = C.SFA_CR_DOCUMENT_ID AND B.SFA_CR_RPT_SCHL_ID = C.SFA_CR_RPT_SCHL_ID AND B.SFA_CR_ATT_SCHL_ID = C.SFA_CR_ATT_SCHL_ID AND B.EMPLID = C.EMPLID AND B.SFA_CR_DOCUMENT_ID = D.SFA_CR_DOCUMENT_ID AND B.SFA_CR_RPT_SCHL_ID = D.SFA_CR_RPT_SCHL_ID AND B.SFA_CR_ATT_SCHL_ID = D.SFA_CR_ATT_SCHL_ID AND B.EMPLID = D.EMPLID AND C.SFA_CR_LOAN_KEY = D.SFA_CR_LOAN_KEY AND D.SFA_CR_DOCUMENT_ID = E.SFA_CR_DOCUMENT_ID AND D.SFA_CR_RPT_SCHL_ID = E.SFA_CR_RPT_SCHL_ID AND D.SFA_CR_ATT_SCHL_ID = E.SFA_CR_ATT_SCHL_ID AND D.EMPLID = E.EMPLID AND D.SFA_CR_AWARD_NAME = E.SFA_CR_AWARD_NAME AND D.SFA_CR_AWARD_YEAR = E.SFA_CR_AWARD_YEAR AND D.SFA_CR_AWARD_NBR = E.SFA_CR_AWARD_NBR |
| # | 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_ATT_SCHL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Attended School ID |
| 3 | SFA_CR_AWARD_ID |
Character(21) | VARCHAR2(21) NOT NULL | Award ID |
| 4 | SFA_CR_AWARD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Award Name |
| 5 | SFA_CR_AWARD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Award Year |
| 6 | SFA_CR_AWARD_NBR | Number(2,0) | SMALLINT NOT NULL | Award Number |
| 7 | SFA_CR_ID_SSN | Character(9) | VARCHAR2(9) NOT NULL | SSN Identifier |
| 8 | SFA_CR_ID_BIRTH_DT | Character(10) | VARCHAR2(10) NOT NULL | Birthdate Identifier |
| 9 | SFA_CR_ID_LAST_NAM | Character(35) | VARCHAR2(35) NOT NULL | Last Name Identifier |
| 10 | SFA_CR_FIRST_NAME | Character(35) | VARCHAR2(35) NOT NULL | First Name |
| 11 | SFA_CR_MIDDLE_INIT | Character(35) | VARCHAR2(35) NOT NULL | Middle Initial |
| 12 | DL_ORIG_FEE | Number(6,3) | DECIMAL(5,3) NOT NULL | DL Origination Fee % |
| 13 | SFA_CR_INT_REB_PCT | Character(7) | VARCHAR2(7) NOT NULL | Interest Rebate Percentage |
| 14 | SFA_CR_GRADE_LEVEL | Character(18) | VARCHAR2(18) NOT NULL | Student Level Code |
| 15 | SFA_CR_AWARD_AMT | Character(12) | VARCHAR2(12) NOT NULL | Award Amount |
| 16 | SFA_CR_DISB_NBR | Number(4,0) | SMALLINT NOT NULL | Disbursement Number |
| 17 | SFA_CR_DISB_DT | Character(10) | VARCHAR2(10) NOT NULL | Disbursement Date |
| 18 | SFA_CR_DISB_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Amount |
| 19 | SFA_CR_DSB_NET_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Net Amount |
| 20 | SFA_CR_DSB_FEE_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Fee Amount |
| 21 | LN_REBATE_AMT | Number(7,2) | DECIMAL(6,2) NOT NULL | Loan Rebate Amt |