Siebel Clinical Trial Management System Guide > Setting Up and Configuring Clinical Trial Site Visit Data Integration >

Exporting Clinical Trial Site Geographical Location Details to Siebel Clinical


The Web service SWILSClinicalCreateSiteVisitGeoLocation supports regulatory requirements to track completion of clinical trial site visits. Support is provided to export clinical trial site visit and site geographical location details from a third-party application, including an on-site mobile application, to Siebel Clinical.

Table 12 lists the clinical trial site visit records that can be exported to Siebel Clinical from a third-party application. The logged in user must be a site visit team member listed in the Assigned To list for the site visit. For more information on the Assigned To list, see Creating and Managing Clinical Trial Site Visits.

Table 12. Clinical Trial Site Visit Records Exported to Siebel Clinical
Name
Description
Validation
Required

SiteVisitId

This field is populated with the Site Visit ID. Each separate visit to the site is assigned a separate ID number.

Must be a valid site visit ID.

Yes

VisitDate

This field is populated with the trial site visit date and time.

Must be a valid time and date in the format yyyy-mm-dd hh:mm:ss

Yes

UserId

The user ID of the clinical trial site monitor.

The UserID must be a site visit team member listed in the Assigned To list for the site visit.

Yes

Latitude

Latitude coordinates in decimal degree format. Northern hemisphere latitudes must be input as a positive number. The number is preceded by a minus sign to represent southern hemisphere latitudes.

NOTE:  Using the letters N and S to indicate north and south is not supported, and will result in an error. Northern hemisphere values must be preceded by a + (plus) symbol. Southern hemisphere values must be preceded by a - (minus) symbol.

The value must be within the range -90 to +90.

No

Longitude

Longitude coordinates in decimal degree format. Eastern hemisphere latitudes must be input as a positive number. The number is preceded by a minus sign to represent western hemisphere longitudes.

NOTE:  Using the letters E and W to indicate east and west is not supported, and will result in an error. Eastern hemisphere values must be preceded by + a (plus) symbol. Western hemisphere values must be preceded by a - (minus) symbol.

The value must be within the range -180 to +180.

No

Comments

This field is populated by the site monitor with any comments relating to the clinical trial site visit.

Not applicable.

The comments field is truncated if it exceeds 250 characters.

No

Example of SWILSClinicalCreateSiteVisitGeoLocation Web Service Request

This extract provides an example of configuring the SWILSClinicalCreateSiteVisitGeoLocation Web service request. It exports clinical trial site visit and geographical location details for user SIAADMIN to Siebel Clinical.

<?xml version="1.0" encoding="UTF-8" ?>

- <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:cus="http://siebel.com/CustomUI" xmlns:ls="http://www.siebel.com/xml/LS%20Clinical%20Site%20Visits%20Geo%20Loc%20IO">

<soapenv:Header>

<UsernameToken xmlns="http://siebel.com/webservices">SIAADMIN</UsernameToken>

<PasswordText xmlns="http://siebel.com/webservices">SIAADMIN</PasswordText>

<SessionType xmlns="http://siebel.com/webservices">None</SessionType>

</soapenv:Header>

<soapenv:Body>

<cus:insert_Input>

<ls:ListOfLsClinicalSiteVisitsGeoLocIo>

<!-- Zero or more repetitions: -->

- <ls:LsClinicalSiteVisitLocation>

- <!-- Optional: -->

<ls:Latitude>89</ls:Latitude>

- <!-- Optional: -->

<ls:Longitude>91</ls:Longitude>

<ls:SiteVisitId>88-22X7M</ls:SiteVisitId>

<ls:VisitDate>2000-10-10 01:09:09</ls:VisitDate>

- <!-- Optional: -->

<ls:Comments>Clinical trial site monitoring visit tracking complete</ls:Comments>

<ls:UserId>1SIA-8FKI</ls:UserId>

</ls:LsClinicalSiteVisitLocation>

</ls:ListOfLsClinicalSiteVisitsGeoLocIo>

</cus:insert_Input>

</soapenv:Body>

</soapenv:Envelope>

For more information on configuring the SWILSClinicalCreateSiteVisitGeoLocation Web service, see Siebel CRM Web Services Reference.

Siebel Clinical Trial Management System Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.