PowerSchool SIS British Columbia
PowerSchool SIS British Columbia
Breadcrumbs

Permanent Student Record-1704

Introduction

This report provides information about a student’s educational history within a school. It contains details such as demographics, enrollment history, program participation, attendance records, and course grades of the student. When a student transfers to another school, this report must be generated and sent to the school where the student is joining.

The 1704 form is part of the Permanent Student Record (PSR), which is maintained at the school level. The PSR (including Form 1704 and inclusions) must be:

  • Retained by the school for 55 years after a student graduates or withdraws.

  • Transferred to another school upon request when a student moves.

  • Stored securely, either electronically (in a Ministry-certified format) or in paper form.

Note: This report runs for the currently selected school and cannot be run at the district level.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

  • Students with the “Exclude From Provincial Reporting” flag set to True are excluded.

  • The report input parameter Exit Codes to Exclude allows the user to select specific exit codes to exclude students. As a result, the students corresponding to the selected exit codes will be excluded. For example, if "Death" is selected as an exit code, students with an exit code of "Death" will be excluded, and all other students will be included. Students can be excluded using Exit codes only when the All Transferred out Students input parameter is selected.

  • Only students for whom the Enrollment exit date falls within the selected term are included.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Parameter

Description

Current Selection of Students*

Indicate which students to include in the report by selecting one of the following options:

  • The Selected (count) Students Only (Default)

  • All Students

Sort By

Sort by one of the following:

  • Student Grade

  • Student Name

Report Copy Type

Select one of the following options from the drop-down list:

  • **Copy Only---Master resident at school

  • **Obsolete Copy---Record Transferred**

  • **Master Copy---Do Not Destroy**

Exit Codes to Exclude

Select the exit codes to be excluded from the drop-down list. Users can select multiple exit codes.

Note: Use this option only when running the report for All Students. Otherwise, this will be ignored.

Output File name

PSR-1704.pdf

Scheduling

Select one of the following options:

  • Run Now

  • Schedule

Report Output

The report output is categorized based on the following sections:

  • Medical and Legal Alert

  • Student Information

  • Record of Schooling

  • Student Record Inclusions

  • Achievement/Attendance Record for Grades K - 9

  • Achievement/Attendance Record for Grades 10 - 12

  • Graduation Requirement Completed In

  • School Completion Certificate Completed In

These are two checkboxes available on the top right of the report.

Data Element

Description/Business Logic

Table [Field name]

UI Navigation

Medical Alert

  1. If a student has text in the Medical Alert Text box or if there is an inclusion record with the inclusion type Medical under the new page 1704 - Student Record Inclusions, then the Medical Alert checkbox is checked, else unchecked.

  2. The Medical Alert checkbox is checked only if the Alert exit date is blank or greater than the student's exit date.

[Students]Alert_Medical OR S_BC_STU_1704_REC_INCL_C (Type='2')

Report Output will be 'Y' if alert exists and not expired before the exit date.


 

UI Navigation:

  • Student, Health, Emergency and Medical Contacts, Medical Alert Text

  • Student, Compliance, 1704 - Student Record Inclusions, Inclusion Type Medical 

Legal Alert

  1. If a student has text in the Guardian Alert Text box with word Legal/legal/LEGAL in it or if there is an inclusion record with the inclusion type LEGAL under the new page 1704 - Student Record Inclusions, then the Legal Alert checkbox is checked.

  2. The Legal Alert checkbox is checked only if the Alert exit date is blank or greater than the student's exit date.

[Students]Alert_Guardian (contains 'legal') OR S_BC_STU_1704_REC_INCL_C (Type='1')

UI Navigation:

  1. Student, Student Profile, Guardian Info OR

  2. Student, Compliance, 1704 - Student Record Inclusions, Inclusion Type LEGAL 

Student Information

This section provides basic information about students, such as legal name, usual name, family name, gender, birthdate, and so on.

Data Element

Description/Business Logic

Table [Field name]

UI Navigation

Legal family name

The student’s legal last name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

Student, Student Profile-Demographics

Legal first name

The student’s legal first name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

Student, Student Profile-Demographics

Legal middle names

The student’s legal middle name.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Middle_Name

[Students]Middle_Name

Student, Student Profile-Demographics

Usual family name (if different)

The student’s preferred last name.

If the usual name is different from the legal name, only then the usual name is printed in report, otherwise it is blank.

[S_BC_STU_Students_X]Preferred_LastName

Only if different from legal name

Student, Student Profile-Demographics

Usual first name (if different)

The student’s preferred first name.

If the usual name is different from the legal name, only then the usual name is printed in report, otherwise it is blank.

[S_BC_STU_Students_X]Preferred_FirstName

Only if different from legal name

Student, Student Profile-Demographics

Usual middle name(s) (if different)

The student’s preferred middle name.

If the usual name is different from the legal name, only then the usual name is printed in report, otherwise it is blank.

[S_BC_STU_Students_X]Preferred_MiddleName

Only if different from legal name

Student, Student Profile-Demographics

PEN

The Nine-digit Personal Education Number assigned to the student by the Ministry of
Education.

[Students]State_StudentNumber

Student, Compliance, Demographics, PEN

Gender

Gender (M of F).

Note: If populated, the student's legal gender overrides the student's preferred gender.

If its Male, then the M checkbox is checked, else F is checked.

[StudentCoreFields]PSCore_legal_Gender

[Students]Gender

M or F only

Student, Student Profile, Demographics, Gender & Legal Gender

Birthdate

The student’s date of birth in YYYYMMDD format.

[Students]DOB

Student, Student Profile, Demographics, DOB

Birth country

The country where the student was born.

The value selected under Birth_Country is displayed.

[S_BC_STU_Students_X]Birth_Country

Description is printed
from PS_COMMON_CODE where:
pscc.code = stu_x.birthcountry
and pscc.ps_group = 'BC'
and lower(category) = 'countrycode'

Student, Student Profile, Demographics, BIRTH COUNTRY

Initial Entry form

Students may enter a British Columbia school from their home or a school outside the province. Enter in the ‘initial entry form’ box.

The selected Entry Code description is updated in the report and not code. For example, if the selected Entry code is Promoted(P), then only “Promoted” is displayed the report output.

Reference is made to the oldest and first enrollment entry of the student, and the Entry Code from that very first enrollment entry is displayed.

[CodeSet]DisplayValue

[CodeSet]Description

These codes are stored in the codeSets table; the display value is printed if populated, otherwise the description.

Student, School Enrollment, Entry code

Verified

Upon a student’s initial entry to a British Columbia school, it is the responsibility of an administrative office or designate to verify the student’s names, birthdate, and placement data and ensure the box is checked.

If [S_BC_ STU_Students_X]Verification_Method is present, then this checkbox is checked. If it is blank (no value is selected), then the checkbox is unchecked.

[S_BC_ STU_Students_X]Verification_Method

'Y' if not null, else 'N'

Student, Compliance, Demographics, Verification Method

Record of Schooling

The data under this section is based on the initial entry of the student into the school system. It displays the list of schools where the student has enrolled in the past.

  • Consolidation: Multiple enrollments at same school are merged into single record with earliest entry and latest exit.

  • Transfer Handling: If a student transfers from school A to B and then back to A, separate records are created for each distinct enrollment period.

  • Data Sources: Combines data from the Students and Reenrollment tables.

  • Sort: The most recent enrollment is displayed first.

Data Element

Description/Business Logic

Table [Field name]

UI Navigation

Ministry School Code

The 8-character ministry assigned school code identifying the school for which the following student detail records are associated.

First 3 characters of [Prefs]Value (for [Prefs]Name = districtnumber) followed by first 5 characters of [Schools]Alternate_School_Number for the currently selected school.

If alternate school number is not defined, [Schools]School_Number is used.

If the district office is currently selected, a school number value of 00000 is used.


District Name

District name of each school record is displayed.

[Prefs]DistrictName

District Info, Name of District

Name of School

All the schools that student has attended and the corresponding entry and exit dates are retrieved from the Enrollment/Reenrollments tables. The recent school details are listed first.

[Schools]Name

District Management, District Setup, School Info, New/edit

GPL-Graduation Program Level

Blank

NA


Entry Date

Earliest Admission date for the school in the YYYY MM DD format.

[DM_SchoolEnrollment]EntryDate

Student & reenrollments table are referred

MIN(entrydate) per school enrollment group

Student, School Enrollment, Enrollment, Entry grade

Can also be checked from:

Student Profile, Modify Info, School Entry date

Exit Date

Latest Exit date for that school in the YYYY MM DD format.

[DM_SchoolEnrollment]ExitDate

Student & reenrollments table are referred

MAX(exitdate) per school enrollment group

Student, School enrollment, Enrollment, Exit DATE

