Context Navigation

Changes between Version 59 and Version 60 of LEGACY - i2b2OntologyCRC-1

v59	v60
161	161	First of all it's interesting to note that patient information can/is duplicated across patient_dimension and observation_fact tables. My reading of the situation is that the entry 'DEM\|RELIGION:jewish' in the fact table is '''''identical''''' with the 'jewish' entry in the patient_dimension table. The patient_dimension table has the value in column named RELIGION_CD which in effect replaces the name-space 'DEM\|RELIGION:' that prefixes the value in the observation_fact table. So I would argue these are identical. The code_lookup table in column CODE_CD is using the full name-space qualified code. For human readability (for reports etc) the value to use is in the NAME_CHAR column. [[br]]
162	162
163		It appears the code_lookup table is just what it says. It allows data to be stored in coded form but displayed (when required) in human readable form.
	163	It appears the code_lookup table is just what it says. It allows data to be stored in coded form but displayed (when required) in human readable form. [[br]]
	164
	165	The columns within the patient_dimension table are optional columns. Beware of this omission of a name space within optional columns. I'm not completely sure of all its ramifications.