Student Import Layouts | PowerSchool Special Programs

Use these field mapping tables to Import Into PSSP from eSP.

AdminUser-AlternateStaffLocations

PSSP Field	PSSP DB Field
Staff	{__DS__?InstanceID}:{uniqueId}
Location	{__DS__?InstanceID}:{AdminUserSchools_uniqueSchoolId}
IntegrationIDT	{__DS__?InstanceID}:{staff_id}

PSSP Field	PSSP DB Field
LastName	{userName/ >}
FirstName	{[{userName/ <}]~<*>""?"{userName}":"{userName/ <}"}
WorkEmail	{email}
IntegrationIDT	{__DS__?InstanceID}:{uniqueId}
ID	{loginId$'[^a-zA-Z0-9_]','_'}
WorksAt	{defaultSchoolUniqueId~<*>""?"":"{__DS__?InstanceID}:{defaultSchoolUniqueId}"}
IdPUserID	{globalID}
WorkEmail	{email}

PSSP Field	PSSP DB Field
Staff	{__DS__?InstanceID}:{uniquestaffId}
Location	{__DS__?InstanceID}:{uniqueschoolid}
IntegrationIDT	{__DS__?InstanceID}:{staff_id}

PSSP Field	PSSP DB Field
ID	{studentID}
StateID	{StdentStateID}
LastName	{LastName}
FirstName	{FirstName}
MiddleName	{MiddleName}
Birthdate	{BirthDate}
Grade	{Grade}
Gender	{Gender}
IntegrationIDT	{_DS_?InstanceID}:{UniqueID/-1}-{studentGuid}}
School	{_DS_?InstanceID}:{EnrolledBuilding}

PSSP Field	PSSP DB Field
IntegrationIDT	{_DS_?InstanceID}:{UniqueID}
Name	{SchoolName}
City	{City}
District	{_DS_?InstanceID}:{UniqueDistrictID}
State	{State}
ID	{StateCode}
Address	{street1}{street2~#<*>""?", {street2}":""}
PostalCode	{Zip}
Telephone	{phone}
Address Type	Defaults to "Physical"
Organization Type	{SchoolTypeCode}

PSSP Field	PSSP DB Field
IntegrationIDT	{__DS__?InstanceID}:{uniqueId}
ID	{loginId$'[^a-zA-Z0-9_]','_'}
StaffIdentifier	{staffId}
Prefix	{title}
FirstName	{firstName}
MiddleName	{middleName}
LastName	{lastName}
WorkTelephoneNumber	{primaryPhone}
WorkEmail	{email}
WorksAt	{primaryBldg~<*>""?"":"{__DS__?InstanceID}:{primaryBldg}"}
IdPUserID	{globalID}

PSSP Field	PSSP DB Field	eSP DB field
Student	Student {__DS__?InstanceID}:{uniqueId/-1}-{studentGuid}
FirstName	{pFirstName}
MiddleName	{pMiddleName}
LastName	{pLastName}
RelationshipType	{pRelation}
Primary Language	{pLanguage}	pLanguage
Address	{pAddressDE}
City	{pCity}
State	{pState}
PostalCode	{pZip}
Phone1	{pPhoneOne}
Phone1Ext	{pPhoneOneExt}
Phone1Type	{pPhoneOneType}
Phone2	{pPhoneTwo}
Phone2Ext	{pPhoneTwoExt}
Phone2Type	{pPhoneTwoType}
Phone3	{pPhoneThree}
Phone3Ext	{pPhoneThreeExt}
Phone3Type	{pPhoneThreeType}
Email1	{pEmail}
Email1Type	{pEmail~#<*>""?"Current":""}
IsCustodial	{pHasCustody}	Cust_guard
LivesWith	{pLivingWith}	living_with
Receives Mail	{pReceiveLetters}	mail_reg
Sequence	{contactPriority}
IntegrationIDT	{__DS__?InstanceID}:{uniqueStudentGuid}
AddressType	{pAddressType}

PSSP Field	PSSP DB Field	eSP Location
IntegrationIDT	{__DS__?InstanceID}:{uniqueId/-1}-{studentGuid}
State ID	{StateID}	reg
ID	{studentId}
FirstName	{firstName}	reg
MiddleName	{middleName}	reg
LastName	{lastName}	reg
Grade	{grade}
Birthdate	{BirthDate}	reg
Gender	{Gender}	reg
Student Language	{StudentLanguage:N} {StudentLanguageOther:!}
Home Language	{HomeLanguage:N} {HomeLanguageOther:!}
English Learner	{EL}	reg_personal or (line below)
Address	{studentAddress}	reg_contact
Address2	{apartment}	reg_contact
City	{studentCity}	reg_contact
State	{studentState}	reg_contact
PostalCode	{studentZip}	reg_contact
Telephone	{studentHomePhone}
Email	{email}
Lineage	{generation}
Race[Asian]	{studentEthnicities~*",A,"?"true":"false"}
Race[Black]	{studentEthnicities~*",B,"?"true":"false"}
Race[Native]	{studentEthnicities~*",I,"?"true":"false"}
Race[White]	{studentEthnicities~*",W,"?"true":"false"}
Race[Pacific]	{studentEthnicities~*",P,"?"true":"false"}
Race[Hispanic]	{hispanic}
Ethnicity	{Race[Hispanic]}
IdPUserID	{globalID}
EL	{englishas secondlanguage}