...
Student, Parent, and Staff Keys
Requirement
The views should expose "Key" fields based on the natural key of the underlying table. In the case of StudentDimension , ContactPersonDimension , and UserDimension , the original release used StudentUSI , ParentUSI , and StaffUSI respectively. The "USI" columns are primary keys and were used by mistake. The "UniqueId" columns are the correct natural keys.
Design
Change all instances of StudentKey , ContactPersonKey , and UserKey to use the corresponding "UniqueId" column from the source table.
Descriptor and Type Mapping
...
| Expand |
|---|
| title | List of Descriptor and Type Constants... |
|---|
|
| ConstantName | Purpose |
|---|
| AddressType.Home | Looking up ContactPerson's Home address | | AddressType.Mailing | Looking up ContactPerson's Mailing address | | AddressType.Physical | Looking up ContactPerson's Physical address | | AddressType.Temporary | Looking up ContactPerson's Temporary address | | AddressType.Work | Looking up ContactPerson's Work address | | Descriptor.Absent | Looking up StudentAbsenceEvents that should be treated as "Absent" in an Early Warning System. Example descriptor values to map might be "Excused Absence" and "Unexcused Absence." As another example, if a Field Trip absence event should be treated as an absence from school for the purpose of Early Warning, then one would also map the descriptor for "Field Trip" to the constant "Descriptor.Absent". | | Descriptor.Tardy | Looks up StudentAbsenceEvents that should be treated as "Tardy". | | Descriptor.InstructionalDay | Determines if a calendar date is an instructional day that should be used in calculating attendance rates. The Ed-Fi default template mapping would use both the "Instructional Day" and "Make Up Day" descriptors. | | EmailType.Home/Personal | Looking up ContactPerson's home or personal e-mail address. | | EmailType.Work | Looking up ContactPerson's work e-mail address. | | FoodServicesDescriptor.FullPrice | Determines if a student is eligible for school food service. | | GradeType.Grading Period | Looking up the Grade records by the most granular period, which by default is "Grading Period". Some implementations might instead use terms like "Quarter" or "Six Weeks". | | TelephoneNumberType.Home | Looking up ContactPerson's Home phone number. | | TelephoneNumberType.Mobile | Looking up ContactPerson's Mobile phone number. | | TelephoneNumberType.Work | Looking up ContactPerson's Work phone number. |
|
Example
In Version 1.x, the StudentEarlyWarningFact view reports on absences, looking for StudentSchoolAttendanceEvent records with attendance descriptor values of either "Excused Absence" or "Unexcused Absence".
...