dbo.BaseTreeHasLDAPGroup
Roles and organizations: LDAP group assignments
TableType BUsage USERDATARows 82SizeMB 0.104
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Org | varchar(38) | no | Business Role | PKFKUID |
UID_LDAPGroup | varchar(38) | no | LDAP group | PKFKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
RiskIndexCalculated | float(8) | yes | Risk index (calculated) | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
XOrigin | int(4) | yes | Origin | bitmask |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XIsInEffect | bit(1) | yes | Assignment in effect |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T12EF7EEF351BA8CB7B6EB933C SQL_TRIGGER
GEN_T2CA79921530CA27D0251D0BED SQL_TRIGGER
GEN_T5FD85D9E15BB11D9FD1FB7F26 SQL_TRIGGER
GEN_T67F0E798BD3F53EE746217CA0 SQL_TRIGGER
LDP_TIBaseTreeHasLDAPGroup SQL_TRIGGER
LDP_TUBaseTreeHasLDAPGroup 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_FTC97C4E282A021430296681B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTC981DF5F2F0406E0D7320D5B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA3BA487D25E0B51EEA031BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO88C3252E4822EEB5E56129 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY510EB2AF297B8F844C83DA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P1BF268D1A2D85F748D1C8D3DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PF837A42D1078A12AD322DF2DB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZBaseTreeHasObject | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZOrgHasLDAPGroup | 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_FTA73ADF7F79169968E59D3549 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3668994DF4B87B38A53439249 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5FD85D9E15BB11D9FD1FB7F26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TDLDAPGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TDLDAPGroupExclusion | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPGroupCollection | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPGroupExclusion | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DepartmentHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ITShopOrgHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ITShopSrcHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LocalityHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.OrgHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ProfitCenterHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVBaseTreeHasElement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBBaseTreeAndGroups | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVDirectAssignWrong | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZBaseTreeHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZLDPMachineInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZOrgHasLDAPGroup | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.LDP_TDLDAPGroupCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TDLDAPGroupExclusion | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TILDAPGroupCollection | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TILDAPGroupExclusion | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TUBaseTreeHasLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |