- DarkLight
Campaign Business Fields
- DarkLight
Source Table | Column Name | Display Name | Data Type | Description | Platform |
---|---|---|---|---|---|
OBD_Campaign_BusinessFields | CampaignId | CampaignId | nvarchar (64) (not null) | This is the auto-generated unique identifier for the user. | All |
OBD_Campaign_BusinessFields | FieldName | FieldName | nvarchar (64) (not null) | The business fields configured for the campaign. All the business fields are listed. | All |
OBD_Campaign_BusinessFields | DataType | DataType | nvarchar (32) (not null) | The data type for the business field – Number, Float, or DateTime. | All |
OBD_Campaign_BusinessFields | Format | Format | nvarchar (32) (not null) | If the business field data type is field, the format of the date. | All |
OBD_Campaign_BusinessFields | BusinessField | BusinessField | nvarchar (32) (not null) | The business field ID generated by the application. | All |
OBD_Campaign_BusinessFields | SQLExpression | SQLExpression | nvarchar (64) (not null) | The business fields with data type other than string are cast in this column with the business field ID. | All |
OBD_Campaign_BusinessFields | IsEMailMapped | IsEMailMapped | bit (null) | Indicates whether the business field is mapped to email functionality. | All |
OBD_Campaign_BusinessFields | IsSMSMapped | IsSMSMapped | bit (null) | Indicates whether the business field is mapped to SMS functionality. | All |
OBD_Campaign_BusinessFields | IsDNCMapped | IsDNCMapped | bit (null) | Indicates whether the business field is mapped to the Do Not Call (DNC) list. | All |
OBD_Campaign_BusinessFields | BusinessTypeId | BusinessTypeId | int (null) | Represents the identifier for the type of business associated with the campaign. | All |
OBD_Campaign_BusinessFields | Editable | Editable | bit (null) | Indicates whether the business field is editable. | All |
OBD_Campaign_BusinessFields | SequenceID | SequenceID | bit (null) | Represents whether the business field has a specific sequence ID for ordering. | All |
OBD_Campaign_BusinessFields | IsMax | IsMax | int (null) | Indicates the maximum value or limit for the business field, if applicable. | All |
OBD_Campaign_BusinessFields | Viewable | Viewable | bit (not null) | Indicates whether the business field is viewable in the application. | All |
OBD_Campaign_BusinessFields | IsIVRMapped | IsIVRMapped | bit (not null) | Indicates whether the business field is mapped to the IVR system. | All |
OBD_Campaign_BusinessFields | IsSNSMapped | IsSNSMapped | bit (null) | Indicates whether the business field is mapped to SNS functionality. | All |
OBD_Campaign_BusinessFields | CharacterLength | CharacterLength | nvarchar (3) (null) | Represents the maximum allowable length of characters for the business field, as a string value. | All |
OBD_Campaign_BusinessFields | CustomerMaster | CustomerMaster | nvarchar (250) (null) | Contains customer-related data associated with the campaign, with a maximum length of 250 characters. | All |
OBD_Campaign_BusinessFields | TenantID | TenantID | int (null) | The unique identifier for the tenant, auto-generated by the application. | All |
OBD_Campaign_BusinessFields | SubTenantID | SubTenantID | int (null) | The unique identifier for the sub-tenant, auto-generated by the application. | All |