Cc Fact Customer Registration DMO

This DMO contains customer registration fact data from ccdw_fact_customer_registration. Each record represents a customer registration event, capturing visitor, customer, and site context along with temporal dimensions.

Object Properties

Object API Name: CcFactCustomerRegistration_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

Relationships

• UtcRegistrationDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• UtcRegistrationTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardRegistrationDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• StandardRegistrationTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardRegistrationTimezoneId has a FOREIGNKEY relationship with the Cc Dim Time Zone DMO Id field.
• RegistrationSiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.
• CustomerId has a FOREIGNKEY relationship with the Cc Dim Customer DMO Id field.
• LocaleId has a FOREIGNKEY relationship with the Cc Dim Locale DMO Id field.
• UserAgentId has a FOREIGNKEY relationship with the Cc Dim User Agent DMO Id field.

Fields

• cdp_sys_record_currency
• CustomerId
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• KQ_CustomerId
• KQ_Id
• KQ_LocaleId
• KQ_RegistrationSiteId
• KQ_StandardRegistrationDayId
• KQ_StandardRegistrationTimeId
• KQ_StandardRegistrationTimezoneId
• KQ_UserAgentId
• KQ_UtcRegistrationDayId
• KQ_UtcRegistrationTimeId
• LocaleId
• RegistrationSiteId
• StandardRegistrationDayId
• StandardRegistrationTimeId
• StandardRegistrationTimestamp
• StandardRegistrationTimezoneId
• UserAgentId
• UtcRegistrationDayId
• UtcRegistrationTimeId
• UtcRegistrationTimestamp
• UtcUpdateTimestamp
• VisitorIdentifier

cdp_sys_record_currency

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

CustomerId

• Field API Name: CustomerId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_customer.

DataSourceId

• Field API Name: DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

Id

• Field API Name: Id__c
• Data Type: DOUBLE
• Description: Unique identifier for a customer registration.

InternalOrganizationId

• Field API Name: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

KQ_CustomerId

• Field API Name: KQ_CustomerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CustomerId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_LocaleId

• Field API Name: KQ_LocaleId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocaleId

KQ_RegistrationSiteId

• Field API Name: KQ_RegistrationSiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RegistrationSiteId

KQ_StandardRegistrationDayId

• Field API Name: KQ_StandardRegistrationDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardRegistrationDayId

KQ_StandardRegistrationTimeId

• Field API Name: KQ_StandardRegistrationTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardRegistrationTimeId

KQ_StandardRegistrationTimezoneId

• Field API Name: KQ_StandardRegistrationTimezoneId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardRegistrationTimezoneId

KQ_UserAgentId

• Field API Name: KQ_UserAgentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UserAgentId

KQ_UtcRegistrationDayId

• Field API Name: KQ_UtcRegistrationDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcRegistrationDayId

KQ_UtcRegistrationTimeId

• Field API Name: KQ_UtcRegistrationTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcRegistrationTimeId

LocaleId

• Field API Name: LocaleId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_locale.

RegistrationSiteId

• Field API Name: RegistrationSiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site where the registration occurred.

StandardRegistrationDayId

• Field API Name: StandardRegistrationDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the standard registration day.

StandardRegistrationTimeId

• Field API Name: StandardRegistrationTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the standard registration time.

StandardRegistrationTimestamp

• Field API Name: StandardRegistrationTimestamp__c
• Data Type: DATETIME
• Description: Timestamp of the registration, in standard time.

StandardRegistrationTimezoneId

• Field API Name: StandardRegistrationTimezoneId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_timezone for the standard registration time zone.

UserAgentId

• Field API Name: UserAgentId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_user_agent.

UtcRegistrationDayId

• Field API Name: UtcRegistrationDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the UTC registration day.

UtcRegistrationTimeId

• Field API Name: UtcRegistrationTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the UTC registration time.

UtcRegistrationTimestamp

• Field API Name: UtcRegistrationTimestamp__c
• Data Type: DATETIME
• Description: UTC timestamp of the registration.

UtcUpdateTimestamp

• Field API Name: UtcUpdateTimestamp__c
• Data Type: DATETIME
• Description: Last modified UTC timestamp of this record.

VisitorIdentifier

• Field API Name: VisitorIdentifier__c
• Data Type: TEXT
• Description: Anonymous visitor ID.