District Setup

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Defining District Attendance Preferences

Global Attendance Preferences

Attendance

Attendance

Set attendance preferences for all schools on this server.

[Prefs]

Not Required

Entering Calendar Membership Types

District Management->Scheduling->Calendar Membership Types > [Edit/New] > Calendar Membership Type

Code

Enter the calendar membership type code.

[Gen]Value

[Gen]Cat=dailymembtypes

Not Required

Meaning

Enter the calendar membership type meaning.

[Gen]Name

[Gen]Cat=dailymembtypes

Not Required

Setting Up District Courses

District Management-> Courses & Programs->Courses > Edit Course District Information

Courses > View Master Course List > New

Course Name (Subject Description)

Enter the course name.

[Courses]Course_Name

MB TTP Activities

MB Student Course Registrations

MB BEF K-8 Classroom

MB Student Marks

Course Number

Enter the course number.

[Courses]Course_Number

MB Student Course Registrations

MB Student Marks

MB BEF K-8 Classroom

MB BEF K-8 Classroom

Alternate Course Number

Enter the alternate course number.

Note: If the 'Exclude Course from EIS Reporting' checkbox is not selected, this field cannot be blank; you must enter a value before you can submit the page.

[Courses]Alt_Course_Number

MB Student Course Registrations

MB Student Marks

MB TTP Activities

MB BEF K-8 Classroom

CIP Code

Note: This field is used to hold the MB Subject Level

Enter the subject level. Must correspond to the valid subject levels for the subject as shown in the Subject Table Handbook for the academic year being reported.

Note: If the 'Exclude Course from EIS Reporting' checkbox is not selected, this field cannot be blank; you must enter a value before you can submit the page.

[Courses]Code

MB Student Course Registrations

MB Student Marks

MB TTP Activities

MB BEF K-8 Classroom

Delivery Mode

Choose the delivery mode for the course. This value can be overridden for each section.

See Delivery Mode for valid values.

[S_MB_CRS_Courses_X]DeliveryMode

2

MB Student Course Registrations

MB Student Marks

Exam Mark Included

Check if the course has an exam mark.

This value can be overridden for each section.

[S_MB_CRS_Courses_X]ExamMarkIncl

1

MB Student Marks

Secondary Report Card (* Provincial Test)

Bulletin Scolaire (9-12) (* Test provincial)

Language of Instruction

Select the appropriate value. This value can be overridden for each section.

Database Values:

Blank = English

For French Visual Arts courses, ensure the language of instruction is set to French for the 7-8 courses taught in French. This will ensure the bilingual report cards print the grades in French.

See Language Of Instruction Codes.

[S_MB_CRS_Courses_X]LanguageOfInst

2

MB Student Course Registrations

MB Student Marks

MB TTP Activities

MB BEF K-8 Classroom

Bilingual 7-8 Elementary Report Cards.

MB Program Track

Choose the Program Track for this course.

Database Values:

• Blank = English

• FR = Francais

• IM = Immersion

[S_MB_CRS_Courses_X]ProgramTrack

2

MB TTP Activities

MB School Track

Choose the School Track for this course.

See School Track for valid values.

[S_MB_CRS_Courses_X]SchoolTrack

2

MB BEF K-8 Classroom

MB Report Card Subject Code

Choose the Subject Code for this course. This determines which subject on the Elementary Report Card this course will occupy.

See Subject Codes for valid values.

[S_MB_CRS_Courses_X]ReportCardCrsType

MB Student Marks

Elementary Report Cards

EIS Language Program

Choose the EIS language program code.

Used to populate the Student Program fields

[S_MB_CRS_Courses_X]EISLanguageProgram

3

Populate Student Program Fields

Exclude Course from Student Marks Reporting

Check to exclude this course from Student Marks Reporting to the Ministry.

[S_MB_CRS_Courses_X]ExcludeFromStuMarks

MB Student Marks

MB Student Course Registrations

Secondary Report Cards

Exclude Course From EIS Reporting

Select the checkbox to indicate this course is to be excluded from EIS reporting.

[S_MB_CRS_Courses_X]ExcludeFromEIS

