dbo.DynamicGroup
Dynamic roles
TableType TUsage USERDATARows 10SizeMB 0.048
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DynamicGroup | varchar(38) | no | Dynamic role | PKUID |
UID_DialogTableObjectClass | varchar(38) | yes | Object class | FKUIDlimited |
UID_DialogSchedule | varchar(38) | yes | Calculation schedule | FKUID |
DisplayName | nvarchar(512) | yes | Dynamic role | |
WhereClause | nvarchar(-1) | yes | Condition | |
Description | nvarchar(-1) | yes | Description | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
WhereClauseAddOn | nvarchar(-1) | yes | Additional condition | |
XObjectKey | varchar(138) | no | Object key | |
ObjectKeyBaseTree | varchar(138) | no | Role/organization | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsRecalculationDeactivated | bit(1) | yes | No recalculation of assignments | |
IsCalculateImmediately | bit(1) | yes | Immediate recalculation of assignments |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1071 | QERDynamicGroupBlackList.UID_DynamicGroup | DynamicGroup.UID_DynamicGroup |
| QER_RFRL1120 | DynamicGroupHasImmediateColumn.UID_DynamicGroup | DynamicGroup.UID_DynamicGroup |
| QER_RFRL1476 | DynamicGroup.UID_DialogSchedule | DialogSchedule.UID_DialogSchedule |
| QER_RFRL2378 | DynamicGroup.UID_DialogTableObjectClass | DialogTable.UID_DialogTable |
Triggers
GEN_T18C115FB9E44F7DEAA7C91E6D SQL_TRIGGER
GEN_T2C421897AB6560346E8EC5C96 SQL_TRIGGER
GEN_T594EFD452DD4326FC55F98BA9 SQL_TRIGGER
QER_TDDynamicGroup SQL_TRIGGER
QER_TIDynamicGroup SQL_TRIGGER
QER_TUDynamicGroup SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.GEN_FTEA0903650603CEE51D0D8E99 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA199E3E6A7A8E311D20E166 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA39F97BA14C3AF610AF805D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA9CC8C922010CFFAA6F4D1C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB4B3FCC3F35FE97044F114 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD6C8AFC6E23E46E496EAC8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO04F18550BAA5EF552107EF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO41BDBF3DEDBD7A3EDBE1DF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO8864B48D6F511D0508888B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9AF242348875AFC053A649 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB37287BA6CF952714E9E05 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD2110A8D430CBD7D961961 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY365A3E48EE0118A0F8B4E2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY44E94D0D92A82BFECD72B7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY4926D9B896C39764C9EF8F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY95A0CB3F5C230BAF81B16E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYC455A197F1F99E91DE3119 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF919254F951A7A5DF6B821 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZADSMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA104261FA54379C6160FAE8F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA11AF8D16C61275A2DCFAED6E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA32EFCA6201B15CB29D954994 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA6BF9FD71303E4D8F82AD2566 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA72A423016BA139FFC3D8EDFF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA98D6CE53656FFB7523357E71 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PACB9B89D5F903FDF8F2FAD40D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PAD1085733B383217D4E3F0797 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PAD601362D0C4E22FD4721754B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PAE14BB3C2EDA7D127BCA29F96 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD0C461BCE9B1499A948C6DE89 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD75EFC2994CF76773E86FDA0A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD7750F63D2FE88D966B93F426 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD85D31B610579F7BE495D13A3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD88D54946ECC34815B5EF8AA7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDA305E8EEC3AE04AAA39FD671 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDB81C19C7C55B5C62A0191559 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDBB056A1F7CFF0CE82AAA3734 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDBDCABA4BA9EB91B037DD3763 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDEC582A34382551F1DDFD9799 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PDynamicGroupMakeProc_hlp | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShop_ShopMove | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZDynamicGroupMakeProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZDynamicGroupMakeTrigger | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZDynGroupSingleHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZDynGroupSinglePerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZDynGroupSingleWorkDesk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZScheduleStartDynamicGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTDynGroupColForImmediate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T594EFD452DD4326FC55F98BA9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDBaseTreeExcludesBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeExcludesBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIDynamicGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIHardwareInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIWorkDeskInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUDynamicGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUOrgRootAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| QERDynamicGroupBlackList | foreign key references table | QER_RFRL1071: QERDynamicGroupBlackList.UID_DynamicGroup -> DynamicGroup.UID_DynamicGroup |
| DynamicGroupHasImmediateColumn | foreign key references table | QER_RFRL1120: DynamicGroupHasImmediateColumn.UID_DynamicGroup -> DynamicGroup.UID_DynamicGroup |
| DialogSchedule | referenced by foreign key from table | QER_RFRL1476: DynamicGroup.UID_DialogSchedule -> DialogSchedule.UID_DialogSchedule |
| DialogTable | referenced by foreign key from table | QER_RFRL2378: DynamicGroup.UID_DialogTableObjectClass -> DialogTable.UID_DialogTable |
| dbo.ADS_ZADSMachineInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.QER_PDynamicGroupMakeProc_hlp | source text reference | has TRY/CATCH error handling |
| dbo.QER_PITShop_ShopMove | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZAllForPersonInBaseTree | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZDynamicGroupMakeProc | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZDynamicGroupMakeTrigger | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZDynGroupSingleHardware | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZDynGroupSinglePerson | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZDynGroupSingleWorkDesk | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZScheduleStartDynamicGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_FTDynGroupColForImmediate | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TDBaseTreeExcludesBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTreeExcludesBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIDynamicGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIHardwareInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIWorkDeskInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUDynamicGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUOrgRootAssign | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| cs-qer-compositionapi-qer-compositionapi-role-rolesplit.cs | decompiled C# reference | classes RoleSplit, _003C_003Ec__DisplayClass29_0, _003C_003Ec__DisplayClass29_1; methods MoveNext, SetStateMachine, _003CGetSingleAssignmentActionsAsync_003Eb__0, _003CGetSingleAssignmentActionsAsync_003Eb__1, _003CGetSingleAssignmentActionsAsync_003Eb__2, InitAsync; references AERole, Delegation, DynamicGroup, OrgRoot, Person; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-qer-customizer-qer-customizer-dynamicgroup.cs | decompiled C# reference | classes DynamicGroup, _003C_003Ec__DisplayClass2_0; methods _003C_CheckObjectKeyBaseTree_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _CheckObjectKeyBaseTree, CheckWhereClause; references BasetreeAssign, DialogTable, DynamicGroup, OrgRoot, OrgRootAssign; markers reads entity values, references DB/Dialog objects |
| cs-qer-forms-qer-forms-formdynamicgroupmasterdata.cs | decompiled C# reference | classes FormDynamicGroupMasterData; methods OnInit, OnDispose, OnDesignChanged, OnResetForm, OnFormSizeChanged, OnFormLoad; references BasetreeAssign, DialogColumn, DialogSchedule, DialogTable, DynamicGroup, DynamicGroupHasImmediateColumn; markers reads entity values, references DB/Dialog objects |
| cs-vi-controls-vi-controls-data-genericrelationdatastore.cs | decompiled C# reference | classes GenericRelationDataStore; methods OnLoadDeferredOperationDictionary, OnSetState, OnSaveChanges, OnGetSettings, OnGetHistoryChangeInfos, OnGetOriginInformation; references DynamicGroup, ESet; markers writes entity values, references DB/Dialog objects |
| cs-vi-controls-vi-controls-data-memberrelationdatastore.cs | decompiled C# reference | classes MemberRelationDataStore; methods OnLoadDeferredOperationDictionary, OnSetState, OnSaveChanges, OnGetSettings, OnGetHistoryChangeInfos, OnGetOriginInformation; references DialogDeferredOperation, DynamicGroup, ESet; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-vi-ui-controls-common-base-vi-ui-controls-common-data-relations-memberrelationdatastore.cs | decompiled C# reference | classes MemberRelationDataStore, DeferredOperationInfo, MNLoadMemberInfo, OriginInformation; methods StateImageInfo, GetStateKey, Compare, MoveNext, SetStateMachine, IsMember; references DialogDeferredOperation, DynamicGroup, ESet; markers reads entity values, references DB/Dialog objects |