PDM/PTS Column Lookup

The table below includes a list of columns from core tables available in the PDM tables (including CONDBASE and NEWBASE) and PTS tables (including ASMT, PARDAT, and APRVAL) within the FDW database (FDW3NF).

Use the search bar below to look for columns within a particular table (e.g. ASMT) or by column name (e.g. CNS_PID) to see which tables it appears in.

For comprehensive information on these tables, visit the PTS Documentation and User Guides internal SharePoint site.