dbo.UNSGroupB1
System entitlements 1
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSGroupB1 | varchar(38) | no | System entitlement 1 | 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_RFRL5110 | UNSGroupB1Collection.UID_UNSGroupB1Child | UNSGroupB1.UID_UNSGroupB1 |
| TSB_RFRL5440 | UNSGroupB1.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL5444 | UNSGroupB1Exclusion.UID_UNSGroupB1Lower | UNSGroupB1.UID_UNSGroupB1 |
| TSB_RFRL5465 | UNSGroupB1.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL5501 | UNSGroupB1.UID_UNSContainerB | UNSContainerB.UID_UNSContainerB |
| TSB_RFRL5585 | UNSGroupB1InUNSGroupB1.UID_UNSGroupB1Parent | UNSGroupB1.UID_UNSGroupB1 |
Triggers
GEN_T24631282E288DAB452698EE61 SQL_TRIGGER
GEN_T39632B932736FCCF16191D67F SQL_TRIGGER
GEN_T51D28EEDCAA57C5E22819CE78 SQL_TRIGGER
TSB_TATTUUNSGroupB1 SQL_TRIGGER
TSB_TDUNSGroupB1 SQL_TRIGGER
TSB_TIUNSGroupB1 SQL_TRIGGER
TSB_TUUNSGroupB1 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_FTEA0562242E3BC4136BCA1CE9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA0D9141B00DE6C703F65CD1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA45A311C91FBA41355532B8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6A68701D09FEC5A029AF12 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6FF83AAA6C0196BAABFBA1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA7753660E27005EE52B37B7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA7D76E1B7A58049F385BDD1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA84471BDD3A80C274B3CB95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB9E86C9E57B65A3C36124A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAC92179345E716BD560B0CF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE70F7C7DC007D2525BE642 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO21EE4A2BA66BA2714303E5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO32A5C78A846D6205D96590 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO35B790B0C5AAABB0EBD859 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4A7CF4B45C2D7BC9EDAD37 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4CA65D90167B38E40B176D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO5D16B76C939BD16B7F25EC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO65CF709953376CFE851623 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6FA34C069DA6C1F7D48FBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOA9BD5D5E2DDEA5B88787B8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOACC993FDAF5792E1B59AE0 | 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_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY7705EAA3F767C86779D0BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8E0532B844467344E61179 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY93C83068790E482B9BC48A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9AA9267513A52C463DBAB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9C537565E770C30AA1EC81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA17794B9D95EE8DD144E94 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYB5B79D3FB317B463216F71 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYCECC6DB926BCF9648F456B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYDE839AC5FDDF3A157A16AF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYE5C106C07A55319D2D1F4C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF634ACF893A3AC13026A99 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSGroupB1 · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.GEN_P1D67E3E269674A9ABEB90BA37 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P79C56D662E8621728F4523495 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PF1F9147D1FE627AD8AD522454 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB1InUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSGroupB1InUNSGroupB1 | 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_T1075D6B23B28496CE27F34496 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T11E78B827B0A5C827589B3C07 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1246F3949224E6D03A5E6F02A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13473E6C527937D39622EA187 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1B249D65C4DA3A238D98C1FA3 | 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_T1F6F8EC84E20D56CBFF44EBDA | 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_T2215F67402ADC217C92D0E383 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T249DB1D9F525BD29A1CF781A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T284B0E1902B4A5FB88555C50A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2A0A0F253B854763BB4A89422 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2ACEE1A863AC754E97DEA0F8A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2D604E33970089A6E1DBA4CF0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2DFBE30DE5E9F5B7F9E966942 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T42A309EAD25CBB947E4BD3DE7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4ABB875238EBAD4EE55140A9C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T502565353D4716D18CD190BF8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T51D28EEDCAA57C5E22819CE78 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T56BE8C80F287C3D1B0C9B9452 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T586345931225D1263A0DC4DB5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T58EC94E015F7B2A8E8A8B5323 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6468DAEBB9D6716E026B9C95F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TDTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB1 | 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_TIUNSAccountBHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB1InUNSGroupB1 | 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_TUUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB1 | 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_UNSGroupB1 · 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.TSBVUNSGroupB1Revision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| UNSGroupB1Collection | foreign key references table | TSB_RFRL5110: UNSGroupB1Collection.UID_UNSGroupB1Child -> UNSGroupB1.UID_UNSGroupB1 |
| AccProduct | referenced by foreign key from table | TSB_RFRL5440: UNSGroupB1.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB1Exclusion | foreign key references table | TSB_RFRL5444: UNSGroupB1Exclusion.UID_UNSGroupB1Lower -> UNSGroupB1.UID_UNSGroupB1 |
| UNSRootB | referenced by foreign key from table | TSB_RFRL5465: UNSGroupB1.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSContainerB | referenced by foreign key from table | TSB_RFRL5501: UNSGroupB1.UID_UNSContainerB -> UNSContainerB.UID_UNSContainerB |
| UNSGroupB1InUNSGroupB1 | foreign key references table | TSB_RFRL5585: UNSGroupB1InUNSGroupB1.UID_UNSGroupB1Parent -> UNSGroupB1.UID_UNSGroupB1 |
| dbo.TSB_FGIDPRNameSpaceFromRoot | source text reference | SQL_SCALAR_FUNCTION |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupB1InUNSGroupB1 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB1 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSGroupB1InUNSGroupB1 | 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_TIBaseTreeHasUNSGroupB1 | 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_TIUNSAccountBHasUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupB1InUNSGroupB1 | 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_TUUNSAccountBInUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB1 | 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 |