Skip Headers
Oracle® Health Sciences Data Management Workbench User's Guide
Release 2.4

E52292-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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
editing, 7.4
menu label, 7.4
missing, 12.1.3
on discrepancies, 7.2
predefined, 7.3.1
result state, 7.4
result tag, 7.4
routing operation, 7.4
start state, 7.4
start tag, 7.4
activities
running transformations, 10.4
running validation checks, 10.4
adding a comment to discrepancies, 12.7
aliases
column, in clinical data model, 3.3.1
table, in clinical data model, 3.2.5
allow autoclose, validation checks, 6.3.2
Answered discrepancy state, 7.3.1

B

bitmap index constraints, 3.2.8

C

Cancelled discrepancy state, 7.3.1
Candidate discrepancy state, 7.3.1
cascading data blinding, 5.3
categories
compare to tags and flags, 8.6
creating, 8.3
discrepancies, 12.1.2
validation checks, 6.3.2
changing user interface display, 10.7
check constraints, 3.2.8
clinical data models, 3, 3, 3
comparing with InForm metadata, 3.4.4
comparing with InForm metadata during validation status upgrade, 3.8
copying library model, 3.1
copying study model, 3.1
creating from an InForm model, 3.1
creating in library, 4.1
creating in study, 3.1
editing, 3.10
installability, 3.1
installation, 3.6
mapping, in transformations, 5.1.1
modifying, 3.10
Closed discrepancy state, 7.3.1
column order, changing user interface display, 10.7.3
columns
adding to a table, 3.3
default value attribute, 3.3.1
length attribute, 3.3.1, A.1.2
mapping, in transformations, 5.1.3
masking attributes, 3.3.3
nullable attribute, 3.3.1
Oracle name attribute, 3.3.1, A.1.2.2
precision attribute, 3.3.1
SAS format attribute, 3.3.1
SAS label attribute, 3.3.1
SAS name attribute, 3.3.1, A.1.2.2
SDTM identifier attribute, 3.3.1, 3.3.2
showing and hiding in user interface display, 10.7.2
comments, 12.7
comparing metadata, 3.4.4
conformance checks See validation checks and See data loading, 6
connect string, 8.2.1.1
constraints
adding to a table, 3.2.8
bitmap index, 3.2.8
check, 3.2.8
Not Null, 3.2.8
primary key, 3.2.8
unique key, 3.2.8
continue on error, validation checks, 6.3.2
copying
custom listings, 11.1.2.1
library clinical data model, 3.1
study clinical data model, 3.1
validation checks, 6.2
copying table-level transformations, 5.1.2.2
custom actions, creating, 7.4
custom discrepancy workflows, creating, 7.4
custom listings
copying, 11.1.2.1
creating, 11.1.2
SQL expressions, 6.5
Custom Listings page, 11.1.2
custom transformation type, 5.4.6
custom transformations, 5.11
context, 5.11.2
lineage tracing, 5.11.2
custom validation checks, 6.8

D

data
viewing in InForm, 11.2.11
data blinding, 3.7, 3.7
authorizing nonblinded downstream tables, 3.7.2
blinding criteria, 3.2.6
cascading, 5.3
column masking attributes, 3.3.3
InForm hidden data, 3.7.1
InForm hidden items, 8.16.8
maintaining in subsequent clinical data models, 3.7.2
setting attributes in manually created tables, 3.2.6
setting attributes in tables uploaded from SAS files, 3.2.6, 3.7.1
setting attributes in text metadata files, 3.7.1, A.2
table attributes, 3.2.6
unblinding tables, 3.2.6, 3.7.4
viewing blinded data, 11.2.9
Data Change Date filters, 11.2.1.9
data lineage
how the system tracks, 5.12
in custom transformations, 5.11.2
viewing, 11.2.8
data load modes, 3.5.4
data loading
configuring File Watcher, 3.5
format checks, 9.4.3
monitoring, 10.3
processing modes, 9.4.1
SAS file data load parameters, 3.5.2
scheduling InForm, 3.4, 3.4.3.2
text file data load parameters, 3.5.3
data masking
cascading, 5.3
specifying column attributes, 3.3.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.5
Data Source filters, 12.5.1
data sources
adding to list, 8.1.6
data visualization tool, integrating with DMW, 8.15
Default Listings page, 11.1.1
default value column attribute, 3.3.1
deleting data
data processing modes, 9.1
during roll back, 3.10.4
in data loading, 3.5.4
UOW Load, 9.1.2.3
delimited text data load parameters, 3.5.3
deployment See installation, 3.1
detaching a pane in the user interface display, 10.7.4
details, discrepancy, 12.2
detected files, File Watcher, 3.5.7
direct transformation type, 5.4.1
discrepancies, 1.2.1
acting on a single discrepancy, 12.1.2
action, 12.1.2
actions, 7.2
Add Comment, 12.7
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.3
Closed state, 7.3.1
creating manually, 11.2.3
custom workflows, 7.4
definition, 1.2.1, 12
details, 12.2
display full record for a discrepancy, 12.4
Export to Excel, 12.1.1
history, 12.3
icons, 12.1.4
identifying, 1.2.1
managing, 12.1
Open state, 7.3.1
raised in DMW on InForm data, 7.1
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.4
TMS, 12.1.5
workflows, 7.3.2
Discrepancy Category filters, 11.2.1.10
Discrepancy Change Date filters, 11.2.1.11
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
manual closure, 6
TMS, 12.1.5
validation checks, 6
Discrepancy State Date filters, 11.2.1.12
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.4
showing and hiding columns, 10.7.2
display full record, 12.4
domain element (TMS), 2.1.2
DP See Distributed Processing Server, 8.1.2, 8.1.2
duplicate name handling, A.1.3

E

execution order, validation checks, 6.3.2
execution set in UOW processing, 9.1.2
Export All to Excel, 11.2.10
export discrepancies to Excel, 12.1.1
Exporting to Excel
in Discrepancies page, 12.1.1
Expression Builder for transformations and blinding criteria, 5.5
Expression Builder for validation checks and custom listings, 6.5

F

file specification, File Watcher, 3.5.4
File Specifications
file name pattern, 3.5.4
File Watcher
about, 3.5
configuring, 3.5
configuring for input clinical data models, 3.5.1
creating for study, 8.1.4
detected files, 3.5.7
file specifications, 3.5.4
migrating to 2.3.1, 3.5.6
registering folder locations, 8.1.1
restarting, 8.1.5
study folders, 8.1.4
submission modes, 3.5.4
suspending and resuming data loading in Admin page, 8.1.5
suspending and resuming data loading in model, 3.5.5
File Watcher file specifications
file name, 3.5.4
filter groups, 11.2.1.1
filters
creating and using, 11.2.1
Data Change Date, 11.2.1.9
Data Source, 12.5.1
Discrepancy Category, 11.2.1.10
Discrepancy Change Date, 11.2.1.11
Discrepancy State Date, 11.2.1.12
Discrepancy User, 11.2.1.14
Discrepancy User filters, 11.2.1.14
Location, 12.5.2
Record Flags, 11.2.1.8
Subject, 11.2.1.3
Subject Visit Flags, 11.2.1.5
viewing current, 11.2.1.2
Visit, 11.2.1.4
Visit Date, 11.2.1.7
Visit Day, 11.2.1.6
filters See also querying by example,
Find in Listings page, 11.2.2
fixed text data load parameters, 3.5.3
flags
applying to data, 11.2.7
categories, 8.3
compare to tags and categories, 8.6
creating, 8.5.1
for subject visit tracking and data review, 8.5
InForm CRF and section states, 11.2.6
InForm status, 11.2.6
priority icons, 11.2.6
rules, 8.5.2
showing, 11.2.6
Force TMS rederivation, 2.1.2.1
format checks during data loading, 9.4.3
full record display, 12.4
full reload processing, 9.1.1.1
full Unit of Work, 9.1.2.1

G

Generic Visualization Business Area, 8.15

H

help, online, 10.9
history, discrepancy, 12.3

I

