Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 937
  • Last Modified:

Goldmine/Crystal: What is CONTSUPP.RECTYPE='P'

Hi,
We run Crystal Reports against our Goldmine DB. I see in some queries CONTSUPP.RECTYPE='P'
Can some one please explain what this means and are there other values besides 'P'.

We have a report that contains...

WHERE
    CONTSUPP.CONTACT = 'Products' AND
    CONTSUPP.RECTYPE = 'P

...and I'm trying to figure out what kind of report this produces.
0
veedar
Asked:
veedar
  • 2
1 Solution
 
wykabryanCommented:
It would be a guess, because I do not know the database architexture as it ties in with the front end, but because it is a single character this would indicate a flag of some sort.  I would suggest that you talk to your GoldMine Administrator as there is a workflow frontend that will tell you exactly what the field is used for.
0
 
wykabryanCommented:
Based on looking up GoldMine for that table here is the following.
contsupp
rectype
 Description
E
 Automated Process attached event
H
 Extended profile header
L
 Linked document
O
 Organizational chart
P
 Profile record/extended profile record
R
 Referral record
 
The RECTYPE value H can be linked to records with the RECTYPE value P. Assigning extended information settings to a profile (assigned to a tab, or extended fields used) creates an H record type to store the settings. The profile record stores a character string in the Phone field that matches the H record’s AccountNo field.


There are additional information about GoldMine tables and description at this link:
http://www.dcsgroupllc.com/dcscrmsql/tutorials/goldmine_sql_query_tutorial.html

Hope this helps.
0
 
veedarAuthor Commented:
Thank you wykabryan....I sort of inherited this from someone who left the company so I am the GM admin. You mentioned a workflow front end.  That sounds interesting can you tell me how I can get into that?
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now