1. User Guide
  2. APPENDIX A: Naming Conventions Used in OFSDF Data Model
  3. Naming Conventions Used in OFSDF PDM
  4. OFSDF Physical Data Model Naming Conventions
  5. PDM Logical View Mode Naming Conventions

42.1.1.1 PDM Logical View Mode Naming Conventions

In the logical view model, OFSDF PDM model tables and columns have descriptive names that readily convey the meaning and use of the element. In the logical view, names of tables and columns can have more than one word with the first letter of each word capitalized. Staging Area structures and Results Area structures have different name prefixes and suffixes as outlined in the following table.

Table 42-1 Prefixes and Suffixes for tables in the Logical View Mode of the Physical Data Model

PDM Area Table Type Prefix Suffix Example
Staging (Data Sourcing) All Tables Stage Stage Internet Transactions
Transaction Tables Transactions Stage Card Settlement Transactions
Master Tables Master Stage Product Master
Results (Datamart) All Fact Tables Fact Fact Process Cashflow
All Dimension Tables Dimension Account Dimension