PowerSchool SIS Integration

Student > Profile > Student Information > Student Number

ID

{student_local_id}

Student > Profile > Student Information >

FirstName

{student_name_first_name}

Student > Profile > Student Information >

LastName

{student_name_last_name}

Student > Profile > Student Information >

BirthDate

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

Note: Spaces added to text string for readability purposes.

Student > Profile > Student Information >

Street, Address2

{student_addresses_physical_street}

Student Address

Student > Profile > Student Information >

City

{student_addresses_physical_city}

Student > Profile > Student Information >

Province

{student_addresses_physical_state_province}

Student > Profile > Student Information >

PostalCode

{student_addresses_physical_postal_code}

Student > Profile > Student Information >

HomePhone

{student_phones_main_number}

Student > Profile > Student Information >

Grade

{student_school_enrollment_grade_level:1,2<0}

Student > Profile > Student Information > Enrollment Information > District Enrollment Start Date

DistEnrollStartDate

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

Note: Spaces added to text string for readability purposes.

Student > Profile > Student Information > Enrollment Information > District Enrollment End Date

DistEnrollEndDate

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

Note: Spaces added to text string for readability purposes.

Student > Profile > Parent Guardian Information

EmergencyContact1
{EmergContact1Relation}

{student_contact_emergency_contact_name1}

Student > Profile > Parent Guardian Information

EmergencyContact1
{Emerg1Phone1}

{student_contact_emergency_phone1}

Student > Profile > Student Information >

Middle Name

{student_name_middle_name}

Internal Only

Integration IDT

{_DS_?InstanceID}:{student_id}

Student > Profile > Student Information >

Gender

{student_demographics_gender}

Student > Profile > Parent Guardian Information

Parent2FirstName

{student_contact_mother/1}

Student > Profile > Parent Guardian Information

Parent1FirstName

{student_contact_mother/2}

Student > Profile > Parent Guardian Information

Parent1LastName

{student_contact_father/1}

Student > Profile > Student Information > Primary School

School

{student_contact_father/2}

Student > Profile > Student Information > Current Identification and Placement Section: Primary and Secondary Exceptionality

{PrimaryExceptionality:F"InUse"}

{SecondaryExceptionality:F"InUse"}

{ThirdExceptionality:F"InUse"}

{FourthExceptionality:F"InUse"}

{FifthExceptionality:F"InUse"}

{_DS_?InstanceID}:{student_school_enrollment_school_id}

SecondaryExceptionality_l

{student_s_ab_stu_x_spcledustu2}

Student > Profile > Student Information > Alberta Student Number

{ProvinceID}

[Students]State_StudentNumber

Student > Profile > Student Information > English as an Additional Language (ELL Code)

{EAL}

S_AB_STU_X.GrantsProgram1

PowerSchool SIS: Extended Enrollment tab

Student > Profile > Student Information >
Status in Canada (Refugee Status)

{StatusInCanada}

{student_s_ab_stu_x_citizenship}

Student > Profile > Student Information >
Language Spoken at Home

{HomeLanguage}

{student_s_ab_stu_x_languagespokenathome}

Student>Profile>Preferred First Name

{PreFirstName} 

{student_s_ab_stu_x_akagivenname}

Student>Profile>Preferred Middle Name

{student_s_ab_stu_x_akamiddlename}

Student>Profile>Preferred Last Name

{PreLastName}

{student_s_ab_stu_x_akasurname}

Student > Profile > Student Information > Student Number

ID

{studentid}

{student_local_id}

Student > Profile > Student Information > Enrollment Information > Additional School Building

{AdditionalSchool:NAO"AdditionalSchoolTxt"}

S_AB_STU_ConEnrollments_C.SchoolID

-school number school.school

IntegrationIDT

Internal Field

Student > Profile > Medical Alert Type

{MedicalAlertType} {MedicalAlertTypeTxt:!}{-MedicalAlertTypeTxt}

S_AB_STU_MEDICAL_ALERT_C

PSSP has the ability to store text from the IPP/ISP forms to the Medical Alert Section.

