Employees
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. |
| Navigation Properties | ||
| EmployeeJobRates | ||
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 | ||