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 | Account-unique identifier for an employee. 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 | Account-unique identifier for a job. 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 | ||