Index

A  C  D  E  F  H  I  K  L  O  P  R  S  T  U  X 

---

A

AGE BAND dimension, 3.1.1

---

C

calendar population

utility scripts, 12.1

compressed tables

physical data model, 4.6, 4.9

compressed tables list, 4.6

control tables

Intra-ETL load, A

Intra-ETL Monitoring, A

Intra-ETL OLAP Mapping, A

cube views

OLAP, 4.11

---

D

data mining models

Oracle Healthcare Data Model, 11

patient fall, 11.2

derived tables

physical data model, 4.4

Derived tables list, 4.4

dictionary

logical data model, 2.1

dimension

AGE BAND, 3.1.1

FACILITY, 3.1.2

KPI, 3.1.3

ORGANIZATION, 3.1.4

PATIENT, 3.1.5

SERVICE PROVIDER PRACTICE, 3.1.6

SHIFT, 3.1.7

TIME, 3.1.8

TIME OF DAY, 3.1.9

DWD tables list, 4.4

DWR tables list, 4.3

DWX tables list, 4.5

---

E

entity dictionary, 2.1

logical data model, 2.1

ETL views

OLAP, 4.10

---

F

FACILITY dimension, 3.1.2

---

H

HDM physical tables

description, 4.2

table list, 4.2

---

I

index definitions

physical data model, 4.8

index definitions list, 6

intra-ETL, 7

DWC_OLAP_ETL_PARAM table, A.3

---

K

KPI dimension, 3.1.3

KPIs

Oracle Healthcare Data Model, 8

---

L

logical data model, 2.1

dimensions, 3

logical dimensions, 3

logical dimensions, Oracle Healthcare Data Model, 3

logical entities, Oracle Healthcare Data Model, 2, 2

logical to physical mapping

Oracle Healthcare Data Model, 5

---

O

OLAP

populating the OLAP module, 9.1.1

OLAP cube views

from ohdm_sys schema, 4.11

OLAP dimensions, 9.2

OLAP ETL views

from ohdm_sys schema, 4.10

OLAP model cubes

Oracle Healthcare Data Model, 10

OLAP model dimensions

Oracle Healthcare Data Model, 9

Oracle Healthcare Data Model, 7

benefits, 1.2

components summary, 1.3

data mining models, 11

intra-ETL, 7

KPIs, 8

logical data model, 2

logical data model dimensions, 3

logical to physical mapping, 5

OLAP dimensions, 9.2

OLAP model cubes, 10

OLAP model dimensions, 9

physical data model, 4

physical data model partitioning, 6

physical entities, 4

sample reports, 13

utility scripts, 12

ORGANIZATION dimension, 3.1.4

---

P

parallel tables list, 4.9

partition definitions

physical data model, 4.7

PATIENT dimension, 3.1.5

patient fall data mining model, 11.2

physical data model

compressed tables, 4.6, 4.6, 4.9

derived tables, 4.4

index definitions, 4.8

indexes, 6

name prefix conventions, 4.1

parallel tables, 4.9

partition definitions, 4.7

partitioning, 6

reference tables, 4.3

xref tables, 4.5

physical tables

DWX tables list, 4.5

HDM prefix, 4.2

X lookup tables, 4.5

---

R

reference tables

physical data model, 4.3

Reference tables list, 4.3

---

S

sample reports

Oracle Healthcare Data Model, 13

SERVICE PROVIDER PRACTICE dimension, 3.1.6

SHIFT dimension, 3.1.7

---

T

TIME dimension, 3.1.8

TIME OF DAY dimension, 3.1.9

---

U

utility scripts

calendar population, 12.1

Oracle Healthcare Data Model, 12

---

X

xref tables

physical data model, 4.5