Calendars

The Calendars view object contains information about the accounting calendars. The combination of PeriodSetName and PeriodType forms the unique identifier of the Calendars view object. For legacy accounting calendars migrated from instances prior to Oracle Fusion, CalendarId may have a one to many relationship with PeriodSetName.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.FiscalCalendarExtractPVO

Primary Keys : GlCalendarsCalendarId, GlCalendarsPeriodSetId, GlCalendarsPeriodType, GlCalendarsPeriodTypeId, GlCalendarsPeriodSetName

Initial Extract Date : GlCalendarsCreationDate

Incremental Extract Date : GlCalendarsLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
GlCalendarsAdjPeriodFreqCode	The frequency of adjusting periods in the calendar year. Possible values are one adjusting period at the end of the year, two adjusting periods at the end of the year, and one at the beginning and one at the end of the year.
GlCalendarsAdjPeriodsNum	The number of adjusting periods per year in the accounting calendar.
GlCalendarsAttribute1	A segment for the Calendars descriptive flexfield.
GlCalendarsAttribute2	A segment for the Calendars descriptive flexfield.
GlCalendarsAttribute3	A segment for the Calendars descriptive flexfield.
GlCalendarsAttribute4	A segment for the Calendars descriptive flexfield.
GlCalendarsAttribute5	A segment for the Calendars descriptive flexfield.
GlCalendarsAttributeCategory	The descriptive flexfield context name for the Calendars descriptive flexfield.
GlCalendarsCalendarId	The unique identifier of the accounting and commitment calendars.
GlCalendarsCalendarStartDate	The date when the first period of the accounting calendar begins.
GlCalendarsCalendarTypeCode	The type of an accounting calendar. Possible values are Accounting and Budgetary Control.
GlCalendarsCreatedBy	The user who created the accounting calendar.
GlCalendarsCreationDate	The date and time when the accounting calendar was created.
GlCalendarsDescription	The description of the AccountingCalendar entity object provided by the user or source application.
GlCalendarsLastUpdateDate	The date when the accounting calendar record was last updated.
GlCalendarsLastUpdateLogin	The session login associated with the user who last updated the accounting calendar.
GlCalendarsLastUpdatedBy	The user who last updated the accounting period.
GlCalendarsLatestYearStartDate	The start date of the latest year for which periods are generated.
GlCalendarsLegacyCalendarFlag	Indicates whether the accounting calendar is a legacy calendar. A list of accepted values is defined in the lookup type YES_NO.
GlCalendarsLegacyRulesEnabledFlag	Indicates whether the legacy rules for migration apply to the accounting calendar period. A list of accepted values is defined in the lookup type YES_NO.
GlCalendarsNonAdjPeriodFreqCode	The frequency of nonadjusting periods in the calendar year.
GlCalendarsNonAdjPeriodsNum	The number of nonadjusting periods per year in the accounting calendar.
GlCalendarsObjectVersionNumber	The number of times the accounting calendar record has been updated.
GlCalendarsPeriodNameFormatCode	The format for the accounting period name. A list of accepted values is defined in the lookup type CAL_PRD_FMT.
GlCalendarsPeriodNameSeparatorCode	The character that separates the period and year components of an accounting period name.
GlCalendarsPeriodSetId	The identifier of an accounting calendar.
GlCalendarsPeriodSetName	The name of the AccountingCalendar entity object.
GlCalendarsPeriodType	The type of the accounting period based on the calendar. For example, Weekly, Monthly, Quarterly, Yearly, and so on, as selected by the user.
GlCalendarsPeriodTypeId	The identifier of an accounting period type for an accounting calendar.
GlCalendarsSecurityFlag	Indicates whether the calendar setup definition is secured. A list of accepted values is defined in the lookup type YES_NO.
GlCalendarsUserPeriodNamePrefix	The optional string that's added at the beginning of an accounting period name to identify its nature, such as fiscal or quarter name.
GlCalendarsUserPeriodSetName	A user-defined period of time, extending from one date to another, that can be divided into accounting periods.