WorkAssignmentHistoryReport
The view that compiles a comprehensive report of historical work-assignment records. This view integrates multiple dimensions (for example, organizational units, locations, and communication fields) into a unified dataset for compliance and workforce analysis.
Columns
| Name | Type | References | Description |
| AssociateOID | String |
Workers.AssociateOID | The unique identifier (Id) that represents the associate whose work-assignment report record is being captured. This Id links the report entry to the correct worker profile within Human Resources (HR) and payroll systems. |
| WorkerIDValue | String |
Workers.WorkerID | The value of the worker's identification code that is assigned by the organization. This field uniquely identifies the worker across HR, payroll, and compliance systems. |
| WorkerIDschemeCode | String | The code that defines the scheme or format used for the worker identification value (for example, EmployeeNumber, ContractorID, or TemporaryID). This field clarifies how the worker's Id is structured within the organization's system. | |
| WorkerIDShortName | String | The abbreviated name that corresponds to thecode for the worker identification scheme. This field provides a concise label for reports, dashboards, and HR data views. | |
| WorkerIDLongName | String | The full descriptive name of the code for the worker identification scheme. This field provides the complete label that appears in HR and workforce management documentation. | |
| WorkerGivenName | String | The given (first) name of the worker as recorded in HR and payroll systems. This field is used for identification and display in reports and user interfaces. | |
| WorkerMiddleName | String | The middle name of the worker as recorded in HR systems. This field provides additional identification detail when multiple workers share similar names. | |
| WorkerFamilyName1 | String | The primary family (last) name of the worker as recorded in HR and payroll systems. This field is used in official documentation and reports. | |
| WorkerFamilyName2 | String | The secondary family (last) name of the worker, if applicable. This field supports organizations where multiple family names are used for legal or cultural reasons. | |
| WorkerFormattedName | String | The full formatted name of the worker that combines given, middle, and family names according to organizational naming conventions. This field provides a standardized display format for reports and records. | |
| RelationshipCode | String | The code that identifies the reporting relationship between the worker and another individual (for example, Supervisor, Manager, or Team Lead). This field defines the hierarchical or functional link between positions. | |
| RelationshipShortName | String | The abbreviated name that corresponds to the reporting relationship code. This field provides a concise label for HR dashboards, analytics, and summary reports. | |
| RelationshipLongName | String | The full descriptive name of the reporting relationship code. This field provides the complete label that is used in HR and organizational structure documentation. | |
| PositionID | String | The Id that represents the position assigned to the worker within the organization. This field links the worker to the specific role or job that is recorded in the HR system. | |
| PositionTitle | String | The official title of the position assigned to the worker. This field is displayed in HR records, directories, and reporting hierarchies. | |
| ItemID | String | The Id that represents the specific work-assignment history report record. This field enables audit tracking and ensures consistency across HR reports and data extracts. |