Timesheet Transfer

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.

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?

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."