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

About Exporting Geographical Location Details for Sites


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

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

Table 12. Site Visit Data Exported to Siebel Clinical
Data
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 date and time for the site visit.

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

Yes

UserId

The user ID of the site monitor.

The User ID must be a 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 results in an error. Northern hemisphere values must be preceded by a plus sign (+). Southern hemisphere values must be preceded by a minus sign (-).

The value must be within the range of 0 to plus or minus 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 results in an error. Eastern hemisphere values must be preceded by a plus sign (+). Western hemisphere values must be preceded by a minus sign (-).

The value must be within the range of 0 to plus or minus 180.

No

Comments

This field is populated by the site monitor with any comments relating to the 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 site visit and geographical location details for user SIAADMIN to Siebel Clinical. For more information about configuring the SWILSClinicalCreateSiteVisitGeoLocation Web service, see Siebel CRM Web Services Reference.

<?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>

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