An official website of the State of Oregon
How you know »
(how to identify a Oregon.gov website)
An official website of the State of Oregon »
Integrated Client Services (ICS) supports a group of researchers and forecasters in the Office of Forecasting, Research and Analysis (OFRA). ICS also maintains a Master Client Index (MCI) of individuals spanning across most all ODHS and OHA programs a swell as a few Oregon agencies. This allows ICS to create bespoke, integrated datasets used for research and program improvement projects around the state.
Oregon agencies collect and store data about the people they serve using systems and platforms that do not interact with one another. In 2005, in response to the need to integrate agency data, Oregon established the ICS data warehouse.
ICS is a small unit within OFRA and is a shared services between ODHS and OHA. Our primary task is to connect individuals across multiple state agencies and programs. This individual-level link allows us to support forecasters and researchers who forecast ODHS and OHA caseloads used for program budgeting and to support statewide needs for integrated datasets for ongoing research projects, program improvements and data requests requiring integrated data.
ICS is often requested to create custom datasets used for research and across Oregon agencies. During our monthly ETL process, ICS receives data elements necessary for linking individuals across systems (i.e., name, DOB, gender, race, ethnicity, etc.) while the majority of source-level attribute data about individuals (i.e., services received, diagnoses, test scores, offenses, etc.) remain with the agency and program data owners. The process to request a custom, integrated dataset generally follows this process:
Data use requests
A match usually begins with a researcher needing to connect additional information to a universe of individuals.
ICS brings data in monthly from most ODHS and OHA programs and several other state agencies (see ICS Key Partners). We extract, transform and load (ETL) data elements needed to identify and link an individual across systems (i.e., name, demographics, etc.) and limited service-level data from ODHS and OHA programs. This data is processed into caseloads where changes over time are forecast and used in calculations to create program budgets.
During the monthly client match, ICS uses a rigorous combination of probabilistic, deterministic and manual matching to create and maintain the best possible individual-level link across agencies and programs. Each individual in ICS receives a unique Master Identification number that allows identification of an individual across data sources. ICS maintains a master crosswalk of all key partners and provides the state with a better view of individuals utilizing services across state agencies.
ICS provides ad hoc record linkage (aka matching, fuzzy matching or probabilistic matching) between person records when unique identifiers are not available. Names and dates of birth are not unique but can be used to link records of the same person between data systems or data files. Record linkage of administrative data is rarely 100% accurate but some data practices can increase both the accuracy and completeness of record linkage. Where possible ICS will report record linkage metrics (e.g., precision, recall, F-score) that can assist researches in assessing whether a record linkage project is of sufficient accuracy to support research needs. Researchers should recognize that high rates of false matches or missed matches (incomplete linkage) can result in incorrect or biased conclusions. Researches should also be aware of their responsibility to correctly interpret potential effects of inadequate or incorrect record linkage.
Minimal fields for record linkage:
Unique persons should be de-duplicated in program records. If programs are unable to deduplicate records, notify ICS.
Additional fields may increase the match rate including SSN, county of residence, zip code, race and ethnicity. Consult with ICS to determine whether program-specific fields may increase match rates. Record linkage projects will ideally include additional fields in order to improve linkage accuracy - particularly when a large number of records require linkage.
Issues to consider when determining whether to match to data sources or an external data source to ICS:
ICS was established in 2005 to support data integration across ODHS and OHA programs. ICS has since grown to support integrated data efforts with other agencies including Oregon Department of Education and the Department of Correction. ICS data is used by state agencies and other institutions for research and analysis.
ICS shares both identified and deidentified data which requires data governance policies and procedures and legal agreements for the protection of personally identifiable or sensitive data. The primary ICS governance structure was established in an MOU between ODHS and OHA. The MOU allows ICS to receive necessary program data to support statistical forecasting and to maintain and agency-wide client index. Additional agreements are also maintained between entities outside of ODHS and OHA that share data with ICS.
A governance committee with members representing the various data sources determines overall ICS data use and use of their own agency or program data.
ICS convenes special data use committees when requests to create integrated data products are received. Requests must include a complete DUA and must be approved by all committee members.
Learn more about ICS governance.
Our Data Project and Research Use Case Inventory includes research data requests, multiyear data projects, multiyear research data requests and ad hoc requests.
Note: the inventory is updated annually and is not an exhaustive list of all requests ICS has processed.
A .gov website belongs to an official government organization in the United States.
A lock icon ( ) or https:// means you’ve safely connected to the .gov website.
Only share sensitive information on official, secure websites.
Your browser is out-of-date! It has known security flaws and may not display all features of this and other websites. Learn how