remittance effective date

-- Example column naming
CREATE TABLE claims (
  claim_id VARCHAR(50),
  remit_eff_dt VARCHAR(100),  -- remittance effective date
  ...
);

-- Example in SELECT
SELECT 
  claim_id,
  remit_eff_dt as remittance_effective_date
FROM claims;