SSF_SL_HIST(SQL Table) |
Index Back |
---|---|
StudyLink History Table |
# | 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 | 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_SL_FILE_NBR | 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. |