dbo.UNSGroupB
Groups
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSGroupB | varchar(38) | no | Group | PKUID |
UID_UNSContainerB | varchar(38) | yes | Container | 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 | Group type | |
RiskIndex | float(8) | yes | Risk index | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_UNSRootB | varchar(38) | no | Target system | FKUID |
XDateSubItem | datetime(8) | yes | Dependencies modified on | |
HasReadOnlyMemberships | bit(1) | yes | Read only memberships |
Relations
| FK | From | To |
|---|---|---|
| TSB_RFRL1440 | UNSGroupB.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL1444 | UNSGroupBExclusion.UID_UNSGroupBLower | UNSGroupB.UID_UNSGroupB |
| TSB_RFRL1465 | UNSGroupB.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL1501 | UNSGroupB.UID_UNSContainerB | UNSContainerB.UID_UNSContainerB |
| TSB_RFRL1585 | UNSGroupBInUNSGroupB.UID_UNSGroupBParent | UNSGroupB.UID_UNSGroupB |
| TSB_RFRL4110 | UNSGroupBCollection.UID_UNSGroupBChild | UNSGroupB.UID_UNSGroupB |
Triggers
GEN_T2026DF7FB1D795A599832998B SQL_TRIGGER
GEN_T3BABEE34D07AFA1E85F9D5FB1 SQL_TRIGGER
GEN_T5E7DDFA17A216D94DB96445F7 SQL_TRIGGER
TSB_TATTUUNSGroupB SQL_TRIGGER
TSB_TDUNSGroupB SQL_TRIGGER
TSB_TIUNSGroupB SQL_TRIGGER
TSB_TUUNSGroupB 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_FT0044E9DC660D8FECCA25B039 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2D1FA228B84AFBBC14771E3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTB46D2735BB207B0A5BEF3E8A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTBD06BC392C446FFD04D09C27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA59458D9947154584635039 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA611AC9FE209B209D6BA5B6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA643EA6D1A37B3B2AB34742 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA67C57A8217994EA861D49A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6FF83AAA6C0196BAABFBA1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA733D5A2F74AC441DC72FDA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA84A7FC7FA31458F2267433 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB9E86C9E57B65A3C36124A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAC00CD2AABC9A393205CAD7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD301F9FF7A083E43F9504C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEADB5747C14BDA36B438D93E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO2CE4612D8CC0CDCDA47E09 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4E10ADF9DCFEF7C9C58342 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO4F21B63459864B663447DB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO6FA34C069DA6C1F7D48FBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO79FCA5E06289E312186F5F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO837FD4744287294377BA88 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO964FB112702DE4BFCBC649 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB7D443E409F1129BFD9922 | 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_FTEODFBC578DBC3E90294FC921 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOFD1EFA425BAA6B7E15ADE3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY0122181C230044398280FE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY0BAF2057553029E6B0BFCD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY1651DF0943C389DD296ADE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY19AE465A1AEDCAF37D47AC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY73F83A16FCB3159A7F6DF1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8B9BB6E0E5756FA8FC6CBF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY921BCCEECC644676A5E2D4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9C537565E770C30AA1EC81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYACAC5700ABF0D42F65529A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYCECC6DB926BCF9648F456B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYFCC9AEDF028F5733EA1762 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSGroupB · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P511ED250CC29BC4790569AD05 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB940AF6AF37DA86891585D609 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PD994860C104395BD514FD90DD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PMemberOfSplitToGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupBHasUNSItemB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZOrgHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSGroupBHasUNSItemB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSGroupBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT08A14AE8F9D981AD09F553B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4EA9514908EF8B11861005B5 | 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_T102CDF49BEDD007ADFFB1DF46 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T108EF740C6A602FE99C9AFFDC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T11E71644C8593672EDC85E61A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T12EB716723494758918EABF3A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T14C5230D5C8797937CFECF3BD | 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_T1FB9FAF324A738F9433A7F372 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FD8D0CDCDEDD12341C22AD3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T204DF788D20A56142BEFD8D34 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2097E90C97FF08A6EEF5238E8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T228416CFE8BDD3A0020235EC1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2408BFC9FB2338A3CBDF97ABC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T249DB1D9F525BD29A1CF781A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2880B4F4F126CE9FF6DEA98BF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T296DD778001524E66B106AB95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2BDEBD5569215B165D05B32C5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4A8A0610C29C63DF1C8E5E31E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4AEE20180A1714E97C6F9E67C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4E5B2F47BF81CDA96AB4CC2A9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T50FDADCCF5FF5953D3C5CDE3F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T523AC431F41E159AAC3F592B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5353FF58B0B2681FBC37AB5BE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5520BD220624D98637D86D5E3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5DD3539B417B3A1CD581576D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5E7DDFA17A216D94DB96445F7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T637823C4784A2DCBF527F954E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TDTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB | 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_TIUNSAccountBHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupBInUNSGroupB | 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_TUUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB | 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_UNSGroupB · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.TSBAERoleForGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBBaseTreeAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBGroupToTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDirectAssignWrong | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVPersonAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVUNSGroupBRevision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| AccProduct | referenced by foreign key from table | TSB_RFRL1440: UNSGroupB.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupBExclusion | foreign key references table | TSB_RFRL1444: UNSGroupBExclusion.UID_UNSGroupBLower -> UNSGroupB.UID_UNSGroupB |
| UNSRootB | referenced by foreign key from table | TSB_RFRL1465: UNSGroupB.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSContainerB | referenced by foreign key from table | TSB_RFRL1501: UNSGroupB.UID_UNSContainerB -> UNSContainerB.UID_UNSContainerB |
| UNSGroupBInUNSGroupB | foreign key references table | TSB_RFRL1585: UNSGroupBInUNSGroupB.UID_UNSGroupBParent -> UNSGroupB.UID_UNSGroupB |
| UNSGroupBCollection | foreign key references table | TSB_RFRL4110: UNSGroupBCollection.UID_UNSGroupBChild -> UNSGroupB.UID_UNSGroupB |
| dbo.TSB_FGIDPRNameSpaceFromRoot | source text reference | SQL_SCALAR_FUNCTION |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupBHasUNSItemB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupBInUNSGroupB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZOrgHasUNSGroupB | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSGroupBHasUNSItemB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSGroupBInUNSGroupB | 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_TIBaseTreeHasUNSGroupB | 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_TIUNSAccountBHasUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountBInUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupBInUNSGroupB | 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_TUUNSAccountBInUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB | 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 |