dbo.QERAssign
Assignment resources
TableType TUsage USERDATARows 5SizeMB 0.064
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QERAssign | varchar(38) | no | Assignment resource | PKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
Ident_QERAssign | nvarchar(512) | yes | Assignment resource | |
Description | nvarchar(-1) | yes | Description | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
IsForITShop | bit(1) | yes | IT Shop | |
IsITShopOnly | bit(1) | yes | Only use in IT Shop | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
RiskIndex | float(8) | yes | Risk index | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsKeepAssignment | bit(1) | yes | Keeps requested assignment resource | |
IsAutoAssignToPerson | bit(1) | yes | Automatic assignment to identities | |
IsNoInheriteToSecurityIncident | bit(1) | yes | No inheritance on security risk | |
UID_DialogTableAssignTarget | varchar(38) | yes | Table | FKUID |
ObjectKeyAssignTarget | varchar(138) | yes | Object | |
UID_QERAssignPredecessor | varchar(38) | yes | Service item | FKUID |
UID_QERResourceType | varchar(38) | yes | Resource type | FKUID |
IsMAllAssign | bit(1) | yes | Assignment to system role |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL2520 | PersonHasQERAssign.UID_QERAssign | QERAssign.UID_QERAssign |
| QER_RFRL2525 | QERAssign.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2556 | QERAssign.UID_DialogTableAssignTarget | DialogTable.UID_DialogTable |
| QER_RFRL2563 | QERAssign.UID_QERResourceType | QERResourceType.UID_QERResourceType |
Triggers
ATT_TUQERAssign SQL_TRIGGER
GEN_T15BE8F11CCAEC49841830F4E8 SQL_TRIGGER
GEN_T216A0B52BFBA69969CC5137E4 SQL_TRIGGER
GEN_T3C30B8F2DD0A6BE8152D41A12 SQL_TRIGGER
GEN_T520DB3A9BDA3D9A3CB811BD05 SQL_TRIGGER
QER_TUQERAssign 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_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA226D96A5F34CEF70AB82F9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA4D3DEDD0A0680B32BDC19C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA5ACA6175D73BE289D55766 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA971064C4D84C7F5C831A38 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAA6BEB2C92454EB95ADBFCE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAC30B841562FBB6AD83DD64 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEACE29B499D46B63085B019F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADDFFE62F7C862D8EFE9F7E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO124603C4ECA4923BA02CD1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO1AD7DE86A579FA2409914E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO2449A21EFB122D2AF3B920 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO39066D8F7C9AD7CEAEF3FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4FAD48B2C16719AA6AA10A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO7850C0E557233D1B42CCBF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9EBFD3FDDDC9D840459B1C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOBEBB8A4A554D3F83C9F986 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY16F46EAC98E87C927E087B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY6A4C3C6E502E007685003B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY7C0A8CD265F459125E08F4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8BF540F72028620D497ABE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY959435F6DBCCA9EB3EB28D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYB84C3B21509F1AA07885F7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD5D72E6FA335696FA50D11 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYED8E405E523D8D627BD65F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_000 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_001 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_010 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_011 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_100 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_101 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_110 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_111 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIPwoValidDateRangesExist | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderMove_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopPersonHasObjFill_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckValid | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckWaiting | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZOrgHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZPersonHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4EA9514908EF8B11861005B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTQERAssignPredecessor | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTQERAssignPredecessor | SQL expression dependency | dbo · UID_QERAssign · OBJECT_OR_COLUMN |
| dbo.QER_FTQERAssignPredecessor | SQL expression dependency | dbo · UID_QERAssignPredecessor · OBJECT_OR_COLUMN |
| dbo.GEN_T15BE8F11CCAEC49841830F4E8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1954312266BED2B5FBC557445 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T216A0B52BFBA69969CC5137E4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T231D6B739C878E506CDE93AAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C30B8F2DD0A6BE8152D41A12 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T520DB3A9BDA3D9A3CB811BD05 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CEDE433ADD82BAED611B33E6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPersonHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOProductNodes | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERAccProductUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| PersonHasQERAssign | foreign key references table | QER_RFRL2520: PersonHasQERAssign.UID_QERAssign -> QERAssign.UID_QERAssign |
| AccProduct | referenced by foreign key from table | QER_RFRL2525: QERAssign.UID_AccProduct -> AccProduct.UID_AccProduct |
| DialogTable | referenced by foreign key from table | QER_RFRL2556: QERAssign.UID_DialogTableAssignTarget -> DialogTable.UID_DialogTable |
| QERResourceType | referenced by foreign key from table | QER_RFRL2563: QERAssign.UID_QERResourceType -> QERResourceType.UID_QERResourceType |
| dbo.QER_FTPWOOrderPerson_000 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_001 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_010 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_011 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_100 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_101 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_110 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_111 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIPwoValidDateRangesExist | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_PITShopOrderMove_bulk | 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 |
| dbo.QER_PITShopPersonHasObjFill_b | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZITShopCheckValid | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZITShopCheckWaiting | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.QER_ZOrgHasQERAssign | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZPersonHasQERAssign | source text reference | has TRY/CATCH error handling |
| dbo.QER_FTQERAssignPredecessor | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TDBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTreeHasQERAssign | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPersonHasQERAssign | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERAssign | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-itshophelperasync.cs | decompiled C# reference | classes ITShopHelperAsync, _003C_003Ec__DisplayClass14_0, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods _003C_CheckIsGroupAccount_003Eb__0, _003CHandlePersonHasAccountDef_003Eb__0, _003CGetValidAccountDef_003Eb__0, MoveNext, SetStateMachine, CreateAccountITShopOrder; references AccProduct, BasetreeAssign, BaseTreeHasObject, Delegation, DialogTable, ITShopOrg; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| 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 |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |