Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Canadian Schools
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Canadian Schools
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
Sign In
Demo
School CRM
Blog
Importing New Records - Courses
Importing New Records - Courses
Importing New Records - Courses
Follow the steps for
Importing New Records
Field
Required
Type
Sample Value
Notes
Course
_Id
No
Key Id Field
"123"
Short_
Course
_Name
No
Text
"MATH101"
Course
_Name
Yes
Text
"Algebra I"
Report_Card_Type
No
Datasource Data
"3"
Must be integer from 0 to 6. See Notes for additional information
Number_of_Semesters
No
Integer
"2"
1, 2, or 3
Credits_Per_Semester
No
Decimal
"0.5"
Include_in_GPA
Yes
Boolean
"1"
(1 = Yes, 0 = No)
GPA_Weight
No
Decimal
"1.5"
Department_Id
No
Identifier
"456"
Must match an existing Department Id in the database
Include_on_Transcript
Yes
Boolean
"1"
(1 = Yes, 0 = No)
School_Id
Yes
Identifier
"789"
Must match an existing School Id. See
School Division
for more info.
Scheduling_Priority
No
Integer
"3"
In the master schedule builder, you can prioritize which courses to schedule first.
Default_Section_Capacity
No
Integer
"30"
Transcript_
Course
_Name
No
Text
"Algebra I"
This is applicable if you want to show a different course name on the transcript.
grade_scale_max_points
No
Integer
"10"
class_rank_type
No
Datasource Data
"AP Only"
Must match an existing class rank in the system
allow_parent_teacher_conf
Yes
Datasource Data
"No"
Must be either "Yes" or "No"
allow_self_comments_yes_no
Yes
Datasource Data
"Yes"
Must be either "Yes" or "No"
publish_in_online_directory
No
Boolean
"0"
0 or 1
is_advisory_course
No
Boolean
"0"
0 or 1
is_homeroom_course
No
Boolean
"1"
0 or 1
department_name
No
Lookup
"Mathematics"
Must match an existing Department Name in the system
product_id
No
Identifier
"123"
Must match an existing
Product
Id in the system
product_name
No
Lookup
"Advanced Math Package"
Must match an existing
Product
Name in the system
permissible_gender
No
Datasource Data
"Any"
Used to limit online registration courses based on gender
min_birthdate
No
Date
"2010/09/01"
Used to limit online registration courses based on birthdate
max_birthdate
No
Date
"2015/06/30"
Used to limit online registration courses based on birthdate
min_grade_level_id
No
Identifier
"456"
Must match an existing
Grade Level
Id in the system. Used to limit online registration courses based on grade level.
min_grade_level_code
No
Lookup
"06"
Must match an existing
Grade Level
Code in the system. Used to limit online registration courses based on grade level.
max_grade_level_id
No
Identifier
"789"
Must match an existing
Grade Level
Id in the system.
max_grade_level_code
No
Lookup
"08"
Must match an existing
Grade Level
Code in the system.
bc_trax_grad_req
No
Boolean
"0"
bc_trax_examinable_course
No
Boolean
"1"
bc_trax_electronic_exam
No
Boolean
"0"
bc_trax_course_code
No
Text
"MATH10"
bc_trax_course_level
No
Text
"10"
bc_trax_course_type
No
Text
"Academic"
bc_trax_month
No
Text
"June"
bc_trax_proc_spec_case
No
Text
"None"
bc_trax_related_code
No
Text
"MATH20"
bc_trax_related_level
No
Text
"20"
bc_trax_to_write
No
Boolean
"1"
bc_1701_course_type
No
Text
"Core"
course_type_level_id
No
Identifier
"123"
Must match an existing
Course
Type Level Id in the system
lookup_course_type_level_id
No
Lookup
"456"
Must match an existing
Course
Type Level in the system
lookup_course_type
No
Lookup
"Mathematics"
Must match an existing
Course
Type in the system
lookup_course_level
No
Lookup
"100"
Must match an existing
Course
Level in the system
grade_book_template_id
No
Identifier
"789"
Must match an existing Grade Book Template Id in the system
lookup_grade_book_template_name
No
Lookup
"Standard Grading"
Must match an existing Grade Book Template Name in the system
Notes
: Legend for Report_Card_Type
0 = no report card type
1 = Trimester
2 = Semester with History
3 = Semester no History
4 = Elementary
5 = No Comments
6 = Comments Page
See also
Importing New Records
School Division
Grade Level
Class Rank
Product
Course
Gender
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
Please Enter a Maximum of 100 Characters.
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
Please Enter a Maximum of 30 Characters.
*
Your First Name
Please Enter a Maximum of 20 Characters.
*
Your Email
Invalid Email
Please Enter a Maximum of 100 Characters.
*
Your Phone #
Please Enter a Maximum of 20 Characters.
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.