SSF_SL_HIST(SQL Table) |
Index Back |
|---|---|
StudyLink History Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
| 2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 3 | Number(3,0) | SMALLINT NOT NULL | StudyLink loan number unique for each student. | |
| 4 | Number(12,0) | DECIMAL(12) NOT NULL | Unique system assigned number identifying a file coming from StudyLink. | |
| 5 | SSF_SL_FILE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Types of files coming from and going to StudyLink
DEC=Non Payment of Fees File IVS=Verification of Study Response PAY=Payment Schedule REF=Fee Refunds VOS=Verification of Study Requests |
| 6 | SSF_TRANS_DATE | Date(10) | DATE | Transaction Date |
| 7 | SSF_STUDY_START | Date(10) | DATE | Start date of the earliest class for the study period. |
| 8 | SSF_SL_STATUS | Character(2) | VARCHAR2(2) NOT NULL | Student's status on the VOS cycle. |
| 9 | SSF_FEE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if fee details are required.
F=Fee VOS V=Study VOS |
| 10 | SSF_SL_AMOUNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | StudyLink Amount |
| 11 | SSF_STUDY_YEAR | Number(4,0) | SMALLINT NOT NULL | Study Year |
| 12 | SSF_REVOS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | This field indicates whether a manual VOS will be generated for the student. |