LS Clinical CRF Tracking Interface Service Operations

For a list of operations associated with this Web service, see the following table.

Name	Description
QueryById	Returns all Case Report Forms for a specified Protocol Site Id in the "Id" tag.
QueryByExample	Used to query Case Report Form records based on given filter criteria.
QueryPage	Used to query Case Report Form details in pages based on given filter criteria.

Request Message Description: QueryById

For a description of this request message, see the following table.

Node	Description	Type
PrimaryRowId	Required. Specify the Protocol Site RowId value for which the CRF records should be returned.	String
UTCCanonical	This flag is N by default. If this flag is enabled (Y), then data from the Siebel application must be in UTC (Coordinated Universal Time) and canonical format. The data in UTC and canonical format is converted to Siebel Object Manager format as determined by the value of the UTCCanonical flag.	Boolean

Request Message Description: QueryById

For a description of this request message, see the following table.

Node	Description	Type
ClinicalProtocolSite.PlannedSubjects	Number of planned subjects for the site.	Number
ClinicalProtocolSite.AmountCurrencyCode	Current code of the site.	Currency
ClinicalProtocolSite.AmountExchangeDate	Exchange date for the amount at the site.	Date
ClinicalProtocolSite.FirstSubjectEnrolledDate	Date when the subject was first enrolled.	Date
ClinicalProtocolSite.SiteRowId	Protocol site row ID.	Character data
ClinicalProtocolSite.InitiationCompletedDate	Date when the site was initiated.	Date
ClinicalProtocolSite.InvestigatorFirstName	Principal investigator first name.	Character data
ClinicalProtocolSite.InvestigatorLastName	Principal investigator last name	Character data
ClinicalProtocolSite.LastSubjectOffStudyDate	Date when the last subject was terminated.	Date
ClinicalProtocolSite.PrimaryInvestigatorId	Primary investigator's row ID.	Character data
ClinicalProtocolSite.ProtocolId	Protocol row ID.	Character data
ClinicalProtocolSite.ProtocolNumber	Protocol number.	Character data
ClinicalProtocolSite.ProtocolSiteId	Protocol site row ID.	Character data
ClinicalProtocolSite.ProtocolStatus	Protocol status.	Character data
ClinicalProtocolSite.ProtocolTitle	Protocol title.	Character data
ClinicalProtocolSite.Region	Region name.	Character data
ClinicalProtocolSite.RegionPlannedSites	Number of planned sites for the region.	Number
ClinicalProtocolSite.RegionPlannedSubjects	Number of planned subjects for the region.	Number
ClinicalProtocolSite.RegionId	Region row ID.	Character data
ClinicalProtocolSite.RegionStatus	Region status.	Character data
ClinicalProtocolSite.SiteAccountRowId	Account row ID for the associated site.	Character data
ClinicalProtocolSite.SiteAccountName	Account name for the associated site.	Character data
ClinicalProtocolSite.SiteNumber	Site number.	Character data
ClinicalProtocolSite.Status	Protocol site status.	Character data
ClinicalProtocolSite.TerminatedDate	Site terminated date.	Date
ClinicalProtocolSite.TotalContractAmount	Total contract amount rolled up for the site.	Currency
LsCrfTrackingBc.NumberofPages	Total number of pages for the CRF record.	Number
LsCrfTrackingBc.ActivityType	Type of activity.	Character data
LsCrfTrackingBc.Category	Category.	Character data
LsCrfTrackingBc.ChartsReviewed	When was the charts reviewed.	UTC Date Time
LsCrfTrackingBc.Comments	Comments.	Character data
LsCrfTrackingBc.CRFRowIdId	CRF Row ID.	Character data
LsCrfTrackingBc.Name2	Name of the CRF.	Character data
LsCrfTrackingBc.PagesVerified	Number of pages verified.	Number
LsCrfTrackingBc.ProtocolRegionId	Region row ID.	Character data
LsCrfTrackingBc.ProtocolSiteId	Protocol site ID.	Character data
LsCrfTrackingBc.ReceivedbyDataManagement	Date when received by the data management.	UTC Date Time
LsCrfTrackingBc.Receivedinhouse	Date when the CRF was received by in-house.	UTC Date Time
LsCrfTrackingBc.Retrieved	Boolen flag indicating whether or not the CRF information was retrieved.	Boolean
LsCrfTrackingBc.RetrievedDate	When the CRF was retrieved.	UTC Date Time
LsCrfTrackingBc.SignedForms	Whether the CRF are signed.	Boolean
LsCrfTrackingBc.SourceVerfied	The CRF is source verified.	Boolean
LsCrfTrackingBc.SourceVerifiedDate	When the CRF was source verified.	UTC Date Time
LsCrfTrackingBc.SubjectId	Subject row ID.	Character data
LsCrfTrackingBc.SubjectNumber	Subject number.	Character data

Request Message Description: QueryPage

For a description of this request message, see the following table.

Node	Description	Type
UTCCanonical	This flag is N by default. If this flag is enabled (Y), then data from the Siebel application must be in UTC (Coordinated Universal Time) and canonical format. The data in UTC and canonical format is converted to Siebel Object Manager format as determined by the value of the UTCCanonical flag.	Boolean
SortSpec	Determines whether the sort order is ascending ordescending. Valid values are ASC or DEC.	Character Data
StartRowNum	Determines the starting point for record retrieval. The 0-based index of the record within the recordset.	Number
LastPage	Indicates whether the record being returned is the last record in the record set. Valid values are true or false.	Character Data
PageSize	The number of records to be returned for a component. The default page size is 10. Note: There is a server parameter that controls the maximum page size (MaximumPageSize). If the pagesize attribute is greater than the maximum pagesize defined in the server parameter, an error occurs.	Number
ClinicalProtocolSite.PlannedSubjects	Required. Number of planned subjects for the site. Can be either ‘*’ or a valid number.	Number
ClinicalProtocolSite.Searchspec	An optional search specification.	Character Data
ClinicalProtocolSite.AmountCurrencyCode	Required. Currency Code of the site. Can be either ‘*’ or a valid currency amount.	Currency
ClinicalProtocolSite.AmountExchangeDate	Required. Can be either ‘*’ or a valid exchange date for the amount at the site.	Date
ClinicalProtocolSite.FirstSubjectEnrolledDate	Required. Can be either ‘*’ or a valid date when the subject was first enrolled.	Date
ClinicalProtocolSite.SiteRowId	Required. Can be either ‘*’ or a valid protocol site row ID.	Character data
ClinicalProtocolSite.InitiationCompletedDate	Required. Can be either ‘*’ or a valid date when the site was initiated.	Date
ClinicalProtocolSite.InvestigatorFirstName	Required. Can be either ‘*’ or a valid principal investigator first name.	Character data
ClinicalProtocolSite.InvestigatorLastName	Required. Can be either ‘*’ or a valid principal investigator last name.	Character data
ClinicalProtocolSite.LastSubjectOffStudyDate	Required. Can be either ‘*’ or a valid date when the last subject was terminated.	Date
ClinicalProtocolSite.PrimaryInvestigatorId	Required. Can be either ‘*’ or a valid primary investigator’s row ID.	Character data
ClinicalProtocolSite.ProtocolId	Required. Can be either ‘*’ or a valid protocol row ID.	Character data
ClinicalProtocolSite.ProtocolNumber	Required. Can be either ‘*’ or a valid protocol number.	Character data
ClinicalProtocolSite.ProtocolSiteId	Required. Can be either ‘*’ or a valid protocol site row ID.	Character data
ClinicalProtocolSite.ProtocolStatus	Required. Can be either ‘*’ or a valid protocol status.	Character data
ClinicalProtocolSite.ProtocolTitle	Required. Can be either ‘*’ or a valid protocol title.	Character data
ClinicalProtocolSite.Region	Required. Can be either ‘*’ or a valid region name.	Character data
ClinicalProtocolSite.RegionPlannedSites	Required. Can be either ‘*’ or a valid number of planned sites for the region.	Number
ClinicalProtocolSite.RegionPlannedSubjects	Required. Can be either ‘*’ or a valid number of planned subjects for the region.	Number
ClinicalProtocolSite.RegionId	Required. Can be either ‘*’ or a valid region row ID.	Character data
ClinicalProtocolSite.RegionStatus	Required. Can be either ‘*’ or a valid region status.	Character data
ClinicalProtocolSite.SiteAccountRowId	Required. Can be either ‘*’ or a valid account row ID for the site associated.	Character data
ClinicalProtocolSite.SiteAccountName	Required. Can be either ‘*’ or a valid account name for the site associated.	Character data
ClinicalProtocolSite.SiteNumber	Required. Can be either ‘*’ or a valid site number.	Character data
ClinicalProtocolSite.Status	Required. Can be either ‘*’ or a valid protocol site status.	Character data
ClinicalProtocolSite.TerminatedDate	Required. Can be either ‘*’ or a valid site terminated date.	Date
ClinicalProtocolSite.TotalContractAmount	Required. Can be either ‘*’ or a valid total contract amount rolled up for the site.	Currency
LsCrfTrackingBc.NumberofPages	Required. Can be either ‘*’ or a valid total number of pages for the CRF record.	Number
LsCrfTrackingBc.ActivityType	Required. Can be either ‘*’ or a valid type of activity.	Character data
LsCrfTrackingBc.Category	Required. Can be either ‘*’ or a valid category.	Character data
LsCrfTrackingBc.ChartsReviewed	Required. Can be either ‘*’ or a valid charts reviewed date.	UTC Date Time
LsCrfTrackingBc.Comments	Required. Can be either ‘*’ or a valid comments.	Character data
LsCrfTrackingBc.CRFRowIdId	Required. Can be either ‘*’ or a valid CRF row ID.	Character data
LsCrfTrackingBc.Name2	Required. Can be either ‘*’ or a valid name of the CRF.	Character data
LsCrfTrackingBc.PagesVerified	Required. Can be either ‘*’ or a valid number of pages verified.	Number
LsCrfTrackingBc.ProtocolRegionId	Required. Can be either ‘*’ or a valid region row ID.	Character data
LsCrfTrackingBc.ProtocolSiteId	Required. Can be either ‘*’ or a valid protocol site ID.	Character data
LsCrfTrackingBc.ReceivedbyDataManagement	Required. Can be either ‘*’ or a valid Date when received by the data management.	UTC Date Time
LsCrfTrackingBc.Receivedinhouse	Required. Can be either ‘*’ or a valid Date when the CRF was received by the Inhouse.	UTC Date Time
LsCrfTrackingBc.Retrieved	Required. Can be either ‘*’ or a valid Boolen flag if the CRF information is retrieved or not..	Boolean
LsCrfTrackingBc.RetrievedDate	Required. Can be either ‘*’ or a valid CRF retrieved date.	UTC Date Time
LsCrfTrackingBc.SignedForms	Required. Can be either ‘*’ or a valid Boolean value indicating if the CRF is signed.	Boolean
LsCrfTrackingBc.SourceVerfied	Required. Can be either ‘*’ or a valid Boolean value indicating if the CRF is source verified.	Boolean
LsCrfTrackingBc.SourceVerifiedDate	Required. Can be either ‘*’ or a valid date when the CRF was source verified.	UTC Date Time
LsCrfTrackingBc.SubjectId	Required. Can be either ‘*’ or a valid subject row ID.	Character data
LsCrfTrackingBc.SubjectNumber	Required. Can be either ‘*’ or a valid subject number.	Character data

Response Message Description: All LS Clinical CRF Tracking Interface Service Operations

For a description of this response message, see the following table.

Node	Description	Type
ClinicalProtocolSite.PlannedSubjects	Number of planned subjects for the site.	Number
ClinicalProtocolSite.AmountCurrencyCode	Current code of the site.	Currency
ClinicalProtocolSite.AmountExchangeDate	Exchange date for the amount at the site.	Date
ClinicalProtocolSite.FirstSubjectEnrolledDate	Date when the subject was first enrolled.	Date
ClinicalProtocolSite.SiteRowId	Protocol site row ID.	Character data
ClinicalProtocolSite.InitiationCompletedDate	Date when the site was initiated.	Date
ClinicalProtocolSite.InvestigatorFirstName	Principal investigator first name.	Character data
ClinicalProtocolSite.InvestigatorLastName	Principal investigator last name.	Character data
ClinicalProtocolSite.LastSubjectOffStudyDate	Date when the last subject was terminated.	Date
ClinicalProtocolSite.PrimaryInvestigatorId	Primary investigator’s row ID.	Character data
ClinicalProtocolSite.ProtocolId	Protocol row ID.	Character data
ClinicalProtocolSite.ProtocolNumber	Protocol number.	Character data
ClinicalProtocolSite.ProtocolSiteId	Protocol site row ID.	Character data
ClinicalProtocolSite.ProtocolStatus	Protocol status.	Character data
ClinicalProtocolSite.ProtocolTitle	Protocol title.	Character data
ClinicalProtocolSite.Region	Region name.	Character data
ClinicalProtocolSite.RegionPlannedSites	Number of planned sites for the region.	Number
ClinicalProtocolSite.RegionPlannedSubjects	Number of planned subjects for the region.	Number
ClinicalProtocolSite.RegionId	Region row ID.	Character data
ClinicalProtocolSite.RegionStatus	Region status.	Character data
ClinicalProtocolSite.SiteAccountRowId	Account row ID for the site associated.	Character data
ClinicalProtocolSite.SiteAccountName	Account name for the site associated.	Character data
ClinicalProtocolSite.SiteNumber	Site number.	Character data
ClinicalProtocolSite.Status	Protocol site status.	Character data
ClinicalProtocolSite.TerminatedDate	Site terminated date.	Date
ClinicalProtocolSite.TotalContractAmount	Total contract amount rolledup for the site.	Currency
LsCrfTrackingBc.NumberofPages	Total number of pages for the CRF record.	Number
LsCrfTrackingBc.ActivityType	Type of activity.	Character data
LsCrfTrackingBc.Category	Category.	Character data
LsCrfTrackingBc.ChartsReviewed	When was the charts reviewed.	UTC Date Time
LsCrfTrackingBc.Comments	Comments.	Character data
LsCrfTrackingBc.CRFRowIdId	CRF row ID.	Character data
LsCrfTrackingBc.Name2	Name of the CRF.	Character data
LsCrfTrackingBc.PagesVerified	Number of pages verified.	Number
LsCrfTrackingBc.ProtocolRegionId	Region Row ID.	Character data
LsCrfTrackingBc.ProtocolSiteId	Protocol site ID.	Character data
LsCrfTrackingBc.ReceivedbyDataManagement	Date when received by the data management.	UTC Date Time
LsCrfTrackingBc.Receivedinhouse	Date when the CRF was received by the in-house.	UTC Date Time
LsCrfTrackingBc.Retrieved	Boolen flag if the CRF information is retrieved or not.	Boolean
LsCrfTrackingBc.RetrievedDate	When the CRF was retrieved.	UTC Date Time
LsCrfTrackingBc.SignedForms	Whether the CRF are signed.	Boolean
LsCrfTrackingBc.SourceVerfied	The CRF is source verified.	Boolean
LsCrfTrackingBc.SourceVerifiedDate	When the CRF was source verified.	UTC Date Time
LsCrfTrackingBc.SubjectId	Subject row ID.	Character data
LsCrfTrackingBc.SubjectNumber	Subject number.	Character data