PROCESS_INSTANCEUPG_COD_AWD_AET(SQL Table) |
Index Back |
|---|---|
COD Award InformationContains Student Award information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SFA_CR_DOCUMENT_ID | Character(34) | VARCHAR2(34) NOT NULL | Document ID |
| 3 | SFA_CR_RPT_SCHL_ID | Character(8) | VARCHAR2(8) NOT NULL | Reporting School ID |
| 4 | SFA_CR_ATT_SCHL_ID | Character(8) | VARCHAR2(8) NOT NULL | Attended School ID |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | SFA_CR_AWARD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Award Name |
| 7 | SFA_CR_AWARD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Award Year |
| 8 | SFA_CR_AWARD_NBR | Number(2,0) | SMALLINT NOT NULL | Award Number |
| 9 | SFA_CR_LOAN_KEY | Number(2,0) | SMALLINT NOT NULL | Loan Key |
| 10 | SFA_CR_CPS_TRN_NBR | Character(2) | VARCHAR2(2) NOT NULL | CPS Transaction Number |
| 11 | SFA_CR_AWARD_AMT | Character(12) | VARCHAR2(12) NOT NULL | Award Amount |
| 12 | SFA_CR_NOTE_MSG | Character(20) | VARCHAR2(20) NOT NULL | Note Message |
| 13 | SFA_CR_DEPEND_STAT | Character(1) | VARCHAR2(1) NOT NULL | Dependency Status |
| 14 | SFA_CR_DFLT_OVRPAY | Character(3) | VARCHAR2(3) NOT NULL | Default/Overpay |
| 15 | SFA_CR_AWARD_ID | Character(21) | VARCHAR2(21) NOT NULL | Award ID |
| 16 | SFA_CR_AWD_CRE_DT | Character(10) | VARCHAR2(10) NOT NULL | Award Create Date |
| 17 | SFA_CR_HPPA_IND | Character(5) | VARCHAR2(5) NOT NULL | HPPA Indicator |
| 18 | SFA_CR_AWD_AMT_RQD | Character(12) | VARCHAR2(12) NOT NULL | Award Amount Requested |
| 19 | SFA_CR_COA | Character(12) | VARCHAR2(12) NOT NULL | Attendance Cost |
| 20 | SFA_CR_ACAD_CAL_CD | Character(1) | VARCHAR2(1) NOT NULL | Academic Calendar Code |
| 21 | SFA_CR_PMT_METHOD | Character(1) | VARCHAR2(1) NOT NULL | Payment Methodology |
| 22 | SFA_CR_WEEKS_USED | Character(2) | VARCHAR2(2) NOT NULL | Weeks Used to Calc |
| 23 | SFA_CR_WEEKS_PROG | Character(2) | VARCHAR2(2) NOT NULL | Weeks Program Acad Yr |
| 24 | SFA_CR_HOURS_AWARD | Character(4) | VARCHAR2(4) NOT NULL | Hours Award Year |
| 25 | SFA_CR_HOURS_PROG | Character(4) | VARCHAR2(4) NOT NULL | Hours Program Acad Year |
| 26 | SFA_CR_LOW_TUIT_CD | Character(1) | VARCHAR2(1) NOT NULL | Low Tuition Fees |
| 27 | SFA_CR_INCARCERATE | Character(5) | VARCHAR2(5) NOT NULL | Incarcerated Indicator |
| 28 | SFA_CR_VERIF_STAT | Character(1) | VARCHAR2(1) NOT NULL | Verification Status Code |
| 29 | SFA_CR_ENROLL_DT | Character(10) | VARCHAR2(10) NOT NULL | Enrollment Date |
| 30 | SFA_CR_SEC_EFC_CD | Character(1) | VARCHAR2(1) NOT NULL | Secondary EFC Code |
| 31 | SFA_CR_LESSTHAN_FT | Character(5) | VARCHAR2(5) NOT NULL | Less Than FullTime |
| 32 | SFA_CR_FED_SHR_AMT | Character(12) | VARCHAR2(12) NOT NULL | Federal Share Amount |
| 33 | SFA_CR_GRADE_LEVEL | Character(18) | VARCHAR2(18) NOT NULL | Student Level Code |
| 34 | SFA_CR_FISAP_INC | Character(12) | VARCHAR2(12) NOT NULL | FISAP Income Amount |
| 35 | SFA_CR_RESPONSE_CD | Character(15) | VARCHAR2(15) NOT NULL | Response Code |
| 36 | SFA_CR_EMPN_IND | Character(5) | VARCHAR2(5) NOT NULL | eMPN Indicator |
| 37 | SFA_CR_MPN_ID | Character(21) | VARCHAR2(21) NOT NULL | MPN ID |
| 38 | SFA_CR_MPN_STAT | Character(1) | VARCHAR2(1) NOT NULL | MPN Status |
| 39 | SFA_CR_MPN_LINK | Character(5) | VARCHAR2(5) NOT NULL | MPN Link Indicator |
| 40 | SFA_CR_PMT_SRV_AMT | Character(11) | VARCHAR2(11) NOT NULL | Payment to Servicer Amt |
| 41 | SFA_CR_PMT_SRV_DT | Character(10) | VARCHAR2(10) NOT NULL | Payment to Servicer Date |
| 42 | SFA_CR_BKD_LN_AMT | Character(12) | VARCHAR2(12) NOT NULL | Booked Loan Amount |
| 43 | SFA_CR_BKD_LN_DT | Character(10) | VARCHAR2(10) NOT NULL | Booked Loan Date |
| 44 | SFA_CR_ENDORSE_AMT | Character(12) | VARCHAR2(12) NOT NULL | Endorser Amount |
| 45 | SFA_CR_CRD_DEC_ST | Character(1) | VARCHAR2(1) NOT NULL | Credit Decision Status |
| 46 | SFA_CR_CRD_DEC_DT | Character(10) | VARCHAR2(10) NOT NULL | Credit Decision Date |
| 47 | SFA_CR_CRD_OVR_CD | Character(1) | VARCHAR2(1) NOT NULL | Credit Override Code |
| 48 | SFA_CR_YTD_DSB_AMT | Character(12) | VARCHAR2(12) NOT NULL | Year-To-Date Disb Amt |
| 49 | SFA_CR_TOT_ELG_USD | Character(7) | VARCHAR2(7) NOT NULL | Total Eligibility Used |
| 50 | SFA_CR_SCHED_PELL | Character(12) | VARCHAR2(12) NOT NULL | Scheduled Pell Grant |
| 51 | SFA_CR_NEG_PND_AMT | Character(12) | VARCHAR2(12) NOT NULL | Negative Pending Amount |
| 52 | SFA_CR_FSA_CD | Character(2) | VARCHAR2(2) NOT NULL | FSA Code |
| 53 | SFA_CR_CPS_VERIF | Character(5) | VARCHAR2(5) NOT NULL | CPS Verification Indicator |
| 54 | SFA_CR_HIGHEST_CPS | Character(2) | VARCHAR2(2) NOT NULL | Highest CPS Transaction |
| 55 | SFA_CR_ELIG_RSN_CD | Character(2) | VARCHAR2(2) NOT NULL | Eligibility Payment Reason Cd |
| 56 | SFA_CR_HS_PROG_CD | Character(6) | VARCHAR2(6) NOT NULL | Rigorous High School Program |
| 57 | SFA_CR_PROG_CIP_CD | Character(20) | VARCHAR2(20) NOT NULL | Program CIP Code |
| 58 | SFA_CR_MPN_EXPIRE | Character(10) | VARCHAR2(10) NOT NULL | MPN Expire Date |
| 59 | SFA_CR_PPCRWRK_IND | Character(5) | VARCHAR2(5) NOT NULL | PreProfessional Coursewrk |
| 60 | CS_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Field used to indicated wors exist in App Engine |
| 61 | SFA_CR_ADDUSUB_IND | Character(5) | VARCHAR2(5) NOT NULL | Additional Unsubsidized |