i2b2 for PEDSnet

• Version: 2.0.1
• Release: beta+1
• URL: http://pedsnet.info

Tables

• concept_dimension
• i2b2
• observation_fact
• patient_dimension
• provider_dimension
• visit_dimension

concept_dimension

Fields

• concept_blob
• concept_cd
• concept_path
• download_date
• import_date
• name_char
• sourcesystem_cd
• update_date
• upload_id

concept_blob

Schema

• Type: string

concept_cd

Schema

• Type: string
• Length: 50

concept_path

Schema

• Type: string
• Length: 700

download_date

Schema

• Type: timestamp

import_date

Schema

• Type: timestamp

name_char

Schema

• Type: string
• Length: 2000

sourcesystem_cd

Schema

• Type: string
• Length: 50

update_date

Schema

• Type: timestamp

upload_id

Schema

• Type: number
• Precision: 38

i2b2

i2b2 ontology

Fields

• c_basecode
• c_columndatatype
• c_columnname
• c_comment
• c_dimcode
• c_facttablecolumn
• c_fullname
• c_hlevel
• c_metadataxml
• c_name
• c_operator
• c_path
• c_symbol
• c_synonym_cd
• c_tablename
• c_tooltip
• c_totalnum
• c_visualattributes
• download_date
• import_date
• m_applied_path
• m_exclusion_cd
• sourcesystem_cd
• update_date
• valuetype_cd

c_basecode

Schema

• Type: string
• Length: 50

c_columndatatype

Schema

• Type: string
• Length: 50

c_columnname

Schema

• Type: string
• Length: 50

c_comment

Schema

• Type: string

c_dimcode

Schema

• Type: string
• Length: 700

c_facttablecolumn

Schema

• Type: string
• Length: 950

c_fullname

Schema

• Type: string
• Length: 700

c_hlevel

Schema

• Type: number
• Precision: 22

c_metadataxml

Schema

• Type: string
• Length: 2048

c_name

Schema

• Type: string
• Length: 2048

c_operator

Schema

• Type: string
• Length: 10

c_path

Schema

• Type: string
• Length: 700

c_symbol

Schema

• Type: string
• Length: 50

c_synonym_cd

Schema

• Type: string
• Length: 1

c_tablename

Schema

• Type: string
• Length: 50

c_tooltip

Schema

• Type: string
• Length: 900

c_totalnum

Schema

• Type: number
• Precision: 22

c_visualattributes

Schema

• Type: string
• Length: 3

download_date

Schema

• Type: timestamp

import_date

Schema

• Type: timestamp

m_applied_path

Schema

• Type: string
• Length: 700

m_exclusion_cd

Schema

• Type: string
• Length: 25

sourcesystem_cd

Schema

• Type: string
• Length: 50

update_date

Schema

• Type: timestamp

valuetype_cd

Schema

• Type: string
• Length: 50

observation_fact

Fields

• concept_cd
• confidence_num
• download_date
• encounter_num
• end_date
• import_date
• instance_num
• location_cd
• modifier_cd
• nval_num
• observation_blob
• patient_num
• provider_id
• quantity_num
• sourcesystem_cd
• start_date
• tval_char
• units_cd
• update_date
• upload_id
• valtype_cd
• valueflag_cd

concept_cd

Schema

• Type: string
• Length: 50

confidence_num

Schema

• Type: float
• Precision: 18
• Scale: 5

download_date

Schema

• Type: timestamp

encounter_num

Refers to: visit_dimension / encounter_num

Schema

• Type: number
• Precision: 38

end_date

Schema

• Type: timestamp

import_date

Schema

• Type: timestamp

instance_num

Schema

• Type: number
• Precision: 18

location_cd

Schema

• Type: string
• Length: 50

modifier_cd

Schema

• Type: string
• Length: 100

nval_num

Schema

• Type: float
• Precision: 18
• Scale: 5

observation_blob

Schema

• Type: string
• Length: 900

patient_num

Refers to: patient_dimension / patient_num

Schema

• Type: number
• Precision: 38

provider_id

Schema

• Type: string
• Length: 50

quantity_num

Schema

• Type: float
• Precision: 18
• Scale: 5

sourcesystem_cd

Schema

• Type: string
• Length: 50

start_date

Schema

• Type: timestamp

tval_char

Schema

• Type: string
• Length: 255

units_cd

Schema

• Type: string
• Length: 50

update_date

Schema

• Type: timestamp

upload_id

Schema

• Type: number
• Precision: 38

valtype_cd

