dbo.HelperHeadOrg
Auxiliary table for identifying the managers of roles or organizations.
TableType TUsage MATERIALRows 62SizeMB 0.056
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_PersonHead | varchar(38) | no | Manager | PKFKUID |
UID_Org | varchar(38) | no | Business Role | 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_TIHelperHeadOrg SQL_TRIGGER
ATT_TRMBDHelperHeadOrg SQL_TRIGGER
ATT_TRMBIHelperHeadOrg SQL_TRIGGER
ATT_TUHelperHeadOrg SQL_TRIGGER
GEN_T16EABE1586C4372D716340617 SQL_TRIGGER
GEN_T23BD48053845CC95ACF546C7D SQL_TRIGGER
GEN_T537976FAD4FF9DE4E734873E5 SQL_TRIGGER
GEN_T6124437B6E9AB9CE71171409F SQL_TRIGGER
GEN_TDDYGD520D148107936437C57C SQL_TRIGGER
GEN_TIDYG6F197879330E07BBBAC96 SQL_TRIGGER
QER_TIHelperHeadOrg SQL_TRIGGER
QER_TUHelperHeadOrg 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_FT0A86BA2499A6DE11951F0C41 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT1A6AF7C2681843A591AB6B28 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT1BBCDAE6AFEBC59E56E9BD2E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT1FE3E62781488C105F7E7FFB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT22F22DC96335F776BF4D1B6A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT24E3821ACC80AA68E079FB27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2C474E889CA9C8FCEA4EC191 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT338A25E7F823BCDE7C6FE46D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT3B42B798F64848FFFBEE869B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT46BD218E9600B0D353BDA2A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT534BA0D90D4491F2FB85A584 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT6730753DD2A79ACB5F839AB8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT689C0C5D42573B4E1448C6FB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT73EC08F188A7BB5AE3BC6211 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT84FD83F2C0E3EB0DB73704A9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT85A7A15236CA027EB51A0677 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT8E628D60FC464C8B7A3E7163 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT91F94103C9538A0B51B3DBE2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC016772C36040219536E1C4A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC089FEB4D7097AB81097AD23 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC97C4E282A021430296681B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE10BCE32554C404BF46E35BC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE2A4A7C4E6010AD7B8A615BF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE61C28094906F2921112552C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE79CD1ADA478369777AE730F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAAFB9EC93A3D280D5FE7BE4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO51124460D781C27F2EB0B7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYCACD53376979AEB4951686 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTDelegationPossibleTo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren | SQL expression dependency | dbo · XOrigin · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgChildren_RT | SQL expression dependency | dbo · XOrigin · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents | SQL expression dependency | dbo · XOrigin · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · UID_PersonHead · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · UID_Org · OBJECT_OR_COLUMN |
| dbo.QER_FTHelperHeadOrgParents_RT | SQL expression dependency | dbo · XOrigin · OBJECT_OR_COLUMN |
| dbo.QER_FGIITShopNewPersonOrdered | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOVisibleForPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P1BF268D1A2D85F748D1C8D3DC | 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_ZHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopDecisionMakerFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_FTAttCasesForManager | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0C630EFF36AD9E49E0FFF2FE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0F7FE5A5A25A6DE9C309A9D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT498C62BF1B447398CBE7CF50 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPersonHeadCirc_All | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPersonHeadCirc_BaseTree | 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_TUHelperHeadOrg | 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_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T537976FAD4FF9DE4E734873E5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DelegableItem | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0245629225255DE01055A455 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA32FB233979F8D6CAB2B0286C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA7286F0871C63EB6952BFF935 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA88432C004AA69A19EC1FEEBD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE9AEB21BA19D879EB1C23EF3 | 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_Org · 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_FTHelperHeadOrgChildren | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTHelperHeadOrgChildren_RT | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTHelperHeadOrgParents | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTHelperHeadOrgParents_RT | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIITShopNewPersonOrdered | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIPWOVisibleForPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_ZHelperHeadOrg | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZITShopDecisionMakerFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_FTAttCasesForManager | source text reference | uses session context values |
| dbo.QER_FTPersonHeadCirc_All | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPersonHeadCirc_BaseTree | 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_TUHelperHeadOrg | source text reference | 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 |