SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Loc_ID = '#session.AgencyId#' AND Status = '0' ORDER BY Phys_Last SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Loc_ID = '#session.AgencyId#' AND Status = '1' ORDER BY Phys_Last
Physician List
Encry_Phys_ID=encrypt(#Phys_ID#,"#application.enckey#","AES","Hex");
Physician Physician NPI
#Phys_Last#, #Phys_First# #Phys_NPI# Phys_verified EQ 0> omitted from PECOS
Inactive Physician
Encry_Phys_ID=encrypt(#Phys_ID#,"#application.enckey#","AES","Hex");
Physician Physician NPI
#Phys_Last#, #Phys_First# #Phys_NPI# Phys_verified EQ 0> omitted from PECOS