SSF_SL_PAYF_VW(SQL View) |
Index Back |
|---|---|
Pay File Search ViewSearch view to bring up all PAY files from the StudyLink File table. |
| SELECT INSTITUTION , SSF_SL_FILE_NBR , SSF_SL_FILE_TYPE , SSF_TRANS_DATE , FILENAME , SSF_RECORD_COUNT , SSF_SL_AMOUNT , SSF_SL_FILE_STATUS FROM PS_SSF_SL_FILE_HDR 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 | 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 Prompt Table: SSF_TYP2_XLT_VW |
| 4 | SSF_TRANS_DATE | Date(10) | DATE | Transaction Date |
| 5 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 6 | SSF_RECORD_COUNT | Number(7,0) | INTEGER NOT NULL | Record Count |
| 7 | SSF_SL_AMOUNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | StudyLink Amount |
| 8 | 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 |