Apply snapshot labels directly to data in tables

  1. Log in to Oracle LSH.

  2. Expand the Life Sciences Data Hub node in the main menu on the left or from the Navigator drop-down. Select Applications.

    Or, if Oracle LSH is already open, go to the Applications tab.

  3. Navigate to the tables to which you want to apply a snapshot label:

    1. In the Application Development window, click the Icon is a magnifying glass.Search icon next to the Select Domain field.

    2. Select Search By: Domain Name, enter DMW_DOMAIN, then click Go.

    3. Click the Icon includes a down arrow.Quick Select icon for DMW_DOMAIN.

    4. Expand the node for the study grouping domain that contains the study.

    5. Expand the node for the study.

    6. Click the link for the lifecycle application area. A list of work areas, one for each installed clinical data model, appears. The model name is in the work area description.

    7. Click the link for the work area. A list of tables and other objects in the clinical data model appears.

  4. In the Actions list, select Manage Snapshot Labels and click Go.

  5. Query for the data:

    1. Select either:

      - Dummy to label masking values and nonblinded data.

      - Real to label sensitive, blinded data and nonblinded data.

    2. Select either:

      - Most recent timestamp, and then select a timestamp from the drop-down.

      - Snapshot label, and then select a snapshot label from the drop-down.

    3. Click Search. The tables that match the criteria are listed below.

  6. In the Snapshot Label to Add or Remove box, enter a new label or search for an existing one.

  7. Select the tables.

  8. Click Remove Snapshot Label, Add Snapshot Label, or Add/Move Snapshot Label.