Database Values:

NULL = No

1 = Yes

MB Student Marks

MB Student Course Registrations

MB BEF K-8 Classroom

MB TTP Activities

Entering District Info

District Management ->District Setup->District Information

Name of District

Enter the district name.

[Prefs]Value

[Prefs]Name=districtname

MB Monthly School Attendance

District Number

Enter the district number.

[Prefs]Value

[Prefs]Name=districtnumber

MB Monthly School Attendance

Path for District Logo for Report Cards

Enter a local path on the server, using URI formatting.

For example if the local path is C:\ProgramFiles\PowerSchool\data\picture\general\district_logo.jpg, then the valid URI format is:

file:///C:/ProgramFiles/PowerSchool/data/picture/general/district_logo.jpg

Refer to Report Card Logos.

[prefs]MB_DistrictLogoPath

120

Elementary and Secondary Report Cards

Path for Provincial Logo for Report Cards

Enter a local path on the server, using URI formatting.

For example if the local path is C:\ProgramFiles\PowerSchool\data\picture\general\prov_logo.jpg, then the valid URI format is:

file:///C:/ProgramFiles/PowerSchool/data/picture/general/prov_logo.jpg

Refer to Report Card Logos.

[prefs]MB_ProvincialLogoPath

120

Elementary and Secondary Report Cards

Defining Districts of Residence

District Management ->District Setup->Districts of Residence > [New/Edit] District of Residence

District ID

Enter the district ID.

[Gen]Value

[Gen]Cat=districts

Required Setup

District Name

Enter the district name.

[Gen]Name

[Gen]Cat=districts

Required Setup

Superintendent Name

Enter the name of the District Superintendent.

[Prefs]Superintendent

MB Monthly School Attendance

Superintendent Phone

Enter the phone number of the District Superintendent.

[Prefs]SuperintendentPhone

MB Monthly School Attendance

Superintendent Email

Enter the email address of the District Superintendent.

[Prefs]SuperintendentEmail

MB Monthly School Attendance

Defining Entry Codes, Ethnicity Codes, and Exit Codes

Code Sets > EntryCode

Code set

Select the Code set type.

[CODESET]CODETYPE=EntryCode

Code

Enter the entry code.

See the Appendix for valid values.

[CODESET]Code

2

MB Student Enrolment

MB Monthly School Attendance

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the entry code description.

See the Appendix for valid values.

[CODESET]Description

N/A

MB Monthly School Attendance

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate

8

Ethnicity Codes > [New/Edit] Ethnicity Code

Code

Enter the ethnicity code.

[Gen]Value

[Gen]Cat=ethnicity

Not Required

Description

Enter the ethnicity description.

[Gen]Name

[Gen]Cat=ethnicity

Not Required

Code Sets > ExitCode

Code set

Select the Code set type.

[CODESET]CODETYPE=ExitCode

Code

Enter the exit code.

See the Appendix for valid values.

[CODESET]Code

2

MB Student Enrolment

MB Monthly School Attendance

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the exit code meaning.

See the Appendix for valid values.

[CODESET]Description

N/A

MB Monthly School Attendance

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate8

8

Creating Special Programs

Special Programs > Special Program Information

Program Name

Enter the special program name.

[Gen]Name

[Gen]Cat=specprog

Not Required

Qualifies as a special education program

Select the checkbox to indicate a special education program.

[Gen]spedindicator

[Gen]Cat=specprog

Not Required

Defining District Schools

Schools/School Info > Edit School

District Management-> District Setup → School Info

Note: school information can also be setup at the school level by the local school administrator.

School Name

Enter the school name.

[Schools]School_Name

MB Monthly School Attendance

Elementary and Secondary Report Cards

School Abbreviation

Enter the school abbreviation.

[Schools]Abbreviation

Not Required

School Address

Enter the school address.

[Schools]SchoolAddress

Elementary and Secondary Report Cards

School City

Enter the school city.

[Schools]SchoolCity

Elementary and Secondary Report Cards

School State/Province

Enter the school state/province.

[Schools]SchoolState

Elementary and Secondary Report Cards

