TURKISH INJURY DATABASE

(UKAY)

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

Aslı Sungur

Features of Database

Web-based application

Application interface: Microsoft Silverlight technology

Database is developed in Oracle

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

TURKISH INJURY DATABASE

Customized user name and password of data entry staff.

This enables Agency to follow up and assess

• the number of data that data entry personnel have entered,• individual performances with regard to data quality.

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

TURKISH INJURY DATABASE

1st VERSION

http://sbu.saglik.gov.tr/idb

MODULES

ADMINISTRATIVE VARIABLES

INJURY EVENT VARIABLES

SUBMIT CLEAR

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

TURKISH INJURY DATABASE

1st VERSION Problems

All in one screen: difficult to see the whole page in small screens

Forget to fill in modules

Errors in selection of codes (absence of main codes)

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

TURKISH INJURY DATABASE

2nd VERSION

More user friendly :

Separate screens, Combined variables & modules

Efective quality control points

Main codes + sub-codes easy to find correct code

http://sbu.saglik.gov.tr/idbv2

GENERAL INFO

..Recording Country

..ED Recording Number

..Date of Birth

..Sex of Patient

..Education Level

..Place of Perm.Residence

..Date of Injury

..Time of Injury

..Date of Attendance

..Time of Attendance

..Treatment and Follow up

--Number of Days..

..Intent

..Victim Perpetrator Relation

..Sex of Perpetrator

.. Age of Perpetrator

..Context of Assault

..Proximal Risk Factor

..Previous Intentional Selfharm

..Transport Injury Event

.. Mode of Transport

.. Role of Injured Person

.. Counterpart

..Place of Injury

.. Mechanism of Injury

..Activity When Injured

..Type of Sports Activity

..Type of Injury 1

..Injured Body Part 1

..Type of Injury 2

..Injured Body Part 2

MAIN CODE SUB-CODE

..Direct Object

.. Underlying Object

..Intermediate Object

..Product Defect Injury

Narrative

..Recording Country

..ED Recording Number

..Date of Birth

..Sex of Patient

..Education Level

..Place of Perm.Residence

..Date of Injury

..Time of Injury

..Date of Attendance

..Time of Attendance

inconsistant dates entry

..Treatment and Follow up

--Number of Days In

Hospital..

Treated and admitted to this hospital

..Intent

..Victim Perpetrator Relation

..Sex of Perpetrator

.. Age of Perpetrator

..Context of Assault

..Proximal Risk Factor

..Previous Intentional Selfharm

Assault

..Transport Injury Event

.. Mode of Transport

.. Role of Injured Person

.. Counterpart

No

..Place of Injury

.. Mechanism of Injury

..Activity When Injured

..Type of Sports Activity

..Type of Injury 1

..Injured Body Part 1

..Type of Injury 2

..Injured Body Part 2

01 Home (main code) 01.10 Kitchen (sub-code)

2.2 Puncturing, stabbing 2.21 Stabbed

98 Other specified object/

4 Open wound

3.30 Thorax 3.31 Chest

..Direct Object

.. Underlying Object

..Intermediate Object

..Product Defect Injury

08.01 Cooking or food processing utensil 08.0105 Knife

Not mandatory

Not mandatory

Warning: Fields with red backgroung must be filled in

Narrative

Warning: Inconsistant dates

..Trearment and Follow up

--Number of Days..

Treated and admitted to this hospital

..Intent

..Victim Perpetrator Relation

..Sex of Perpetrator

.. Age of Perpetrator

..Context of Assault

..Proximal Risk Factor

..Previous Intentional Selfharm

Assault

..Place of Injury

.. Mechanism of Injury

..Activity When Injured

..Type of Sports Activity

..Type of Injury 1

..Injured Body Part 1

..Type of Injury 2

..Injured Body Part 2

01 Home 01.10 Kitchen

2.2 Puncturing, stabbing 2.21 Stabbed

98 Other specified object/

4 Open wound

3.30 Thorax 3.31 Chest

Not mandatory

Not mandatory

..Direct Object

.. Underlying Object

..Intermediate Object

..Product Defect Injury

08.01 Cooking or food processing utensil 08.0105 Knife

Not mandatory

Not mandatory

Warning: Fields with red backgroung must be filled in

Narrative

Information System Infrastructure

EDs

Operational database of MoH Data warehouse

Data

Data

Data

ETL RAPORT

FIELD

INF

O

INF

O

Decision makers

Web based data entry

Extract Transform Load:

Data quality check

Business intelligence application

Data ready to momentary

interrogation

Role Based Dashboards Analytic Workflow Guided Navigation Security / Visibility Alerts & Proactive Delivery

Logical to Physical Abstraction Layer Calculations and Metrics Definition Visibility & Personalization Dynamic SQL Generation

Highly Parallel Multistage and Customizable Deployment Modularity

Abstracted Data Model Conformed Dimensions Heterogeneous Database support Database specific indexing

Oracle BI Applications ArchitectureOracle BI Applications ArchitectureA

dmin

istr

atio

n

Met

adat

a

Oracle BI Presentation Services

Dashboards by Role

Reports, Analysis / Analytic Workflows

Metrics / KPIs

Logical Model / Subject Areas

Physical Map

Oracle BI Server

Direct Access to Source Data

Data Warehouse /Data Model

ETL

Load Process

Staging Area

Extraction Process

DA

C

Federated Data Sources

SiebelOracle SAP R/3 PSFT EDW

Other

Feature of Oracle Business Intelligence

Oracle BI 11 G, 1.1.6.2

https://kds.sagliknet.saglik.gov.tr

Reports with interactive dashboards

Performances of hospitals & data recorders

Export of data as pdf, excel, ppt.

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

Data Information

Oldest attendance date: 03.07.2012

Youngest attendance date: up to date

Number of data: 1268

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

INJURY REPORTS

TURKISH PUBLIC HEALTH AGENCYDirectorate of Strategy Development

Thank you for your interest..