dbo.UNSRootB
Custom target systems
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSRootB | varchar(38) | no | Target system | PKUID |
Ident_UNSRoot | nvarchar(128) | no | Target system | |
UID_TSBAccountDef | varchar(38) | yes | Account definition (initial) | FKUID |
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 | |
Description | nvarchar(-1) | yes | Description | |
AlternatePropertyCaptions | nvarchar(-1) | yes | Alternative column names | |
UID_AERoleOwner | varchar(38) | yes | Target system manager | FKUID |
MatchPatternDisplay | nvarchar(-1) | yes | Mapping rule category | |
DisplayName | nvarchar(256) | yes | Display name | |
NamespaceManagedBy | nvarchar(32) | yes | Synchronized by | limited |
DistinguishedName | nvarchar(800) | yes | Distinguished name | |
CanonicalName | nvarchar(800) | yes | Canonical name | |
isMemberOfEnabled | bit(1) | yes | Group membership as MVP | |
UID_SyncServer | varchar(38) | yes | Synchronization server | FKUID |
AccountToPersonMatchingRule | nvarchar(-1) | yes | Search criteria for automatic identity assignment | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_DPRNameSpace | varchar(38) | yes | Target system type | FKUID |
IsNoWrite | bit(1) | yes | No write operations | |
UsesContainer | bit(1) | yes | Container hierarchy | |
GroupUsageMask | int(4) | yes | Used system entitlement types | bitmask |
UserContainsGroupList | int(4) | yes | User account contains memberships | bitmask |
DeleteDelayDays | int(4) | yes | Deferred deletion [days] |
Relations
| FK | From | To |
|---|---|---|
| TSB_RFRL1465 | UNSGroupB.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL1466 | UNSAccountB.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL1468 | UNSRootB.UID_TSBAccountDef | TSBAccountDef.UID_TSBAccountDef |
| TSB_RFRL1500 | UNSContainerB.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL1603 | UNSRootB.UID_AERoleOwner | BaseTree.UID_Org |
| TSB_RFRL1719 | UNSItemB.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL2566 | UNSRootB.UID_DPRNameSpace | DPRNameSpace.UID_DPRNameSpace |
| TSB_RFRL4293 | UNSRootB.UID_SyncServer | QBMServer.UID_QBMServer |
| TSB_RFRL5465 | UNSGroupB1.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL6465 | UNSGroupB2.UID_UNSRootB | UNSRootB.UID_UNSRootB |
| TSB_RFRL7465 | UNSGroupB3.UID_UNSRootB | UNSRootB.UID_UNSRootB |
Triggers
GEN_T1AA25344E959F205F78B42357 SQL_TRIGGER
GEN_T22D930250ADA9EA6A1B16DD90 SQL_TRIGGER
GEN_T39B2E068B76181F1D019E7ABE SQL_TRIGGER
GEN_T46053E3A047CA637BAAA41F87 SQL_TRIGGER
GEN_T5DFA1DFCF86799F836817BFF0 SQL_TRIGGER
GEN_T6BB3F02737D849522B1E4D081 SQL_TRIGGER
TSB_TATTUUNSRootB SQL_TRIGGER
TSB_TCPLUUNSRootB SQL_TRIGGER
TSB_TDUNSRootB SQL_TRIGGER
TSB_TIUNSRootB SQL_TRIGGER
TSB_TRMBUUNSRootB SQL_TRIGGER
TSB_TUUNSRootB 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_FTBD06BC392C446FFD04D09C27 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAB9E86C9E57B65A3C36124A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD0423232E940C76F51DB95 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY9C537565E770C30AA1EC81 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.TSB_FGIDPRNameSpaceFromRoot | SQL expression dependency | dbo · UID_DPRNameSpace · OBJECT_OR_COLUMN |
| dbo.TSB_FGIUNSRootBMatching | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_FGIUNSRootBMatching | SQL expression dependency | dbo · UID_UNSRootB · OBJECT_OR_COLUMN |
| dbo.TSB_FGIUNSRootBMatching | SQL expression dependency | dbo · UID_DPRNameSpace · OBJECT_OR_COLUMN |
| dbo.GEN_P81873663C07A2B77D5AFA3EBA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBHasUNSItemB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB1InUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_RUNSGroupB3InUNSGroupB3 | 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_ZBaseTreeOwnsObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZPersonHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSAccountBHasUNSItemB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSGroupBHasUNSItemB | 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_T1278801ADF47EAB5ED6CBA574 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T16854EEB4DCCB6D28FD3846C0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1A53B5FF8BC2525A724319139 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D01571F7BC5055F3A7389C93 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20FD7E6E6BD9B58A3ACFC862C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T22194AF12D6CB9D9BADC3CFBE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T236F0F75AB9F7309F1342269A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T239F21D783D386786BEB87121 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2548431FC8000F88E6670D504 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSAccountBInUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB1InUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB3InUNSGroupB3 | 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_TUTSBBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSRootB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMSystemMetering | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VAERoleUnsContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VAERoleUnsContainerB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · 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.TSBAccountDefAndAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBAERoleForRoot | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBGroupToTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDomainAndContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVPersonAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVUNSDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSRoot | SQL expression dependency | OBJECT_OR_COLUMN |
| UNSGroupB | foreign key references table | TSB_RFRL1465: UNSGroupB.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSAccountB | foreign key references table | TSB_RFRL1466: UNSAccountB.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| TSBAccountDef | referenced by foreign key from table | TSB_RFRL1468: UNSRootB.UID_TSBAccountDef -> TSBAccountDef.UID_TSBAccountDef |
| UNSContainerB | foreign key references table | TSB_RFRL1500: UNSContainerB.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| BaseTree | referenced by foreign key from table | TSB_RFRL1603: UNSRootB.UID_AERoleOwner -> BaseTree.UID_Org |
| UNSItemB | foreign key references table | TSB_RFRL1719: UNSItemB.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| DPRNameSpace | referenced by foreign key from table | TSB_RFRL2566: UNSRootB.UID_DPRNameSpace -> DPRNameSpace.UID_DPRNameSpace |
| QBMServer | referenced by foreign key from table | TSB_RFRL4293: UNSRootB.UID_SyncServer -> QBMServer.UID_QBMServer |
| UNSGroupB1 | foreign key references table | TSB_RFRL5465: UNSGroupB1.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSGroupB2 | foreign key references table | TSB_RFRL6465: UNSGroupB2.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| UNSGroupB3 | foreign key references table | TSB_RFRL7465: UNSGroupB3.UID_UNSRootB -> UNSRootB.UID_UNSRootB |
| dbo.DPR_FSQTriggerWatchMemberShip | source text reference | uses session context values |
| dbo.TSB_FGIDPRNameSpaceFromRoot | source text reference | SQL_SCALAR_FUNCTION |
| dbo.TSB_FGIUNSRootBMatching | source text reference | SQL_SCALAR_FUNCTION |
| dbo.TSB_PUNSAccountBInUNSGroupB_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB1_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB2_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_PUNSAccountBInUNSGroupB3_K | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSAccountBHasUNSItemB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSAccountBInUNSGroupB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSAccountBInUNSGroupB1 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSAccountBInUNSGroupB2 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSAccountBInUNSGroupB3 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupB1InUNSGroupB1 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupB2InUNSGroupB2 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_RUNSGroupB3InUNSGroupB3 | 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_ZBaseTreeOwnsObject | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasUNSGroupB | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasUNSGroupB1 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasUNSGroupB2 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZPersonHasUNSGroupB3 | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.TSB_ZUNSAccountBHasUNSItemB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSAccountBInUNSGroupB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSAccountBInUNSGroupB1 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSAccountBInUNSGroupB2 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSAccountBInUNSGroupB3 | source text reference | has TRY/CATCH error handling |
| dbo.TSB_ZUNSGroupBHasUNSItemB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_TIUNSAccountB | 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_TIUNSAccountBHasUNSGroupB1 | 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_TIUNSAccountBHasUNSGroupB3 | 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_TIUNSAccountBInUNSGroupB1 | 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_TIUNSAccountBInUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupB1 | 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_TIUNSGroupB2 | 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_TIUNSGroupB3 | 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_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_TUTSBBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountB | source text reference | 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 |