Spectre Measures Code Samples
In this Spectre Measures example, there are three dimensions that require mapping, three data sources to be converted into four data sets, and nine measures. The mapping is done in each data-set block by using the rename-dimension tag.
measures {
output "/measures/out"
dimension "Date"
dimension "Facility"
dimension "Provider"
data-set "util_inpatient_ad" {
input "/in/encounters.cbase" {
filter ```
value("Patient Type") = "Inpatient" and
notnull(value("Admit Date"))```
}
rename-dimension "Admitting Provider ID" "Provider"
rename-dimension "Admit Date" "Date"
rename-dimension "Facility Code" "Facility"
}
data-set "util_inpatient_dc" {
input "/in/encounters.cbase" {
filter ```
value("Patient Type") = "Inpatient" and
notnull(value("Discharge Date"))```
}
rename-dimension "Discharge Date" "Date"
rename-dimension "Facility Code" "Facility"
}
data-set "chrgs_all" {
input "/in/charges.cbase"
rename-dimension "Service Date" "Date"
rename-dimension "Facility Code" "Facility"
}
data-set "targets" {
input "/in/targets.cbase"
rename-dimension "Year-Month Start" "Date"
}
measure "TTLAD" ```
dscolumn("util_inpatient_ad", "Admissions")
``` format="#,###" label="Total Admissions" {
custom-property "Use Percent Difference" "False"
related-measure "Target" `dscolumn("targets", "Total Admissions")`
}
measure "NBAD" ```
dscolumn("util_inpatient_ad", "Newborn")
``` format="#,###" label="Newborn Admissions" {
related-measure "Target" `dscolumn("targets", "Newborn Admissions")`
}
measure "TTLDC" ```
dscolumn("util_inpatient_dc", "Discharges")
``` format="#,###" label="Total Discharges" {
related-measure "Target" `dscolumn("targets", "Total Discharges")`
}
measure "INPTCHRGS" ```
value("Inpatient Charges")
``` format="#,###,K" label="Inpatient Charges" {
related-measure "Target" `dscolumn("targets", "Inpatient Charges")`
}
measure "OUTPTCHRGS" ```
dscolumn("chrgs_all", "Outpatient Charges")
``` format="#,###,K" label="Outpatient Charges" {
related-measure "Target" `dscolumn("targets", "Outpatient Charges")`
}
measure "TTLCHRGS" ```
dscolumn("chrgs_all", "Total Charges")
``` format="#,###,K" label="Total Charges" {
related-measure "Target" `dscolumn("targets", "Total Charges")`
}
measure "REVPERDC" ```
measure("TTLCHRGS")/measure("TTLDC")
``` format="#,###" label="Revenue per Discharge" {
related-measure "Target" ```
dscolumn("targets", "Revenue per Discharge Numerator")/
dscolumn("targets", "Revenue per Discharge Denominator")
```
}
measure "IPOPRATIO" ```
measure("INPTCHRGS")/measure("OUTPTCHRGS")
``` format="#.0" label="IP OP Charge Ratio" {
related-measure "Target" ```
dscolumn("targets", "IP OP Charge Ratio Numerator")/
dscolumn("targets", "IP OP Charge Ratio Denominator")
```
}
measure "CASEMIX" ```
dscolumn("util_inpatient_dc", "DRG Weight")/
dscolumn("util_inpatient_dc", "DRG Weight Count")
``` format="#.0000" label="Overall All Payor Case Mix" {
custom-property "Use Percent Difference" "False"
related-measure "Target" ```
dscolumn("targets", "Overall All Payor Case Mix")```
}
}
See also: