Column patterns

Generated guide over 2,483 distinct column names and 7,720 table columns. Pattern groups help start investigations but do not claim semantic equivalence.

pass 9 warn 0

UID identity and relation columns pass

Columns beginning with UID_ commonly identify records or reference other records. Use FK evidence and table pages before assuming semantics.

563 column names1,315 occurrences629 FK out629 FK in

UID_Org 33 tables · FK out 13 · FK in 43
Types: varchar(38) × 33
UID_Person 30 tables · FK out 19 · FK in 38
Types: varchar(38) × 30
UID_QBMClrType 26 tables · FK out 25 · FK in 41
Types: varchar(38) × 26
UID_AccProduct 21 tables · FK out 19 · FK in 21
Types: varchar(38) × 21
UID_DialogColumn 21 tables · FK out 0 · FK in 1
Types: varchar(38) × 21
UID_DialogTable 21 tables · FK out 20 · FK in 31
Types: varchar(38) × 21
UID_DialogGroup 14 tables · FK out 12 · FK in 14
Types: varchar(38) × 14
UID_PersonHead 12 tables · FK out 3 · FK in 0
Types: varchar(38) × 12
UID_TSBAccountDef 12 tables · FK out 10 · FK in 11
Types: varchar(38) × 12
UID_DialogCulture 11 tables · FK out 10 · FK in 12
Types: varchar(38) × 11
UID_DPRShell 10 tables · FK out 9 · FK in 9
Types: varchar(38) × 10
UID_PWODecisionRule 10 tables · FK out 9 · FK in 9
Types: varchar(38) × 10
UID_UNSAccountB 10 tables · FK out 0 · FK in 0
Types: varchar(38) × 10
UID_DialogProduct 9 tables · FK out 8 · FK in 8
Types: varchar(38) × 9
UID_PersonWantsOrg 9 tables · FK out 6 · FK in 8
Types: varchar(38) × 9
UID_AERoleOwner 8 tables · FK out 8 · FK in 0
Types: varchar(38) × 8

X* audit / system columns pass

Common X-prefixed columns such as XDateInserted, XDateUpdated, XUserInserted, XUserUpdated, XTouched, XObjectKey, and XMarkedForDeletion.

11 column names2,878 occurrences0 FK out0 FK in

XTouched 422 tables · FK out 0 · FK in 0
Types: nchar(1) × 422
XObjectKey 418 tables · FK out 0 · FK in 0
Types: varchar(138) × 418
XDateInserted 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XDateUpdated 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XUserInserted 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XUserUpdated 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XMarkedForDeletion 334 tables · FK out 0 · FK in 0
Types: int × 334
XOrigin 42 tables · FK out 0 · FK in 0
Types: int × 42
XIsInEffect 37 tables · FK out 0 · FK in 0
Types: bit × 37
XDateSubItem 11 tables · FK out 0 · FK in 0
Types: datetime × 11
X121Address 2 tables · FK out 0 · FK in 0
Types: nvarchar(15) × 2

Ident / display-name columns pass

Columns often used for identifiers, names, captions, display values, and user-visible labels.

137 column names453 occurrences0 FK out0 FK in

Description 153 tables · FK out 0 · FK in 0
Types: nvarchar(max) × 58, nvarchar(1024) × 57, nvarchar(512) × 14
DisplayName 74 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 38, nvarchar(255) × 18, nvarchar(64) × 7
Name 35 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 24, nvarchar(255) × 6, nvarchar(128) × 3
NameFormat 23 tables · FK out 0 · FK in 0
Types: nvarchar(32) × 23
DisplayValue 10 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 8, nvarchar(255) × 2
Caption 7 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 3, nvarchar(128) × 2, nvarchar(255) × 1
IdentityType 5 tables · FK out 0 · FK in 0
Types: varchar(32) × 5
DisplayPattern 4 tables · FK out 0 · FK in 0
Types: nvarchar(255) × 2, nvarchar(256) × 1, nvarchar(max) × 1
DisplayPersonHead 4 tables · FK out 0 · FK in 0
Types: nvarchar(128) × 2, nvarchar(255) × 2
Ident_PWODecisionStep 4 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 4
NamespaceManagedBy 3 tables · FK out 0 · FK in 0
Types: nvarchar(16) × 3
DisplayNameQualified 2 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 2
DisplayObjectKeyAssignment 2 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 2
DisplayOrg 2 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 2
Ident_Domain 2 tables · FK out 0 · FK in 0
Types: nvarchar(128) × 1, nvarchar(32) × 1
Ident_PWODecisionSubMethod 2 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 2

Date/time columns pass

Columns whose type or name indicates date/time values.

113 column names1,366 occurrences3 FK out3 FK in

