dbo.LDAPGroup
LDAP groups
TableType TUsage USERDATARows 4SizeMB 0.064
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_LDAPGroup | varchar(38) | no | LDAP group | PKUID |
XObjectKey | varchar(138) | no | Object key | |
ObjectGUID | varchar(40) | yes | Object GUID | |
CanonicalName | nvarchar(2000) | yes | Canonical name | |
IsDynamicGroup | bit(1) | yes | Dynamic group | |
IsForITShop | bit(1) | yes | IT Shop | |
ModifyTimeStamp | nvarchar(60) | yes | LDAP date last changed | |
IsITShopOnly | bit(1) | yes | Only use in IT Shop | |
StructuralObjectClass | nvarchar(512) | yes | Structural object class | |
XDateSubItem | datetime(8) | yes | Dependencies modified on | |
UID_LDPDomain | varchar(38) | no | Domain | FKUID |
MatchPatternForMembership | bigint(8) | yes | Category | |
DisplayName | nvarchar(510) | yes | Display name | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
RiskIndex | float(8) | yes | Risk index | |
DynamicGroupFilter | nvarchar(-1) | yes | Condition | |
cn | nvarchar(510) | yes | Name | |
UID_LDAPAccountOwner | varchar(38) | yes | Administrator | FKUID |
ObjectClass | nvarchar(2048) | yes | Object class | |
DistinguishedName | nvarchar(2000) | yes | Distinguished name | |
UID_LDAPContainer | varchar(38) | yes | Container | FKUID |
UID_AccProduct | varchar(38) | yes | Service item | 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 | |
BusinessCategory | nvarchar(-1) | yes | Business unit | |
Description | nvarchar(-1) | yes | Description | |
XTouched | nchar(2) | yes | Processing status | |
SeeAlso | nvarchar(-1) | yes | See also |
Relations
| FK | From | To |
|---|---|---|
| LDP_RFRL1320 | LDAPGroupInLDAPGroup.UID_LDAPGroupParent | LDAPGroup.UID_LDAPGroup |
| LDP_RFRL1332 | LDAPGroup.UID_LDAPContainer | LDAPContainer.UID_LDAPContainer |
| LDP_RFRL1348 | LDAPGroup.UID_AccProduct | AccProduct.UID_AccProduct |
| LDP_RFRL1425 | LDAPGroupExclusion.UID_LDAPGroupLower | LDAPGroup.UID_LDAPGroup |
| LDP_RFRL2553 | LDAPGroup.UID_LDPDomain | LDPDomain.UID_LDPDomain |
| LDP_RFRL4120 | LDAPGroupCollection.UID_LDAPGroupChild | LDAPGroup.UID_LDAPGroup |
Triggers
GEN_T148F6ED9F193FD4CBF6BA2B9C SQL_TRIGGER
GEN_T24CBF08E0CBCE9927C4191610 SQL_TRIGGER
GEN_T3668994DF4B87B38A53439249 SQL_TRIGGER
GEN_T5DBAF22C0428DC64E2CF763E9 SQL_TRIGGER
GEN_T64FA00E84359C96AB8A81824A SQL_TRIGGER
LDP_TATTULDAPGroup SQL_TRIGGER
LDP_TILDAPGroup SQL_TRIGGER
LDP_TULDAPGroup 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_FTEA0D4ED3FA20B8B03D99F9EA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA38B9ED76E7AC8770650C35 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA3BA487D25E0B51EEA031BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA6634AAB5446A6F027C3DDD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA717DA0B73310E9B176E430 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA927634F409219D76930307 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD3B3D4A4AAE3E77B7F745E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAD7441E90FFE1AE74985684 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE24C7689C983E5CB872211 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEAE94A2AB5EF5E2BADE9B1BB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO0EDC8574A3FA2D64F9D50A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO3077299134008999AC844A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO3D188781B44D49B2F0B86D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO441C2F873660C363A87E18 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO56BF6085851555680F56E2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEO88C3252E4822EEB5E56129 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOADB5D482192FECE896DB8D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOAF1EC18D18BF11B4872359 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOB2D535C0B0425DCAA6927A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD6B7883AF33FD1CE427C46 | 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_FTEY510EB2AF297B8F844C83DA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY6CBBED4521EDE5C5B61A02 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY714650F04D0D2C9ADFD428 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY780D32B60508B96FB55733 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY95BE8166C29BD1FD6991CC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA5065182EC53F911A8AB59 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYA60CCE102C52A5B0014C2D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYAC13F21E0D4DB4DD55310E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYF9B5B0718078CC8E220CB4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEYFED8D3214C9C1DAFEE2EB0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_P47FE782293862D2C716B80BCC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PB2F935A721940C6E32DB7B15C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PF837A42D1078A12AD322DF2DB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_PSRAE945DF58C7B8271C35910F | 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.LDP_ZPersonHasObject | 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_T12EF7EEF351BA8CB7B6EB933C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T13C1DDCEDA2F88F8632472AE6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1603BDFF9396E4E301A6A5255 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T163D7EB65421F4DB85A9FD579 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AED260340D040570CA4B3A61 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C81F4CC9D7AD8B36CAD6F2EB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1CC003F287E0713C2B7CC2D12 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1D625FC408434BD76E7C6A6C2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1EA7BE24A3331D721708CF413 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2078A04626260289E98D2CEAA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20C3366B9D322CD1C80FCEDAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T223962B688CF6CCA1B0A830C6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T236F0F75AB9F7309F1342269A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T249DB1D9F525BD29A1CF781A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25865F0A35D2A5F0430A6D78C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T289440C5249682B41CC407075 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CA79921530CA27D0251D0BED | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF44B1B0CFB801EB44A91ECE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2F01CEE8B7F3A9CA24C3EC862 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T417F8A7AFDDFC7CAB5315DF3D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T41B946E67273DDED72C86A445 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T43A01A89BE7D8EA235ED186F7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4906297FA0095B928C0D22E5E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4E21B0FB60FBE5F3646DB956B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T4FCB6A4B24280E57D68698951 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T553B9FB5AC14B225E0456AC15 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5AD66EB14BA05645CF6CF0E9C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5C05EBA812196A9AC2E57CCEE | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CFD1B173A2279589C6E3B7AB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5DBAF22C0428DC64E2CF763E9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5E1068FB36635FE0D4AE78366 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5F6AD473564BCE54D231FDB20 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5FD85D9E15BB11D9FD1FB7F26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T61B7F18C833B8744090DC161D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T6530B0C6C5D0CD4132304B156 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TDTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TIBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDAPGroupExclusion | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TILDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TIRMSESetHasEntitlement | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TITSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPAccountInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TUTSBSpecificGroupBehavior | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAC8843738FF9888D444E29989 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAD69C7D347D77FD889E74A114 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · UID_LDAPGroup · OBJECT_OR_COLUMN |
| dbo.LDP_VAccountGroupExtendedAtt | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · UID_LDAPGroup · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.LDP_VElementAndRoot | SQL expression dependency | dbo · UID_LDPDomain · 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.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.UNSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| LDAPGroupInLDAPGroup | foreign key references table | LDP_RFRL1320: LDAPGroupInLDAPGroup.UID_LDAPGroupParent -> LDAPGroup.UID_LDAPGroup |
| LDAPContainer | referenced by foreign key from table | LDP_RFRL1332: LDAPGroup.UID_LDAPContainer -> LDAPContainer.UID_LDAPContainer |
| AccProduct | referenced by foreign key from table | LDP_RFRL1348: LDAPGroup.UID_AccProduct -> AccProduct.UID_AccProduct |
| LDAPGroupExclusion | foreign key references table | LDP_RFRL1425: LDAPGroupExclusion.UID_LDAPGroupLower -> LDAPGroup.UID_LDAPGroup |
| LDPDomain | referenced by foreign key from table | LDP_RFRL2553: LDAPGroup.UID_LDPDomain -> LDPDomain.UID_LDPDomain |
| LDAPGroupCollection | foreign key references table | LDP_RFRL4120: LDAPGroupCollection.UID_LDAPGroupChild -> LDAPGroup.UID_LDAPGroup |
| 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_ZPersonHasObject | source text reference | has TRY/CATCH error handling |
| dbo.LDP_TDTSBSpecificGroupBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TIBaseTreeHasLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TILDAPAccountInLDAPGroup | 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_TILDPMachineInLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TIRMSESetHasEntitlement | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TITSBSpecificGroupBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPAccountInLDAPGroup | 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 |
| dbo.LDP_TUTSBSpecificGroupBehavior | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |