ZCA_BI_CRM_CAL_PERIOD

This table stores Gregorian and Accounting Calendar information at period level.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
ZCA_BI_CRM_CAL_PERIOD_PK	FISCAL_PERIOD_NUMBER, FISCAL_PERIOD_START_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
FISCAL_PERIOD_SET_ID	NUMBER		18	Yes	defaulted to -1.	Active
ADJUSTMENT_PERIOD_FLAG	VARCHAR2	1		Yes	Calendar period adjustment status.	Active
FISCAL_PERIOD_SET_NAME	VARCHAR2	15		Yes	Name of the accounting calendar.	Active
FISCAL_PERIOD_TYPE	VARCHAR2	15		Yes	Accounting period type. Examples are Weekly, Monthly, Quarterly	Active
FISCAL_PERIOD_NAME	VARCHAR2	15		Yes	System generated accounting period name.	Active
FISCAL_PERIOD_NUMBER	NUMBER		18	Yes	Unique period number within accounting calendar year.	Active
FISCAL_QUARTER_NUMBER	NUMBER		18	Yes	Quarter number of accounting period.	Active
FISCAL_YEAR_NUMBER	NUMBER		18	Yes	Denotes the accounting calendar year represented by a numerical value, such as 2009.	Active
FISCAL_PERIOD_START_DATE	DATE			Yes	Date when the accounting period begins.	Active
FISCAL_PERIOD_END_DATE	DATE				Date when the accounting period ends.	Active
FISCAL_QUARTER_START_DATE	DATE				Date when the quarter containing this accounting period starts.	Active
FISCAL_QUARTER_END_DATE	DATE				Date when the quarter containing this accounting period ends.	Active
FISCAL_YEAR_START_DATE	DATE				Date when the year containing this accounting period starts.	Active
FISCAL_YEAR_END_DATE	DATE				Date when the year containing this accounting period ends.	Active
ENTERPRISE_QUARTER	VARCHAR2	83			It is a concatenation of Fiscal Year Number and 'Q' and Fiscal Quarter Number.	Active
ENTERPRISE_YEAR	VARCHAR2	40			Enterprise year.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
ENTERPRISE_ID	NUMBER		18		ENTERPRISE_ID	Active
CALENDAR_ID	NUMBER		18		CALENDAR_ID	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZCA_BI_CRM_CAL_PERIOD_U1	Unique	Default	FISCAL_PERIOD_NUMBER, FISCAL_PERIOD_START_DATE
ZCA_BI_CRM_CAL_PERIOD_U2	Unique	FUSION_TS_TX_IDX	FISCAL_PERIOD_NAME, FISCAL_PERIOD_SET_NAME	Active