Scoir Template Guide

Updated Sep 23, 2026Article

Overview#

Scoir has a portion of it’s product for receiving application related documents for schools. If you are wanting to bring the documents in from Scoir, this guide will help you get started building that process.

Data Connectors#

Scoir’s interface will let you add a SFTP connection. This is where you can add the SFTP Element451 hosts and provided you during the implementation phase. We recommend building a Scoir folder in your SFTP. To generate another set of username and password for that folder, reach out to Customer Success via Live Support.

Import#

There will be two assets, a data import task and a document import task. It is import to build a data import task in the event that a student has submitted documents but is not a record in your Element451 instance.

Data Import Task

Create a new import task and select the folder in the SFTP where Scoir is dropping off the documents. If you are wanting to schedule this process, you can use dynamic names in the path with the date:now token. More information found in our help article (opens in a new tab).

Once setting up the import’s source, on the mapping screen you can apply the Scoir Index File template. This template is to help get you started. Feel free to map additional things like address, phone number, source information.

New database

177 rows

New database
Name	Element451 Slug	Notes	Row
LastName			6
course_comments_response			58
gpa_weighting			74
myr_rank_provided_date			152
myr_counselor_title			140
File			177
fr_graduation_on_time			171
ssr_counselor_title			83
myr_counselor_name_last			139
ssrcourse3_secondsemester_secondtrimester			108
HighSchoolName			23
hs_province			30
ssr_counselor_email			87
ssr_counselor_name_first			80
gpa_reporting			73
ssrcourse6_secondsemester_secondtrimester			111
fr_students_sharing_rank			169
application_round			22
hs_counselor_workextension			41
pct_attend_2year_college			45
RecommenderSubType			136
pct_attend_4year_college			44
pct_free_or_reducedlunch			55
hs_counselor_title			39
myr_weighted_gpa			146
ssrcourse2_fullyear_firstsemester_firsttrimester			99
BirthDate			7
hs_state			29
FirstName			4
coalitionId			2
ssr_counselor_name_middle			81
honors_course_limit			64
ssr_ib_diploma_candidate			96
pct_first_generation			46
myr_course_changes			153
ssr_exact_rank			90
ssr_additional_counselor_comments			128
myr_quintile_rank			149
ssr_extracurricular_rating			124
ssr_contact_counselor			127
pct_non_uscitizen			54
ssr_students_sharing_rank			94
pct_white_caucasian			47
ssr_personal_qualities_rating			125
ssrcourse6_thirdsemester_thirdtrimester			119
rank_decision_date			72
ssr_academic_acheivement_rating			123
pct_other_undisclosed			52
myr_course_comments			154
City			11
ssrcourse8_secondsemester_secondtrimester			113
myr_counselor_workextension			142
senior_graduation_date			67
hs_counselor_name_last			38
myr_students_sharing_rank			151
State			12
MiddleName			5
fr_class_rank			168
ClassYear			8
SentDate			20
ssrcourse1_secondsemester_secondtrimester			106
fr_evaluation_comments			175
ssr_counselor_workextension			85
hs_street			27
myr_counselor_workphone			141
ib_course_offering_number			61
CEEBCode			24
hs_counselor_email			43
community_disruption			78
ssrcourse6_fullyear_firstsemester_firsttrimester			103
recommender_email			132
ssrcourse4_thirdsemester_thirdtrimester			117
ssr_overall_rating			126
Address2			10
fr_weighted_gpa			167
pct_americanIndian_alaskanative			51
myr_exact_rank			147
hs_longitude			34
hs_counselor_name_middle			37
fr_counselor_name_last			160
StudentPersonalEmail			19
fr_counselor_email			165
fr_contact_counselor			176
ssrcourse5_fullyear_firstsemester_firsttrimester			102
ssrcourse8_thirdsemester_thirdtrimester			121
pct_black_africanamerican			48
ssrcourse2_secondsemester_secondtrimester			107
DocumentType			16
ssr_academic_rigor_rating			122
ssrcourse3_thirdsemester_thirdtrimester			116
ssrcourse7_fullyear_firstsemester_firsttrimester			104
ssrcourse5_secondsemester_secondtrimester			110
recommender_name_last			130
hs_counselor_cellphone			42
myr_counselor_cellphone			143
ssrcourse4_secondsemester_secondtrimester			109
Province			13
highest_senior_gpa			77
hs_website			35
ap_course_limit			60
scoir_id			1
pct_hispanic_latino			49
ssrcourse5_thirdsemester_thirdtrimester			118
myr_counselor_name_middle			138
fr_counselor_title			161
recommender_name_first			129
hs_latitude			33
ssrcourse3_fullyear_firstsemester_firsttrimester			100
hs_postalcode			31
class_rank_weighting			71
ssrcourse1_fullyear_firstsemester_firsttrimester			98
hs_international			26
fr_evaluation_changes			174
community_disruption_response			79
ssrcourse7_secondsemester_secondtrimester			112
ssr_quintile_rank			92
honors_course_offering_number			63
ssr_ap_capstone_candidate			95
ap_course_offering_number			59
block_scheduling			66
ssr_weighted_gpa			89
myr_quartile_rank			150
ssrcourse8_fullyear_firstsemester_firsttrimester			105
ssr_counselor_cellphone			86
courses_offered			56
myr_unweighted_gpa			145
ssr_unweighted_gpa			88
CommonAppId			3
myr_evaluation_changes			155
gpa_maximum			76
hs_counselor_workphone			40
fr_rank_provided_date			170
hs_city			28
recommender_title			131
ssr_counselor_workphone			84
fr_unweighted_gpa			166
fr_course_changes			172
ssrcourse7_thirdsemester_thirdtrimester			120
ap_capstone_offered			65
gpa_minimum			75
fr_counselor_name_first			158
RecommenderPhoneExt			134
fr_counselor_cellphone			164
RecommenderPhone			133
myr_decile_rank			148
fr_counselor_workphone			162
hs_country			32
ssrcourse1_thirdsemester_thirdtrimester			114
hs_type			25
pct_asian			50
Address			9
fr_counselor_workextension			163
course_comments			57
myr_counselor_email			144
hs_counselor_name_first			36
ssrcourse4_fullyear_firstsemester_firsttrimester			101
FileType			17
class_ranking_method			70
ssr_aiced_diploma_candidate			97
ssr_decile_rank			91
myr_counselor_name_first			137
StudentEmail			18
country			15
ZipCode			14
ssrcourse2_thirdsemester_thirdtrimester			115
myr_contact_counselor			157
ferpa_waiver			21
fr_counselor_name_middle			159
pct_uscitizen			53
ssr_quartile_rank			93
senior_class_size			68
fr_course_comments			173
RecommenderType			135
ib_course_limit			62
myr_evaluation_comments			156
ssr_counselor_name_last			82
class_rank_reporting			69

