Index

A B C D E F G H I J L M N O P Q R S T U V W

A

actions

applying to a discrepancy, 12.1.2

creating custom, 7.4.1

editing, 7.4.1

menu label, 7.4.1

on discrepancies, 7.2

predefined, 7.3.1

result state, 7.4.1

result tag, 7.4.1

routing operation, 7.4.1

start state, 7.4.1

start tag, 7.4.1

activities

running transformations, 10.4

running validation checks, 10.4

add comment to discrepancies, 12.1.1

alias

column, 3.3.4

table, 3.3.2

allow autoclose, validation checks, 6.3.2

Answered discrepancy state, 7.3.1

autoclose

applying to a discrepancy, 12.1.2

B

bitmap index constraints, 3.4

blinding See data blinding, 3.1.2

C

Cancelled discrepancy state, 7.3.1

Candidate discrepancy state, 7.3.1

D

data and metadata loading, 3.6

data blinding, 3.1.2

authorizing nonblinded downstream tables, 3.1.2.2

blinding criteria, 3.3.3.2

column masking attributes, 3.3.6

InForm hidden data, 3.1.2.1

maintaining in subsequent clinical data models, 3.1.2.2

setting attributes in manually created tables, 3.3.3.2

setting attributes in tables uploaded from SAS files, 3.1.2.1, 3.3.3.2

setting attributes in text metadata files, 3.1.2.1, A.2

table attributes, 3.3.3.2

unblinding tables, 3.1.2.4

viewing blinded data, 11.11

Data Change Date filters, 11.4.5

data lineage

how the system tracks, 5.12

in custom transformations, 5.11.2

viewing, 11.10

data loading

configuring File Watcher, 3.7

format checks, 9.4.3

monitoring, 10.3

processing modes, 9.4.1

SAS file data load parameters, 3.7.2

scheduling InForm, 3.6, 3.6.3.2

text file data load parameters, 3.7.3

data loading, InForm, 3.6

data models See clinical data models, 3

data processing

full reload processing, 9.1.1.1

full Unit of Work, 9.1.2.1

incremental reload processing, 9.1.1.2

incremental Unit of Work, 9.1.2.2

modes, 9.1

reload processing, 9.1.1

Unit of Work, 9.1.2

data review flags, 8.8

data sources

adding to list, 8.1

data visualization tool, integrating with DMW, 8.16

Default Listings page, 11.1

default value column attribute, 3.3.4

deleting data

data processing modes, 9.1

UOW Load, 9.1.2.3

delimited text data load parameters, 3.7.3

deployment See installation, 3.2

detaching a pane in the user interface display, 10.7.5

details, discrepancy, 12.3

detected files, File Watcher, 3.7.7

direct transformation type, 5.4.1

discrepancies

acting on a single discrepancy, 12.1.2

action, 12.1.2

actions, 7.2

Add Comment, 12.1.1

Answered state, 7.3.1

autoclose, 12.1.2

Cancelled state, 7.3.1

Candidate state, 7.3.1

categories, 12.1.2

categories, creating, 8.6

Closed state, 7.3.1

creating manually, 11.6

custom workflows, 7.4

definition, 1.2.1, 12

details, 12.3

display full record for a discrepancy, 12.5

Export to Excel, 12.1.1

history, 12.4

icons, 12.1.3

identifying, 1.2.1

managing, 12.1

Open state, 7.3.1

raised in DMW on InForm data, 7.1.2

reason for action, 12.1.2

routing operation, 7.3.1

selecting multiple, 12.1.1

Set State, 12.1.1

states and transitions, 7.1, 7.3.1

tags, 8.7

unread, 12.1.2

workflows, 7.3.2

Discrepancy Category filters, 11.4.6

Discrepancy Change Date filters, 11.4.7

discrepancy field, 12.1.2

discrepancy initial action, validation checks, 6.3.2

discrepancy initial state, validation checks, 6.3.2

discrepancy management

automated closure, 6.1

manual closure, 6.1

validation checks, 6.1

Discrepancy State Date filters, 11.4.8

discrepancy text, 12.1.2

discrepancy text, validation checks, 6.3.2

display

changing column order, 10.7.3

changing sort order, 10.7.1

changing user interface, 10.7

detaching a pane, 10.7.5

freezing columns, 10.7.4

showing and hiding columns, 10.7.2

