Database Information

Host 

Enter the name or IP address of the Oracle Server where the Watson schema is located.

Port 

Enter the port of the Oracle Server where the Watson data­base is located (Oracle’s default port number is 1521).

DB SID 

Enter the name of the Oracle database where the Watson schema is located.

Account Information

Service Account 

Enter the name of the Oracle database account used to select data from the Watson schema.
This account needs to be located in the same Oracle data­base as the Watson schema and must have select privileges on all tables in the Watson Account schema.

Service Account PW 

Enter the password for the Service Account.

Watson Account 

Enter the name of the Watson schema.
The Watson LIMS plug-in uses this to select data from the Watson schema (e.g., select * from wat­son.study). This is usually set to watson.

License Information

Info field 

Lists copyright and specific licensing information.

Worksheet Names

Sample 

Enter the name of the Sample Worksheet that is created in the Phoenix project.

Dosing 

Enter the name of the Phoenix Dosing Worksheet that is created in the Phoenix project.

Text Replacement Labels

BQL 

Enter the text used to represent values from Wat­son that are below the limit of quantification.

AQL 

Enter the text used to represent values from Wat­son that are above the limit of quantification.

Missing Value 

Enter the text to display in cells that are missing data.

Nominal/Relative Time Configuration

Units 

Specify the unit of the transferred columns (Days, Hours, Minutes).

Precision 

Specify the precision of the time columns trans­ferred from Watson by selecting either Signifi­cant Digits or Decimal Places and entering the numeric value for the precision in the adjacent field.

Worksheet Configuration

Remove Subjects With­out Sample Results 

Only import subjects with at least one concentra­tion value in Watson.
Default is checked.

Remove Samples Without Sample Results 

Only import designed samples that have a corre­sponding sample result in Watson.
Default is unchecked.

Remove Unlocked Sam­ple Results 

Only import samples from Watson where the sample result is locked.
This option is grayed out by default.

Create Dose Rows For Unique Analytes 

Create additional dosing rows for each unique analyte in the study.
Default is checked.

Create Dose Rows For Unique Matrices 

Create additional dosing rows for each unique matrix in the study.
Default is checked.

Remove Empty Columns 

Only import a column of data from Watson when at least one value exists in the column.
This rule is applied before the Missing Text Value is applied.
Default is checked.

Remove Rejected Sam­ples 

Remove samples that have been rejected from the sample dataset.

Remove Dosing Work­sheet 

Do not create a dosing worksheet on a transfer from Watson.
Default is checked.

Include Prep. Sample Worksheet 

Create a prepared sample worksheet

ReAssay Handling

Include Samples with ReAssay Tags 

Include reassayed data in the worksheets returned to Phoenix.
When checked, the Filter Criteria options become available.

Filter Criteria 

Reasons: Enter the reason for the reassay (e.g., Mandatory Repeats or Incurred Sam­ple Repeats).
Reassayed samples that match the reason will be included during import.
If not, the sample is removed.

Statuses: Enter the status of the reassay (e.g., acc).
Reassayed samples that match the status will be included.
If not, the sample is removed.

If there is no entry for Reasons and Statuses, but the Include Samples with ReAssay Tags option is checked, then all of the reassayed data is imported.

Columns

Transfer 

Check the checkbox to transfer the column during the Watson import.
Uncheck the checkbox for columns that are not to be transferred.

Default Column Name 

Displays the Watson column name and is not editable.
Cells in this table column that are in yellow are time independent (demographics) and are shared across the Dosing and Sample Worksheet configurations.
Configurations applied to these columns will be replicated to both the Dosing and Sample Worksheets.

Transferred Column Name 

Enter the name of the column as it will appear in the Phoenix Work­sheet after the Watson import is completed.

Units 

Define the unit for the transferred column.
Set the units of a column to a fixed value by entering a text entry surrounded by single quotes (e.g., ‘year’, ‘min’).
Or set the units of a column to a transferred column from Watson (e.g., CONCENTRATIONUNITS or DOSEUNITS).
Cells in this column that are highlighted in gray cannot be set because these fields are not applicable or are populated based on a business rule.

Other Settings

Sync Non-Demo From Samples 

Synchronize configuration settings from the columns that are shared across the Dosing and Sample Worksheet configurations (e.g., Treatment, Period).

Column Order 

Click the Up or Down to move the selected row up or down the list, respectively.
This will impact the order that the columns appear from left to right in the Phoenix Worksheet.

All/None 

Click All to check all of the Transfer checkboxes.
Click None to uncheck all of the Transfer checkboxes.

Defaults 

Restore the Worksheet configuration options to the original default selections.