Vermont Data Consortium

 

Local Data Warehouse Documents

To support VDC members in their local data warehouse build process a number of files have been created and are organized under several headings.


Common Data Model (CDM) Mapping and Extract Templates

Name
Format
Comments
Diagram of Expanded CDM Data Model  
Expanded CDM Data Model  
Expanded CDM Data Model PowerPoint  
CDM Mapping Extract Templates  
CDM Mapping Extract Templates Spreadsheet  
Data Export Instructions (Complete CDM)  
Required Objects  
SU Identification Codes  

File Management, FTP and Other Extract Resources

Name
Format
Comments
Local Extract Process Summary  
Data Import Instructions  

Sample Directory Structure with Files (Work with Excel Verification Tool)

 
Automated CDM Extract Template revised 1/2/08
FTP Documentation  
Data Extract Analyzer Tool (Access) V 1.35
Basic DEA (Access) Tool Documentation  
Excel Verification Tool V 1.3 updated 1/2/08

Student Information Systems
Name
Format
Comments
SASIxp Sample Mapping  
MMS Description  
MMS GE Tables  
Mazik Crosswalks  

Current Local Assessments Loaded in Warehouse
Name
Format
Comments
VDC Member Local Assessment Matrix May 21, 2007