DELETE from #Request.prefix_db_agency#.authorizations WHERE Auth_ID = #url.AID#
SELECT Payer_ID, PayName, Output_Type FROM #Request.prefix_db_agency#.Payer WHERE Payer_ID =#trim(form.Payer_Plan)#
insert into #Request.prefix_db_agency#.authorizations
(
Patient_ID,
Revenue_Code,
HCPCS_Code,
Units,
Time_Frame,
StartDate,
EndDate,
Duration,
Authorization_Number,
Notes,
Mod_Date,
Rev_CodeID,
Payer_ID
)
values
(
#trim(form.patientid)#,
'#trim(RevenueCode)#',
'#trim(HCPCS)#',
'#trim(form.Units)#',
'#trim(form.Time_Frame)#',
#CreateODBCDate(form.StartDate)#,NULL,
#CreateODBCDate(form.EndDate)#,NULL,
'#trim(form.rdOverride)#',
'#trim(form.AuthorizationNumber)#',
'#trim(form.txtNotes)#',
#CreateODBCDate(now())#,
'#Rev_CodeID#',
'#form.Payer_Plan#'
)
SELECT max(auth_ID) as auth_id FROM #Request.prefix_db_agency#.authorizations
insert into #Request.prefix_db_agency#.authorizations_details
(
Auth_ID
)
values
(
#Getauthid.auth_id#
)
SELECT Payer_ID, PayName, Output_Type FROM #Request.prefix_db_agency#.Payer WHERE Payer_ID =#trim(form.Payer_Plan)#
SELECT Units,Duration,Time_Frame FROM #Request.prefix_db_agency#.authorizations where Auth_ID = '#Trim(form.hdnAuthID)#'
UPDATE #Request.prefix_db_agency#.authorizations SET
Patient_ID = #trim(form.patientid)#,
Revenue_Code = '#trim(RevenueCode)#',
HCPCS_Code = '#trim(HCPCS)#',
Units = '#trim(form.Units)#',
Time_Frame = '#trim(form.Time_Frame)#',
StartDate = #CreateODBCDate(form.StartDate)#,StartDate = NULL,
EndDate = #CreateODBCDate(form.EndDate)#,EndDate = NULL,
Duration = '#trim(form.rdOverride)#',
Authorization_Number = '#trim(form.AuthorizationNumber)#',
Notes = '#trim(form.txtNotes)#',
Mod_Date = #CreateODBCDate(now())#,
Rev_CodeID ='#trim(Rev_CodeID)#',
Payer_ID ='#form.Payer_Plan#'
Where Auth_ID = '#Trim(form.hdnAuthID)#'
SELECT count(*) as countunits FROM #Request.prefix_db_agency#.authorizations_details where Auth_ID = '#Trim(form.hdnAuthID)#'
insert into #Request.prefix_db_agency#.authorizations_details
(
Auth_ID
)
values
(
#form.hdnAuthID#
)
insert into #Request.prefix_db_agency#.authorizations_details
(
Auth_ID
)
values
(
#form.hdnAuthID#
)
select Auth_Details_ID from #Request.prefix_db_agency#.authorizations_details where Auth_ID = '#Trim(form.hdnAuthID)#' and ScheduleItems_ID is null order by Auth_Details_ID desc limit 1
Delete from #Request.prefix_db_agency#.authorizations_details where Auth_ID = '#Trim(form.hdnAuthID)#'
and Auth_Details_ID=#selectid.Auth_Details_ID# and ScheduleItems_ID is null