Returns if any partients are scheduled on a Schema

Assigns patient to schema and create timeline

Removes old Schema Item

Removes old Schema Item Fields

Removes old Timeline and ItemTimeline records.

Delete the Patient from the treatment arm.

Removes patient items and fields for a patient on a protocol treatment arm after (and including) offStudyDate

Deletes the treatment arm.

Determines whether the specified Object is equal to the current Object.

Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

Returns a list of all Protocol records

Returns a list of all Protocol Records specified in range start to end. i.e., startIndex=0,endIndex=4, will return upto first 5 records. i.e., startIndex=5,endIndex=9, will return upto 6th through 10th records.

Returns a list of all Schema Items that are templates

Return a list of visits which are contingent on a patient status.

Gets all Child Tables which belong to a ProtocolSchema

Returns the SQL which will return the calcualted firts, last and scheduled date for patient schema

Returns the SQL which will return ALL dependent PatientItems which have yet to be scheduled. Return all columns from ProtocolMgr_PatientItems with ScheduledDate, FirstAnticipatedDate and LastAnticipatedDate calculated on the ScheduledDate of the source visit item.

Returns the SQL which will return a normalilzed list of Patient Items. This will return the depdendent items with their calcualted schedule dates.

Returns the full timeline of all patients (by dataset) for the specified Protocol.

Returns the full timeline of all patients (by dataset) for the specified Protocol.

Serves as a hash function for a particular type.

Returns a list of unique PtProtocolStatus and PatientCount (# of patients with that status). Looks across all schema arms and status of patients on the Protocol.

Returns the next Participant Id

For the given Protocol and Orgnaization, get the next study id.

Returns a list of Unplanned Events based on records in Deviation Table and list of Related Tables

Returns a list of all patients on the protocols (PatientProtocol with optional PatientSchema)

Gets a list of PatientSchema for a protocol

Gets a list of patients across all tratment arms

Gets a list of patients across specified list of tratment arms

Returns a list of Patient's in the specified schema.

Returns a list of Patient Visits and items collected during the visit.

Get the medical therapy record associated with a previous medical therapy administration, given the patient item.

Return the number of Protocol records

Returns a list of ProtocolVersionIds associated with a MetadataSurvey

Returns the PSA Decline (Key) and MAX PSA Decline (Value) for each patient across a trial.

Return a list of all Schemas for a Protocol. SELECT ProtocolSchemaId, ProtocolArmDescription, ProtocolVersionId, VersionNumber

Returns a list of Schema by Protocol Verion.

Gets all TimelineItems which belong to a ProtocolSchema

Gets the Type of the current instance.

Returns if there are any visits created for this item.

Returns if there are any patients scheduled for this item.

Returns if the Schema Item is a grid (i.e., FieldRowIndex IS NOT NULL)

Creates a shallow copy of the current Object.

For the specified Patient Item, if performed, schedule items which are depdent on it.

Schedule Patient Items which are to be scheduled on specified Patient status.

For the given Protocol Schema, schedule items which are not scheduled

Returns if the study id "compareStudyId" exists for this Protocol

Returns a String that represents the current Object.

Updates PatientItemFields with entries for the specified tables and primary keys.