Schema

• Type: string
• Length: 50

valueflag_cd

Schema

• Type: string
• Length: 50

patient_dimension

Fields

• age_in_years_num
• birth_date
• death_date
• download_date
• ethnicity_cd
• gestational_age_num
• import_date
• income_cd
• language_cd
• marital_status_cd
• patient_blob
• patient_num
• race_cd
• religion_cd
• sex_cd
• sourcesystem_cd
• statecityzip_path
• update_date
• upload_id
• vital_status_cd
• zip_cd

age_in_years_num

Schema

• Type: number
• Precision: 38

birth_date

Schema

• Type: timestamp

death_date

Schema

• Type: timestamp

download_date

Schema

• Type: timestamp

ethnicity_cd

Schema

• Type: string
• Length: 200

gestational_age_num

Schema

• Type: number
• Precision: 38

import_date

Schema

• Type: timestamp

income_cd

Schema

• Type: string
• Length: 50

language_cd

Schema

• Type: string
• Length: 50

marital_status_cd

Schema

• Type: string
• Length: 50

patient_blob

Schema

• Type: string

patient_num

Schema

• Type: number
• Precision: 38

Inbound References

Total: 2

Table	Field	Name
observation_fact	patient_num	fpk_obs_fact_patient
visit_dimension	patient_num	fpk_visit_patient

race_cd

Schema

• Type: string
• Length: 50

religion_cd

Schema

• Type: string
• Length: 50

sex_cd

Schema

• Type: string
• Length: 50

sourcesystem_cd

Schema

• Type: string
• Length: 50

statecityzip_path

Schema

• Type: string
• Length: 700

update_date

Schema

• Type: timestamp

upload_id

Schema

• Type: number
• Precision: 38

vital_status_cd

Schema

• Type: string
• Length: 50

zip_cd

Schema

• Type: string
• Length: 50

provider_dimension

Fields

• dea
• department_id
• department_name
• download_date
• gender_cd
• import_date
• name_char
• npi
• provider_blob
• provider_id
• provider_path
• sourcesystem_cd
• specialty_source_c
• specialty_source_value
• update_date
• upload_id

dea

Schema

• Type: string
• Length: 50

department_id

Schema

• Type: integer

department_name

Schema

• Type: string
• Length: 254

download_date

Schema

• Type: timestamp

gender_cd

Schema

• Type: string
• Length: 254

import_date

Schema

• Type: timestamp

name_char

Schema

• Type: string
• Length: 850

npi

Schema

• Type: string
• Length: 50

provider_blob

Schema

• Type: string

provider_id

Schema

• Type: string
• Length: 50

provider_path

Schema

• Type: string
• Length: 700

sourcesystem_cd

Schema

• Type: string
• Length: 50

specialty_source_c

Schema

• Type: string
• Length: 254

specialty_source_value

Schema

• Type: string
• Length: 254

update_date

Schema

• Type: timestamp

upload_id

Schema

• Type: number
• Precision: 38

visit_dimension

Fields

• active_status_cd
• admit_src_destcd
• disch_disp_destcd
• disch_status_destcd
• download_date
• encounter_num
• end_date
• import_date
• inout_cd
• length_of_stay
• location_cd
• location_path
• patient_num
• provider_id
• sourcesystem_cd
• start_date
• update_date
• upload_id
• visit_blob

active_status_cd

Schema

• Type: string
• Length: 50

admit_src_destcd

Schema

• Type: string
• Length: 50

disch_disp_destcd

Schema

• Type: string
• Length: 50

disch_status_destcd

Schema

• Type: string
• Length: 50

download_date

Schema

• Type: timestamp

encounter_num

Schema

• Type: number
• Precision: 38

Inbound References

Total: 1

Table	Field	Name
observation_fact	encounter_num	fpk_obs_fact_visit

end_date

Schema

• Type: timestamp

import_date

Schema

• Type: timestamp

inout_cd

Schema

• Type: string
• Length: 50

length_of_stay

Schema

• Type: number
• Precision: 38

location_cd

Schema

• Type: string
• Length: 50

location_path

Schema

• Type: string
• Length: 900

patient_num

Refers to: patient_dimension / patient_num

Schema

• Type: number
• Precision: 38

provider_id

Schema

• Type: integer

sourcesystem_cd

Schema

• Type: string
• Length: 50

start_date

Schema

• Type: timestamp

update_date

Schema

• Type: timestamp

upload_id

Schema

• Type: number
• Precision: 38

visit_blob

Schema

• Type: string