Timesheet Transfer

Use this utility to transfer exported timesheet records to a selected table. Currently the only option available is for JD Edwards and is called "Enterprise One." You can select the records you want to transfer by batch ID. Once the records have been processed, the system deletes them from the table, based on selected Batch ID.

When do I use the Transfer Timesheets screen?

Use this screen to transfer exported labor records to a table of your choice.

The Timesheet Transfer screen

The Timesheet Transfer screen is a process application. This application assumes that you do NOT have a value for the LABOR=parameter in the exporttimesheets.properties file. If you do, the EXPORT_LABOR file will be cleared and there will be nothing to transfer. If no records exist in the EXPORT_LABOR table when the screen is first loaded, the system will display the following message: "No exported timesheets found for transfer."

Format

In this version, the only format available is "Enterprise One." This is the table name used by JD Edwards.

Batch ID

This table contains the batch IDs that were used to export timesheets. It contains all batch IDs in the EXPORT_LABOR table. They are displayed in alphabetical order. To select a row, select the checkbox to the left of that row. To unselect a row, uncheck the checkbox to the left of the row. To select all of the rows, select the checkbox in the upper left corner. This will automatically select the checkboxes in all of the rows.

Execute

Select the Execute pushbutton to transfer the selected timesheet records.

Close

Select the Close pushbutton to close the screen and return to your designated default screen as set up in your preferences.

Data mapping

The following information shows the mapping for the JDEdwards table (JDE_TS_F5606ZW):

Field

Size

Source

Notes

WKC5606EMP

CHAR (20)

EXPORT_LABOR.empl_id

The unique identifier of the employee.

WKC5606TS

CHAR (10)

EXPORT_LABOR.ts_schedule_cd

The timesheet frequency identifier.

WKC5606FYR

CHAR (4)

EXPORT_LABOR.year_no_cd

The timesheet frequency's year code.

WKC5606PER

CHAR (3)

EXPORT_LABOR.period_no_cd

The period number for the timesheet frequency.

WKEDLN

FLOAT (126)

EXPORT_LABOR.line_no

The timesheet line number to which the timesheet cell record belongs.

WKC5606CDT

CHAR (10)

EXPORT_LABOR.hrs_dt

The column (cell) date for this row.

WKC5606SDT

CHAR (10)

TS_SCHEDULE_PERIOD.start_dt based on EXPORT_LABOR.ts_schedule_cd and EXPORT_LABOR.year_no_cd and EXPORT_LABOR.period_no_cd

The start date of the period.

Converted to String yyyy-mm-dd.

WKC5606EDT

CHAR (10)

TS_SCHEDULE_PERIOD.end_dt based on EXPORT_LABOR.ts_schedule_cd and EXPORT_LABOR.year_no_cd and EXPORT_LABOR.period_no_cd

End date of the period.

Converted to string yyyy-mm-dd.

WKEDBT

CHAR (15)

EXPORT_LABOR.batch_id

Batch Number.

WKC5606TSD

CHAR (10)

EXPORT_LABOR.timesheet_dt

The date associated with the timesheet.

Converted to string yyyy-mm-dd.

WKC5606SID

CHAR (10)

"01"

The ID of the site ID from which the timesheet and employee came.

WKC5606CCD

CHAR (10)

EXPORT_LABOR.class_cd

The current class to which the employee belongs.

WKC5606OTH

CHAR (20)

If EXPORT_LABOR.ot_fl = "Y," EXPORT_LABOR.hrs ; otherwise, 0.00.

The number of overtime hours.

Converted to string.

WKC5606LDS

CHAR (120)

EXPORT_LABOR.line_desc

Description of the charge on the line (Line Description).

WKC5606GRP

CHAR (20)

SPACES

Group Code.

WKC5606CHG

CHAR (45)

EXPORT_LABOR.charge_cd

Charge number for the timesheet line.

WKC5606CAI

CHAR (20)

SPACES

Charge abbreviation code.

WKC5606UTL

CHAR (10)

SPACES

Utilization code.

WKC5606T01

CHAR (30)

EXPORT_LABOR.udt01_id

The UDT01 identifier for the timesheet line (Proj/Task or Work Order).

WKC5606T02

CHAR (30)

EXPORT_LABOR.udt02_id if not null; otherwise, spaces,

The UDT02 identifier for the timesheet line.

WKC5606T03

CHAR (20)

EXPORT_LABOR.udt03_id if not null; otherwise, spaces,

The UDT03 identifier for the timesheet line.

WKC5606T04

CHAR (20)

EXPORT_LABOR.udt04_id if not null; otherwise, spaces.

The UDT04 identifier for the timesheet line.

WKC5606T05

CHAR (20)

EXPORT_LABOR.udt05_id if not null; otherwise, spaces.

The UDT05 identifier for the timesheet line.

WKC5606T06

CHAR (20)

EXPORT_LABOR.udt06_id if not null; otherwise, spaces.

The UDT06 identifier for the timesheet line (Job Step).

WKC5606T07

CHAR (20)

EXPORT_LABOR.udt07_id if not null; otherwise, spaces.

The UDT07 identifier for the timesheet line (Job Type).

WKC5606T08

CHAR (20)

EXPORT_LABOR.udt08_id if not null; otherwise, spaces.

The UDT08 identifier for the timesheet line.

WKC5606T09

CHAR (20)

EXPORT_LABOR.udt09_id if not null; otherwise, spaces

The UDT09 identifier for the timesheet line.

WKC5606T10

CHAR (20)

EXPORT_LABOR.udt10_id

The UDT10 identifier for the timesheet line (Pay Type).

WKC5606TST

CHAR (254)

EXPORT_LABOR.short_header_text if not null; otherwise, spaces.

Timesheet Text.

WKC5606LBR

CHAR (20)

EXPORT_LABOR.rate1_amt/ EXPORT_LABOR.hrs

The labor rate.
Converted to string.

WKC5606LAM

CHAR (20)

EXPORT_LABOR.rate1_amt

The labor amount.
Converted to string.

WKC5606BRT

CHAR (20)

EXPORT_LABOR.rate2_amt/ EXPORT_LABOR.hrs

The billing rate.
Converted to string.

WKC5606BAM

CHAR (20)

EXPORT_LABOR.rate2_amt

The billing amount.
Converted to string.

WKC5606HRS

CHAR (20)

EXPORT_LABOR.hrs

The entered labor hours for this cell.

WKC5606CRF

CHAR (1)

EXPORT_LABOR.correct_fl

Logical as to whether this cell is a correcting entry.

WKC5606CTX

CHAR (254)

EXPORT_LABOR.short_cell_text if not null; otherwise, spaces.

User-provided notes about the timesheet cell.

WKC5606LTX

CHAR (254)

EXPORT_LABOR.short_line_text if not null; otherwise, spaces.

User-provided notes about the timesheet line.

WKC5606STS

CHAR (1)

"P"

Status of the cell.

WKEDSP

CHAR (1)

"N"

(EditSuccessfullyProcess) Logical as to whether this cell record has been confirmed.

"N" - Record has not been picked up.

"Y" - Record has been picked up.

WKC5606ETX

CHAR (254)

SPACES

Error Text.

WKC5606ETK

VARCHAR2 (50)

EXPORT_LABOR.empl_id+ EXPORT_LABOR.ts_schedule_cd + EXPORT_LABOR.year_no_cd + EXPORT_LABOR.period_no_cd +

EXPORT_LABOR.hrs_dt

ET Key ID.

Padded with spaces to make fields full width.

WKUSER

CHAR (10)

Null

User ID.

WKPID

CHAR (10)

Null

Program ID.

WKJOBN

CHAR (10)

Null

Workstation ID.

WKUPMJ

NUMBER (6)

Null

Date - Updated.

WKUPMT

NUMBER (6)

Null

Time - Updated.