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 API Name: CcDimDate_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DayDisplayName
• DayOfMonth
• DayOfWeek
• DayOfWeekLong
• DayOfWeekShort
• DayOfYear
• DayTimestamp
• Id
• InternalOrganizationId
• KQ_Id
• MonthDisplayName
• MonthId
• MonthOfYear
• MonthOfYearLong
• MonthOfYearShort
• MonthTimestamp
• QuarterDisplayName
• QuarterId
• QuarterLong
• QuarterOfYear
• QuarterShort
• QuarterTimestamp
• WeekDisplayName
• WeekId
• WeekOfYear
• WeekOfYearLong
• WeekOfYearShort
• WeekTimestamp
• WeekYearDisplayName
• WeekYearId
• WeekYearOfEra
• WeekYearTimestamp
• YearDisplayName
• YearId
• YearOfEra
• YearTimestamp

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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