hone,'') AS StudentPrimaryContactPhoneNumber
FROM person p
INNER JOIN [identity] i ON i.identityID = p.currentidentityID
LEFT OUTER JOIN contact c1 ON c1.personID = p.personID
INNER JOIN enrollment e ON e.personID = p.personID AND e.enrollmentID =
(SELECT TOP 1 x.enrollmentID F
== Students =====
<code sql>
WITH S AS (
SELECT P.personID,P.studentNumber AS studentNumber,I.firstName,I.lastName,E.grade
FROM Person P
JOIN Enrollment E ON P.personID = E.personID AND E.endDate IS NULL
JOIN Calendar Cal ON E.calendarID = Cal.calendarID AND Cal.summerSch
-video|Element Replacement Video]]
===== Combine Person Wizard =====
[[https://kb.infinitecampus.com/help/combine-duplicate-person-records|Combine Person Wizard]]
[[https://kb.infinitecampus.com/help/combine-person-video|Combine Person Wizard Video]]
===== Data E
TO CustomTransportation
SELECT ca.attributeID,snh.personID,tc.TrnsCmt AS value,GETDATE() AS date,t.transpo... ationComment'
) ca
JOIN Transportation t ON t.PersonID = snh.personID
JOIN Calendar c ON t.calendarID = c.calendarID
JOIN SchoolYear sy ON sy.active = 1 AND s