Abbreviations of Database Terms

The Workforce Management (WFM) ETL Database Reference uses abbreviations throughout all topics to provide detailed information about and within the tables, including a concise listing of primary and foreign keys, default field values, and mandatory fields for each table. The field and index abbreviations are described here:

Field Characterizations

• P—Primary key
• M—Mandatory field
• F—Foreign key
• DV—Default value

Index Characterizations

• C—Cluster
• U—Unique