INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: SSF_SL_INST
EMPLIDSSF_SL_FILE_NBRDEC=Non Payment of Fees File
IVS=Verification of Study Response
PAY=Payment Schedule
REF=Fee Refunds
VOS=Verification of Study Requests
SSF_SL_PAYR_VW(SQL View) |
Index Back |
|---|---|
Pay File Search ViewSearch view to bring up all PAY files from the StudyLink File table. |
| SELECT INSTITUTION , EMPLID , SSF_SL_FILE_NBR , SSF_SL_FILE_TYPE , SSF_TRANS_DATE FROM PS_SSF_SL_HIST WHERE SSF_SL_FILE_TYPE = 'PAY' OR SSF_SL_FILE_TYPE = 'REF' OR SSF_SL_FILE_TYPE = 'DEC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: SSF_SL_INST |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SSF_SL_FILE_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Unique system assigned number identifying a file coming from StudyLink. |
| 4 | 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 |
| 5 | SSF_TRANS_DATE | Date(10) | DATE | Transaction Date |