JobSubmission
Represents job submission records that link candidates to job orders during the recruiting lifecycle. This table supports placement workflows by tracking submission status, recruiter actions, and candidate progress across hiring stages.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) of the JobSubmission record. This value supports submission tracking and ensures that each candidate submission can be referenced consistently. |
| AddedById | Int | False |
Represents the Id of the user who adds the JobSubmission record. This value supports audit tracking and helps identify which recruiter initiates the submission. |
| BillRate | String | False |
Captures the bill rate that is associated with the job submission. This value supports financial evaluation and ensures accurate billing alignment with client requirements. |
| BranchID | Int | False |
Represents the Id of the branch that is associated with the job submission. This value supports organizational reporting and enables location-based segmentation. |
| CandidateId | Int | False |
Represents the Id of the candidate who is submitted for the job. This value supports candidate-job linking and ensures accurate reporting of submission activities. |
| Comments | String | False |
Captures the comments that are associated with the job submission. This value supports internal communication and helps recruiters annotate relevant submission details. |
| DateAdded | Datetime | False |
Indicates the date and time when the JobSubmission record is added. This value supports timeline tracking and provides a historical reference for submission activity. |
| DateLastModified | Datetime | False |
Indicates the date and time when the JobSubmission record is most recently modified. This value supports audit accuracy and helps identify recent updates to submission data. |
| DateWebResponse | Datetime | False |
Captures the date and time when a web response is received from the candidate. This value supports engagement monitoring and helps measure response times. |
| IsHidden | Bool | False |
Returns a value of 'true' if the JobSubmission record is hidden from standard user views. It returns a value of 'false' if the record is visible within typical submission workflows. |
| JobId | Int | False |
Represents the Id of the job order that is associated with the submission. This value supports relational tracking and aligns candidate submissions with specific job openings. |
| LatestAppointmentId | Int | False |
Represents the Id of the latest appointment that is associated with the submission. This value supports interview workflow management and helps track candidate progression. |
| MigrateGUID | String | False |
Captures the globally unique migration Id that is assigned to the JobSubmission record. This value supports data-migration integrity and ensures consistent reconciliation across systems. |
| PayRate | String | False |
Captures the pay rate that is associated with the job submission. This value supports compensation evaluation and helps compare candidate expectations with job requirements. |
| Salary | String | False |
Captures the salary information that is associated with the job submission. This value supports compensation assessment and enables alignment with client-offered ranges. |
| Source | String | False |
Captures the source from which the job submission originates. This value supports pipeline attribution and helps identify effective candidate-acquisition channels. |
| Status | String | False |
Captures the current status that is associated with the job submission. This value supports workflow tracking and enables visibility into candidate progression. |
| IsDeleted | Bool | False |
Returns a value of 'true' if the JobSubmission record is marked as deleted in Bullhorn CRM. It returns a value of 'false' if the record remains active and available for operational use. |