Transcript Data Collection - Scoliosis Research Society

Research Data Collection
Oheneba Boachie-Adjei, MD
Professor Orthopedic Surgery
Weill Medical College of Cornell University
Chief Scoliosis Service
Hospital For Special Surgery, New York
FOCOS DATABASE
History
Need for a comprehensive database
for spine deformity data collection
FOCOS Database v1 (2001)
Purpose:
RESEARCH
REGISTRY
AND
DATABASE
FOR NATURAL
HISTORY
AND
OUTCOME
STUDIES
FOCOS Database v2 (2006)
• Sponsored by DePuy Spine
FOCOS Database v2.
(2006) Purpose
• Clinical registry
– Data collection
– Data retrieval
– Reporting
– Publications
2 Tabs: Main & Operative
Medical History
Demographics
(entered initially)
appear on every
field. No need to
enter more than
Once.
Neurologic Exam
Drop down
options
Users must
indicate an
abnormal
Sensation
to enter
data in this
section
General Exam
Main Sections:
•Anthropometric
•Vital Signs
•Pulmonary Function Tests
•General Exam
Drop down options:
Yes
No
Unk
N/A
Oswestry Questionnaire
Automatic
calculation
Text Box
SF-12 is
Not captured
in FOCOS
Database v2
Spine Exam
SRS 22 Questionnaire
Automatic Calculations
Radiographic Jacket
Drop down
options for
vertebrae
Other Treatment
Family History
Diagnosis Deformity - Scoliosis
Diagnosis: Deformity
Neuromuscular
Scoliosis
Diagnosis: Sagittal Plane Deformity
Age Group Options:
Diagnosis: Syndrome/Other Complications
Syndrome/Other (Syndrome)
Diagnosis: Degenerative Spondylolisthesis
Diagnosis: Degenerative
Diagnosis: Fracture/Trauma
Adding an Operative Report
Surgery: Posterior
Instrumentation
Instrumentation: Screw Fixation
Instrumentation: Hook Fixation
Instrumentation: Interbody Cage
Instrumentation: Connectors
Instrumentation: Other Implants
Surgery: Operative Details
Surgery: Bone Graft
Surgery: Spinal Cord Monitoring
Surgery: Intra Op Complications
Surgery: Post Op Complications
Surgery: Complications leading to death
Revision Surgery
Surgery: Anterior/ Posterior
Advantages of FOCOS Database v2
•
•
•
•
User Friendly
Password Protected
HIPAA Compliant
Drop down fields are easier for reporting
A database with a
purpose…
Generating A Report
2 Options
• For Database users
on server
– Accessing the data
extraction tool via
server login
• For Independent
database users
FOCOS Database
Data Extraction Tool
Ability to choose data from
Various sites who enter
Data onto the database
Server.
Types of Reports Generated
•Microsoft Access based
Back end
•Tables for datapoints
Creating a Query
Advantages of Querying Tool
Research in Motion