PowerSchool SIS Integration

ID

{student_local_id}

{ID}

Profile > Student Information

FirstName

{student_name_first_name}

{FirstName}

LastName

{student_name_last_name}

{LastName}

BirthDate

{student_demographics_birth_date:6,2}/{student_demographics_birth_date:9,2}/{student_demographics_birth_date:1,4}

{BirthDate}

Student Address

{student_addresses_physical_street}

• {Street}

• {Address2}

Student City

{student_addresses_physical_city}

StudentState

{student_addresses_physical_state_province}

{City}, {Province}

StudentZipCode

{student_addresses_physical_postal_code}

{PostalCode}

StudentHomePhone

{student_phones_main_number}

{HomePhone}

Grade

{student_school_enrollment_grade_level:1,2<0}

{Grade}

EnrollmentStartDate

{student_school_enrollment_entry_date:6,2}/{student_school_enrollment_entry_date:9,2}/{student_school_enrollment_entry_date:1,4}

{DistEnrollStartDate}

EnrollmentEndDate

{student_school_enrollment_exit_date:6,2}/{student_school_enrollment_exit_date:9,2}/{student_school_enrollment_exit_date:1,4}

{DistEnrollEndDate}

Race[Black]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Black]}

Race[Asian]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Asian]}

Race[Hispanic]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Hispanic]}

Race[White]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[White]}

Race[Pacific]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Pacific]}

Race{Native]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[Native]}

MiddleName

{student_name_middle_name}

{MiddleName}

IntegrationIDT

{__DS__?InstanceID}:{student_id}

Gender

{student_demographics_gender}

{Gender}

Parent2FirstName

{student_contact_mother/1}

{Parent2FirstName}

Profile > Parent Guardian Information

Parent2LastName

{student_contact_mother/2}

{Parent2LastName}

Parent1FirstName

{student_contact_father/1}

{Parent1FirstName} 

Parent1LastName

{student_contact_father/2}

{Parent1LastName}

Parent1Email

{student_contact_guardian_email}

{Parent1Email}

Race[None]

{student_ethnicity_race_scheduling_reporting_ethnicity}

{Race[None]}

School

{__DS__?InstanceID}:{student_school_enrollment_school_id}

{School}

Student

{__DS__?InstanceID}:{student_id}

{ID}

FirstName

{first_name}

{FirstName}

LastName

{last_name}

{LastName}

MiddleName

{middle_name}

{MiddleName}

Prefix

{prefix}

Suffix

{suffix}

Address

{[{[{street} {unit} {linetwo}]-< > }]@<*>" "*>>" "}

{Street}        

{Address2}

City

{city}

State

{state}

{City}, {Province}

PostalCode

{postal_code}

{PostalCode}

AddressType

{address_type<A1>}

Phone1

{phone1}

{Parent1HomePhone}

Phone1Ext

{phone1_ext}

Phone1Type

{phone1_type<A1>}

Home Phone Label

Phone2

{phone2}

{Parent1WorkPhone}

Phone2Ext

{phone2_ext}

Phone2Type

{phone2_type<A1>}

Work Phone Label

Phone3

{phone3}

{Parent1CellPhone}

Phone3Ext

{phone3_ext}

Phone3Type

{phone3_type<A1>}

Cell Phone Label

Email1

{email1}

{Parent1Email}

Email1Type

{email1_type<A1>}

Email2

{email2}

{Parent2Email}

Email2Type

{email2_type<A1>}

RelationshipType

{relationship_type<A1>}

{Parent1Relationship}

1-4

IsCustodial

{is_custodial}

{@IFELSE(Parent1JointCust, "Yes", "No")}

Relabel Has Custody

IsEmergency

{is_emergency}

LivesWith

{lives_with}

ReceivesMail

{receives_mail}

{Parent1GetLetters}

SchoolPickup

{school_pickup}

Gender

{gender}

{Gender}

Allow Override With Empty, Set as Empty When Not Valid

Sequence

{Sequence}

Allow Override With Empty, Set as Empty When Not Valid

#DeleteFlag

{student_contact_rel_id~<*>""?"true":"false"}

IntegrationIDT

{__DS__?InstanceID}:{student_contact_rel_id}

Integration IDT

SPEnrollmentSDCID

spenrollmentsdcid

RegulareducationPortion

RegularEducationPortion

RegPercent.Code

EducationalSetting

EducationalSetting

Environment.Code

isonepercent

IsOnePercent

{AltAssessment}

extschoolyear

ExtSchoolYear

{ESY}

Integrationidt

S4=

Student Number

{ID}

·          

S1 & S4 records required

StudEntID

{StateID}

·          

Code 1

{PrimaryDisability:F"InUse"}

·          

Primary Disability

Code 2

{TimePerDay:F"InUse"}

·          

TimePerDay

ExitCode

{SpecialEdExitReason:F"Special_Education"}

·          

Special Ed Exit Reason

ProgramID

{Environment:F"InUse"}

·          

EnterDate

{InitEligibilityDate}

·          

Special Ed Start Date

ExitDate

{SpecialEdExitDate}

·          

Special Ed Exit Date

Record ID

S4=

Student Number

{ID}

·          

S1 & S4 records required

Section 504 Entry Date

{Section504EntryDate}

[SpEnrollments]Enter_Date

Section 504 Exit Date

{Section504ExitDate}

[SpEnrollments]Exit_Date

Section 504 Exit Reason

{ExitReason} {ExitReason_Other}{-ExitReason_Other}

[SpEnrollments]ExitCode

LEA Number

{ThisDistrict} ID

LEA Number would be the PS district so:

[Prefs]Value where [Prefs]name = districtnumber

School Number

{=School.ID}

[SpEnrollments]SchoolID

Autism

Y/Blank

Autism

Disabilities entered in 1-3 will indicate Y/N in the appropriate fields below..

{Disability1}

{Disability2}

{Disability3}

Brain Injury or Concussion Impairment

Y/Blank

BraininjConcussionImpmnt

Hearing Impairment

Y/Blank

Hearingimpmnt

Learning Impairment

Y/Blank

Learningimpmnt

Major Bodily Function Impairment

Y/Blank

MajorBodilyFunctionImprmnt

Medical Impairment

Y/Blank

MedicalImprmnt

Mental Health Impairment

Y/Blank

MentalHealthImprmnt

Orthopedic Impairment

Y/Blank

OrthopedicImprmnt

Other Impairment

Y/Blank

OtherImprmnt