270 likes | 399 Views
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
E N D
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 • developed for the storage and maintenance of: • employment statistics • labor market information • economic data • demographic information • occupational information
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
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
Module 1 Workforce Information Database Review Implementation Options • Data warehouse for LMI research shops • Storage container for information delivery systems • A combination of both
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
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
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
Module 1 ALMIS Database Review Module 1 Workforce Information Database Review How is the Workforce Information Database currently being used by customers?
Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Who are they [customers]? What do they want? How do they want it?
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
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.
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.
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...
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
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)
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)
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.
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
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?
Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Who identifies the core tables required by ETA?
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
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
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)
Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Project Updates
Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Employer Database WID XML Definitions National Crosswalk Service Center Education & Support
Module 1 ALMIS Database Review Module 1 Workforce Information Database Review Questions? Comments? Musings?