PEDSnet/pedsnetcdm_to_pcornetcdm

Develop code to add census_block_group to OBS_GEN

Closed this issue · 5 comments

burrowse commented
  • Definition:
    • census block group of patient residence
  • Source:
    • pedsnet.location.census_block_group
  • Target Table
    • obs_gen
  • Metadata:
    • obsgen_type='LC'
    • obsgen_code='49084-7'
    • obs_gen_result_text= 'Census block group (2019)'
    • obsgen_table_modified='LDS'
    • obsgen_id_modified=addressid of corresponding record
burrowse commented

@shorrocka Thanks for working on this! Is this ready for testing as yet? I see some code added here:

pedsnetcdm_to_pcornetcdm/v4.4_to_v6.0/sql_etl/scripts/etl_scripts/n_obs_gen.sql

Line 196 in 40cd3aa

create table SITE_pcornet.census_block_group

shorrocka commented

Should be ready for testing!

burrowse commented

Code updated here: c84c07b . @shorrocka please review! Thanks!