ETL-CDMBuilder INPATIENT_SERVICES table issue
The builder is expecting a column (dx5) that doesn’t seem to exists in Truven CCAE (2015) data.
Error from Source: Amazon Redshift ODBC Driver: Message: ERROR  [Amazon]Amazon Redshift Error occurred while trying to execute a query: [SQLState 42703] ERROR: column "dx5" does not exist in inpatient_services, ch, unnamed_join
The following columns are part of these data (taken from the Truven sample data):
SEQNUM VERSION DX1 DX2 DXVER PROC1 PROCTYP CASEID DISDATE DOBYR YEAR ADMDATE AGE CAP_SVC COB COINS COPAY DEDUCT DRG DX3 DX4 FACHDID FACPROF MHSACOVG MSCLMID NETPAY NPI NTWKPROV PAIDNTWK PAY PDDATE PDX PPROC PROCMOD PROVID QTY REVCODE SVCDATE SVCSCAT TSVCDAT UNITS ADMTYP MDC DSTATUS STDPLAC STDPROV EFAMID ENROLID PLANTYP REGION MSA DATATYP AGEGRP EECLASS EESTATU EGEOLOC EIDFLAG EMPREL ENRFLAG PHYFLAG RX SEX HLTHPLAN INDSTRY
Any advice on a work around will be appreciated.