dbo.HelperHeadPerson
Auxiliary table for identifying the managers of identities.
TableType TUsage MATERIALRows 141SizeMB 0.12
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PersonHead | varchar(38) | no | Manager | PKFKUID |
UID_Person | varchar(38) | no | Identity | PKFKUID |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
XOrigin | int(4) | yes | Origin | bitmask |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
ATT_TIHelperHeadPerson SQL_TRIGGER
ATT_TUHelperHeadPerson SQL_TRIGGER
GEN_T160BE2096DA0E536BD115587E SQL_TRIGGER
GEN_T22EA34771021358523BD3EC3E SQL_TRIGGER
GEN_T59D1C8DC48C28DECAC9869622 SQL_TRIGGER
GEN_T689E14D946EF40697E75A939E SQL_TRIGGER
GEN_TDDYG7C9210353B2AE7800ED15 SQL_TRIGGER
GEN_TIDYGA609384CCBF9BA169C392 SQL_TRIGGER
QER_TIHelperHeadPerson SQL_TRIGGER
QER_TUHelperHeadPerson 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.GEN_FT3354606E3BF1E02E5A5A0D6D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT3AD31EFDD488FB8203F7A95A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT5A6F9D07A29423F9B201F14A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE88D7AC2E5BCB2C66CBA5FF1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTFF06E267A3719F2448E723DE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTDelegationPossibleTo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIITShopNewPersonOrdered | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPersonHeadCirc | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOVisibleForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P9B87544E1325D45A63B7E4C95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PA104261FA54379C6160FAE8F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD7750F63D2FE88D966B93F426 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopDecisionMakerFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPersonHeadCirc_All | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPersonHeadCirc_Person_i | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOVisibleForPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FTAttCasesForManager | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T14F9BAB630FEC5E457C155D22 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T282F7C436F7EDAC30B5878691 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T59D1C8DC48C28DECAC9869622 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DelegableItem | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · UID_Person · OBJECT_OR_COLUMN |
| dbo.QER_VEditEmployee | SQL expression dependency | dbo · XOrigin · OBJECT_OR_COLUMN |
| dbo.QERVEditEmployee | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTDelegationPossibleTo | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIITShopNewPersonOrdered | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIPersonHeadCirc | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIPWOVisibleForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_ZHelperHeadPerson | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZITShopDecisionMakerFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_FTPersonHeadCirc_All | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPersonHeadCirc_Person_i | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOVisibleForPerson_I | source text reference | uses session context values |
| dbo.TSB_FTAttCasesForManager | source text reference | uses session context values |
| dbo.ATT_TUHelperHeadPerson | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPerson | source text reference | creates 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.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 |
| 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 |