dbo.UNSGroupB3
System entitlements 3
TableType TUsage USERDATARows 0SizeMB 0
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSGroupB3 | varchar(38) | no | System entitlement 3 | 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_RFRL7110 | UNSGroupB3Collection.UID_UNSGroupB3Child | UNSGroupB3.UID_UNSGroupB3 |
| TSB_RFRL7440 | UNSGroupB3.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL7444 | UNSGroupB3Exclusion.UID_UNSGroupB3Lower | UNSGroupB3.UID_UNSGroupB3 |
| TSB_RFRL7465 | UNSGroupB3.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL7501 | UNSGroupB3.UID_UNSContainerB | UNSContainerB.UID_UNSContainerB |
| TSB_RFRL7585 | UNSGroupB3InUNSGroupB3.UID_UNSGroupB3Parent | UNSGroupB3.UID_UNSGroupB3 |
Triggers
GEN_T27FDE06F12A320CD765BC78C4 SQL_TRIGGER
GEN_T3EED7E219EC6F23D4F21DED1D SQL_TRIGGER
GEN_T5EFD8D431016E20B0F16AC534 SQL_TRIGGER
TSB_TATTUUNSGroupB3 SQL_TRIGGER
TSB_TDUNSGroupB3 SQL_TRIGGER
TSB_TIUNSGroupB3 SQL_TRIGGER
TSB_TUUNSGroupB3 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_FTEA0645E8C2F9B5D85DEBA328 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA310165B25E4563AF303EE0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA4EA5D15C763E3C3011039A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6B0C73DBB737AB994BFB9E | 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_FTEACE3DC70A9B100D72DAA13F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD8BB649D76CAA69B89A966 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE471A89D763769CBFA1C40 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE6BFA2A0EEBD07BFB948B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE955BD06F7AE35BED30834 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO3B9C6D580006D4DD813B7E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6FA34C069DA6C1F7D48FBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO747E5F4E3A4061542A3456 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO90AA6311D0390A1E4D5F33 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO9226A461259BE698109D7C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA7A83C03AC63E92F4E255A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB3B2560AB2854AC430D072 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOBF13787D687DDE946FAC9E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOCCEC6FAAAADDAE4E64A778 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD0423232E940C76F51DB95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEODB55B8F6DCCF7F77DBFE9B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY1259C3D6106F88D3FE81C1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY53D8D792B6515142C31909 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY6A01F15B07CC9CBEDA919D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9C537565E770C30AA1EC81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9D970CBAA569CA4712CE1A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYAD6AB0B9B040433F113D36 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYB7D9F2A88D2BEE2704FF81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYCECC6DB926BCF9648F456B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYD9E45B5BA3CF3011E79360 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYDAF6E4727A8EAE717E59D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF4FA37E77329315C33C8D5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSGroupB3 · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.GEN_P3D1014B8F2EC2E7D43FE7A93B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P4057136D381E001C6D193807D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PEB7B38B3919D8817864BF479A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB3InUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSGroupB3InUNSGroupB3 | 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_T100DA55DDFAFC0BDE68778218 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1196E31B36D371B2817341FAA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13370D8A372ADE9E9F652E4A1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T173E3C749DD499AECF2367DE7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T18A3347F4BE417B5CD0632915 | 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_T1EFB876323763C5834862CD86 | 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_T23E96A163A64E806CA7B7A7A3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T249DB1D9F525BD29A1CF781A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2518C8D5D2656ECAF25509E31 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2830D5FD86BC8D861772916A9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T288757ABC1B2DC91763A6428A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2BB4BBE0C1D83E4F3D88C58F3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2D19B3664A87F52617B6B35AE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4D98B18BC4726258DD729B3C5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4E8713A0FF742E80460D61515 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T577565B77F38638D05A8B603C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T58B922964748DF1AC72372DE9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5C78C00811232C8D437AF8288 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5DEC3B8B413163D8D6070A959 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5EFD8D431016E20B0F16AC534 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6A7B532502BAB791B67341556 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TDTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB3 | 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_TIUNSAccountBHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB3InUNSGroupB3 | 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_TUUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB3 | 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_UNSGroupB3 · 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.TSBVUNSGroupB3Revision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| UNSGroupB3Collection | foreign key references table | TSB_RFRL7110: UNSGroupB3Collection.UID_UNSGroupB3Child -> UNSGroupB3.UID_UNSGroupB3 |
| AccProduct | referenced by foreign key from table | TSB_RFRL7440: UNSGroupB3.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB3Exclusion | foreign key references table | TSB_RFRL7444: UNSGroupB3Exclusion.UID_UNSGroupB3Lower -> UNSGroupB3.UID_UNSGroupB3 |
| UNSRootB | referenced by foreign key from table | TSB_RFRL7465: UNSGroupB3.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSContainerB | referenced by foreign key from table | TSB_RFRL7501: UNSGroupB3.UID_UNSContainerB -> UNSContainerB.UID_UNSContainerB |
| UNSGroupB3InUNSGroupB3 | foreign key references table | TSB_RFRL7585: UNSGroupB3InUNSGroupB3.UID_UNSGroupB3Parent -> UNSGroupB3.UID_UNSGroupB3 |
| dbo.TSB_FGIDPRNameSpaceFromRoot | source text reference | SQL_SCALAR_FUNCTION |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupB3InUNSGroupB3 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB3 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSGroupB3InUNSGroupB3 | 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_TIBaseTreeHasUNSGroupB3 | 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_TIUNSAccountBHasUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupB3InUNSGroupB3 | 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_TUUNSAccountBInUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB3 | 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 |