SSF_SL_PAY (SQL Table)	Index Back
StudyLink Pay Table This table contains all payments made by StudyLink to students as listed in a PAY file. It also contains all refunds going back to StudyLink as listed in an REF file.

SSF_SL_PAY

(SQL Table)

StudyLink Pay Table

This table contains all payments made by StudyLink to students as listed in a PAY file. It also contains all refunds going back to StudyLink as listed in an REF file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 SSF_SL_FILE_NBR Number(12,0) DECIMAL(12) NOT NULL Unique system assigned number identifying a file coming from StudyLink.

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 SSF_RECEIVED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Received Amount

6 SSF_REFUND_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Refund Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SSF_SL_FILE_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Unique system assigned number identifying a file coming from StudyLink.
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	SSF_RECEIVED_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Received Amount
6	SSF_REFUND_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Refund Amount