Health Care DTP

0ENT

0ENT — Entity Matching and Data Cleanse

Level 0 · Target: 000008 Input Quantitative Discharge Data - Calc 1

clears target Update Reporting Layer

3 ops

▾

# Code Description Type Source Target / Method Mappings

0

000001

Discharge Data Insert

Insert from other dataset

000003

Discharge Data

—

Target field	Source field	Group by
`PAY`	`DD21`	—
`DRG`	`DRG`	—
`INDIRC`	`DD24`	—
`YR`	`YR`	—
`DIST`	`DIST`	—
`VENT`	`DD13`	—
`DIRC`	`DD23`	—
`IP`	`IP`	—
`ICU`	`DD12`	—
`LOS`	`DD09`	—
`LOSVAR`	`DD11`	—
`BAL`	`DD22`	—
`SURG`	`CASE WHEN DD06 ='Y' THEN 1 ELSE 0 END`	—
`CHARGES`	`DD20`	—
`MTH`	`PD`	—
`GMLOS`	`DD10`	—
`NAME`	`DD01`	—

1

000002

Entity Update

Enrichment with reference dataset

ref 000005

Entity Mapping Table

—

2

000003

DRG Node Update

Enrichment with reference dataset

ref 000010

Diagnostic Related Grouping

—

1SUM

1SUM — Summarize Quantitative Data

Level 1 · Target: 000006 Input Patient Analysis Summary

clears target Update Reporting Layer

1 op

▾

# Code Description Type Source Target / Method Mappings

0

000001

Insert From Step 1 and Summarize

Insert from other dataset

000008 Input

Quantitative Discharge Data - Calc 1

—

Source filter · MTH >=0 and YR >=0 and LENGTH(DRG)>0

Target field	Source field	Group by
`DIRC`	`DIRC`	Sum
`CHARG`	`CHARGES`	Sum
`VENT`	`VENT`	Sum
`ENT`	`ENT`	Group by
`DRG`	`DRG`	Group by
`CT`	`NAME`	C
`SUR`	`SURG`	Sum
`SCE`	`Concat(cast(YR as INT),'ACT')`	Group by
`AVG_LOS`	`LOS`	A
`INDIRC`	`INDIRC`	Sum
`ICU`	`ICU`	Sum
`MIN_LOS`	`LOS`	N
`PD`	`Right(Concat('0',cast(MTH as int)),2)`	Group by
`MAX_LOS`	`LOS`	Max

2PAY

2PAY — Payment Analysis

Level 2 · Target: 000013 Engine Payment Analysis - Calc 2

clears target Update Reporting Layer

1 op

▾

# Code Description Type Source Target / Method Mappings

0

000001

Insert From Calc 1

Insert from other dataset

000008 Input

Quantitative Discharge Data - Calc 1

—

Target field	Source field	Group by
`R16`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=16 then 1 else 0 end`	Sum
`R06`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=6 then 1 else 0 end`	Sum
`R04`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=4 then 1 else 0 end`	Sum
`R14`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=14 then 1 else 0 end`	Sum
`PAYPCT`	`ABS(PAY)/CHARGES`	A
`R17`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=17 then 1 else 0 end`	Sum
`R18`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=18 then 1 else 0 end`	Sum
`R03`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=3 then 1 else 0 end`	Sum
`R08`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=8 then 1 else 0 end`	Sum
`R05`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=5 then 1 else 0 end`	Sum
`CHARG`	`CHARGES`	Sum
`PD`	`'12'`	—
`IP`	`IP`	Group by
`R01`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=1 then 1 else 0 end`	Sum
`R13`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=13 then 1 else 0 end`	Sum
`R11`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=11 then 1 else 0 end`	Sum
`R20`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=20 then 1 else 0 end`	Sum
`R09`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=9 then 1 else 0 end`	Sum
`R15`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=15 then 1 else 0 end`	Sum
`R12`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=12 then 1 else 0 end`	Sum
`SCE`	`Concat(cast(YR as INT),'ACT')`	Group by
`R19`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=19 then 1 else 0 end`	Sum
`R02`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=2 then 1 else 0 end`	Sum
`R10`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=10 then 1 else 0 end`	Sum
`R07`	`case when Round((ABS(PAY)/CHARGES)/.05,0)=7 then 1 else 0 end`	Sum

Setupsource
Sources: OWS_DTP

Activities 3source
Sources: OWS_ATTIVITA, OWS_OPERAZIONE

Workflow task lists 1

Health Care DTP

SetupsourceSources: OWS_DTP

Activities 3sourceSources: OWS_ATTIVITA, OWS_OPERAZIONE

Workflow task lists 1

Setupsource
Sources: OWS_DTP

Activities 3source
Sources: OWS_ATTIVITA, OWS_OPERAZIONE