Well, I can only tell you that my reading is borne out by experience with removing optional columns and adding columns of our own.
>From >epic_dimensions_load.sql<https://informatics.kumc.edu/work/browser/heron_load/epic_dimensions_load.sql>: alter table NightHerondata.patient_dimension drop (zip_cd) ; ... alter table NightHerondata.patient_dimension add (date_shift number) ; alter table NightHerondata.patient_dimension add (ssn varchar2(45)) ; alter table NightHerondata.patient_dimension add (age_in_years_num_hipaa number) ; alter table NightHerondata.patient_dimension add (birth_date_hipaa date) ; The way I2B2 dynamically builds queries from c_facttablecolumn, c_tablename, c_columnname, c_columndatatype, and c_operator is also suggestive of the reading that says we can add whatever columns we like to the dimension tables. -- Dan ________________________________ From: Greater Plains Collaborative Software Development [[email protected]] on behalf of Wilson Nathan [[email protected]] Sent: Monday, February 03, 2014 8:26 AM To: [email protected] Subject: Re: Minutes of GPV-DEV call 20140128 After reading that documentation I don’t think that it states precisely what you think it states? When I read the documentation; it states that there are required and optional attributes, and that there is not a limit to the number of optional attributes you use nor to the code sets and values used to populate these attribute. It doesn’t state that you can add columns as you desire, but rather that you can use the existing optional columns if you choose too. Nathan Wilson UW - Madison From: Greater Plains Collaborative Software Development [mailto:[email protected]] On Behalf Of Dan Connolly Sent: Sunday, February 02, 2014 11:53 PM To: [email protected] Subject: Re: Minutes of GPV-DEV call 20140128 I think I said that adding columns to the dimension tables such as patient_dimension has been a documented i2b2 technique as far back as 1.3 or 1.4. Double-checking, I find: "The Patient table may have an unlimited number of optional columns and their data types and coding systems are local implementation-specific." -- 3.3 PATIENT_DIMENSION i2b2 Clinical Research Chart (CRC) Design Document Document Version: 1.1 I2b2 Software Release: 1.4 https://www.i2b2.org/software/projects/hivecore/i2b2core-doc-14.zip I don't believe I had anything to say about what the slides said about modifiers (i.e. that they appear in 1.6). -- Dan ________________________________ From: Greater Plains Collaborative Software Development [[email protected]] on behalf of Campbell, James R [[email protected]] Sent: Tuesday, January 28, 2014 2:43 PM To: [email protected]<mailto:[email protected]> Subject: Minutes of GPV-DEV call 20140128 GPC standard data model JRC: i2b2 documentation reports changes in functionality by version (now 1.7). Will minimum version be required for data standardization? DC: although documentation reports differently, modifiers available in v1.3
