60 likes | 207 Views
OCFS Data Warehouse. CCRS. CONNECTIONS. OCFS Data Warehouse. Operational Data Store (ODS). Commissioner’s Dashboard. Geographic Information Center (GIC). Data Marts/ Cognos/ End User. How It Works. General Information. Data from CONNECTIONS and CCRS
E N D
CCRS CONNECTIONS OCFS Data Warehouse Operational Data Store (ODS) Commissioner’s Dashboard Geographic Information Center (GIC) Data Marts/ Cognos/ End User How It Works
General Information • Data from CONNECTIONS and CCRS • CPS/Foster Care: last 10 years • Case Management: since 2006/2007 • Read-only reporting tool; delivers output • Data refreshed regularly • Security set for individual users based on their District
Reporting Areas Data organized by topic • CPS: allegations, investigations • Foster Care: placements, admissions, discharges, movements • Case Management: FASPs, SPRs, casework contacts • Facilities and Foster Homes
Utilization • Users at each District • Dozens of predefined reports • Current snapshot • Historical data • Trending • Ad hoc reporting available for creating custom reports (authorization required)
Contacts Project Manager • Lillian Denton • lillian.denton@ocfs.state.ny.us User Support • data.warehouse@ocfs.state.ny.us