Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
|
|
The error occurred in C:/Web/PCL_NEW/staffing/display.cfm: line 50
Called from C:/Web/PCL_NEW/staffing/display.cfm: line 4
Called from C:/Web/PCL_NEW/staffing/display.cfm: line 50
Called from C:/Web/PCL_NEW/staffing/display.cfm: line 4
|
48 : /PA1.A_BUDGET_WHPPD *100,2) as PERCENT_VARIANCE
49 : from P1ST_AUI PA JOIN P1ST_ACTUAL PA1 ON PA.ACTUAL_ID=PA1.ACTUAL_ID
50 : where (ID = #url.ID#) AND Hospital_Name = '#url.Name#' AND (Unit_Name = '#url.Unit#')
51 : order by OrderOfLines
52 : </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 = 20007) AND Hospital_Name = 'Beth Israel Deaconess Medical Center' AND (Unit_Name = 'Stoneman 7')
order by OrderOfLines
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.217.7.118 |
Referrer |
|
Date/Time |
27-Sep-24 03:33 AM |
|