INSTITUTIONSSF_SL_FILE_NBRSEQNODEC=Non Payment of Fees File
IVS=Verification of Study Response
PAY=Payment Schedule
REF=Fee Refunds
VOS=Verification of Study Requests
SSF_SL_PAYP_VW(SQL View) |
Index Back |
|---|---|
Processed PAY file View |
| SELECT A.INSTITUTION ,A.SSF_SL_FILE_NBR ,A.SEQNO ,A.EMPLID ,A.SSF_RECEIVED_AMT ,A.SSF_REFUND_AMT ,B.FILENAME ,B.SSF_SL_FILE_TYPE ,B.SSF_TRANS_DATE FROM PS_SSF_SL_PAY A , PS_SSF_SL_FILE_HDR B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSF_SL_FILE_NBR = B.SSF_SL_FILE_NBR AND B.SSF_SL_FILE_STATUS = 'P' |
| # | 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 |
| 7 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 8 | 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 |
| 9 | SSF_TRANS_DATE | Date(10) | DATE | Transaction Date |