Ref Table Description Values Longer than character limit
Closed this issue · 1 comments
Describe the bug
Currently Description in Ref tables is a nvarchar(100) however several reference tables have values in the populating script that are truncated to fit this length. In most cases these seem to be small, only 1-3 characters and it's straightforward to interpolate what's being cut off, but in others it's hard to tell just what's being cut off. Currently these tables are:
RefCarnegieBasicClassification
RefCourseSectionExitType
RefExitOrWithdrawalType
RefIPEDSFASBFinancialPosition
RefPESCAwardLevelType
RefProgramExitReason
RefProgramGiftedEligibility
RefRlisProgramUse
RefTribalAffiliation
To Reproduce
Steps to reproduce the behavior:
- Go to 'Populate-CEDS-Ref-Tables.sql'
- Search for one of the above tables
- Locate record that is truncated. For example RefPESCAwardLevelType has a Description with the value 'Postsecondary award, certificate, or diploma of less than one academic year (less than 900 contact o' and it's unclear at a quick glance just what's being lost with the truncation.
Expected behavior
I'd expect the Description field to be long enough to hold all values without truncation
Addressed in V9.0.0.0 release, #42. See CEDS OSC IDS Summary v9 Changes.xlsx for additional details.