Siebel Clinical Trial Management System Guide > Administering Clinical Subjects and Clinical Visits >

Using Audit Trail for Clinical Subject Status


The Status Audit Trail view provides a detailed history of the changes that have been made to Subject Status records, including the dates and times of changes, and the details of the users who completed the changes.

To use the audit trail for subject status changes

  1. Navigate to the Subjects screen, then the Subject List view.
  2. In the Subjects list, drill down on the screening number of the required subject.
  3. Select the Status Audit Trail tab.

    The Audit Trail applet displays. Some fields are described in the following table.

    Field
    Description

    Base Table

    Displays the name of the primary database table where the database change occurred.

    Business Component

    Displays the business component for the record where the database change occurred.

    Column

    Displays the name of the column in which the change occurred.

    Date

    Displays the timestamp of the change.

    Employee ID

    Displays the unique identifier of the user who changed the record.

    Employee Login

    Displays the username of the user who changed the record.

    Field

    Displays the name of the field where the change occurred.

    Group ID

    Displays the unique identifier of the group to which the user who changed the record belonged.

    New Value

    Displays the value in the field after the database change occurred.

    Node

    Displays the name of the database table node where the change occurred.

    Old Value

    Displays the value in the field before the database change occurred.

    Operation

    Displays the type of operation that was performed, for example, New Record, or Modify.

    Record ID

    Displays the unique identifier of the record that was changed.

    Row ID

    Displays the unique identifier of the row in which the change occurred.

    Table

    Displays the name of table to which the selected field belongs in the Siebel database.

Siebel Clinical Trial Management System Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.