Search found 8 matches

by bhdataq
Mon Apr 14, 2014 3:55 pm
Forum: BH Backup Information
Topic: BH Notes, where Action = email
Replies: 1
Views: 9844

BH Notes, where Action = email

Regarding emails that become Notes (action = email) associated with either a candidate or client... In BullHorn we're seeing that the notes with an Action = email are truncated. Part of the note will display, but there is a hyperlink reading "more" at the end. When you click "more" you are directed ...
by bhdataq
Tue Apr 08, 2014 11:50 am
Forum: BH Backup Information
Topic: Client Corporation
Replies: 1
Views: 10184

Client Corporation

What are we missing? Here is the code: SELECT distinct cc.clientCorporationID ,cc.name ,cc.status ,count(c.userid) [Contact Count] FROM BullHorn.BULLHORN1.BH_ClientCorporation cc left join BullHorn.BULLHORN1.BH_Client c ON cc.clientCorporationID = c.clientCorporationID WHERE 1=1 group by cc.clientco...
by bhdataq
Mon Apr 07, 2014 12:05 pm
Forum: BH Backup Information
Topic: File Structure for Attachments folders
Replies: 2
Views: 11080

Re: File Structure for Attachments folders

?? any response ?? We emailed and were told to post this question here on the discussion board.
by bhdataq
Fri Apr 04, 2014 9:53 pm
Forum: BH Backup Information
Topic: File Structure for Attachments folders
Replies: 2
Views: 11080

File Structure for Attachments folders

Could you please provide me with the tree structure for the backup files which house the attachments. We have 4 files in our backup. They end with: _database.rar _PL-320_1.rar _PL-320_4.rar _4251_1.rar We have downloaded and can access the _database.rar file. It is our presumption that the other thr...
by bhdataq
Tue Apr 01, 2014 1:23 pm
Forum: BH Backup Information
Topic: Private Label
Replies: 1
Views: 9895

Private Label

What is a Private Label? We were just notified that we have a primary and a secondary private label. Is the data different in each private label?

thanks.
by bhdataq
Fri Mar 28, 2014 1:45 pm
Forum: BH Backup Information
Topic: Attachments
Replies: 1
Views: 9678

Attachments

I've followed the postings I've found on this forum and can identify the attachments in our backup for both Candidates and Contacts. However, there are instances where a Facility also has an attachment. How is this identified? Here are my joins: FROM BULLHORN1.BH_UserWork uw JOIN BULLHORN1.BH_UserWo...
by bhdataq
Fri Mar 21, 2014 3:39 pm
Forum: BH Backup Information
Topic: More records in BH database than on BH web
Replies: 3
Views: 12487

Re: More records in BH database than on BH web

The ClientCorporation table does not have a isDeleted column. There is no concept of a soft deleted ClientCorporation, the appplication views a valid ClientCorporation as one having a linked Contact (BH_Client.clientcorporationID). So it's possible that the reason for more Facility (clientcorporati...
by bhdataq
Fri Mar 21, 2014 1:58 pm
Forum: BH Backup Information
Topic: More records in BH database than on BH web
Replies: 3
Views: 12487

More records in BH database than on BH web

Are there filters we need to be mindful of as we are looking at the backup data - to weed out unusable/deleted records? We have been able to identify the isDeleted field. However, even with that, we are still finding more records in the database than we do when viewing through the Web service (and c...