slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Module 1 ********* Brief Review of the Workforce Information Database PowerPoint Presentation
Download Presentation
Module 1 ********* Brief Review of the Workforce Information Database

Loading in 2 Seconds...

play fullscreen
1 / 27

Module 1 ********* Brief Review of the Workforce Information Database - PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Module 1 ********* Brief Review of the Workforce Information Database' - patty


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Module 1

*********

Brief Review of the Workforce Information Database

Workforce Information Database Training

Revised May 2007

slide2

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
slide3

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
slide4

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

slide5

Module 1

Workforce Information Database Review

Implementation Options

  • Data warehouse for LMI research shops
  • Storage container for information delivery systems
  • A combination of both
slide6

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
slide7

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
slide8

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
slide9

Module 1

ALMIS Database Review

Module 1

Workforce Information Database Review

How is the Workforce

Information Database

currently being

used by

customers?

slide10

Module 1

ALMIS Database Review

Module 1

Workforce Information Database Review

Who are they [customers]?

What do they want?

How do they want it?

slide11

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
slide12

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.
slide13

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.
slide14

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...

slide15

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

slide16

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)

slide17

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)

slide18

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.

slide19

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
slide20

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?
slide21

Module 1

ALMIS Database Review

Module 1

Workforce Information Database Review

Who identifies the core tables

required by ETA?

slide22

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

slide23

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
slide24

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)

slide25

Module 1

ALMIS Database Review

Module 1

Workforce Information Database Review

Project Updates

slide26

Module 1

ALMIS Database Review

Module 1

Workforce Information Database Review

Employer

Database

WID

XML

Definitions

National Crosswalk

Service Center

Education &

Support

slide27

Module 1

ALMIS Database Review

Module 1

Workforce Information Database Review

Questions?

Comments?

Musings?