icons
discrepancies, 12.1.4
incremental reload processing, 9.1.1.2
incremental Unit of Work, 9.1.2.2
InForm, 1.3
adding a remote location, 8.2.1.1
adding a web service location, 8.2.1.2
configuring the InForm Connector, 3.4
connect string, 8.2.1.1
flags, 11.2.6
hidden data, 3.7.1
loading data immediately, 3.4.3
metadata loading, 3.4.2
scheduling data loads, 3.4, 3.4.3.2
selecting internal tables and views in administration, 8.2.2
selecting internal tables and views in study, 3.4.1
suspending and resuming data loading, 3.4.3.1
InForm internal tables and views available, 8.2.2.1
installation, 2.3, 3.6
clinical data models, 3.1
transformations, 5.7
validation checks, 6.4
integration with
InForm, 1.3
labs, 1.4
LSH, 1.9

J

job statuses, 10.3
jobs, monitoring, 10.3
join transformation type, 5.4.2

L

labs, 1.4
libraries, 2.2
library
clinical data models, 4.1
code lists, 4.2
library names, A.1.4
library of SQL functions, 5.5.4
lifecycle mode
selecting, 10.2
lineage
See data lineage, 5.11.2
loading data
File Watcher, suspending and resuming, 8.1.5
InForm, immediate, 3.4.3
InForm, suspending and resuming, 3.4.3.1
processing modes, 9.4.1
Location filters, 12.5.2
lookup values, 8.17
LSH See Life Sciences Data Hub, 1.9, 1.9
creating custom program for transformation, 5.11
creating custom program for validation check, 6.8
SQL function library, 5.5.4

M

mappings
automatic, 5.1.2.3
manual, 5.1.2.4
undoing a single table or column map, 5.2.2
upgrading for metadata changes, 5.10
validating, 5.6
mark as complete, 5.1.2.8.2
mark Not Used, 5.1.2.8.2
masking Listings See data masking, 5.3
menu label, actions, 7.4
metadata comparison report, 3.4.4
metadata loading
from files, 3.1
InForm, 3.4.2
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.2.8
nullable, 3.3.1

O

online help, 10.9
Open discrepancy state, 7.3.1
Oracle Applications profile
logging in, 8.16.1
Oracle Life Sciences Data Hub
object ownership, A.3

P

packages
selecting in Expression Builder, 6.3.1.2
pane, detaching, 10.7.4
pivot transformation type, 5.4.4
preferred path, 11.2.8, 11.2.8.1
setting, 5.1.3
primary key
about, 3.2.8
in data lineage display, 11.2.8.1
Supports Duplicate attribute, 3.2.8
primary source column, validation checks, 6.3.2
primary source table, validation checks, 6.3.2
primary TMS Set column linking to model table column, 3.2.9

R

reason for action
apply to a discrepancy, 12.1.2
Record Flags filters, 11.2.1.8
record, display full, 12.4
reload processing
about, 9.1.1
full, 9.1.1.1
incremental, 9.1.1.2
remote location, adding, 8.2.1.1
Remote Study Account Name, 3.4
reserved words, avoid in names, A.1.1
result state, actions, 7.4
result tag, actions, 7.4
review flags, 8.5
reviewing data
Default Listings page, 11.1.1
Listings pages, 11
reviewing discrepancies
Custom Listings page, 11.1.2
Validation Check Listings page, 11.1.3
rolling back changes to models, 3.10.4
routing operations
about, 7.3.1
actions, 7.4

S

SAS
custom program, 5.11
data load parameters, 3.5.2
SDTM identifier, 3.3.1, 3.3.2
security
adding and removing user group assignments, 3.9
applying to objects, 3.9
See also the Security Guide, 3.7.2
selecting packages in Expression Builder, 6.3.1.2
Set State of discrepancies, 12.1.1
Show Discrepancies button, 11.2.5
side models, 5.1.2.1
side transformations, 5.1.2.1
single discrepancy actions, 12.1.2
sort order, changing, 10.7.1
source-dependent transformations, 5.1.2.7
source-independent transformations, 5.1.2.7
special characters, avoid in names, A.1.1
SQL expressions
in transformations and validation checks, 5.5
in validation checks and custom listings, 6.5
SQL functions
library, 5.5.4
staging layer, 5.1.2.7
staging tables, 5.1.2.7
start state, actions, 7.4
start tag, actions, 7.4
statuses, job, 10.3
studies
components, 2.2
Template attribute, 2.1.1
Therapeutic Area or Category attribute, 2.1.1
studies, creating a study, 2.1.1
studies, selecting a study to work in, 10.1
study clinical data models, 3
study File Watcher, creating, 8.1.4
study names, A.1.4
study templates, 2.2
Subject filters, 11.2.1.3
subject table, adding to model, 3.2.3
subject visit completeness flags, 8.5
Subject Visit Flags filters, 11.2.1.5
subject visit table, adding to model, 3.2.3
submission modes, File Watcher, 3.5.4
Supports Duplicate
in transformations, 5.1.2.7
table attribute, 3.2.8
surrogate key
in custom transformations, 5.11.2
in data lineage tracing, 5.12
syntax for text metadata files, A.2

