Ed-Fi Audit Report

Tool Search: Ed-Fi Audit Report

The Ed‑Fi Audit Report provides a record of all Ed‑Fi resync and delete requests initiated within your Infinite Campus site. It shows who triggered each request (user or automated process), when it occurred, which schools were included, and which Ed‑Fi resources were affected.

This report does NOT display any filters that may have been used on the request (such as specific personIDs, courseIDs, or sectionIDs). It confirms that a request was made and logs its key details.

Screenshot of the Ed-Fi Audit Report. Ed-Fi Audit Report

Read - Access and generate the Ed-Fi Audit Report.
Write - Provides no additional functionality for this tool
Add - Provides no additional functionality for this tool
Delete - Provides no additional functionality for this tool

For more information about Tool Rights and how they function, see this Tool Rights article.

Generate the Ed-Fi Audit Report

The Ed-Fi Audit Report generates a report that includes various details about resync/delete requests made in the last 90 days for a configuration(s).

Screenshot of teh Ed-Fi Audit Report. Generate the Ed-Fi Audit Report

To Generate the Report:

Select the Ed-Fi Configuration(s). The report can be run against Ed-Fi Configurations in any combination of School Years.
To generate the report immediately, select the Generate Report button. Or, use the Submit to Batch Queue button to select when the report is generated.
The report is generated in CSV format.

Report Data Elements Logic

The report is sorted based on the following columns: Timestamp, Ed-Fi Configuration ID, Ed-Fi Application ID, and Person ID.

Screenshot of an example of the Identity report generated. Example of the Identity Mapping Report

Data Element	Business Rule(s)	Database Field(s)
Ed-Fi Configuration ID	Reports the Ed-Fi Configuration ID of the Ed-Fi Configuration.	EdFiAudit.edFiConfigurationID
Ed-Fi Application ID	Reports the Ed-Fi Application ID of the Ed-Fi Configuration.	EdFiAudit.edFiApplicationID
Ed-Fi Configuration Name	Reports the Connection Name of the Ed-Fi Configuration being reported. Reports Connection Name - Credential Name if reporting from a multi-connection.	EdFiConfiguration.[name] (Connection Name) EdFiApplication.[name] (Credential Name)
Timestamp	Reports the Timestamp associated with the Resync/Delete request. Reports in the format of YYYYMMDD-HHMMSS.	EdFiAudit.[auditTimestamp]
Person ID	Reports the Person ID of the user that initiated the request. Reports nothing (NULL) when the request was initiated through a Prism Call or the Resync Scheduler.	EdFiAudit.personID
Person Name	Reports the Last Name, First Name from the current Identity record. Reports Automated Request when the request was initiated through a Prism Call or the Resync Scheduler.	[Identity].lastName [Identity].firstName
Request Type	Reports: Resync or Delete, depending on the type of request submitted.	EdFiAudit.requestType
Schools	Reports the School Name(s) that were selected for the request. If multiple Schools were selected in the request, they will be separated by the pipe (\|) symbol. Schools will be listed in alphabetical order. Deletes do not have school(s) associated with them. Deletes are not school-based, but rather, they are application-based.	EdFiAuditSchool.schoolID > School.name
Resources	Reports the Resource Name(s) that were selected for the request. If multiple Resources were selected in the request, they will be separated by the pipe (\|) symbol. Resources will be listed in alphabetical order.	EdFiAuditResource.edFiPreferenceID > EdFiResourcePreferences.[resource]

Generate the Ed-Fi Audit Report

To Generate the Report:

Report Data Elements Logic

Related Articles