Effectivity View Suffix
Suffix for the PSA effectivity views, appended after the view name. A blank value falls back to the default _EFDT.
The effectivity view for an object is named with the Prefix Persistent View value, then the staging object name, then this suffix, in the staging schema. With the defaults, the effectivity view is named vw_<ObjectName>_EFDT. On Databricks without Unity Catalog, the schema name and an underscore are placed in front of the view name. Leading and trailing spaces in the value are removed.
When to Change This Setting
Keep the default _EFDT unless your naming convention calls for a different suffix on the PSA effectivity views.
Related Settings
| Setting | Interaction |
|---|---|
| Create Persistent View | Enables the persistent views, which include the PSA effectivity views |
| Prefix Persistent View | The prefix at the start of the view name |
| Current View Suffix | The equivalent suffix for the PSA current views |
| Effectivity View Suffix (Data Vault) | The equivalent suffix for Data Vault Satellite effectivity views |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
_EFDT.