Vault FK Field Name Pattern
Overview
Vault FK Field Name Pattern is a Data Vault parameter that defines the autogenerated foreign key field name corresponding to the vault hub ID. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID}, {TableID} and {ColumnName} placeholders.
Function
Use this setting to keep Data Vault object generation consistent across the project. AnalyticsCreator uses this value when no custom value is saved for the project. Keep placeholder names unchanged when adapting the pattern.
This value supports placeholders such as {TableName}, {SchemaName}, {FriendlyName}, {SchemaID}, {TableID}, {ColumnName}.
Access
The parameter is maintained from the Parameters list in AnalyticsCreator.
How to access
Navigation tree
Parameters->List Parameters
Toolbar
Options->Parameter
Diagram
Not opened from the diagram.
Visual element
Parameter list
Default value
VAULT_HUB_ID_{TableName}
Custom value
Not set.
Where it is used
This parameter belongs to the Data Vault group and is used when AnalyticsCreator applies Data Vault object generation.
| Setting | Value |
|---|---|
| Technical parameter name | VAULT_FK_FIELDNAME_PATTERN |
| Default value | VAULT_HUB_ID_{TableName} |
| Custom value | Not set. |
Parameter groups
| Group |
|---|
| Data Vault |
| Vault & Deps |
| Vault |
