SFA_CR_DOCUMENT_IDSFA_CR_RPT_SCHL_IDSFA_CR_ATT_SCHL_IDEMPLIDSFA_CR_AWARD_NAMESFA_CR_AWARD_YEARSFA_CR_AWARD_NBRSFA_CR_DISB_NBRSFA_COD_DISB(SQL Table) |
Index Back |
|---|---|
COD Disbursement InformationContains Student Award Disbursement Information. |
| # | 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_RPT_SCHL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Reporting School ID |
| 3 | SFA_CR_ATT_SCHL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Attended School ID |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | SFA_CR_AWARD_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Award Name |
| 6 | SFA_CR_AWARD_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Award Year |
| 7 | SFA_CR_AWARD_NBR |
Number(2,0) | SMALLINT NOT NULL | Award Number |
| 8 | SFA_CR_DISB_NBR |
Number(4,0) | SMALLINT NOT NULL | Disbursement Number |
| 9 | SFA_CR_DISB_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Amount |
| 10 | SFA_CR_DISB_DT | Character(10) | VARCHAR2(10) NOT NULL | Disbursement Date |
| 11 | SFA_CR_DSB_RELEASE | Character(5) | VARCHAR2(5) NOT NULL | Disbursement Release |
| 12 | SFA_CR_DSB_SEQ_NBR | Character(2) | VARCHAR2(2) NOT NULL | Disbursement Sequence |
| 13 | SFA_CR_NOTE_MSG | Character(20) | VARCHAR2(20) NOT NULL | Note Message |
| 14 | SFA_CR_FIRST_DISB | Character(5) | VARCHAR2(5) NOT NULL | First Disbursement |
| 15 | SFA_CR_DSB_NET_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Net Amount |
| 16 | SFA_CR_DSB_FEE_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Fee Amount |
| 17 | SFA_CR_DSB_REB_AMT | Character(12) | VARCHAR2(12) NOT NULL | Disbursement Rebate Amount |
| 18 | SFA_CR_DSB_CONFIRM | Character(5) | VARCHAR2(5) NOT NULL | Disbursement Confirmation |
| 19 | SFA_CR_PMT_PER_DT | Character(10) | VARCHAR2(10) NOT NULL | Payment Period Start Date |
| 20 | SFA_CR_RESPONSE_CD | Character(15) | VARCHAR2(15) NOT NULL | Response Code |
| 21 | SFA_CR_PRV_SEQ_NBR | Character(2) | VARCHAR2(2) NOT NULL | Previous Disbursement Seq Nbr |
| 22 | SFA_CR_DISB_AMT_N | Number(12,2) | DECIMAL(11,2) NOT NULL | Disbursement Amount |
| 23 | SFA_CR_ENR_SCHLCD | Character(8) | VARCHAR2(8) NOT NULL | Enrollment School Code for use with the Department of Education financial aid. |
| 24 | SFA_CR_ENRLMNTSTAT | Character(1) | VARCHAR2(1) NOT NULL | Enrollment Status |
| 25 | SFA_CR_PROG_CIP_CD | Character(20) | VARCHAR2(20) NOT NULL | Program CIP Code |
| 26 | SFA_CR_PGMLENYEARS | Character(7) | VARCHAR2(7) NOT NULL | Published Pgm Length Years |
| 27 | SFA_CR_PGMLENMNTHS | Character(7) | VARCHAR2(7) NOT NULL | Published Pgm Length Months |
| 28 | SFA_CR_PGMLENWEEKS | Character(7) | VARCHAR2(7) NOT NULL | Published Pgm Length Weeks |
| 29 | SFA_CR_WKPGMACADYR | Character(7) | VARCHAR2(7) NOT NULL | Weeks Programs Academic Year |
| 30 | SFA_CR_SPECIALPGMS | Character(1) | VARCHAR2(1) NOT NULL | Special Programs |
| 31 | SFA_CR_PROGCREDLVL | Character(2) | VARCHAR2(2) NOT NULL | Program Credential Level |
| 32 | SFA_CR_CIPCD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | CIP Code Year |
| 33 | SFA_CR_INCAR_STU | Character(5) | VARCHAR2(5) NOT NULL | Incarcerated Student Indicator |
| 34 | SFA_CR_PMT_END_DT | Character(10) | VARCHAR2(10) NOT NULL | Payment Period End Date |
| 35 | SFA_CR_ENROL_INT | Character(4) | VARCHAR2(4) NOT NULL | 2425 COD Changes |