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.