dbo.UNSGroupB2
System entitlements 2
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSGroupB2 | varchar(38) | no | System entitlement 2 | PKUID |
UID_UNSContainerB | varchar(38) | yes | Container | FKUID |
UID_UNSRootB | varchar(38) | no | Target system | FKUID |
UID_AccProduct | varchar(38) | yes | Service item | FKUID |
cn | nvarchar(800) | yes | Name | |
DistinguishedName | nvarchar(800) | yes | Distinguished name | |
ObjectGUID | varchar(256) | yes | Object GUID | |
CanonicalName | nvarchar(800) | yes | Canonical name | |
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 | |
IsForITShop | bit(1) | yes | IT Shop | |
IsITShopOnly | bit(1) | yes | Only use in IT Shop | |
MatchPatternForMembership | bigint(8) | yes | Category | |
Description | nvarchar(-1) | yes | Description | |
DisplayName | nvarchar(510) | yes | Display name | |
GroupType | nvarchar(128) | yes | Type of system entitlement | |
RiskIndex | float(8) | yes | Risk index | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
XDateSubItem | datetime(8) | yes | Dependencies modified on | |
HasReadOnlyMemberships | bit(1) | yes | Read only memberships |
Relations
| FK | From | To |
|---|---|---|
| TSB_RFRL6110 | UNSGroupB2Collection.UID_UNSGroupB2Child | UNSGroupB2.UID_UNSGroupB2 |
| TSB_RFRL6440 | UNSGroupB2.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL6444 | UNSGroupB2Exclusion.UID_UNSGroupB2Lower | UNSGroupB2.UID_UNSGroupB2 |
| TSB_RFRL6465 | UNSGroupB2.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL6501 | UNSGroupB2.UID_UNSContainerB | UNSContainerB.UID_UNSContainerB |
| TSB_RFRL6585 | UNSGroupB2InUNSGroupB2.UID_UNSGroupB2Parent | UNSGroupB2.UID_UNSGroupB2 |
Triggers
GEN_T2A2AFD4A5679A4B4D5208D73F SQL_TRIGGER
GEN_T3EEEF1F10626CDAD0BB259B5D SQL_TRIGGER
GEN_T5F57D889AE402D94CED242291 SQL_TRIGGER
TSB_TATTUUNSGroupB2 SQL_TRIGGER
TSB_TDUNSGroupB2 SQL_TRIGGER
TSB_TIUNSGroupB2 SQL_TRIGGER
TSB_TUUNSGroupB2 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_FT2D1FA228B84AFBBC14771E3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTBD06BC392C446FFD04D09C27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA0AFEF484D24111A0AD05D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA2BA18D91752F1D5C38D151 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6FF83AAA6C0196BAABFBA1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB9E86C9E57B65A3C36124A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEABF977C3E8CA5B9E2A0D17C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEACC0A0F161C5139A85978D6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEACFBED7D30C98E347C66961 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD520395E68C42A43B324B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD7000AD9C38ECA30590962 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADE1E3A590507E281619BA6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAF53ED6416AEF3C9155D8DB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO61B64082003B832769B7DF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO63E550B307F1843BBAEA41 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6FA34C069DA6C1F7D48FBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO8B96783B24FC6E0786844D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA2CD631FB056F00F8EB771 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOAD799FB98908DDB42033D6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOCC97ED88B89CA73E2DA389 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD0423232E940C76F51DB95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD48DD3E8DD9E49B431EC66 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOE03F4413CB822BD15BB87C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOEE436F5AE4FD21173A888F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY0BA325EDC97A6511B77954 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY15CB642D7F87E41BF86FE8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY68B364EED5084A7D5D23F3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY87AE45C88F8A7904BD9510 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8C8C8E4B72714983D306FB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9C537565E770C30AA1EC81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA0EB22774E297DA91E86F4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYB5C2BEFDF41A038B6E4E8F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYCB57F36D8B554BDAEF804B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYCECC6DB926BCF9648F456B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF56DD909CB94BEEC756652 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSGroupB2 · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.GEN_P3E0A52C4815EF3D7D5E6F6954 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PDB723629AD0B408FABAA3CD5E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PE480ACF02FD9C9941892572A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT08A14AE8F9D981AD09F553B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT621FC79B97DAA6A151B9A8A2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA3AD537967B99F82C7D2C1DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T11B8F6854B948B659C5B19B26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T124A6666B20E1F9A5E9BE205D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1273DE800B574856FF3A4C97C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T15CE9759A7C86DDF4361A7B0F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D625FC408434BD76E7C6A6C2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EA7BE24A3331D721708CF413 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1F9A6BFEAD9DD4B7EB9137521 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FB8381EF840D6407B442800B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T249DB1D9F525BD29A1CF781A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T26CBA54AF6227252C6BC60459 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T28CEADDC1FE7C3B744422ABD2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T29437D986718603D8A58ACA6C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C3C41865F0BEEE6E7C2926CE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C69E7CB9260533F4818A4FC9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2DA9C74E24FC246A805717CD7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T46B3896E11782F0E183030BA4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4AB196A56BE48DED95B0A787F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T52819732AD9162A7E270A272E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T541F18114947083CAA443F0CC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T54F003558B15BEF055B8642BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T55870560D013ECC8B97535914 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5F57D889AE402D94CED242291 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T60CDFF22743D86A6C45717BDA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TDTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIRMSESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TITSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUDPRNameSpace | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSRootB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERAccProductUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVReportAllData | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · UID_UNSGroupB2 · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.TSBAERoleForGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBBaseTreeAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDirectAssignWrong | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVPersonAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVUNSGroupB2Revision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| UNSGroupB2Collection | foreign key references table | TSB_RFRL6110: UNSGroupB2Collection.UID_UNSGroupB2Child -> UNSGroupB2.UID_UNSGroupB2 |
| AccProduct | referenced by foreign key from table | TSB_RFRL6440: UNSGroupB2.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB2Exclusion | foreign key references table | TSB_RFRL6444: UNSGroupB2Exclusion.UID_UNSGroupB2Lower -> UNSGroupB2.UID_UNSGroupB2 |
| UNSRootB | referenced by foreign key from table | TSB_RFRL6465: UNSGroupB2.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSContainerB | referenced by foreign key from table | TSB_RFRL6501: UNSGroupB2.UID_UNSContainerB -> UNSContainerB.UID_UNSContainerB |
| UNSGroupB2InUNSGroupB2 | foreign key references table | TSB_RFRL6585: UNSGroupB2InUNSGroupB2.UID_UNSGroupB2Parent -> UNSGroupB2.UID_UNSGroupB2 |
| dbo.TSB_FGIDPRNameSpaceFromRoot | source text reference | SQL_SCALAR_FUNCTION |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupB2InUNSGroupB2 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB2 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSGroupB2InUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TDTSBSpecificGroupBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIBaseTreeHasUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIRMSESetHasEntitlement | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TITSBSpecificGroupBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBHasUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupB2InUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUDPRNameSpace | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUTSBSpecificGroupBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBInUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB2 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSRootB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |