dbo.BaseTreeCollectionF
Business role hierarchies
TableType TUsage MATERIALRows 765SizeMB 0.192
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Org | varchar(38) | no | Business Role | PKFKUID |
UID_ParentOrg | varchar(38) | no | Parent business role | PKFKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1201 | BaseTreeCollectionF.UID_Org | BaseTree.UID_Org |
Triggers
GEN_T1840A1B7AFE7F537D244CA8EF SQL_TRIGGER
GEN_T2338F711DBEF9AA0F9F4FFD1F 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.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOVisibleForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeOwnsObjectPrepair | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeOwnsObjectPrepair | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDynamicUserForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeCollectionF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeOwnsObjectPrepair | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPersonHeadCirc_All | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPersonHeadCirc_BaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOVisibleForPerson_I | 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.QER_VBaseTreeCollection | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VBaseTreeCollection | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_VBaseTreeCollection | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| dbo.QER_VBaseTreeCollection_Root | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VBaseTreeCollection_Root | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_VBaseTreeCollection_Root | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · UID_ParentOrg · OBJECT_OR_COLUMN |
| BaseTree | referenced by foreign key from table | QER_RFRL1201: BaseTreeCollectionF.UID_Org -> BaseTree.UID_Org |
| dbo.QER_FTHelperHeadOrgChildren | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTHelperHeadOrgChildren_RT | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTHelperHeadOrgParents | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTHelperHeadOrgParents_RT | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIPWOVisibleForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ADS_ZBaseTreeOwnsObjectPrepair | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_ZBaseTreeOwnsObjectPrepair | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_PDynamicUserForPerson | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZBaseTreeCollectionF | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeOwnsObjectPrepair | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_FTPersonHeadCirc_All | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPersonHeadCirc_BaseTree | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOVisibleForPerson_I | source text reference | uses session context values |
| 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 |