Database Schema Changes 12.0.x

12.0.5.3511 (05.03.2025)

Deleted Tables

Table	Attribute
WorkerEvents	EnterpriseId
	Id
	InstanceId
	RecordDetails
	StartTime

Deleted Attributes

Table	Attribute
WFPPromotionsTable	Culture

12.0.5.3445 (Technical Release; 09.07.2024)

Added Tables

Table	Attribute
DWPEntraIDFilterPropertyPickup	DataColumnName
	DisplayString
	DisplayString
	Hidden
	ID
	IsArray
	Isable
	Name
	ObjectType
	Position
	ReferenceFilter
	ReferenceTo
	SupportedConditionOperators
	TimeStamp
	Type
DWPEntraIDFilterPropertyPickup-CI	DisplayString
	ID
	LCID
	Owner
	TimeStamp
PDRDwpAuroraIngestionConfiguration	ID
	LastRunErrors
	TimeStamp
	TrackingLastVersionNumber
	UploadEndVersionNumber
	UploadStartVersionNumber
PDRDwpAuroraIngestionConfigurationPerCi	BatchIsComplete
	CiName
	ConfigVersion
	CurrentBatchId
	CurrentBatchVersion
	ID
	TimeStamp

Added Attributes

Table	Attribute
DWPFileStorageAccountClass	SendContentThroughServer
PDRApplicationClassBase	ShowPreviewOnSave
PDRDataQueryFilterClassBase	Hidden
PDRNavigationItemClassBase	BadgeFilter
	NumericBadge
	UnifiedSearchApplication
PDRServiceConnectionAppClass	SubscriptionId
SPSGlobalConfigurationClassBase	DisableHamletSearch
	OpenViewsFullscreen
WFPPromotionsTable	Culture

Changed Attributes

Table	Attribute	Change
LCMCloudSubscriptionClassBase	PID	From 100 to 200
PDRServiceConnectionClass	Password	From 100 to 500
SPSAssetClassOrder	ManufacturerOrderNumber	From 100 to 200

Version 12.0.4

12.0.4.3226 (06.06.2024)

Added Attributes

Table	Attribute
SPSSecurityGroupClassAD	MemberRemovingDate

12.0.4.3222 (08.05.2024)

Added Tables

Table	Attribute
SVCServiceBookingClassBase-CI	ID
	LCID
	Owner
	ServiceName
	TimeStamp

12.0.4.3192 (22.03.2024)

Added Tables

Table	Attribute
DWPCertificatesSyncResult	ErrorMessage
	ID
	LastSyncDate
	TimeStamp
DWPLoginPageConfigurationClass	BackgroundColor
	BackgroundImage
	ButtonColor
	ButtonTextColor
	Expression-ObjectID
	ID
	LeftForegroundColor
	LeftForegroundImage
	Logo
	RightForegroundColor
	RightForegroundImage
	RightForegroundImageBehaviour
	ShowRightPanel
	TextColor
	TimeStamp
	UsedInTypeSPSGlobalConfigurationType
	WelcomeText
	WelcomeTitle
	WelcomeTitleColor
DWPLoginPageConfigurationClass-CI	ID
	LCID
	Owner
	TimeStamp
	WelcomeText
	WelcomeTitle
SPSEnvironmentTypePickup	DiaplayString
	Hidden
	ID
	Position
	TimeStamp
	Value
SPSEnvironmentTypePickup-CI	DiaplayString
	ID
	LCID
	Owner
	TimeStamp

Added Attributes

Table	Attribute
PDRThemeClassBase	IsAvailable
SPSArticleClassBase	OneFromOptionalRequired
SPSGlobalConfigurationClassBase	EnvironmentType

Changed Attributes

Table	Attribute	Change
DWPLoginPageConfigurationClass	Logo	From 100 to -1

Version 12.0.3

12.0.3.3107 (05.02.2024)

Deleted Attributes

Table	Attribute
SPSSecurityGroupClassMember	Sid

12.0.3.3092 (Technical Preview; 20.12.2023)

New Tables

Table	Attribute
DWPActionGroupPickup	DisplayString
	Hidden
	Icon
	ID
	Position
	TimeStamp
	Value
DWPActionGroupPickup-CI	DisplayString
	ID
	LCID
	Owner
	TimeStamp
PDRCustomFilterExpressions	DataDefinition
	FilterExpression
	ID
	TimeStamp

Changed Attributes

