Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.





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
Framework

Microsoft .NET 4.5

 

Database

Microsoft SQL Server 2014 Standard Edition

Microsoft SQL Server 2016 Standard Edition

Other Requirements

  • SQL Server Management Studio
  • Mixed Mode Authentication
  • SQL Server Agent
  • Firewall exception for connectivity

    - Standard SQL server ports are
  • TCP 1433
  • UDP 1434
  • Remote access facilities for installation and maintenance by Pen CS
  • with local admin privileges and database owner privileges

 

Operational Requirements

  • We recommend having an experienced database administrator to

maintain the database and the server

  • The PHN holds the sole responsibility to protect and/or manage the

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.

...