display full record, 12.5

DP Server, See Distributed Processing Server See also the Oracle LSH System Administrator's Guide, 8.4.2

duplicate name handling, A.1.3

E

edit checks See validation checks, 6.1

execution order, validation checks, 6.3.2

execution set in UOW processing, 9.1.2

Export All to Excel, 11.12

export discrepancies to Excel, 12.1.1

Export to Excel, 12.1.1

Expression Builder for transformations and validation checks, 5.5

F

file specification, File Watcher, 3.7.4

File Specifications

file name pattern, 3.7.4

File Watcher

about, 3.7

configuring, 3.7

configuring for input clinical data models, 3.7.1

creating for study, 8.4.1

detected files, 3.7.7

Distributed Processing (DP) Server, 8.3.4

file specifications, 3.7.4

migrating to 2.3.1, 3.7.6

restarting, 8.5.2.1

root folders, 8.3.1

service, 8.3.3

setting up for the DMW instance, 8.3

study folders, 8.3.2

submission modes, 3.7.4

suspending and resuming data loading in Admin page, 8.5.2.2

suspending and resuming data loading in model, 3.7.5

File Watcher file specifications

file name, 3.7.4

filters

creating and using, 11.4

Data Change Date, 11.4.5

Discrepancy Category, 11.4.6

Discrepancy Change Date, 11.4.7

Discrepancy State Date, 11.4.8

Subject, 11.4.1

Visit, 11.4.2

Visit Date, 11.4.4

Visit Day, 11.4.3

filters See also querying by example, 10.8

Find in Listings page, 11.5

fixed text data load parameters, 3.7.3

flags

categories, 8.6

creating, 8.8.1

for subject visit tracking and data review, 8.8

InForm status, 11.8

rules, 8.8.2

format checks during data loading, 9.4.3

freezing columns in user interface display, 10.7.4

full record display, 12.5

full reload processing, 9.1.1.1

full Unit of Work, 9.1.2.1

G

Generic Visualization Business Area, 8.16

H

help, online, 10.9

history, discrepancy, 12.4

I

icons

discrepancies, 12.1.3

incremental reload processing, 9.1.1.2

incremental Unit of Work, 9.1.2.2

InForm, 1.3, 3.6

adding a remote location, 3.6.1, 8.2.1

adding a web service location, 3.6.2, 8.2.2

configuring the InForm Connector, 3.6

connect string, 3.6.1, 8.2.1

flags, 11.8

hidden data, 3.1.2.1

loading data immediately, 3.6.3

metadata loading and synchronization, 3.6.4

scheduling data loads, 3.6, 3.6.3.2

suspending and resuming data loading, 3.6.3.1

installation, 3.1.1

clinical data models, 3.2

transformations, 5.7

validation checks, 6.4

integration with

InForm, 1.3

labs, 1.4

LSH, 1.8

J

job statuses, 10.3

jobs, monitoring, 10.3

join transformation type, 5.4.2

L

labs, 1.4

libraries, 2.1

library

clinical data models, 4.1

code lists, 4.3

library names, A.1.4

library of SQL functions, 5.5.4

life cycle mode

selecting, 10.2

life cycle mode See also validation status, 10.2

Life Sciences Data Hub

creating custom program for transformation, 5.11

creating custom program for validation check, 6.7

object ownership, A.3

SQL function library, 5.5.4

lineage

See data lineage, 5.11.2

loading data

File Watcher, suspending and resuming, 8.5.2.2

InForm, immediate, 3.6.3

InForm, suspending and resuming, 3.6.3.1

processing modes, 9.4.1

LSH See Life Sciences Data Hub, 1.8

M

mappings

automatic, 5.2.2.2

manual, 5.2.2.3

validating, 5.6

menu label, actions, 7.4.1

metadata loading, 3.6

from files, 3.2

InForm, 3.6.4

required syntax, A.2

models See clinical data models, 3

monitoring data loading, 10.3

N

name

avoid reserved words, A.1

avoid special characters, A.1

customizable package, A.1

duplicate, A.1

guidelines, A.1

length, A.1

libraries, A.1

studies, A.1

non-unique index, 3.4

nullable, 3.3.4

O

online help, 10.9

Open discrepancy state, 7.3.1

Oracle Life Sciences Data Hub See Life Sciences Data Hub, 1.8

P

pane, detaching, 10.7.5

