#186: Querying age by numerical constraints
-----------------------------------------+----------------------------
Reporter: huhickman | Owner: huhickman
Type: problem | Status: assigned
Priority: major | Milestone: data-domains2
Component: data-stds | Resolution:
Keywords: age valueset obesity-cohort | Blocked By:
Blocking: 67 |
-----------------------------------------+----------------------------
Comment (by huhickman):
We have the following indexes active on our `observation_fact` table:
||= INDEX_OWNER =||= INDEX_NAME =||= UNIQUENESS =||= STATUS =||=
INDEX_TYPE =||= COLUMNS =||
|| BLUEHERONDATA || OBS_FACT_PAT_NUM_BI || NONUNIQUE || VALID || BITMAP
|| PATIENT_NUM ||
|| BLUEHERONDATA || OBS_FACT_CON_CODE_B || NONUNIQUE || VALID ||
BITMAP || CONCEPT_CD ||
|| BLUEHERONDATA || OBS_FACT_MOD_CODE_BI || NONUNIQUE || VALID || BITMAP
|| MODIFIER_CD ||
|| BLUEHERONDATA || OBS_FACT_UPLOAD_ID_BI || NONUNIQUE || VALID || BITMAP
|| UPLOAD_ID ||
|| BLUEHERONDATA || FACT_CNPT_PAT_ENCT_IDX || NONUNIQUE || VALID || NORMAL
|| CONCEPT_CD, INSTANCE_NUM, PATIENT_NUM, ENCOUNTER_NUM ||
|| BLUEHERONDATA || OBS_FACT_VALTYPE_CD_BI || NONUNIQUE || VALID || BITMAP
|| VALTYPE_CD ||
The `FACT_CNPT_PAT_ENCT_IDX` is a standard i2b2 index. The others come
from the heron code base - though this is not all of the ones that exist
in the heron code base. I've been conservative in adding in indexes as we
go along.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/186#comment:12>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
