Text Size:   A+ A- A   •   Text Only
Site Image

Technical Information

Data Submission 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 Publication Dates
October 14 2016 (outcomes through March 31, 2016) ​Nov. 9, 2016
January 13, 2017 (outcomes through June 30, 2016) Feb. 8, 2017
April 15, 2017 (outcomes through Sept. 30, 2016) ​May 10, 2017
After 15 years of quarterly reports published for five measures, May 10, 2017 will mark the end of an era. PRISM reports will be published for the last time. The published reports will remain available for viewing on the website until further notice. PRISM staff invite you to visit www.qualityinfo.org/pm, the site for PRISM's new flexible reporting tool, to view the performance reports for the WIOA measures and four Oregon measures. to view the performance reports for the WIOA measures and four Oregon measures.


Back to Top


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) 

Back to Top

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, 95 KB)
Section 3:
Section 4: 
Section 5:  Database Tables  (pdf, 727 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) 

Back to Top

Desk Manual

Desk Manual  - A step-by-step reference guide for partner agency staff with access to the PRISM database. (pdf, 2,150 KB)

Back to Top


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. 
Change to CIP Code Table - Correspondence sent November 17, 2008 to PRISM Data Elements Committee members notifying the partners beginning November 21, 2008, the CIP Code field will no longer be validated against the CIP Code table. (pdf, 7 KB)

Veteran Status - Correspondence sent December 11, 2012 notifying the PRISM partners veterans status will be posted on PRISM reports beginning February 2013. The partners were asked to begin submitting veterans status currently coded '0' (missing) to '9' (unknown) after December 17, 2012. (pdf, 9 KB)

Partner Communication Veteran Counts - Notice distributed to staff January 29, 2013 with access to PRISM reports and contains action steps required before February 15, 2013. (pdf, 54 KB)


Back to Top

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

 Wage Gain
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 Employment 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 Employed, 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 Employment 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 employment 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 employment 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 employment 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.
Helpful Hint 25 - Create queries and a report that lists the average number of days of Level I services received, by client education level (pdf, 700 KB).
Helpful Hint 26 - Create queries and a report that lists the number of Level I services received by
Hispanic clients, by education level (pdf, 472 KB). 
Helpful Hint 27 - Create queries and a report that describes quarterly change in average wage gain, by region (pdf, 309 KB).
Helpful Hint 28 - Create queries and a graph that depicts quarterly change in total clients placed in an industry, along with their average employment wage. (pdf, 288 KB).
Helpful Hint 29 - Use SQL*Plus to create a count of service goals for clients, by their education level. (pdf, 58 KB).
Helpful Hint 30 - Create a query that calculates: average wage at employment; average wage at 5th quarter of employnent; and wage gain. (pdf, 142 KB).
Helpful Hint 31 - Create a query which calculates: average wage at employment; average wage at 5th quarter of employment; for the period of 2007 Q3 through 2008 Q2. The variables for this query include: age, an education level of high school or less, and type of service received (pdf, 85 KB).
Helpful Hint 32 - How to create queries that compare the employment rate for those who recieved services in the 200 series (Support Services), against those who did not, between July 1, 2008 and June 30, 2009. Includes a report with results by workforce region.  (pdf, 131 KB). 

Back to Top