Document Import Task

Following the processes in the help article (opens in a new tab), after creating the data task, a document task will be the next step. When setting up the document task, it will be important to toggle the “Use Index File” to on. The index file settings and document types are found below.

New database

177 rows

New database
Name	Mode	Notes	Row
scoir_id	Person Matching	Matching on Scoir ID	1
coalitionId	Skip		2
CommonAppId	Skip		3
FirstName	Skip		4
MiddleName	Skip		5
LastName	Skip		6
BirthDate	Skip		7
ClassYear	Skip		8
Address	Skip		9
Address2	Skip		10
City	Skip		11
State	Skip		12
Province	Skip		13
ZipCode	Skip		14
country	Skip		15
DocumentType	Document Type		16
FileType	Skip		17
StudentEmail	Skip		18
StudentPersonalEmail	Person Matching	Matching on Email	19
SentDate	Skip		20
ferpa_waiver	Skip		21
application_round	Skip		22
HighSchoolName	Skip		23
CEEBCode	Skip		24
hs_type	Skip		25
hs_international	Skip		26
hs_street	Skip		27
hs_city	Skip		28
hs_state	Skip		29
hs_province	Skip		30
hs_postalcode	Skip		31
hs_country	Skip		32
hs_latitude	Skip		33
hs_longitude	Skip		34
hs_website	Skip		35
hs_counselor_name_first	Skip		36
hs_counselor_name_middle	Skip		37
hs_counselor_name_last	Skip		38
hs_counselor_title	Skip		39
hs_counselor_workphone	Skip		40
hs_counselor_workextension	Skip		41
hs_counselor_cellphone	Skip		42
hs_counselor_email	Skip		43
pct_attend_4year_college	Skip		44
pct_attend_2year_college	Skip		45
pct_first_generation	Skip		46
pct_white_caucasian	Skip		47
pct_black_africanamerican	Skip		48
pct_hispanic_latino	Skip		49
pct_asian	Skip		50
pct_americanIndian_alaskanative	Skip		51
pct_other_undisclosed	Skip		52
pct_uscitizen	Skip		53
pct_non_uscitizen	Skip		54
pct_free_or_reducedlunch	Skip		55
courses_offered	Skip		56
course_comments	Skip		57
course_comments_response	Skip		58
ap_course_offering_number	Skip		59
ap_course_limit	Skip		60
ib_course_offering_number	Skip		61
ib_course_limit	Skip		62
honors_course_offering_number	Skip		63
honors_course_limit	Skip		64
ap_capstone_offered	Skip		65
block_scheduling	Skip		66
senior_graduation_date	Skip		67
senior_class_size	Skip		68
class_rank_reporting	Skip		69
class_ranking_method	Skip		70
class_rank_weighting	Skip		71
rank_decision_date	Skip		72
gpa_reporting	Skip		73
gpa_weighting	Skip		74
gpa_minimum	Skip		75
gpa_maximum	Skip		76
highest_senior_gpa	Skip		77
community_disruption	Skip		78
community_disruption_response	Skip		79
ssr_counselor_name_first	Skip		80
ssr_counselor_name_middle	Skip		81
ssr_counselor_name_last	Skip		82
ssr_counselor_title	Skip		83
ssr_counselor_workphone	Skip		84
ssr_counselor_workextension	Skip		85
ssr_counselor_cellphone	Skip		86
ssr_counselor_email	Skip		87
ssr_unweighted_gpa	Skip		88
ssr_weighted_gpa	Skip		89
ssr_exact_rank	Skip		90
ssr_decile_rank	Skip		91
ssr_quintile_rank	Skip		92
ssr_quartile_rank	Skip		93
ssr_students_sharing_rank	Skip		94
ssr_ap_capstone_candidate	Skip		95
ssr_ib_diploma_candidate	Skip		96
ssr_aiced_diploma_candidate	Skip		97
ssrcourse1_fullyear_firstsemester_firsttrimester	Skip		98
ssrcourse2_fullyear_firstsemester_firsttrimester	Skip		99
ssrcourse3_fullyear_firstsemester_firsttrimester	Skip		100
ssrcourse4_fullyear_firstsemester_firsttrimester	Skip		101
ssrcourse5_fullyear_firstsemester_firsttrimester	Skip		102
ssrcourse6_fullyear_firstsemester_firsttrimester	Skip		103
ssrcourse7_fullyear_firstsemester_firsttrimester	Skip		104
ssrcourse8_fullyear_firstsemester_firsttrimester	Skip		105
ssrcourse1_secondsemester_secondtrimester	Skip		106
ssrcourse2_secondsemester_secondtrimester	Skip		107
ssrcourse3_secondsemester_secondtrimester	Skip		108
ssrcourse4_secondsemester_secondtrimester	Skip		109
ssrcourse5_secondsemester_secondtrimester	Skip		110
ssrcourse6_secondsemester_secondtrimester	Skip		111
ssrcourse7_secondsemester_secondtrimester	Skip		112
ssrcourse8_secondsemester_secondtrimester	Skip		113
ssrcourse1_thirdsemester_thirdtrimester	Skip		114
ssrcourse2_thirdsemester_thirdtrimester	Skip		115
ssrcourse3_thirdsemester_thirdtrimester	Skip		116
ssrcourse4_thirdsemester_thirdtrimester	Skip		117
ssrcourse5_thirdsemester_thirdtrimester	Skip		118
ssrcourse6_thirdsemester_thirdtrimester	Skip		119
ssrcourse7_thirdsemester_thirdtrimester	Skip		120
ssrcourse8_thirdsemester_thirdtrimester	Skip		121
ssr_academic_rigor_rating	Skip		122
ssr_academic_acheivement_rating	Skip		123
ssr_extracurricular_rating	Skip		124
ssr_personal_qualities_rating	Skip		125
ssr_overall_rating	Skip		126
ssr_contact_counselor	Skip		127
ssr_additional_counselor_comments	Skip		128
recommender_name_first	Skip		129
recommender_name_last	Skip		130
recommender_title	Skip		131
recommender_email	Skip		132
RecommenderPhone	Skip		133
RecommenderPhoneExt	Skip		134
RecommenderType	Skip		135
RecommenderSubType	Skip		136
myr_counselor_name_first	Skip		137
myr_counselor_name_middle	Skip		138
myr_counselor_name_last	Skip		139
myr_counselor_title	Skip		140
myr_counselor_workphone	Skip		141
myr_counselor_workextension	Skip		142
myr_counselor_cellphone	Skip		143
myr_counselor_email	Skip		144
myr_unweighted_gpa	Skip		145
myr_weighted_gpa	Skip		146
myr_exact_rank	Skip		147
myr_decile_rank	Skip		148
myr_quintile_rank	Skip		149
myr_quartile_rank	Skip		150
myr_students_sharing_rank	Skip		151
myr_rank_provided_date	Skip		152
myr_course_changes	Skip		153
myr_course_comments	Skip		154
myr_evaluation_changes	Skip		155
myr_evaluation_comments	Skip		156
myr_contact_counselor	Skip		157
fr_counselor_name_first	Skip		158
fr_counselor_name_middle	Skip		159
fr_counselor_name_last	Skip		160
fr_counselor_title	Skip		161
fr_counselor_workphone	Skip		162
fr_counselor_workextension	Skip		163
fr_counselor_cellphone	Skip		164
fr_counselor_email	Skip		165
fr_unweighted_gpa	Skip		166
fr_weighted_gpa	Skip		167
fr_class_rank	Skip		168
fr_students_sharing_rank	Skip		169
fr_rank_provided_date	Skip		170
fr_graduation_on_time	Skip		171
fr_course_changes	Skip		172
fr_course_comments	Skip		173
fr_evaluation_changes	Skip		174
fr_evaluation_comments	Skip		175
fr_contact_counselor	Skip		176
File	Filename		177

Scoir Document Type

21 rows

Scoir Document Type
Name
TranscriptInitial
OtherDocument
TranscriptAdditional
ACTScoreReport
EarlyDecisionContract
SATScoreReport
TranscriptFinal
FeeWaiver
TranscriptTransfer
TranscriptMid
CounselorRecommendation
SchoolProfile
FinalReport
TeacherRecommendation
OtherRecommendation
SecondarySchoolReport
SeniorCourses
GradeReport
ApplicationProfile
MidyearReport
FERPAWaiver