encounter chief complaint

-- Example column naming
CREATE TABLE claims (
  claim_id VARCHAR(50),
  enc_cc VARCHAR(100),  -- encounter chief complaint
  ...
);

-- Example in SELECT
SELECT 
  claim_id,
  enc_cc as encounter_chief_complaint
FROM claims;