Discharge Data

000003 · Health Care Revenue Model
Dataset online 33 fields 1 partition

Setupsource
Sources: ows_tabella

Workspace
002 · Health Care Revenue Model
Type
Dataset
Status
online
Partitions
VAL Validated & Cleansed

Fields 33source
Sources: ows_tabella_campo

# Code Description Type Length Default Time rollup Conversion Key Req Dimension
0 IP Insurance & Payer Text — — — — — — IP
1 DD01 Name Text 255 — — — — — —
2 DD02 DOB Text 255 — — — — — —
3 DD03 Sex Text 255 — — — — — —
4 DD04 MRUN Text 255 — — — — — —
5 DD05 PtSrv Text 255 — — — — — —
6 DD06 Surgery Text 255 — — — — — —
7 DD07 Admission Text 255 — — — — — —
8 DD08 Discharge Text 255 — — — — — —
9 YR Year Number 27,9 — Sum None — — —
10 PD Period Number 27,9 — Sum None — — —
11 DD09 Length of Stay Number 27,9 — Sum None — — —
12 DD10 Geometric Mean Length of Stay Number 27,9 — Sum None — — —
13 DD11 LOS Variance Number 27,9 — Sum None — — —
14 DD12 ICU Days Number 27,9 — Sum None — — —
15 DD13 Ventilator Days Number 27,9 — Sum None — — —
16 DD14 MDC Text 255 — — — — — —
17 DD15 Rel Wgt Number 27,9 — Sum None — — —
18 DD16 Physicians Text 255 — — — — — —
19 DD17 Diag Text 255 — — — — — —
20 DD18 Diagnosis Text 255 — — — — — —
21 DD19 Proc Text 255 — — — — — —
22 DD20 Charges Number 27,9 — Sum None — — —
23 DD21 Payments Number 27,9 — Sum None — — —
24 DD22 Balance Number 27,9 — Sum None — — —
25 DD23 Direct Cost Number 27,9 — Sum None — — —
26 DD24 Indirect Cost Number 27,9 — Sum None — — —
27 DD25 ZIP Text 255 — — — — — —
28 DIST District Text 255 — — — — — —
29 DD27 Service Line Text 255 — — — — — —
30 DD28 Arrived From Text 255 — — — — — —
31 DD29 Status Text 255 — — — — — —
32 DRG Diagnostic Related Grouping Text — — — — — — DRG

Lineage

Read by 1

000001 Health Care DTP act 0ENT

Written by 0

No DTPs write to this dataset.

Used in Forms 1 source
Sources: prospetto_xml

Form Form description Sheet Matrix
F100 Patient Data Patient Data Matrix00