Exhibit E Master Data Inventory.xlsx
XLSX spreadsheet 161 KB Posted
- Attached to
- Data Validation for CHSD
- Solicitation number
- RFP FAAA 2027000072 2
- Issued by
- Denver County, Denver City, Colorado
About this file
This file is a Master Data Inventory Template developed by the State of Colorado's Office of Information Technology (OIT) in collaboration with data integration teams and referencing efforts from multiple states including Maryland, California, Connecticut, and Utah. The template serves as a standardized framework for state agencies to document and manage their datasets across various systems and platforms.
The template provides comprehensive guidance for agencies to catalog their data assets by identifying key attributes including data stewards, custodians, dataset titles, source systems, hosting locations, data classifications, and sensitivity designations. It includes dropdown menus and predefined categories covering data types (flat files, relational databases, non-relational data, GIS data, and paper records), hosting platforms (Google Cloud, AWS, Azure, Salesforce, physical premises), business importance levels (critical, primary, secondary, minimal), and data sources (transactional vendor data, customer entries, social media, emails, forms, and automated systems). The template also addresses data governance by requiring documentation of data transformation processes, authoritative source identification, normalization needs, and compliance with various regulatory frameworks including PII, PCI, FERPA, HIPAA, CJIS, and FTI protections. The document includes extensive lists of Colorado state agency personnel designated as data owners, stewards, custodians, and technical leads across multiple departments, reflecting a coordinated statewide data management initiative. This inventory template directly supports the Data Validation for CHSD contract opportunity by establishing standardized data documentation protocols that enable effective data validation, quality assurance, and interagency data sharing across Colorado's state government.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 4 - System Security Plan 2.5.5 Template.docx | DOCX document | |
| Attachment 1 - Request for Proposal Signature Page.docx | DOCX document | |
| Attachment 3 - RFP Proposer Response Template.docx | DOCX document | |
| Addendum 1, Questions and Answers.pdf | ||
| Exhibit A - Submission Instructions.docx | DOCX document | |
| Exhibit D CDPHE Data Management Plan.pdf | ||
| Revised Attachment 4 - System Security Plan 2.5.5 Template.docx | DOCX document | |
| Revised Attachment 1 - Request for Proposal Signature Page.docx | DOCX document | |
| Attachment 5 - Data Use Agreement Template.pdf | ||
| Attachment 2, Budget Template.docx | DOCX document | |
| Exhibit C - Information-Technology-Contract_05.2026.pdf | ||
| RFP 2027000072 Data Validation for CHSD Final.pdf | ||
| Revised Attachment 3 - RFP Proposer Response Template.docx | DOCX document | |
| Exhibit B Draft Statement of Work-final.docx | DOCX document |
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
TemplateFields
| Colorado Draft Data Inventory Template Fields |
| These fields were compiled referencing efforts in Colorado, Maryland, California, Connecticut & Utah as well as recommendations from the Colorado OIT data integration team. |
| How to use: Hover over field for definition. Dropdowns indictated in light blue shading. |
| State Agency (prepopulated) |
| Data Owner, if not State Agency |
| Division/Office/Section/Unit (Dropdown specific to agency) |
| Data Steward (Business knowledge) - Name |
: Who manages the data and is responsible for making changes to the data? Who understands what the dataset includes and can answer questions about it?
Data Custodian (Technical knowledge) - Name : If applicable, include a contact who manages the technical execution of the database (e.g. database management, access and extraction).
| Dataset Title or Name |
| Dataset short description |
: Describe what a single row in the data represents, as simply as possible What system does the data live in? (prepopulated by OIT) : If dataset lives in more than one system, use a separate row for each system.
| If "EXTERNAL WEBSITE" please list |
| If "OTHER" please list |
| Type of source system or file format (Dropdown) |
| Flat file (e.g., CSV, spreadsheet) |
| Relational data (e.g., Oracle, SQL Server, Postgres) |
| Non-relational data ( key/value, DynamoDB, S3, Elasticsearch) |
| GIS data (location-based) |
| Paper |
| Hosted location (Dropdown) |
| Google Cloud (GCP) |
| Amazon Web Services (AWS) |
| Azure Cloud |
| Cloud File Storage (Google Drive, Dropbox, etc.) |
| Salesforce |
| On Physical Premise |
| Other |
| What level of importance does this data have to your business functions? (Dropdown) |
| Critical |
| Primary |
| Secondary |
| Minimal |
| How often is this data requested by other divisions/agencies, etc.? (Dropdown) |
| Daily |
| Weekly |
| Monthly |
| Quarterly |
| Yearly |
| Never |
| What populates the data? (Dropdown) |
| Transactional data from vendors/3rd parties |
| Customer data entry on agency website |
| Social Media |
| Incoming emails and messages |
| Client facing forms |
| Interpreted images of paper documents |
| Another state-owned system |
| Data found on the Web |
| Public APIs |
| Streaming data (continuous flows) |
| Operations data (budget, accounting, HR etc...) |
| Web Form or Survey responses |
| Staff entered |
| Bot , AI or Automated entry |
| Other |
| Unknown |
| When data is received from another system or database, is it transformed/mapped before storage or use? (Yes/No) |
| Do you think this is the authoritative source of this data at your agency? (Yes/No) |
| Do you think this is the authoritative source of this data at the State? (Yes/No) |
| Does the data need normalizing before using? (Yes/No) |
| Data Classification (Dropdown) |
: How would you classify this data?
PUBLIC - this data could be publicly disseminated without any concerns;
PROTECTED - this data is protected by law or regulation and can only be shared or accessed internally and per organizational procedures; OR this information includes individually identified information;
| Publicly Accessible |
| Publicly Requestable |
| Internal use only |
| Protected, releasable with restrictions |
| Protected, never released |
| Sensitive |
| Unknown |
| Personally Identifiable (PII) Data (Yes/No) |
| Payment Card Industry (PCI) Data (Yes/No) |
| FERPA Data (Yes/No) |
| Homeland Security Data (Yes/No) |
| Contractually Protected Data (Yes/No) |
| PHI (Yes/No) |
| Criminal Justice Information Services (CJIS) Data (Yes/No) |
| Federal Tax Information (FTI) Data (Yes/No) |
| Legislatively Protected/Restricted (Yes/No) |
| If yes, please cite specific legislation |
| Protected - "Other" |
: If you marked “Other” for Protected Data Classification, please indicate what law(s)/regulation(s) protect this data.
: Who manages the data and is responsible for making changes to the data? Who understands what the dataset includes and can answer questions about it?
: If applicable, include a contact who manages the technical execution of the database (e.g. database management, access and extraction).
: Describe what a single row in the data represents, as simply as possible : If dataset lives in more than one system, use a separate row for each system. Name of Data Sub-Domain (example: member, provider, health, etc...)
Template
| Agency | Data Owner, if not State Agency | ||||||||
| : An individual responsible for definitions, policy, and practice decisions about data within their area of responsibility. For business data, the individual may be called a business owner of the data. | Division/Office/Section/Unit (Dropdown specific to agency) | Data Steward (Business knowledge) - Name | |||||||
| : A business leader and/or subject matter expert designated as accountable for: a) the identification of operational and business intelligence data requirements within an assigned subject area, b) the quality of data names, business definitions, data integrity rules, and domain values within tan assigned subject area c) compliance with regulatory requirements and conformance to internal data policies and data standards, d) application of appropriate security controls, | Data Custodian (Technical knowledge) - Name | ||||||||
| : If applicable, include a contact who manages the technical execution of the database (e.g. database management, access and extraction). | Dataset Title or Name | Dataset short description | |||||||
| : Describe what a single row in the data represents, as simply as possible | What system does the data live in? (prepopulated by OIT) | ||||||||
| : If dataset lives in more than one system, use a separate row for each system. | If "EXTERNAL WEBSITE" please list | If "OTHER" please list | Type of source system or file format | Data Type | Hosted Location | Hosted in Google Cloud (GCP)? | Hosted in Amazon Web Services? (AWS) | Hosted in Azure? | Hosted in Cloud File Storage? |
: Examples of Cloud File Storage include Google Drive, Dropbox, etc.)
: An individual responsible for definitions, policy, and practice decisions about data within their area of responsibility. For business data, the individual may be called a business owner of the data.
: A business leader and/or subject matter expert designated as accountable for: a) the identification of operational and business intelligence data requirements within an assigned subject area, b) the quality of data names, business definitions, data integrity rules, and domain values within tan assigned subject area c) compliance with regulatory requirements and conformance to internal data policies and data standards, d) application of appropriate security controls, : If applicable, include a contact who manages the technical execution of the database (e.g. database management, access and extraction).
: Describe what a single row in the data represents, as simply as possible : If dataset lives in more than one system, use a separate row for each system. Hosted in Salesforce? Hosted on physical premises? Hosted in location other than previously listed locations? If "yes" to other, please list hosted location. What level of importance does this data have to your business functions? How often is this data requested by other divisions/ agencies, etc.? What populates the data? Transactional data from vendors/3rd parties Customer data entry on agency website Social Media Incoming emails and messages Client facing forms Interpreted images of paper documents Another state-owned system Data found on the Web Internal APIs Public APIs Streaming data (continuous flows) Operations data (budget, accounting, HR etc...) Web Form or Survey responses Staff entered Bot , AI or Automated entry Other Unknown When data is received from another system or database, is it transformed/ mapped before storage or use? Do you think this is the authoritative source of this data at your agency? Do you think this is the authoritative source of this data at the State? Does the data need normalizing before using? Data Classification : How would you classify this data?
PUBLIC - this data could be publicly disseminated without any concerns;
| PROTECTED - this data is protected by law or regulation and can only be shared or accessed internally and per organizational procedures; OR this information includes individually identified information; | Personally Identifiable (PII) Data | Payment Card Industry (PCI) Data | FERPA Data | Homeland Security Data | Contractually Protected Data | Protected Health Information (PHI) Data | Criminal Justice Information Services (CJIS) Data | Federal Tax Information (FTI) Data | Legislatively Protected/ Restricted | If yes, please cite specific legislation | Protected - "Other" |
| : If you marked “Other” for Protected Data Classification, please indicate what law(s)/regulation(s) protect this data. | Name of Data Sub-Domain |
: Example: Education, Health, Member, Workforce : How would you classify this data?
PUBLIC - this data could be publicly disseminated without any concerns;
| PROTECTED - this data is protected by law or regulation and can only be shared or accessed internally and per organizational procedures; OR this information includes individually identified information; | Data Retention Requirements | |||||||||||||||||||||||||||||||||||||||||
| Relational data (e.g., Oracle, SQL Server, Postgres) | No | No | No | No | No | Yes | No | Critical | Weekly | No | No | No | No | Yes | Yes | No | No | Yes | No | No | No | No | Yes | No | No | No | Yes | Yes | Yes | Yes | Publicly Accessible | No | No | No | No | No | No | No | No | No | ||
| Relational data (e.g., Oracle, SQL Server, Postgres) | No | No | No | No | No | Yes | No | Critical | Weekly | No | No | No | No | Yes | Yes | No | No | Yes | No | No | No | No | Yes | No | No | No | Yes | Yes | Yes | Yes | Publicly Accessible | No | No | No | No | No | No | No | No | No |
DataValidation
| IT Product Name from TPW | ||||||||||
| : This list updates Dynamically from TPW data - KKIBURZ 07/19/2022 | Product Hosted By | Product Technical Lead | Agency | Division | Type of source system or file format (Dropdown) | Hosted location (Dropdown) | What level of importance does this data have to your business functions? (Dropdown) | How often is this data requested by other divisions/agencies, etc.? (Dropdown) | What populates the data? (Dropdown) | Data Classification (Dropdown) |
: How would you classify this data?
PUBLIC - this data could be publicly disseminated without any concerns;
| PROTECTED - this data is protected by law or regulation and can only be shared or accessed internally and per organizational procedures; OR this information includes individually identified information; | Yes/No | |||||||||||
| CDA | Legislative Affairs Unit | Flat file (e.g., CSV, spreadsheet) | Google Cloud (GCP) | Critical | Daily | Transactional data from vendors/3rd parties | Publicly Accessible | Yes | ||||
| OIT - State Data Center | Shannon Sellers | CDEC | Office of Public Health Practice, Planning & Local Partnerships | Relational data (e.g., Oracle, SQL Server, Postgres) | Amazon Web Services (AWS) | Primary | Weekly | Customer data entry on agency website | Publicly Requestable | No | ||
| Vendor | Shannon Sellers & Vendor | CDHS | Center for Health & Environmental Data | Non-relational data ( key/value, DynamoDB, S3, Elasticsearch) | Azure Cloud | Secondary | Monthly | Social Media | Internal use only | |||
| CSU | Kevin Burg, Dacia Brunker, Vendor | CDLE | Disease Control & Public Health Response | GIS data (location-based) | Cloud File Storage (Google Drive, Dropbox, etc.) | Minimal | Quarterly | Incoming emails and messages | Protected, releasable with restrictions | |||
| OIT - Cloud | Nikki Brinson | CDOT | Health Facilities & Emergency Medical Services | Paper | Salesforce | Yearly | Client facing forms | Protected, never released | ||||
| Isilon | Karl Mauch | CDPHE | Office of Gun Violence Prevention | On Physical Premise | Never | Interpreted images of paper documents | Sensitive | |||||
| N/A | Johannah Baca | CDPS | Office of HIV/STI/HV | Other | Another state-owned system | Unknown | ||||||
| other | Dacia Brunker & Tiffany Brigner (and Jeff Stanley) | DMVA | Prevention Services | Data found on the Web | ||||||||
| DHSEM data center at Mineral Ave | Vendor | DNR | Business Operations | Public APIs | ||||||||
| .... | CSU IT & Vendor | DOC | Financial Services | Streaming data (continuous flows) | ||||||||
| Tirshana Regmi | DOLA | Office of Legal & Regulatory Compliance | Operations data (budget, accounting, HR etc...) | |||||||||
| Nishant Tiwari | DOR | Board of Health | Web Form or Survey responses | |||||||||
| Erik Sells | DORA | Culture, Strategy, Equity & Innovation | Staff entered | |||||||||
| Brent Denny | DPA | Equity, Diversity & Inclusion | Bot , AI or Automated entry | |||||||||
| Prasanna Bennabhaktula | GOV | Office of Human Resources | Other | |||||||||
| Doug Winters | HC | Office of Strategy, Performance & Innovation | Unknown | |||||||||
| Peggy Rogers | HCPF | Office of Health Equity | ||||||||||
| Val Limes | OIT | Environmental Health & Protection (EH&P) | ||||||||||
| Diana Truax | CDHE | Air Pollution Control | ||||||||||
| Carmela Leon | SOS | Environmental Health and Sustainability | ||||||||||
| Joe Huter | Judicial | Hazardous Materials & Waste Management | ||||||||||
| Richard Gonzales | Water Quality Control | |||||||||||
| Marvin Mitchell | ||||||||||||
| Patrick Sheehan | ||||||||||||
| Justin McElroy | ||||||||||||
| Autumn Smith | ||||||||||||
| Marc Workman and Cindy Foreman | ||||||||||||
| Michael Kissinger | ||||||||||||
| Greg Smith | ||||||||||||
| Susan Morse | ||||||||||||
| Agency Managed | ||||||||||||
| Tina McCauley | ||||||||||||
| Donald Hannon | ||||||||||||
| Ryan Mushrush | ||||||||||||
| Michael Anderson | ||||||||||||
| Jianling Hu | ||||||||||||
| Gina Montoya | ||||||||||||
| Nicholas Morgan | ||||||||||||
| Chad Geidel | ||||||||||||
| Chelsea Baldwin/ Darrell Filmore | ||||||||||||
| New person is being hired. | ||||||||||||
| Milo Knezevic | ||||||||||||
| TBD | ||||||||||||
| Arthur Sonka | ||||||||||||
| Marc Workman | ||||||||||||
| Richard Gonzales/ Darrell Filmore | ||||||||||||
| Darrell Filmore | ||||||||||||
| Roger Luchessi | ||||||||||||
| Justin McElroy/ Diana Truax when it moves to Legacy | ||||||||||||
| Elizabeth Hayes | ||||||||||||
| Genie Hurt | ||||||||||||
| N/A | ||||||||||||
| Paul Neumann |
William Moore
| OIT Salesforce Apps Team |
| Vanessa Jozef |
| Greg Ostravich |
William Moore
| Majid Afiri |
| Saeed Mohseni |
| Mohamed.Benjelloun |
| Bill Graefe |
| Jason Augilar |
| Cynthia Schuster |
| OIT Saleforce Apps Team |
| William Moore |
| Ali Farrokhyar |
| Jessica Martinez |
| Gregg Miller |
| Greg Ostravich |
| Rob Bruening |
| Bill Graefe |
Paul Neumann
| Paula Monts |
| Jonathan Esner |
| Felicia Michael |
| Greg Ostravich |
| Craig Fuller |
| David Miller |
| Gary Aucott (CDOT) |
| OIT Apps Team |
| OIT Apps Team |
William Moore
| Paul Bankston | |
| Decomissioned | |
| Kathleen McLaughlin | |
| Don Bailey | |
| Brandon Vaught | |
| Rio Chowdhury | |
| Kristen Campos | |
| Greg Stasinos | |
| Brian Stafford | |
| Andi Hardy | |
| Angelo Fernandez | |
| Greg Quintana | |
| Brandon Warren - OIT | |
| Eugene Aguirre | |
| ECS OIT | |
| Eric Busch | |
| Matt Cramer/Milo | |
| Eric Winkelmann | |
| Matt Cramer | |
| Erick Mattson | |
| Brent Boland | |
| Grahame Dryden | |
| Devon Williford | |
| None | |
| Carla McWilliams | |
| Chennelle Valenzuela | |
| John Arend / Vendor | |
| Peter Davis | |
| Muthukumar (?) | |
| Shannon Matzinger | |
| Vincent Kumagai | |
| Dan Hudson | |
| Kourosh Alizadeh | |
| Justin Nucci | |
| Jeff Groff | |
| Mike Merrell | |
| Erika Sommer | |
| Casey Carlson | |
| koral | |
| Robert Montelongo | |
| Andrea Dakan | |
| Kim Greeley | |
| Christina Sanford | |
| Mark Eberling | |
| No longer in use | OIT Cloud |
| annemarie harris | OIT-State Data Center |
| KOral'Brien | Vendor |
| Elizabeth Ownsby | Isilon |
| Scott.leach@state.co.us | |
| Matt.ballard@state.co.us | |
| iDrop | |
| Matt Ballard | |
| My Hoang | |
| Richard Leander | |
| Nicholas Luedde | |
| Kevin Groome (Vendor-Pica9) | |
| Devon Cochenour (vendor) | |
| Matt Ballard (OIT) | |
| Ami Jordan (CTS-vendor) | |
| Matt Ballard (OIT)? |
Ticket submitted to OIT
| Suzanne Hassler (OIT) |
| Kirida Sin (OIT)? |
| Amanda Nichols (Vendor-RMC) |
| Jeanne Ainsley (OIT-CDPHE) |
Vendor: Custom Data Processing (CDP)
| Jeff Scott |
| Robin Hedlund |
| Arne Sjodin |
Chris Theel
| Michael Emming |
| Robert Hillegas |
| Phil Stanwood |
| Chris Theel |
| Sarah Erickson |
| Erick Worker |
| Ben Eby |
| Veronica Kenkel |
| John Duggan |
| Jyoti Kochnar |
| Ralph Gagliardi |
| Heidi Loveless |
| Rob Barnes - Servers |
Alan Horsman - DB Vendor for application
| Robyn Peterson |
| Vendor Supported |
| Audrey Simkens |
| Darla Hackworth, Scott Conner |
| Jennifer Malone |
| Scott Conner |
| Pam Buderer |
| Barry Shearer |
| Robert Barnes |
| Natalie Olson |
| Vendor Supported application |
| Vendor Supported (SIPA) |
| Josh Ward/Rob Barnes |
| Scott Conner, Dan Hillman |
| Christopher Wallner |
| Lars Richards |
| Lukas Klifman |
| Rick Lukowicz |
| Rob Barnes |
| Bryan White, Planet Technologies |
| Hailey Nguyen |
| SABR (Jordan Wescott) and Evidence Units |
with Vendor Supported
| Dan Hillman |
| Anthony Rinehart |
| Brian White, Planet Technologies |
| Rick Summers |
| Jeremiah Barkeen |
| Jack Howard |
| Carrie Anders |
| Michael Scott |
TPW_ITProducts IT Product Name from TPW #REF!
File details come from the government source that posted it. Updated .