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 |