UpRevSiteNPartcpnt
Description:
Updates the revision of Study Sites and/or Participants.
Input Properties
participantid
Description:
Semicolon separated list of participants whose revision are to be updated.
Required:
Yes
participantfilter
Description:
Optional property that contains certain filter condition to select participant from LV_Participant SDC. Set the condition in the format of a valid SQL Where clause wrt the LV_Participant SDC.
Example: participantstatus='Enrolled'.
Required:
Only if no participants are passed in using the participantid property.
siteid
Description:
Semicolon-separated list of study sites whose revisions are to be updated.
Required:
Yes
clinicalprotocolrevision
Description:
Clinical protocol revision with which the site and participants are to be updated.
Required:
Yes
auditreason
Description:
Auditing information recorded in the "Reason" column of the TraceLog table.
Required:
No
auditactivity
Description:
Auditing information recorded in the "Activity" column of the TraceLog table.
Required:
No
auditsignedflag
Description:
Auditing information recorded in the "SignedFlag" column of the TraceLog table.
Required:
No
auditdt
Description:
Auditing information recorded in the "ModDt" column of the TraceLog table.
Required:
No
Additional Information
Additional information concerning this Action:
To update revision for sites:
  1. Single site : Pass the site id as 'siteid' property and the revision to set as 'clinicalprotocolrevision' property.
  2. Multiple sites : Pass the sites' ids as semicolon separated list of ids as the 'siteid' property and the revision
  to set as 'clinicalprotocolrevision' property.

To update revision for participants:
  1. Single Participant : Pass the participant id as 'participantid', revision to set as 'clinicalprotocolrevision'
  2. Multiple Participants : Pass the participants as semicolon separated string as 'participantid', revision to set as 'clinicalprotocolrevision'
  3. No Participant : Send the participantid property as "".
  4. All Participant based on condition : Set the condition as 'participantfilter' property. The condition should be a valid SQL WHERE clause based on
  the LV_Participant SDC. Ex - participantstatus='Enrolled'

This Action affects records in the LV_Participant and LV_StudySite SDC tables.

Copyright © 1999-2025 LabVantage Solutions, Inc.