non-standard tables

Boise, Idaho May 11-14, 2010

Applied Database Management & Information Delivery

Non-Standard Tables

Steve RosenowNational Crosswalk Service Center


Applied Database Management & Information DeliveryNon-Standard Tables

Civilizations in decline are consistently characterized by a tendency towards standardization and uniformity.

Arnold Toynbee



Session Objectives1. Answer: “Why have this page/collection of tables?”2. Define the types of files found there3. Introduce you to the current collection of non-standard tables4. Share our hopes and plans for this resource

Jackalope – Non-standard animal


WID Non-Standard Tables History Lesson

•ALMIS/WID Database is constantly evolving:•Versions 1.0, 1.1, 2.0, 2.1, 2.2, 2.3, 2.4

• Changes have several origins:•New data•Coding changes•State DBA input

•Non-Standard tables page added in June, 2003•Data to be used with the WID•Prototype tables for testing for future versions




Path to NCSC’s WID Non-Standard tables page

NCSC Home Page: http://www.xwalkcenter.org


Applied Database Management & Information DeliveryApplied Database Management & Information DeliveryNon-Standard Tables

Path to NCSC’s WID Non-Standard tables page – step 2



NCSC’s WID Non-Standard tables page


External databases (designed to be used with the ALMIS Database)

Supplemental files – go beyond content of structure document

Tables for future versions


NCSC’s WID Non-Standard tables page table categories


:•Minimal O*NET content in the WID•Content kept separate

• Choice of multiple O*NET versions• Some O*NET content updated regularly, some not• O*NET updates completely independent of WID versions

•Non-standard tables page can have up to three versions:• Version 4.0 – Pre-data collection• Production Version (October)• Development Release (June)


NCSC’s WID O*NET databases


NCSC O*NET Database Directory•Links to databases for all

Versions (98 through 14.0)•Includes link to development

release (when available)Links to supplemental and crosswalk files


NCSC’s O*NET Database Directory


WID Non-Standard Tables Tables for future versions

Data structure or coding don’t fit current versionEmployment projections, 2008-19Employer database

Prototype tablesDemographicsCareer clusters and pathways



Tables for future versions:•Employer Database (May 2009 contract)•National Employment Projections•Population Demographics•Career Clusters and Pathways•Job Benefit Surveys•Special Identifier Employment Table•Employment Initiative Tracking Tables




Data Table Creation: Questions to consider

Any “standard” data table elements?Descriptive variablesKeys:

PrimaryForeign

New or existing lookup tables


WID Licensing Tables – process for ACINet

a) States send licensing tables (LICENSE, LICAUTH, LICXONET) to the NCSC (Workforce Information Grants require updates once every two years)

b) The NCSC checks for internal consistency and compatibility with ACINet application

c) The NCSC and the state work out solutions to any issues identified.

d) Quarterly updates are sent to ACINet



WID Licensing Tables – NCSC Services to States

• Version Conversion – ACINet uses structure based on Version 2.3-2.4 of the ALMIS Database• Uses license-occupation crosswalk file• LICXONET – similar to WID LICXOCC• Utilizes O*NET-SOC 2009 Occupations

• Licensing-occupation crosswalk enhancement – possibility of multiple occupations per license



WID Licensing Tables – Internet Resources




Session Objectives Review1. Answer: “Why have this page/collection of tables?”2. Define the types of files found there3. Introduce you to the current collection of non-standard tables4. Share our hopes and plans for this resource

4. Share our hopes and plans…•DBA surveys reveal state DBAs’ imagination and innovation•Tables added by DBAs, frequently because of customer requests•Share those structures on the Non-Standard Tables page


Contact us•Mail:

National Crosswalk Service CenterDepartment of Education400 East 14th StreetDes Moines, IA 50319

•Telephone:515-242-5034

•E-mail:[email protected]

•Home Page:http://www.xwalkcenter.org


non-standard tables

Documents

wid nonstandard tables

widprototype tables

pagecollection of tables

wid licensing tables

licensing tables license

net content

net versionssome o

net database directorylinks