dbo.BaseTreeHasObject
Roles and organizations: company resource assignments
TableType TUsage MATERIALRows 348SizeMB 0.28
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_BaseTreeHasObject | varchar(38) | no | Assignment | PKUID |
ObjectKey | varchar(138) | no | Object key | |
UID_Org | varchar(38) | no | Role/organization | FKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
InheritInfo | int(4) | yes | Origin | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1413 | BaseTreeHasObject.UID_Org | BaseTree.UID_Org |
Triggers
GEN_T20EFA75A0DCDCC40F0C058306 SQL_TRIGGER
GEN_T368532D5494C3DD4E75BA0656 SQL_TRIGGER
QER_TDBaseTreeHasObject SQL_TRIGGER
QER_TIBaseTreeHasObject 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.CPL_FTCCSOrgCheckWithPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSOrgCheckWithPWODetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_FTCCSPersonCheckWithOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_000 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_001 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_010 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_011 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_100 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_101 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_110 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_111 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPwoValidDateRangesExist | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P1D67E3E269674A9ABEB90BA37 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P4057136D381E001C6D193807D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P511ED250CC29BC4790569AD05 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P52191672D9A949F56CEF49189 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P79C56D662E8621728F4523495 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB2F935A721940C6E32DB7B15C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB940AF6AF37DA86891585D609 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDB723629AD0B408FABAA3CD5E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PE480ACF02FD9C9941892572A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PEB7B38B3919D8817864BF479A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PFFF6475ED5AB3E00FA2D77305 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PBasetreeHasObjectPostProc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShop_PRNodesMove | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopPersonHasObjFill_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopProductNodeMove | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObjectExtAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPwoValidDateRanges | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDObjectHasExtendedAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIObjectHasExtendedAtt | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · ObjectKey · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheck | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.CPL_VCCSOrgCheckDetail | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPersonHasElemWReason | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · ObjectKey · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · InheritInfo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOProductNodes | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOProductNodesSlim | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOProductNodesSlim | SQL expression dependency | dbo · ObjectKey · OBJECT_OR_COLUMN |
| dbo.QER_VPWOProductNodesSlim | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_VPWOProductNodesSlim | SQL expression dependency | dbo · InheritInfo · OBJECT_OR_COLUMN |
| dbo.TSBVGroupMemberSource | SQL expression dependency | OBJECT_OR_COLUMN |
| BaseTree | referenced by foreign key from table | QER_RFRL1413: BaseTreeHasObject.UID_Org -> BaseTree.UID_Org |
| dbo.CPL_FTCCSOrgCheckWithPWO | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSOrgCheckWithPWODetail | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.CPL_FTCCSPersonCheckWithOrg | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_000 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_001 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_010 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_011 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_100 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_101 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_110 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_111 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIPwoValidDateRangesExist | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ADS_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_PBasetreeHasObjectPostProc | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShop_PRNodesMove | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopPersonHasObjFill_b | source text reference | has TRY/CATCH error handling |
| dbo.QER_PITShopProductNodeCreate_b | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopProductNodeMove | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZBaseTreeHasObjectExtAtt | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.RPS_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTPwoValidDateRanges | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.ADS_TUAdsGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TDObjectHasExtendedAtt | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIObjectHasExtendedAtt | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB1 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB2 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB3 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-itshophelperasync.cs | decompiled C# reference | classes ITShopHelperAsync, _003C_003Ec__DisplayClass14_0, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods _003C_CheckIsGroupAccount_003Eb__0, _003CHandlePersonHasAccountDef_003Eb__0, _003CGetValidAccountDef_003Eb__0, MoveNext, SetStateMachine, CreateAccountITShopOrder; references AccProduct, BasetreeAssign, BaseTreeHasObject, Delegation, DialogTable, ITShopOrg; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |