match
INSERT INTO ProgramParticipation (programID,personID,startDate,districtID)
SELECT P.programID, CS.personID, CAST(CS.date AS DATE) AS startDate,D.districtID
... lue = 'N'
LEFT JOIN ProgramParticipation PP ON PP.personID = CS.personID AND PP.startDate = CAST(CS.date AS DATE)
CROSS JOIN (SELECT programID FROM Program WHERE
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
Census > People > Demographics | Person Info > First Name |
| Midd... Census > People > Demographics | Person Info > Middle Name |
| Last... Census > People > Demographics | Person Info > Last Name |
| Suff... Census > People > Demographics | Person Info > Suffix |
| Nick
IS ID Assignment system.
StudentNumber is set to PersonID where a Person does not have a student number and has an active enrollment.
<code sql>
UPDATE Person
SET studentNumber = P.personID
FROM Person P
JOIN Enrollment E ON P.personID = e.personID
WHERE studentNu
ensus-staff-information|Census Staff]]
Audience: Person(s) responsible for managing staff information
Sk... embers who are also parents? ====
Only create one person. Infinite Campus recommends that the staff member... ry email address be their work email address. The person will have two user accounts; one for work access ... [[https://kb.infinitecampus.com/help/demographics#personal-contact-information|Personal Contact Informatio
-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
| Census > People > Demographics | Personal Contact Information > {Household} |
===== Home... |
| Proof of Residency | Census > People > Person Documents
t be given an **Activation Key**. This key is the person's **GUID** (Global Unique Identifier) available w... phanumeric identification number assigned to each person within Campus.
{{:campus:portal:pasted:20230802-
711-145313.png?800}}
**Student** is defined as a person in Census with an Enrollment to a particular Calendar.
**Staff** is defined as a person in Census with an Assignment to a particular Scho
ol, the [[https://kb.infinitecampus.com/help/fees-person|Person Fees]] tool, or the [[https://kb.infinitecampus.com/help/fees-households|Household Fees]] tool.
pplication.
Linking – This is where we connect a person, household, or address in the application to an e... gs > Online Registration Setup > OLR Lists Bank > Person-Healthconditions\\ \\ Add Health Condition Codes