School Postal/Zip Code

Enter the school postal/zip code.

[Schools]SchoolZIP

Elementary and Secondary Report Cards

School Phone Number

Enter the school phone number.

[Schools]SchoolPhone

Elementary and Secondary Report Cards

School Number

Enter the school number.

[Schools]School_Number

MB Student Enrolment

MB TTP Activities

MB BEF K-8 Classroom

MB Teacher Contract

MB Monthly School Attendance

Alternate School Number

Enter the alternate school number.

[Schools]Alternate_School_Number

MB Student Enrolment

MB TTP Activities

MB BEF K-8 Classroom

MB Teacher Contract

MB Monthly School Attendance

Exclude From State Reporting?

Select the checkbox to exclude the school from state reporting.

[Schools]State_ExcludeFromReporting

MB Student Demographics

MB Student Enrolment

MB Student Course Registrations

MB Student Marks

MB Monthly School Attendance

Principal’s Name

Enter the principal’s name.

[Schools]Principal

MB Monthly School Attendance

Elementary and Secondary Report Cards

Principal’s Phone Number

Enter the principal’s phone number.

[Schools]PrincipalPhone

MB Monthly School Attendance

Principal’s Email

Enter the principal’s email address.

[Schools]PrincipalEmail

MB Monthly School Attendance

Grades

Enter the school grades (lowest – highest).

Note: Grade levels must be in the range -10 to 20.

[Schools]Low_Grade

[Schools]High_Grade

Required Setup

Setup Semester Codes

Click the link to setup semester codes for each school.

N/A

MB Student Marks

MB Student Course Registrations

MB TTP Activities

MB BEF K-8 Classroom

Elementary Report Card Term 1 Attendance End Date

Enter the cutoff date for Term 1 for the Elementary Report Card. For purposes of reporting Lates and Absences on the Elementary Report Card, Term 1 will start from the first day of school year term to this date.

This date can be overridden on the Elementary Report Card run screen.

[S_MB_SCH_X]T1_End_Date

Elementary Report Cards

Elementary Report Card Term 2 Attendance End Date

Enter the cutoff date for Term 2 for the Elementary Report Card. For purposes of reporting Lates and Absences on the Elementary Report Card, Term 2 will be from the Term 1 cutoff date to this date.

Term 3 will be from this date to the last day of the school year term.

This date can be overridden on the Elementary Report Card run screen.

[S_MB_SCH_X]T2_End_Date

Elementary Report Cards

Elementary Report Cards – First Local Option Learning Behavior Name

Up to 2 local option learning behaviours can be used in the Elementary Report Card.

Enter the name of the first Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB1_Name

80

Elementary Report Cards

Elementary Report Cards – First Local Option Learning Behavior Description

Enter the description of the first Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB1_Description

250

Elementary Report Cards

Elementary Report Cards – Second Local Option Learning Behavior Name

Up to 2 local option learning behaviours can be used in the Elementary Report Card.

Enter the name of the second Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB2_Name

80

Elementary Report Cards

Elementary Report Cards – Second Local Option Learning Behavior Description

Enter the description of the second Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB2_Description

250

Elementary Report Cards

Multi-Subject Grading Box Title

If a second multi-subject grading box (that is not Art Education) is used for report cards, enter the title of the grading box.

If this is left blank, the title will default to “Additional Courses”.

[S_MB_SCH_X]MultiSubject_Title

35

Elementary Report Cards

Principal’s Report Card Comments for Grades 1-6

Enter principal’s comments that will be printed on all students’ report cards for Grades 1 thru 6.

[S_MB_SCH_X]PrincipalComments_16

Elementary Report Cards (1-6)

Principal’s Report Card Comments for Grades 7-8

Enter principal’s comments that will be printed on all students’ report cards for Grades 7 thru 8.

[S_MB_SCH_X]PrincipalComments_78

Elementary Report Cards (7-8)

Principal’s Report Card Comments for Grades 9-12

Enter principal’s comments that will be printed on all students’ report cards for Grades 9 thru 12.

[S_MB_SCH_X]PrincipalComments_912

Secondary Report Cards

