field_name,type,nullable,source_status,definition,example
record_id,string,no,derived,Persistfolio deterministic row identifier.,CAPD-…
source_period,string,no,normalized,Quarter page on which the Board published the record.,2015Q1
entity_scope,categorical,no,normalized,Source section: PERSONAL or FACILITY.,PERSONAL
name_raw,string,no,reported,"Respondent/entity name, whitespace-normalized only.","Alvarez, Jonathan"
license_type_raw,string,no,reported/normalized,Published license code/type or applicant label.,RPH
license_number,string,yes,reported,Published license number; blank for applicant rows without one.,41154
case_type,string,no,reported/normalized,Board case-type label.,Administrative Case
case_number,string,no,reported,Published case number including prefix.,AC 5057
location_raw,string,yes,reported,Published location line.,"Phoenix, AZ"
action_raw,string,no,reported,Board action text with whitespace normalized; effective-date boilerplate separated.,Through a disciplinary action…
action_normalized,categorical,no,classified,Conservative Persistfolio top-level action class.,PUBLIC_REPROVAL
probation_years,integer,yes,derived,Explicit probation duration when stated; blank is not zero.,5
effective_date,date,yes,normalized,Printed action effective date in ISO format.,2015-01-19
source_url,string,no,reported lineage,Exact quarterly Board page.,https://www.pharmacy.ca.gov/enforcement/…