KNTA_TS_APPROVAL_REMINDER_SENT

This table tracks whether approval reminder notifications have been sent for timesheets to prevent duplicate emails.

For one-time reminders, a record is inserted once and never updated. For recurring reminders, SENT_DATE is updated each time a reminder is sent, at most once per day.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
TM_TIME_SHEETS	TIME_SHEET_ID	TIME_SHEET_ID
KNTA_NOTIFICATIONS	NOTIFICATION_ID	NOTIFICATION_ID

Column Descriptions

Column Name	Null?	Data Type	Description
ID	NOT NULL	NUMBER(19,0)	Surrogate primary key.
TIME_SHEET_ID	NOT NULL	NUMBER(19,0)	Identifier of the timesheet.
NOTIFICATION_ID	NOT NULL	NUMBER(19,0)	Identifier of the notification.
SENT_DATE	NOT NULL	DATE	Date/time when the system sent the reminder.

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_TS_APPROVAL_REMINDER_SENT_PKEY	UNIQUE	1	ID
KNTA_TS_APPROVAL_REM_TSID_NOTIFID_KEY	UNIQUE	1	TIME_SHEET_ID
KNTA_TS_APPROVAL_REM_TSID_NOTIFID_KEY	UNIQUE	2	NOTIFICATION_ID

Sequences

Sequence Name	Sequence Type
KNTA_TS_APPROVAL_REMINDER_SENT_ID_SEQ	ID