Insight model score feed layout definition

This page provides the feed layout definition for the Insight Model Score Feed Layout. This feed is used to load model scores/segments to the Redpoint CDP based on an associated entity ID. The data is loaded to the appropriate tables in the data model.

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)`
Identity Id	`identity_id`	(Required) This field is the natural primary key. Uniquely identifies the record that insight information (model scores or segments) belongs to. Can support any of identity ID types described in the line below.	`char(320)`
Identity Id Type Code	`identity_id_type_code`	(Required) This field is the natural primary key. Defines the type of identity ID as party profile, email, individual, or household. Valid values: `party_profile_id` when identity ID contains source party profile ID `email_id` when identity ID contains RPG's email ID `individual_id` when identity ID contains RPG's individual ID `household_id` when identity ID contains RPG's household ID	`char(50)`
Business Unit Code	`business_unit_code`	Business Unit identifies the structure of brands within an organizational entity. It is the way in which the brands within a company's portfolio are related to, and differentiated from, one another. Values are defined as part of on-boarding, in `BUSINESS_UNIT_LOOKUP`; `NULL` values will default to `org`. Refer to Business unit for details.	`char(50)`
Source Model Id	`source_model_id`	(Required) This field is the natural primary key. Uniquely identifies a marketing model.	`char(50)`
Raw Score Type	`raw_score_type`	(Required) This field is the natural primary key. Supports multiple predictions per individual/model.	`varchar(64)`
Raw Score	`raw_score`	Raw model score. (The values or scores that are created can represent predictions of future values, but they might also represent a likely category or outcome.)	`decimal(12,6)`
Quartile Score	`quartile_score`	Quartile Score.	`decimal(12,6)`
Quintile Score	`quintile_score`	Quintile Score.	`decimal(12,6)`
Decile Score	`decile_score`	Decile Score.	`decimal(12,6)`
Demi Decile Score	`demi_decile_score`	Demi Decile Score.	`decimal(12,6)`
Score Datetime	`score_datetime`	(Required) This field is the natural primary key. Date when the model was run for this resolution: (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Segment Id	`segment_id`	Marketing Segment.	`varchar(20)`
Segment Value	`segment_value`	Marketing Segment.	`varchar(64)`
Segment Description	`segment_desc`	Marketing Segment.	`varchar(512)`
Segment Datetime	`segment_datetime`	(Required) This field is the natural primary key. Date when the segment was assigned for this resolution: (`YYYY-MM-DD HH:mm:ss`).	`datetime`
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`