Top
i2b2
Tables
concept_dimension
Fields
concept_blob
Schema
concept_cd
Schema
concept_path
Schema
download_date
Schema
import_date
Schema
name_char
Schema
- Type:
string
- Length: 2000
sourcesystem_cd
Schema
update_date
Schema
upload_id
Schema
- Type:
number
- Precision: 38
i2b2
Fields
c_basecode
Schema
c_columndatatype
Schema
c_columnname
Schema
Schema
c_dimcode
Schema
c_facttablecolumn
Schema
c_fullname
Schema
c_hlevel
Schema
- Type:
number
- Precision: 22
Schema
c_name
Schema
c_operator
Schema
c_path
Schema
c_symbol
Schema
c_synonym_cd
Schema
c_tablename
Schema
Schema
c_totalnum
Schema
- Type:
number
- Precision: 22
c_visualattributes
Schema
download_date
Schema
import_date
Schema
m_applied_path
Schema
m_exclusion_cd
Schema
sourcesystem_cd
Schema
update_date
Schema
valuetype_cd
Schema
observation_fact
Fields
concept_cd
Schema
confidence_num
Schema
- Type:
float
- Precision: 18
- Scale: 5
download_date
Schema
encounter_num
Schema
- Type:
number
- Precision: 38
end_date
Schema
import_date
Schema
instance_num
Schema
- Type:
number
- Precision: 18
location_cd
Schema
modifier_cd
Schema
nval_num
Schema
- Type:
float
- Precision: 18
- Scale: 5
observation_blob
Schema
patient_num
Schema
- Type:
number
- Precision: 38
provider_id
Schema
quantity_num
Schema
- Type:
float
- Precision: 18
- Scale: 5
sourcesystem_cd
Schema
start_date
Schema
tval_char
Schema
units_cd
Schema
update_date
Schema
upload_id
Schema
- Type:
number
- Precision: 38
valtype_cd
Schema
valueflag_cd
Schema
patient_dimension
Fields
age_in_years_num
Schema
- Type:
number
- Precision: 38
birth_date
Schema
death_date
Schema
download_date
Schema
ethnicity_cd
Schema
import_date
Schema
income_cd
Schema
language_cd
Schema
marital_status_cd
Schema
patient_blob
Schema
patient_num
Schema
- Type:
number
- Precision: 38
race_cd
Schema
religion_cd
Schema
sex_cd
Schema
sourcesystem_cd
Schema
statecityzip_path
Schema
update_date
Schema
upload_id
Schema
- Type:
number
- Precision: 38
vital_status_cd
Schema
zip_cd
Schema
provider_dimension
Fields
download_date
Schema
import_date
Schema
name_char
Schema
provider_blob
Schema
provider_id
Schema
provider_path
Schema
sourcesystem_cd
Schema
update_date
Schema
upload_id
Schema
- Type:
number
- Precision: 38
visit_dimension
Fields
active_status_cd
Schema
download_date
Schema
encounter_num
Schema
- Type:
number
- Precision: 38
end_date
Schema
import_date
Schema
inout_cd
Schema
length_of_stay
Schema
- Type:
number
- Precision: 38
location_cd
Schema
location_path
Schema
patient_num
Schema
- Type:
number
- Precision: 38
sourcesystem_cd
Schema
start_date
Schema
update_date
Schema
upload_id
Schema
- Type:
number
- Precision: 38
visit_blob
Schema