9 Oracle Healthcare Data Model OLAP Dimensions

This chapter describes the Data Flow between fact tables and dimension tables of Oracle Healthcare Data Model relational part to target dimensions to support the module Oracle Healthcare Data Model OLAP.

This chapter includes the following sections:

Introduction to OLAP Architecture
Oracle Healthcare Data Model OLAP Dimensions

For more information, see Chapter 10, "Oracle Healthcare Data Model OLAP Cubes and OLAP Facts".

Introduction to OLAP Architecture

Oracle Healthcare Data Model contains:

Oracle Healthcare Data Model OLAP component contains 11 dimensions.
Oracle Healthcare Data Model OLAP component contains 4 cubes.

General Process to Populate the OLAP Module in Oracle Healthcare Data Model

The following steps illustrate the process of loading the Oracle Healthcare Data Model OLAP Module:

Data is loaded from OLAP ETL views which are built over relational dimension/fact tables.
OLAP ETL View (Time dimension: DWV_TIME_ENC_DIM) contains ILM_STRT_DT and ILM_END_DT filters, where ILM represents Information Lifecycle Management. Indicates the end date of the data age. These filters control the OLAP ILM time range.
All cubes are available for the end user SQL based Query Tool access through CUBE_TABLE based SQL Views which are created and maintained automatically during the cube build/update process.
Cubes are loaded through OLAP ETL Fact Views defined on the KPI Fact tables.

Using SQL to access the cubes and dimensions is a significant feature of Oracle OLAP because it enables reporting tools that only generate SQL to use all of the powerful features of the analytic workspace. In Oracle Database 11g this is achieved by the use of the CUBE_TABLE function that extracts multidimensional data from a cube in an analytic workspace and presents it to the relational SQL engine in the form of a two dimensional table, such as a set of rows and columns. the CUBE_TABLE function provides a mapping between the cube in the analytic workspace and the rows and columns that the SQL sees.

Oracle Healthcare Data Model OLAP Dimensions

The dimensions section describes the detail information for all the OLAP dimensions. Each dimension includes the following information:

Physical Name
Levels
Hierarchies
Attributes and Attribute mappings

Table 9-1 lists the dimensions.

Table 9-1 OLAP Dimensions

Dimensions
Age Band Dimension: AGEBND
Case Dimension: CASE
Facility Dimension: FAC
KPI Dimension: KPI
Observation Dimension: OBSV
Organization Dimension: ORG
Patient Dimension: PT
Service Provider Practice Dimension: SPP
Shift Dimension: SHFT
Time Dimension: TIME
Time of Day Dimension: TOD

Age Band Dimension: AGEBND

Entity Description: AGE BAND

Table 9-2 shows Age Band levels and hierarchies.

Table 9-2 Age Band Levels and Hierarchies

Level	Level	Description	Age Band Hierarchy(HAGEBND)
1	TAGEBND	Total Age Band	TAGEBND
2	AGEBND	Age Band	AGEBND

Table 9-3 shows Age Band attributes.

Table 9-3 Age Band Attributes and Data Type

Attribute	Data Type	Comment
AGEBAND_ID	NUMBER(10)	Age Band ID
AGEBAND_YEARS	NUMBER(10)	Age Band Years
AGEBAND_MTHS	NUMBER(10)	Age Band Months
AGEBAND_WKS	NUMBER(10)	Age Band Weeks
AGEBAND_DAYS	NUMBER(10)	Age Band Days
AGEBAND1	VARCHAR2(80)
AGEBAND1_DESC	VARCHAR2(2000)
AGEBAND2	VARCHAR2(80)
AGEBAND2_DESC	VARCHAR2(2000)
AGEBAND3	VARCHAR2(80)
AGEBAND3_DESC	VARCHAR2(2000)
AGEBAND4	VARCHAR2(80)
AGEBAND4_DESC	VARCHAR2(2000)
AGEBAND5	VARCHAR2(80)
AGEBAND5_DESC	VARCHAR2(2000)
AGEBAND6	VARCHAR2(80)
AGEBAND6_DESC	VARCHAR2(2000)

Age Band Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-4 Age Band Long Description Mapping

Level	Mapping (Physical Column)
TAGEBAND	'Total Age Band'
AGEBAND	DWV_AGEBND_DIM.AGEBND1_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-5 Age Band Short Description Mapping

Level	Mapping (Physical Column)
TAGEBAND	'Total Age Band'
AGEBAND	DWV_AGEBND_DIM.AGEBND1_NM

Attribute Name: Age Band ID (AGEBAND_ID)

Table 9-6 Age Band ID Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND_ID

Attribute Name: Age Band Years (AGEBAND_YEARS)

Table 9-7 Age Band Years Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND_YEARS

Attribute Name: Age Band Weeks (AGEBAND_WKS)

Table 9-8 Age Band Weeks Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND_WKS

Attribute Name: Age Band Days (AGEBAND_DAYS)

Table 9-9 Age Band Days Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND_DAYS

Attribute Name: Age Band1 (AGEBAND1)

Table 9-10 Age Band1 Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND1_NM

Attribute Name: Age Band1 Description (AGEBAND1_DESC)

Table 9-11 Age Band1 Description Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND1_RNG_NM

Attribute Name: Age Band2 (AGEBAND2)

Table 9-12 Age Band2 Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND2_NM

Attribute Name: Age Band2 Description (AGEBAND2_DESC)

Table 9-13 Age Band2 Description Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND2_RNG_NM

Attribute Name: Age Band3 (AGEBAND3)

Table 9-14 Age Band3 Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND3_NM

Attribute Name: Age Band3 Description (AGEBAND3_DESC)

Table 9-15 Age Band3 Description Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND3_RNG_NM

Attribute Name: Age Band4 (AGEBAND4)

Table 9-16 Age Band4 Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND4_NM

Attribute Name: Age Band4 Description (AGEBAND4_DESC)

Table 9-17 Age Band4 Description Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND4_RNG_NM

Attribute Name: Age Band5 (AGEBAND5)

Table 9-18 Age Band5 Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND5_NM

Attribute Name: Age Band5 Description (AGEBAND5_DESC)

Table 9-19 Age Band5 Description Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND5_RNG_NM

Attribute Name: Age Band6 (AGEBAND6)

Table 9-20 Age Band6 Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND6_NM

Attribute Name: Age Band6 Description (AGEBAND6_DESC)

Table 9-21 Age Band6 Description Mapping

Level	Mapping (Physical Column)
TAGEBAND
AGEBAND	DWV_AGEBND_DIM.AGEBND6_RNG_NM

Case Dimension: CASE

Entity Description: CASE

Table 9-22 shows Case levels and hierarchies.

Table 9-22 Case Levels and Hierarchies

Level	Description	Case Hierarchy(HCASE)
TCASE	Total Case	TCASE
CASE	Case	CASE

Table 9-23 shows Case attributes.

Table 9-23 Case Attributes and Data Types

Attribute	Data Type	Description
CASE_ID	NUMBER(10)	Case ID (Unique Key)
CASE_END_DT	DATE	Patient Clinical Trial Status Code details
CASE_STRT_DT	DATE

Case Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-24 Case Long Description Mapping

Level	Mapping (Physical Column)
TCASE	"Total Case"
CASE	DWV_CASE_DIM.CASE_ID

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-25 Case Short Description Mapping

Level	Mapping (Physical Column)
TCASE	"Total Case"
CASE	DWV_CASE_DIM.CASE_ID

Attribute Name: Case ID (CASE_ID)

Table 9-26 Case ID Mapping

Level	Mapping (Physical Column)
TCASE
CASE	DWV_CASE_DIM.CASE_ID

Attribute Name: Case End Date (CASE_END_DT)

Table 9-27 Case End Date Mapping

Level	Mapping (Physical Column)
TCASE
CASE	DWV_CASE_DIM.CASE_END_DT

Attribute Name: Case Start Date (CASE_STRT_DT)

Table 9-28 Case Start Date Mapping

Level	Mapping (Physical Column)
TCASE
CASE	DWV_CASE_DIM.CASE_STRT_DT

Facility Dimension: FAC

Entity Description: FACILITY DIMENSION

Table 9-29 shows Facility levels and hierarchies.

Table 9-29 Facility Levels and Hierarchies

