S360 Data and Technical Requirements

	A	B	C	D	E
1
2	Each field listed below can be used to populate EL program data via SFTP upload (CSV format) or API call.
3
4	All date fields should be provided in mm/dd/yyyy format. Fields that contain multiple values (e.g. sport, academic
5	interests etc.) should be comma separated.
6
7				Program
8	CATEGORY	FIELD NAME	NOTES/EXPLANATION	S360	P360
9				Required: ● Optional: ◌
10	ID’s:
11		AID	Academic ID, unique, numeric ID	●*	◌
12		ID	Alternative ID, unique, non numeric (e.g. Banner, Slate, TargetX)	●*	◌
13		Checksum	Alternative ID, unique non numeric	◌	◌
14
15		* At least one of AID or ID is required however both fields can be used.
16
17	Program and Status:
18		Program	360 field program, e.g. "Yield", "Recruit", "Parent", "Search Social"	●	●
19		Cancel	Remove from any further mailings from 360 if "Yes"	●	●
20		GDPR	Exercise right to be forgotten if "Remove", exercise right	◌	◌
21		GDPR	Exercise right to be forgotten if "Remove", exercise right
22		GDPR	Exercise right to be forgotten if "Remove", exercise right
23
24	Student Information:
25		First	First name	●	◌
26		Last	Last name	●	◌
27		Gender	Male or Female	◌	◌
28		Email	Email address, unique.	●	◌
29		DOB	Date of birth (mmddyy)	●	◌
30		Street_1	Street Address	◌	◌
31		Street_2	Street Address	◌	◌
32		City	City	◌	◌
33		State	State, 2 letter abbreviation.	◌	◌
34		Zip	ZIP, short version e.g. 10001	●	◌
35		Country	Country	●	◌
36		Phone	Primary phone	◌	◌
37		Cell	Cell phone	●	◌
38		Citizenship	Country of citizenship	◌	◌
39		Ethnicity	Open text field for ethnicity	◌	◌
40		HS_Name	High school name (can include address)	◌	◌
41		HS_CEEB	High school CEEB	◌	◌
42		GPA_Highest	Highest GPA	◌	◌
43		ACT_Highest	Highest ACT	◌	◌
44		SAT_Highest	Highest SAT	◌	◌
45		Major	Intended Major (leave blank for undecided).	●	◌
46		Major_2	Second major field or minor.	◌	◌
47		AC_interests	Academic Interest	◌	◌
48		First_gen	First generation college attendee	◌	◌
49		Appl_Status	Application status - e.g. accepted, deposit paid	◌	◌
50
51	College/Other Data:
52		Campus	Campus choice if relevant	◌	◌
53		EC_interests	Extracurricular interests	◌	◌
54		Visited	Visited college yes/no	◌	◌
55		Origin	Origin of user e.g. visit, campus fair, online etc.	◌	◌
56
57	Yield Program Additional Fields:
58		Appl_Status	Application status - e.g. accepted, deposit paid	◌	◌
59		Appl_Date	Date of application	◌	◌
60		Appr_Date	Approval Date	●	●
61
62		Intake	Date of intake e.g. Fall Semester 2016	●	●
63
64	Recruit Program Additional Fields
65		Source	Source of user e.g. Prospect, Inquiry, List, SNR	◌	◌
66		Intake	Intake of student, e.g. Fall 2017	●**	◌
67		Appl_Status	Application status - e.g. accepted, deposit paid	◌	◌
68		** At least one of Intake or Student_year is required however both fields can be used.
69
70	Other Fields (All Programs)
71		Oth_1	Open field for data if required by client	◌	◌
72		Oth_2	Open field for data if required by client	◌	◌
73		Oth_3	Open field for data if required by client	◌	◌
74		Oth_4	Open field for data if required by client	◌	◌
75
76	Parent P360 Fields:
77		Par_First	First name	n/a	●
78		Par_Last	Last name	n/a	●
79		Par_Email	Email address	n/a	●
80		Par_Add_City	City	n/a	●
81		Par_Add_State	State	n/a	●
82		Par_Add_ZIP	ZIP	n/a	●
83		Par_Add_Country	Country	n/a	●
84		Par_Phone_Day	Primary phone	n/a	●
85		Par_Phone_Cell	Cell phone	n/a	●
86		Par_Alum	Alumni yes/no	n/a	◌
87		Par_Occupation	Parent occupation	n/a	◌
88		Par_Visit	Parents visited yes/no	n/a	◌
89		Student_Name	Name of student	n/a	◌
90		StudentID	ID or AID of student	n/a	◌
91		Dep_Date	Deposit date	●	●
92		NB: Parent data for Parent programs must be presented as a separate file. Each parent must be presented on one line.
93
94
95	SA360 Program Additional Fields
96		Sport	Participating sport(s)	n/a	n/a
97		Student_Year	Freshman, Junior etc.	n/a	n/a
98
99
100