Post-Collection Processing with Bl i Blaise in a Distributed i - - PowerPoint PPT Presentation

▶
post collection processing with bl i blaise in a
SMART_READER_LITE
LIVE PREVIEW

Post-Collection Processing with Bl i Blaise in a Distributed i - - PowerPoint PPT Presentation

Dec 09, 2023 284 likes •446 views

IBUC 2010 Post-Collection Processing with Bl i Blaise in a Distributed i Di t ib t d Environment Mary Laidlaw Mike Rhoads Mary Laidlaw, Mike Rhoads and Jane S hepherd 11/ 3/ 2010 1 Post Processing: Expanding Requirements

slide-1
SLIDE 1

IBUC 2010

Post-Collection Processing with Bl i i Di t ib t d Blaise in a Distributed Environment

Mary Laidlaw Mike Rhoads Mary Laidlaw, Mike Rhoads and Jane S hepherd

11/ 3/ 2010 1

slide-2
SLIDE 2

Post Processing: Expanding Requirements Post-Processing: Expanding Requirements

  • Distributed sites
  • High security with individualized access

High security with individualized access

  • S

equencing and division of tasks

  • Levels of review
  • Automated documentation of data decisions
  • Integration of hardcopy form data

11/ 3/ 2010 2

slide-3
SLIDE 3

Post Processing: Expanding Requirements Post-Processing: Expanding Requirements

  • Easy update of post-processing tool

Ad h d d fi d ti g

  • Ad hoc and predefined reporting
  • Data file versioning and management
  • Instrument level and case level processing

11/ 3/ 2010 3

slide-4
SLIDE 4

The S

  • lution Path

The S

  • lution Path …

Blaise Data Processing and Blaise Data Processing and Quality Assurance (BDPQA)

11/ 3/ 2010 4

slide-5
SLIDE 5

BDPQA: Architecture (part 1) BDPQA: Architecture (part 1)

  • Workflow Manager

I t ti li ti

  • Interactive application
  • S

et up tool

  • S

et up tool

  • User access controls tool

11/ 3/ 2010 5

slide-6
SLIDE 6

BDPQA: Architecture (part 2) BDPQA: Architecture (part 2)

  • DEP, Manipula, Blaise Datalink, and Blaise

Component Pack (BCP)

  • Microsoft S

QL S erver 2005

  • S

QL S erver triggers and stored procedures

  • COTS

for report generation, conversion to PDF, PDF viewing, and viewing audit trails

11/ 3/ 2010 6

slide-7
SLIDE 7

BDPQA: Workflow Manager BDPQA: Workflow Manager

  • Loads newly collected data into site-specific

Loads newly collected data into site specific databases

  • Names and loads associated audit trails
  • Names and loads associated audit trails
  • Runs checks and adds to decision tables at site level
  • Loads cases and decisions closed out by site offices

into central office database

  • Runs checks and adds to decision tables at central
  • ffice level

11/ 3/ 2010 7

slide-8
SLIDE 8

BDPQA: User Interface BDPQA: User Interface

  • Integration with Blaise through BCP

D t d t d d t b i g ith Bl i

  • Data update and data browsing with Blaise

DEP

  • Interaction with S

QL S erver database tables using insert triggers

  • Two views – editor and supervisor

11/ 3/ 2010 8

slide-9
SLIDE 9

BDPQA: Databases BDPQA: Databases

  • Microsoft S

QL S erver S eparate databases for site office editing

  • S

eparate databases for site office editing, central office editing, metadata

  • Write access only by Blaise
  • Additional tables outside of Blaise

11/ 3/ 2010 9

slide-10
SLIDE 10

BDPQA: Highly Customizable BDPQA: Highly Customizable

  • S

etup tool and INI files identify network locations, p y , databases, data models, and sites

  • Distinction between editors and verifiers
  • Edit check exclusion

Critical items nondeliverable items

  • Critical items, nondeliverable items
  • Access to field audit trails
  • S

creen headings (instrument/ form names, study)

  • Internal securit y – IDs and roles

11/ 3/ 2010 10

y

slide-11
SLIDE 11

BDPQA: Editor Level Data Processing BDPQA: Editor Level Data Processing

  • Document reported issues in the system

Document reported issues in the system

  • Review field interviewer comments
  • Update data as necessary enforcing rules
  • Update data as necessary, enforcing rules
  • Document all data updates/ decisions

Verify data decisions

  • Verify data decisions
  • Browse/ review data

R d i

  • Run and review reports
  • Release data to the central office

11/ 3/ 2010 11

slide-12
SLIDE 12

BDPQA Editor View: Main Menu BDPQA Editor View: Main Menu

11/ 3/ 2010 12

slide-13
SLIDE 13

BDPQA Editor View: Pending Work BDPQA Editor View: Pending Work

11/ 3/ 2010 13

slide-14
SLIDE 14

BDPQA: S upervisor Data Processing BDPQA: S upervisor Data Processing

  • Establish editing rules
  • Review data decisions

Review data decisions

  • Code text responses
  • Review frequencies and cross tabulations
  • Finalize data and documentation for delivery

11/ 3/ 2010 14

slide-15
SLIDE 15

Lessons Learned Lessons Learned

Ti t

  • Time stamps
  • Auxfields
  • Field names

Tags

  • Tags
  • Edit checks
  • Data models for form data

11/ 3/ 2010 15

slide-16
SLIDE 16

BDPQA: Advantages BDPQA: Advantages

A t ti i i f d t

  • Automatic versioning of data
  • S

torage and retrieval off audit trails

  • Generation of a variety of reports
  • Internal security for user and role

Internal security for user and role identification at two levels

  • Different data models at editor and

supervisor levels

  • Electronic or hardcopy decision logs

11/ 3/ 2010 16