Lookup tables: core

This is the set of lookup tables associated to the core data domain.

Party profile type

Party profile type indicates the type of party profile. In this example, the party profile type code is related to a prospect or consumer as it would in a retail application, but you may have patients and providers in a healthcare application.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (IGR)	`YES`	List of valid types of the party profile types: customer, prospect, patient, consumer, etc.	`PARTY_PROFILE_TYPE_LOOKUP`	`party_profile_type_code`	`party_profile_type_desc`
				`prospect`	Prospect is someone that has profile information, but does not have any transactions.
				`customer`	Customer (any type).

Party profile status

This lookup is related to the status of a given profile. For example, active and non_active are retail-related, but deactivated or dp_deleted are more general and may be related to deleting a record due to a request via a California Consumer Privacy Act (CCPA) request.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (IGR)	`YES`	Identifies a current status of the profile (active, not active, deleted, etc.).	`PARTY_PROFILE_STATUS_LOOKUP`	`party_profile_status_code`	`party_profile_status_desc`
				`active`	Active customer (transactions within N number of months).
				`non_active`	Non-active customer (no transactions within N number of months).
				`deactivated`	The profile has been deactivated based on the business rules; PII (Personally Identifiable Information) erased.
				`dp_deleted`	The profile has been deleted based on the DP rules; PII erased.

Business unit (BU)

Redpoint CDP supports multiple business units if a client has that type of data where there is a BU associated to the customer. This flexibility offers the ability to load data and calculate aggregates based on a specific business unit as opposed to lumping them all together. All of the business units need to be loaded to the lookup table before data for that BU will be loaded. BU is not a required field, but it is required for processing. Due to that, there is a field for this lookup only that indicates what the default value is and that will be used when BU is not provided in a feed layout. The default is enterprise, although that can be modified specifically for a client as well.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (All)	`YES`	Referenced in multiple feed layouts; BU 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.	`BUSINESS_UNIT_LOOKUP`	`business_unit_code`	`business_unit_desc`	`business_unit_id` (optional)
				`enterprise`	Organizational level	`1`
				custom value
				custom value
				custom value

Address type

This indicates which address type is being loaded when you provide an address in a feed that has address as an input. This lookup table does not allow custom values.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (`IGR`)	`NO`	The type of address, such as billing, shipping, home, business, secondary mailing address, etc.	`ADDRESS_TYPE_LOOKUP`	`address_type_code`	`address_type_desc`
				`billing`	Billing address
				`shipping`	Shipping address
				`home`	Home address
				`business`	Business address
				`secondary`	Secondary address
				`primary`	Primary address
				`not_provided`	Not provided

Email type

These are the type codes for the “other” email values that can be provided. If someone gives a different email for shipping, it could be marked with a type indicating that.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (`IGR`)	`NO`	The type of email address, such as billing, shipping, home, business, primary, etc.	`EMAIL_TYPE_LOOKUP`	`email_type_code`	`email_type_desc`
				`billing`	Billing email address
				`shipping`	Shipping email address
				`personal`	Personal email address
				`business`	Business email address
				`primary`	Primary email address
				`not_provided`	Not provided

Phone type

This indicates the type of phone that is being provided, if it was provided for a specific reason, like billing.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (`IGR`)	`NO`	The type of phone number, such as billing, shipping, home, business, primary, etc.	`PHONE_TYPE_LOOKUP`	`phone_type_code`	`phone_type_desc`
				`billing`	Billing phone
				`shipping`	Shipping phone
				`personal`	Personal phone
				`business`	Business phone
				`primary`	Primary phone
				`mobile`	Mobile phone
				`not_provided`	Not provided

Event disposition

Event disposition values are related to response event records. They are primarily used to identify the different email disposition values.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (`EMAIL_SUMMARY`, `IRG`)	`NO`	Referenced in response event feed layout. Disposition code for phone (wrong number, not valid phone, etc.), for direct mail (mail returned, undeliverable as addressed, etc.), or for email (hard bounce, soft bounce, opened, click through, delivered).	`EVENT_DISPOSITION_LOOKUP`	`disposition_code`	`disposition_desc`
				`bounced`	Bounced email
				`clicked`	Email was clicked on
				`undeliverable`	Email or mail is undeliverable
				`opened`	Email was opened
				`processed`	Email or Mail was processed
				`reported_as_spam`	Email was reported as spam
				`unsubscribed`	Email was unsubscribed
				`sent`	Email was sent
				`delivered`	Email was delivered
				`forward`	Email was forwarded
				`group_unsubscribes`	Group unsubscribes
				`group_resubscribes`	Group resubscribes
				`dropped`	Dropped email
				`not_provided`	Not provided

Account type

Account type code to indicate the type of account that is being provided.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
No	`YES`	List of valid account types: ECommerce, membership, loyalty, etc.	`ACCOUNT_TYPE_LOOKUP`	`account_type_code`	`account_type_desc`
				`e-com`	E-commerce account
				`member`	Membership account
				`loyalty`	Loyalty account
				`customer`	Customer account
				`not_provided`	Not provided
				custom value
				custom value

Loyalty account tier

This supports the use of tiers for loyalty accounts, for example, bronze, silver, and gold. Using this lookup, you can indicate a current tier as well as the previous and next tier for a member.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's (Individual Loyalty Summary) if provided	`YES`	Referenced in loyalty account membership feed layout; loyalty account tiers, for example: Tier Spend Range: Base $0-$399.99 Plus $400-$1199.99 and 2 visits VIP $1200+ and 2 visits	`LOYALTY_ACCOUNT_TIER_LOOKUP`	`loyalty_account_tier_code`	`loyalty_account_tier_desc`
				`not_provided`	Not provided
				custom value
				custom value
				custom value

Location status

This lookup indicates the status of a location. Someone may have a transaction at a closed location, and we don’t want to lose that link, so we advise clients to provide both open and closed locations. There may also be a state of “opening soon” that could be useful if you want to notify customers about a store opening near them that is not the current store that they shop at.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's	`NO`	Identifies if the location is currently closed, open, or opening soon.	`LOCATION_STATUS_LOOKUP`	`location_status_code`	`location_status_desc`
				`open`	Open
				`closed`	Closed
				`soon_open`	Opening soon
				`not_provided`	Not provided

Location type

This indicates the type of location that is being provided. Some locations like a warehouse or headquarters may be useful to have in the CDP, but do not have a transaction or some other activity associated to them.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
Used in Agg Calc's	`YES`	Type of location as physical, mobile, or virtual location: Examples below (could have more types): B&M (brick and mortar store) WEB (website) Warehouse Headquarters	`LOCATION_TYPE_LOOKUP`	`location_type_code`	`location_type_desc`
				`b&m`	Brick and mortar store
				`web`	Web store
				`warehouse`	Warehouse
				`headquarters`	Headquarters
				`not_provided`	Not provided
				`pharmacy`	Pharmacy
				`custom value`

Channel

This indicates the type of channel when loading campaign event data. This helps identify the channel that the event is associated to.

Used in Agg Calc	Custom Values Allowed	Reference Information Description	Target DB object	Reference Information Data Element 1	Reference Information Data Element 2
NO	`YES`	List of values that identify the way communications get to the end-user, the consumer (customer or prospect).	`CHANNEL_LOOKUP`	`channel_code`	`channel_desc`
				`soc_media`	Social media
				`email`	Email
				`direct_mail`	Direct mail
				`phone`	Phone (non SMS)
				`fax`	Fax
				`web`	Website
				`sms`	SMS (text message)
				`data_onboarding`	Channels used for data onboarding
				`general`	Other channels