Authorizations

Active Authorizations

select PayName FROM #Request.prefix_db_agency#.Payer WHERE Payer_ID = (select Payer_ID from #Request.prefix_db_agency#.authorizations where Auth_ID = '#Auth_ID#')

Visit Type	Rev/HCPCS	Payer	Units	Frequency	Start Date	End Date	Duration	Auth Number	Schedule?	Action
#Visit_Type#	#Revenue_Code#/#HCPCS_Code#	#Getpayername.PayName#	#NumberFormat(Units, '___')# #Measure#(s)	every#NumberFormat(Time_Frame, '___')# days	#DateFormat(StartDate,'mm/dd/yyyy')#	#DateFormat(EndDate,'mm/dd/yyyy')#	#Duration#	#Authorization_Number#

SELECT a.Auth_ID, a.Patient_ID, a.Benefits_ID, a.Revenue_Code, a.Rev_CodeID, a.HCPCS_Code, a.Units, a.Time_Frame, a.StartDate, a.EndDate, a.Duration, a.Authorization_Number, a.Notes, a.Payer_ID, r.Measure, r.Visit_Type FROM #Request.prefix_db_agency#.authorizations a, #Request.prefix_db_agency#.Revenue_Code r WHERE Patient_ID = '#session.cs.patientid#' and a.Rev_CodeID = r.Rev_CodeID and Deleted = '1'

Inactive Authorizations

select PayName FROM #Request.prefix_db_agency#.Payer WHERE Payer_ID = (select Payer_ID from #Request.prefix_db_agency#.authorizations where Auth_ID = '#Auth_ID#')

Visit Type	Rev/HCPCS	Payer	Units	Frequency	Start Date	End Date	Duration	Auth Number	Schedule?	Action
#Visit_Type#	#Revenue_Code#/#HCPCS_Code#	#Getpayername.PayName#	#NumberFormat(Units, '___')# #Measure#(s)	every#NumberFormat(Time_Frame, '___')# days	#DateFormat(StartDate,'mm/dd/yyyy')#	#DateFormat(EndDate,'mm/dd/yyyy')#	#Duration#	#Authorization_Number#