Table 344. Request Message Description: QueryPage
|
|
|
UTCCanonical |
This flag is N by default. If this flag is enabled (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 recordset. |
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.Early TerminatedCount |
An 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.Screen FailuresCount |
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.Site AddressType |
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.CDMS Site |
Required. Can be either '*' or a valid study name associated. Used for SC-OC Integration. |
Character data |
ClinicalProtocolSite.CDMS StudyId |
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.Clinical ProgramId |
Required. Can be either '*' or a valid row ID. |
Character data |
ClinicalProtocolSite.Clinical ProgramName |
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. InitiationCompletedDate |
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.Last CompletedDateFlag |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite.Last SubjectOffStudyDate |
Required. Can be either '*' or a valid date. |
Date |
ClinicalProtocolSite.LocaleId |
Required. Can be either '*' or a valid row ID. |
Character data |
ClinicalProtocolSite.Locale Name |
Required. Can be either '*' or a valid locale. |
Character data |
ClinicalProtocolSite.Max EnrollmentNumber |
Required. Can be either '*' or a valid number. |
Number |
ClinicalProtocolSite.No SubjectInfoFlag |
Required. Can be either '*' or a valid Boolean value. |
Boolean |
ClinicalProtocolSite.Phone Number |
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.PrimarySubjectTemplateId |
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.Region PlannedSites |
Required. Can be either '*' or a valid number of planned sites for the region. |
Character data |
ClinicalProtocolSite.Region PlannedSubjects |
Required. Can be either '*' or a valid number of planned subjects for the region. |
Character data |
ClinicalProtocolSite.Region Id |
Required. Can be either '*' or a valid region ID. |
Character data |
ClinicalProtocolSite.Region NoSiteInfoFlag |
Required. Can be either '*' or a valid Region No Site Info flag. |
Boolean |
ClinicalProtocolSite.Region Status |
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.SiteBill ToAddressId |
Required. Can be either '*' or a valid Site Bill To Address ID. |
Character data |
ClinicalProtocolSite.SiteBill ToContactId |
Required. Can be either '*' or a valid Site Bill To Contact ID. |
Character data |
ClinicalProtocolSite.Site AccountRowId |
Required. Can be either '*' or a valid Site ID. |
Character data |
ClinicalProtocolSite.Site AccountName |
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.DivisionLocation |
Required. Can be either '*' or a valid division location. |
Character data |
ClinicalProtocolSite_Position.IsPrimaryMVG |
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.RowStatus |
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 |