Enterprise Master Patient Index

-- Example column naming
CREATE TABLE claims (
  claim_id VARCHAR(50),
  empi VARCHAR(100),  -- Enterprise Master Patient Index
  ...
);

-- Example in SELECT
SELECT 
  claim_id,
  empi as enterprise_master_patient_index
FROM claims;