BCPSEA Data Elements | PowerSchool Atrieve

Data Elements - Quick Reference Guide

Element 06 – Employee No

From HR Demographics

Element 01 – School District

PRM Master Profile, Field 14 = District Number.

Element 02 - Work Location

HR Assignment location – if multiple locations, the location listed will be the one with the highest FTE/hours.

Element 03 – General Classification

SU, EU, EN, EX

– HR Assignment - Employee’s position code is located from the HR Assignment(s), this is then cross referenced with the Position Code Mapping.

Element 04 – Position

HR Assignment – Employee’s position code is located from the HR Assignment(s), this is then cross referenced with the Position code mapping. The number if finds there is placed here.

Element 05 – Employment Status

P = Permanent/Continuing, T = Temporary, C = Casual/TTOC
HR Assignment – Assignment Type code, which is cross referenced to the Assignment type code mapping in the BCPSEA databases

HR Demographics

Element 08 – Date of Birth

HR Demographics

Element 09 – Gender

HR Demographics

Element 10 – Date of Hire

HR Hire Records – Current Hire Date is reported

Element 11 – Union

If employee has an assignment, the position code is cross referenced with the BCPSEA Position Code mapping profile, pulling the union from there
If the employee is a casual or ttoc, the union will pull from the User Defined field in HR Demographics, third page. **Each District will have a different field number on this screen.

Element 12 – School Level

1 = Elementary, 2 = Secondary, 3 = All grade levels
Comes from the BCPSEA Database Location Code mapping

Element 13 – Years of Experience

Not currently tracked or reported

Element 14 – Working Status

A = Currently working, L – Leave paid or unpaid, R – layoff/recall list, D – LTD, T – terminated
BCPSEA Assignment Type Code Mapping

Element 15 – Unpaid Sick Days

Depends on the General Profile setting
- IF General Profile has the Category listed here (EU, EN or EX only) Then it will use the BCPSEA Absence Code mapping and report from HR Absences
- If the General Profile does NOT have the Category listed, then it will use the Payroll Earnings Code Mapping to pull the hours from the pay code(s) listed in Payroll

Element 16 – Unpaid Sick Hours

Depends on the General Profile setting
- If there is a category listed in the General Profile (SU only) Then it will use the BCPSEA Absence code mapping and report from HR Absence code hours
- If there are NO Categories listed here, then it will use the BCPSEA Payroll Earnings Code Mapping and pull the hours from the pay code(s) listed

Element 17 – Reason for Departure

D=Deceased, E=Expired Contract, L=Layoff, R=Resignation, S=Retirement, X=On Exchange
Element to be left blank if the employee is still active
If Employment status is T, it pulls the Termination Code from the HR Hire Records
Cross Referenced to the BCPSEA Termination Codes Mapping

Element 18 – Date of Departure

If Employment status is T, it pulls the termination date from the HR Hire Records

Element 19 – YTD Earnings

Payroll Earnings Code Mapping – Element 19
Reported for EN, EX, EU – with the exception of ttocs - 000000 reported here for them
Value here will be split between positions if more than one assignment
Pulls year to date values from payroll(s) based on the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 20 – FTE

For FTE based positions, the FTE pulls directly from the HR Assignment
For hourly based positions, the FTE is calculated using the hours on the HR assignment divided by the hours per week from the matching HR position code.

Element 21 – Salary Category (Education)

General Profile tells the extract where to look for the two digit value to be reported
Payroll Salary Grid from employee’s function line
**Note, each District may have these two characters in a different position
TTOC salary grids must have the Years of Education in the same position as the teacher grids.

Element 22 – BCCT Certification

Payroll > Reporting > BCPSEA Profiles > General Profile > PRM Certification Class Codes
- If you’re unsure of what your class code(s) should be, run the Certificate Hierarchy Report:
  - In Atrieve HR > HR Demographics > Certification and Training > Certificates > Certificate Hierarchy Report. Click Run (do not enter anything in Certificate Type prompt).
    - Locate your teaching certificate codes in the report. The class is printed in the column to the left of the codes. Add the identified class to the General Profile.
