Bucketed report and report reserve change amounts

Bucketed report amounts

Deductible Recovery Amount
Equals report_amount if the transaction_allocation_code equals deductible_recovery. Otherwise, zero.
Expense Recovery Amount
Equals report_amount if the transaction_allocation_code equals expense_recovery. Otherwise, zero.
Indemnity Recovery Amount
Equals report_amount if the transaction_allocation_code equals indemnity_recovery. Otherwise, zero.
Salvage Expense Recovery Amount
Equals report_amount if the transaction_allocation_code equals salvage_expense_recovery. Otherwise, zero.
Salvage Recovery Amount
Equals report_amount if the transaction_allocation_code equals salvage_recovery. Otherwise, zero.
Subrogation Expense Recovery Amount
Equals report_amount if the transaction_allocation_code equals subro_expense_recovery. Otherwise, zero.
Subrogation Recovery Amount
Equals report_amount if the transaction_allocation_code equals subro_recovery. Otherwise, zero.
ALAE Paid Amount
Equals report_amount if the transaction_allocation_code equals lae_expense. Otherwise, zero.
Indemnity Paid Amount
Equals report_amount if the transaction_allocation_code equals indemnity. Otherwise, zero.
Medical Paid Amount
Equals report_amount if the transaction_allocation_code equals medical. Otherwise, zero.
ULAE Paid Amount
Equals report_amount if the transaction_allocation_code equals ulae_expense. Otherwise, zero.

Bucketed report reserve change amounts

Deductible Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals deductible_recovery. Otherwise, zero.
Expense Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals expense_recovery. Otherwise, zero.
Indemnity Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals indemnity_recovery. Otherwise, zero.
Salvage Expense Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals salvage_expense_recovery. Otherwise, zero.
Salvage Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals salvage_recovery. Otherwise, zero.
Subrogation Expense Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals subro_expense_recovery. Otherwise, zero.
Subrogation Recovery Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals subro_recovery. Otherwise, zero.
ALAE Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals lae_expense. Otherwise, zero.
Indemnity Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals indemnity. Otherwise, zero.
Medical Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals medical. Otherwise, zero.
ULAE Reserve Change Amount
Equals report_reserve_change_amount if the transaction_allocation_code equals ulae_expense. Otherwise, zero.