Table layouts for ZTRAX files.

A dataset containing the full ZTRAX database schema (available in Layout.xslx). In addition to the original columns from ZTRAX documentation, there are also columns with the table and column names and data types as they will appear in the database. While the raw files use UpperCamelCase, they will be changed to snake_case in the database, and data types will be adjusted from SQL Server to PostgreSQL. The ztrax_lyout dataframe also contains the format in which each column will be read into R, displayed as the standard format abbreviations passed to readr::cols().

ztrax_layout

Format

A data frame with 814 rows and 8 variables:

ztype_raw

Transaction ("ZTrans") or Assessment ("ZAsmt")

table_name_raw

Table name as in flat files

table_name_db

Table name as in database

column_name_raw

Column names as in flat files

column_name_db

Column names as in database

data_type_r

Column formats to be read into R as standard abbreviations to be passed to readr::cols()

data_type_db

Column formats to be used in database

primary_key

Indicates that the column is a primary key for the table. There may be multiple columns that are a composite key.

Details

All columns *_raw are in UpperCamelCase and represent information directly from ZTRAX documentation and flat files, and columns *_db are in snake_case and represent information as it will be in SQL database.