Table Name:exc_usr_role
Table Number:5288
Group:Exchange Mgr
Description:Roles played users and exchanges for one another. Reserved; future
Flags: 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
activeLONGsmallint  DIRECT Indicates whether the role is currently being used; i.e., 0=inactive, 1=active, default=1  
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
focus_typeLONGsmallint   DIRECT Object type ID of the role-player; i.e., 20=a user's role, 5140=an exchange's role (rare)  
objidLONGint3  DIRECT Internal record number  
role_nameCHARvarchar 80  Name of the role  
server_idLONGint   DIRECT Exchange protocol server ID number  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
exc_usr_role2exchangeMTOexchangeexchange2exc_usr_roleExchange involved with the role    
exc_usr_role2userMTOuseruser2exc_usr_roleUser involved with the role    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
exc_usr_indrole_name:exc_usr_role2exchangeUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
exc_usr_indrole_name, exc_usr_role2exchangenonclustered, unique located on PRIMARY
ind_exc_usr_role2exchangeexc_usr_role2exchange, exc_usr_role2user, role_namenonclustered located on PRIMARY
ind_exc_usr_role2userexc_usr_role2user, exc_usr_role2exchange, role_namenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
exc_usr_role