20.24.12 Data changes ?

Randall.S.394

I am looking at the release notes for December and I don't see any datatypes or constraints listed for the new columns like there have been in 20.24.7 - 20.24.10) Are the details of these changes listed somewhere else? I am just trying to have scripts in place before the change is applied.

Claire.D.2

Hi @Randall.S.394, the data types and constraints should have been included, but it slipped through the cracks. Sorry about that! It will take a bit of time to update the release note, so here's a list of the new columns and their info:

• Content Objects BDS
  • AIUtilization (int, non-nullable)
• Content User Completion BDS
  • Version (bigint, non-nullable)
  • LastModifiedBy (int, non-nullable)
  • IsDeleted (bit, non-nullable)
  • AutomaticDateCompleted (datetime2, non-nullable)
  • ManualDateCompleted (datetime2, non-nullable)
• Course Copy Logs BDS
  • StatusId (int, non-nullable)
• Grade Objects BDS
  • ToolId (int, nullable)
  • Version (int, non-nullable)
• Outcomes Aligned to Tool Objects BDS
  • AIUtilization (int, non-nullable)
• Outcomes Assessed Checkpoints BDS
  • AchievedLevelId (uniqueidentifier, nullable)

I hope this helps!

Allard.N.654

Hi @Claire.D.2 ,

There are some differences between your list and the release notes.

• Content User Completion / Version (not in release notes) + data limit changed (not in this list)
• Grade Objects / OrgUnitId, TypeName, and IsDeleted not nullable now (not in this list)
• Rubric Object Criteria / Name max length updated (not in this list)
• (All sets? Or just Grade Objects?) bit and datetime2 columns changed (not in this list)

Does this mean the release notes are more up to date? If so, what will happen with the Version column (first bullet?)

Furthermore, I think this is quite some change for a minor version update. I would have expected the bit and datetime consistency to be part of v10 for a more controlled migration.