SSF_SL_VOSH_VW

(SQL View)
 Index Back

VOS History View


SELECT A.INSTITUTION , A.EMPLID , A.SSF_SL_LOAN_NBR , A.SSF_SL_FILE_NBR , B.SSR_PROSPECTUS_CD , A.SSF_SL_FILE_TYPE , A.SSF_TRANS_DATE , B.SSF_STUDY_START , A.SSF_SL_STATUS , B.SSF_FEE_FLAG , B.SSF_TOTAL_FEES , B.SSF_SL_AMOUNT , B.SSF_SL_EMPLID , B.SSF_SL_ID , B.SSF_SL_FIRST_NAME , B.SSF_SL_LAST_NAME , B.SSF_SL_BIRTHDATE ,%subrec(SSF_SL_PROS_SBR, b) FROM PS_SSF_SL_HIST A , PS_SSF_SL_VOS B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSF_SL_FILE_NBR = B.SSF_SL_FILE_NBR AND A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
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 SSR_PROSPECTUS_CD Character(6) VARCHAR2(6) NOT NULL The code that identifies a program or qualification on the New Zealand Ministry of Education Prospectus Database.
6 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
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_TOTAL_FEES Signed Number(16,2) DECIMAL(14,2) NOT NULL Total Fees
12 SSF_SL_AMOUNT Signed Number(16,2) DECIMAL(14,2) NOT NULL StudyLink Amount
13 SSF_SL_EMPLID Character(11) VARCHAR2(11) NOT NULL Student's Emplid as per StudyLink's records.
14 SSF_SL_ID Number(9,0) DECIMAL(9) NOT NULL StudyLink's ID for the student
15 SSF_SL_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Student's First name as per StudyLink records.
16 SSF_SL_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Student's Last name per StudyLink's records.
17 SSF_SL_BIRTHDATE Date(10) DATE Birthdate recorded by StudyLink
18 SSF_SL_START_DATE Date(10) DATE Start date for the studylink loan.
19 SSF_SL_END_DATE Date(10) DATE End date of StudyLink Loan.
20 SSF_TOTAL_EFTS Number(7,4) DECIMAL(6,4) NOT NULL Total EFTS for a student for a prospectus.
21 SSF_P1_START_DT Date(10) DATE Period One Start Date
22 SSF_P1_END_DT Date(10) DATE Period One End Date.
23 SSF_P1_EFTS Number(7,4) DECIMAL(6,4) NOT NULL Period One EFTS
24 SSF_P2_START_DT Date(10) DATE Start date of Period two.
25 SSF_P2_END_DT Date(10) DATE End date for Period two.
26 SSF_P2_EFTS Number(7,4) DECIMAL(6,4) NOT NULL Period Two EFTS
27 SSF_P3_START_DT Date(10) DATE Start date of Period three.
28 SSF_P3_END_DT Date(10) DATE End Date of Period three.
29 SSF_P3_EFTS Number(7,4) DECIMAL(6,4) NOT NULL EFTS for period three.
30 SSF_P4_START_DT Date(10) DATE Start date of Period four.
31 SSF_P4_END_DT Date(10) DATE End date of Period four.
32 SSF_P4_EFTS Number(7,4) DECIMAL(6,4) NOT NULL EFTS for Period four.
33 SSF_VAC1_START_DT Date(10) DATE Defines the vacation start date after period one.
34 SSF_VAC1_END_DT Date(10) DATE Defines the vacation end date after period one.
35 SSF_VAC2_START_DT Date(10) DATE Defines the vacation start date after period two.
36 SSF_VAC2_END_DT Date(10) DATE Defines the end date for vacation after period two.
37 SSF_VAC3_START_DT Date(10) DATE Start date for the vacation after period three.
38 SSF_VAC3_END_DT Date(10) DATE Defines the end date for the vacation period after period three.