PersonSecurityGroups View

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

Contains detailed information on users belonging to security groups in different projects.

Dependencies

Columns

AppCode  :  varchar (max 100 chars), allows null: no

The application type. agSP corresponds to QAComplete; SaaS and agSPEnt correspond to QAComplete On-Premises.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time when the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date and time when the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DeptId  :  int, allows null: no

The ID of the user’s department.

Email  :  varchar (max 255 chars), allows null: no

The user’s email address.

GroupName  :  varchar (max 50 chars), allows null: no

The name of the security group.

IsActive  :  char (max 1 char), allows null: yes

Indicates whether the security user is active.

PersonSecurityGroupId  :  int, allows null: no

The unique numeric identifier of the item.

ProjId  :  int, allows null: no

The ID of the project.

ProjName  :  varchar (max 50 chars), allows null: no

The name of the project.

SecurityGroupId  :  int, allows null: no

The ID of the security group to which the user belongs in the project.

SecurityUserName  :  varchar (max 78 chars), allows null: no

The name of the user.

UserId  :  int, allows null: no

The ID of the security user.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the item.

WorkPhone  :  varchar (max 25 chars), allows null: yes

The user's work phone number.

See Also

PersonSecurityGroups Table
PersonAddresses View
Setup

Highlight search results