pivot transformation type, 5.4.4

preferred path, 11.10, 11.10

setting, 5.2.3

primary key

about, 3.4

in data lineage display, 11.10

Supports Duplicate attribute, 3.4

primary source column, validation checks, 6.3.2

primary source table, validation checks, 6.3.2

Q

query, InForm See discrepancies, 1.2.1

querying by example, 10.8

R

reason for action

apply to a discrepancy, 12.1.2

record, display full, 12.5

reload processing

about, 9.1.1

full, 9.1.1.1

incremental, 9.1.1.2

remote location, adding, 3.6.1, 8.2.1

Remote Study Account Name, 3.6

required syntax in text metadata files, A.2

reserved words, avoid in names, A.1.1

result state, actions, 7.4.1

result tag, actions, 7.4.1

review flags, 8.8

reviewing data

Default Listings page, 11.1

Listings pages, 11

reviewing discrepancies

Custom Listings page, 11.3

Validation Check Listings page, 11.2

routing operations

about, 7.3.1

actions, 7.4.1

S

SAS

custom program, 5.11

SAS files

data load parameters, 3.7.2

SDTM identifier, 3.3.4, 3.3.5

security

adding and removing user group assignments, 3.9

applying to objects, 3.9

T

tables

adding columns, 3.3.4

alias, 3.3.2

blinding attributes, 3.3.3.2

constraints, 3.4

creating from a file, 3.3.1

creating manually, 3.3.2

editing, 3.3.2

installability, 3.2

mapping, in transformations, 5.2.2

modifying, 3.3.2

transformation types, 5.4

tag

result tag in actions, 7.4.1

routing operation in actions, 7.4.1

start tag in actions, 7.4.1

tags, discrepancies, 8.7

template, study, 2.2.1

text files

data load parameters, 3.7.3

therapeutic area category, 2.2.1

Trace Data Lineage, 11.10

Trace Data Lineage display explanation, 11.10

transformation types, 5.4

custom, 5.4.6

direct, 5.4.1

join, 5.4.2

pivot, 5.4.4

union, 5.4.3

unpivot, 5.4.5

transformations

column-level mappings, 5.2.3

model-level mappings, 5.2.1

running, 10.4

source-dependent, 5.2.2.5

source-independent, 5.2.2.5

SQL expressions, 5.5

staging layer, 5.2.2.5

table-level mappings, 5.2.2

types, 5.4

Transformations

about, 5.1

truncation, automatic name, A.1.2.2

U

union transformation type, 5.4.3

unique key constraints, 3.4

Unit of Work

File Watcher submission, 3.7.4

full, 9.1.2.1

incremental, 9.1.2.2

processing, 9.1.2

UOW Load processing mode, 9.1.2.3

unpivot transformation type, 5.4.5

unread

apply to a discrepancy, 12.1.2

UOW key, 9.1.2

UOW See Unit of Work, 3.3.2

user groups

assigning to objects, 3.9

V

validating mappings, 5.6

validation check batch

Execution Order attribute, 6.3.2

reordering, 6.6.1

validation check batches, 6.2

Validation Check Listings page, 11.2

validation checks, 6

allow autoclose, 6.3.2

batches, 6.2

categories, creating, 8.6

category, 6.3.2

continue on error, 6.3.2

creating, 6.3, 6.3.2

creating joins, 6.3.1.2

custom, creating, 6.7

disabling, 6.6.2

discrepancy initial action, 6.3.2

discrepancy initial state, 6.3.2

discrepancy text, 6.3.2

editing, 6.6

execution order, 6.3.2

modifying, 6.6

primary source column, 6.3.2

primary source table, 6.3.2

running, 10.4

selecting columns, 6.3.1.1

SQL expressions, 5.5

upgrading, 6.6.3

validation status

introduction, 3.8

life cycle, 2.3

updating, 3.8

validation, custom naming package, A.1.5

VC Listings See Validation Check Listings page, 11.2

viewing data

Default Listings page, 11.1

Listings pages, 11

tracing data lineage, 11.10

viewing discrepancies

Custom Listings page, 11.3

Validation Check Listings page, 11.2

Visit Date filters, 11.4.4

Visit Day filters, 11.4.3

Visit filters, 11.4.2

W

web service location, InForm, 3.6.2, 8.2.2

workflows, discrepancy, 7.3.2