SELECT rc.Rev_CodeID, rc.Visit_Type, rc.Description, rc.Rev_Code, rc.HCPCS, rc.Payer_ID,rc.RevenueCodeStatus, rc.EClaim_Price, rc.Measure, p.PayName FROM #Request.prefix_db_agency#.Revenue_Code rc, #Request.prefix_db_agency#.Payer p WHERE rc.Payer_ID = p.Payer_ID AND rc.Agency_ID = #session.AgencyID# and rc.RevenueCodeStatus = 'active' GROUP BY rc.Rev_CodeID ORDER BY rc.RevenueCodeStatus,p.PayName ASC, rc.Visit_Type ASC SELECT rc.Rev_CodeID, rc.Visit_Type, rc.Description, rc.Rev_Code, rc.HCPCS, rc.Payer_ID,rc.RevenueCodeStatus, rc.EClaim_Price, rc.Measure, p.PayName FROM #Request.prefix_db_agency#.Revenue_Code rc, #Request.prefix_db_agency#.Payer p WHERE rc.Payer_ID = p.Payer_ID AND rc.Agency_ID = #session.AgencyID# and (rc.RevenueCodeStatus = 'deleted' or rc.RevenueCodeStatus = 'inactive') GROUP BY rc.Rev_CodeID ORDER BY rc.RevenueCodeStatus,p.PayName ASC, rc.Visit_Type ASC SELECT DISTINCT(s.Rev_CodeID) FROM #Request.prefix_db_agency#.ScheduleItems s WHERE s.Agency_ID = #session.AgencyID# ORDER BY s.Rev_CodeID

Active Revenue Codes

Encrypted_Rev_CodeID=encrypt(#Rev_CodeID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex");
Payer Visit Type Description Rev Code HCPCS Unit Charge
#PayName# #Visit_Type# #Description# #Rev_Code# #HCPCS# #EClaim_Price# by hour 1/4 hr visit

Inactive Revenue Codes

Payer Visit Type Description Rev Code HCPCS Unit Charge
#PayName# #Visit_Type# #Description# #Rev_Code# #HCPCS# #EClaim_Price# by hour 1/4 hr visit