Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
|
|
The error occurred in C:/Web/PCL_NEW/staffing_new/display.cfm: line 54
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 4
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 1
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 54
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 4
Called from C:/Web/PCL_NEW/staffing_new/display.cfm: line 1
|
52 : /PA1.A_BUDGET_WHPPD *100,2) as PERCENT_VARIANCE
53 : from P1ST_AUI PA JOIN P1ST_ACTUAL PA1 ON PA.ACTUAL_ID=PA1.ACTUAL_ID
54 : where (ID = #ID#) AND Hospital_Name = '#Name#' AND (Unit_Name = '#Unit#')
55 : order by OrderOfLines
56 : </CFQUERY>
|
|
SQLSTATE |
22012 |
DATASOURCE |
MHA |
VENDORERRORCODE |
8134 |
SQL |
select PA.Add_Unit_Info, PA.WHPPD, PA1.A_BUDGET_WHPPD,PA1.A_PATIENT_DAYS, PA.Avg_Daily_Census, PA.OrderOfLines,
round ((PA1.A_TOTAL_WH/PA1.A_TOTAL_PD),2) as WHPPD_ACTUAL,
round( (PA1.A_TOTAL_WH/PA1.A_TOTAL_PD) - PA1.A_BUDGET_WHPPD,2) as VARIANCE,
round(round((round((PA1.A_TOTAL_WH/PA1.A_TOTAL_PD) ,2)
- PA1.A_BUDGET_WHPPD),2)
/PA1.A_BUDGET_WHPPD *100,2) as PERCENT_VARIANCE
from P1ST_AUI PA JOIN P1ST_ACTUAL PA1 ON PA.ACTUAL_ID=PA1.ACTUAL_ID
where (ID = 20128) AND Hospital_Name = 'Caritas - Carney Hospital' AND (Unit_Name = 'Transitional Care Unit')
order by OrderOfLines
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.21.244.151 |
Referrer |
|
Date/Time |
27-Sep-24 01:16 AM |
|