Level	Description	Facility Hierarchies (HFAC)
TFAC	Total Facility	TFAC
L6	L6 - Campus (Typically)	L6
L5	L5 - Building (Typically)	L5
L4	L4 - Floor (Typically)	L4
L3	L3 - Suite (Typically)	L3
L2	L2 - Caresite (Typically)	L2
L1	L1 - Room (Typically)	L1
L0	L0 - Bed (Typically)	L0

In addition, there is an attribute FAC_SUBTYPE (applicable at levels - L0 to L6) which contains the actual Subtype Value for the dimension member.

Caresite should typically be at Level L2. However if a Caresite is below a Building, Outpatient Facility Caresite, then it would exist at Level L4 instead of L2. Thus, use generic names such as L0 to L6 instead of specific values.

For example, FLOOR level or L5 level would contain Facilities with Subtype=Floor as well as those with Subtype=Caresite or Suite or others in a similar pattern.

Table 9-30 shows Facility attributes.

Table 9-30 Facility Attributes

Attribute	Data Type	Description
FAC_MBR_NM	VARCHAR2(80)
FAC_MBR_SUBTYP	VARCHAR2(80)	Facility Subtype - from Campus, Building, Floor, Suite, Caresite, Room and Bed
FAC_MBR_BED_TYP	VARCHAR2(200)
L1_FAC_ID	NUMBER(10)	Id at Facility level L1 - Typically Room
L1_FAC_NM	VARCHAR2(80)
L1_FAC_SUBTYP	VARCHAR2(200)
L1_FAC_SUBTYP_NM	VARCHAR2(200)
FAC_MBR_BED_TYP_NM	VARCHAR2(200)
L2_FAC_ID	NUMBER(10)	Id at Facility level L2 - Typically Caresite
L2_FAC_NM	VARCHAR2(80)
L2_FAC_SUBTYP	VARCHAR2(200)
L2_FAC_SUBTYP_NM	VARCHAR2(200)
L3_FAC_ID	NUMBER(10)	Id at Facility level L3 - Typically Suite
L3_FAC_NM	VARCHAR2(80)
L3_FAC_SUBTYP	VARCHAR2(80)
L3_FAC_SUBTYP_NM	VARCHAR2(200)
L4_FAC_ID	NUMBER(10)	Id at Facility level L4 - Typically Floor
L5_FAC_ID	NUMBER(10)	Id at Facility level L5 - Typically Building
L6_FAC_ID	NUMBER(10)	Id at Facility level L6 - Typically Campus
L4_FAC_NM	VARCHAR2(80)
L5_FAC_NM	VARCHAR2(80)
L6_FAC_NM	VARCHAR2(80)
L4_FAC_SUBTYP	VARCHAR2(200)
L5_FAC_SUBTYP	VARCHAR2(200)
L6_FAC_SUBTYP	VARCHAR2(200)
L4_FAC_SUBTYP_NM	VARCHAR2(200)
L5_FAC_SUBTYP_NM	VARCHAR2(200)
L6_FAC_SUBTYP_NM	VARCHAR2(200)
FAC_MBR_ID	NUMBER(10)
FAC_MBR_SUBTYP_NM	VARCHAR2(200)

Facility Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-31 Facility Long Description Mapping

Level	Mapping (Physical Column)
TFAC	'Total Facility'
L6	DWV_FAC_DIM.L6_FAC_NM
L5	DWV_FAC_DIM.L5_FAC_NM
L4	DWV_FAC_DIM.L4_FAC_NM
L3	DWV_FAC_DIM.L3_FAC_NM
L2	DWV_FAC_DIM.L2_FAC_NM
L1	DWV_FAC_DIM.L1_FAC_NM
L0	DWV_FAC_DIM.FAC_MBR_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-32 Facility Short Description Mapping

Level	Mapping (Physical Column)
TFAC	'Total Facility'
L6	DWV_FAC_DIM.L6_FAC_NM
L5	DWV_FAC_DIM.L5_FAC_NM
L4	DWV_FAC_DIM.L4_FAC_NM
L3	DWV_FAC_DIM.L3_FAC_NM
L2	DWV_FAC_DIM.L2_FAC_NM
L1	DWV_FAC_DIM.L1_FAC_NM
L0	DWV_FAC_DIM.FAC_MBR_NM

Attribute Name: Facility Member Name (FAC_MBR_NM)

Table 9-33 Facility Member Name Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1
L0	DWV_FAC_DIM.FAC_MBR_NM

Attribute Name: Facility Member Subtype (FAC_MBR_SUBTYP)

Table 9-34 Facility Member Subtype Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1
L0	DWV_FAC_DIM.FAC_MBR_SUBTYP

Attribute Name: Facility Member Bed Type (FAC_MBR_BED_TYP)

Table 9-35 Facility Member Bet Type Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1
L0	DWV_FAC_DIM.FAC_MBR_BED_TYP

Attribute Name: Facility ID Level 1 (L1_FAC_ID)

Table 9-36 Facility ID Level 1 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1	DWV_FAC_DIM.L1_FAC_ID
L0

Attribute Name: Facility Name Level 1 (L1_FAC_NM)

Table 9-37 Facility Name Level 1 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1	DWV_FAC_DIM.L1_FAC_NM
L0

Attribute Name: Facility Subtype Level 1 (L1_FAC_SUBTYP)

Table 9-38 Facility Subtype Level 1 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1	DWV_FAC_DIM.L1_FAC_SUBTYP
L0

Attribute Name: Facility Member Bed Type Name (FAC_MBR_BED_TYP_NM)

Table 9-39 Facility Member Bed Type Name Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1
L0	DWV_FAC_DIM.FAC_MBR_BED_TYP_NM

Attribute Name: Facility Subtype Name Level 1 (L1_FAC_SUBTYP_NM)

Table 9-40 Facility Subtype Name Level 1 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1	DWV_FAC_DIM.L1_FAC_SUBTYP_NM

Attribute Name: Facility ID Level 2 (L2_FAC_ID)

Table 9-41 Facility ID Level 2 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2	DWV_FAC_DIM.L2_FAC_ID
L1
L0

Attribute Name: Facility Name Level 2 (L2_FAC_NM)

Table 9-42 Facility Name Level 2 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2	DWV_FAC_DIM.L2_FAC_NM
L1
L0

Attribute Name: Facility Subtype Level 2 (L2_FAC_SUBTYP)

Table 9-43 Facility Subtype Level 2 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2	DWV_FAC_DIM.L2_FAC_SUBTYP
L1
L0

Attribute Name: Facility Subtype Name Level 2 (L2_FAC_SUBTYP_NM)

Table 9-44 Facility Subtype Name Level 2 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2	DWV_FAC_DIM.L2_FAC_SUBTYP_NM
L1
L0

Attribute Name: Facility ID Level 3 (L3_FAC_ID)

Table 9-45 Facility ID Level 3 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3	DWV_FAC_DIM.L3_FAC_ID
L2
L1
L0

Attribute Name: Facility Name Level 3 (L3_FAC_NM)

Table 9-46 Facility Name Level 3 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3	DWV_FAC_DIM.L3_FAC_NM
L2
L1
L0

Attribute Name: Facility Subtype Level 3 (L3_FAC_SUBTYP)

Table 9-47 Facility Subtype Level 3 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3	DWV_FAC_DIM.L3_FAC_SUBTYP
L2
L1
L0

Attribute Name: Facility Subtype Name Level 3 (L3_FAC_SUBTYP_NM)

Table 9-48 Facility Subtype Name Level 3 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3	DWV_FAC_DIM.L5_FAC_SUBTYP_NM
L2
L1
L0

Attribute Name: Facility ID Level 4 (L4_FAC_ID)

Table 9-49 Facility ID Level 4 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4	DWV_FAC_DIM.L4_FAC_ID
L3
L2
L1
L0

Attribute Name: Facility ID Level 5 (L5_FAC_ID)

Table 9-50 Facility ID Level 5 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5	DWV_FAC_DIM.L5_FAC_ID
L4
L3
L2
L1
L0

Attribute Name: Facility ID Level 6 (L6_FAC_ID)

Table 9-51 Facility ID Level 6 Mapping

Level	Mapping (Physical Column)
TFAC
L6	DWV_FAC_DIM.L6_FAC_ID
L5
L4
L3
L2
L1
L0

Attribute Name: Facility Name Level 4 (L4_FAC_NM)

Table 9-52 Facility Name Level 4 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4	DWV_FAC_DIM.L4_FAC_NM
L3
L2
L1
L0

Attribute Name: Facility Name Level 5 (L5_FAC_NM)

Table 9-53 Facility Name Level 5 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5	DWV_FAC_DIM.L5_FAC_NM
L4
L3
L2
L1
L0

Attribute Name: Facility Name Level 6 (L6_FAC_NM)

Table 9-54 Facility Name Level 6 Mapping

Level	Mapping (Physical Column)
TFAC
L6	DWV_FAC_DIM.L6_FAC_NM
L5
L4
L3
L2
L1
L0

Attribute Name: Facility Subtype Level 4 (L4_FAC_SUBTYP)

Table 9-55 Facility Subtype Level 4 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4	DWV_FAC_DIM.L4_FAC_SUBTYP
L3
L2
L1
L0

Attribute Name: Facility Subtype Level 5 (L5_FAC_SUBTYP)

Table 9-56 Facility Subtype Level 5 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5	DWV_FAC_DIM.L5_FAC_SUBTYP
L4
L3
L2
L1
L0

Attribute Name: Facility Subtype Level 6 (L6_FAC_SUBTYP)

Table 9-57 Facility Subtype Level 6 Mapping

Level	Mapping (Physical Column)
TFAC
L6	DWV_FAC_DIM.L6_FAC_SUBTYP
L5
L4
L3
L2
L1
L0

Attribute Name: Facility Subtype Name Level 4 (L4_FAC_SUBTYP_NM)

Table 9-58 Facility Subtype Name Level 4 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4	DWV_FAC_DIM.L4_FAC_SUBTYP_NM
L3
L2
L1
L0

Attribute Name: Facility Subtype Name Level 5 (L5_FAC_SUBTYP_NM)

Table 9-59 Facility Subtype Name Level 5 Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5	DWV_FAC_DIM.L5_FAC_SUBTYP_NM
L4
L3
L2
L1
L0

Attribute Name: Facility Subtype Name Level 6 (L6_FAC_SUBTYP_NM)

Table 9-60 Facility Subtype Name Level 6 Mapping

Level	Mapping (Physical Column)
TFAC
L6	DWV_FAC_DIM.L6_FAC_SUBTYP_NM
L5
L4
L3
L2
L1
L0

Attribute Name: Facility Member ID (FAC_MBR_ID)

Table 9-61 Facility Member ID Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1
L0	DWV_FAC_DIM.FAC_MBR_ID

Attribute Name: Facility Member Subtype Name (FAC_MBR_SUBTYP_NM)

Table 9-62 Facility Member Subtype Name Mapping

Level	Mapping (Physical Column)
TFAC
L6
L5
L4
L3
L2
L1
L0	DWV_FAC_DIM.FAC_MBR_SUBTYP_NM

KPI Dimension: KPI

Physical Name: KPI

Entity Description: KPI DIMENSION TABLE

Table 9-63 shows KPI levels and hierarchies.

Table 9-63 KPI Levels and Hierarchies

Level	Description	KPI Hierarchy(HKPI)
TKPI	All KPIs	TKPI
KPI	KPI Ids	KPI

Table 9-64 shows KPI attributes.

Table 9-64 KPI Attributes

Attribute	Data Type	Comment
Long_Description	VARCHAR2(300)	Long Description
Short_Description	VARCHAR2(300)	Short Description

KPI Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-65 KPI Long Description Mapping

Level	Mapping
TKPI	'Total KPI'
KPI	DWR_KPI.KPI_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-66 KPI Short Description Mapping

Level	Mapping
TKPI	'Total KPI'
KPI	DWR_KPI.KPI_NM

Observation Dimension: OBSV

Entity Description: OBSERVATION

Table 9-67 shows Observation levels and hierarchies.

Table 9-67 Observation Levels and Hierarchies

Level	Description	Observation Hierarchy(HOBSV)
TOBSV	Total Observation	TOBSV
OBSV	Observation	OBSV

Table 9-68 shows Observation attributes.

Table 9-68 Observation Attributes

Attribute	Data type	Description
OBSV_ID	NUMBER(10)	Observation ID (Unique Key)
OBSV_DT	DATE
OBSV_CD	VARCHAR2(80)
OBSV_CD_NM	VARCHAR2(200)
OBSV_SUBTYP_CD	VARCHAR2(80)
OBSV_SUBTYP_NM	VARCHAR2(200)
OBSV_STCD	VARCHAR2(80)
OBSV_STCD_NM	VARCHAR2(200)
OBSV_EFF_STRT_DT	DATE
OBSV_EFF_END_DT	DATE
OBSV_ONSET_DT	DATE	Observation Onset Date Time

Observation Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-69 Observation Long Description Mapping

Level	Mapping (Physical Column)
TOBSV	"Total Observation"
OBSV	DWV_OBSV_DIM.OBSV_CD_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-70 Observation Short Description Mapping

Level	Mapping (Physical Column)
TOBSV	"Total Observation"
OBSV	DWV_OBSV_DIM.OBSV_CD

Attribute Name: Observation ID (OBSV_ID)

Table 9-71 Observation ID Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_ID

Attribute Name: Observation Date Time (OBSV_DT)

Table 9-72 Observation Date Time Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_DT

Attribute Name: Observation Code (OBSV_CD)

Table 9-73 Observation Code Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_CD

Attribute Name: Observation Code Name (OBSV_CD_NM)

Table 9-74 Observation Code Name Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_CD_NM

Attribute Name: Observation Subtype Code (OBSV_SUBTYP_CD)

Table 9-75 Observation Subtype Code Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_NM

Attribute Name: Observation Subtype Name (OBSV_SUBTYP_NM)

Table 9-76 Observation Subtype Name Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_SUBTYP_NM

Attribute Name: Observation Status Code (OBSV_STCD)

Table 9-77 Observation Status Code Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_STCD

Attribute Name: Observation Status Code Name (OBSV_STCD_NM)

Table 9-78 Observation Status Code Name Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_STCD_NM

Attribute Name: Observation Effective Start Date (OBSV_EFF_STRT_DT)

Table 9-79 Observation Effective Start Date Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_EFF_STRT_DT

Attribute Name: Observation Effective End Date (OBSV_EFF_END_DT)

Table 9-80 Observation Effective End Date Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_EFF_END_DT

Attribute Name: Observation Onset Date Time (OBSV_ONST_DT)

Table 9-81 Observation Onset Date Time Mapping

Level	Mapping (Physical Column)
TOBSV
OBSV	DWV_OBSV_DIM. OBSV_ONST_DT

Organization Dimension: ORG

Entity Description: ORGANIZATION DIMENSION

Table 9-82 shows Organization levels and hierarchies.

Table 9-82 Organization Levels and Hierarchies

Level	Description	Organization Hierarchy(HORG)
TORG	Total Organization	TORG
ENTRPRS	Enterprise	ENTRPRS
RGNBU	Regional BU	RGNBU
FCLBU	Facility BU	FCLBU
DEP	Department	DEP
BU	Business Unit	BU

Table 9-83 shows Organization attributes.

Table 9-83 Organization Attributes

