Understanding the database tables that control delinquent timesheets

A manager can view the late timesheet submissions in the Infor XM application. The alts_delinquent_report table contains the period that the Infor TS users have not submitted timesheets. This table is populated regularly by the DlnqntSubmitReportBkg background process.

Database Tables

The alts_delinquent_report table contains the duration for which the timesheet has not been submitted by the users.

Column	Type	Nullity	Description	Example
change_timestamp	datetime	NULL		06/29/2012 17:53:00
presubmitted	int	NULL	1 - pre-submitted timesheet by the user. Row is added by the business rule. NULL - Timesheet not submitted in this period by the user. Row is added by either of the background processes.	1
ts_delinquent_report_id	int	NOT NULL	PK - a unique ID for the table.	1234567890
ts_end_calendar_date	datetime	NOT NULL	Timesheet period calendar end date used for display.	07/15/2012 17:53:00
ts_end_date	datetime	NOT NULL	Timesheet period end date.	07/14/2012 17:53:00
ts_start_date	datetime	NOT NULL	Timesheet period start date.	07/01/2012 17:53:00
User_id	int	NOT NULL	FK to alco_user.	1234567890

The alts_delinquent_timesheet table is used by the notification background process to ensure that the notifications of the delinquent timesheet submissions are sent only once a day.

Column	Type	Nullity	Description	Example
ts_delinquent_timesheet_id	int	NOT NULL
user_id	int	NOT NULL	FK to alco_user.
ts_start_time	datetime	NULL	Timesheet period start date.
ts_end_time	datetime	NULL	Timesheet period end date.
email_sent	int	NULL	0 -failure to send 1 - email sent
change_timestamp	datetime	NULL