dbo.QERUniversalSubstitute
Deputies of identities for an entire section. For example, the IT Shop or attestation.
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERUniversalSubstitute | varchar(38) | no | Identity deputization | PKUID |
UID_PersonWantsOrg | varchar(38) | no | Request procedure | FKUID |
UID_PersonSender | varchar(38) | no | Identity | FKUID |
UID_PersonReceiver | varchar(38) | no | Deputy | FKUID |
IsCurrentlyActive | bit(1) | yes | In effect | |
UseForITShop | bit(1) | yes | Deputy for approvals in IT Shop | |
UseForITShopCompliance | bit(1) | yes | Deputy for approvals of rule violations | |
UseForAttestation | bit(1) | yes | Deputy for attestations | |
KeepMeInformed | bit(1) | yes | Information for delegators | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
OrderState | nvarchar(32) | yes | Request status | limited |
UseForHeadPerson | bit(1) | yes | Deputy for identity's manager | |
UseForHeadOrg | bit(1) | yes | Deputy for supervison of organizations or business roles |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1150 | QERUniversalSubstitute.UID_PersonWantsOrg | PersonWantsOrg.UID_PersonWantsOrg |
| QER_RFRL1152 | QERUniversalSubstitute.UID_PersonSender | Person.UID_Person |
Triggers
ATT_TDQERUniversalSubstitute SQL_TRIGGER
ATT_TIQERUniversalSubstitute SQL_TRIGGER
ATT_TUQERUniversalSubstitute SQL_TRIGGER
GEN_T10963300A12D809473E6A1AB6 SQL_TRIGGER
GEN_T2D75C46BA3D9F3CE74FEA7252 SQL_TRIGGER
GEN_T3A6EF756B8D89478899D6DCDB SQL_TRIGGER
QER_TDQERUniversalSubstitute SQL_TRIGGER
QER_TIQERUniversalSubstitute SQL_TRIGGER
QER_TUQERUniversalSubstitute 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.ATT_PAttestationHelperFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopHelperFill_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOVisibleForPerson_I | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T19C3C2FB203CD24A1EB8ECC93 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2D48342F7ABA3EB961827EBDC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T377F10C7782E804450A883790 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERUniversalSubstitute | SQL expression dependency | OBJECT_OR_COLUMN |
| PersonWantsOrg | referenced by foreign key from table | QER_RFRL1150: QERUniversalSubstitute.UID_PersonWantsOrg -> PersonWantsOrg.UID_PersonWantsOrg |
| Person | referenced by foreign key from table | QER_RFRL1152: QERUniversalSubstitute.UID_PersonSender -> Person.UID_Person |
| dbo.ATT_PAttestationHelperFill | 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_PITShopHelperFill_bulk | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZHelperHeadOrg | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZHelperHeadPerson | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTPWOVisibleForPerson_I | source text reference | uses session context values |
| dbo.ATT_TUQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TDBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TDPerson | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTree | source text reference | inserts DBQueue tasks, 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_TUBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPerson | 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 |
| dbo.QER_TUQERUniversalSubstitute | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |