JobOrderHistory
Captures lifecycle and historical events that relate to job order records. This table supports long-term analysis by tracking changes that influence recruiting metrics, client activity, and job order progression.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) of the JobOrderHistory record. This value supports historical tracking and ensures stable reference points for analyzing job-order changes over time. |
| ClientBillRate | String | False |
Captures the client bill rate that is associated with the historical job order. This value supports revenue analysis and enables comparison between historical and current rates. |
| ClientContactId | Int | False |
Represents the Id of the client contact that is associated with the job order at the time of the historical entry. This value supports audit reconstruction and client communication tracking. |
| ClientCorporationId | Int | False |
Represents the Id of the client corporation that is linked to the job order history. This value supports relational reporting and corporate-level trend analysis. |
| DateAdded | Datetime | False |
Indicates the date and time when the historical entry is added. This value supports chronological sequencing and enhances audit traceability. |
| DateEnd | Datetime | False |
Captures the end date that is associated with the job order during the historical period. This value supports contract tracking and project-timeline reconstruction. |
| FeeArrangement | Double | False |
Indicates the fee arrangement that is associated with the job order at the time of the historical entry. This value supports revenue modeling and change-impact assessments. |
| IsOpen | Bool | False |
Returns a value of 'true' if the job order is marked as open during the historical period. It returns a value of 'false' if the job order is considered closed for that timestamp. |
| IsPublic | Int | False |
Indicates the public-visibility setting that is associated with the job order at the time of the historical record. This value supports audit analysis of posting availability and access settings. |
| JobBoardPublishing | String | False |
Captures details about job-board publishing that is associated with the job order during the historical entry. This value supports external-posting tracking and visibility analysis. |
| JobOrderId | Int | False |
Represents the Id of the job order that is associated with the historical entry. This value supports record linkage and ensures accurate reconstruction of job-order evolution. |
| MigrateGUID | String | False |
Captures the globally unique migration Id that is assigned to the historical record. This value supports data-migration integrity and system synchronization. |
| ModifyingUserId | Int | False |
Represents the Id of the user who performs the modification that results in this historical entry. This value supports accountability and contributor tracking. |
| NumOpenings | Int | False |
Indicates the number of job openings that is associated with the job order during the historical timestamp. This value supports forecasting, analytics, and historical staffing insights. |
| PayRate | String | False |
Captures the pay rate that is associated with the job order during the historical record. This value supports compensation tracking and helps identify changes across revisions. |
| ReportToClientContactId | Int | False |
Represents the Id of the client contact to whom the role reports at the time of the historical entry. This value supports structural workflow mapping and reporting-relationship analysis. |
| Salary | String | False |
Captures the salary information that is associated with the job order during the historical period. This value supports compensation benchmarking and auditing of offer evolution. |
| StartDate | Datetime | False |
Indicates the start date that is associated with the job order during the historical record. This value supports project planning and reconstruction of engagement timelines. |
| Status | String | False |
Captures the job-order status that is recorded in the historical entry. This value supports pipeline analysis and identifies changes in job-order lifecycle state. |
| TaxRate | Double | False |
Indicates the tax rate that is associated with the job order during the historical timestamp. This value supports financial review and ensures consistency in historical billing calculations. |
| Type | Int | False |
Indicates the job-order type that is associated with the historical entry. This value supports organizational reporting and helps classify changes in job-type configuration. |