Add 2.0 StaffCredential sample data to allow for upgrade compatibility to 2.1

Summary:

• Current sample data in table edfi.StaffCredential missing values for StateOfIssueStateAbbreviationTypeId, which is now a required value for the 2.0 => 2.1 upgrade. Possible update to 2.0 sample data may be required.

Details:

• In 2.0, the StateOfIssueStateAbbreviationTypeId column on edfi.StaffCredential is optional.
  • v20 handbook reference: http://schema.ed-fi.org/datahandbook-v20/MetaEd-Handbook-Index.html#/Credential496

• For 2.1, the StateOfIssueStateAbbreviationTypeId on edfi.Credential has become a required part of the new key:
  • v21 handbook reference: http://schema.ed-fi.org/datahandbook-v21/MetaEd-Handbook-Index.html#/Credential2630

• For the 2.0 => 2.1 upgrade, a requirement is being added that all edfi.StaffCredential rows have data in StateOfIssueStateAbbreviationTypeId before the migration can proceed (see comments in linked ticket). This requirement makes the 2.0 populated template incompatible for upgrade out of the box however, because all StateOfIssueStateAbbreviationTypeId values are currently null.

Reference/Data Source: Query on ODS Populated Template 2.0.0.21

SELECT COUNT(*) FROM [EdFi_Ods_Populated_Template_v2.0.0.21].edfi.StaffCredential WHERE StateOfIssueStateAbbreviationTypeId IS NULL

> 56 results

Additional notes:

• Currently as a workaround, the StateOfIssueStateAbbreviationTypeId from sample staff member's associated school address is being used for development (State ID #54 for the above referenced ODS)