SVC_TIME_OF_DAY

Stores a row for every minute of the day to facilitate aggregation report by various time intervals.

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
SVC_TIME_OF_DAY_PK	TIME_OF_DAY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TIME_OF_DAY_ID	NUMBER		18	Yes	Generated number and primary key for this table.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
AM_PM_CD	VARCHAR2	30			Stores whether the time of the day is AM or PM.
HH12MI	VARCHAR2	30			Stores the 12 hour format of the time of the day.
HH24MI	VARCHAR2	30			Stores the 24 hour format of the time of the day.
HOUR_12	NUMBER		2		Stores the hour in the 12 hour format of the time of the day.
HOUR_24	NUMBER		2		Stores the hour in the 24 hour format of the time of the day.
MINUTE	NUMBER		2		Stores the minute of the time of the day.
QUARTER_HOUR	NUMBER		2		Stores the quarter hour num for the time of the day.
QUARTER_HOUR_OF_DAY	NUMBER		2		Stores the quarter hour of the day for the time of the day.
TIME_SESSION_CD	VARCHAR2	30			Stores the time session of the time of the day.

Indexes

Index	Uniqueness	Tablespace	Columns
SVC_TIME_OF_DAY_PK	Unique	Default	TIME_OF_DAY_ID