Updating Managed Descriptors for Previous Versions

The Ed-Fi Data Standard v2.2 introduced a change in Ed-Fi Managed Descriptors (i.e., the enumeration values that can be updated by vendor client systems). The new list of Managed Descriptors that ships with ODS / API 2.6 is:

AssessmentPeriodDescriptor
PerformanceLevelDescriptor
AccomodationDescriptor

New ODS / API 2.6 implementations will be automatically configured with this change.

However, existing implementations of v2.5 and earlier may elect to update their security configurations to match this change using the following SQL script:

USE EdFi_Security;
DECLARE @systemDescriptorClaimId int;

SELECT @systemDescriptorClaimId = [ResourceClaimId] 
FROM [EdFi_Security].[dbo].[ResourceClaims] where ResourceName = 'systemDescriptors'

UPDATE [EdFi_Security].[dbo].[ResourceClaims] 
SET ParentResourceClaimId = @systemDescriptorClaimId where ResourceName ='competencyLevelDescriptor' OR  ResourceName ='diagnosisDescriptor'