|
|
|
 |
| Data Submittal Schedule |
|
The following schedule displays the quarterly due dates for agency data submission and the report publication dates. Data submitted after the due date will be loaded and published in the next quarter.
Data Submission Due Dates Report Publication Dates
September 15, 2008 (outcomes through March 31, 2008) October 8, 2008
December 15, 2008 (outcomes through June 30, 2008) January 7, 2009
March 14, 2008 (outcomes through Sept. 30, 2008) April 8, 2009
June 15, 2009 (outcomes through Dec. 31, 2008) July 8, 2009
|
|
|
| Episodes |
|
An episode is the basic building block in PRISM. An episode is the period between the first service date and the date of service completion, determined by the partner agency.
View the PRISM powerpoint on episode.
Episode (ppt, 217 KB)
The number of new intake records transmitted to PRISM each quarter.
Episode Count Report (pdf, 30 KB)
|
|
|
| Data Dictionary |
|
The PRISM reference manual.
Cover: PRISM Logo (pdf, 452 KB)
Section 0: Table of Contents (pdf, 34 KB)
Section 1: Data Diagram (pdf, 123 KB)
Section 2: Data Matrix (pdf, 79 KB)
Section 3: Data Elements Definitions (pdf, 1,605 KB)
Section 4: External Data File Definitions (pdf, 140 KB)
Section 5: Database Table Descriptions (pdf, 2,143 KB)
Section 6: Database Local View Definitions (pdf, 129 KB)
Section 7: Glossary of Terms (pdf, 22 KB)
Section 8: Employment Services - Addendum (pdf, 402 KB)
|
|
|
| Desk Manual |
|
Desk Manual - A step-by-step reference guide for partner agency staff with access to the PRISM database. (pdf, 2,150 KB)
|
|
|
| Documentation |
|
System Accessibility - A one page diagram showing system accessibility of the PRISM system. (pdf, 59 KB)
Data Model - A two-page flow chart showing PRISM data collection, validation, and processing. (pdf, 311 KB)
Data Submittal Flow - This one-page document shows the flow of data from receipt of the data into PRISM through the validation process. (pdf, 42 KB)
Standard Report Calculation Programming - A two-page narrative on the data processing behind the quarterly performance standard reports. (pdf, 12 KB)
Entity Relationship - For the analyst this PRISM data model displays the relationships for the Subject, Episode, Services, Goals, Pre-Post Standard Calc, and the Post Outcome Perf Rpts Tables. (pdf, 33 KB)
Enhancements to PRISM - Correspondence sent Oct. 12, 2006, to the partners detailing enhancements made to the transmittal_trans.dat file format, suspension correction process and the version control on the PRISM reports.
SSN Updates/Changes Processing (pdf, 11 KB)
Attachment A (pdf, 12 KB)
Attachment B (pdf, 12 KB)
Recommendations for changes to CIP table - Correspondence sent Oct. 30, 2006, to the partners with four recommendations and results for possible changes to the CIP table. (pdf, 12 KB)
Ethnic Data - Beginning September 2005, partner agencies began submitting ethnic and race under the 1997 OMB Directive to PRISM. (pdf, 12 KB)
Process to transition to new ethnic coding structure - Correspondence sent to the partners June 6, 2005 detailing the three phases of transition to the ethnic coding structure based on the OMB revisions to the Standards for the Classification of Federal Data on Race and Ethnicity. (pdf, 22 KB)
Suspense Correction Application - Correspondence sent to PRISM Data Elements Committee members requesting the partners use the Suspense Correction Application tool to correct suspended records. (pdf, 11 KB)
Modification to PRISM reports - Correspondence sent Feb. 8, 2007, notifying the partners the files to produce PRISM reports are no longer valid and require updating. This correspondence is a step-by-step process for the partners to update their files on their computers. (pdf, 11 KB)
2007 NAICS codes - A list of the latest version of codes and definitions for the North American Industrial Classification System.
|
|
|
| Helpful Hints |
|
The hints are a step by step process to help partner agency staff setup queries for data extraction and reporting.
Helpful Hint by Topic
|
Placement
|
Retention
|
Wage Gain
|
Services
|
Other
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Helpful Hint by number with description
Helpful Hint 01 - Count of Total Exited and Total Employed by Workforce Area using SQL*Plus. (pdf, 588 KB)
Helpful Hint 02 - Count of Total Exited, Total Employed, and Placement Rate by Workforce Area using Microsoft Access. (pdf, 306 KB)
Helpful Hint 03 - Count of participants with 0 - 30 days of service by the number of days of service using Microsoft Access. (pdf, 258 KB)
Helpful Hint 04 - Count of Total Exited by Workforce Area using Oracle Discover. (pdf, 1,816 KB)
Helpful Hint 05 - Average hourly wage by year/quarter by last grade using Oracle Discover. (pdf, 1,023 KB)
Helpful Hint 06 - Count of Total Exited and Placed, Total Retained and Retention Rate by Industry using Microsoft Access. (pdf, 755 KB)
Helpful Hint 07 - Subject ID grand totals by row (workforce regions) and column (exit quarter from 1Q2003 - 4Q2004). (pdf, 791 KB)
Helpful Hint 08 - Use SQL*Plus to produce a duplicated and unduplicated count of services for a time period of July 1, 2002 through June 30, 2003. (pdf, 979 KB)
Helpful Hint 09 - A step-by-step process to display Average Hourly Wage by workforce region for a single industry - services - using Oracle Discoverer. (pdf, 986 KB)
Helpful Hint 10 - Step-by-step process to display the retention rate by county for individuals with a high school education or less, exiting services in 1Q 2003 using Oracle Discoverer. (pdf, 1,794 KB)
Helpful Hint 11 - Step-by-step process to display Wage Gain by County and by Industry for 2Q 2002 using Oracle Discoverer. (pdf, 1,078 KB)
Helpful Hint 12 - Combines Oracle Discoverer queries to calculate retention rate by county and Excel charting to compare counties or exit date performance. (pdf, 696 KB)
Helpful Hint 13 - Summarizes the selection criteria for the three performance measures. Replicate the PRISM Standard Performance Reports for placement, retention and wage gain. (pdf, 17 KB)
Helpful Hint 14 - Creates the Placement Performance Measure using Oracle Discoverer. Report options include variations on ethnicity. (pdf,167 KB)
Helpful Hint 15 - This Oracle Discoverer exercise computes retention numerator and denominator by standard age groups. (pdf, 366 KB)
Helpful Hint 16 - Run standard reports using the Oracle Run Time. (pdf, 81 KB)
Helpful Hint #17 - Calculate the retention rate by county by ethnic group using Microsoft Access. (pdf, 117 KB). This exercise requires importing this ethnic code Excel file as an Access table.(xls, 25 KB)
Helpful Hint 18 - Ever wonder what the placement rate is for individuals who have at least a high school education and are multiple race (not Hispanic)? This helpful hint, (pdf, 196KB) using Microsoft Access, provides a step-by-step process to display the placement rate by education level for individuals with a minimum of a high school education. This exercise requires importing this ethnic code Excel file as an Access table.(xls, 25 KB)
Helpful Hint 19 - This exercise, (pdf, 256KB), show a step-by-step approach to develop a report, using Microsoft Access, which displays the wage gain for Blacks, not Hispanic, by gender for each region.(pdf, 22KB)
Helpful Hint 20 - Calculate the placement rate for clients of DHS: Children, Adults, and Families within a given time period. This document, (pdf, 278KB), uses Black (not Hispanic) clients as an example.
Helpful Hint 21 - Calculate the wage gain by region and gender, for workers in the accommodation and food services industry . This document, (pdf, 419KB), shows the data for October 1, 2005 through December 31, 2005.
Helpful Hint 22 - Retention rates vary considerably by industry and by region. This helpful hint (pdf, 282) uses Microsoft Access to develop a report showing the retention rates by industry by region. (pdf, 84 KB)
Helpful Hint 23 - Calculate the retention rate for individuals working at temporary help agencies. This helpful hint (pdf, 429 KB) uses Microsoft Access to develop a report showing the retention rate by workforce region.
Helpful Hint 24 - Calculate average wage gain for individuals working at temporary help agencies. This helpful hint (pdf, 453 KB) uses Microsoft Access to develop a report showing average wage gain by workforce region.
|
|
| |
|
|
