Salesforce Docs Portal

Cc Dim Date DMO

This DMO contains various attributes related to dates, providing detailed temporal information. Each record represents a calendar date and its component parts (year, quarter, month, week, day).

Object Properties

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

Fields

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.

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.

DayDisplayName

  • Field API Name: DayDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the day.

DayOfMonth

  • Field API Name: DayOfMonth__c
  • Data Type: DOUBLE
  • Description: Day number within the month (1-31).

DayOfWeek

  • Field API Name: DayOfWeek__c
  • Data Type: DOUBLE
  • Description: Day number within the week (for example, 1 for Monday).

DayOfWeekLong

  • Field API Name: DayOfWeekLong__c
  • Data Type: TEXT
  • Description: Long name for the day of the week (for example, "Monday").

DayOfWeekShort

  • Field API Name: DayOfWeekShort__c
  • Data Type: TEXT
  • Description: Short name for the day of the week (for example, "Mon").

DayOfYear

  • Field API Name: DayOfYear__c
  • Data Type: DOUBLE
  • Description: Day number within the year (1-366).

DayTimestamp

  • Field API Name: DayTimestamp__c
  • Data Type: DATEONLY
  • Description: Timestamp representing the start of the day.

Id

  • Field API Name: Id__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a specific day.

InternalOrganizationId

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

KQ_Id

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

MonthDisplayName

  • Field API Name: MonthDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the month (for example, 'January')

MonthId

  • Field API Name: MonthId__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a specific month.

MonthOfYear

  • Field API Name: MonthOfYear__c
  • Data Type: DOUBLE
  • Description: Month number within the year (1-12).

MonthOfYearLong

  • Field API Name: MonthOfYearLong__c
  • Data Type: TEXT
  • Description: Long representation of the month of the year (for example, 'Jan').

MonthOfYearShort

  • Field API Name: MonthOfYearShort__c
  • Data Type: TEXT
  • Description: Short representation of the month of the year.

MonthTimestamp

  • Field API Name: MonthTimestamp__c
  • Data Type: DATEONLY
  • Description: Timestamp representing the start of the month.

QuarterDisplayName

  • Field API Name: QuarterDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the quarter

QuarterId

  • Field API Name: QuarterId__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a specific quarter.

QuarterLong

  • Field API Name: QuarterLong__c
  • Data Type: TEXT
  • Description: Long representation of the quarter.

QuarterOfYear

  • Field API Name: QuarterOfYear__c
  • Data Type: DOUBLE
  • Description: Quarter number within the year (1-4).

QuarterShort

  • Field API Name: QuarterShort__c
  • Data Type: TEXT
  • Description: Short representation of the quarter.

QuarterTimestamp

  • Field API Name: QuarterTimestamp__c
  • Data Type: DATEONLY
  • Description: Timestamp representing the start of the quarter.

WeekDisplayName

  • Field API Name: WeekDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the week.

WeekId

  • Field API Name: WeekId__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a specific week.

WeekOfYear

  • Field API Name: WeekOfYear__c
  • Data Type: DOUBLE
  • Description: Week number within the year (1-53).

WeekOfYearLong

  • Field API Name: WeekOfYearLong__c
  • Data Type: TEXT
  • Description: Long representation of the week of the year.

WeekOfYearShort

  • Field API Name: WeekOfYearShort__c
  • Data Type: TEXT
  • Description: Short representation of the week of the year.

WeekTimestamp

  • Field API Name: WeekTimestamp__c
  • Data Type: DATEONLY
  • Description: Timestamp representing the start of the week.

WeekYearDisplayName

  • Field API Name: WeekYearDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the week-year.

WeekYearId

  • Field API Name: WeekYearId__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a specific week-year.

WeekYearOfEra

  • Field API Name: WeekYearOfEra__c
  • Data Type: DOUBLE
  • Description: Week-year number within its era.

WeekYearTimestamp

  • Field API Name: WeekYearTimestamp__c
  • Data Type: DATEONLY
  • Description: Timestamp representing the start of the week-year.

YearDisplayName

  • Field API Name: YearDisplayName__c
  • Data Type: TEXT
  • Description: User-friendly display name for the year.

YearId

  • Field API Name: YearId__c
  • Data Type: DOUBLE
  • Description: Unique identifier for a specific year.

YearOfEra

  • Field API Name: YearOfEra__c
  • Data Type: DOUBLE
  • Description: Year number within its era.

YearTimestamp

  • Field API Name: YearTimestamp__c
  • Data Type: DATEONLY
  • Description: Timestamp representing the start of the year.