SSF_SL_VOSEXTVW

#	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_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Student's Emplid as per StudyLink's records.
6	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.
7	SSF_SL_ID	Number(9,0)	DECIMAL(9) NOT NULL	StudyLink's ID for the student
8	SSF_SL_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Student's First name as per StudyLink records.
9	SSF_SL_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Student's Last name per StudyLink's records.
10	SSF_SL_BIRTHDATE	Date(10)	DATE	Birthdate recorded by StudyLink
11	SSF_STUDY_START	Date(10)	DATE	Start date of the earliest class for the study period.
12	SSF_FEE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if fee details are required. F=Fee VOS V=Study VOS
13	SSF_SL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Student's status on the VOS cycle.
14	SSF_TOTAL_FEES	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Total Fees
15	SSF_SL_AMOUNT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	StudyLink Amount
16	SSF_SL_START_DATE	Date(10)	DATE	Start date for the studylink loan.
17	SSF_SL_END_DATE	Date(10)	DATE	End date of StudyLink Loan.
18	SSF_TOTAL_EFTS	Number(7,4)	DECIMAL(6,4) NOT NULL	Total EFTS for a student for a prospectus.
19	SSF_P1_START_DT	Date(10)	DATE	Period One Start Date
20	SSF_P1_END_DT	Date(10)	DATE	Period One End Date.
21	SSF_P1_EFTS	Number(7,4)	DECIMAL(6,4) NOT NULL	Period One EFTS
22	SSF_P2_START_DT	Date(10)	DATE	Start date of Period two.
23	SSF_P2_END_DT	Date(10)	DATE	End date for Period two.
24	SSF_P2_EFTS	Number(7,4)	DECIMAL(6,4) NOT NULL	Period Two EFTS
25	SSF_P3_START_DT	Date(10)	DATE	Start date of Period three.
26	SSF_P3_END_DT	Date(10)	DATE	End Date of Period three.
27	SSF_P3_EFTS	Number(7,4)	DECIMAL(6,4) NOT NULL	EFTS for period three.
28	SSF_P4_START_DT	Date(10)	DATE	Start date of Period four.
29	SSF_P4_END_DT	Date(10)	DATE	End date of Period four.
30	SSF_P4_EFTS	Number(7,4)	DECIMAL(6,4) NOT NULL	EFTS for Period four.
31	SSF_VAC1_START_DT	Date(10)	DATE	Defines the vacation start date after period one.
32	SSF_VAC1_END_DT	Date(10)	DATE	Defines the vacation end date after period one.
33	SSF_VAC2_START_DT	Date(10)	DATE	Defines the vacation start date after period two.
34	SSF_VAC2_END_DT	Date(10)	DATE	Defines the end date for vacation after period two.
35	SSF_VAC3_START_DT	Date(10)	DATE	Start date for the vacation after period three.
36	SSF_VAC3_END_DT	Date(10)	DATE	Defines the end date for the vacation period after period three.
37	SSF_SL_CUR_FEE_REQ	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Current Fees Requested
38	SSF_SL_PRE_FEE_REQ	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Previous Fees Requested
39	SSF_SL_SELECTED	Character(1)	VARCHAR2(1) NOT NULL	Selected flag N=Deselected Y=Selected Y/N Table Edit