Table	Attribute	Change
SPSAccountClassAD	HomeDriveUNCPath	Length increased from 255 to 4000
SPSAccountClassAD	TSHomeDriveUNCPath	Length increased from 255 to 4000

New Attributes

Table	Attribute
LCMLicenseDemandClassBase	ConfirmationMissingTaskCreated
PDRActionClassBase	Group
PDRNavigationItemClassBase	ShowStructureInNavigation
SPSArticleCategoryClassBase	Icon
SPSGenericConnectorConfigurationClassAzureAD	PrefillPersonsEmail
SPSGlobalConfigurationClassBase	ForceNewLookForEveryone
	TelemetryEnabled
SPSSecurityGroupClassMember	Sid
PDRThemeClassBase	BaseLayoutColor

Version 12.0.2

12.0.2.1197 (Technical Release; 02.10.2023)

Deleted Attributes

Table	Attribute
WFPPromotionsTable	Culture

12.0.2.1193 (Release candidate; 26.09.2023)

New Attributes

Table	Attribute
SPSArticleClassBase	DeclineBookingIfAllChildrenDeclined
SPSGlobalConfigurationClassBase	AllowParameterizedFiltersOnly
SPSRemoteAgentClassBase	Name

Deleted Tables

Table	Attribute
AspNetViewState	Date
	Expire
	ID

Deleted Attributes

Table	Attribute
SPSAlertingConfiguration	SuiteURL
SPSGlobalConfigurationClassContractManagement	UseUuxLinksInEmails
SPSGlobalConfigurationClassLicenseManagement	UseUuxLinksInEmails
SPSGlobalConfigurationClassServiceCatalog	UseUuxLinksInEmails
SPSGlobalConfigurationClassServiceDesk	UseUuxLinksInEmails
WFPPromotionsTable	Culture

Version 12.0.1

12.0.1.1174 (21.09.2023)

New Tables

Table	Attribute
DWPAzureADCustomFilterPickup	DisplayString
	GraphFilterExpression
	Hidden
	ID
	Position
	TimeStamp
	Type
	Value
DWPAzureADCustomFilterPickup-CI	DisplayString
	ID
	LCID
	Owner
	TimeStamp
DWPAzureADCustomFilterTypePickup	DisplayString
	Hidden
	ID
	Position
	TimeStamp
	Value
DWPAzureADCustomFilterTypePickup-CI	DisplayString
	ID
	LCID
	Owner
	TimeStamp

12.0.1.1162 (31.08.2023)

New Attributes

Table	Attribute
SPSGlobalConfigurationClassSecurity	Saml2LoginSign
SPSGlobalConfigurationClassServiceDesk	InheritTaskOwnershipFromInitiator

12.0.1.1124 (Technical Preview; 03.07.2023)

New Attributes

Table	Attribute
PDRActionClassBase	ReloadPageOnSuccess
PDRAudienceClass	UsedInTypePDRDataQueryType
PDRDataQueryClassBase	PrimaryFilter
PDRDataQueryClassBase	Priority
PDRThemeClassBase	IsActiveForNewUi
SPSActivityClassGroupTicket	KnownError
SPSGlobalConfigurationClassServiceDesk	DaysAllowedToReopenClosedTicket

Version 12.0

12.0.0.1050 (Release Candidate; 28.03.2023)

New Tables

Table	Attribute
SchemaRelation-SVCDecisionMakerGroupClassBase2SPSSecurityClassRole	DecisionMakerGroups
	ID
	Roles
	TimeStamp
SchemaRelation-SVCDecisionMakerGroupClassBase2SPSUserClassBase	DecisionMakerGroupss
	ID
	TimeStamp
	Users
SVCDecisionMakerGroupClassBase	Description
	Expression-ObjectID
	Expressions
	ID
	Name
	TimeStamp
	TypeID
SVCDecisionMakerGroupClassBase-CI	ID
	LCID
	Name
	Owner
	TimeStamp

New Attributes

Table	Attribute
SPSGlobalConfigurationClassBase	HistoryConsolidationUseAuditService
	HistoryServiceConnection
SPSInventoryClassBase	UsedInTypeSPSPrinterType
SPSRatingSummaryClassBase	UsedInTypeSPSArticleTypeGroup
	UsedInTypeSPSArticleTypeService
	UsedInTypeSVCServiceTypeBundle
	UsedInTypeSVCServiceTypeConfigGroup

Changed Attributes

Table	Attribute	Change
PDRAsyncOperationClass	OperationName	Size increased from 100 to 1000