Layouts for CSV files

WFM Employee Data Element Import – CSV File Layout for Employee Data

Fields sent for non-primary employee positions are marked with an asterisk (*). Some fields will be sent as null. At some future point, those fields may contain data, or a client could populate them if desired.

CSV File is WFMEMPCSV

Col WB Field HRM Field CSV Header Examples
A/1 Calcgrp_Name PAY-PLAN CALC-GROUP BW QCBW
B/2 Default_Timesheet DEFFAULT-TIMESHEET Null
C/3 Emp_Base_Rate PAY-RATE EMP-BASE-RATE 10.0000 123456789.1234
D/4 Emp_Birth_Date BIRTHDATE EMP-BIRTH-DATE 01/25/1989
E/5 Emp_Def_Minutes & Emp_Retail_Avail DEF-MINUTES-RETAIL-AVAIL Null
F/6 Emp_Firstname * FIRST-NAME FIRST-NAME Samantha
G/7 Emp_Fulltime EMP-FTE-TOTAL FULLTIME Null
H/8 Emp_Hire_Date DATE-HIRED HIRE-DATE 12/15/2004
I/9 Emp_Job * POSITION or Job based on parms JOB ANALYST
J/10 Emp_Lastname * LTD-LAST-NAME LAST-NAME
K/11 Emp_Name *

LTD-COMPANY

LTD-EMPLOYEE

COMPANY-EMP-NUMBER

3004012345678

0001000002355

L/12 Emp_Seniority_Date SENIORITY-DT SENIORITY-DATE 02/04/2012
M/13 Emp_SIN

LTD-COMPANY

LTD-EMPLOYEE

SIN

3004012345678

0001000002355

N/14 Emp_Status* EMP-STATUS STATUS

A

I – if terminating

O/15 Emp_Termination_Date TERM-DATE TERMINATION-DATE 10/25/2012
P/16 Empbdg_Badge_Number & Wbu_Badge_Number BADGE-NUMBER Null
Q/17 Empt_Hierarchy SUPERVISOR-CD HIERARCHY MANAGER
R/18 Ovr_End_Date * PEP-END-DATE OVR-END-DATE 03/15/2012
S/19 Ovr_Start_Date * PEP-EFFECT-DATE OVR-START-DATE 04/16/2001
T/20 Paygrp_Name WORK-SCHEDULE PAYGRP-NAME

WFM Job Import – Job or Position CSV Layout

Data will come from the JOBCODE or PAPOSITION table, based on the option in HR50.

If HR50 WFM parameter = Positions: We will send Positions with statuses of Active and Temporary.

If HR50 WFM parameter = Jobs: We will send Jobs with status of Active.

CSV File is WFMJOBCSV

Col WB Field HRM Field Field Size Notes
A/1 Type* Default to 'J' Varchar2 1

Required - Type of record

J - Job record

R - Rate record

B/2 Job_Name*

JBC-JOB-CODE

POS-POSITION

Varchar2 40 Required - Job name
C/3 Job_Desc

JBC-DESCRIPTION

POS-DESCRIPTION

Varchar2 40 Description
D/4 Job_Start_Date**

JBC-EFFECTIVE-DATE

POS-EFFECT-DATE

Varchar2

yyyymmdd

Required – Job start date – default 19000101
E/5 Job_End_Date* POS-END-DATE or default if blank

Varchar2

yyyymmdd

Required – Job end date – default 30000101 if Job. Use End date if Position has value in field, otherwise default.

WFM Team Import – Supervisor Structure CSV Layout

Supervisor data will be used for interfacing to the WFM Team. CSV File is WFMSUPCSV.

Col WB Field HRM Field/File Field Size Examples Notes
A/1 Wbt_String* HRSUPER file HSU-CODE HSU-SUPER-RPTS-TO Varchar2 1000

~~CEO

~MANAGER~ SUPERVISOR

Required – Team hash string format: Two tildes (~) at the beginning mean there’s no parent Supervisor.

~~<HSU-CODE> (When no value in HSU-SUPER-RPTS-TO)

~<HSU-SUPER-RPTS-TO>~<HSU-CODE>

B/2 Wbt_Action* Add for HR951 Varchar2 40 ADD Required – Team action – Only accepts ADD or DELETE.

CSV File Layout for PR530 (PRTRCSV) – WFM Payroll Extract

Following is the current file layout for Workbrain which will be used to populate the PRTRCSV file. This csv file can then be updated by PR530 to create time records.

Col WB Field HRM CSV Field Field Size Examples Notes
A Extract from Emp_Name. Positions 1-4. COMPANY N 4

3004

0001

Required
B BATCH-NBR N6 12 Required if client is not using auto-batch numbering or the PR530 parameter to assign. – for now, it can be configured to a single batch number
C Extract from Emp_Name. Positions 5-13. EMPLOYEE N 9

245784512

000025138

Required
D Time_Code** PAY-CODE A 4

REG

BON3

Required – client mapping needed for Time Codes/Pay Codes
E Wrkd_minutes HOURS S 7.2 40.00 Required. Convert to hours format
F Wrkd_rate RATE S 13.4 25.7520 Required. Will default to employee’s pay rate if left blank
G Work_date TR-DATE

N 8

ddmmyyyy

12152012 Required
H Emp_Job*** JOB-CODE A 9 NURSE Optional
I Emp_Job*** POSITION A 12 MANAGER Optional – Configuration will be set to this field by default but can be changed to JOB-CODE column H if required.

**Time Code – Client will need to set up and map Time Codes in Workbrain.

***Emp_Job – Client will need to set up and map which field is used in Workbrain. Will either populate Job-Code or Position, based on HR50.1 parameters for the data interfaced to WFM.