dbo.BaseTreeCollection
Role/organization inheritance hierarchies
TableType BUsage MATERIALRows 733SizeMB 0.176
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Org | varchar(38) | no | Role/organization | PKFKUID |
UID_ParentOrg | varchar(38) | no | Parent role / parent organization | PKFKUID |
XTouched | nchar(2) | yes | Processing status |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL3286 | BaseTreeCollection.UID_ParentOrg | BaseTree.UID_Org |
Triggers
GEN_T18B0F54C0AF42F68CEA2259F8 SQL_TRIGGER
GEN_T28962414ABE9507896FB96CFE 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.ATT_FTOrgAttHighest | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTOrgRulerHighest | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTOrgAttHighest | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTOrgRulerHighest | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZOrgHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZOrgHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopPersonHasObjFill_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_POrgSubTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllChildrenOfOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgRoot | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZESetCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZOrgHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZAllForOneRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZOrgHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTOrgAttestatorHighest | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTOrgHighestRulerContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUBaseTreeHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_VAERoleADSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.AERoleCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DepartmentCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ITShopOrgCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ITShopSrcCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_VAERoleLDAPContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LocalityCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.NonComplianceCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.OrgCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ProfitCenterCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERITShopOwnerUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VAERoleUnsContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VAERoleUnsContainerB | SQL expression dependency | OBJECT_OR_COLUMN |
| BaseTree | referenced by foreign key from table | QER_RFRL3286: BaseTreeCollection.UID_ParentOrg -> BaseTree.UID_Org |
| dbo.ATT_FTOrgAttHighest | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ATT_FTOrgRulerHighest | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTOrgAttHighest | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTOrgRulerHighest | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.ADS_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.ADS_ZOrgHasADSGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZOrgHasLDAPGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PITShopPersonHasObjFill_b | source text reference | has TRY/CATCH error handling |
| dbo.QER_POrgSubTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZAllChildrenOfOrg | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERAssign | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERResource | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERReuse | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERReuseUS | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZOrgRoot | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.RMS_ZESetCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_ZOrgHasESet | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZAllForOneRPSReport | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.RPS_ZOrgHasRPSReport | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasTSBAccountDef | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB1 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB2 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB3 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_FTOrgAttestatorHighest | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTOrgHighestRulerContainer | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TIBaseTree | 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.RMS_TUBaseTreeHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |