Required fields for a successful sync


Student


PS DB Fields PS API Fields
Students.ID id
Students.ID id
Students.DCID dcid
Students.Student_Number

local_id
Students.First_Name first_name
Students.Middle_Name middle_name
Students.Last_Name last_name
Students.Student_Number local_id

Student_contact


PS DB Fields PS API Fields
StudentContactDetail.StudentContactDetailID contact_id
Person.FirstName firstName
Person.MiddleName middleName
Person.LastName lastName
PCAS_Account.Username userName
PersonPhoneNumberAssoc.PhoneNumberAsEntered phoneNumber
StudentContactDetail.RelationshipNote relationshipNote
OriginalContactMap.OriginalContactType originalContactType
StudentContactDetail.RelationshipTypeCodeSetId relationship
StudentContactDetail.SchoolPickupFlg schoolPickup

Organization


PS DB Fields PS API Fields
Schools.ID id
Schools.School_Number school_number

Attendance_code


PS DB Fields PS API Fields
Attendance_code.DCID DCID
Attendance_code.SCHOOLID SCHOOLID
Attendance_code.YEARID YEARID
Attendance_code.ATT_CODE ATT_CODE
Attendance_code.ALTERNATE_CODE ALTERNATE_CODE
Attendance_code.DESCRIPTION DESCRIPTION
Attendance_code.PRESENCE_STATUS_CD PRESENCE_STATUS_CD