XDateInserted 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XDateUpdated 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XUserUpdated 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XDateSubItem 11 tables · FK out 0 · FK in 0
Types: datetime × 11
DateHead 4 tables · FK out 0 · FK in 0
Types: datetime × 4
UID_DialogTimeZone 4 tables · FK out 3 · FK in 3
Types: varchar(38) × 4
AccountExpires 3 tables · FK out 0 · FK in 0
Types: datetime × 3
ExceptionValidUntil 3 tables · FK out 0 · FK in 0
Types: datetime × 3
IsoDate 3 tables · FK out 0 · FK in 0
Types: nvarchar(10) × 3
ModifyTimeStamp 3 tables · FK out 0 · FK in 0
Types: nvarchar(30) × 3
ValidFrom 3 tables · FK out 0 · FK in 0
Types: datetime × 3
ValidUntil 3 tables · FK out 0 · FK in 0
Types: datetime × 3
ValidUntilUnsubscribe 3 tables · FK out 0 · FK in 0
Types: datetime × 3
CreationDate 2 tables · FK out 0 · FK in 0
Types: datetime × 2
DateTimeDetail 2 tables · FK out 0 · FK in 0
Types: int × 2
DecisionDate 2 tables · FK out 0 · FK in 0
Types: datetime × 2

Flag / boolean-like columns pass

Bit and flag-style columns, including Is*/Has*/XMarked* patterns.

464 column names1,047 occurrences0 FK out0 FK in

XMarkedForDeletion 334 tables · FK out 0 · FK in 0
Types: int × 334
XIsInEffect 37 tables · FK out 0 · FK in 0
Types: bit × 37
IsInActive 27 tables · FK out 0 · FK in 0
Types: bit × 27
IsDeactivatedByPreProcessor 15 tables · FK out 0 · FK in 0
Types: bit × 15
IsForITShop 13 tables · FK out 0 · FK in 0
Types: bit × 13
IsITShopOnly 13 tables · FK out 0 · FK in 0
Types: bit × 13
IsLocked 9 tables · FK out 0 · FK in 0
Types: bit × 9
IsCircular 6 tables · FK out 0 · FK in 0
Types: bit × 6
HasReadOnlyMemberships 5 tables · FK out 0 · FK in 0
Types: bit × 5
IsAutoAssignToPerson 5 tables · FK out 0 · FK in 0
Types: bit × 5
IsCrypted 5 tables · FK out 0 · FK in 0
Types: bit × 5
IsDeactivated 5 tables · FK out 0 · FK in 0
Types: bit × 5
IsProtectedFromAccidentalDel 5 tables · FK out 0 · FK in 0
Types: bit × 5
IsReadOnly 5 tables · FK out 0 · FK in 0
Types: bit × 5
IsGroupAccount 4 tables · FK out 0 · FK in 0
Types: bit × 4
IsManual 4 tables · FK out 0 · FK in 0
Types: bit × 4

Columns with outgoing FK evidence pass

Column groups with at least one foreign-key row pointing to another table.

254 column names870 occurrences629 FK out611 FK in

UID_Org 33 tables · FK out 13 · FK in 43
Types: varchar(38) × 33
UID_Person 30 tables · FK out 19 · FK in 38
Types: varchar(38) × 30
UID_QBMClrType 26 tables · FK out 25 · FK in 41
Types: varchar(38) × 26
UID_AccProduct 21 tables · FK out 19 · FK in 21
Types: varchar(38) × 21
UID_DialogTable 21 tables · FK out 20 · FK in 31
Types: varchar(38) × 21
UID_DialogGroup 14 tables · FK out 12 · FK in 14
Types: varchar(38) × 14
UID_PersonHead 12 tables · FK out 3 · FK in 0
Types: varchar(38) × 12
UID_TSBAccountDef 12 tables · FK out 10 · FK in 11
Types: varchar(38) × 12
UID_DialogCulture 11 tables · FK out 10 · FK in 12
Types: varchar(38) × 11
UID_DPRShell 10 tables · FK out 9 · FK in 9
Types: varchar(38) × 10
UID_PWODecisionRule 10 tables · FK out 9 · FK in 9
Types: varchar(38) × 10
UID_DialogProduct 9 tables · FK out 8 · FK in 8
Types: varchar(38) × 9
UID_PersonWantsOrg 9 tables · FK out 6 · FK in 8
Types: varchar(38) × 9
UID_AERoleOwner 8 tables · FK out 8 · FK in 0
Types: varchar(38) × 8
UID_ComplianceRule 8 tables · FK out 7 · FK in 7
Types: varchar(38) × 8
UID_DialogCountry 8 tables · FK out 7 · FK in 13
Types: varchar(38) × 8

