Source Data required by the NCEdCloud IAM Service (and other systems), comes from the designated authoritative databases or Systems of Record. The primary data sources for the NCEdCloud IAM Service are listed below and can also be found in the data resources documents listed in the sidebar. Specific data elements are required by the IAM Service to provision user accounts and establish roles or enable access to target applications integrated with the Service.
Student Data
- PowerSchool (PSU local instances feed a statewide database) OR
- NCSIS (Infinite Campus)
Employee Data
- Staff UID (Unique statewide IDentifier system)
- Staff UID is maintained by PSU Payroll systems running Batch Upload Extracts
- For Staff email address:
- PowerSchool State ODS (operational data store)
- NCSIS (Infinite Campus)
- NOTE: As of January 2024, email addresses from HR data sources are no longer supported. The jobs still run; however, they are not reliable, and a root cause has not been identified.
- EDDIE (Educational Directory and Demographical Information Exchange
Critical Data Needs
While ALL the data described in the Student and Employee Schemas is necessary to provision NCEdCloud accounts for the PSUs, the UID, LEA Code, Budget Codes (Job/Object Code and Department/Purpose Code), and Email are the most critical. The LEA Code determines in "which" PSU the user is visible. Budget codes are used to create staff roles such as Teacher, Faculty or Employee, while Email is used in the IAM Service for some self-service functions as well as in Workflow requests and approvals. Additionally, some number of applications and other online resources use email as a required user attribute.
PSU employees with the "Data Auditor" or "LEA Administrator" role have the ability to look at their district's or school's data to verify that the right LEA Code, Budget Codes (e.g. Job and Department Codes), and Email are indeed present and accurate. Any errors or missing information should be updated in the appropriate System of Record (e.g. PowerSchool/NCSIS for students and PowerSchool/NCSIS, UID, Payroll, and HRMS for employees). The Schemas document shows which System the data element is pulled from.
*** NOTE: While the Staff UID system is the authoritative source for most of the Employee Data in the IAM Service, it is UPDATED by extracts from PSU Payroll Systems. Data that is not accurate in the IAM Service - for example Date of Birth, Last Name, LEA Code(s), etc. - has likely been entered in error in the Payroll system, and needs to be corrected there. Then the Staff UID Batch Upload process needs to be run to update the changes to the Staff UID System the same day. Otherwise, updates will not be made until the next scheduled Payroll process is run. Updates made to the Staff UID system will show up in the IAM Service the next business day.
Source Data for the IAM Service is often referred to as "Identity" or directory data and is used to uniquely identify a student, teacher or other user across the entire state. The IAM Service only consumes data needed for this purpose or when specifically required by one of the integrated applications (e.g. SchoolNet codes are passed to the IAM Service as part of an employee's record). Student course enrollment or "roster" data is not part of the Service at this time, since it is provided "out of band" to applications that need it - usually from the Student Information System (PowerSchool or Infinite Campus).