Art Subjects Marked at Category Level

Select up to four arts courses per grade level.

Notes:

• If all art courses can be reported in a single multi-subject Art Education grading box in the report card, then make no selections.

• More than two courses should only be specified when students will be scheduled into one or two Arts subjects and the schools wants the Arts subject selected for the student to be reported at the Category level. 

• Do not select the same arts course twice for a given grade level.

Database Values:

• ARVA = Visual Arts

• ARDA = Dance

• ARDR = Drama

• ARMU = Music

• ARBA = Band

• ARCH = Choral

• ARGU = Guitar

• AROR = Strings/Orchestra

Grade 1:

• [S_MB_SCH_X]ArtByCat_A_1

• [S_MB_SCH_X]ArtByCat_B_1

• [S_MB_SCH_X]ArtByCat_C_1

• [S_MB_SCH_X]ArtByCat_D_1

Grade 2:

• [S_MB_SCH_X]ArtByCat_A_2

• [S_MB_SCH_X]ArtByCat_B_2

• [S_MB_SCH_X]ArtByCat_C_2

• [S_MB_SCH_X]ArtByCat_D_2

Grade 3:

• [S_MB_SCH_X]ArtByCat_A_3

• [S_MB_SCH_X]ArtByCat_B_3

• [S_MB_SCH_X]ArtByCat_C_3

• [S_MB_SCH_X]ArtByCat_D_3

Grade 4:

• [S_MB_SCH_X]ArtByCat_A_4

• [S_MB_SCH_X]ArtByCat_B_4

• [S_MB_SCH_X]ArtByCat_C_4

• [S_MB_SCH_X]ArtByCat_D_4

Grade 5:

• [S_MB_SCH_X]ArtByCat_A_5

• [S_MB_SCH_X]ArtByCat_B_5

• [S_MB_SCH_X]ArtByCat_C_5

• [S_MB_SCH_X]ArtByCat_D_5

Grade 6:

• [S_MB_SCH_X]ArtByCat_A_6

• [S_MB_SCH_X]ArtByCat_B_6

• [S_MB_SCH_X]ArtByCat_C_6

• [S_MB_SCH_X]ArtByCat_D_6

Grade 7:

• [S_MB_SCH_X]ArtByCat_A_7

• [S_MB_SCH_X]ArtByCat_B_7

• [S_MB_SCH_X]ArtByCat_C_7

• [S_MB_SCH_X]ArtByCat_D_7

Grade 8:

• [S_MB_SCH_X]ArtByCat_A_8

• [S_MB_SCH_X]ArtByCat_B_8

• [S_MB_SCH_X]ArtByCat_C_8

• [S_MB_SCH_X]ArtByCat_D_8

4

Elementary Report Cards

Secondary Report Cards – First Local Option Learning Behavior Name

Up to 2 local option learning behaviours can be used in the Secondary Report Card.

Enter the name of the first Local Option. This appears on the first page of the Secondary Report Cards.

[S_MB_SCH_X]SRC_LB1_Name

80

Secondary Report Cards

Secondary Report Cards – First Local Option Learning Behavior Description

Enter the description of the first Local Option. This appears on the first page of the Secondary Report Cards.

[S_MB_SCH_X]SRC_LB1_Description

250

Secondary Report Cards

Secondary Report Cards – Second Local Option Learning Behavior Name

Up to 2 local option learning behaviours can be used in the Secondary Report Card.

Enter the name of the second Local Option. This appears on the first page of the Secondary Report Cards.

[S_MB_SCH_X]SRC_LB2_Name

80

Secondary Report Cards

Secondary Report Cards – Second Local Option Learning Behavior Description

Enter the description of the second Local Option. This appears on the first page of the Secondary Report Cards.

[S_MB_SCH_X]SRC_LB2_Description

250

Secondary Report Cards

Path for School Logo for Report Cards

Enter a local path on the server, using URI formatting.

For example if the local path is C:\ProgramFiles\PowerSchool\data\picture\general\school_logo.jpg, then the valid URI format is:

file:///C:/ProgramFiles/PowerSchool/data/picture/general/school_logo.jpg

Refer to Report Card Logos.

This setting overrides the logo selected in the Select School Logo for Report Cards field.

[S_MB_SCH_X]SchoolLogoPath

120

Elementary and Secondary Report Cards

Path for Principal Signature for Report Cards

Enter a local path on the server, using URI formatting.

For example if the local path is C:\ProgramFiles\PowerSchool\data\picture\general\principal_signature.jpg, then the valid URI format is:

file:///C:/ProgramFiles/PowerSchool/data/picture/general/principal_signature.jpg

Refer to Report Card Logos.

This setting overrides the principal signature selected in the Select Principal Signature for Report Cards field.

[S_MB_SCH_X]PrincipalSignaturePath

250

Elementary and Secondary Report Cards

Select School Logo for Report Cards

Select the school logo’s file name from the drop-down list. For uploading, refer to Report Card Image Settings.

To print the selected logo on the report card, the 'Path for School Logo for Report Cards' field must not be defined.

[S_MB_SCH_X]School_Logo_Asset_ID

Elementary Report Card

MB Bulletin scolaire
MB Elementary Bilingual Report Cards

Select Principal Signature for Report Cards

Select the principal signature from the file name from the drop-down list. For uploading, refer to Report Card Image Settings.

For the selected signature to appear on the report card, the 'Path for Principal Signature for Report Cards' field must not be defined.

[S_MB_SCH_X]Principal_Sign_Asset_ID

Elementary Report Card

MB Bulletin scolaire
MB Elementary Bilingual Report Cards

French Local Option - Used Only by Bilingual Report Cards

First Local Option Learning Behaviour Name (French)

Up to 2 local option learning behaviours can be used in the Elementary Report Card.

Enter the French name of the first Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB1_fname

80

Elementary Report Card

MB Bulletin scolaire
MB Elementary Bilingual Report Cards

First Local Option Learning Behaviour Description (French)

Enter the French description of the first Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB1_fdescription

250

Elementary Report Cards

Second Local Option Learning Behaviour Name (French)

Up to 2 local option learning behaviours can be used in the Elementary Report Card.

Enter the French name of the second Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB2_fname

80

Elementary Report Cards

Second Local Option Learning Behaviour Description (French)

Enter the French description of the second Local Option. This appears in the Learning Behaviors section of the Elementary Report Cards.

[S_MB_SCH_X]ERC_LB2_fdescription

250

Elementary Report Cards

Defining Years & Terms

Years & Terms

Years & Terms

Define term names and abbreviations with term beginning and ending dates.

[Terms]

MB Monthly School Attendance

Adding Semester Codes

Semester Codes

A semester code entry must be created for each Year and Term defined for each school. Click the New button to create a semester code entry.

Term

Select the term from the list for which you wish to assign a semester code to.

[Gen]cat=semestercode

[Gen]SchoolID=School_Number

[Gen]YearID=[Terms]ID

MB Student Marks

MB Student Course Registrations

MB TTP Activities

MB BEF K-8 Classroom

MB Semester Code

Select the MB Semester code to assign to the selected term.

Database Values:

• 0 = Full Year

• 1 = Semester 1

• 2 = Semester 2

• 5 = Summer School

• 6 = Quarter 1

• 7 = Quarter 2

• 8 = Quarter 3

• 9 = Quarter 4

[Gen]Value

1

MB Student Marks

MB Student Course Registrations

MB TTP Activities

MB BEF K-8 Classroom

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Name

Value

Description

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Added Value

RETSD Weighted

Simple

Simple Percent

Weighted

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Method name

Enter the name of the GPA Calculation Method.

[Gen]Name

Description

Enter a description of the GPA Calculation Method.

[Gen]ValueT2

GPA Calculation

Formula

Enter a standard GPA Calculation Formula, or edit the formula based.

[Gen]ValueT

Calculation type

Choose the appropriate calculation type from the pop-up menu.

[Gen]Value

Grade scale

Choose a grade scale from the pop-up menu, if appropriate. This option may be left blank.

[Gen]ValueLi

Query Options

Terms

[Gen]queryterms

Grade levels

School years

Credit types

Only include grades