dbo.PersonInBaseTree

Identities: memberships in roles and organizations

TableType BUsage USERDATARows 777SizeMB 0.752

Table relation graph

Loading table relation graph…

Columns

NameTypeNullableOIM caption/commentaryFlags
UID_Personvarchar(38)noIdentityPKFKUID
UID_Orgvarchar(38)noRole/organizationPKFKUID
XDateInserteddatetime(8)yesCreated on
XDateUpdateddatetime(8)yesModified on
XUserInsertednvarchar(128)yesCreated by
XUserUpdatednvarchar(128)yesModified by
XTouchednchar(2)yesProcessing status
IsExceptionGrantedbit(1)yesException is approved
XObjectKeyvarchar(138)noObject key
RiskIndexCalculatedfloat(8)yesRisk index (calculated)
XMarkedForDeletionint(4)yesMarked for deletionbitmask
XOriginint(4)yesOriginbitmask
RiskIndexReducedfloat(8)yesRisk index (reduced)
UID_QERJustificationvarchar(38)yesStandard reasonFKUID
UID_PersonDecisionMadevarchar(38)yesApproverFKUID
DecisionReasonnvarchar(2048)yesReason
IsDecisionMadebit(1)yesChecked
DecisionDatedatetime(8)yesApproval date
ExceptionValidUntildatetime(8)yesValid until

Relations

FKFromTo
CPL_RFRL2553PersonInBaseTree.UID_PersonDecisionMadePerson.UID_Person
CPL_RFRL2556PersonInBaseTree.UID_QERJustificationQERJustification.UID_QERJustification

Triggers

CPL_TIPersonInBaseTree SQL_TRIGGER

CPL_TUPersonInBaseTree SQL_TRIGGER

GEN_T1247934F7A26C9FC0156558C9 SQL_TRIGGER

GEN_T21E730FC2AEF995FFE9A93F4C SQL_TRIGGER

GEN_T5F1999AF021085071EE9E48B2 SQL_TRIGGER

GEN_T6F4F6B162E3634FE2381E1BF1 SQL_TRIGGER

POL_TIATTPersonInBaseTree SQL_TRIGGER

POL_TUATTPersonInBaseTree SQL_TRIGGER

QER_TIPersonInBaseTree SQL_TRIGGER

