SELECT r.*,0 as total FROM #Request.prefix_db_agency#.pReferral r WHERE r.Loc_ID = #session.AgencyID# and status !='2' group by r.Referral_ID ORDER BY r.status,r.R_Contact_Name
Referral in use ... cannot delete
Referral Sources
New Referral Source Back

Alert!

You cannot delete it. Because already the Referral in use.

Name Facility Status Action
Encrypted_Referral_ID=encrypt(#Referral_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); #R_Contact_Name# #Referral_Name# ActiveInactive Encrypted_Referral_ID=encrypt(#Referral_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex");