1 / 27

Module 1 ********* Brief Review of the Workforce Information Database

Module 1 ********* Brief Review of the Workforce Information Database. Workforce Information Database Training Revised May 2007. Module 1 Workforce Information Database Review. What is the Workforce Information Database? a normalized, relational database structure

patty
Download Presentation

Module 1 ********* Brief Review of the Workforce Information Database

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. Module 1 ********* Brief Review of the Workforce Information Database Workforce Information Database Training Revised May 2007

  2. Module 1 Workforce Information Database Review • What is the Workforce • Information Database? • a normalized, relational database structure • developed for the storage and maintenance of: • employment statistics • labor market information • economic data • demographic information • occupational information

  3. Module 1 Workforce Information Database Review Workforce Information Database Advantages • Provides a “common structure” • Allows consistent data to be accessed quickly & efficiently • Results in cost-savings to the entire workforce information system • Unlimited opportunities for meaningful, customized, local information

  4. Staging Area Module 1 Workforce Information Database Review WID Architecture QCEW CES Web-based Applications WID LAUS Decision Support Systems Operational Systems & External Data Sources OES Client/server Applications • Extraction • Transformation • Loading Census Others In-House Query & Reporting Tools

  5. Module 1 Workforce Information Database Review Implementation Options • Data warehouse for LMI research shops • Storage container for information delivery systems • A combination of both

  6. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Implications of Alternative Implementations • Flexibility (display, storage, analysis) • Maintenance (ease, speed, cost) • Operational Speed

  7. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review What relational database software is being used to house the WID? • SQL Server (48%) • Oracle (28%) • Other Relational Databases (24%): • MS Access • MS Visual FoxPro

  8. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review How can the information in the WID be accessed/ extracted/queried? • Directly through the relational database software housing the WID • ODBC using another relational database software • Through Custom Graphical User Interfaces (GUI) (Client/Server Application) • Internet

  9. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review How is the Workforce Information Database currently being used by customers?

  10. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Who are they [customers]? What do they want? How do they want it?

  11. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review LMI Applications currently employing the Workforce Information Database Structure • ACINet (America’s Career InfoNet) • Vendor-Provided Systems • State LMI customized applications

  12. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Relationship Between the WID and Applications • The WID is a generic data container that can feed a variety of applications for different customers and purposes. • The WID is NOT SYNONYMOUS with the applications that it feeds.

  13. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Relationship Between the WID and Applications (cont.) • Different applications produced by the same or different vendors can access the same WID. • Applications may require “optional or additional” tables.

  14. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review How is the WID initiated in the states through ALMIS? A deliverable in theETA Workforce Information Grant When? Grant period is July 1 to June 30 (sort of) What are the deliverables? Glad you asked...

  15. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review ETA One-Stop Grant Requirements (if using v. 2.2) Core Data Tables: ces licauth** empdb license** income occprj* indprj* oeswage* industry populatn iomatrix* labforce *DBA may opt to populate one or both **Required to be sent to NCSC

  16. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review ETA One-Stop Grant Requirements Core Look-Up Tables: addresty incsourc annslflg inddir areatype indsub benmark indtypes cescode leveltyp creditcd licnumty empszflg locstat empszrng occdir geocode occsub geog occtypes growcode ownership incomtyp period (refer to handout)

  17. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review ETA One-Stop Grant Requirements Core Look-Up Tables, continued: periodid periodty popsourc prpbstat ratetype stattype stfipstb urltopic webflag (refer to handout)

  18. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review ETA One-Stop Grant Requirements Core Crosswalk Tables: licxocc** matxnaic matxsoc Core Administrative Tables: indcodes*** occcodes*** **Required to be sent to NCSC ***Need to populate additional lookup tables.

  19. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review • Minimum Requirements • for Population of the • WID Core Tables • Statewide data • Time series should have the most recent 2 years • Both seasonally and not seasonally adjusted • All time periods as available • Occupational projections at BLS collapsed level • Send license and licauth to NCSC for inclusion in ACINet • CES must have MSA data

  20. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review • What is not specified in the • ETA One-Stop Grant: • Which columns in each core table are required to be populated? • Which version of the WID must be populated? • Deliverable deadlines? • Is national data required?

  21. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Who identifies the core tables required by ETA?

  22. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review • ARC is responsible for the • WID structure: • Development • Update • Maintenance Members include: 15 States (shown in red) ETA NCSC

  23. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review ARC Responsibilities: • Provision of technical support, training, education, and communication • Review of potential structure changes • and release of structure updates • Coordination and collaboration with other groups working on related projects • Identification of ETA core data elements

  24. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Questions and suggestions for ARC may be submitted to: http://www.workforceinfodb.org/9helpdesk.cfm Or (Go to – www.workforceinfodb.org, Click on Helpdesk)

  25. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Project Updates

  26. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Employer Database WID XML Definitions National Crosswalk Service Center Education & Support

  27. Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Questions? Comments? Musings?

More Related