PJS_TIME_D

This table contains persistent time dimension information for use in Essbase.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PJS_TIME_D_PK	CAL_PERIOD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CALENDAR_ID	NUMBER		18		Time dimension calendar ID	Active
CAL_PERIOD_ID	NUMBER		18	Yes	Calendar period ID	Active
CAL_PERIOD_NAME	VARCHAR2	100			Calendar period name	Active
CAL_PERIOD_START_DATE	DATE				Calendar period start date	Active
CAL_PERIOD_END_DATE	DATE				Calendar period end date	Active
CAL_PERIOD_SPAN_IN_DAYS	NUMBER				Calendar period length in days	Active
CAL_QUARTER_ID	NUMBER		18		Calendar quarter ID	Active
CAL_QUARTER_NAME	VARCHAR2	100			Calendar quarter name	Active
CAL_QUARTER_START_DATE	DATE				Calendar quarter start date	Active
CAL_QUARTER_END_DATE	DATE				Calendar quarter end date	Active
CAL_QUARTER_SPAN_IN_DAYS	NUMBER				Calendar quarter length in days	Active
CAL_YEAR_ID	NUMBER		18		Calendar year ID	Active
CAL_YEAR_NAME	VARCHAR2	100			Calendar year name	Active
CAL_YEAR_START_DATE	DATE				Calendar year start date	Active
CAL_YEAR_END_DATE	DATE				Calendar year end date	Active
CAL_YEAR_SPAN_IN_DAYS	NUMBER				Calendar year length in days	Active
CAL_ALL_ID	NUMBER		18		Calendar top most node for Essbase	Active
CAL_ALL_NAME	VARCHAR2	100			Calendar top most node for Essbase	Active
CAL_ALL_START_DATE	DATE				Calendar top most node for Essbase	Active
CAL_ALL_END_DATE	DATE				Calendar top most node for Essbase	Active
CAL_ALL_SPAN_IN_DAYS	NUMBER				Calendar top most node for Essbase	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active
ALIAS_NAME	VARCHAR2	80			Alternate name to identify a member of time dimension in Smartview
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10	VARCHAR2	80			Descriptive Flexfield: segment of the user descriptive flexfield.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_TIME_D_N2	Non Unique	FUSION_TS_TX_DATA	CALENDAR_ID, CAL_PERIOD_NAME
PJS_TIME_D_N3	Non Unique	Default	CALENDAR_ID, CAL_PERIOD_START_DATE, CAL_PERIOD_END_DATE