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.