INSTITUTIONPrompt Table: INSTITUTION_TBL
EMPLIDSSF_SL_LOAN_NBRSSF_SL_FILE_NBRDEC=Non Payment of Fees File
IVS=Verification of Study Response
PAY=Payment Schedule
REF=Fee Refunds
VOS=Verification of Study Requests
F=Fee VOS
V=Study VOS
SSF_SL_HIST_VW(SQL View) |
Index Back |
|---|---|
View based on History recordView based on History record |
| SELECT A.INSTITUTION , A.EMPLID , A.SSF_SL_LOAN_NBR , A.SSF_SL_FILE_NBR , A.SSF_SL_FILE_TYPE , B.FILENAME , A.SSF_TRANS_DATE , A.SSF_STUDY_START , A.SSF_SL_STATUS , A.SSF_FEE_FLAG , A.SSF_SL_AMOUNT FROM PS_SSF_SL_HIST A , PS_SSF_SL_FILE_HDR B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSF_SL_FILE_NBR = B.SSF_SL_FILE_NBR |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SSF_SL_LOAN_NBR |
Number(3,0) | SMALLINT NOT NULL | StudyLink loan number unique for each student. |
| 4 | SSF_SL_FILE_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Unique system assigned number identifying a file coming from StudyLink. |
| 5 | 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 |
| 6 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 7 | SSF_TRANS_DATE | Date(10) | DATE | Transaction Date |
| 8 | SSF_STUDY_START | Date(10) | DATE | Start date of the earliest class for the study period. |
| 9 | SSF_SL_STATUS | Character(2) | VARCHAR2(2) NOT NULL | Student's status on the VOS cycle. |
| 10 | SSF_FEE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if fee details are required.
F=Fee VOS V=Study VOS |
| 11 | SSF_SL_AMOUNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | StudyLink Amount |