EXAMPLE SchoolMint Re-Enrollments Template (accounts created)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBV
1
account_pending_pwd_reset
account_preferred_language_id
student_sis_local_id
student_sis_id
student_first_name
student_middle_name
student_last_name
student_birth_date
student_gender
student_address_street1
student_address_street2
student_address_city_name
student_address_state
student_address_zipcode
student_current_school_id
student_current_school_name
student_current_grade_level
re_enrollment_gradere_enrollment_school_id
re_enrollment_school_name
student_lives_with
mailing_address_street1
mailing_address_street2
mailing_address_city_name
mailing_address_state
mailing_address_zipcode
primary_guardian_id
guardian_1_first_name
guardian_1_last_name
guardian_1_email
guardian_1_phone_number
guardian_1_relation
guardian_1_address_street1
guardian_1_address_street2
guardian_1_address_city_name
guardian_1_address_state
guardian_1_address_zipcode
guardian_1_home_phone_number
guardian_1_work_phone_number
guardian_2_first_name
guardian_2_last_name
guardian_2_email
guardian_2_phone_number
guardian_2_relation
guardian_2_address_street1
guardian_2_address_street2
guardian_2_address_city_name
guardian_2_address_state
guardian_2_address_zipcode
guardian_2_home_phone_number
guardian_2_work_phone_number
emergency_contact_1_first_name
emergency_contact_1_last_name
emergency_contact_1_mobile_phone_number
emergency_contact_1_home_phone_number
emergency_contact_1_work_phone_number
emergency_contact_1_email
emergency_contact_1_relationship
emergency_contact_2_first_name
emergency_contact_2_last_name
emergency_contact_2_mobile_phone_number
emergency_contact_2_home_phone_number
emergency_contact_2_work_phone_number
emergency_contact_2_email
emergency_contact_2_relationship
emergency_contact_3_first_name
emergency_contact_3_last_name
emergency_contact_3_mobile_phone_number
emergency_contact_3_home_phone_number
emergency_contact_3_work_phone_number
emergency_contact_3_email
emergency_contact_3_relationship
student_doctor_name
student_doctor_number
2
true or false. The default is false. If true the parents will be forced to reset their password.OPTIONAL: It should a number and it is the identifier of the language, for exmple: 1 (for English), 2 (for Spanish)[PowerSchool - Attribute Path] student/id

[PS - Database Column] Students.student_number]
this field is mandatory for powerschool

[PS - Database Column] Students.DCID]
REQUIREDREQUIREDREQUIRED (MM/DD/YY)REQUIREDREQUIREDOPTIONAL (Apartment Number, Suite, etc)REQUIRED: City must be spelled correctly for all studentsREQUIRED: Should be the two character state code (CA, AZ, MA etc.)REQUIRED: 5 digit zipOPTIONAL
SchoolMint School Id
OPTIONALREQUIRED (pk, k, 1, 2,...)REQUIRED

grade_level

tk, pk, k, 1, 2,...
REQUIRED - Fill this one searching for the school id in our DBREQUIREDOPTIONAL:
-Values must be: MO, FA, SFA, SMO, SB, AU, UN, BR, CO, GP, CT, FP or OT
-Multiple values, it can be for example: MO or more than one i.e: MO,FA
REQUIREDREQUIREDREQUIREDREQUIREDREQUIREDREQUIREDREQUIREDREQUIRED: if an email is not available, a mobile phone MUST be provided in the next column. The import will create an account for this student that is = primary guardian email or mobile phone. Please make sure students from different families are not listed under the same email.REQUIRED: if a mobile phone number is not available, an email MUST be provided in the previous column. The import will create an account for this student that is = primary guardian email or mobile phone. Please make sure students from different families are not listed under the same email.REQUIRED: Values are "Mother", "Father", "Guardian", "Other", "Aunt", "Uncle", "Sibling", "Cousin". Default is "other"REQUIRED (Default would take the student address); if you specify this column, City, State, and Zip must be provided as wellOPTIONAL (Apt number, suite,etc.)REQUIRED: City must be spelled correctly for all guardiansREQUIRED: Should be the two character state code (CA, AZ, MA etc.)REQUIRED: 5 digit zipOPTIONAL: numbers onlyOPTIONAL: numbers only
3
Recommendation: set this to `TRUE`, because that will ask families to create their own password immediately upon logging in with the default password that has been originally set, which greatly increases security.Please note: This is the student's grade level they will be entering for the next school year. Ex. If the current school year is 2017-2018, this column will be the grade of the student for 2018-2019.
Reminder: This grade will almost always be one grade above the grade listed in column Q for the current grade level.
Please refer to this video linked here to find the school id.
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...