######################################################
###        Prodcom Correspondence 2017 - 2016      ###
######################################################

dsource register "PRC_CORRESPONDENCE"                           \
    type    delimitedFile                                       \
    file    "$(dir.datasource)/data.csv"                        \
    header  true                                                \
    quote   '"'

tupletable create ufrd:PRC_CORRESPONDENCE                       \
    dataSourceName  "PRC_CORRESPONDENCE"                        \
    "columns"       2                                           \
    "1"             "{2}"                                       \
    "1.datatype"    "string"                                    \
    "1.if-empty"    "absent"                                    \
    "2"             "{3}"                                       \
    "2.datatype"    "string"                                    \
    "2.if-empty"    "absent"

    # 1 This is the PRC ClassificationCodes for 2017-2018
    # 1 if blank the corresponding code was deleted
    # 2 This is the PRC ClassificationCodes for 2016
    # 2 if blank the corresponding code was added
