Unique Person Identifiers (UIC)

All Ed-Fi categories and resources that carry data containing staff, students, or student contacts must include a reference to the corresponding Unique ID for that person. Unique IDs must be assigned before any related data can be published to the state. The assignment of missing Unique IDs is automatically managed by the Ed-Fi publishing process for staff and contacts. Use the Request UIC process for missing student Unique IDs.

Unique Person Identifiers for Students

For Michigan, the Student Unique ID is not stored in a regular PowerSchool table, but is held in the following Ed-Fi publishing table, and is referenced whenever student data is published or updated to the state ODS: [CST_PubUniqueIdStudent]UniqueId.

Unique Person Identifiers for Staff

This category provides views related to Staff Unique IDs. Michigan Staff Unique IDs are not stored in a regular PowerSchool table. Michigan Staff Unique IDs are held in the following Ed-Fi publishing table: [CST_PubUniqueIdStaff]UniqueId. 

To view a staff member's Unique Person ID, navigate to Reports > System Reports > Ed-Fi Reporting > Staff Demographics > Data Views > Staff Published > Staff Unique ID Status.

To view a staff member's Unique Person ID within PowerSchool, navigate to Staff > Information > Ed-Fi Information> State Assigned Unique Person ID.

Unique Person Identifiers for Student Contacts

For Michigan, the Student Contact Unique ID is held in the STATE_CONTACTNUMBER field in the S_CONTACTS_S extended schema table. For Ed-Fi purposes, it is also held in the following Ed-Fi publishing table, which is referenced whenever student contact data is published or updated to the state ODS: [CST_PubUniqueIdParent]UniqueId.

To view a student contact Unique Person ID within PowerSchool, navigate to Start Page > Contacts > Contact Information > State Contact Number or State Assigned Unique Person ID.