Tables (with brief descriptions)

Post questions on how to interpret your Bullhorn SQL Server backup of your Database.

Moderators: StaffingSupport, s.emmons

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Tables (with brief descriptions)

Post by apsmith » Thu Feb 25, 2010 4:17 pm

BH_MessageRecipient - Stores email information, most important is that there can be more than one row per message in this table
BH_UserMessage - The main email table, one row per message here
BH_UserHit - Stores viewing information for contact / candidate records
BH_UserMessageFile - File attachments to emails
BH_UserWorkHistory - Work History information linked to candidates
BH_UserWorkHistoryCustom - Work History information linked to candidates (extension table)
BH_UserComment - Notes Table
BH_UserCommentEntity - Mapping of notes to the relevant entity in Bullhorn (people, job, placement, etc)
BH_UserEditHistoryFieldChange - Stores detail on any edits made to candidates and contacts
BH_Activity - Not Used
BH_UserEditHistory - Stores each entry for candidate/contact edits
BH_User - Parent table for all "People" in Bullhorn (internal, candidates, contacts), mainly used for login information maps 1 to 1 with BH_UserContact
BH_UserContact - Parent table for all "People" in Bullhorn (internal, candidates, contacts)
BH_UserCategory - Mapping table of categories to users
BH_CandidateHistory - Older field change tracking table, tracks edits to major fields
BH_Schedule - Appointments and Tasks
BH_Candidate - Extension of BH_Usercontact, will exist one row for each candidate owner
BH_UserWork - Stores files linked to users and jobs
BH_UserWorkFile - Extension table of BH_UserWork
BH_UserEducation - Education information linked to candidates
BH_UserEducationCustom - Education information linked to candidates (extension table)
BH_DistributionListMember - One row for each user record on a Distribution List
BH_Client - Extension of BH_Usercontact, will exist one row for each contact owner
BH_ClientHistory - Older field change tracking table, tracks edits to major fields
BH_ResultsList - Internal use only
BH_MessageFolder - Email Folder List
BH_AutoComplete - Stores autocomplete entries for select field types
BH_JobResponseHistory - Stores history tracking on Submissions
BH_ScheduleRecipient - Stores invitees to appontments
BH_JobResponse - Submission parent table
BH_ClientCorporation - Client Company parent table
BH_ClientCorporationEditHistoryFieldChange - Stores field changes to company records (detail table)
BH_ReportingEditHistoryFieldChange - Stores field changes to report records (detail table)
BH_ReportingEditHistory - Stores field changes to report records
BH_UserSetting - User specific settings
BH_DistributionList - Distribution Lists and Saved Queries
BH_JobPostingEditHistoryFieldChange - Stores field changes to job records (detail table)
BH_PlacementEditHistoryFieldChange - Stores field changes to placement records (detail table)
BH_ReportingOutputOption - Extension report table, tracks output types
BH_JobPostingHistory - Older field change tracking table, tracks edits to major fields
BH_ClientCorporationFile - Stores files linked to company records
BH_ReportingCriteria - Stores input variables for reports
BH_ClientCorporationEditHistory - Stores field changes to company records
BH_JobPostingEditHistory - Stores field changes to job records
BH_ReportingEntitlement - Stores which usertypes have access to reports
BH_Reporting - Parent report table
BH_JobCategory - Mapping table of category to job
BH_JobPosting - Parent job table
BH_PlacementHistory - Stores field changes to placement records
BH_Commission - Stores commission information, linked to placements
BH_ClientCorporationHistory - Older field change tracking table, tracks edits to major fiel
BH_ReportingCategory - Mapping table of report to category
BH_ReportingOutput - Extension report table, tracks output types
BH_Sendout - Child of BH_JobResponse, tracks client submittals
BH_PlacementEditHistory - Stores field changes to placement records
BH_Placement - Placement parent table
BH_CorporateUser - Extension of BH_UserContact for internal users
BH_MessageTemplate - Stores Email message template information
BH_ShortListGrouping - Stores Tearsheet information
emaildupTable_20090815 - not used
BH_ShortList - Parent tearsheet table
BH_MessageTemplateFile - Stores files attached to message templates
BH_UserMessageDistributionList - stores link between messages and distribution lists
BH_MessageProcedureTracking - Not Used
Andrew Smith
Director, Technical Operations
Developer Forum Admin

stgilbert
User
Posts: 1
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by stgilbert » Thu Mar 01, 2012 3:57 pm

I am having trouble locating the "Category" field in any tables. I have tried UserContact, User, Category. Any ideas?

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Thu Mar 01, 2012 4:59 pm

There is a mapping table of BH_UserCategory. This will map userID to categoryID.

The same is true for the Job Entity as well.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

vasantha_r
User
Posts: 5
Joined: Tue Apr 23, 2013 7:19 am

Re: Tables (with brief descriptions)

Post by vasantha_r » Mon Apr 29, 2013 6:02 am

Hello,

Am not able to find the field for the Resume Text of a Candidate(The Resume field in the Candidate Overview Page). The API document says the field "description" in the Candidate Table is the one that contains the Candidate's Resume. But, I dont see this field in the database. Please advice.

Further, is there a correlation between the Resume field and a file attached as resume to a Candidate. Say, if I input the Resume text and save the Candidate Record will a file get created and attached as well? OR if I add a file as Resume to a Candidate, will the Resume field be populated with the content?

Thanks.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Mon Apr 29, 2013 9:00 am

Vasantha,

The description field is in the BH_UserContact table.

If you upload a file, it will not affect this field, files are separate from the resume field.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by chris.sargent » Mon Aug 26, 2013 4:18 am

I notice in the main UserContact table, each user has a list of their associated skills and category IDs. However, this list is not always the same as the information in the UserCategory table and UserSkills table.

Which is the correct, accurate and most up to date list?

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Mon Aug 26, 2013 10:09 am

Chris,

The linked list in the UserCategory and UserSkill table is the definitive list, that should be used.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by chris.sargent » Mon Aug 26, 2013 1:06 pm

Okay, thanks Andew. Are the values obsolete / not updated in the UserContact table?

I ask because I've already imported a bunch of contacts to a new system using the Specialty and Category values in the UserContact table

Chris

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Mon Aug 26, 2013 1:09 pm

Chris,

They should be in line with the linked tables, but there can be instances where they are not in sync. The values in the UserContact field are not used by any current features in the application, that field was designed for some legacy features.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

chris.sargent
User
Posts: 30
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by chris.sargent » Mon Aug 26, 2013 6:12 pm

Thanks again Andrew. It looks like the Specialties relating to each User_Contact is also included in the User_Categories table, is that correct? (Although from what I can tell so far the specialty ID fields are mapped correctly in the User_Contact table already.)

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Mon Aug 26, 2013 8:54 pm

Correct for the mapping in the BH_userCategory table. A specialty is just a category of a certain criteria, so we overload that table.

Again, the join should be the definitive list.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

AndyD
User
Posts: 1
Joined: Wed Jan 08, 2014 1:12 pm

Re: Tables (with brief descriptions)

Post by AndyD » Wed Jan 08, 2014 1:16 pm

Hi,

I am trying to locate the client data, specifically Client name, individual cleint contacts, and their associated contact details. Could you please point me to the tables that hold this information?

Many thanks
Andy

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Wed Jan 08, 2014 1:35 pm

Andy,

This information is in the main post.

BH_ClientCorporation has the company information and the Contact data is found in 2 tables BH_UserContact joined to BH_Client using userID column. The contacts join to the company via a clientcorporationID column on BH_Client.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

htran811
User
Posts: 2
Joined: Wed Aug 12, 2015 7:14 pm

Re: Tables (with brief descriptions)

Post by htran811 » Tue May 24, 2016 1:40 pm

Hi. I am having trouble locating the Owner User for Client Corporation. can you please show me where I can find them? Thanks.

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Tables (with brief descriptions)

Post by apsmith » Tue May 24, 2016 1:49 pm

Hello, a client corporation does not have an owner, the list of owners is the list of owners of all contacts at that company.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

Post Reply