Table 352. Request Message Description: QueryPage
|
|
|
UTCCanonical |
This flag is N by default. If this flag is 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 or descending. 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 record set. |
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 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. |
Number |
ClinicalProtocolSite.CompletedCount |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.EarlyTerminated Count |
The optional search specification. |
Number |
ClinicalProtocolSite.EnrolledCount |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.PlannedSubjects |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite. Re-ScreenedCount |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.ScreenFailures Count |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.ScreenedCount |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.AccountId |
Required. Can be either '*' or a valid row ID. |
Character data |
ClinicalProtocolSite.Activate SynchronizationFlag |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite.PrimarySite Address |
Required. Can be either '*' or a valid address. |
Character data |
ClinicalProtocolSite.PrimarySite AddressRowId |
Required. Can be either '*' or a valid Address row ID. |
Character data |
ClinicalProtocolSite.SiteAddressType |
Required. Can be either '*' or a valid address type. |
Character data |
ClinicalProtocolSite.AmountCurrency Code |
Required. Can be either '*' or a valid Currency Code. |
Character data |
ClinicalProtocolSite.AmountEarnedToDate |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.AmountExchangeDate |
Required. Can be either '*' or a valid Date. |
Date |
ClinicalProtocolSite.AmountPaidTo Date |
Required. Can be either '*' or a valid Date. |
Number |
ClinicalProtocolSite.CDMSSite |
Required. Can be either '*' or a valid study name associated. Used for SC-OC Integration. |
Character data |
ClinicalProtocolSite.CDMSStudyId |
Required. Can be either '*' or a valid Study row ID. |
Character data |
ClinicalProtocolSite.City |
Required. Can be either '*' or a valid city name. |
Character data |
ClinicalProtocolSite.ClinicalProgramId |
Required. Can be either '*' or a valid row ID. |
Character data |
ClinicalProtocolSite.ClinicalProgram Name |
Required. Can be either '*' or a valid program name. |
Character data |
ClinicalProtocolSite.Country |
Required. Can be either '*' or a valid country name. |
Character data |
ClinicalProtocolSite.Description |
Required. Can be either '*' or a valid description. |
Character data |
ClinicalProtocolSite.Email |
Required. Can be either '*' or a valid email address. |
Character data |
ClinicalProtocolSite.FaxNumber |
Required. Can be either '*' or a valid fax number. |
Number |
ClinicalProtocolSite.FirstSubjectEnrolledDate |
Required. Can be either '*' or a valid date. |
Date |
ClinicalProtocolSite.SiteRowId |
Required. Can be either '*' or a valid row ID. |
Character data |
ClinicalProtocolSite.Initiation CompletedDate |
Required. Can be either '*' or a valid date. |
Date |
ClinicalProtocolSite.Primary InvestigatorFirstName |
Required. Can be either '*' or a valid first name. |
Character data |
ClinicalProtocolSite.Primary InvestigatorLastName |
Required. Can be either '*' or a valid last name. |
Character data |
ClinicalProtocolSite.LastCompleted DateFlag |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite.LastSubjectOff StudyDate |
Required. Can be either '*' or a valid date. |
Date |
ClinicalProtocolSite.LocaleId |
Required. Can be either '*' or a valid row ID. |
Character data |
ClinicalProtocolSite.LocaleName |
Required. Can be either '*' or a valid locale. |
Character data |
ClinicalProtocolSite.MaxEnrollment Number |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.NoSubjectInfo Flag |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite.PhoneNumber |
Required. Can be either '*' or a valid phone number. |
Character data |
ClinicalProtocolSite.PrevCDMSSite |
Required. Can be either '*' or a valid PrevCDMSSite value. This is used for SC-OC Integration. |
Character data |
ClinicalProtocolSite.PrimaryAddressId |
Required. Can be either '*' or a valid Row Id. |
Character data |
ClinicalProtocolSite.Primary InvestigatorId |
Required. Can be either '*' or a valid Row Id. |
Character data |
ClinicalProtocolSite.PrimaryPositionId |
Required. Can be either '*' or a valid position row ID. |
Character data |
ClinicalProtocolSite.PrimarySubject TemplateId |
Required. Can be either '*' or a valid subject template 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.ProtocolNumber SitesPlanned |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.ProtocolNumber SubjectsPlanned |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.ProtocolProduct Name |
Required. Can be either '*' or a valid number. |
Character data |
ClinicalProtocolSite.ProtocolProgram Indication |
Required. Can be either '*' or a valid program indication. |
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. |
Character data |
ClinicalProtocolSite.RegionPlanned Sites |
Required. Can be either '*' or a valid number of planned sites for the region. |
Character data |
ClinicalProtocolSite.RegionPlanned Subjects |
Required. Can be either '*' or a valid number of planned subjects for the region. |
Character data |
ClinicalProtocolSite.RegionId |
Required. Can be either '*' or a valid region ID. |
Character data |
ClinicalProtocolSite.RegionNoSiteInfoFlag |
Required. Can be either '*' or a valid Region No Site Info flag. |
Boolean |
ClinicalProtocolSite.RegionStatus |
Required. Can be either '*' or a valid region status. |
Character data |
ClinicalProtocolSite.RegionsRequiredFlag |
Required. Can be either '*' or a valid Regions Required flag. |
Boolean |
ClinicalProtocolSite.SiteBillToAddressId |
Required. Can be either '*' or a valid Site Bill To Address ID. |
Character data |
ClinicalProtocolSite.SiteBillToContactId |
Required. Can be either '*' or a valid Site Bill To Contact ID. |
Character data |
ClinicalProtocolSite.SiteAccountRowId |
Required. Can be either '*' or a valid Site ID. |
Character data |
ClinicalProtocolSite.SiteAccountName |
Required. Can be either '*' or a valid site name. |
Character data |
ClinicalProtocolSite.SiteNumber |
Required. Can be either '*' or a valid site number. |
Character data |
ClinicalProtocolSite.State |
Required. Can be either '*' or a valid state. |
Character data |
ClinicalProtocolSite.Status |
Required. Can be either '*' or a valid status. |
Character data |
ClinicalProtocolSite.StreetAddress |
Required. Can be either '*' or a valid street address. |
Character data |
ClinicalProtocolSite.TerminatedDate |
Required. Can be either '*' or a valid terminated date. |
Date |
ClinicalProtocolSite.TimeZone |
Required. Can be either '*' or a valid time zone. |
Character data |
ClinicalProtocolSite.TimeZoneId |
Required. Can be either '*' or a valid Time Zone ID. |
Character data |
ClinicalProtocolSite.TotalContract Amount |
Required. Can be either '*' or a valid total contract amount. |
Number |
ClinicalProtocolSite.TotalVATAmount |
Required. Can be either '*' or a valid VAT amount. |
Number |
ClinicalProtocolSite.Withholding Amount |
Required. Can be either '*' or a valid withholding amount. |
Number |
ClinicalProtocolSite.Withholding Percentage |
Required. Can be either '*' or a valid withholding percentage |
Number |
ClinicalProtocolSite.Zip |
Required. Can be either '*' or a valid ZIP code. |
Character data |
ClinicalProtocolSite.Searchspec |
Required. Can be either '*' or a valid search specification. |
Character data |
ClinicalProtocolSite_Position.Division |
Required. Can be either '*' or a valid division. |
Character data |
ClinicalProtocolSite_Position.DivisionBU |
Required. Can be either '*' or a valid division business unit. |
Character data |
ClinicalProtocolSite_Position.Division Location |
Required. Can be either '*' or a valid division location. |
Character data |
ClinicalProtocolSite_Position.Is PrimaryMVG |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite_Position.Name2 |
Required. Can be either '*' or a valid name. |
Character data |
ClinicalProtocolSite_Position.Row Status |
Required. Can be either '*' or a valid row status. |
Character data |
ClinicalProtocolSite_Position.SalesRep |
Required. Can be either '*' or a valid sales representative. |
Character data |
ClinicalProtocolSite_Position. Searchspec |
Required. Can be either '*' or a valid search specification. |
Character data |
ClinicalProtocolSite_SubjectTemplate.IRBApprovalDate |
Required. Can be either '*' or a valid IRB approval date. |
Date |
ClinicalProtocolSite_SubjectTemplate.IsPrimaryMVG |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite_SubjectTemplate.Version |
Required. Can be either '*' or a valid Version. |
Character data |
ClinicalProtocolSite_SubjectTemplate.Searchspec |
Required. Can be either '*' or a valid search specification. |
Character data |