TrueCost measures
Encounter
| Measure name | Source business class / calculation |
|---|---|
| Encounter ID | load_Encounters.Encounter_ID |
| Length of Stay | load_Encounters.Length_of_Stay |
Events
| Measure name | Source business class / calculation |
|---|---|
| TC Event Duration – Minutes | DATEDIFF(Minute, load_Events.Event_End_Time - load_Events.Event_Start_Time) |
| TC Event Duration – Hours | DATEDIFF(Hour, load_Events.Event_End_Time - load_Events.Event_Start_Time) |
| TC Event Quantity | load_Events.Detail_Event_Quantity |
TC Allocation Summary
| Measure name | Source business class / calculation |
|---|---|
| TCAS Snapshot Amount | AllocationTransactionDetail.TransactionAmount |
| TCAS Transaction Amount - Step 1 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 1 |
| TCAS Balance Amount - Step 1 | Snapshot Amount + Transaction Amount - Step 1 |
| TCAS Transaction Amount - Step 2 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 2 |
| TCAS Balance Amount - Step 2 |
Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 |
| TCAS Transaction Amount - Step 3 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 3 |
| TCAS Balance Amount - Step 3 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 |
| TCAS Transaction Amount - Step 4 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 4 |
| TCAS Balance Amount - Step 4 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 |
| TCAS Transaction Amount - Step 5 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 5 |
| TCAS Balance Amount - Step 5 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 |
| TCAS Transaction Amount - Step 6 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 6 |
| TCAS Balance Amount - Step 6 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 |
| TCAS Transaction Amount - Step 7 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 7 |
| TCAS Balance Amount - Step 7 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 |
| TCAS Transaction Amount - Step 8 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 8 |
| TCAS Balance Amount - Step 8 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 + Transaction Amount - Step 8 |
| TCAS Transaction Amount - Step 9 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 9 |
| TCAS Balance Amount - Step 9 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 + Transaction Amount - Step 8 + Transaction Amount - Step 9 |
| TCAS Transaction Amount - Step 10 | AllocationTransactionDetail.TransactionAmount where AllocationStep = 10 |
| TCAS Balance Amount - Step 10 | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 + Transaction Amount - Step 8 + Transaction Amount - Step 9 + Transaction Amount - Step 10 |
| TCAS Balance Amount - End of Allocation | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 + Transaction Amount - Step 8 + Transaction Amount - Step 9 + Transaction Amount - Step 10 |
| TCAS Allocated to Cost Object | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 + Transaction Amount - Step 8 + Transaction Amount - Step 9 + Transaction Amount - Step 10 where Cost Object is not null |
| TCAS Not Allocated to Cost Object | Snapshot Amount + Transaction Amount - Step 1 + Transaction Amount - Step 2 + Transaction Amount - Step 3 + Transaction Amount - Step 4 + Transaction Amount - Step 5 + Transaction Amount - Step 6 + Transaction Amount - Step 7 + Transaction Amount - Step 8 + Transaction Amount - Step 9 + Transaction Amount - Step 10 where Cost Object is null
|
TC Encounter Detail Cost
| Measure name | Source business class / calculation |
|---|---|
| TCDC Total Costs | [TCDC Direct Costs] + [TCDC Indirect Costs] |
| TCDC Indirect Costs |
SUM([Grain(TC Unit Cost).TCUC Quantity Unit Cost - Indirect Amount]) * SUM([Grain(Event).TC Event Quantity]) |
| TCDC Direct Costs |
SUM([Grain(TC Unit Cost).TCUC Quantity Unit Cost - Direct Amount]) * SUM([Grain(Event).TC Event Quantity]) |
TC Unit Cost
| Measure name | Source business class / calculation |
|---|---|
| TCUC Event Duration - Minutes | SUM([Grain(Event).TC Event Duration - Minutes]) |
| TCUC Quantity Unit Cost - Direct Amount | SUM([Grain(TC Allocation Summary).TCAS Snapshot Amount]) / SUM([Grain(Event).TC Event Quantity]) |
| TCUC Quantity Unit Cost - Indirect Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of Allocations])
/ SUM([Grain(Event).TC Event Quantity]) |
| TCUC Duration Minute Cost - Direct Amount | SUM([Grain(TC Allocation Summary).TCAS Snapshot Amount]) /
SUM([Grain(Event).TC Event Duration - Minutes]) |
| TCUC Duration Minute Cost - Indirect Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of Allocations]) / SUM([Grain(Event).TC Event Duration - Minutes]) |
| TCUC Event Duration - Hours | SUM([Grain(Event).TC Event Duration - Hours]) |
| TCUC Duration Hours Cost - Direct Amount | SUM([Grain(TC Allocation Summary).TCAS Snapshot Amount]) / SUM([Grain(Event).TC Event Duration - Hours]) |
| TCUC Duration Hours Cost - Indirect Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of Allocations])
/ SUM([Grain(Event).TC Event Duration - Hours]) |
| TCUC Event Quantity | SUM([Grain(Event).TC Event Quantity]) |
| TCUC Direct Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of
Allocations]) where TCAS Snapshot Amount <> 0 |
| TCUC Indirect Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of
Allocations]) where TCAS Snapshot Amount = 0 |
| TCUC Event Duration - Minutes | SUM([Grain(Event).TC Event Duration - Minutes]) |
| TCUC Quantity Unit Cost - Direct Amount | SUM([Grain(TC Allocation Summary).TCAS Snapshot Amount]) / SUM([Grain(Event).TC Event Quantity]) |
| TCUC Quantity Unit Cost - Indirect Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of Allocations])
/ SUM([Grain(Event).TC Event Quantity]) |
| TCUC Duration Minute Cost - Direct Amount | SUM([Grain(TC Allocation Summary).TCAS Snapshot Amount]) / SUM([Grain(Event).TC Event Duration - Minutes]) |
| TCUC Duration Minute Cost - Indirect Amount | SUM([Grain(TC Allocation Summary).TCAS Balance Amount - End of Allocations])
/ SUM([Grain(Event).TC Event Duration - Minutes]) |
| TCUC Event Duration - Hours | SUM([Grain(Event).TC Event Duration - Hours]) |
TC Encounter Summary Fact
| Measure name | Source business class / calculation |
|---|---|
| TCES Total Adjustments | SUM([Grain(Encounter AR Details).Adjustments Amount]) where: Adjustments Amount = [load_ARTransactions.Transaction_Amount] Where Transaction_Type = ‘ADJ’ |
| TCES Total Charges | SUM([Grain(Encounter AR Details).Charges Amount]) where: Charges Amount = [load_ARTransactions.Transaction_Amount] Where Transaction_Type = ‘CHRG |
| TCES Total Payments | SUM([Grain(Encounter AR Details).Payments Amount]) where: Payments Amount = [load_ARTransactions.Transaction_Amount] Where Transaction_Type = ‘PMT |
| TCES Total Costs | SUM([Grain(TC Encounter Detail Cost Fact).TCDC Direct Costs] + SUM([Grain(TC Encounter Detail Cost Fact).TCDC Indirect Costs] |
| TCES Total Operating Margin | TCES Total Charges – TCES Total Adjustments – TCES Total Costs |
TrueCost RU Driver Event
| Measure name | Source business class / calculation |
|---|---|
| TrueCost Driver Amount | FSM_TrueCostResourceUtilizationDriverEvent.Value |