AB_CODE_VALUE, class_NAME = MedicalAlertType
Allergy         
Asthma
Diabetes
Epilepsy
Heart
Hemophilia
Illness
Mental
Other
Severe Allergy
Asthma
Diabetes
Epilepsy
Heart Condition
Hemophilia
Chronic Illness
Mental Disability
Other Medical Condition
Physical Disability

Medical Alert Message

{MedicalAlertMessage:W99%H3}

S_AB_STU_MEDICAL_ALERT_C.MEDICALALERTTYPE

In Pasi

SELECT * from AB_STUDENT_MEDICAL_ALERT_INFO where LOCAL_ID = XXXXX  (ID FROM_S_AB_STU_MEDICAL_ALERT_C TABLE)

AB_STUDENT_MEDICAL_ALERT_INFO with AB_STUDENT_MEDICAL_ALERT_INFO.LOCAL_ID = S_AB_STU_MEDICAL_ALERT_C.ID)

Checkbox
PowerSchool SIS: In PASI column is used to show the client whether the record is in PASI. It is not a database column. The value is calculated from the backend.

Student > Profile > Parent Guardian Information

PowerSchool – Student Import fills the student Parent Guardian Information for correspondence.

Student > Profile > Student Guardians
Student ID

{_DS_?InstanceID}:{student_id}

These two imports handle the new unlimited contact screens in PowerSchool SIS. However only contacts 1 - 4 are copied into PSSP screens.

FirstName

{tables_guardian_firstname}

{FirstName} {MiddleName} {LastName}

LastName

{tables_guardian_lastname}

UserName

{tables_pcas_account_username}

{UserName}

EmailAddress

{tables_pcas_emailcontact_emailaddress}

{EmailAddress}

Open ID

\{\[\{__DS__?ServerUrl\}/oid/guardian/\{tables_pcas_account_username\}\]@*>"/guardian/">""\}

{OpenID}

Student > Profile > Student Student Contacts

PowerSchool – Student Import fills the student Parent Guardian Information for correspondence.

Student > Profile > Student Guardians & Student Contacts

Student

{_DS_?InstanceID}:{student_id}

These two imports handle the new unlimited contact screens in PowerSchool SIS. However only contacts 1 - 4 are copied into PSSP screens.

FirstName

{first_name}

LastName

{last_name}

MiddleName

{middle_name}

{FirstName} {MiddleName} {LastName}

Prefix

{prefix}

Suffix

{suffix}

Address

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

• {Street}

• {Address2}

City

{city}

1.

State

{state}

2. {City}, {Province}

PostalCode

{postal_code}

3. {PostalCode}

AddressType

{address_type<A1>}

4.

Phone1

{phone1}

5. {Parent1Contact1}

Phone1Ext

{phone1_ext}

6.

Phone1Type

{phone1_type<A1>}

7.

Phone2

{phone2}

8. {Parent1Contact2}

Phone2Ext

{phone2_ext}

9.

Phone2Type

{phone2_type<A1>}

10.

Phone3

{phone3}

11. {Parent1Contact3}

Phone3Ext

{phone3_ext}

12. {Parent1Contact4}

Phone3Type

{phone3_type<A1>}

13. {Parent1Contact5}

Email1

{email1}

14.{Parent1EmailAddress}

Email1Type

{email1_type<A1>}

15.

Email2

{email2}

16.

Email2Type

{email2_type<A1>}

17.

RelationshipType

{relationship_type<A1>}

18. {Parent1Relationship}

1-4

IsCustodial

{is_custodial}

19.

IsEmergency

{is_emergency}

20.

LivesWith

{lives_with}

21.

ReceivesMail

{receives_mail}

22.

SchoolPickup

{school_pickup}

23.

Gender

{gender}

24.

Allow Override With Empty, Set as Empty When Not Valid

Sequence

{Sequence}

25.

Allow Override With Empty, Set as Empty When Not Valid

#DeleteFlag

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

26.

IntegrationIDT

{_DS_?InstanceID}:{student_contact_rel_id}

27.