The following list of fields is a basic view of all group contacts (members). It also includes managers. Here, View_Group is joined with the Group_Member table, and then joined with the ca_contact table. All fields in View_Group are listed, as well as the first, middle and last name from the ca_contact table. The Group_Member manager flag is also listed. The group member manager flag is 1 or 0, which means that the member is either (yes - 1) a manager, or (no - 0) not a manager. Most of the information in this view pertains to the group itself, not the actual members. This view is used to find information on a particular group, including the names of its members.
Field |
Remarks |
---|---|
View_Group.* |
The View_Group fields that are defined in the View_Group definition. |
member_lastname |
ca_contact.last_name: The surname of the group member. |
member_firstname |
ca_contact.first_name: The formal first name of the group member. |
member_middlename |
ca_contact.middle_name: The middle name of the group member. |
grpmem_manager_flag |
ca_contact.manager_flag: The Group Member Manager (1 or 0) indicator. |
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |