Note
Represents user-created notes that store freeform or structured commentary that is associated with Bullhorn CRM entities. This table supports communication, documentation, and relationship management by capturing contextual information that informs future actions.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) of the Note record. This value ensures that each interaction or activity log entry is tracked separately within Bullhorn CRM. |
| AboutId | Int | False |
Specifies the Id of the entity that is associated with the Note record. This linkage enables the system to determine which candidate, client contact, job order, or other record the note pertains to. |
| Action | String | False |
Indicates the action type that is associated with the Note record. This information helps categorize the nature of the activity for reporting, workflow routing, and analytics. |
| AuthorId | Int | False |
Captures the Id of the user who authors the Note record. This detail ensures accountability and provides meaningful activity history for audit and communication tracking. |
| BhTimeStamp | String | False |
Stores the Bullhorn CRM timestamp string that is generated for the Note entry. This value supports chronological ordering and consistency with system-generated event logs. |
| Comments | String | False |
Captures the free-form comments that are written in the Note record. This narrative provides context, communication details, and qualitative information that supports follow-up actions. |
| DateAdded | Datetime | False |
Indicates the datetime when the Note record is created. This timestamp enables historical reconstruction of activity sequences and supports audit requirements. |
| DateLastModified | Datetime | False |
Captures the datetime when the Note record is last updated. This value allows users and automated processes to detect changes to existing notes. |
| ExternalID | String | False |
Stores an external system Id that is associated with the Note record. This field supports data imports, integrations, and cross-system synchronization activities. |
| JobOrderId | Int | False |
Identifies the Id of the job order that is linked to the Note record. This association helps consolidate all activity and communication that is related to the job order lifecycle. |
| MigrateGUID | String | False |
Stores the unique identifier for the migration object that is assigned during data migration processes. This value prevents duplication and supports traceability across external systems. |
| PrimaryDepartmentName | String | False |
Captures the primary department name that is associated with the Note record. This information supports routing, departmental reporting, and organizational context. |
| TimespentMin | Int | False |
Indicates the number of minutes that are recorded as time spent on the activity described in the Note record. This value supports productivity tracking and time-based metrics. |
| TruestDateAdded | Datetime | False |
Represents the system-calculated datetime that is associated with the Note record's creation. This value provides a normalized timestamp that is used when source systems supply inconsistent date information. |
| IsDeleted | Bool | False |
Returns a value of 'true' when the Note record is marked as deleted. It returns a value of 'false' when the record remains active and visible within Bullhorn CRM. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| LuceneQuery | String |
Specifies a Lucene query that is submitted directly to the Bullhorn CRM API as a pseudocolumn. This element overrides other filters and allows advanced search operations that are executed using the Lucene query syntax. |