dbo.UNSGroupB2Collection
Group hierarchy
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSGroupB2Parent | varchar(38) | no | Parent system entitlement 2 | PKFKUID |
UID_UNSGroupB2Child | varchar(38) | no | Child system entitlement 2 | PKFKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
LevelNumber | int(4) | yes | Level | |
IsCircular | bit(1) | yes | Circular reference | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| TSB_RFRL6110 | UNSGroupB2Collection.UID_UNSGroupB2Child | UNSGroupB2.UID_UNSGroupB2 |
Triggers
GEN_T1F9A6BFEAD9DD4B7EB9137521 SQL_TRIGGER
GEN_T26CBA54AF6227252C6BC60459 SQL_TRIGGER
GEN_T3AA5BD8A9DFC535F2F46665E8 SQL_TRIGGER
TSB_TDUNSGroupB2Collection SQL_TRIGGER
TSB_TIUNSGroupB2Collection 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_FTEAD7000AD9C38ECA30590962 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD48DD3E8DD9E49B431EC66 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY8C8C8E4B72714983D306FB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZBaseTreeHasObject | 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.TSB_ZUNSGroupB2InUNSGroupB2_C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3EEEF1F10626CDAD0BB259B5D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TDUNSGroupB2Exclusion | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TDUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB2Exclusion | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIUNSGroupB2InUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.UNSGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| UNSGroupB2 | referenced by foreign key from table | TSB_RFRL6110: UNSGroupB2Collection.UID_UNSGroupB2Child -> UNSGroupB2.UID_UNSGroupB2 |
| dbo.TSB_ZBaseTreeHasObject | source text reference | 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_ZUNSGroupB2InUNSGroupB2_C | source text reference | has TRY/CATCH error handling |
| dbo.TSB_TDUNSGroupB2Exclusion | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TDUNSGroupB2InUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIUNSGroupB2Exclusion | 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 |