Location of User Defined Fields in backup

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

Moderators: StaffingSupport, s.emmons

Post Reply
h00ver
User
Posts: 6
Joined: Thu Jun 06, 2013 1:05 pm

Location of User Defined Fields in backup

Post by h00ver » Mon Feb 02, 2015 4:15 pm

We are running a data conversion, and trying to get the User Defined Fields to map up correctly. However, in order to do that, we need to know the structure of the Fields and where they are located in the database. Anyone know where they can be found?

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

Re: Location of User Defined Fields in backup

Post by apsmith » Mon Feb 02, 2015 8:09 pm

hoover,

By user defined field, you mean custom fields (ie customText2)? If so, your client has access to a tool called Field Maps where they are defined.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

h00ver
User
Posts: 6
Joined: Thu Jun 06, 2013 1:05 pm

Re: Location of User Defined Fields in backup

Post by h00ver » Tue Feb 03, 2015 10:56 am

I am aware of the Field Maps tool, however we are having trouble finding the actual location of the fields and the data associated within the backup that we were given. Is there a specific structure path that all the custom fields are located in?

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

Re: Location of User Defined Fields in backup

Post by apsmith » Tue Feb 03, 2015 12:57 pm

hoover,

What fields (and on what entity) are you trying to find?
Andrew Smith
Director, Technical Operations
Developer Forum Admin

h00ver
User
Posts: 6
Joined: Thu Jun 06, 2013 1:05 pm

Re: Location of User Defined Fields in backup

Post by h00ver » Tue Feb 03, 2015 3:37 pm

There's about 65 fields that I'm trying to locate, and they're all spread out between all of the different record categories. The categories I need are as follows:

Candidate
Candidate List
Company
Contact
Contact List
Job
Placement

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

Re: Location of User Defined Fields in backup

Post by apsmith » Tue Feb 03, 2015 8:35 pm

hoover,

Those are not fields, they are entities, are you not even able to find the tables involved? If not, there is a sticky topic on this forum with pointers for the major entities.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

h00ver
User
Posts: 6
Joined: Thu Jun 06, 2013 1:05 pm

Re: Location of User Defined Fields in backup

Post by h00ver » Wed Feb 04, 2015 10:33 am

I'm not actually looking at the data, but just acting as a go between for the people running the conversion for us. I've looked at the sticky, and I think Ive got how the entities match to each table. Please correct me if I am wrong.

Entity -> Table

Candidate -> BH_Candidate
Candidate List -> ?
Company -> BH_Client
Contact -> BH_UserContact
Contact List -> ?
Job -> BH_JobPosting
Placement -> BH_Placement

I could not see where the two lists would map to

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

Re: Location of User Defined Fields in backup

Post by apsmith » Wed Feb 04, 2015 12:44 pm

The lists do not map to an entity, they are just a display of that entity.

For example, Candidate list view the candidate entity. (BH_Candidate)
Andrew Smith
Director, Technical Operations
Developer Forum Admin

h00ver
User
Posts: 6
Joined: Thu Jun 06, 2013 1:05 pm

Re: Location of User Defined Fields in backup

Post by h00ver » Thu Feb 05, 2015 10:46 am

My conversion team cannot find any custom field data in the tables that I mentioned. Is the custom data included in incremental backups or only full backups?

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

Re: Location of User Defined Fields in backup

Post by apsmith » Thu Feb 05, 2015 10:48 am

hoover,

I will need specifics on what you cannot find.

The customText, customInt etc fields are in the BH_userCOntact tables. this table is shared by all person entities (candidate, contact, internal) and extended by the relevant tables (BH_Candidarte, BH_client, BH_CorporateUser respectively)
Andrew Smith
Director, Technical Operations
Developer Forum Admin

Post Reply