Insight model feed layout definition

The following table represents the feed layout definition. This is used to get the information related to the analytic data models into the system so we can associate scores/segments to them for a given set of IDs.

Required fields are marked as (Required) in the field description column; fields not marked as required are optional.

Business name	Field name	Field description	Field data type/length
System of Record Name	`sor_name`	Name of the system that is the authoritative data source for a record.	`char(100)`
Source Model Id	`source_model_id`	(Required) This field is the natural primary key. Uniquely identifies a marketing model.	`char(50)`
Model Name	`model_name`	Name of the model.	`char(128)`
Model Version Number	`model_version_num`	(Required) Version number of the model to show multiple iterations/releases/versions of the model.	`char(32)`
Model Start Date	`model_start_date`	(Required) Effective enforce start date of the model: (`YYYY-MM-DD HH:mm:ss`).	`DATETIME`
Model End Date	`model_end_date`	Effective enforce end date of the model: (`YYYY-MM-DD HH:mm:ss`).	`DATETIME`
Model Description	`model_desc`	User provided description of the model.	`char(512)`
Model Type	`model_type`	Examples: Clustering; Classification; Regression; Recommender; p2purchase.	`varchar(50)`
Model Type Description	`model_type_desc`	A description of the entity identified by unique code or an identifier.	`varchar(100)`
Model Algorithm	`model_algorithm`	Model algorithm commonly used for customer segmentation (grouping customers based on specific qualities such as demographics or behavioral patterns).	`varchar(100)`
Source Record Create Datetime	`source_rec_create_datetime`	The datetime when the record was created at source system (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Source Record Update Datetime	`source_rec_update_datetime`	The datetime of the latest update of the record at source system (`YYYY-MM-DD HH:mm:ss`).	`datetime`