====== Data Utilities ======
[[https://kb.infinitecampus.com/help/ed3ea28|Data Utilities]]

===== Ad Hoc Deactivated Elements Impact Report =====
[[https://kb.infinitecampus.com/help/deactivated-elements-impact-report|Deactivated Elements Impact Report]]

[[https://kb.infinitecampus.com/help/locate-deactivated-data-elements-video|Deactivated Elements Impact Report Video]]

===== Ad Hoc Element Replacement Wizard =====
[[https://kb.infinitecampus.com/help/element-replacement|Element Replacement]]

[[https://kb.infinitecampus.com/help/ad-hoc-element-replacement-wizard-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 Extract History =====
[[https://kb.infinitecampus.com/help/data-extract-history-data-extract-history|Data Extract History]]
===== Data Extract Utility =====
[[https://kb.infinitecampus.com/help/data-extract-utility|Data Extract Utility]]

[[https://kb.infinitecampus.com/help/data-extract-utility-client-pull-method-update|Data Extract Utility Client (Pull Method) Update]]

[[https://kb.infinitecampus.com/help/setting-up-the-data-extract-client-to-utilize-the-pull-delivery-mode|Setting Up the Data Extract Client to Utilize the Pull Delivery Mode]]

==== OneRoster CSV Extract ====
[[https://kb.infinitecampus.com/help/oneroster-csv-extract-configuration|OneRoster CSV Extract Configuration]]

<code sql>
--Academic Sessions
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterAcademicSessions] 
@type = 'bulk'
GO

--Categories
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterCategories] 
@type = 'bulk'
GO

--Classes
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterClasses] 
@type = 'bulk'
GO

--Courses
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterCourses] 
@type = 'bulk'
GO

--Demographics
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterDemographics] 
@type = 'bulk'
GO

--Enrollments
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterEnrollments] 
@type = 'bulk'
GO

--LineItems
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterLineItems] 
@type = 'bulk'
GO

--Manifest
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterManifest] 
@type = 'bulk'
GO

--Orgs
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterOrgs] 
@type = 'bulk'
GO

--Results
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterResults] 
@type = 'bulk'
GO

--Users
DECLARE @RC int
DECLARE @type varchar(10)
DECLARE @days int
EXECUTE @RC = [dbo].[extract_V1P1OneRosterUsers] 
@type = 'bulk'
GO
</code>
===== Data Extract Zip Tool =====
[[https://kb.infinitecampus.com/help/data-extract-zip-tool-data-extract-zip-tool|Data Extract Zip Tool]]

===== Data Health Check =====
[[https://kb.infinitecampus.com/help/data-health-check-report|Data Health Check Report]]