Attribute	Data Type	Description
ORG_MBR_ID	NUMBER(10)	Organization Member Id … This is a lowest level (L0) representation of any Organization Member.
ORG_MBR_NM	VARCHAR2(80)	Name
ORG_MBR_ADDR_TYP	VARCHAR2(200)	Address
ORG_MBR_LOC_STREET_ADDR1	VARCHAR2(200)
ORG_MBR_LOC_STREET_ADDR2	VARCHAR2(200)
ORG_MBR_LOC_STREET_ADDR3	VARCHAR2(200)
ORG_MBR_CIT	VARCHAR2(200)	City
ORG_MBR_ST_CD	VARCHAR2(80)	State Code
ORG_MBR_ST_NM	VARCHAR2(200)	State Name
ORG_MBR_ZP_CD	VARCHAR2(80)	Zip Code
L1_ORG_ID	NUMBER(10)	Id at Organization level L1 - Typically Department
L2_ORG_ID	NUMBER(10)	Id at Organization level L2 - Typically Facility BU
L4_ORG_ID	NUMBER(10)	Id at Organization level L4 - Typically Enterprise
L3_ORG_ID	NUMBER(10)	Id at Organization level L3 - Typically Regional BU
L1_ORG_NM	VARCHAR2(80)
L1_ORG_ADDR_TYP	VARCHAR2(200)
L1_ORG_MBR_LOC_STREET_ADDR1	VARCHAR2(200)
L1_ORG_MBR_LOC_STREET_ADDR2	VARCHAR2(200)
L1_ORG_MBR_LOC_STREET_ADDR3	VARCHAR2(200)
L1_ORG_CIT	VARCHAR2(200)
L1_ORG_ST_CD	VARCHAR2(80)
L1_ORG_ST_NM	VARCHAR2(80)
L1_ORG_ZP_CD	VARCHAR2(80)
L2_ORG_NM	VARCHAR2(80)
L2_ORG_ADDR_TYP	VARCHAR2(200)
L2_ORG_MBR_LOC_STREET_ADDR1	VARCHAR2(200)
L2_ORG_MBR_LOC_STREET_ADDR2	VARCHAR2(200)
L2_ORG_MBR_LOC_STREET_ADDR3	VARCHAR2(200)
L2_ORG_CIT	VARCHAR2(200)
L2_ORG_ST_CD	VARCHAR2(80)
L2_ORG_ST_NM	VARCHAR2(200)
L2_ORG_ZP_CD	VARCHAR2(80)
L3_ORG_NM	VARCHAR2(80)
L4_ORG_NM	VARCHAR2(80)
L3_ORG_MBR_LOC_STREET_ADDR1	VARCHAR2(200)
L4_ORG_MBR_LOC_STREET_ADDR1	VARCHAR2(200)
L3_ORG_MBR_LOC_STREET_ADDR2	VARCHAR2(200)
L4_ORG_MBR_LOC_STREET_ADDR2	VARCHAR2(200)
L3_ORG_MBR_LOC_STREET_ADDR3	VARCHAR2(200)
L4_ORG_MBR_LOC_STREET_ADDR3	VARCHAR2(200)
L3_ORG_CIT	VARCHAR2(200)
L4_ORG_CIT	VARCHAR2(200)
L3_ORG_ST_CD	VARCHAR2(80)
L4_ORG_ST_CD	VARCHAR2(80)
L3_ORG_ST_NM	VARCHAR2(200)
L4_ORG_ST_NM	VARCHAR2(80)
L3_ORG_ZP_CD	VARCHAR2(80)
L4_ORG_ZP_CD	VARCHAR2(80)

Organization Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-84 Organization Long Description Mapping

Level	Mapping (Physical Column)
TORG	'Total Organization'
ENTRPRS	DWV_ORG_DIM.L4_ORG_NM
RGNBU	DWV_ORG_DIM.L3_ORG_NM
FCLBU	DWV_ORG_DIM.L2_ORG_NM
DEP	DWV_ORG_DIM.L1_ORG_NM
BU	DWV_ORG_DIM.ORG_MBR_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-85 Organization Short Description Mapping

Level	Mapping (Physical Column)
TORG	'Total Organization'
ENTRPRS	DWV_ORG_DIM.L4_ORG_NM
RGNBU	DWV_ORG_DIM.L3_ORG_NM
FCLBU	DWV_ORG_DIM.L2_ORG_NM
DEP	DWV_ORG_DIM.L1_ORG_ID
BU	DWV_ORG_DIM.ORG_MBR_NM

Attribute Name: Organization Member Business Unit (ORG_MBR_ID)

Table 9-86 Organization Member Business Unit Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_ID

Attribute Name: Organization Member Name (L0) (ORG_MBR_NM)

Table 9-87 Organization Member Name (L0) Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_NM

Attribute Name: Organization Member Address Type (ORG_MBR_ADDR_TYP)

Table 9-88 Organization Member Address Type Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_ADDR_TYP

Attribute Name: Location Street Address Line 1(ORG_MBR_LOC_STREET_ADDR1)

Table 9-89 Organization Street Address Line 1 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_LOC_STRT_ADDR1

Attribute Name: Location Street Address Line 2(ORG_MBR_LOC_STREET_ADDR2)

Table 9-90 Organization Street Address Line 2 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_LOC_STRT_ADDR2

Attribute Name: Location Street Address Line 3(ORG_MBR_LOC_STREET_ADDR3)

Table 9-91 Organization Street Address Line 3 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_LOC_STRT_ADDR3

Attribute Name: Organization Member City (ORG_MBR_CIT)

Table 9-92 Organization Member City Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_CIT

Attribute Name: Organization Member State Name (ORG_MBR_ST_NM)

Table 9-93 Organization Member State Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_ST_NM

Attribute Name: Organization Member Postal Code (ORG_MBR_ZP_CD)

Table 9-94 Organization Member Postal Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP
BU	DWV_ORG_DIM.ORG_MBR_PSTL_CD

Attribute Name: ID at Organization Level L1 Department (L1_ORG_ID)

Table 9-95 Organization: ID at Organization Level L1 Department Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_ID
BU

Attribute Name: ID at Organization Level L2 Department (L2_ORG_ID)

Table 9-96 Organization ID at Organization Level L2 Department Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_ID
DEP
BU

Attribute Name: ID at Organization Level L4 Department (L4_ORG_ID)

Table 9-97 Organization ID at Organization Level L4 Department Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_ID
RGNBU
FCLBU
DEP
BU

Attribute Name: ID at Organization Level L3 Department (L3_ORG_ID)

Table 9-98 Organization: ID at Organization Level L3 Department Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_ID
FCLBU
DEP
BU

Attribute Name: L1 Organization Name (L1_ORG_NM)

Table 9-99 Organization: L1 Organization Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_NM
BU

Attribute Name: L1 Organization Address Type (L1_ORG_ADDR_TYP)

Table 9-100 Organization L1 Organization Address Type Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_ADDR_TYP
BU

Attribute Name: L1 Organization Location Street Address 1(L1_ORG_LOC_STREET_ADDR1)

Table 9-101 Organization: L1 Organization Location Street Address 1 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_LOC_STRT_ADDR1
BU

Attribute Name: L1 Organization Location Street Address 2(L1_ORG_LOC_STREET_ADDR2)

Table 9-102 Organization: L1 Organization Location Street Address 2 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_LOC_STRT_ADDR2
BU

Attribute Name: L1 Organization Street Address 2(L1_ORG_LOC_STREET_ADDR3)

Table 9-103 Organization: L1 Organization Street Address 2 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_LOC_STRT_ADDR3
BU

Attribute Name: L1 Organization City (L1_ORG_CIT)

Table 9-104 Organization: L1 Organization City Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_CIT
BU

Attribute Name: L1 Organization State Code (L1_ORG_ST_CD)

Table 9-105 Organization: L1 Organization State Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_ST_CD
BU

Attribute Name: L1 Organization State Name (L1_ORG_ST_NM)

Table 9-106 Organization: L1 Organization State Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_ST_NM
BU

Attribute Name: L1 Organization Postal Code (L1_ORG_ZP_CD)

Table 9-107 Organization: L1 Organization Postal Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU
DEP	DWV_ORG_DIM.L1_ORG_PSTL_CD
BU

Attribute Name: L2 Organization Name (L2_ORG_NM)

Table 9-108 Organization: L2 Organization Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_NM
DEP
BU

Attribute Name: L2 Organization Address Type (L2_ORG_ADDR_TYP)

Table 9-109 Organization: L2 Organization Address Type Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_ADDR_TYP
DEP
BU

Attribute Name: L2 Organization Location Street Address 1 (L2_ORG_LOC_STREET_ADDR1)

Table 9-110 Organization: L2 Organization Location Street Address 1 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_LOC_STRT_ADDR1
DEP
BU

Attribute Name: L2 Organization Location Street Address 2 (L2_ORG_LOC_STREET_ADDR2)

Table 9-111 Organization: L2 Organization Location Street Address 2 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_LOC_STRT_ADDR2
DEP
BU

Attribute Name: L2 Organization Location Street Address 3 (L2_ORG_LOC_STREET_ADDR3)

Table 9-112 Organization: L2 Organization Location Street Address 3 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_LOC_STRT_ADDR3
DEP
BU

Attribute Name: L2 Organization City (L2_ORG_CIT)

Table 9-113 Organization: L2 Organization City Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_CIT
DEP
BU

Attribute Name: L2 Organization State Code (L2_ORG_ST_CD)

Table 9-114 Organization: L2 Organization State Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_ST_CD
DEP
BU

Attribute Name: L2 Organization State Name (L2_ORG_ST_NM)

Table 9-115 Organization: L2 Organization State Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_ST_NM
DEP
BU

Attribute Name: L2 Organization Postal Code (L2_ORG_ZP_CD)

Table 9-116 Organization: L2 Organization Postal Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU
FCLBU	DWV_ORG_DIM.L2_ORG_PSTL_CD
DEP

Attribute Name: L3 Organization Name (L3_ORG_NM)

Table 9-117 Organization: L3 Organization Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_NM
FCLBU
DEP
BU

Attribute Name: L4 Organization Name (L4_ORG_NM)

Table 9-118 Organization: L4 Organization Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_NM
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization Address Type (L3_ORG_ADDR_TYP)

Table 9-119 Organization: L3 Organization Address Type Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_ADDR_TYP
FCLBU
DEP
BU

Attribute Name: L4 Organization Address Type (L4_ORG_ADDR_TYP)

Table 9-120 Organization: L4 Organization Address Type Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_ADDR_TYP
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization Location Street Address 1(L3_ORG_LOC_STREET_ADDR1)

Table 9-121 Organization: L3 Organization Location Street Address 1 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_LOC_STRT_ADDR1
FCLBU
DEP
BU

Attribute Name: L4 Organization Location Street Address 1(L4_ORG_LOC_STREET_ADDR1)

Table 9-122 Organization: L4 Organization Location Street Address 1 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_LOC_STRT_ADDR1
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization Location Street Address 2(L3_ORG_LOC_STREET_ADDR2)

Table 9-123 Organization: L3 Organization Location Street Address 2 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_LOC_STRT_ADDR2
FCLBU
DEP
BU

Attribute Name: L4 Organization Location Street Address 2(L4_ORG_LOC_STREET_ADDR 2)

Table 9-124 Organization: L4 Organization Location Street Address 2 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_LOC_STRT_ADDR2
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization Location Street Address 3(L3_ORG_LOC_STREET_ADDR 3)

Table 9-125 Organization: L3 Organization Location Street Address 3 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_LOC_STRT_ADDR3
FCLBU
DEP
BU

Attribute Name: L4 Organization Location Street Address 3(L4_ORG_LOC_STREET_ADDR 3)

Table 9-126 Organization: L4 Organization Location Street Address 3 Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_LOC_STRT_ADDR3
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization City (L3_ORG_CIT)

Table 9-127 Organization: L3 Organization City Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_CIT
FCLBU
DEP
BU

Attribute Name: L4 Organization City (L4_ORG_CIT)

Table 9-128 Organization: L4 Organization City Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_CIT
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization State Code (L3_ORG_ST_CD)

Table 9-129 Organization: L3 Organization State Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_ST_CD
FCLBU
DEP
BU

Attribute Name: L4 Organization State Code (L4_ORG_ST_CD)

Table 9-130 Organization L4 Organization State Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_ST_CD
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization State Name (L3_ORG_ST_NM)

Table 9-131 Organization L3 Organization State Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_ST_NM
FCLBU
DEP
BU

Attribute Name: L4 Organization State Name (L4_ORG_ST_NM)

Table 9-132 Organization: L4 Organization State Name Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_ST_NM
RGNBU
FCLBU
DEP
BU

Attribute Name: L3 Organization Postal Code (L3_ORG_ZP_CD)

Table 9-133 Organization: L3 Organization Postal Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS
RGNBU	DWV_ORG_DIM.L3_ORG_PSTL_CD
FCLBU
DEP
BU

Attribute Name: L4 Organization Postal Code (L4_ORG_ZP_CD)

Table 9-134 Organization: L4 Organization Postal Code Mapping

Level	Mapping (Physical Column)
TORG
ENTRPRS	DWV_ORG_DIM.L4_ORG_PSTL_CD
RGNBU
FCLBU
DEP
BU

Patient Dimension: PT

Entity Description: PATIENT DIMENSION

Table 9-135 shows Patient levels and hierarchies.

Table 9-135 Patient Levels and Hierarchies

Level	Description	Patient Hierarchy(HPT)
TPT	Total Patient	TPT
PT	Patient	PT

Table 9-136 shows Patient attributes.

Table 9-136 Patient Attributes

Attribute	Data Type	Description
PT_ID	NUMBER(10)	Patient Id (Unique Key)
PT_BIR_PLC	VARCHAR2(80)	Patient Birth Place
PT_BIR_ORD	NUMBER(10)	Patient Birth Order (in relation to patient's siblings). Values: 1, 2, 3, 4, and so on.
PRTY_BIR_DT	DATE	Patient (Ind Party) Birth Date
PRTY_FRST_NM	VARCHAR2(80)	Patient (Ind Party) First Name
PRTY_MID_NM	VARCHAR2(80)	Patient (Ind Party) Middle Name
PRTY_LST_NM	VARCHAR2(80)	Patient (Ind Party) Last Name
PRTY_DECD_FLG	CHAR	Patient (Ind Party) deceased flag
PRTY_DECD_DT	DATE	Patient (Ind Party) deceased date
PRTY_MRTL_STCD	VARCHAR2(80)	Patient (Ind Party) Marital Status Code
PRTY_MRTL_ STCD _NM	VARCHAR2(200)
PRTY_GNDR_CD	VARCHAR2(80)	Patient (Ind Party) Gender Code
PRTY_GNDR_CD_NM	VARCHAR2(200)	Patient Gender Code Name
PT_STCD	VARCHAR2(80)	Patient Status Code
PT_STCD_NM	VARCHAR2(200)	Patient Status Code Name
PRTY_ID_NBR	VARCHAR2(80)	Party Identification Number
PRTY_ID_TYP	VARCHAR2(80 BYTE)	Party Identification Type
PRTY_ID_TYP_NM	VARCHAR2(200)	Party Identification Type Name
PRTY_RELGN_CD	VARCHAR2(80)	Party Religion Code
PRTY_RELGN_CD_NM	VARCHAR2(200)	Party Religion Code Name
PRTY_RC_CD	VARCHAR2(80)	Party Race Code
PRTY_RC_CD_NM	VARCHAR2(200)	Party Race Code Name
PRTY_ETHN_CD	VARCHAR2(80)	Party Ethnicity Code
PRTY_ETHN_CD_NM	VARCHAR2(200)	Party Ethnicity Code Name

Patient Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-137 Patient Long Description Mapping

Level	Mapping (Physical Column)
TPT	"Total Patient"
PT	DWV_PT_DIM. PRTY_LST_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-138 Patient Short Description Mapping

Level	Mapping (Physical Column)
TPT	"Total Patient"
PT	DWV_PT_DIM. PRTY_LST_NM

Attribute Name: Patient Id (PT_ID)

Table 9-139 Patient ID Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PT_ID

Attribute Name: Patient Birth Place (PT_BIR_PLC)

Table 9-140 Patient Birth Place Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM.PT_BIR_PLC

Attribute Name: Patient Birth Order (PT_BIR_ORD)

Table 9-141 Patient Birth Order Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM.PT_BIR_ORD

Attribute Name: Patient Birth Date (PT_BIR_DT)

Table 9-142 Patient Long Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM.PT_BIR_DT

Attribute Name: Patient First Name (PRTY_FRST_NM)

Table 9-143 Patient First Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM.PRTY_FRST_NM

Attribute Name: Patient Middle Name (PRTY_MID_NM)

Table 9-144 Patient Long Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_MID_NM

Attribute Name: Patient Last Name (PRTY_LST_NM)

Table 9-145 Patient Last Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_LST_NM

Attribute Name: Patient Deceased Flag (PRTY_DECD_FLG)

Table 9-146 Patient Deceased Flag Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_DECD_FLG

Attribute Name: Patient Deceased Date (PRTY_DECD_DT)

Table 9-147 Patient Long Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_DECD_DT

Attribute Name: Patient Marital Status Code (PRTY_MRTL_STCD)

Table 9-148 Patient Marital Status Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_MRTL_STCD

Attribute Name: Patient Marital Status Code Name (PRTY_MRTL_STCD_NM)

Table 9-149 Patient Marital Status Code Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_MRTL_STCD_NM

Attribute Name: Patient Gender Code (PRTY_GNDR_CD)

Table 9-150 Patient Gender Code Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_GNDR_CD

Attribute Name: Patient Gender Code Name (PRTY_GNDR_CD_NM)

Table 9-151 Patient Gender Code Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_GNDR_CD_NM

Attribute Name: Patient Status Code (PT_STCD)

Table 9-152 Patient Status Code Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PT_STCD

Attribute Name: Patient Status Code Name (PT_STCD_NM)

Table 9-153 Patient Status Code Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PT_STCD_NM

Attribute Name: Party Identification Number (PRTY_ID_NBR)

Table 9-154 Patient: Party Identification Number Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_ID_NBR

Attribute Name: Party Identification Type (PRTY_ID_TYP)

Table 9-155 Patient: Party Identification Type Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_ID_TYP

Attribute Name: Party Identification Type Name (PRTY_ID_TYP_NM)

Table 9-156 Patient: Party Identification Type Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PT_ID_TYP_NM

Attribute Name: Party Religion Code (PRTY_RELGN_CD)

Table 9-157 Patient: Party Religion Code Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_RELGN_CD

Attribute Name: Party Religion Code Name (PRTY_RELGN_CD_NM)

Table 9-158 Patient: Party Religion Code Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_RELGN_CD_NM

Attribute Name: Party Race Code (PRTY_RC_CD)

Table 9-159 Patient: Party Race Code Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_RC_CD

Attribute Name: Party Race Code Name (PRTY_RC_CD_NM)

Table 9-160 Patient: Party Race Code Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_RC_CD_NM

Attribute Name: Party Ethnicity Code (PRTY_ETHN_CD)

Table 9-161 Patient: Party Ethnicity Code Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_ETHN_CD

Attribute Name: Party Ethnicity Code Name (PRTY_ETHN_CD_NM)

Table 9-162 Patient: Party Ethnicity Code Name Mapping

Level	Mapping (Physical Column)
TPT
PT	DWV_PT_DIM. PRTY_ETHN_CD_NM

Service Provider Practice Dimension: SPP

Entity Description: SERVICE PROVIDER PRACTICE SNOWFLAKE

Table 9-163 shows Service Provider Practice levels and hierarchies.

Table 9-163 Service Provider Practice Levels and Hierarchies

Level	Description	Service Provider Practice Hierarchy(HSPP)
TSPP	Total Service Provider Practice	TSPP
PRCT	Practice	PRCT
SPP	Service Provider Practice	SPP

Table 9-164 shows Service Provider Practice attributes.

Table 9-164 Service Provider Practice Attributes

Attribute	Data Type	Description
SVCPRVPRCT_ID	NUMBER(10)	Service Provider Practice Id … This is a representation of Service Provider within a Practice. This is a Surrogate Key as multiple records of Service Provider are possible under different Practices.
SVCPRV_PRCT_SVCPRV_ID	NUMBER(10)	HDM Service Provider.Svcprv_Id … where Service Provider Type is Individual Party. Part of Natural Key comprising of SvcprvPrct_Svcprv_Id and SvcprvPrct_Prct_Id columns.
SVCPRV_IND_FRST_NM	VARCHAR2(80)	HDM Individual Party.Frst_Nm
SVCPRV_IND_MID_NM	VARCHAR2(80)	HDM Individual Party.Mid_Nm
SVCPRV_IND_LST_NM	VARCHAR2(80)	HDM Individual Party.Lst_Nm
SVCPRV_IND_PRTY_ID	NUMBER(10)	HDM Individual Party.Prty_Id
SVCPRV_IND_PRTY_SRC_ID	VARCHAR2(80)	HDM Individual Party.Integration_Id
SVCPRV_IND_TYP	VARCHAR2(80)	Service Provider Type (Code)
SVCPRV_IND_TYP_NM	VARCHAR2(200)	Service Provider Type (Name)
SVCPRVPRCT _PRCT_ID	NUMBER(10)	HDM Service Provider.Svcprv_Id … where service Provider Type is Organization Party. Part of Natural Key comprising of SvcprvPrct_Svcprv_Id and SvcprvPrct_Prct_Id columns.
PRCT_ORG_NM	VARCHAR2(80)	HDM Organization.Org_Nm where Org corresponds to Service Provider Type of Type: Organization Party
PRCT_ORG_PRTY_SRC_ID	NUMBER(10)	HDM Organization Party.Integration_Id
PRCT_ORG_TYP	VARCHAR2(80)	Service Provider Type (Code)
PRCT_ORG_TYP_NM	VARCHAR2(200)	Service Provider Type (Name)
PRCT_ORG_SVCPRV_GRP_NM	VARCHAR2(200)

Service Provider Practice Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-165 Service Provider Practice Long Description Mapping

Level	Mapping (Physical Column)
TSPP	'Total Service Provider Practice'
PRCT	DWV_SPP_DIM.PRCT_ORG_NM
SPP	DWV_SPP_DIM.SVCPRV_IND_LST_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-166 Service Provider Practice Short Description Mapping

Level	Mapping (Physical Column)
TSPP	'Total Service Provider Practice'
PRCT	DWV_SPP_DIM.PRCT_ORG_NM
SPP	DWV_SPP_DIM.SVCPRV_IND_LST_NM

Attribute Name: Service Provider Practice Id(SVCPRV_PRCT_ID)

Table 9-167 Service Provider Practice ID Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM.SVCPRVPRCT_ID

Attribute Name: Service Provider ID (SVCPRV_PRCT_SVCPRV_ID)

Table 9-168 Service Provider Practice: Service Provider ID Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM.SVCPRVPRCT_SVCPRV_ID

Attribute Name: Individual Party First Name (SVCPRV_IND_FRST_NM)

Table 9-169 Service Provider Practice: Individual Party First Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_FRST_NM

Attribute Name: Individual Party Middle Name (SVCPRV_IND_MID_NM)

Table 9-170 Service Provider Practice: Individual Party Middle Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_MID_NM

Attribute Name: Individual Party Last Name (SVCPRV_IND_LST_NM)

Table 9-171 Service Provider Practice: Individual Party Last Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_LST_NM

Attribute Name: Individual Party ID(SVCPRV_IND_PRTY_ID)

Table 9-172 Service Provider Practice: Individual Party ID Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_PRTY_ID

Attribute Name: Individual Party Integration ID (SVCPRV_IND_SRC_ID)

Table 9-173 Service Provider Practice: Individual Party Integration ID Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_SRC_ID

Attribute Name: Service Provider Type (SVCPRV_IND_TYP)

Table 9-174 Service Provider Practice: Service Provider Type Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_TYP

Attribute Name: Service Provider Type Name (SVCPRV_IND_TYP_NM)

Table 9-175 Service Provider Practice: Service Provider Type Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT
SPP	DWV_SPP_DIM. SVCPRV_IND_TYP_NM

Attribute Name: Practice ID (SVCPRVPRCT_PRCT_ID)

Table 9-176 Service Provider Practice: Practice ID Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.SVCPRVPRCT_PRCT_ID
SPP	DWV_SPP_DIM. SVCPRVPRCT_PRCT_ID

Attribute Name: Practice Organization Name (PRCT_ORG_NM)

Table 9-177 Service Provider Practice: Practice Organization Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.PRCT_ORG_NM
SPP	DWV_SPP_DIM. PRCT_ORG_NM

Attribute Name: Practice Organization Party Source ID (PRCT_ORG_PRTY_SRC_ID)

Table 9-178 Service Provider Practice: Practice Organization Party Source ID Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.PRCT_ORG_PRTY_SRC_ID
SPP	DWV_SPP_DIM.PRCT_ORG_PRTY_SRC_ID

Attribute Name: Practice Organization Type (PRCT_ORG_TYP)

Table 9-179 Service Provider Practice: Practice Organization Type Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.PRCT_ORG_TYP
SPP	DWV_SPP_DIM.PRCT_ORG_TYP

Attribute Name: Practice Organization Type Name (PRCT_ORG_TYP_NM)

Table 9-180 Service Provider Practice: Practice Organization Type Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.PRCT_ORG_TYP_NM
SPP	DWV_SPP_DIM.PRCT_ORG_TYP_NM

Attribute Name: Practice Organization Service Provider Group Name (PRCT_ORG_SVCPRV_GRP_NM)

Table 9-181 Service Provider Practice: Practice Organization Service Provider Group Name Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.PRCT_ORG_SVCPRV_GRP_NM
SPP	DWV_SPP_DIM.PRCT_ORG_SVCPRV_GRP_NM

Attribute Name: Practice Organization Service Provider Group Type (PRCT_ORG_SVCPRV_GRP_TYP)

Table 9-182 Service Provider Practice: Practice Organization Service Provider Group Type Mapping

Level	Mapping (Physical Column)
TSPP
PRCT	DWV_SPP_DIM.PRCT_ORG_SVCPRV_GRP_TYP
SPP	DWV_SPP_DIM.PRCT_ORG_SVCPRV_GRP_TYP

Shift Dimension: SHFT

Entity Definition: SHIFT DIMENSION

Table 9-183 shows Shift levels and hierarchies.

Table 9-183 Shift Levels and Hierarchies

Level	Description	Shift Hierarchy(HSHFT)
TSHFT	Total Shift	TSHFT
SHFT	Shift	SHFT

Table 9-184 shows Shift attributes.

Table 9-184 Shift Attributes

Attribute	Data Type	Description
SHFT_ID	NUMBER(10)	Shift Id (Unique Key)
SHFT_NM	VARCHAR2(80)	Shift Name. For example: 07.00 hrs - 14.59 hrs
SHFT_DESC	VARCHAR2(200)	Shift Description. For example: "Morning Shift (07.00 hrs to 14.59 hrs)"
SHFT_LOW_FMT	VARCHAR2(20)	Format. For example: HH24:MI hrs
SHFT_HI_FMT	VARCHAR2(20)	Format. For example: HH24:MI hrs

Shift Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-185 Shift Long Description Mapping

Level	Mapping (Physical Column)
TSHFT	'Total Shift'
SHFT	DWV_SHFT_DIM.SHFT_NM

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-186 Shift Short Description Mapping

Level	Mapping (Physical Column)
TSHFT	'Total Shift'
SHFT	DWV_SHFT_DIM.SHFT_DESC

Attribute Name: Shift_ID (SHFT_ID)

Table 9-187 Shift ID Mapping

Level	Mapping (Physical Column)
TSHFT
SHFT	DWV_SHFT_DIM.SHFT_ID

Attribute Name: Shift Name (SHFT_NM)

Table 9-188 Shift Name Mapping

Level	Mapping (Physical Column)
TSHFT
SHFT	DWV_SHFT_DIM.SHFT_NM

Attribute Name: Shift Description (SHFT_DESC)

Table 9-189 Shift Description Mapping

Level	Mapping (Physical Column)
TSHFT
SHFT	DWV_SHFT_DIM.SHFT_DESC

Attribute Name: Format of Lower Range of Shift (SHFT_LOW_FMT)

Table 9-190 Shift Format of Lower Range Mapping

Level	Mapping (Physical Column)
TSHFT
SHFT	DWV_SHFT_DIM. SHFT_LOW_FMT

Attribute Name: Format of Higher Range of Shift (SHFT_HI_FMT)

Table 9-191 Shift Format of Higher Range Mapping

Level	Mapping (Physical Column)
TSHFT
SHFT	DWV_SHFT_DIM. SHFT_HI_FMT

Time Dimension: TIME

Physical Name: TIME

Entity Description: ENCOUNTER DIMENSION

The Time Dimension contains the regular levels of Calendar Time Hierarchy such as Total Time, Year, Quarter, Month, Week, and Day. The Time Dimension also includes the ENC level containing the Encounter entity information. Every Encounter has an Encounter End Date Attribute; this allows the creation of a slot for an Encounter within a particular Time dimension member (Day level member). This approach, combining Encounter information within the Time Dimension, has several advantages relating to the maintenance and loading operations of the OLAP Analytic Workspace.

Table 9-192 shows Time levels and hierarchies.

Table 9-192 Time (TIME) Levels and Hierarchies

Level	Description	Time Hierarchy (HENC)
TTIME	Total Time	TTIME
YR	Year	YR
HLF_YR	Half Year	HLF_YR
QTR	Quarter	QTR
MO	Month	MO
DAY	Day	DAY
ENC	ENCOUNTER	ENC

Table 9-193 shows the Time attributes.

For the Time attributes, note the following:

ENC_ attributes such as ENC_END_DT, ENC_STRT_DT, and so on, are present as attributes of the Time Dimension and are applicable only at the lowest level (ENC).
Generic attributes such as END_DATE, STRT_DT and TIME_SPAN are present as attributes of the Time Dimension and are applicable at all the levels.
The two generic attributes END_DATE and TIME_SPAN are required attributes for enabling OLAP Time Series Intelligence functionality.

Table 9-193 Time Attributes

Attribute	Data Type	Description
ENC_ID	Number(10)	Encounter ID (Unique Key)
ENC_STRT_DT	Date	Encounter Start Date
ENC_NT	VARCHAR2(200)	Encounter Note
ADMSN_TYP_CD	VARCHAR2(80)	Admission Type Code
ADMSN_TYP_NM	VARCHAR2(200)	Admission Type Name
CNFDLTY_CD	VARCHAR2(80)	Confidentiality Code
CNFDLTY_CD_NM	VARCHAR2(200)	Confidentiality Code Name
ENC_CD	VARCHAR2(80)	Encounter Code
ENC_CD_NM	VARCHAR2(200)	Encounter Code Name
ENC_END_DT	DATE	Encounter End Date
ENC_SUBTYP_CD	VARCHAR2(80)	Encounter Subtype Code
ENC_SUBTYP_NM	VARCHAR2(200)	Encounter Subtype Name
END DATE	DATE	End Date
LONG DESCRIPTION	Number(10)	Long Description
PT_DC_STCD	VARCHAR2(80)	Patient Discharge Status Code
PT_DC_STCD_NM	VARCHAR2(200)	Patient Discharge Status Code Name
SHORT DESCRIPTION	Number(10)	Short Description
SRC_OF_ADMSN_CD	VARCHAR2(80)	Source of Admission Code
SRC_OF_ADMSN_CD_NM	VARCHAR2(200)	Source of Admission Code Name
STRT_DT	DATE	Start Date
TIME_SPAN	Number	Time Span

Time Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-194 Time Long Description Mapping

Level	Mapping (Physical Column)
TTIME	DWV_TIME_ENC_DIM.TIME_TOT_DESC
YR	DWV_TIME_ENC_DIM.CAL_YR_DESC
HLF_YR	DWV_TIME_ENC_DIM.CAL_HALF_YR_DESC
QTR	DWV_TIME_ENC_DIM.CAL_QTR_DESC
MO	DWV_TIME_ENC_DIM.CAL_MTH_DESC
DAY	DWV_TIME_ENC_DIM.CAL_DT_DESC
ENC	Encounter: ' \|\| OHDM_SYS.DWV_TIME_ENC_DIM.ENC_ID

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-195 Time Short Description Mapping

Level	Mapping (Physical Column)
TTIME	DWV_TIME_ENC_DIM.TIME_TOT_CD
YR	DWV_TIME_ENC_DIM.CAL_YR_DESC
HLF_YR	DWV_TIME_ENC_DIM.CAL_HALF_YR_CD
QTR	DWV_TIME_ENC_DIM.CAL_QTR_CD
MO	DWV_TIME_ENC_DIM.CAL_MTH_CD
DAY	DWV_TIME_ENC_DIM.CAL_DT_DESC
ENC	'Encounter: ' \|\| OHDM_SYS.DWV_TIME_ENC_DIM.ENC_ID

Attribute Name: End Date (END_DATE)

Table 9-196 Time End Date Mapping

Level	Mapping (Physical Column)
TTIME	DWV_TIME_ENC_DIM.TIME_TOT_END_DT
YR	DWV_TIME_ENC_DIM.CAL_YR_END_DT
HLF_YR	DWV_TIME_ENC_DIM.CAL_HALF_YR_END_DT
QTR	DWV_TIME_ENC_DIM.CAL_QTR_END_DT
MO	DWV_TIME_ENC_DIM.CAL_MTH_DESC
DAY	DWV_TIME_ENC_DIM.CAL_END_DT
ENC	DWV_TIME_ENC_DIM.ENC_END_DT

Attribute Name: Time Span (TIME_SPAN)

Table 9-197 Time Span Mapping

Level	Mapping (Physical Column)
TTIME	DWV_TIME_ENC_DIM.TIME_TOT_TIMESPN
YR	DWV_TIME_ENC_DIM.CAL_YR_TIMESPN
HLF_YR	DWV_TIME_ENC_DIM.CAL_HALF_YR_TIMESPN
QTR	DWV_TIME_ENC_DIM.CAL_QTR_TIMESPN
MO	DWV_TIME_ENC_DIM.CAL_MTH_TIMESPN
DAY	DWV_TIME_ENC_DIM.CAL_DY_TIMESPN
ENC	1

Attribute Name: Start Date (STRT_DT)

Table 9-198 Time Start Date Mapping

Level	Mapping (Physical Column)
TTIME	DWV_TIME_ENC_DIM.TIME_TOT_STRT_DT
YR	DWV_TIME_ENC_DIM.CAL_YR_STRT_DT
HLF_YR	DWV_TIME_ENC_DIM.CAL_HALF_YR_STRT_DT
QTR	DWV_TIME_ENC_DIM.CAL_QTR_STRT_DT
MO	DWV_TIME_ENC_DIM.CAL_MTH_STRT_DT
DAY	DWV_TIME_ENC_DIM.CAL_STRT_DT
ENC	DWV_TIME_ENC_DIM.ENC_STRT_DT

Attribute Name: Encounter ID (ENC_ID)

Table 9-199 Time ID Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_ID

Attribute Name: Encounter End Date (ENC_END_DT)

Table 9-200 Time Encounter End Date Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_END_DT

Attribute Name: Encounter Start Date (ENC_STRT_DT)

Table 9-201 Time Encounter Start Date Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_STRT_DT

Attribute Name: Admission Type Name (ADMSN_TYP_NM)

Table 9-202 Time Encounter Admission Type Name Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ADMSN_TYP_NM

Attribute Name: Admission Type Code (ADMSN_TYP_CD)

Table 9-203 Time Encounter Admission Type Code Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ADMSN_TYP_CD

Attribute Name: Source of Admission Code (SRC_OF_ADMSN_CD)

Table 9-204 Time Encounter Source of Admission Code Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.SRC_OF_ADMSN_CD

Attribute Name: Source of Admission Code Name (SRC_OF_ADMSN_CD_NM)

Table 9-205 Time Encounter Source of Admission Code Name Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.SRC_OF_ADMSN_CD_NM

Attribute Name: Encounter Code (ENC_CD)

Table 9-206 Time Encounter Code Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_CD

Attribute Name: Encounter Code Name (ENC_CD_NM)

Table 9-207 Time Encounter Code Name Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_CD_NM

Attribute Name: Encounter Subtype Code (ENC_SUBTYP_CD)

Table 9-208 Time Encounter Subtype Code Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_SUBTYP_CD

Attribute Name: Encounter Subtype Name (ENC_SUBTYP_NM)

Table 9-209 Time Encounter Subtype Name Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_SUBTYP_NM

Attribute Name: Patient Discharge Status Code (PT_DC_STCD)

Table 9-210 Patient Discharge Status Code Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.PT_DC_STCD

Attribute Name: Patient Discharge Status Code Name (PT_DC_STCD_NM)

Table 9-211 Patient Discharge Status Code Name Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.PT_DC_STCD_NM

Attribute Name: Confidentiality Code (CNFDLTY_CD)

Table 9-212 Confidentiality Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.CNFDLTY_CD

Attribute Name: Confidentiality Code Name (CNFDLTY_CD_NM)

Table 9-213 Confidentiality Code Name Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.CNFDLTY_CD_NM

Attribute Name: Encounter Note (ENC_NT)

Table 9-214 Time Encounter Note Mapping

Level	Mapping (Physical Column)
TTIME
YR
HLF_YR
QTR
MO
DAY
ENC	DWV_TIME_ENC_DIM.ENC_NT

Time of Day Dimension: TOD

Entity Description: TIME OF DAY

Physical Name: TOD

Table 9-215 shows Time of Day levels and hierarchies.

Table 9-215 Time of Day Levels and Hierarchies

Level	Description	Time of Day Hierarchy(HTOD)
TTOD	Total Time of Day	TTOD
HR	Hour	HR
HLFHR	Half Hour	HLFHR
QTRHR	Quarter Hour	QTRHR
MIN	Minute	MIN
SCND	Second	SCND

Table 9-216 shows Time of Day attributes.

Table 9-216 Time of Day Attributes

Attribute	Data Type	Description
TOD_ID	NUMBER(10)	Time of Day Id … represents a second within a day. For example, 119
TOD_NM	VARCHAR2(80)	TOD Name. For example, 00119
TOD_DESC	VARCHAR2(200)	TOD Description For example, 00119
TOD_ HHMISS_AM	VARCHAR2(20)	Format in HH:MI:SS AM/PM. For example, 12:01:59 AM
TOD_HH24MISS	VARCHAR2(20)	Format in HH24:MI:SS. For example, 00:01:59
TOD_MINUTE	VARCHAR2(20)	TOD Minute information (in HH24:MI format). For example, 00:01.
TOD_QTR_HR	VARCHAR2(20)	TOD Quarter Hour information (in HH24:MI format). For example, 00:00
TOD_HALF_HR	VARCHAR2(20)	TOD Half Hour information (in HH24:MI format). For example, 00:00.
TOD_HR	VARCHAR2(20)	TOD Hour information (in HH24:MI format). For example, 00:00.

Time of Day Attribute Mapping

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 9-217 Time of Day Long Description Mapping

Level	Mapping (Physical Column)
TTOD	'Total Time of Day'
HR	DWV_TOD_DIM.TOD_HR
HLFHR	DWV_TOD_DIM.TOD_HALF_HR
QTRHR	DWV_TOD_DIM.TOD_QTR_HR
MIN	DWV_TOD_DIM.TOD_MINUTE
SCND	DWV_TOD_DIM.TOD_DESC

Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 9-218 Time of Day Short Description Mapping

Level	Mapping (Physical Column)
TTOD	'Total Time of Day'
HR	DWV_TOD_DIM.TOD_HR
HLFHR	DWV_TOD_DIM.TOD_HALF_HR
QTRHR	DWV_TOD_DIM.TOD_QTR_HR
MIN	DWV_TOD_DIM.TOD_MINUTE
SCND	DWV_TOD_DIM.TOD_NM

Attribute Name: Time of Day ID (TOD_ID)

Table 9-219 Time of Day ID Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR
MIN
SCND	DWV_TOD_DIM.TOD_ID

Attribute Name: Time of Day Name (TOD_NM)

Table 9-220 Time of Day Name Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR
MIN
SCND	DWV_TOD_DIM.TOD_NM

Attribute Name: Time of Day Description (TOD_DESC)

Table 9-221 Time of Day Description Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR
MIN
SCND	DWV_TOD_DIM.TOD_DESC

Attribute Name: Format HH:MI:SS AM/PM (TOD_HHMISS_AM)

Table 9-222 Time of Day Format HH:MI:SS AM/PM Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR
MIN
SCND	DWV_TOD_DIM.TOD_HHMISS_AM

Attribute Name: Format E.g:HH24:MI:SS (TOD_HH24MISS)

Table 9-223 Time of Day Long Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR
MIN
SCND	DWV_TOD_DIM.TOD_HH24MISS

Attribute Name: TOD Minute Information (TOD_MINUTE)

Table 9-224 Time of Day Minute Information Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR
MIN	DWV_TOD_DIM.TOD_MINUTE
SCND	DWV_TOD_DIM.TOD_MINUTE

Attribute Name: TOD Quarter Hour Information (TOD_QTR_HR)

Table 9-225 Time of Day Quarter Hour Information Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR
QTRHR	DWV_TOD_DIM.TOD_QTR_HR
MIN	DWV_TOD_DIM.TOD_QTR_HR
SCND	DWV_TOD_DIM.TOD_QTR_HR

Attribute Name: TOD Half Hour Information (TOD_HALF_HR)

Table 9-226 Time of Day Half Hour Information Mapping

Level	Mapping (Physical Column)
TTOD
HR
HLFHR	DWV_TOD_DIM.TOD_HALF_HR
QTRHR	DWV_TOD_DIM.TOD_HALF_HR
MIN	DWV_TOD_DIM.TOD_HALF_HR
SCND	DWV_TOD_DIM.TOD_HALF_HR

Attribute Name: TOD Hour Information (TOD_HR)

Table 9-227 Time of Day Hour Information Mapping

Level	Mapping (Physical Column)
TTOD
HR	DWV_TOD_DIM.TOD_HR
HLFHR	DWV_TOD_DIM.TOD_HR
QTRHR	DWV_TOD_DIM.TOD_HR
MIN	DWV_TOD_DIM.TOD_HR
SCND	DWV_TOD_DIM.TOD_HR