PCR independent school management solution and website
Customer Portal
School Portal
Request Demo
SOLUTION
FAQ
PRICING
EMPLOYMENT
BLOG
SUPPORT
KNOWLEDGE BASE
Admissions
CMS Website
Community Connect
Finance & Student Billing
Fundraising / Development
Student Information
Cafeteria POS
Summer Camp & School
301-947-7380
sales@pcreducator.com
School Information Management System & Website Software
FAQ
School CRM
Importing New Records - Historical Marks
Importing New Records - Historical Marks
Follow the steps for
Importing New Records
.
Field
Required
Type
Sample Values
Notes
Student_Id
Yes, if student first/last/birthdate is unspecified
Identifier
“12345”
Student_First_Name
No
Lookup
"John
Student_Last_Name
No
Lookup
"Doe"
Birthdate
No
Lookup
"1/1/2000"
School_Year
Yes
Data
"2000/2001"
Course
s in the same school year are grouped together on transcripts. Format must be xxxx/yyyy
Grade_Level
No
Lookup
"11"
Matches with the integer value in
Grade Level
s.
Note
: This grade level is the grade level of the student when they took the course.
Grade_Level_Id
Yes, if grade_level is unspecified
Identifier
Course
_Name
Yes
Data
"Algebra I"
Does not need to match course names offered by your school.
External_
Course
Yes
Datasource
"0
1 indicates the course was taken at another school. 0 indicates the course is taken at the school.
School_Name
No
Data
Name of the school an external course is taken
Number_of_Semesters
Yes
Datasource
"2"
Possible values include 1, 2, 3, or 4
Credits_Per_Semester
No
Data
"0.5"
Value may be 0 or blank.
Include_In_GPA
Yes
Datasource
"1"
1 indicates grades are included in gpa. 0 indicates grades are not included in gpa.
Hist_Transcript_
Course
_Name
No
Data
An alternative course name which may be shown depending on the transcript setup
Class_Rank_Type
No
Lookup
"AP Only"
Source is based on
Course
“
Class Rank
” types
Attribute
1
No
Data
Attribute
2
No
Data
Attribute
3
No
Data
Course
_Type3
No
Data
Department_Id
Yes
Identifier
"5"
The department id helps determine which school division the record is for
First_Mark
No
Data
"A"
Second_Mark
No
Data
"95"
Third_Mark
No
Data
"P"
Final_Mark
No
Data
"A"
Teacher_Last_Name
No
Data
"Smith"
Does not need to match a teacher name with your school
Teacher_First_Name
No
Data
"Jane"
Does not need to match a teacher name with your school
First_Effort
No
Data
Second_Effort
No
Data
Third_Effort
No
Data
Fourth_Effort
No
Data
First_Quarter
No
Data
Second_Quarter
No
Data
Third_Quarter
No
Data
Fourth_Quarter
No
Data
First_Exam
No
Data
Second_Exam
No
Data
Third_Exam
No
Data
First_Final_Exam
No
Data
Second_Final_Exam
No
Data
Third_Final_Exam
No
Data
Course
_Id
No
Lookup
Leave this field blank unless directed otherwise
Section
No
Lookup
Leave this field blank unless directed otherwise
BC_Trax_Examinable_
Course
No
Datasource
"1"
1 indicates that the course is an examinable course, 0 indicates the opposite
BC_Trax_Electronic_Exam
No
Datasource
"1"
1 indicates that the student takes the electronic exam, 0 indicates the opposite
BC_Trax_
Course
_Code
No
Data
"EN"
BC_Trax_
Course
_Level
No
Data
"10"
BC_Trax_
Course
_Type
No
Data
"E"
E means equivalency and C means challenge
BC_Trax_Month
No
Data
"6"
Must be a value 1-12 or blank
BC_Trax_Proc_Spec_Case
No
Data
"D"
R means Rewrite, D means Deferral
BC_Trax_Related_Code
No
Data
“YSSC”
BC_Trax_Related_Level
No
Data
"11B"
BC_Trax_to_Write
No
Data
"1"
1 indicates the student opted to write the optional exam, 0 indicates the opposite
BC_Trax_School_Percent
No
Data
"95"
BC_Trax_Exam_Percent
No
Data
"95"
BC_Trax_Grad_Req
No
Data
"F"
F meets Fine Arts, A meets Applied Skills, B meets both requirements
Course
_Start_Date
No
Data
"9/1/2000"
Course
_End_Date
No
Data
“12/1/2000”
Course
_Type_Level_Id
No
Identifier
"6"
Course
Type Levels are typically used for Graduation Requirements or Prerequisites
Lookup_
Course
_Type_Level_Id
No
Lookup
"6"
Used to look up the couse_type_level_id
Lookup_
Course
_Type
No
Lookup
"Math"
Used to look up the couse_type_level_id
Lookup_
Course
_Level
No
Lookup
"105"
Used to look up the couse_type_level_id
Note
: Typically, only First_Mark, Second_Mark, Third_Mark, and/or Final_Mark are showing on transcripts. Other marks are retained only for data mining purposes.
Note
: Only one record per student may have the same School_Year, Grade_Level_Id,
Course
_Name, External_
Course
, School_Name
Note
:
Attribute
s 1-3 and
Course
_Type3 are used to store custom data
Note
: For BC fields, see the
TRAX Specification
for British Columbia reporting requirements.
Note
:
Course
_Id and Section are included for completeness. These fields are only intended for use by PCR Educator software when
Closing the School Year
.
See also
Closing the School Year
Importing New Records
TRAX Specification
School Division
Grade Level
Class Rank
Attribute
Course
DAT
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.
Facebook
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - CFO
Finance - Business Manager
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User