Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Y_Contact_Group

Y_Contact_Group represents contact groups (Address Books) and contains information such as the user who owns the contact group, whether the contact group is public, and name of the contact group.

This table represents the Contact Group Information block on the General tab of a contact group record. The list of members is available through the memberList attribute.

Object: Y_Contact_Group

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

createdBy-->

CREATED_BY_
ID (NUMBER)

 

x

x

YUser

object

8 User who created the contact group (Address Book).

--> Links to specific information for the user account.

createdOn

CREATED_ON (DATE)

 

x

   

date

Date when the contact group (Address Book) was created.

members-->

Before TeamConnect 3.3

SP2: memberList-->

n/a

   

x

JDistMember

 

Links to the list of members in the contact group (Address Book).

modifiedBy-->

MODIFIED_BY_
ID (NUMBER)

 

x

x

YUser

object

8 User who last modified the contact group (Address Book).

--> Links to specific information for the user account.

modifiedOn

MODIFIED_ON (NUMBER)

 

x

   

date

Date when the contact group (Address Book) was last modified.

name

NAME
(VARCHAR2) (250)

Group name (General block of Contact Group)

x

   

string (250)

The name of the contact group (Address Book).

owner-->

USER_ID (NUMBER)

 

x

x

YUser

object

8 The user to whom the contact group (Address Book) belongs.

--> Links to specific information about the user account.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the contact group (Address Book).

shared

Before TeamConnect 3.3

SP2: isPublic

IS_PUBLIC (NUMBER)

Is contact group (Address Book) public (General block of Contact Group)

x

   

boolean

The setting that indicates whether the contact group is public.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the item was updated.

JDistMember

JDistMember contains information about the members of a contact group (Address Book). This information includes the contact who is a member of a contact group and the contact group to which the member belongs. This table represents the Contact Group Information block on the Members tab of a contact group record.

Object: JDistMember (J_DIST_MEMBER)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

contact-->

CONTACT_ID (NUMBER)

Member (Members block of Contact Group)

x

x

TContact

object

8 The contact who is a member of a contact group (Address Book).

--> Links to specific information for the contact record.

createdBy-->

CREATED_BY_ID (NUMBER)

 

x

x

YUser

object

8 User who created the contact group (Address Book) member.

--> Links to specific information for the user account.

createdOn

CREATED_ON (DATE)

 

x

   

date

Date when the contact group (Address Book) member was created.

distribution-->

CONTACT_ GROUP_ID (NUMBER)

 

x

x

RDistribution

object

8 The contact group (Address Book) to which this contact group member belongs.

--> Links to definition information for the contact group.

modifiedBy-->

MODIFIED_BY_ID (NUMBER)

 

x

x

YUser

object

8 User who last modified the contact group (Address Book) member.

--> Links to specific information for the user account.

modifiedOn

MODIFIED_ON (DATE)

 

x

   

date

Date when the contact group (Address Book) member was last modified.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the contact group (Address Book) member.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the item was updated.

  • Was this article helpful?