T

tables
adding columns, 3.3
alias, 3.2.5
blinding attributes, 3.2.6
constraints, 3.2.8
creating from a file, 3.2.2
creating manually, 3.2.5
editing, 3.2.5
installability, 3.1
mapping, in transformations, 5.1.2
modifying, 3.2.5
transformation types, 5.4
tag
result tag in actions, 7.4
routing operation in actions, 7.4
start tag in actions, 7.4
tags
compare to flags and categories, 8.6
tags, discrepancies, 8.4
template, study, 2.1.1
text data load parameters, 3.5.3
therapeutic area category, 2.1.1
TMS
discrepancies, 12.1.5
overview of integration, 8.7
processing, 8.7.3
set up coding, 8.7
statuses, 8.7.3.3
TMS domain elements, 2.1.2
TMS Sets
defining, 8.7.1
defining columns, 8.7.2
linking to a target table, 3.2.9
Trace Data Lineage, 11.2.8
Trace Data Lineage display explanation, 11.2.8.1
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.1.3
copying table-level tranformations, 5.1.2.2
model-level mappings, 5.1.1
running, 10.4
side, 5.1.2.1
side models, 5.1.2.1
source-dependent, 5.1.2.7
source-independent, 5.1.2.7
SQL expressions, 5.5, 6.5
staging layer, 5.1.2.7
table-level mappings, 5.1.2
types, 5.4
truncation, automatic name, A.1.2.2

U

unblind data, 3.2.6
undo a single mapping, 5.2.2
union transformation type, 5.4.3
unique key constraints, 3.2.8
unpivot transformation type, 5.4.5
UOW See Unit of Work, 3.2.5
File Watcher submission, 3.5.4
full, 9.1.2.1
incremental, 9.1.2.2
processing, 9.1.2
UOW Load processing mode, 9.1.2.3
UOW key, 9.1.2
upgrading a mapping, 5.10
user groups
assigning to objects, 3.9
See also the Security Guide, 3.9
user interface
changing column order, 10.7.3
changing display, 10.7
changing sort order, 10.7.1
detaching a pane, 10.7.4
showing and hiding columns, 10.7.2

V

validating mappings, 5.6
validation check batch
Execution Order attribute, 6.3.2
reordering, 6.7.1
validation check batches, 6.1
Validation Check Listings page, 11.1.3
validation checks, 6, 6
allow autoclose, 6.3.2
batches, 6.1
categories, creating, 8.3
category, 6.3.2
continue on error, 6.3.2
copying, 6.2
creating, 6.3, 6.3.2
custom, creating, 6.8
disabling, 6.7.2
discrepancy initial action, 6.3.2
discrepancy initial state, 6.3.2
discrepancy text, 6.3.2
editing, 6.7
execution order, 6.3.2
modifying, 6.7
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, 6.5
upgrading, 6.7.3
validation status,
introduction, 3.8
lifecycle, 2.3
updating, 3.8
validation, custom naming package, A.1.5
VC Listings See Validation Check Listings page, 11.1.3
viewing data
Default Listings page, 11.1.1
Listings pages, 11
tracing data lineage, 11.2.8
viewing discrepancies
Custom Listings page, 11.1.2
Validation Check Listings page, 11.1.3
Visit Date filters, 11.2.1.7
Visit Day filters, 11.2.1.6
Visit filters, 11.2.1.4

W

web service location, InForm, 8.2.1.2
workflows, discrepancy, 7.3.2