In this section Hide
A source description table (or view) describes the source data that is used in the Empirica Signal application. Information from this table appears when users do the following:
Additionally, this table defines information needed for timestamped data. You must specify a source description table for a data configuration that supports timestamped data.
A source description table is created and populated outside of the Empirica Signal application using standard Oracle tools or any application that enables working with Oracle tables. The table must be in the Oracle account containing the source database tables. A data configuration in the Empirica Signal application then refers to the table. An existing data configuration can be edited to add a source description table to it.
For the table name, it is recommended that the name distinguishes the table from other source description tables and indicates the table's purpose. A source description table must include one row with the following columns. All columns must be included, even if they are not used.
|
Column |
Data Type |
Description |
|
ID |
NUMBER(1) |
Unique identifier of the row. (There will be only one row.) |
|
DESCRIPTION |
VARCHAR2(30) |
Description of the source data. |
|
LOADDATE |
DATE |
Date and time when the source data was loaded. |
|
SOURCE |
VARCHAR2(30) |
Source of the safety data. |
|
DRUGDICTIONARY |
VARCHAR2(30) |
Reserved for future use. |
|
DRUGDICTIONARYVER |
VARCHAR2(30) |
Reserved for future use. |
|
EVENTDICTIONARY |
VARCHAR2(30) |
Reserved for future use. |
|
EVENTDICTIONARYVER |
VARCHAR2(30) |
Reserved for future use. |
|
ASOFDATE |
DATE |
Supports use of timestamped data. |
|
EARLIEST_ASOFDATE |
DATE |
Supports use of timestamped data |
For example, suppose the DESCRIPTION is TEST_AERS_2007, the LOADDATE is 02-Jan-2008, and the SOURCE is NTIS. The description of the source database appears in the application as:
Source Data: TEST_AERS_2007 from NTIS on 02-Jan-2008
You can view the source description table on the Data Sources page.
To support timestamped data, the application must know the range of dates that are valid for users to enter when prompted for an As Of date. The following two columns of the source description table define the range:
The values of these columns are determined during the data preparation process.
On Empirica Signal pages where users specify an As Of date, the default date that appears is the ASOFDATE from the source description table. Users can change the displayed date to another date that is earlier than or equal to the ASOFDATE and later than or equal to the EARLIEST_ASOFDATE.