1 / 18

Non-Standard Tables

Applied Database Management & Information Delivery. Non-Standard Tables. Steve Rosenow National Crosswalk Service Center. Boise, Idaho May 11-14, 2010. Applied Database Management & Information Delivery Non-Standard Tables.

kyros
Download Presentation

Non-Standard Tables

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Applied Database Management & Information Delivery Non-Standard Tables Steve Rosenow National Crosswalk Service Center Boise, Idaho May 11-14, 2010

  2. Applied Database Management & Information Delivery Non-Standard Tables Civilizations in decline are consistently characterized by a tendency towards standardization and uniformity. Arnold Toynbee Boise, Idaho May 11-14, 2010

  3. Applied Database Management & Information Delivery Non-Standard Tables Session Objectives Answer: “Why have this page/collection of tables?” Define the types of files found there Introduce you to the current collection of non-standard tables Share our hopes and plans for this resource Bonus Slide Jackalope – Non-standard animal Boise, Idaho May 11-14, 2010

  4. Applied Database Management & Information Delivery Non-Standard Tables 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 Boise, Idaho May 11-14, 2010

  5. Applied Database Management & Information Delivery Non-Standard Tables Path to NCSC’s WID Non-Standard tables page NCSC Home Page: http://www.xwalkcenter.org Boise, Idaho May 11-14, 2010

  6. Applied Database Management & Information Delivery Applied Database Management & Information Delivery Non-Standard Tables Path to NCSC’s WID Non-Standard tables page – step 2 Boise, Idaho May 11-14, 2010

  7. Applied Database Management & Information Delivery Non-Standard Tables NCSC’s WID Non-Standard tables page Boise, Idaho May 11-14, 2010

  8. Applied Database Management & Information Delivery Non-Standard Tables NCSC’s WID Non-Standard tables page table categories External databases (designed to be used with the ALMIS Database) Supplemental files – go beyond content of structure document Tables for future versions Boise, Idaho May 11-14, 2010

  9. Applied Database Management & Information Delivery Non-Standard Tables NCSC’s WID O*NET databases • : • 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) Boise, Idaho May 11-14, 2010

  10. Applied Database Management & Information Delivery Non-Standard Tables NCSC’s O*NET Database Directory • 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 Boise, Idaho May 11-14, 2010

  11. Applied Database Management & Information Delivery Non-Standard Tables WID Non-Standard Tables • Tables for future versions • Data structure or coding don’t fit current version • Employment projections, 2008-19 • Employer database • Prototype tables • Demographics • Career clusters and pathways Boise, Idaho May 11-14, 2010

  12. Applied Database Management & Information Delivery Non-Standard Tables • 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 Boise, Idaho May 11-14, 2010

  13. Applied Database Management & Information Delivery Non-Standard Tables Data Table Creation: Questions to consider • Any “standard” data table elements? • Descriptive variables • Keys: • Primary • Foreign • New or existing lookup tables Boise, Idaho May 11-14, 2010

  14. Applied Database Management & Information Delivery Non-Standard Tables WID Licensing Tables – process for ACINet • States send licensing tables (LICENSE, LICAUTH, LICXONET) to the NCSC (Workforce Information Grants require updates once every two years) • The NCSC checks for internal consistency and compatibility with ACINet application • The NCSC and the state work out solutions to any issues identified. • Quarterly updates are sent to ACINet Boise, Idaho May 11-14, 2010

  15. Applied Database Management & Information Delivery Non-Standard Tables 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 Boise, Idaho May 11-14, 2010

  16. Applied Database Management & Information Delivery Non-Standard Tables WID Licensing Tables – Internet Resources Boise, Idaho May 11-14, 2010

  17. Applied Database Management & Information Delivery Non-Standard Tables Session Objectives Review Answer: “Why have this page/collection of tables?” Define the types of files found there Introduce you to the current collection of non-standard tables Share our hopes and plans for this resource • 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 Boise, Idaho May 11-14, 2010

  18. Applied Database Management & Information Delivery Non-Standard Tables • Contact us • Mail: • National Crosswalk Service Center • Department of Education • 400 East 14th Street • Des Moines, IA 50319 • Telephone: • 515-242-5034 • E-mail: • ncsc@iowa.gov • Home Page: • http://www.xwalkcenter.org Boise, Idaho May 11-14, 2010

More Related