Page History
Pen CS will be opening up the full capability of PAT CAT though a purpose built API.
Taking Your Population Health Reporting to the Next Level
The PAT BI database provides unprecedented access to the data derived and submitted from CAT4 to your PAT CAT. A purpose built granular database designed for use with Business Intelligence (BI) Tools such as Qlik, Power BI etc. empowers your PHN/ACCHO to explore the depth of data currently at your disposal. Practice data is stored at patient level with an encrypted unique patient identifier allowing for comprehensive longitudinal reporting.
KEY FEATURESGEOCODING YOUR EXTRACTS?
- Uninterrupted access to your data
- Granular patient level database structure
- Fully documented database schema
- Includes PAT CAT database cleaning tools and services
- Capacity for patient and practice longitudinal reporting
- If you are using the Pen CS Geocoding Service you will have the added advantage of bringing together your practices CAT4 clinical data with additional data sets using the exposed Statistical Area 2 (SA2) codes. Each patient, in CAT4, has their address mapped to a SA2 code. Once an SA2 code is assigned to a patient, it can be linked to data sets available outside of the practice clinical information system such as immunisation rates and ABS data.
PAT BI Database Server Specifications
| Minimum Requirements | Recommended Requirements |
---|---|---|
Operating System | Windows Server 2012 (Standard/R2) X64 or higher |
|
Processor | 8 Logical Cores | 16 Logical Cores or more |
RAM | 16 GB | 64 GB or more |
Hard Disk | 500 GB* | 1 TB* or more |
Microsoft .NET | Microsoft .NET 4.5 |
|
Database | Microsoft SQL Server 2014 Standard Edition | Microsoft SQL Server 2016 Standard Edition |
Other Requirements |
|
|
Operational Requirements |
maintain the database and the server
database (including related artifacts) and the server |
|
...
"Estimated Size (GB) =((Patients Per Extract ×Total Practices ×Total Duration)/1,000,000)×15.50
Complex Database Storage
Data growth will eventually hit a limit where increasing disk space is no longer possible. In order to solve the limit issue, we can split the data into multiple drives. Splitting data over multiple disk increases performance of read and writes operations as this spreads the I/O loads, allowing for parallel queries and specific backup/restore of data.
...