INSTITUTIONPrompt Table: INSTITUTION_TBL
SSF_SL_FILE_NBRSEQNON=Deselected
Y=Selected
Y/N Table Edit
SSF_SL_VOS_EXT(SQL Table) |
Index Back |
|---|---|
StudyLink VOS tableThis table contains all Verification of study records. |
| # | 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 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | SSF_SL_SELECTED | Character(1) | VARCHAR2(1) NOT NULL |
Selected flag
N=Deselected Y=Selected Y/N Table Edit |
| 6 | SSF_SL_CUR_FEE_REQ | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Current Fees Requested |
| 7 | SSF_SL_PRE_FEE_REQ | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Previous Fees Requested |