INSTITUTIONEMPLIDSSF_SL_LOAN_NBRY/N Table Edit
Default Value: N
SSF_SL_LOAN(SQL Table) |
Index Back |
|---|---|
StudyLink Loan Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SSF_SL_LOAN_NBR |
Number(3,0) | SMALLINT NOT NULL | StudyLink loan number unique for each student. |
| 4 | SSF_STUDY_START | Date(10) | DATE | Start date of the earliest class for the study period. |
| 5 | SSF_SL_START_DATE | Date(10) | DATE | Start date for the studylink loan. |
| 6 | SSF_SL_END_DATE | Date(10) | DATE | End date of StudyLink Loan. |
| 7 | SSF_REQUESTED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Requested Amount |
| 8 | SSF_RECEIVED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Received Amount |
| 9 | SSF_LOAN_DECLINED | Character(1) | VARCHAR2(1) NOT NULL | Loan Declined |
| 10 | SSF_REVOS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates whether a manual VOS will be generated for the student.
Y/N Table Edit Default Value: N |