Skip to content

visit_detail.visit_detail_type_concept_id is misspelled in the bigquery test database #11

@ablack3

Description

@ablack3
image
library(DatabaseConnector)
connectionDetails <- createConnectionDetails(dbms="bigquery",
                                             connectionString=Sys.getenv("BIGQUERY_CONNECTION_STRING"),
                                             user="",
                                             password='')


con <- connect(connectionDetails)
#> Connecting using BigQuery driver

df <- querySql(con, "select * from synpuf_110k.visit_detail limit 1")

df
#>  [1] VISIT_DETAIL_ID                PERSON_ID                     
#>  [3] VISIT_DETAIL_CONCEPT_ID        VISIT_DETAIL_START_DATE       
#>  [5] VISIT_DETAIL_START_DATETIME    VISIT_DETAIL_END_DATE         
#>  [7] VISIT_DETAIL_END_DATETIME      VISIT_DEATIL_TYPE_CONCEPT_ID  
#>  [9] PROVIDER_ID                    CARE_SITE_ID                  
#> [11] ADMITTING_SOURCE_CONCEPT_ID    DISCHARGE_TO_CONCEPT_ID       
#> [13] PRECEDING_VISIT_DETAIL_ID      VISIT_DETAIL_SOURCE_VALUE     
#> [15] VISIT_DEATIL_SOURCE_CONCEPT_ID ADMITTING_SOURCE_VALUE        
#> [17] DISCHARGE_TO_SOURCE_VALUE      VISIT_DETAIL_PARENT_ID        
#> [19] VISIT_OCCURRENCE_ID           
#> <0 rows> (or 0-length row.names)

"VISIT_DEATIL_SOURCE_CONCEPT_ID" %in% names(df)
#> [1] TRUE

disconnect(con)

@konstjar Can you fix this? DETAIL is mispelled in the visit_detail.visit_detail_type_concept_id column in both the synpuf_110k schema and synpuf_2m schemas.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions