Hi,
I can't seem to load my script as I keep seeing "field name must be unique within table" as an error message which pops up and halts my run. I don't see any duplicates in my script. I have provided it below.
Please advise.
Thank you so much! ☺
Clem
--
LOAD*;
SELECT concat (v_MedicalClaim.MEM_UNIQUE_ID,
'_',
v_MedicalClaim.SERVICE_DATE,
'_',
v_MedicalClaim.SERVICING_PROVIDER_FULL_NAME)
AS UNIQUE_VISIT_KEY,
v_MedicalClaim.MEM_UNIQUE_ID,
v_MedicalClaim.MEM_FULL_NAME,
v_MedicalClaim.MEM_GENDER_CD
AS MEM_GENDER,
v_MedicalClaim.MEM_DOB,
v_MedicalClaim.MEM_CURRENT_AGE_KEY
AS MEM_AGE,
CASE
WHEN v_MedicalClaim.SERVICE_YEAR_MONTH BETWEEN '201812'
AND '201911'
THEN
'PY'
ELSE
'CY'
END
AS REPORTING_YEAR,
v_MedicalClaim.SERVICE_DATE,
v_MedicalClaim.SERVICE_YEAR_MONTH,
v_MedicalClaim.PCP_NPI,
v_MedicalClaim.PCP_FULL_NAME,
v_MedicalClaim.PCP1_LEVEL1_NAME
AS PCP_REGION,
v_MedicalClaim.PCP2_LEVEL3_NAME,
v_MedicalClaim.SERVICING_PROVIDER_NPI,
v_MedicalClaim.SERVICING_PROVIDER_FULL_NAME,
v_MedicalClaim.REV_CODE,
v_MedicalClaim.PRODUCT_TYPE,
v_MedicalClaim.PRODUCT_GROUP_DESC,
v_MedicalClaim.SOURCE_CD,
v_MedicalClaim.SOURCE_NAME,
v_MedicalClaim.PROC_CODE,
v_MedicalClaim.PROC_DESC,
v_MedicalClaim.SERVICE_LEVEL1_DESC,
v_MedicalClaim.POS_CODE,
v_MedicalClaim.diag1,
v_MedicalClaim.AMT_PAID,
v_MedicalClaim.MDC,
v_MedicalClaim.MEG,
v_MedicalClaim.MEG_Desc,
v_MedicalClaim.MEG_Type_DESC,
v_MedicalClaim.MEG_TYPE,
v_MedicalClaim.MEG_TYPE_GROUP,
v_MedicalClaim.Stage,
v_MedicalClaim.Stage_Desc,
v_MedicalClaim.sdc_cd,
v_MedicalClaim.sdc_desc,
v_MedicalClaim.IP_STAY_NUM,
v_MedicalClaim.ER_VISIT_KEY,
v_MedicalClaim.EPISODE_NUM,
v_MedicalClaim.PRODUCT_TYPE
FROM DDW_HPH.dbo.v_MedicalClaim v_MedicalClaim
WHERE (v_MedicalClaim.SERVICE_YEAR_MONTH BETWEEN '201812' AND '202011')
ORDER BY v_MedicalClaim.AMT_PAID DESC
