Data Dictionary

Explore the following pages that help document the data resources available to DOF’s property modeling team:

• FDW to Vision Crosswalk: A table that contains FDW table names and their matching CAMA table names if applicable, as well as the prefix used and relevant primary keys for the table (unit of observation: table).
• REAL_PROP Column Lookup: A table that contains all columns for the most important REAL_PROP tables in the production database, including the column type, description, and if it is a primary key (unit of observation: column).
• PDM/PTS Column Lookup: A table that contains information for columns for PDM tables (notably: NEWBASE, CONDBASE) and PTS tables (notably: ASMT, PARDAT, and APRVAL) available in the FDW database (FDW3NF), including the column type, description, and additional notes if relevant (unit of observation: column).
• All Tables: This is a comprehensive list of all database tables within Production, FDW, and IAS databases, including the prefix used, number of columns in the table, and primary keys where relevant (unit of observation: table).

To download any of these data sets, visit the source data here.