Line: 179 - 181
INSERT INTO [dbo].[PCORNET_ENC]([C_HLEVEL], [C_FULLNAME], [C_NAME], [C_SYNONYM_CD], [C_VISUALATTRIBUTES], [C_TOTALNUM], [C_BASECODE], [C_METADATAXML], [C_FACTTABLECOLUMN], [C_TABLENAME], [C_COLUMNNAME], [C_COLUMNDATATYPE], [C_OPERATOR], [C_DIMCODE], [C_COMMENT], [C_TOOLTIP], [M_APPLIED_PATH], [UPDATE_DATE], [DOWNLOAD_DATE], [IMPORT_DATE], [SOURCESYSTEM_CD], [VALUETYPE_CD], [M_EXCLUSION_CD], [C_PATH], [C_SYMBOL], [PCORI_BASECODE])
VALUES(3, '\PCORI\ENROLLMENT\ENR_BASIS\D\', 'Outpatient prescription drug coverage (v3.1)', 'N', 'LIE', NULL, 'ENR_BASIS:D', NULL, 'PATIENT_NUM', 'OBSERVATION_FACT', '1', 'N', '=', '0', 'CDMv3.1', 'Outpatient prescription drug coverage: The start and stop dates are based on enrollment where the health plan has any responsibility for covering outpatient prescription drugs for the member during this enrollment period (i.e., if you expect to observe outpatient pharmacy dispensings for this member during this enrollment period). (New value set item added in v3.1.)', '@', '20010101 00:00:00.0', '20010101 00:00:00.0', '20010101 00:00:00.0', 'PCORNET_CDMv3.1', NULL, NULL, '\PCORI\ENROLLMENT\ENR_BASIS\', 'D', 'ENR_BASIS:D')
GO
Issue & resolution: INSERT INTO [dbo].[PCORNET_ENC] should be INSERT INTO [dbo].[PCORNET_ENROLL]
File: upgradeV21to31.sql
Line: 179 - 181 INSERT INTO [dbo].[PCORNET_ENC]([C_HLEVEL], [C_FULLNAME], [C_NAME], [C_SYNONYM_CD], [C_VISUALATTRIBUTES], [C_TOTALNUM], [C_BASECODE], [C_METADATAXML], [C_FACTTABLECOLUMN], [C_TABLENAME], [C_COLUMNNAME], [C_COLUMNDATATYPE], [C_OPERATOR], [C_DIMCODE], [C_COMMENT], [C_TOOLTIP], [M_APPLIED_PATH], [UPDATE_DATE], [DOWNLOAD_DATE], [IMPORT_DATE], [SOURCESYSTEM_CD], [VALUETYPE_CD], [M_EXCLUSION_CD], [C_PATH], [C_SYMBOL], [PCORI_BASECODE]) VALUES(3, '\PCORI\ENROLLMENT\ENR_BASIS\D\', 'Outpatient prescription drug coverage (v3.1)', 'N', 'LIE', NULL, 'ENR_BASIS:D', NULL, 'PATIENT_NUM', 'OBSERVATION_FACT', '1', 'N', '=', '0', 'CDMv3.1', 'Outpatient prescription drug coverage: The start and stop dates are based on enrollment where the health plan has any responsibility for covering outpatient prescription drugs for the member during this enrollment period (i.e., if you expect to observe outpatient pharmacy dispensings for this member during this enrollment period). (New value set item added in v3.1.)', '@', '20010101 00:00:00.0', '20010101 00:00:00.0', '20010101 00:00:00.0', 'PCORNET_CDMv3.1', NULL, NULL, '\PCORI\ENROLLMENT\ENR_BASIS\', 'D', 'ENR_BASIS:D') GO
Issue & resolution: INSERT INTO [dbo].[PCORNET_ENC] should be INSERT INTO [dbo].[PCORNET_ENROLL]