dbo.HelperWorkDeskOrg

Auxiliary table for identifying primary assignments of workdesks to roles and organization. Required for inheritance calculation. Depends on the settings of the configuration parameters under “QER\Structures\Inherite\Workdesk”.

TableType TUsage MATERIALRows 0SizeMB 0

Table relation graph

Loading table relation graph…

Columns

NameTypeNullableOIM caption/commentaryFlags
UID_WorkDeskvarchar(38)noWorkdeskPKFKUID
UID_Orgvarchar(38)noBusiness RolePKFKUID

Relations

FKFromTo
QER_RFRL1435HelperWorkDeskOrg.UID_WorkDeskWorkDesk.UID_WorkDesk
QER_RFRL1716HelperWorkDeskOrg.UID_OrgBaseTree.UID_Org

Triggers

QER_TDHelperWorkDeskOrg SQL_TRIGGER

QER_TIHelperWorkDeskOrg 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 objectRelationEvidence
dbo.ADS_ZADSMachineInADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_ZLDPMachineInLDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZHelperWorkDeskOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMB_ZHelperWorkDeskOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_ZWorkDeskHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_TIBaseTreeHasADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_TUAdsGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_TUBaseTreeHasADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_TIBaseTreeHasLDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_TUBaseTreeHasLDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_TIBaseTreeHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_TUBaseTreeHasESetSQL expression dependencyOBJECT_OR_COLUMN
WorkDeskreferenced by foreign key from tableQER_RFRL1435: HelperWorkDeskOrg.UID_WorkDesk -> WorkDesk.UID_WorkDesk
BaseTreereferenced by foreign key from tableQER_RFRL1716: HelperWorkDeskOrg.UID_Org -> BaseTree.UID_Org
dbo.ADS_ZADSMachineInADSGroupsource text referencehas TRY/CATCH error handling
dbo.LDP_ZLDPMachineInLDAPGroupsource text referencehas TRY/CATCH error handling
dbo.QER_ZHelperWorkDeskOrgsource text referencehas TRY/CATCH error handling
dbo.RMB_ZHelperWorkDeskOrgsource text referencehas TRY/CATCH error handling
dbo.RMS_ZWorkDeskHasESetsource text referencehas TRY/CATCH error handling
dbo.ADS_TIBaseTreeHasADSGroupsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.ADS_TUAdsGroupsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.ADS_TUBaseTreeHasADSGroupsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.LDP_TIBaseTreeHasLDAPGroupsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.LDP_TUBaseTreeHasLDAPGroupsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TUBaseTreesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.RMS_TIBaseTreeHasESetsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.RMS_TUBaseTreeHasESetsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling