LS Clinical Trip Report File Transfer Operations

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

Name Description

LSClinicalTripReportFileTransferQuery

This operation returns one or more trip reports along with approved BIP report attachments if any.

LSClinicalTripReportFileTransferQueryPage

This operation returns pages of trip reports along with approved BIP report attachments if any.

LSClinicalTripReportFileTransferUpsert

This operation is used to update the external system URL back to the CTMS system.

Request Message Description: LSClinicalTripReportFileTransferQuery and LSClinicalTripReportFileTransferUpsert.

Name Description Type
ClinicalTripReport.Searchspec Custom search spec to query items such as approved trip reports and trip reports whose BIP reports are not yet uploaded to ETMF. Character
ClinicalTripReport.TripReportID Row Id of Trip report. Character
ClinicalTripReport.VisitName Name of Trip Report. Character
ClinicalTripReport.VisitType Trip Report Type. Character
ClinicalTripReport.VisitStart Trip Report Start Date. Date
ClinicalTripReport.ProtocolId Protocol Row Id. Character
ClinicalTripReport.ProtocolNumber Protocol Number. Character
ClinicalTripReport.Region Region Name. Character
ClinicalTripReport.RegionId Region Row Id. Character
ClinicalTripReport.ProtocolSiteId Site Row Id. Character
ClinicalTripReport.SiteNumber Protocol Site Number. Character
ClinicalTripReport.PIFirstName Principle Investigator First Name. Character
ClinicalTripReport.PILastName Principle Investigator Last Name. Character
ClinicalTripReport.TripReportStatus Trip Report Status. Character
ClinicalTripReport.ApprovedDate Approval date of trip report. Date
ClinicalTripReport.EtmfReceivdDate Date of receipt of ETMF file in the external system. Date
ClinicalTripReport.EtmfUrl URL of the approved BIP Report that is stored in the external ETMF system. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.Id Trip Report Attachment Row Id. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. Searchspec Trip Report Attachment Search specification. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. Comment Trip Report Attachment comments. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. SiteVisitFileExt Trip Report Attachment file extension type. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. Name Trip Report Attachment File Name. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. AttachmentType Trip Report Attachment File Type such as ETMF File or ETMF URL. Character

Request Message Description: LSClinicalTripReportFileTransferQueryPage

Name Description Type
SortSpec Determines whether the the sort order is ascending or descending. Valid values are ASC or DEC. Character
StartRowNum Determines the starting point for record retrieval. The 0-based index of the record within the record set. Character
PageSize The number of records to be returned for a component. The default page size is 10. Note that 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. Character
ClinicalTripReport.Searchspec Custom search spec to query items such as approved trip reports and trip reports whose BIP reports are not yet uploaded to ETMF. Character
ClinicalTripReport.TripReportID Row Id of Trip report. Character
ClinicalTripReport.VisitName Name of Trip Report. Character
ClinicalTripReport.VisitType Trip Report Type. Character
ClinicalTripReport.VisitStart Trip Report Start Date. Date
ClinicalTripReport.ProtocolId Protocol Row Id. Character
ClinicalTripReport.ProtocolNumber Protocol Number. Character
ClinicalTripReport.Region Region Name. Character
ClinicalTripReport.RegionId Region Row Id. Character
ClinicalTripReport.ProtocolSiteId Site Row Id. Character
ClinicalTripReport.SiteNumber Protocol Site Number. Character
ClinicalTripReport.PIFirstName Principle Investigator First Name. Character
ClinicalTripReport.PILastName Principle Investigator Last Name. Character
ClinicalTripReport.TripReportStatus Trip Report Status. Character
ClinicalTripReport.ApprovedDate The date when trip report was approved. Date
ClinicalTripReport.EtmfReceivdDate The date when ETMF file was received by external system. Date
ClinicalTripReport.EtmfUrl URL of the approved BIP Report that is stored in the external ETMF system. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.Id Trip Report Attachment Row Id. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. Searchspec Trip Report Attachment Search specification. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. Comment Trip Report Attachment comments. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. SiteVisitFileExt Trip Report Attachment file extension type. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. Name Trip Report Attachment File Name. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment. AttachmentType Trip Report Attachment File Type such as ETMF File or ETMF URL. Character

Response Message Description: LSClinicalTripReportFileTransferQuery & LSClinicalTripReportFileTransferQueryPage

Name Description Type
ClinicalTripReport.TripReportID Trip Report Row Id. Character
ClinicalTripReport.VisitName Trip Report Name. Character
ClinicalTripReport.VisitType Trip Report Type. Character
ClinicalTripReport.VisitStart Trip Report Start Date. Date
ClinicalTripReport.ProtocolId Protocol Row Id. Character
ClinicalTripReport.ProtocolNumber Protocol Row Number. Character
ClinicalTripReport.Region Region Name. Character
ClinicalTripReport.RegionId Region Row Id. Character
ClinicalTripReport.ProtocolSiteId Protocol Site Row Id. Character
ClinicalTripReport.SiteNumber Protocol Site Number. Character
ClinicalTripReport.PIFirstName Principle Investigator First name. Character
ClinicalTripReport.PILastName Principle Investigator Last name. Character
ClinicalTripReport.TripReportStatus Trip Report Status. Character
ClinicalTripReport.ApprovedDate Approval date of Trip Report. Date
ClinicalTripReport.EtmfReceivdDate Date of receipt of the BIP report in the external ETMF system. Date
ClinicalTripReport.EtmfUrl URL of BIP Report that is stored in the external ETMF system. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.Comment Attachment comments. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.SiteVisitFileExt File extension type such as PDF or DOC. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.Name Attachment name. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.AttachmentType Attachment type such as ETMF File or ETMF URL. Character
ClinicalTripReport_ LSClinicalSiteVisitsAttachment.SiteVisitFileBuffer File attachment in the form of base encode 64. Character

Response Message Description: LSClinicalTripReportFileTransferUpsert

Name Description Type
ClinicalTripReport. PrimaryRowId The updated Trip Report Row Id. Character