dbo.BaseTreeHasQERAssign
Roles and organizations: resource assignments
TableType BUsage USERDATARows 10SizeMB 0.032
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Org | varchar(38) | no | Role/organization | PKFKUID |
UID_QERAssign | varchar(38) | no | Assignment resource | PKFKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
RiskIndexCalculated | float(8) | yes | Risk index (calculated) | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
XOrigin | int(4) | yes | Origin | bitmask |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XIsInEffect | bit(1) | yes | Assignment in effect |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T1954312266BED2B5FBC557445 SQL_TRIGGER
GEN_T231D6B739C878E506CDE93AAF SQL_TRIGGER
GEN_T5CEDE433ADD82BAED611B33E6 SQL_TRIGGER
GEN_T65329233D224F6C4B82F5DABF SQL_TRIGGER
QER_TIBaseTreeHasQERAssign SQL_TRIGGER
QER_TUBaseTreeHasQERAssign 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_FTC981DF5F2F0406E0D7320D5B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADDFFE62F7C862D8EFE9F7E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO2449A21EFB122D2AF3B920 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY6A4C3C6E502E007685003B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P1BF268D1A2D85F748D1C8D3DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PEE925B28D9898EAABD5AB9B6A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PAfterMigrationTasks | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C30B8F2DD0A6BE8152D41A12 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CEDE433ADD82BAED611B33E6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTreeHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DepartmentHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ITShopOrgHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ITShopSrcHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LocalityHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.OrgHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ProfitCenterHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PAfterMigrationTasks | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERAssign | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERAssign | source text reference | has TRY/CATCH error handling |
| dbo.QER_TUBaseTreeHasQERAssign | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERAssign | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |