Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 EDM Data TypeNotes
EmployeeIdGuidGlobally-unique identifier for an employee. May be named "Employee_ObjectId" in other tables.
EmployeeNumberInt32Integer identifier for an employee. This is intended to be unique within each account, but may not be if the client needs duplicate separate users to report identically. Presented as "External Code" in ECM.
AccountIdGuidAccount identifier
FullNameStringA 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.
NicknameStringA free-text field for the name displayed on receipts and other places in the NorthStar system.
DisabledBooleanSet to true when the employee is terminated.
Navigation Properties
EmployeeJobRates  

...

 EDM Data TypeNotes
JobIdGuidGlobally-unique identifier for a job. May be named "Job_ObjectId" in other tables.
JobNumberInt32Account-unique 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.
NameStringA free-text name for the job.
DescriptionStringA free-text description of the job.
Navigation Properties
EmployeeJobRates  

...