KNTA_NOTIF_INTERVALS

This table stores definitions of intervals for email notifications.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_USERS	USER_ID	CREATED_BY

Column Name	Null?	Data Type	Description
INTERVAL_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
ENTITY_LAST_UPDATE_DATE	NOT NULL	DATE	Date a record in the entity was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
INTERVAL_NAME	NOT NULL	VARCHAR2(30)
DESCRIPTION	NULLABLE	VARCHAR2(240)
INTERVAL_TYPE_CODE	NOT NULL	VARCHAR2(30)
START_TIME	NOT NULL	DATE
END_TIME	NOT NULL	DATE
TIME_INTERVAL	NOT NULL	NUMBER
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
NEXT_SEND_TIME	NOT NULL	DATE
SUNDAY_FLAG	NOT NULL	VARCHAR2(1)
MONDAY_FLAG	NOT NULL	VARCHAR2(1)
TUESDAY_FLAG	NOT NULL	VARCHAR2(1)
WEDNESDAY_FLAG	NOT NULL	VARCHAR2(1)
THURSDAY_FLAG	NOT NULL	VARCHAR2(1)
FRIDAY_FLAG	NOT NULL	VARCHAR2(1)
SATURDAY_FLAG	NOT NULL	VARCHAR2(1)
SOURCE_TYPE_CODE	NULLABLE	VARCHAR2(30)
SOURCE	NULLABLE	VARCHAR2(100)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Index Name	Index Type	Sequence	Column Name
KNTA_NOTIFICATION_INTERVALS_U1	UNIQUE	1	INTERVAL_ID
KNTA_NOTIFICATION_INTERVALS_U2	UNIQUE	1	INTERVAL_NAME
SYS_C00109352509	UNIQUE	1	REFERENCE_CODE

This table uses no sequences.