QER_TUPersonInBaseTree 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.ATT_FTOrgAttHighestSQL expression dependencyOBJECT_OR_COLUMN
dbo.ATT_FTOrgRulerHighestSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_FTCCSPersonCheckWithOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT0044E9DC660D8FECCA25B039SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT1A6AF7C2681843A591AB6B28SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT2C474E889CA9C8FCEA4EC191SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT2D1FA228B84AFBBC14771E3ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT338A25E7F823BCDE7C6FE46DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT3B45AEE64517F17D7C3A20C5SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT3EF28497CED27004B689D6F8SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT40E617EA4EDFD9F440AB5C68SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT4F8BB10C39B7D5A024EDA2F1SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT71486EB9289E8C428D0BC8BDSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT85A7A15236CA027EB51A0677SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT927E5D5D3F0555DEEE967B36SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT9B840E61FC75310C8C9A83D7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTB46D2735BB207B0A5BEF3E8ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTB7B5BDD7AB99634CC7E45559SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTBB042D9B3231E5643CB9EF48SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTC016772C36040219536E1C4ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTC089FEB4D7097AB81097AD23SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTE7DB900500A82E082B94D0A7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTE88D7AC2E5BCB2C66CBA5FF1SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA0AFEF484D24111A0AD05D7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0SQL 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_FTED9A51712E94DE99846FA141SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTEFFAA41A2AB92F8FB75E91BDSQL 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_FTEOD74410BBDA5C1BE51102F6SQL 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_FTEY06423E1553D20332D88F9ASQL 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_FTDelegationPossibleToSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTITShopNewProductNodeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTOrgAttHighestSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTOrgRulerHighestSQL expression dependencyOBJECT_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_FTPWOOrderPerson_000SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_001SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_010SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_011SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_100SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_101SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_110SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTPWOOrderPerson_111SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FGIAdminUnitForPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FGIITShopNewPersonOrderedSQL expression dependencyOBJECT_OR_COLUMN
dbo.ATT_PAttestationHelperFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_ZITShopMakeDecisionOCSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_ZITShopMakeDecisionOHSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P1D67E3E269674A9ABEB90BA37SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P4057136D381E001C6D193807DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P511ED250CC29BC4790569AD05SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P52191672D9A949F56CEF49189SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P79C56D662E8621728F4523495SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P886EBDC846EA30F027AA1D382SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_P9B87544E1325D45A63B7E4C95SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA104261FA54379C6160FAE8F6SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA11AF8D16C61275A2DCFAED6ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA32EFCA6201B15CB29D954994SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA6BF9FD71303E4D8F82AD2566SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA72A423016BA139FFC3D8EDFFSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA98D6CE53656FFB7523357E71SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PACB9B89D5F903FDF8F2FAD40DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PAD1085733B383217D4E3F0797SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PAD601362D0C4E22FD4721754BSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PAE14BB3C2EDA7D127BCA29F96SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PB2F935A721940C6E32DB7B15CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PB940AF6AF37DA86891585D609SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD0C461BCE9B1499A948C6DE89SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD75EFC2994CF76773E86FDA0ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD7750F63D2FE88D966B93F426SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD85D31B610579F7BE495D13A3SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD88D54946ECC34815B5EF8AA7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDA305E8EEC3AE04AAA39FD671SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDB723629AD0B408FABAA3CD5ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDB81C19C7C55B5C62A0191559SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDBB056A1F7CFF0CE82AAA3734SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDBDCABA4BA9EB91B037DD3763SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDEC582A34382551F1DDFD9799SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PE480ACF02FD9C9941892572A7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PEB7B38B3919D8817864BF479ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PF213242606AF08FBBEC556492SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PFFF6475ED5AB3E00FA2D77305SQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDynamicUserForPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShop_ShopMoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopBoardPrepareDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopHelperFill_bulkSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopOrderMove_bulkSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopPersonHasObjFill_bSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_RAllForPersonInBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZAllForPersonInBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZHelperHeadOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopCheckValidSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopDecisionMakerFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopMemberDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_ZAllForOneRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_FTCCSPWOCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT08A14AE8F9D981AD09F553B0SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT0C630EFF36AD9E49E0FFF2FESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT0F7FE5A5A25A6DE9C309A9D7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT206288222D1F87EA0484AA8ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT43995B4CF20EE84DFB6E7371SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT6584585E7E66B87B5B962382SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT842C03601E482D5270A228C9SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FT9C4D6102BCF4ED8AC1D655D7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTA4721EFEFFE03144F484EE09SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTAEBCA0961E006D5B8C67FB78SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_FTD77937B9B2F8F10E78FB7DD3SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTEntitlementSourceOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTEntitlementSourceOrgWhoSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTOrgAttestatorHighestSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_FTOrgHighestRulerContainerSQL 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.ATT_TUAccProductSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_TDComplianceRuleSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_TUATTComplianceRuleSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_TUComplianceRuleSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_TUPersonInBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T1306636629A2B4F89DCD834E4SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T14F9BAB630FEC5E457C155D22SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T207D5AECD71FD130412DD7D83SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T21E730FC2AEF995FFE9A93F4CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T282F7C436F7EDAC30B5878691SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T380DEA238A283A0D5F954A670SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5F1999AF021085071EE9E48B2SQL 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.POL_TUATTPersonInBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TDBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIBaseTreeExcludesBaseTreeSQL 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_TIPersonInBaseTreeSQL 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.QER_TUOrgRootSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUOrgRootAssignSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUOrgTypeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUPersonInBaseTreeSQL 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.ADS_VAERoleADSContainerSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_VCCSPersonCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_VDecisionPersonSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.CPL_VDecisionPersonSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.CPL_VDecisionPersonSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.CPL_VDecisionPersonSQL expression dependencydbo · XObjectKey · OBJECT_OR_COLUMN
dbo.CPL_VDecisionPersonSQL expression dependencydbo · XOrigin · OBJECT_OR_COLUMN
dbo.CPL_VDecisionPersonSQL expression dependencydbo · IsDecisionMade · OBJECT_OR_COLUMN
dbo.DelegableItemSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_VA39182F18C1CD001E7EA6166FSQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_VAERoleLDAPContainerSQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInAERoleSQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInDepartmentSQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInITShopOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInLocalitySQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInNonComplianceSQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.PersonInProfitCenterSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBMVSystemOverviewSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_VITShopOrderForEmployeeSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_VITShopOrderForEmployeeSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.QER_VITShopOrderForEmployeeSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.QER_VITShopOrderForEmployeeSQL expression dependencydbo · XOrigin · OBJECT_OR_COLUMN
dbo.QER_VPersonInOrgAndPHOSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_VPWOBoardUserRuleHeadSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_VPWOOrderPersonBaseNoMultiSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_VPWOOrderPersonBaseNoMultiSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.QER_VPWOOrderPersonBaseNoMultiSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.QER_VPWOOrderPersonBaseNoMultiSQL expression dependencydbo · XOrigin · OBJECT_OR_COLUMN
dbo.QER_VPWOShopMemberSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QER_VPWOShopMemberSQL expression dependencydbo · UID_Person · OBJECT_OR_COLUMN
dbo.QER_VPWOShopMemberSQL expression dependencydbo · UID_Org · OBJECT_OR_COLUMN
dbo.QER_VPWOShopMemberSQL expression dependencydbo · XOrigin · OBJECT_OR_COLUMN
dbo.QERVPersonAndAERolesSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_VAERoleUnsContainerSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_VAERoleUnsContainerBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSBVGroupMemberSourceSQL expression dependencyOBJECT_OR_COLUMN
Personreferenced by foreign key from tableCPL_RFRL2553: PersonInBaseTree.UID_PersonDecisionMade -> Person.UID_Person
QERJustificationreferenced by foreign key from tableCPL_RFRL2556: PersonInBaseTree.UID_QERJustification -> QERJustification.UID_QERJustification
dbo.ATT_FTOrgAttHighestsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.ATT_FTOrgRulerHighestsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.CPL_FTCCSPersonCheckWithOrgsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTAccountInheritFromOrg_Lsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTDelegationPossibleTosource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTITShopNewProductNodesource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTOrgAttHighestsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTOrgRulerHighestsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPersonInheritFromOrg_Lsource text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_000source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_001source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_010source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_011source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_100source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_101source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_110source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FTPWOOrderPerson_111source text referenceSQL_INLINE_TABLE_VALUED_FUNCTION
dbo.QER_FGIAdminUnitForPersonsource text referenceSQL_SCALAR_FUNCTION
dbo.QER_FGIITShopNewPersonOrderedsource text referenceSQL_SCALAR_FUNCTION
dbo.ATT_PAttestationHelperFillsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.CPL_PComplianceCheckMakeProc_hsource text referencehas TRY/CATCH error handling
dbo.CPL_ZITShopMakeDecisionOCsource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling
dbo.CPL_ZITShopMakeDecisionOHsource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDynamicUserForPersonsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_PITShop_ShopMovesource text referencecreates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling
dbo.QER_PITShopBoardPrepareDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_PITShopHelperFill_bulksource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_PITShopOrderMove_bulksource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling
dbo.QER_PITShopPersonHasObjFill_bsource text referencehas TRY/CATCH error handling
dbo.QER_PRulerDetect_OXsource text referencehas TRY/CATCH error handling
dbo.QER_RAllForPersonInBaseTreesource text referencehas TRY/CATCH error handling
dbo.QER_ZAllForPersonInBaseTreesource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, has TRY/CATCH error handling
dbo.QER_ZHelperHeadOrgsource text referencehas TRY/CATCH error handling
dbo.QER_ZITShopCheckValidsource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling
dbo.QER_ZITShopDecisionMakerFillsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_ZITShopMemberDeletesource text referencehas TRY/CATCH error handling