dbo.HelperPersonOrg

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

TableType TUsage MATERIALRows 540SizeMB 0.112

Table relation graph

Loading table relation graph…

Columns

NameTypeNullableOIM caption/commentaryFlags
UID_Personvarchar(38)noIdentityPKFKUID
UID_Orgvarchar(38)noBusiness RolePKFKUID

Relations

FKFromTo
QER_RFRL1437HelperPersonOrg.UID_PersonPerson.UID_Person
QER_RFRL1715HelperPersonOrg.UID_OrgBaseTree.UID_Org

Triggers

QER_TDHelperPersonOrg SQL_TRIGGER

QER_TIHelperPersonOrg 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.GEN_FTEA0AFEF484D24111A0AD05D7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA19278B9A1A963F887B7D68SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA2BA18D91752F1D5C38D151SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA3506D39B51979D4C46E482SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA3BA487D25E0B51EEA031BASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA45A311C91FBA41355532B8SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA59458D9947154584635039SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA5EA3EF0E9FC80233ADD9EESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA6A68701D09FEC5A029AF12SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA8AEAF9E5D09259EDA878DFSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEAAB5A6D24DC44B6BA4A9D69SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEAB8A4C56A3BCAE4E1CC8CB9SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEAD8BB649D76CAA69B89A966SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEADB5747C14BDA36B438D93ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEADDFFE62F7C862D8EFE9F7ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEAE3032C0FADEE6588E30677SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEAE6BFA2A0EEBD07BFB948B0SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEAF375C8DA6762C3F41D8CD0SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO2449A21EFB122D2AF3B920SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO25F2BE28B359A147002484SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO2DFFC3597F23CBA73DEBA2SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO43DA50DFD7474F509FE625SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO4A7CF4B45C2D7BC9EDAD37SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO4CA65D90167B38E40B176DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO4F410D16844712C63A98BASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO747E5F4E3A4061542A3456SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO79FCA5E06289E312186F5FSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO88C3252E4822EEB5E56129SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEO9D4FD2292EFC748015E780SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEOA7A83C03AC63E92F4E255ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEOC7B20A6BD971728008EA89SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEOCBE1F5EFEA131E8729A6FFSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEOCC97ED88B89CA73E2DA389SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEODFBC578DBC3E90294FC921SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEOE03F4413CB822BD15BB87CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEOFCDDA80E733A80CFE09BC5SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY0122181C230044398280FESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY1651DF0943C389DD296ADESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY32246AB0D1EBEA0EF689F3SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY510EB2AF297B8F844C83DASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY603E46E7D17851CEECD074SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY6A4C3C6E502E007685003BSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY6CF75B30295FEFA8CD3709SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY7705EAA3F767C86779D0BDSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY87AE45C88F8A7904BD9510SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY8E0532B844467344E61179SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY94A1455D19630D9B5E3446SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEY9C5A940806B98C76B45A28SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEYBC1B1E1153DA0887D6F11CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEYCB57F36D8B554BDAEF804BSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEYD1570666C15F0F46905354SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEYDAF6E4727A8EAE717E59D7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEYE3300D332EFDFCD61A0A1FSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEYF4FA37E77329315C33C8D5SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTAccountInheritFromOrg_LSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_FTAccountInheritFromOrg_LSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.QER_FTAccountInheritFromOrg_LSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.QER_FTPersonInheritFromOrg_LSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_FTPersonInheritFromOrg_LSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.QER_FTPersonInheritFromOrg_LSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.QER_FGIPWOVisibleForPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopPersonHasObjFill_bSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZHelperPersonOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMB_ZHelperPersonOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_ZAllForOneRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTEntitlementSourceOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTEntitlementSourceOrgWhoSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPersonHeadCirc_AllSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPersonHeadCirc_BaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOVisibleForPerson_ISQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_FTAttCasesForManagerSQL 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.LDP_TULDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERAssignSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERResourceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERReuseSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERReuseUSSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERAssignSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERResourceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERReuseSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUBaseTreeHasQERReuseUSSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_TIBaseTreeHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_TUBaseTreeHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_TIBaseTreeHasRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_TUBaseTreeHasRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasTSBAccountDefSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB1SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB2SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB3SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasTSBAccountDefSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupB1SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupB2SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUBaseTreeHasUNSGroupB3SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUUNSGroupBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUUNSGroupB1SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUUNSGroupB2SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_TUUNSGroupB3SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_VEditEmployeeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_VEditEmployeeSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.QER_VEditEmployeeSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.QERVEditEmployeeSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSBVGroupMemberSourceSQL expression dependencyOBJECT_OR_COLUMN
Personreferenced by foreign key from tableQER_RFRL1437: HelperPersonOrg.UID_Person -> Person.UID_Person
BaseTreereferenced by foreign key from tableQER_RFRL1715: HelperPersonOrg.UID_Org -> BaseTree.UID_Org
dbo.QER_FTAccountInheritFromOrg_Lsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPersonInheritFromOrg_Lsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FGIPWOVisibleForPersonsource text referenceSQL_SCALAR_FUNCTION
dbo.QER_PITShopPersonHasObjFill_bsource text referencehas TRY/CATCH error handling
dbo.QER_ZHelperPersonOrgsource text referencehas TRY/CATCH error handling
dbo.QER_ZPersonHasObjectsource text referencehas TRY/CATCH error handling
dbo.RMB_ZHelperPersonOrgsource text referencehas TRY/CATCH error handling
dbo.RPS_ZAllForOneRPSReportsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_FTEntitlementSourceOrgsource text referenceSQL_TABLE_VALUED_FUNCTION
dbo.QER_FTEntitlementSourceOrgWhosource text referenceSQL_TABLE_VALUED_FUNCTION
dbo.QER_FTPersonHeadCirc_Allsource text referenceSQL_TABLE_VALUED_FUNCTION
dbo.QER_FTPersonHeadCirc_BaseTreesource text referenceSQL_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOVisibleForPerson_Isource text referenceuses session context values
dbo.TSB_FTAttCasesForManagersource text referenceuses session context values
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.LDP_TULDAPGroupsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TIBaseTreeHasQERAssignsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TIBaseTreeHasQERResourcesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TIBaseTreeHasQERReusesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TIBaseTreeHasQERReuseUSsource 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.QER_TUBaseTreeHasQERAssignsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TUBaseTreeHasQERResourcesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TUBaseTreeHasQERReusesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_TUBaseTreeHasQERReuseUSsource 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
dbo.RPS_TIBaseTreeHasRPSReportsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.RPS_TUBaseTreeHasRPSReportsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TIBaseTreeHasTSBAccountDefsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TIBaseTreeHasUNSGroupBsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TIBaseTreeHasUNSGroupB1source text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TIBaseTreeHasUNSGroupB2source text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TIBaseTreeHasUNSGroupB3source text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUBaseTreeHasTSBAccountDefsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUBaseTreeHasUNSGroupBsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUBaseTreeHasUNSGroupB1source text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUBaseTreeHasUNSGroupB2source text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUBaseTreeHasUNSGroupB3source text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUUNSGroupBsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUUNSGroupB1source text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUUNSGroupB2source text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.TSB_TUUNSGroupB3source text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling