SFA_STPSTWD_AUD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: STDNT_FA_TRM_VW |
| 5 | RTRN_TIV_PGM_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Program Type (Credit/Clock Hr)
L=Clock Hour Program R=Credit Hour Program Default Value: R |
| 6 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | STDNT_PWD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Post-Withdrawal Disb Status
C=Completed P=Pending |
| 8 | RTRN_TIV_AID_EARN | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | D. TIV Aid Earned |
| 9 | TOTAL_TIV_DISB | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | A. Total TIV Aid Disb |
| 10 | RTRN_TIV_PWD | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | (Aid To Be Late Disbursed) |
| 11 | STU_NDISB_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 12 | STU_NDISB_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFel/Direct Staff |
| 13 | STU_NDISB_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 14 | STU_NDISB_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 15 | STU_NDISB_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Pell Grant |
| 16 | STU_NDISB_WK_6 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FSEOG |
| 17 | STU_NDISB_WK_7 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Other |
| 18 | STU_NDISB_WK_8 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | National SMART Grant |
| 19 | STU_NDISB_WK_9 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 20 | STU_NDISB_WK_10 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | TEACH Grant |
| 21 | STU_DISB_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 22 | STU_DISB_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 23 | STU_DISB_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 24 | STU_DISB_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 25 | STU_DISB_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Pell Grant |
| 26 | STU_DISB_WK_6 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FSEOG |
| 27 | STU_DISB_WK_7 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Other |
| 28 | STU_DISB_WK_8 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | National SMART Grant |
| 29 | STU_DISB_WK_9 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 30 | STU_DISB_WK_10 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | TEACH Grant |
| 31 | STU_RTN_PWD_CR_DT | Date(10) | DATE | Date Disbursements Credited |
| 32 | STU_RTN_PWD_OFF_DT | Date(10) | DATE | Date Disbursements Offered |
| 33 | STU_RTN_PWD_ACC_DT | Date(10) | DATE | Date Disbursements Accepted |
| 34 | STU_RTN_PWD_DEC_DT | Date(10) | DATE | Date Disbursements Declined |
| 35 | STU_RTN_PWD_DISBDT | Date(10) | DATE | Date Disbursements Made |
| 36 | RTRN_TIV_DAYS_PAST | Signed Number(4,0) | DECIMAL(3) NOT NULL | Days Elapsed * |
| 37 | SFA_LN_FUNDS_ND | Date(10) | DATE | Date Loan Funds Needed |
| 38 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 39 | RTRN_TIV_PROC_DTTM | DateTime(26) | TIMESTAMP | Process Instance DTTM |
| 40 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 41 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 42 | SFA_HERA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
RTIV Hera flag.
N=New RTIV HERA Version O=Old RTIV Version Default Value: N |
| 43 | RTRN_TIV_FORM_DT | Date(10) | DATE | Date Form Completed |
| 44 | SFA_AUTH_CREDIT | Date(10) | DATE | Date Authorized to Credit |
| 45 | SFA_BORR_NOTIF | Date(10) | DATE | Date Borrower Notified |
| 46 | SFA_AMT_CRED_CHGS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Amount Credited for Charges |
| 47 | SFA_AMT_CRED_OTHR | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Amount Credited for Other |
| 48 | SFA_AMT_CRED_PRIOR | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Amount Credited Prior Year |
| 49 | SFA_TOT_PWD_CRED | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total PWD Credited (Box 2) |
| 50 | SFA_RESP_RECV | Date(10) | DATE | Date Response Received |
| 51 | SFA_DT_RESP_RECV | Character(1) | VARCHAR2(1) NOT NULL |
Date Not Received
N=Not Received Y=Date Response Received |
| 52 | SFA_PWD_ACCEPT | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Amount PWD Accepted |
| 53 | SFA_DT_FNDS_MAIL | Date(10) | DATE | Date Accepted Funds Mailed |
| 54 | SFA_DT_FNDS_MAIL_L | Date(10) | DATE | Date Accepted Funds Mailed |
| 55 | SFA_GRNT_AID_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Pell Grant |
| 56 | SFA_GRNT_AID_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Academic Comp |
| 57 | SFA_GRNT_AID_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | National SMART Grant |
| 58 | SFA_GRNT_AID_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FSEOG |
| 59 | SFA_GRNT_AID_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | TEACH Grant |
| 60 | SFA_LN_AMT_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 61 | SFA_LN_AMT_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 62 | SFA_LN_AMT_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 63 | SFA_LN_AMT_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 64 | SFA_LN_AMT_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 65 | SFA_LN_AUTH_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 66 | SFA_LN_AUTH_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 67 | SFA_LN_AUTH_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 68 | SFA_LN_AUTH_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 69 | SFA_LN_AUTH_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 70 | SFA_AID_OFFRD_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 71 | SFA_AID_OFFRD_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 72 | SFA_AID_OFFRD_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 73 | SFA_AID_OFFRD_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 74 | SFA_AID_OFFRD_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 75 | SFA_AID_OFFRD_WK_6 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Pell Grant |
| 76 | SFA_AID_OFFRD_WK_7 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Academic Comp |
| 77 | SFA_AID_OFFRD_WK_8 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | National SMART Grant |
| 78 | SFA_AID_OFFRD_WK_9 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FSEOG |
| 79 | SFA_AID_OFRD_WK_10 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | TEACH Grant |
| 80 | SFA_AID_ACCPT_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 81 | SFA_AID_ACCPT_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 82 | SFA_AID_ACCPT_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 83 | SFA_AID_ACCPT_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 84 | SFA_AID_ACCPT_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 85 | SFA_AID_ACCPT_WK_6 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Pell Grant |
| 86 | SFA_AID_ACCPT_WK_7 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Academic Comp |
| 87 | SFA_AID_ACCPT_WK_8 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | National SMART Grant |
| 88 | SFA_AID_ACCPT_WK_9 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FSEOG |
| 89 | SFA_AID_ACPT_WK_10 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | TEACH Grant |
| 90 | SFA_PWD_SENT_DT | Date(10) | DATE |
PWD Notification Sent
N=Not Received Y=Date Response Received |
| 91 | SFA_RESP_DEDLN_DT | Date(10) | DATE | Response Deadline |
| 92 | SFA_RESP_DT | Character(1) | VARCHAR2(1) NOT NULL |
Response Received
N=Not Received Y=Date Response Received |
| 93 | SFA_NO_LATE_RESP | Character(1) | VARCHAR2(1) NOT NULL |
Late Response Not Accepted
Y/N Table Edit |
| 94 | SFA_AID_DISB_D_WK1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 95 | SFA_AID_DISB_D_WK2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 96 | SFA_AID_DISB_D_WK3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 97 | SFA_AID_DISB_D_WK4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 98 | SFA_AID_DISB_D_WK5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |
| 99 | SFA_AID_DISB_D_WK6 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Pell Grant |
| 100 | SFA_AID_DISB_D_WK7 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Academic Comp |
| 101 | SFA_AID_DISB_D_WK8 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | National SMART Grant |
| 102 | SFA_AID_DISB_D_WK9 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FSEOG |
| 103 | SFA_AID_DIS_D_WK10 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | TEACH Grant |
| 104 | SFA_LN_AID_CR_WK_1 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Unsub FFEL/Direct |
| 105 | SFA_LN_AID_CR_WK_2 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Sub FFEL/Direct Staff |
| 106 | SFA_LN_AID_CR_WK_3 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Perkins |
| 107 | SFA_LN_AID_CR_WK_4 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Dir PLUS (Grad) |
| 108 | SFA_LN_AID_CR_WK_5 | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | FFEL/Direct PLUS |