Transcript 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
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
Module 1
Workforce Information Database Review
WID Architecture
QCEW
CES
LAUS
OES
Web-based
Applications
Staging
Area
•Extraction
•Transformation
Census
WID
Client/server
Applications
•Loading
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
Workforce
Information
ReviewDatabase Review
Implications of Alternative
Implementations
• Flexibility (display, storage, analysis)
• Maintenance (ease, speed, cost)
• Operational Speed
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase Review
How is the Workforce
Information Database
currently being
used by
customers?
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase Review
Who are they [customers]?
What do they want?
How do they want it?
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase Review
How is the WID initiated in the
states through ALMIS?
A deliverable in the ETA 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase Review
ETA One-Stop Grant Requirements
Core Look-Up Tables:
(refer to handout)
addresty
annslflg
areatype
benmark
cescode
creditcd
empszflg
empszrng
geocode
geog
growcode
incomtyp
incsourc
inddir
indsub
indtypes
leveltyp
licnumty
locstat
occdir
occsub
occtypes
ownership
period
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase Review
ETA One-Stop Grant Requirements
Core Look-Up Tables,
continued:
(refer to handout)
periodid
periodty
popsourc
prpbstat
ratetype
stattype
stfipstb
urltopic
webflag
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase Review
Who identifies the core tables
required by ETA?
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase Review
ARC is responsible for the
WID structure:
– Development
– Update
– Maintenance
Members include:
15 States (shown in red)
ETA
NCSC
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase 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
Workforce
Information
ReviewDatabase Review
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase Review
Employer
Database
WID
National Crosswalk
Service Center
XML
Definitions
Education &
Support
Module 1
ALMIS Database
Workforce
Information
ReviewDatabase Review
Questions?
Comments?
Musings?