1. User Guide
  2. Loading data into the Oracle InForm User Management Tool
  3. Entering data in the MUL Template
  4. Entering site data

Entering site data

You enter data for sites on the Sites worksheet. You can add new sites, change data for existing sites, delete existing sites, or re-instate a site.

Blue-labeled columns are required fields and data must be filled in according to the formats specified in the spreadsheet. For example, when entering phone numbers only include digits and start the number with the appropriate country code.

  • Do not leave blank rows between entries.

    This prevents the data from being properly validated.

  • For site names only, you can use alpha numeric characters or apostrophe ( ' ), comma ( , ), dash ( - ), period ( . ), semi-colon ( ; ), colon ( : ), or underscore ( _ ) characters.

    The apostrophe ( ' ) character can only be used in Oracle InForm 6.2 and above. No foreign accents or special characters are allowed. Do not use carriage returns in addresses.

  • For Oracle IRT trials only, leaving the Limit ship address field to 30 checkbox unchecked allows you to provide a shipping address up to 255 characters.
  • You must select a time zone in the Time Zone column.

    However, the time zone-related data in the Time Zones 2011/Time Zones Dec 2012 conversion time column is populated for you based on the time zone you select.

  • The optional Date Format column allows the trial’s default date format to be overridden on a site-by-site basis.

    This is configured in the Oracle InForm User Management Tool configuration for a trial. If you are using a trial configuration document and this is left blank, the date format provided in the trial configuration document is used.

  • The mandatory Accept Date column should be populated with the date that the site was added to the MUL template.
  • If the Oracle InForm User Management Tool configuration for the trial is set to MULTIPLE and you are re-instating a site, the Study Version column is mandatory (this value is checked as part of the upload to Oracle InForm User Management Tool).
    • If your trial is configured for MULTIPLE and you create a new site, you can either specify a study version in this column or the version will default to the earliest study version entered in Oracle InForm User Management Tool.
    • If your trial is configured for LATEST, a study version is not required.

Note:

When specifying a trial version, you must enter it exactly as it appears in Oracle Central Designer.

Parent topic: Entering data in the MUL Template