Protocol Management Development

From CaisisWiki

(Difference between revisions)
Jump to: navigation, search
(Timeline)
(Depending on a previous Visit's item)
Line 48: Line 48:
*ItemIntervalType: "Recurring"
*ItemIntervalType: "Recurring"
 +
 +
 +
'''SQL:''' get source visit's item based on dependent item
 +
<pre>
 +
RelatedRecords.SrcTableName = 'ProtocolMgr_Timeline'
 +
AND RelatedRecords.SrcPrimaryKey = [DEPENDENT ItemTimelineId]
 +
AND RelatedRecords.DestTableName = 'ProtocolMgr_ItemTimeline'
 +
AND RelatedRecords.SrcSystem = 'Caisis'
 +
</pre>
=====Depending on a Patient's status=====
=====Depending on a Patient's status=====

Revision as of 20:41, 17 February 2011

Contents

Developer

Schema Info

Schema Items

Timeline

Relevant Tables

  • ProtocolMgr_SchemaItems: represents a particular set of items to be collected (collect LabDate and LabResult for Lab Tests)
  • ProtocolMgr_Timeline: represents visit
  • ProtocolMgr_ItemTimeline: represents a particular set of items on a visit
  • ProtocolMgr_PatientItems: a patient's specific particular set of items for a particular date.
  • RelatedRecords: used to relate one record to another

Advanced Scheduling

Visits which have advanced scheduling are marked in the visit's ItemIntervalType field to signify the scheduling. A pipe is used to delimit multiple advanced scheduling features.

ProtocolMgr_Timeline

  • ItemIntervalType: "Recurring", "Dependent Off Treatment", "Recurring|Dependent Off Treatment"

Recurring Visits

A recurring visit is a visit that will occur at a set frequency for a set time period. For instance, a visit may occur every 4 Weeks for 16 Weeks, creating 4 visits.

Dependent Visits

A dependent visit is one which will not be scheduled until a specified actions happens in the system, such as a patient status changing or upon completion of a visit.

In both scenarios, a Patient Item record will be created, but NOT scheduled when then are initially placed "On Study", since these dates are computed after an event in the system.

ProtocolMgr_PatientItems

  • FirstAnticipatedDate: date is calculated after trigger event
  • LastAnticipatedDate: date is calculated after trigger event
  • ScheduledAnticipatedDate: date is calculated after trigger event
Depending on a previous Visit's item

In this scenario, when a previous is marked as performed, the dependent visits are then scheduled based upon the performed date of the previous visit, such as Week 3's visit is based on completion of a Pre-Study lab test.

A Related Record entry is used to mark a visit's dependency on another visit's item, as well as marking the ItemIntervalType column as Dependent.

RelatedRecord

  • DestTableName: "ProtocolMgr_ItemTimeline" - the visit item on which the visit is dependent
  • DestPrimaryKey: pri key of visit item
  • SrcTableName: "ProtocolMgr_Timeline" - the dependent visit
  • SrcPrimaryKey: pri key of the visit
  • SrcSystem: "Caisis" - mark that this an internal Caisis relation

ProtocolMgr_Timeline

  • ItemIntervalType: "Recurring"


SQL: get source visit's item based on dependent item

RelatedRecords.SrcTableName = 'ProtocolMgr_Timeline'
AND RelatedRecords.SrcPrimaryKey = [DEPENDENT ItemTimelineId]
AND RelatedRecords.DestTableName = 'ProtocolMgr_ItemTimeline'
AND RelatedRecords.SrcSystem = 'Caisis'
Depending on a Patient's status

In this scenario, when a specified patient's status is entered, these visits will be scheduled based on that new status. i.e., A patient is placed "Off Treatment", and will require a final visit.

No related record is created in this instance. The mapping to signal this visit as dependent on a status is stored in the ItemIntervalType' field.

ProtocolMgr_Timeline

  • ItemIntervalType: "Dependent Off Treatment"

PatientProtocolStatus

  • PtProtocolStatus: "Off Treatment" - a status of a patient on a protocol

SQL: visit is matched to patient's status

ProtocolMgr_Timeline.ItemIntervalType LIKE '%Dependent ' + PatientProtocolStatus.PtProtocolStatus + '%'

Multiple Advanced Scheduling Options

Both the recurring and dependent scheduling options can be combined for more complex scenarios, such as a patient will be scheduled for 3 weekly follow up visits 1 week after they go "Off Treatment".

Personal tools