Columns referenced by FKs pass

Column groups referenced by at least one foreign-key row from another table.

145 column names712 occurrences467 FK out629 FK in

UID_Org 33 tables · FK out 13 · FK in 43
Types: varchar(38) × 33
UID_Person 30 tables · FK out 19 · FK in 38
Types: varchar(38) × 30
UID_QBMClrType 26 tables · FK out 25 · FK in 41
Types: varchar(38) × 26
UID_AccProduct 21 tables · FK out 19 · FK in 21
Types: varchar(38) × 21
UID_DialogColumn 21 tables · FK out 0 · FK in 1
Types: varchar(38) × 21
UID_DialogTable 21 tables · FK out 20 · FK in 31
Types: varchar(38) × 21
UID_DialogGroup 14 tables · FK out 12 · FK in 14
Types: varchar(38) × 14
UID_TSBAccountDef 12 tables · FK out 10 · FK in 11
Types: varchar(38) × 12
UID_DialogCulture 11 tables · FK out 10 · FK in 12
Types: varchar(38) × 11
UID_DPRShell 10 tables · FK out 9 · FK in 9
Types: varchar(38) × 10
UID_PWODecisionRule 10 tables · FK out 9 · FK in 9
Types: varchar(38) × 10
UID_DialogProduct 9 tables · FK out 8 · FK in 8
Types: varchar(38) × 9
UID_PersonWantsOrg 9 tables · FK out 6 · FK in 8
Types: varchar(38) × 9
UID_ComplianceRule 8 tables · FK out 7 · FK in 7
Types: varchar(38) × 8
UID_DialogCountry 8 tables · FK out 7 · FK in 13
Types: varchar(38) × 8
UID_DialogSchedule 8 tables · FK out 5 · FK in 7
Types: varchar(38) × 8

AccProduct / IT Shop related columns pass

Column names or examples related to AccProduct, PersonWantsOrg, ITShop, or ShoppingCart evidence.

160 column names3,680 occurrences120 FK out160 FK in

XTouched 422 tables · FK out 0 · FK in 0
Types: nchar(1) × 422
XObjectKey 418 tables · FK out 0 · FK in 0
Types: varchar(138) × 418
XDateInserted 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XDateUpdated 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XUserInserted 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XUserUpdated 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XMarkedForDeletion 334 tables · FK out 0 · FK in 0
Types: int × 334
Description 153 tables · FK out 0 · FK in 0
Types: nvarchar(max) × 58, nvarchar(1024) × 57, nvarchar(512) × 14
SortOrder 35 tables · FK out 0 · FK in 0
Types: int × 21, float × 3, nvarchar(16) × 3
UID_Org 33 tables · FK out 13 · FK in 43
Types: varchar(38) × 33
UID_Person 30 tables · FK out 19 · FK in 38
Types: varchar(38) × 30
IsInActive 27 tables · FK out 0 · FK in 0
Types: bit × 27
CustomProperty01 21 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 21
CustomProperty02 21 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 21
CustomProperty03 21 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 21
CustomProperty04 21 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 21

Target-system related columns pass

Column names or examples related to ADS, LDAP, DPR, TSB, UNS, account, or group evidence.

869 column names5,357 occurrences342 FK out412 FK in

XTouched 422 tables · FK out 0 · FK in 0
Types: nchar(1) × 422
XObjectKey 418 tables · FK out 0 · FK in 0
Types: varchar(138) × 418
XDateInserted 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XDateUpdated 403 tables · FK out 0 · FK in 0
Types: datetime × 403
XUserInserted 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XUserUpdated 403 tables · FK out 0 · FK in 0
Types: nvarchar(64) × 403
XMarkedForDeletion 334 tables · FK out 0 · FK in 0
Types: int × 334
Description 153 tables · FK out 0 · FK in 0
Types: nvarchar(max) × 58, nvarchar(1024) × 57, nvarchar(512) × 14
DisplayName 74 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 38, nvarchar(255) × 18, nvarchar(64) × 7
XOrigin 42 tables · FK out 0 · FK in 0
Types: int × 42
RiskIndexCalculated 39 tables · FK out 0 · FK in 0
Types: float × 39
XIsInEffect 37 tables · FK out 0 · FK in 0
Types: bit × 37
Name 35 tables · FK out 0 · FK in 0
Types: nvarchar(256) × 24, nvarchar(255) × 6, nvarchar(128) × 3
SortOrder 35 tables · FK out 0 · FK in 0
Types: int × 21, float × 3, nvarchar(16) × 3
UID_Org 33 tables · FK out 13 · FK in 43
Types: varchar(38) × 33
UID_Person 30 tables · FK out 19 · FK in 38
Types: varchar(38) × 30