dbo.QERDynamicGroupBlackList
To exclude identities from dynamic roles due to a denied attestation or a rule violation, or manually, for example.
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DynamicGroup | varchar(38) | no | Dynamic role | PKFKUID |
UID_Person | varchar(38) | no | Identity | PKFKUID |
Description | nvarchar(-1) | yes | Reason | |
IsNotMatched | bit(1) | yes | Condition not applicable | |
IsAssignedByOthers | bit(1) | yes | Not assigned by dynamic role | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1070 | QERDynamicGroupBlackList.UID_Person | Person.UID_Person |
| QER_RFRL1071 | QERDynamicGroupBlackList.UID_DynamicGroup | DynamicGroup.UID_DynamicGroup |
Triggers
GEN_T3E7424CCF31FB5F646E190C23 SQL_TRIGGER
QER_TDQERDynamicGroupBlackList SQL_TRIGGER
QER_TIQERDynamicGroupBlackList 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_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_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| Person | referenced by foreign key from table | QER_RFRL1070: QERDynamicGroupBlackList.UID_Person -> Person.UID_Person |
| DynamicGroup | referenced by foreign key from table | QER_RFRL1071: QERDynamicGroupBlackList.UID_DynamicGroup -> DynamicGroup.UID_DynamicGroup |
| dbo.QER_PDynamicGroupMakeProc_hlp | source text reference | 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 |