HR Refresh Field Specification

Field Name	Type	Size/ Format	Description
Ovr_Start_Date	Date	MM/DD/YYYY	Effective start date. Start of effective period. Default to the system date if the import value is {empty}.
Ovr_End_Date	Date	MM/DD/YYYY	Effective end date. End of effective period. Default to '01/01/3000' if the import value is {empty}.
Emp_Name*	Varchar2	40	Employee identification. This import value must always be filled.
Emp_Lastname	Varchar2	40	Employee last name. This import value must be filled if the import value is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Firstname	Varchar2	40	Employee first name. This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Day_Start_Time	Date	MM/DD/YYYY	Day start time. Default to 00:00 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Shftpat_Name	String	40	Shift pattern factor string. The factors separated by tilde (~) symbols, that map to a Shift Pattern. Up to ten factors can be used to map to a single shift pattern. Default to 'NULL - ALL OFFS' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Calcgrp_Name	String	40	Calculation group factor string. The factors separated by tilde (~) symbols, that map to a calculation group. Up to ten factors can be used to map to a single calculation group. This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Base_Rate	Number	20	Base pay rate. Default to 0.00 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Paygrp_Name	String	40	Pay group factor string. The factors separated by tilde (~) symbols, that map to a Payroll Group. Up to ten factors can be used to map to a single payroll group. Default to '0' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Hire_Date	Date	MM/DD/YYYY	Hire date. Default to the system date if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Seniority_Date	Date	MM/DD/YYYY	Seniority date. Default to system date if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Birth_Date	Date	MM/DD/YYYY	Birth date. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Termination_Date	Date	MM/DD/YYYY	Termination date. Default to '01/01/3000' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Status	Varchar2	1	Employee status. Default to 'A' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_SIN	Varchar2	40	Employee ID. This import value must be filled if the import value is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Shftpat_Offset	Number	22	Shift pattern offset. Employees start day in a cyclical shift pattern. Default to '0' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Emp_Flag[1..20]	Varchar2	20	Flag string. 20 one-character flags for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag position indicates the flag is to be 'blanked'.
Emp_Val1	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val2	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val3	Var- char2	40	Free field. Do not process if the import value is {empty}.
Emp_Val4	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val5	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val6	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val7	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val8	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val9	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val10	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val11	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val12	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val13	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val14	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val15	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val16	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val17	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val18	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val19	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Val20	Varchar2	40	Free field. Do not process if the import value is {empty}.
Emp_Def_Minutes and Emp_Retail_Avail	Varchar2	22 / minutes~ mode	Default shift length and employee retail mode. String format: `Emp_Def_Minutes~Emp`_Retail_Avail Example: `500~Y`Emp_Def_Minutes default to 480 (minutes) if the import value is {empty} and is creating a new record. Emp_Retail_Avail is either Y or N. Y=Schedule Optimization, N=Staff Scheduling mode. This field is not processed if the import value is {empty} and is writing to an existing record.
Empbdg_Badge_Number and Wbu_Badge_Number	Varchar2	40	Employee badge number. Do not process if the import value is {empty}.
Emp_UDF_Data1	Varchar2	100	User defined field (UDF). The import value has this name-value pair format: `{UDF Definition}~{value}`. Do not process if the import value is {empty}.
Emp_UDF_Data2	Varchar2	100	User defined field (UDF). (See description for Emp_UDF_Data1).
Emp_UDF_Data3	Varchar2	100	User defined field (UDF). (See description for Emp_UDF_Data1).
Emp_UDF_Data4	Varchar2	100	User defined field (UDF). (See description for Emp_UDF_Data1).
Emp_UDF_Data5	Varchar2	100	User defined field (UDF). (See description for Emp_UDF_Data1).
Emp_UDF_Data6	Varchar2	100	User defined field (UDF). (See description for Emp_UDF_Data1).
Emp_UDF_Data7	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data8	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data9	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data10	Var- char2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data11	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data12	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data13	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data14	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data15	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data16	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data17	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data18	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data19	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_UDF_Data20	Varchar2	100	User defined field (UDF) (See description for Emp_UDF_Data1)
Emp_Def_Lab1	Varchar2	200	Employee default labor allocation. The import value has this format: `{percentage}~{docket}~{hour type}~{job}~{time code}~{project}~{department}` Do not process if the import value is {empty}.
Emp_Def_Lab2	Varchar2	200	Employee default labor allocation. (See description for Emp_Def_Lab1)
Emp_Def_Lab3	Varchar2	200	Employee default labor allocation (See description for Emp_Def_Lab1)
Emp_Def_Lab4	Varchar2	200	Employee default labor allocation. (See description for Emp_Def_Lab1)
Emp_Job	Varchar2	200	Employee job. The import value contains a list of job codes separated by tilde (~) symbols, that represent the skills that an employee is capable of performing. Do not process if the import value is {empty}. See Jobs (Column 65).
Emp_Job_Rate_Index	Varchar2	200	Employee job rate index. The import value contains a list of job rate indices separated by tilde (~) symbols, corresponding to the job list specified in Emp_Job. The number of job rate indices matches the number of jobs listed in Emp_Job. Otherwise, the entire record is rejected and an error message is generated. See Job Rate Indices (Column 66).
EmpJob_Rank	String	1000	Employee job rank The import value contains a list of job rank indices separated by tilde (~) symbols, corresponding to the job list specified in EMP_JOB. The number of job rank indices matches the number of jobs listed in EMP_JOB. Otherwise, the entire record is rejected and an error message is generated. See Job Rank Indices (Column 67).
Empt_Hierarchy	String	1000	Team hash string Default to 'Unassigned Team' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record. See Teams (Column 68).
Ent_Emp_Policy. Entpol_ID	String	1000	Entitlement policy name More than one policy can be supplied by using the tilde (~) symbol. For example: POLICY1~POLICY2 Do not process if the import value is {empty}.
Wbu_Name	String	40	User name If the import value is {empty}, do not process this and the next five (5) field columns: Wbu_Password Wbu_Email Wbll_ID Wbg_ID Wbu_Pwd_Changed_Date
Wbu_Password	String	100	Password Default to the Employee ID (Emp_SIN) if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Wbu_Email	Varchar2	100	E-mail address. Do not process if the import value is {empty}.
Wbll_ID	Varchar2	40	Language locale. Default to 'ENGLISH' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Wbg_ID	Number	10	Security group factor string. The factors separated by tilde (~) symbols, that map to a Security Group. Up to ten factors can be used to map to a single Security Group. Do not process if the import value is {empty}.
Wbu_Pwd_Changed_Date	Date	MM/DD/YYYY	Password change date. Default to the system date if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.
Embal_Delta1	Number	10	Employee balance. Embal_Delta1 to Embal_Delta10 are used to change employee balances. The format for changing an employee balance is: {Balance_Name}~{Value}~{Action} where {Action} can be 'SET' or 'ADD'. See Effective Dating (Columns 1-2). Do not process if the import value is {empty}.
Embal_Delta2	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta3	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta4	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta5	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta6	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta7	Num- ber	10	Employee balance (See description for Embal_Delta1)
Embal_Delta8	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta9	Number	10	Employee balance (See description for Embal_Delta1)
Embal_Delta10	Number	10	Employee balance (See description for Embal_Delta1)

Ovr_Start_Date

Date

MM/DD/YYYY

Effective start date. Start of effective period. Default to the system date if the import value is {empty}.

Ovr_End_Date

Date

MM/DD/YYYY

Effective end date. End of effective period. Default to '01/01/3000' if the import value is {empty}.

Emp_Name*

Varchar2

40

Employee identification. This import value must always be filled.

Emp_Lastname

Varchar2

40

Employee last name. This import value must be filled if the import value is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Firstname

Varchar2

40

Employee first name. This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Day_Start_Time

Date

MM/DD/YYYY

Day start time. Default to 00:00 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Shftpat_Name

String

40

Shift pattern factor string. The factors separated by tilde (~) symbols, that map to a Shift Pattern. Up to ten factors can be used to map to a single shift pattern. Default to 'NULL - ALL OFFS' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Calcgrp_Name

String

40

Calculation group factor string. The factors separated by tilde (~) symbols, that map to a calculation group. Up to ten factors can be used to map to a single calculation group. This import value must be filled if a new record is being created. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Base_Rate

Number

20

Base pay rate. Default to 0.00 if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Paygrp_Name

String

40

Pay group factor string. The factors separated by tilde (~) symbols, that map to a Payroll Group. Up to ten factors can be used to map to a single payroll group. Default to '0' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Hire_Date

Date

MM/DD/YYYY

Hire date. Default to the system date if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Seniority_Date

Date

MM/DD/YYYY

Seniority date. Default to system date if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Birth_Date

Date

MM/DD/YYYY

Birth date. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Termination_Date

Date

MM/DD/YYYY

Termination date. Default to '01/01/3000' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Status

Varchar2

1

Employee status. Default to 'A' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_SIN

Varchar2

40

Employee ID. This import value must be filled if the import value is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Shftpat_Offset

Number

22

Shift pattern offset. Employees start day in a cyclical shift pattern. Default to '0' if the import value is {empty} and is creating a new record. Do not process if the import value is {empty} and is writing to an existing record.

Emp_Flag[1..20]

Varchar2

20

Flag string. 20 one-character flags for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag position indicates the flag is to be 'blanked'.

Emp_Val1

Varchar2

40