get_patron_data_from_email.sql

SELECT
'p' || r.record_num || 'a' as patron_record_num,
v.field_content,
b.index_entry as barcode,
n.index_entry as patron_name_norm

FROM
sierra_view.record_metadata 	as r

JOIN
sierra_view.varfield		as v
ON
  v.record_id = r.id

-- get patron barcode
LEFT OUTER JOIN
sierra_view.phrase_entry	AS b
ON
  (b.record_id = r.id) AND (b.index_tag = 'b')

-- get normalized patron name
LEFT OUTER JOIN
sierra_view.phrase_entry	AS n
ON
  (n.record_id = r.id) AND (n.index_tag = 'n')

  
WHERE
r.record_type_code = 'p'
AND v.varfield_type_code = 'z'
AND v.field_content IN
(
'rvoelker1@udayton.edu'
)