GPL-Graduation Program Level

For each school record, the Graduation Requirement Year (GRY) selected under program information page is retrieved and mapped.

The Graduation Program Level in report output is displayed as:

  • '2018-Graduation Program' - If GRY selected is 2018 or 2023

  • 'ADULT- Adult Graduation Program' -If GRY selected is 1950

  • 'EVERGREEN-School Completion Certificate Program' -If GRY selected is SCCP

  • 'DUAL-Dual Dogwood Diploma'

  • ‘2004 Graduation Program’ IF GRY Selected is 2004

  • ‘1996- Graduation Program’ - If GRY Selected is 1996

Note: If the student was in a school for three years, then the GPL shows the last year in this school GPL Value.

[S_BC_STU_STUDENTS_X]GRAD_REQT_YEAR

Maps

  • 2018/2023→'2018',

  • 1950→'ADULT',

  • SCCP→'EVRGRN',

  • 2004→'2004',

  • 1996→'1996'


Reason for Exit

The code representing how or why the student exited the school.

In case of consecutive year enrolments in the same school, the last year exit reason reason is displayed.

Code sets are used, and the display value is printed if populated, otherwise the description.

[CodeSet]DisplayValue

[CodeSet]Description

From exitcode on last exit date


Student Record Inclusions

The student record inclusions are listed only for the latest enrollment record and year in which the student is transferred out.

For every Inclusion, the following fields are displayed in the report output (if applicable):

  • Date- The date must be in (YYYY MM DD) format.

  • Description AND/OR Documentation

    • MEDICAL ALERT

      • If a student has text in the Medical Alert Text box a record will be created.

      • If an inclusion record with the type Medical exists on page ‘1704 - Student Record Inclusions’, a record will be created.

    • LEGAL ALERT

      • If a student has text in the Guardian Alert Text box with word Legal/legal/LEGAL in it, then a record will be created.

      • If an inclusion record with the type Legal exists on page ‘1704 - Student Record Inclusions’, a record will be created.

    • Others

      • If an inclusion record with the type Others exists on page ‘1704 - Student Record Inclusions’, a record will be created.

    • IEP

      • If the student is enrolled in an IEP Program, a record will be created with Description as ‘IEP Program’

    • Homeschool

      • If the student is enrolled in a Homeschool Program, a record will be created with Description as ‘Homeschool Program’

    • Screening

      • If the student has health screening records, a record will be created for each screening.

  • Expiry Date-The date must be in (YYYY MM DD) format.

Data Element

Description

Table[Field Name]

UI Navigation

Date

The date must be in (YYYY MM DD) format.

Medical Alert:

  1. This is the 'MEDICAL Alert Start date' on the Student->Health->Emergency and Medical Contacts page, OR

  2. This is the Start date for Inclusion type “Medical” created on ‘1704 - Student Record Inclusions’ page.

Legal Alert:

  1. This is the ‘ALERT START (DATE)’ on the Student->Student Profile->Guardian Info page, OR

  2. This is the Start date for Inclusion type “LEGAL” created on ‘1704 - Student Record Inclusions’ page.

Others:

This is the Start date for Inclusion type ‘Others’ created on ‘1704 - Student Record Inclusions’ page.

IEP and Homeschool Program:

This is the Entry Date on Student->Courses & Programs->Student Program page for IEP or Homeschool Program.

Screening:

This is the Screening Date on Student->Health->Screenings page.

Medical Alert:

  1. Students.Alert_Medical + S_BC_STU_STUDENTS_X.med_alert_start, OR

  2. [S_BC_STU_1704_REC_INCL_C]Start_Date, where Inclusion_Type='2'

Legal Alert:

  1. Students.alert_guardian (contains 'legal') + S_BC_STU_STUDENTS_X.GDN_alert_start , OR

  2. [S_BC_STU_1704_REC_INCL_C]Start_Date , where Inclusion_Type='1'

Others:

  1. [S_BC_STU_1704_REC_INCL_C]Start_Date , where Inclusion_Type='3'

IEP and Homeschool Program:

SPEnrollments + S_BC_GEN_STUPROG_X.IEP_FLAG='1' [SpEnrollments]Enter_Date OR SPEnrollments + S_BC_GEN_STUPROG_X.HS_FLAG='1'[SpEnrollments]Enter_Date

Screening:

This is the Screening Date on Student->Health->Screenings page.





Description AND/OR Documentation


MEDICAL ALERT

[Students]Alert_Medical + [S_BC_STU_STUDENTS_X]Med_Alert_Start

OR

[S_BC_STU_1704_REC_INCL_C]Inclusion_Type='2')

  1. Student, Health, Emergency and Medical Contact, Medical Alert Text OR

  2. Student, Compliance, 1704 - Student Record Inclusions, Inclusion Type Medical

LEGAL ALERT

Students]Alert_Guardian (contains 'legal') + [S_BC_STU_STUDENTS_X]GDN_Alert_Start

OR

[S_BC_STU_1704_REC_INCL_C]Inclusion_Type='1')

  1. Student, Student Profile, Guardian Info OR

  2. Student, Compliance, 1704 - Student Record Inclusions, Inclusion Type LEGAL

Other Inclusions

[S_BC_STU_1704_REC_INCL_C]Inclusion_Type='3')

Student, Compliance, 1704 - Student Record Inclusions, Inclusion Type OTHERS

IEP Program

SPEnrollments + [S_BC_GEN_STUPROG_X]IEP_FLAG='1'

Student, Courses & Programs, Student Program

Homeschool Program

SPEnrollments + [S_BC_GEN_STUPROG_X]HS_FLAG='1'

Student, Courses & Programs, Student Program

Screening Type:

  • "Hearing Screening"

  • "Lead Screening"

  • "Oral Health Screening"

  • "Scoliosis Screening"

  • "System Review Screening"

  • "Tuberculosis Screening"

  • "Vision and Color Screening"

  • "Vital Signs/Biometrics Screening"

healthstudhearing "Hearing Screening"

healthstudlead"Lead Screening"

healthstudoral"Oral Health Screening"

healthstudscolio"Scoliosis Screening"

healthstudsystem"System Review Screening"

healthstudtb"Tuberculosis Screening"

healthstudvision"Vision and Color Screening"

healthvitalsigns"Vital Signs/Biometrics Screening"

Student, Health, Screenings

Expiry Date

The date must be in (YYYY MM DD) format.

Medical Alert:

  1. This is the 'Alert Expires(date)' on the Student->Health->Emergency and Medical Contacts page, OR

  2. This is the Expiry date for Inclusion type “Medical” created on ‘1704 - Student Record Inclusions’ page.

Legal Alert:

  1. This is the ‘Alert Expires(date)’ on the Student->Student Profile->Guardian Info page, OR

  2. This is the Expiry date for Inclusion type “LEGAL” created on ‘1704 - Student Record Inclusions’ page.

Others:

This is the Expiry date for Inclusion type ‘Others’ created on ‘1704 - Student Record Inclusions’ page.

IEP and Homeschool Program:

This is the Exit Date on Student->Courses & Programs->Student Program page for IEP or Homeschool Program.

Screening:

This is the Screening Date on Student->Health->Screenings page.

Medical Alert:

  1. Student, Health, Emergency and Medical Contacts, Alert Expires(date) OR

  2. [S_BC_STU_1704_REC_INCL_C]Expiry_date for Inclusion type “Medical”

Legal Alert:

  1. Student, Student Profile, Guardian Info-Alert Expires(date) OR

  2. [S_BC_STU_1704_REC_INCL_C]Expiry_date for Inclusion type “LEGAL”

Others:

[S_BC_STU_1704_REC_INCL_C]Expiry_date for Inclusion type “Others”

IEP and Homeschool Program:

SPEnrollments + S_BC_GEN_STUPROG_X.IEP_FLAG='1' [SpEnrollments]Exit_Date OR SPEnrollments + S_BC_GEN_STUPROG_X.HS_FLAG='1'[SpEnrollments]Exit_Date


Screening:

Student, Health, Screenings, Screening Date


Achievement/Attendance Record

This section applies only to Grade Levels K-9 listed on page 1.

For every enrollment/reenrollment record, a new row with school year is created for the year the student’s grade is in K-9.

This section displays student achievement & attendance history.

Each row contains the school year,grade,progress description and days absent data.

The Progress Description contains the following information:

  • Lists all courses in which the student was enrolled during the year. Multiple courses are separated with commas.

  • For each course, displays the final grade from the stored grades page, if available.

  • Format: Course Name - Final Grade (e.g., Mathematics - EXT).

  • If the final grade is unavailable (Current Courses), display only the course name and leave the grade blank.

  • The final mark comes from the store codes listed under the field Final School Grade Store Code(s), (Navigation: District Management, School Info, Final School Grade Store Code(s)).

Absence Days

  • Days Absent -The total number of days the student was absent during that school year. The Attendance/ps_adaadm_defaults_all table is referred for yearly attendance details.

  • Includes all previous years’ attendance data for the student, with the most recent enrollment listed first.

Data Element

Description

Table [Field name]

School Year

For Each Enrollment/Reenrollment Record:

Year of enrollment - Just the completion year (2024-2025) show as 2025

Terms.yearid + 1991

Grade

For Each Enrollment/Reenrollment and for each School year:

The grade level or overridden grade level of the student.

[S_BC_STU_Students_X]Grade_Override if populated , otherwise -

[Students]Grade_Level or

[Reenrollments]Grade_Level

Progress Description

  • Lists all courses in which the student was enrolled during the year. Multiple courses are separated with commas.

  • Format → Course - Final Grades, For example, Mathematics- EXT

  • To retrieve all the course grades, the Student Information System determines enrollment and grades by using a prioritized matching process. The first step is to link official course enrollments to stored grades by using the class section ID. If no section match exists, it associates grades by using the course number and school year. Grades that are manually entered and not linked to Course Catalog enrollment are also included as independent academic records.

[Courses]Course_name + [StoredGrades]Ggrade

Grade Matching Priority:

  1. CC enrollment matched to StoredGrades by sectionid

  2. StoredGrades sectionid=0 matched by course_number + school year

  3. Pure manual StoredGrades entries with no CC match

Final Grades Filter: Uses S_BC_SCH_SCHOOLS_X.FINALSCHGRADESTORECD to identify which storedgrades records to include.

Days Absent

The total number of days the student was absent for the year (All types of absences). If the student was absent for 3 days and on the 4th day, the attendance is half day, then the total absences will be 3.5.

Note- Daily Attendance is used for K-9 Students.

  • ps_adaadm_defaults_all (membershipvalue - attendancevalue)

  • Sum of daily absences where Potential_Attendancevalue is greater than 0

Achievement/Attendance Record

This section applies only to Grade Levels 10-12 listed on page 2.

  • There are two sections named Achievement/Attendance Record, and both sections (PART 1/PART 2) are applicable only for grade 10-12.

  • Achievement/Attendance Record-Part 1

    • This table is to capture subject wise attendance along with year and grade.

    • All registered courses are considered, and attendance is consolidated for courses sharing the same Ministry defined subject areas field on the courses page.

    • The subject name and attendance association is mapped to courses with Ministry defined subject areas. Refer to Subject and Ministry Defined Subject Areas Mapping. For example - Subject Name LANGUAGE ARTS attendance is the combined attendances for all the courses the student is enrolled in with Ministry defined subject areas as “10 - English Language Arts”. Navigation: Courses page, BC Info, Ministry defined subject areas

    • This section records course attendance with the year and grade as shown below.

Data Element


Description

Table[Field Name]

Navigation

HEADER OF PAGE 2




PEN

The Nine-digit Personal Education Number assigned to the student by the Ministry of Education.

[Students]State_StudentNumber

Student, Compliance, Demographics, PEN

Family Names

The student’s legal last name.

[StudentCoreFields]PSCore_Legal_Last_Name

Student, Student Profile-Demographics

Given Names

The student’s legal first name.

[StudentCoreFields]PSCore_Legal_First_Name

Student, Student Profile-Demographics

BIRTHDATE

The student’s date of birth in YYYYMMDD format.

[Students]DOB

Student, Student Profile, Demographics, DOB

Achievement/Attendance Record - Part 1




Subject

Subjects are mapped according to the Ministry's defined subject areas on the courses page. Refer to the Ministry-defined subject areas and courses mapping here -Subject and Ministry Defined Subject Areas Mapping

Courses page, BC info, Ministry defined subject areas

[S_BC_CRS_COURSES_X]Subject_Area

Year

For each enrollment/reenrollment, a new vertical column for each year is created.


Terms.yearid + 1991

Year identifier

Grade

The student’s grade in that year.

From Student Enrollment page

[Students / Reenrollments]Grade_Level

OR override

Override takes precedence

Subject Attendance

Absences are summed up by Ministry's defined subject areas. It is reported by the subject area for the period the student was enrolled.

Note- Meeting Attendance is used for Grade 10-12 Students

Absences are reported as the total number of absences for the student in a subject area. For example:

  • Semester 1: Student took course MAT 7 with 2 absences

  • Semester 2: Student took course MAT 8 with 3 absences

In this case, the Subject Area “Mathematics” on page 2 will show 5 absences in total.

Attendance table

SUM of absences per subject area

Days Absent

  • Total Absences includes all excused/unexcused absences for the entire year.

  • Blank means the student was not enrolled in a course with this subject area.

  • 0 indicates zero absences.



  • Achievement/Attendance Record-Part2

    • The second part is to capture course wise grade, percentage and Credit along with Total Days of absence. For each enrollment/reenrollment entry, a vertical column in report is updated with course grades.

    • Grade information is taken based only on the Final Grade. If the student transfers out before writing the final examination, then the grade is BLANK.

Data Element

Description

Other Info

Table[Field Name]

Course

This is the course number.

For each enrollment record:

  • From the Course Registration Page, all courses in which the student is enrolled are listed and for each course, the LG, % and CR is reported. The LG, %, and CR refer to the final term.

  • If the student transfers out before writing the final examination, then for all enrolled courses blank is reported.

Each course will be displayed separately with its respective details such as CR, %, etc. For example:

  • MAT 7 will be shown as a separate entry

  • MAT 8 will also be shown separately

Course numbers will be displayed individually in this section.

  • [S_BC_CRS_Courses_X]Ministry_Course_Code + [S_BC_CRS_Courses_X]Course_Level or [S_BC_SGR_TRAX_X] TRAXCourseNumber + [S_BC_CRS_Courses_X]Course_Level is printed

    • Format code(level) ex: CH(11)

  • or if both fields are blank, then the full [Courses]Course_Number or full [StoredGrades]Course_Number is printed (course level is not needed here).

LG

  • This is the final Letter Grade for the course.

  • Only the Final Grade is considered. If the student transfers out before writing the final examination, then BLANK is reported.

  • To retrieve all the course grades, the Student Information System determines enrollment and grades by using a prioritized matching process. The first step is to link official course enrollments to stored grades by using the class section ID. If no section match exists, it associates grades by using the course number and school year. Grades that are manually entered and not linked to Course Catalog enrollment are also included as independent academic records.

The Final grade is taken from the store codes defined under the field Final School Grade Store Code(s) field, (Navigation: District Management, School Info, Final School Grade Store Code(s)).

[StoredGrades]Grade

Final grade

Grade Sources (Priority Order):

  1. CC enrollment + StoredGrades matched by sectionid

  2. StoredGrades sectionid=0 matched by course_number + school year

  3. Pure manual StoredGrades with no CC match

%

  • This is the final percentage for the course

  • Only the Final Term % is considered. If the student transfers out before writing the final examination, then BLANK is reported.

The Final term % is taken from the store codes mentioned under the field Final School Grade Store Code(s) field, (Navigation: District Management, School Info, Final School Grade Store Code(s)).

[StoredGrades]Percent

Percentage

CR

  • This is the final Credits for the course

  • Only the Final Term CR is considered. If the student transfers out before writing the final examination, then BLANK is reported.

  • The Final term CR is taken from the store codes mentioned under the field Final School Grade Store Code(s) field, (Navigation: District Management, School Info, Final School Grade Store Code(s)).

[StoredGrades]CRHRS

Credits earned

Days Absent

For each year, this field displays the total absences for the entire year data.

Attendance Calculation Logic:

  • attendance_type_code = 0: Count 1 absence per day (regardless of periods)

  • attendance_type_code = 2: Count 1 absence per period

  • Requires: calculate_ada_yn=1 AND presence_status_cd='absent'

  • Joins: section_meeting, calendar_day, bell_schedule, period, cycle_day, attendance, attendance_code

Attendance table

Per course absence count


Data Element

Description

Table[Field Name]

Graduation Requirement

The date is reported from the Graduation Requirement MET date from the latest enrollment record in the school and the checkbox is checked only if the date is on or before the system date

This field is available on Compliance-Program Info page.

[S_STU_X]GRAD_REQ_MET_DATE

Format: YYYY MM DD

Only if less than or equal to current date

School Completion Certificate

The date is reported from the SCCP date from the latest enrollment record in the school and the checkbox is checked only if

  • SCCP Date is not blank & the date is on or before the system date

This field is available on Compliance-Program Info page.

[S_BC_STU_STUDENTS_X]SCCP_Comp_Date

Format: YYYY MM DD

Only if less than or equal to current date