EntityFiles
Represents the set of files that are attached to entities within Bullhorn CRM. This view supports document management workflows by allowing users to identify, access, and review attachments that relate to records such as candidates, job orders, or client contacts.
View Specific Information
Use this view as a helper in case you need the file unique identifiers, for the DownloadFile.
Except the pseudo columns, no filters are handled server-side on this view. EntityType and EntityId must be specified to query from this view.
SELECT * FROM EntityFiles WHERE EntityType = 'Candidate' AND EntityId = '110011'
Columns
| Name | Type | Description |
| Id [KEY] | Int | Represents the unique identifier (Id) for the file record in Bullhorn CRM. This value supports attachment tracking and enables integrations and UI workflows to reference each stored or linked file reliably. |
| Name | String | Captures the name of the file that is associated with the record. This value supports file-identification workflows and helps users distinguish among attachments during review or retrieval. |
| DateAdded | Datetime | Indicates the date and time when the file is added to Bullhorn CRM. This value supports lifecycle auditing and enables users to understand when files become available within the system. |
| FileType | String | Indicates the file type that is associated with the attachment. This value supports processing and categorization workflows that treat files differently based on their general type. |
| Type | String | Indicates the classification type that is assigned to the file. This value supports internal categorization logic and helps determine how the file is used within entity workflows. |
| FileExtension | String | Captures the file extension that is associated with the attachment. This value supports validation and ensures that file-processing components handle the file according to its expected format. |
| Description | String | Captures the descriptive text that is associated with the file. This information supports interpretation during review and helps users understand the file's purpose or relevance. |
| IsDeleted | Boolean | Returns a value of 'true' if the file record is marked as deleted in Bullhorn CRM. It returns a value of 'false' if the file remains active and available for retrieval, review, or workflow use. |
| IsPrivate | Boolean | Returns a value of 'true' if the file is marked as private and restricted from standard user visibility. It returns a value of 'false' if the file is available to users who have normal access to the associated entity. |
| IsExternal | Boolean | Returns a value of 'true' if the file is stored externally rather than within Bullhorn CRM's internal file repository. It returns a value of 'false' if the file is stored directly in the system's managed storage. |
| ContentType | String | Indicates the primary content type that is associated with the file. This value supports downstream processing workflows that treat files according to their declared media category. |
| ContentSubType | String | Captures the more specific subtype designation that is associated with the file's content. This value supports detailed content handling and helps integrations apply subtype-specific logic. |
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 |
| EntityType | String | Identifies the type of entity for which the attached files are being listed. This value supports filtering logic that determines which records are queried when retrieving associated files.
The allowed values are Candidate, ClientContact, ClientCorporation, JobOrder, Opportunity, Placement. |
| EntityId | String | Represents the Id of the entity for which the attached files are being listed. This value ensures that file queries correctly return attachments that belong to the intended parent record. |