dbo.BaseTreeExcludesBasetree
Conflicting roles and origanizations
TableType BUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Org | varchar(38) | no | Role/organization | PKFKUID |
UID_OrgExcluded | varchar(38) | no | Conflicting business role | PKFKUID |
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 | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1627 | BaseTreeExcludesBasetree.UID_Org | BaseTree.UID_Org |
Triggers
GEN_T192BE894F4764F809C6E07070 SQL_TRIGGER
GEN_T2C2BA7FA63BC26484CD47A8C5 SQL_TRIGGER
GEN_T3B386261DC8BD37C70AED30CD SQL_TRIGGER
QER_TDBaseTreeExcludesBaseTree SQL_TRIGGER
QER_TIBaseTreeExcludesBaseTree 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.GEN_T380DEA238A283A0D5F954A670 | 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.AERoleExcludesAERole | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DepartmentExcludesDepartment | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LocalityExcludesLocality | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.OrgExcludesOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ProfitCenterExcludesProf | SQL expression dependency | OBJECT_OR_COLUMN |
| BaseTree | referenced by foreign key from table | QER_RFRL1627: BaseTreeExcludesBasetree.UID_Org -> BaseTree.UID_Org |
| dbo.QER_PDynamicGroupMakeProc_hlp | source text reference | 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 |