Importing Timesheets
Default, regular, or supplement timesheets can be imported. The following tables show examples of data fields used in the Timesheets section of the MasterPR.DEF file:
Header
| Table: tblPRTS | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TIMESHEET,HEADER,HTS | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TS_EMPLOYEEID |
Y |
User Defined |
Employee ID |
|
|
TS_PROCGROUP |
Y |
User Defined |
If timesheet is default, this field is ignored. The system validates the processing group for the associated employee. |
|
|
TS_TYPE |
N |
20 |
|
Valid timesheet types: D (Default), R (Regular), and S (Supplemental) |
|
TS_PAYDATE |
N |
Date |
Required if timesheet is regular; it is ignored if it is default. If timesheet is supplemental or regular and no date is provided, the system uses the current system date. Can be 6, 8, or 10 digit date. |
|
|
TS_BEGPERIODDATE |
N |
Date |
Required if timesheet is regular; it is ignored if it is default. If timesheet is supplemental or regular and no date is provided, the system uses the Processing Group Pay Period Begin date. Can be 6, 8, or 10 digit date. |
|
|
TS_ENDPERIODDATE |
N |
Date |
Required if timesheet is regular; it is ignored if it is default. If timesheet is supplemental or regular and no date is provided, the system uses the Processing Group Pay Period End date. Can be 6, 8, or 10 digit date. |
|
|
TS_SUTAWEEKS |
N |
Integer |
0 |
Number of SUTA weeks for timesheet information |
|
TS_REF |
N |
20 |
Timesheet reference number |
|
|
TS_ID |
N |
20 |
Timesheet reference |
|
Detail Earnings
| Table: tblPRTSEarn | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TIMESHEET,DETAILTSEARN,DTSEARN | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TSEG_CODE |
Y |
User Defined |
Earning Code. At least one earning or benefit code is required to save a timesheet. |
|
|
TSEG_HOURS |
N |
Single |
0.0000 |
Earning Hours |
|
TSEG_RATE |
N |
8 |
0.0000 |
Used with Rate on Timesheet calculation method |
|
TSEG_AMOUNT |
N |
Currency |
0.00 |
Earning Amount |
|
TSEG_DISTCODE |
Y |
User Defined |
Must be a valid code with a distribution type of "B" or "P" (Maintain>Payroll>Distribution Codes). |
|
Detail Benefits
| Table: tblPRTSBene | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TIMESHEET,DETAILTSBENE,DTSBENE | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TSBG_CODE |
Y |
User Defined |
Benefit Code. At least one earning or benefit code is required to save a timesheet. |
|
|
TSBG_AMOUNT |
N |
Currency |
0.00 |
Benefit Amount |
|
TSBG_RATE |
N |
7 |
Used with Percentage on Timesheet calculation method. Must be a positive number greater than zero and cannot exceed the Maximum Percentage set on the Maintain>Payroll>Benefit Codes such as 99.9999 |
|
Detail Deductions
| Table: tblPRTSDeduct | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TIMESHEET,DETAILTSDED,DTSDED | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TSDG_CODE |
N |
User Defined |
Deduction Code |
|
|
TSDG_AMOUNT |
N |
Currency |
0.00 |
Deduction Amount |
|
TSDG_RATE |
N |
7 |
Used with Percentage on Timesheet calculation method. Must be a positive number greater than zero and cannot exceed the Maximum Percentage set on the Maintain>Payroll>Deduction Codes such as 99.9999 |
|
Detail Workers' Compensation
| Table: tblPRTSWC | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TIMESHEET,DETAILTSWC,DTSWC | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TSWG_CODE |
N |
User Defined |
Workers' Compensation Code |
|
|
TSWG_HOURS |
N |
Single |
0.00 |
Workers' Compensation Hours |
Detail Leave
| Table: tblPRTSLeave | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TIMESHEET,DETAILTSLEAVE,DTSLEAVE | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TSLG_CODE |
N |
User Defined |
Leave Code |
|
|
TSLG_HOURS |
N |
Single |
0.00 |
Leave Hours |
|
TSLG_RATE |
N |
7 |
Used with Percentage on Timesheet calculation method. Must be a positive number greater than zero and cannot exceed the Maximum Percentage set on the Maintain>Payroll>Leave Codes such as 99.9999 |
|
|
TSLG_HOURSACC |
N |
8 |
0 |
Used with Amount on Timesheet calculation method |