dbo.Delegation
Delegations
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Delegation | varchar(38) | no | Delegation | PKUID |
UID_PersonReceiver | varchar(38) | no | Delegation recipient | FKUID |
UID_PersonSender | varchar(38) | no | Delegator | FKUID |
UID_PersonWantsOrg | varchar(38) | no | Request procedure | FKUID |
ObjectKeyDelegated | varchar(138) | no | Delegation object | |
IsDelegable | bit(1) | yes | further delegable | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
KeepMeInformed | bit(1) | yes | Information for delegators | |
OrderState | nvarchar(32) | yes | Request status | limited |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1712 | Delegation.UID_PersonWantsOrg | PersonWantsOrg.UID_PersonWantsOrg |
Triggers
GEN_T14F9BAB630FEC5E457C155D22 SQL_TRIGGER
GEN_T282F7C436F7EDAC30B5878691 SQL_TRIGGER
GEN_T3E427E8A0BFA60C93C3579F71 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_FGIPWOVisibleForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PPersonDelete_GDPR | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopRepairClosed | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOVisibleForPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPersonWantsOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DelegableItem | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOPersonPropertyReset | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOPersonPropertyReset | SQL expression dependency | dbo · UID_Delegation · OBJECT_OR_COLUMN |
| dbo.QER_VPWOPersonPropertyReset | SQL expression dependency | dbo · UID_PersonReceiver · OBJECT_OR_COLUMN |
| dbo.QER_VPWOPersonPropertyReset | SQL expression dependency | dbo · UID_PersonSender · OBJECT_OR_COLUMN |
| dbo.QER_VPWOPersonPropertyReset | SQL expression dependency | dbo · UID_PersonWantsOrg · OBJECT_OR_COLUMN |
| PersonWantsOrg | referenced by foreign key from table | QER_RFRL1712: Delegation.UID_PersonWantsOrg -> PersonWantsOrg.UID_PersonWantsOrg |
| dbo.QER_FGIPWOVisibleForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_PPersonDelete_GDPR | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZAllForPersonInBaseTree | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopRepairClosed | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_FTPWOVisibleForPerson_I | source text reference | uses session context values |
| dbo.QER_TDPerson | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUHelperHeadOrg | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUHelperHeadPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPersonInBaseTree | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPersonWantsOrg | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| cs-ads-forms-ads-forms-formadsaccountmasterdata.cs | decompiled C# reference | classes FormADSAccountMasterData; methods OnInit, _ActivateForm, _AdaptTasks, FormTask_MoveToDomain, FormTask_MoveContainer, FormTask_Unlock; references ADSAccount, ADSAccountInADSGroup, ADSContainer, ADSDomain, ADSGroup, Delegation; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-att-compositionapi-server-plugin-att-compositionapi-api-att-case-workflow.cs | decompiled C# reference | classes ATT_Case_Workflow, _003C_003Ec__DisplayClass0_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, _003CBuild_003Eb__2, _003CBuild_003Eb__3, _003CBuild_003Eb__4; references AttestationCase, AttestationPolicy, Delegation, ESet, Person; markers reads entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| cs-att-customizer-att-customizer-attestationcase.cs | decompiled C# reference | classes AttestationCase, MP, DecisionHistoryArgs, _003C_003Ec__DisplayClass4_0; methods _003C_Initialize_IsNotApprovedBefore_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _Initialize_IsNotApprovedBefore, Handle_DecisionHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-att-forms-att-forms-formattestationmakedecision.cs | decompiled C# reference | classes FormAttestationMakeDecision; methods OnInit, InitializeComponent, OnFormLoad, OnFormSizeChanged, OnFormUnload, Task_ShowHistory; references AttestationCase, AttestationHelper, AttestationHistory, AttestationObject, AttestationPolicy, Delegation; markers reads entity values, references DB/Dialog objects |
| cs-qer-compositionapi-qer-compositionapi-history-unsubscribepwoaction.cs | decompiled C# reference | classes UnsubscribePwoAction; methods MoveNext, SetStateMachine, ExecuteAsync, ToSerializableActionAsync, FromAssignmentKeyAsync, FromUidPwoAsync; references Delegation, Person, PersonWantsOrg, QERJustification; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-qer-compositionapi-role-roleassigncompare.cs | decompiled C# reference | classes RoleAssignCompare; methods MoveNext, SetStateMachine, GetMergeActionsAsync; references Delegation; markers references DB/Dialog objects |
| cs-qer-compositionapi-qer-compositionapi-role-rolesplit.cs | decompiled C# reference | classes RoleSplit, _003C_003Ec__DisplayClass29_0, _003C_003Ec__DisplayClass29_1; methods MoveNext, SetStateMachine, _003CGetSingleAssignmentActionsAsync_003Eb__0, _003CGetSingleAssignmentActionsAsync_003Eb__1, _003CGetSingleAssignmentActionsAsync_003Eb__2, InitAsync; references AERole, Delegation, DynamicGroup, OrgRoot, Person; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-qer-compositionapi-server-plugin-qer-compositionapi-delegation-globaldelegationapi.cs | decompiled C# reference | classes GlobalDelegationApi, FkWhereClauseContext, _003C_003Ec__DisplayClass0_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, Build, CheckPersonIsValidAsync, GetCountRolesOwnedAsync; references DelegableItem, Delegation, OrgRoot, Person; markers reads entity values, references DB/Dialog objects |
| cs-qer-compositionapi-server-plugin-qer-compositionapi-itshop-workflowapi.cs | decompiled C# reference | classes WorkflowApi, _003C_003Ec__DisplayClass1_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, _003CBuild_003Eb__2, _003CBuild_003Eb__3, _003CBuild_003Eb__4; references AccProduct, Delegation, ESet, Person, PersonWantsOrg; markers reads entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-delegation.cs | decompiled C# reference | classes Delegation; methods MoveNext, SetStateMachine, OnSavingAsync, GetParentInformed, _CheckDelegation, _CheckPwO; references DelegableItem, Delegation, Person, PersonWantsOrg, PWOState; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| 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-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process 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 |
| cs-qer-customizer-qer-customizer-pwodecisionsubmethod.cs | decompiled C# reference | classes PWODecisionSubMethod, SelectableEntity, _003C_003Ec__DisplayClass3_0, _003C_003Ec__DisplayClass7_0; methods GetTablename, _003CGetValidityMessages_003Eb__0, _003CValidityCheck_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync; references Delegation, PWODecisionMethod, PWODecisionRule, PWODecisionStep, PWODecisionSubMethod; markers reads entity values, saves entities, references DB/Dialog objects |
| cs-qer-forms-qer-forms-formdelegationmasterdata.cs | decompiled C# reference | classes FormDelegationMasterData; methods OnInit, InitializeComponent, OnFormLoad, TaskAbort, MainActivator_OnActivating, _AdaptTasks; references DelegableItem, Delegation, HelperHeadPerson, ITShopOrg, Person, PersonWantsOrg; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-forms-qer-forms-formitshopdecideorder.cs | decompiled C# reference | classes FormITShopDecideOrder; methods OnInit, Proxy_NodeDoubleClick, OnDesignChanged, OnResetForm, _LoadComplianceExceptions, InitializeComponent; references AccProduct, ComplianceArea, ComplianceRule, Delegation, ESet, HelperPWOCompliance; markers reads entity values, references DB/Dialog objects, IT Shop related markers |