Table Reorg for the UWSDBDataStore Curriculum Management objects on December 16, 2019
November 25, 2019
Hello,
The Curriculum Management tables in UWSDBDataStore will have some changes on Dec. 16, 2019. These changes to the objects (listed below) will be available in the UWSDBDataStore on Dec 17, 2019 .
However, data on the new objects will be visible as soon as the Data Custodians submit the security role definitions.
(last updated: 11.25.2019)
New columns to be added:
| Table Name | Column Name | Data Type |
| CM_Programs | CIPCode_title | nvarchar(300) |
| program_dateEndLabel | varchar(25) | |
| CM_Credentials
|
credential_dateEndLabel | varchar(25) |
| CIPCode_title | nvarchar(300) | |
| stemCIP | varchar(10) | |
| alt_thesis_requirement | varchar(100) |
Existing columns to be deleted:
| Table Name | Column Name |
| CM_Programs | Program_Status |
| CM_Credentials | credential_Status |
Please Note: The scope of the reorg may still change. Please check this page frequently to see changes to the scope.