Employees

General information about a single employee

	EDM Data Type	Notes

	EDM Data Type	Notes
EmployeeId	Guid	Globally-unique identifier for an employee. May be named "Employee_ObjectId" in other tables.
EmployeeNumber	Int32	Integer identifier for an employee. This is intended to be unique within each account, but may not be if the client needs separate users to report identically. Presented as "External Code" in ECM.
AccountId	Guid	Account identifier
FullName	String	A free-text field for the employee's legal name. No restrictions are made about whether this contains given names, family names, initials, or any other parts of a name.
Nickname	String	A free-text field for the name displayed on receipts and other places in the NorthStar system.
Disabled	Boolean	Set to true when the employee is terminated.
KeyCode	String	The number the employee types to log into the POS. If the site uses employee mag cards, this field contains the final digits of the employee's mag card.
Navigation Properties
EmployeeJobRates
EmployeeSites

Jobs

General information about a job

	EDM Data Type	Notes

	EDM Data Type	Notes
JobId	Guid	Globally-unique identifier for a job. May be named "Job_ObjectId" in other tables.
JobNumber	Int32	Integer identifier for a job. This is intended to be unique within each account, but may not be if the client needs separate jobs to report identically. Presented as "External Code" in ECM.
Name	String	A free-text name for the job.
Description	String	A free-text description of the job.
Navigation Properties
EmployeeJobRates

Information about an employee assigned to a job.

	EDM Data Type	Notes

	EDM Data Type	Notes
EmployeeJobRateId	Guid	Globally-unique identifier for an employee-job assignment.
EmployeeId	Guid	Globally-unique identifier for an employee.
JobId	Guid	Globally-unique identifier for the job assigned to the employee.
Rate	Decimal	Hourly pay rate for the employee in this job.
ActivationDate	DateTime	Date when the employee was assigned this job.
Navigation Properties
Employee
Job

Information about the relationship between sites and users.

	EDM Data Type	Notes

	EDM Data Type	Notes
SiteUserId	Guid	Globally-unique identifier for an employee-job assignment.
EmployeeId	Guid	Globally-unique identifier for an employee.
SiteId	Guid	Globally-unique identifier for the job assigned to the employee.
AssignedSite	Boolean	Shows if the user is active at this site.
KeyCode	String	Key code used to log into the site.
Navigation Properties
Employees