pharmacist parent

-- Example column naming
CREATE TABLE claims (
  claim_id VARCHAR(50),
  phrm_prnt VARCHAR(100),  -- pharmacist parent
  ...
);

-- Example in SELECT
SELECT 
  claim_id,
  phrm_prnt as pharmacist_parent
FROM claims;