Employee Export Interface Field Specification

This table lists the field-column specifications of the Employee Export Interface. The column number as well as the column name in the Export Transaction page is specified (for example, 1/A).

Col. Field Name Type Size/Format Description
1/A Export_Date_Time Date MM/DD/-YYYY Export Date
2/B Export_Record_Status Varchar2 1 I - Insertion/New Employee; U - Updated employee; D - Deleted employee. This value is exported if the Performs Difference check box is selected in the HR Export Task Parameters page. See Export Record Status Field (Column 2).
3/C Emp_Name Varchar2 40 Employee ID
4/D Emp_Lastname Varchar2 40 Employee Last Name
5/E Emp_Firstname Varchar2 40 Employee First Name
6/F Emp_Day_Start_Time Date hh:mm Day Start Time
7/G Emp_Shftpat_Name Number 10 Shift Pattern Name
8/H Emp_Calcgrp_Name Number 10 Calculation Group Name
9/I Emp_Base_Rate Number 20 Base Pay Rate
10/J Emp_Paygrp_Name Number 10 Pay Group Name
11/K Emp_Hire_Date Date MM/DD/-YYYY Hire Date
12/L Emp_Seniority_Date Date MM/DD/-YYYY Seniority Date
13/M Emp_Birth_Date Date MM/DD/-YYYY Birth Date
14/N Emp_Termination_Date Date MM/DD/-YYYY Termination Date
15/O Emp_Status Varchar2 1 Employee Status
16/P Emp_SIN Varchar2 40 Employee ID
17/Q Emp_Shftpat_Offset Number 22 Shift Pattern Offset
18/R Emp_Flags Varchar2 20 Flag String - 20 one character flags for general use.
19/S Emp_Val1 Varchar2 40 Free Field
20/T Emp_Val2 Varchar2 40 Free Field
21/U Emp_Val3 Varchar2 40 Free Field
22/V Emp_Val4 Varchar2 40 Free Field
23/W Emp_Val5 Varchar2 40 Free Field
24/X Emp_Val6 Varchar2 40 Free Field
25/Y Emp_Val7 Varchar2 40 Free Field
26/Z Emp_Val8 Varchar2 40 Free Field
27/AA Emp_Val9 Varchar2 40 Free Field
28/AB Emp_Val10 Varchar2 40 Free Field
29/AC Emp_Val11 Varchar2 40 Free Field
30/AD Emp_Val12 Varchar2 40 Free Field
31/AE Emp_Val13 Varchar2 40 Free Field
32/AF Emp_Val14 Varchar2 40 Free Field
33/AG Emp_Val15 Varchar2 40 Free Field
34/AH Emp_Val16 Varchar2 40 Free Field
35/AI Emp_Val17 Varchar2 40 Free Field
36/AJ Emp_Val18 Varchar2 40 Free Field
37/AK Emp_Val19 Varchar2 40 Free Field
38/AL Emp_Val20 Varchar2 40 Free Field
39/AM Emp_Def_Minutes Number 22 / minutes Default Shift Length
40/AN Empbdg_Badge_Number Varchar2 40 Employee Badge Number - Also Wbu_Badge_Number.
41/AO Emp_UDF_Data1 Varchar2 100 User Defined Field (UDF) - The export value has this name-value pair format: {UDF Definition}~{value}. If this field does not exist, no employee UDF data processing is done for field 41..60.
42/AP Emp_UDF_Data2 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
43/AQ Emp_UDF_Data3 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
44/AR Emp_UDF_Data4 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
45/AS Emp_UDF_Data5 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
46/AT Emp_UDF_Data6 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
47/AU Emp_UDF_Data7 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
48/AV Emp_UDF_Data8 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
49/AW Emp_UDF_Data9 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
50/AX Emp_UDF_Data10 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
51/AY Emp_UDF_Data11 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
52/AZ Emp_UDF_Data12 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
53/BA Emp_UDF_Data13 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
54/BB Emp_UDF_Data14 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
55/BC Emp_UDF_Data15 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
56/BD Emp_UDF_Data16 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
57/BE Emp_UDF_Data17 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
58/BF Emp_UDF_Data18 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
59/BG Emp_UDF_Data19 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
60/BH Emp_UDF_Data20 Varchar2 100 User Defined Field (UDF) - (See description for Emp_UDF_Data1)
61/BI Emp_Def_Lab1 Varchar2 200 Employee Default Labor Allocation (as of the export date). The export value has this format: {percentage}~{docket}~{hour type}~{job} {time code}~{project}~{department}.

If this field does not exist, no employee default labor data processing is done for field 61...64. See Default Labor Allocation.

62/BJ Emp_Def_Lab2 Varchar2 200 Employee Default Labor Allocation - (See description for Emp_Def_Lab1.)
63/BK Emp_Def_Lab3 Varchar2 200 Employee Default Labor Allocation - (See description for Emp_Def_Lab1.)
64/BI Emp_Def_Lab4 Varchar2 200 Employee Default Labor Allocation - (See description for Emp_Def_Lab1.)
65/BM Emp_Jobs Varchar2 200 Employee Job at the export date. The export value contains a list of job codes separated by tilde (~) symbols. The codes represent the skills an employee is capable of performing. If this field does not exist, no employee job data processing is done for field 65..66. See Jobs (Column 65).
66/BN Emp_Job_Rate_Index Varchar2 200 Employee Job Rate Index. The export value contains a list of job rate indices separated by tilde (~) symbols, corresponding to the job list specified in EMP_JOB.
67/BO Unused Unused - For future use.
68/BP Empt_Name Varchar2 100 Employee Team Name (as of the export date) - See Teams (Column 68).
69/BQ Entpol_Name Varchar2 40 Entitlement Policy Name (as of the export date).
70/BR Wbu_Name Varchar2 40 User Name - If this field does not exist, no application user data is processed for fields 70..75: WBU_PASSWORD; WBU_EMAIL; WBLL_ID; WBG_ID; WBU_PWD_CHANGED_DATE
71/BS Wbu_Password Varchar2 4000 Password
72/BT Wbu_Email Varchar2 100 E-mail Address
73/BU Wbll_ID Varchar2 40 Language Locale
74/BV Wbg_ID Number 10 Security Group Factor String
75/BW Wbu_Pwd_Changed_Date Date MM/DD/YYYY Password Change Date
76/BX Embal_Delta1 Number 10 Employee Balance (as of the export date). Embal_Delta1 to Embal_Delta10 are used to export employee balances. The format for employee balance is: {Balance_Name}~{Value}.

If this field does not exist, no employee balance data processing is done for fields 76..85. (See Balances (Column 76-85).)

77/BY Embal_Delta2 Number 10 Employee Balance - (See description for Embal_Delta1)
78/BZ Embal_Delta3 Number 10 Employee Balance - (See description for Embal_Delta1)
79/CA Embal_Delta4 Number 10 Employee Balance - (See description for Embal_Delta1)
80/CB Embal_Delta5 Number 10 Employee Balance - (See description for Embal_Delta1)
81/CC Embal_Delta6 Number 10 Employee Balance - (See description for Embal_Delta1)
82/CD Embal_Delta7 Number 10 Employee Balance - (See description for Embal_Delta1)
83/CE Embal_Delta8 Number 10 Employee Balance - (See description for Embal_Delta1)
84/CF Embal_Delta9 Number 10 Employee Balance - (See description for Embal_Delta1)
85/CG Embal_Delta10 Number 10 Employee Balance - (See description for Embal_Delta1)
86/CH ST_EMP_SKILLS_ MULTI_COL Employee Skill A list of employee skill properties separated by tilde (~) symbols. Each property is a name value pair separated by equal (=) signs.

See Properties for Employee Skill.

87/CI SOEMP_MULTI_COL Also called SO_EMPLOYEE. SO Employee details. A list of l properties separated by tilde (~) symbols. Each property is a name value pair separated by equal (=) signs.

See Properties for Employee Details.