Please enable JavaScript.
Coggle requires JavaScript to display documents.
Value Based Care Data Landscape (CC Population Health Product Suite (CC…
Value Based Care Data Landscape
CC Population Health Product Suite
CC Population Health Intelligence
PP_ClientName
- used to store the web site information for each of the clients (1 DB for each client on webdata01)
Security
- used to house security and permissions information. It is accessed via a connection string with a security prefix in OTS (One DB on for all clients)
WH_Prod
- Stores EBM & ETG data, claims, labs, referrals (One DB for all clients) Found on WH_Data, WH_Main, and APS
WH_Conv
- Initial store for external data that will be imported into the system. Contains original external formats and converted data (One DB for all clients)
OTSStratification
AnalyticDM
- On APS and CONVBCCLSQLAD01. APS is for construction and the CONVBCCLSQLAD01 server is for consumption.
WH_Elig
- Store for incoming eligibility data
PP_ClientName
- Databases on Data_Conv used for ETL purposes
MR
- Reference Database
Hangfire
- Process Automation DB
ETL_Control
- Data flow from SMP DBs to APS
EMR_MS
- Data intake for EMR
BundledPayments
- DB on APS for Bundled Payments
Cypress
- A data service Api to allow for connections between EZCAP and CapConnect
MirthDB
- Application DB for Mirth
PP_Agg
- Aggregation of PP_ClientName databases on APS
ETL_Stage
- CI Database for data intake
PPN_Master
- Database for the CI tool
OTS
- The OTS database is used to track information across all clients (One DB for all clients) Housed on both Webdata01 and WH_Data using transactional replication
Diagnostic Class Hierarchy
EBMRulesManager_Version
- Databases for the Optum EBM Rule Manager application
TYCHO
- Staging database for DCH
CIRBM
- Development DB for DCH
NPICodes
- Stores the NPI codes for use by applications
CODES
- DB maintained by the Data Analytics team and published to the Warehouses
Online Analytical Processing (OLAP)
OLAP_ClientName_EBM
- Evidence Based Medicine (EBM) Cube
OLAP_ClientName_ERG
- Episodic Risk Groups (ERG) Cube
OLAP_ClientName
- Medical, Admission, and Risk Strat Cubes