This table holds all defined user groups of the application.
User groups are used for routing purposes and group together users,
who are working in a common area of business.
A predefined extension of the USFMOD functions might be activated
when adding the field USGSET to the USG table to activate the filter
function for main groups (groups of user groups).
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of User Group | Text | 8 | 1 | Edit | Yes | Public | ||
| EXTKEY | User Group ID | Text | 6 | 1 | Edit | Yes | Public | USGTXT | |
| NAM | Name of User Group | Text | 40 | 1 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| COLOR | Color for charts | Text | 6 | 1 | Edit | Yes | Public | CHSCOL | |
| ETYEXTKEY | Entity of profiledata of Usergroup | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search Fields. | Text | 60 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| USG_ETYEXTKEY | ETYEXTKEY | |
| USG_EXTKEY | EXTKEY | Unique |
| USG_EXTKEY | EXTKEY, ETYEXTKEY | Unique |
| USG_GETFLDNRM | GETFLDNRM | |
| USG_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter USG. The field INR is used to maintain links from other tables into this table. Additionally for performance reasons, the EXTKEY of a user group is used in many application tables as a link, as often only the user group ID is needed and in this case, no resolution of a link is necessary to get this information.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field holds the shortname of a user group. This shortname might be used in other tables to identify a user group. To decode a user group to a language-dependent longname, the codetable USGTXT might be used.
This field holds the shortname of a user group. This shortname might be used in other tables to identify a user group. The 'User Group' codetable can be used to decode a user group to a language-dependent longname.
This is the internally used descriptive longname of a user group.
This is the descriptive longname of a user group used internally .
This field holds the version counter to keep track of the version history of a USG entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
Color to be used if group is represented in charts.
Typically specified in form rgb(rrr,ggg,bbb) as this allows automatic modification of color to create color gradients.
This field controls the color in which the entries assigned to the user are displayed in the Dashboard charts.
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
This field holds the external key of the owning entity to identify the logical owner of this entry.
This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.