...
General information about a single employee
| 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 | |
|---|---|---|
| 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 | ||
EmployeeJobRates
Information about an employee assigned to a job.
...
| 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 |
EmployeeSites
Information about the relationship between sites and users.
| 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 | ||