CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • what is record_type_id?
Pages: [1]

Author Topic: what is record_type_id?  (Read 538 times)

twls08

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.2.4
  • CMS version: Drupal
  • MySQL version: 5.5
  • PHP version: 3.4
what is record_type_id?
February 11, 2014, 09:29:26 pm
In the table "civicrm_activity_contact."  Mysql tells me that it is "the record type id for this row." 

It varies between 1 and 3.  2 and 3 seem to specify source and target of some activity, respectively.  But does does a value of 1 signify?

Thanks.  Apologies if I posted this in the wrong topic forum.

Rajesh

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 10
  • CiviCRM version: 4.2.x, 4.3.x, 4.4.x
  • CMS version: Drupal 7.xx, Wordpress 3.5.x - 3.6.x, Joomla 3.1
  • MySQL version: 5.5.20
  • PHP version: 5.3.10
Re: what is record_type_id?
February 12, 2014, 05:01:32 am
The record type ID 1 indicates that the contact is the activity assignee.

Value      Type
===================
1            Activity Assignees
2            Activity Source
3            Activity Targets

Hope this helps.

- Rajesh

maxwell

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal
  • MySQL version: 5.0
  • PHP version: 5.0
Re: what is record_type_id?
April 28, 2014, 08:24:51 am
Rajesh,

Thanks for the breakdown.

Which table are those values stored?
Are there ever anymore record_type_id than the three listed?

Warm Regards,
Chris

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: what is record_type_id?
April 28, 2014, 08:46:36 am
I am not sure but I would assume it is an option value (civicrm_option_value and civicrm_option_group)
Developer at Edeveloper / CiviCoop
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • what is record_type_id?

This forum was archived on 2017-11-26.