SSF_SL_FILE_HDR

#	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	SSF_SL_FILE_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Unique system assigned number identifying a file coming from StudyLink.
3	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
4	SSF_DIRECTION	Character(1)	VARCHAR2(1) NOT NULL	Indicates the direction of the file being reported. I=Inbound O=Outbound
5	SSF_TRANS_DATE	Date(10)	DATE	Transaction Date
6	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
7	SSF_RECORD_COUNT	Number(7,0)	INTEGER NOT NULL	Record Count
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	SSF_SL_LNK_FILE	Number(12,0)	DECIMAL(12) NOT NULL	StudyLink Linked File Number
10	SSF_SL_AMOUNT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	StudyLink Amount
11	SSF_SL_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether processing for a StudyLink file has been completed. C=In Progress P=Processed