This value comes from HR Certificate Class Codes
It will then Display the HR Certificate codes with that Class attached to them in the BCPSEA Certification Code Mapping:
- Payroll > Reporting > BCPSEA Profiles > Certification Code
  - Align your Atrieve Teaching Certificate Codes with the appropriate BCPSEA Code.

Element 23 – Scale Placement

General Profile tells the extract where to look for the two digit value to be reported
Payroll Salary Grid from employee’s function line
**Note, each District may have these two characters in a different position
TTOC salary grids must have the Years of Experience in the same position as the teacher grids.

Element 24 – Increment Month

Payroll - Employee Demographics – Pay Screen
There is an increment date process that payroll needs to run before doing salary grid increments in September that populates this field.

Element 25 – Annual Salary

BCPSEA Payroll Earnings Mapping – for each payroll there is an Element 25 to be mapped. List the pay codes here for the Payroll Function line(s) to use to calculate annual salary.
Can only be 000000 if casual, ttoc or HR Assignment has 0.00 FTE or hours.

Element 26 – Annual Vacation

Applies to EU and EN Categories only
BCPSEA Payroll Earnings Mapping – each pay code for vacation pay needs to be mapped
Pulls year to date values from payroll(s) based on the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 27 – Sick Leave Days Accumulated

Applies to all categories
BCPSEA Payroll Earnings Mapping – storage bank to be listed for Sick leave accruals for each payroll
Pulls year to date values from payroll(s) based on the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 28 – Sick Days Used

If the General Profile has a Category listed here, then it will look to the BCPSEA Absence Code Mapping and report the days paid with the absence code listed here
If the General Profile does not have a Category listed, then it will look to the Payroll Earnings Code Mapping and report the hours paid with the pay codes mapped here
If the Payroll is listed in the General Profile for this prompt

Then it will look to the storage bank listed beside this element in the Payroll Earnings Code Mapping

Element 29 – TOC Days

BCPSEA Payroll Earnings Mapping – map pay codes here that represent days paid
Pulls year to date values from payroll(s) based on the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 30 – TOC Salary

BCPSEA Payroll Earnings Mapping – map pay codes here that represent monies paid
Pulls year to date values from payroll(s) based on the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 31 – Job Type

SU Category only
1=10 Month, 2=12 Month, 3=11 Month, 4=Other
Payroll Function line – Pay Cycle Code – extract looks for 10, 11 or 12 in the description.

Element 32 – Support Staff Hrs

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 33 – Casual Earnings

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter
Extra info – If casual time is paid on Support Payroll, this element to be added to the General Profile
Extra Info – if casual time is paid on Support Payroll with the same pay codes used for regular employees, this field in the General Profile has to be set to Y

If the pay codes used are specific to casuals, and not used by regular staff, then this can be set to N.

Element 34 – Hourly Rate of Pay

HR Assignment – pulls position code
HR Position Code Database – on the second page holds the salary grid range
Payroll – Employee Demographics – function line. If it finds a salary grid match, it will list the hourly rate of pay, if it cannot, then it zeros out 0.00. Salary grid can be on any function line.

Element 35 – Support Staff Reg Earnings

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 36 – Support Staff Overtime Hrs

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 37 – Support Staff Overtime Pay

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 38 – Support Staff Vacation Pay

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 39 – Support Staff Accum Sick Hrs

BCPSEA Payroll Earnings Mapping
Pulls year to date values from payroll(s) based on the storage bank listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 40 - Paid Sick Leave Hrs Used

If the General Profile has a Category listed here, then it will look to the BCPSEA Absence Code Mapping, and report the hours paid with the absence code listed here.
If there is no category listed here, then it will look to the BCPSEA Payroll Earnings Code Mapping and report the hours paid using the pay code(s) listed here
If the Payroll is listed in the General Profile for this prompt

Then it will look to the storage bank listed beside this element in the Payroll Earnings Code Mapping

Element 41 – MSP Cost

BCPSEA Deduction Code Mapping

Each deduction code is listed (left) which is mapped to the BCPSEA Element.

Pulls employer paid year to date values from payroll(s) based on the deduction code listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 42 – MSP Coverage Status

