dbo.HelperPWOPersonHasObject

Auxiliary table for the IT Shop that notes which identity would be allocated object keys they that did not have already due to the request.

TableType TUsage MATERIALRows 0SizeMB 0

Table relation graph

Loading table relation graph…

Columns

NameTypeNullableOIM caption/commentaryFlags
UID_HelperPWOPersonHasObjectvarchar(38)noIDPKUID
UID_Personvarchar(38)yesIdentityFKUID
UID_PersonWantsOrgvarchar(38)yesRequest procedureFKUID
ObjectKeyvarchar(138)yesObject key
UID_OrgRelatedvarchar(38)yesAssigned business roleFKUID
IsExistingbit(1)yesalready exists
IsFromSubIdentityOnlybit(1)yesAssignment of subidentity

Relations

FKFromTo
QER_RFRL1757HelperPWOPersonHasObject.UID_PersonWantsOrgPersonWantsOrg.UID_PersonWantsOrg
QER_RFRL1758HelperPWOPersonHasObject.UID_PersonPerson.UID_Person
QER_RFRL2566HelperPWOPersonHasObject.UID_OrgRelatedBaseTree.UID_Org

Triggers

GEN_T24FB1E3D7153AF1B956B59EC4 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.CPL_FTCCSPersonHasObjectWPWOSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopPersonHasObjFill_bSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopOrderResetSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_FTCCSPersonsForPWOSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_FTCCSPWOCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TDBaseTreeHasObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TDPersonHasObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIPersonHasObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUPersonWantsOrgSQL expression dependencyOBJECT_OR_COLUMN
PersonWantsOrgreferenced by foreign key from tableQER_RFRL1757: HelperPWOPersonHasObject.UID_PersonWantsOrg -> PersonWantsOrg.UID_PersonWantsOrg
Personreferenced by foreign key from tableQER_RFRL1758: HelperPWOPersonHasObject.UID_Person -> Person.UID_Person
BaseTreereferenced by foreign key from tableQER_RFRL2566: HelperPWOPersonHasObject.UID_OrgRelated -> BaseTree.UID_Org
dbo.CPL_FTCCSPersonHasObjectWPWOsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.CPL_PComplianceCheckMakeProc_hsource text referencehas TRY/CATCH error handling
dbo.QER_PITShopPersonHasObjFill_bsource text referencehas TRY/CATCH error handling
dbo.QER_ZITShopOrderResetsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.CPL_FTCCSPersonsForPWOsource text referenceSQL_TABLE_VALUED_FUNCTION
dbo.CPL_FTCCSPWOChecksource text referenceSQL_TABLE_VALUED_FUNCTION
dbo.QER_TDBaseTreeHasObjectsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TDPersonHasObjectsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TIBaseTreeHasObjectsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TIPersonHasObjectsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TUPersonWantsOrgsource text referencecreates 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-cpl-compositionapi-cpl-compositionapi-itshop-cartcompliancecheck.csdecompiled C# referenceclasses CartComplianceCheck, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass12_0, _003C_003Ec__DisplayClass17_0; methods MoveNext, SetStateMachine, _003CGetViolationsAsync_003Eb__1, _003CGetViolationsAsync_003Eb__2, _003CSetExceptionApproverFlagsAsync_003Eb__1, _003CCheckOrgAssignmentComplianceAsync_003Eb__3; references AERole, ComplianceRule, ComplianceSubRule, Department, ESet, HelperPWOPersonHasObject; markers reads entity values, references DB/Dialog objects, IT Shop related markers