Understanding Associate Data

This topic describes the structure and format of the data files used for adding associate data to EOM. The files are pipe-delimited text files that contain data records to insert, update, or delete from the database tables.

Job Codes file

The job code file contains information about an associate’s job description or status.

Format

The job code file follows the following format:

AJ|1234|111|50|Terminated|50|en|Terminated

Data

The job code file contains the following data.

Data	Sample Value	Description
Action	AJ	Determines the behavior of the data. The following are the possible actions: AJ (AddJobCode)—adds job code of the associate to the database. MJ (ModifyJobCode)—modifies existing job code data in the database. DJ (DeleteJobCode)—removes existing job code data from the database.
CompanyID	1234	Indicates the company ID number.
StoreID	111	Indicates the store ID number.
JobCode	50	Specifies the job code (i.e., 10, 30, 70) of the associate.
JobCodeName	Terminated	Specifies the corresponding job code name (i.e., Cashier, Manager).
SecurityLevel	50	Indicates the security level (i.e., 10, 30, 70) of the associate.
Culture	en	Indicates the associate’s culture/language.
JobCodeDescription	Terminated	Describes the job specification of the associate according to the job code.

Associates file

Information in the associate file is used to provide access for store associates to the Advanced Store system.

Format

The associate file follows the following format:

AA|1234|111|102|Chris|Brown|Chris|||~BY1000000000005T0IVJSOCQ7AvCQaOytvVw==||||||||||||10|5/31/2005||10|English|English|0|102|||Training Session Associate|0|Yes

Data

The associate file contains the following data.

Data	Sample value	Description
Action	AA	Determines the behavior of the data. The following are the possible actions: AA (AddAssociate)—adds new associate to the database. MA (ModifyAssociate)—modifies existing associate data in the database. DA (DeleteAssociate)—removes existing associate data from the database.
CompanyID	1234	Indicates the company ID number of the associate.
StoreID	111	Indicates the store ID number of the associate.
AssociateID	102	Identifies the associate number. This is an identification used by the associate to access the Advanced Store system.
FirstName	Chris	Indicates the first name of the associate.
LastName	Brown	Indicates the last name of the associate.
DisplayName	Chris	Indicates the display name of the associate. Display name is the name printed on the receipts.
Password		Indicates the password of the associate.
Password2		Indicates the password 2 of the associate.
PasswordRenewal	~BY1000000000005T0IVJSOCQ7AvCQaOytvVw==	Indicates the renewed password of the associate.
OldPasswords		Indicates the old password of the associate.
WorkPhone		Indicates the work phone number of the associate.
HomePhone		Indicates the home phone number of the associate.
CellPhone		Indicates the cellular phone number of the associate.
Email		Indicates the e‑mail address of the associate.
Address1		Indicates the address 1 of the associate.
Address2		Indicates the address 2 of the associate.
City		Indicates the city the associate resides.
State		Indicates the state or territory the associate resides.
ZIPCode		Indicates the ZIP code.
Country		Indicates the country the associate resides.
SecurityLevel	10	Indicates the security level of the associate. Example 10, 30, 70
HireDate	5/31/2005	Identifies the date on which the associate began (or will begin) working with the company.
TerminationDate		Determines when the associate is terminated.
JobCode	10	Specifies the job code of the associate. Example 10, 30, 70
PrimaryLanguage	English	Indicates the primary language of the associate.
SecondaryLanguage	English	Indicates the secondary language of the associate.
StatusFlag	0	Indicates the status of the associate.
BadgeNum	102	Specifies the badge number of the associate.
SupervisorID		Indicates the ID number of the associate’s supervisor.
Department		Indicates the department the associate belongs to.
Notes	Training Session Associate	Indicates notes and specific information about the associate.
Clock_in_out	0	Determines the associate’s clock in and clock out time.
Reset Password	Yes	Determines whether an associate who logs on to the WebOffice application for the first time would be prompted for a Change Password requirement.