S=Single, C=Couple, F=Family, O=Opted Out
BCPSEA Deduction Code Mapping
Value here determined by which table employee has based on the above mapping for Single, Couple or Family. If no deduction on employee or suspended, then O will list.
EXTRA – For some positions – Continuing Ed – this must be listed as O. The General Profile has a spot for an override to force the O

Element 43 – Dental Cost

BCPSEA Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 44 – Dental Coverage Status

S=Single, C=Couple, F=Family, O=Opted Out
BCPSEA Deduction Code Mapping
Value here determined by which table employee has based on the above mapping for Single, Couple or Family. If no deduction on employee or suspended, then O will list.
EXTRA – For some positions – Continuing Ed – this must be listed as O. The General Profile has a spot for an override to force the O

Element 45 – EHB Cost

BCPSEA Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code listed here combined with the pay period range mapping in the BCPSEA Payroll Selection – end value to be changed each reporting quarter

Element 46 – EHB Coverage Status

S=Single, C=Couple, F=Family, O=Opted Out
BCPSEA Deduction Code Mapping
Value here determined by which table employee has based on the above mapping for Single, Couple or Family. If no deduction on employee or suspended, then O will list. If mapped to One Rate – No Table, will list as F – Family.
EXTRA – For some positions – Continuing Ed – this must be listed as O. The General Profile has a spot for an override to force the O

Element 47 – LTD Cost

BCPSEA – Payroll Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 48 – Pension Cost

BCPSEA – Payroll Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 49 – Group Life/ADD Cost

BCPSEA – Payroll Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 50 – CPP Cost

BCPSEA – Payroll Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 51 – EI Cost

BCPSEA – Payroll Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 52 – Work Safe BC Premium

BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 53 –Short Term Disability

BCPSEA – Payroll Deduction Code Mapping
Pulls employer paid year to date values from payroll(s) based on the deduction code(s) listed here (may be more than one) combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 54 – Mat leave Top-up

BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 55 – Isolation Allowance

BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 56 – SIP Allowance

EU Category only
BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 57 – Mileage

BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 58 – POSR Cost

EU Group Only
BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 59 – Other Allowances

BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 60 – Education Leave Cost

HR Assignment type, which is Cross Referenced to the BCPSEA Assignment Type code mapping.
If Assignment type is Education Leave, then year to date values will be entered here

Element 61 – Paid Union Leave Cost

EU and SU Categories Only
BCPSEA – Payroll Earnings Code Mapping
Pulls employer paid year to date values from payroll(s) based on the pay codes listed here combined with the pay period range mapping in the BCPSEA Payroll Selection (per payroll) – end value to be changed each reporting quarter

Element 62 – Unpaid Union Leave Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 63 – Unpaid Union Leave Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 64 – Parental Leave Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 65 – Parental Leave Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 66 – Paternity/Maternity/Adoption Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 67 – Paternity/Maternity/Adoption Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 68 – Compassionate Leave Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 69 – Compassionate Leave Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 70 – Unpaid Compassionate Leave Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 71 Unpaid Compassionate Leave Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 72 – Partial Medical Leave FTE

EU and SU Categories Only
HR Assignment

First portion uses the assignment type code, which is cross referenced to the BCPSEA Assignment Type code mapping. It will use assignment type codes mapped to Medical Leave.
If the FTE on the Assignment is .01-.99, then this is considered a Partial FTE, so the FTE will be listed here.
If the FTE on the Assignment is 1.0, then the FTE will not be listed here since that is not a Partial Medical leave…it is a full time medical leave.

Note, there is an element in the absence code mapping, but there is nothing to map here.

Element 73 – Other Paid Leave Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 74 – Other Paid Leave Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 75 – Other Unpaid Leave Days

EU Category only
BCPSEA Absence Code Mapping
Pulls days logged for the reporting quarter range in General Profile

Element 76 – Other Unpaid Leave Hours

SU Category only
BCPSEA Absence Code Mapping
Pulls hours logged for the reporting quarter range in General Profile

Element 77 – Position code

BCPSEA Position Code Mapping
The description from that mapping will be listed here
Casuals or TTOCs – this will be left blank

NOTE -there will be a warning message from EDAS that this is blank for them, but there is nothing to fix.