| Database | Number of tables |
|---|---|
| PTS | 88 |
| PDM | 73 |
| CAMA | 65 |
| NA | 1 |
FDW to Vision Table Crosswalk
There are currently 227 tables within the Financial Data Warehouse (FDW) database from PTS, PDM, and CAMA.
Crosswalk
The table below includes all FDW tables, but includes most complete information for those also in the V8_NEWYORK_NY_LIVE REAL_PROP schema. The primary keys column indicates the identifiers needed to obtain unique records in a database table.