SELECT IFNULL(Patient_Lock, 0) AS Patient_Lock FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID =