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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions