Data Model Changes

Release Information > Release Notes > Core Feature-Based Release Notes > Core 25.2 > Data Model Changes

Data Model Changes

The following are the Data Model changes for the ServiceMax Core 25.2 release:

• The number of Custom Objects added: 34

• The number of Custom Relationship Fields added: 43

• The number of Standard Fields added: 10

• The number of Custom Fields added: 60

The following table lists the custom Objects and Fields added in the data dictionary for the ServiceMax Core 25.2 release:

Feature	Object Name	Field Name	Data Type
Investigation	Investigation Context (New)	Custom Relationship Fields
		Case	Lookup (Case)
		Investigation	Master-Detail(Investigation)
		Service Product	Lookup(Service Product)
		Service Request	Lookup(Service Request)
		Work Order	Lookup(Work Order)
		Standard Field
		Record Number	Auto Number
		Custom Field
		Context Type	Text(100)
	Observation Applicability (New)	Custom Relationship Fields
		Observation	Master-Detail (Observation)
		Product	Lookup(Product)
		Standard Field
		Record Number	Auto Number
		Custom Fields
		Active	Checkbox
		Product Line	Picklist
		Product Family	Picklist
	Root Cause Applicability (New)	Custom Relationship Fields
		Root Cause	Master-Detail (Root Cause)
		Product	Lookup(Product)
		Standard Field
		Record Number	Auto Number
		Custom Fields
		Active	Checkbox
		Product Line	Picklist
		Product Family	Picklist
	Solution Applicability (New)	Custom Relationship Fields
		Solution	Master-Detail (Solution)
		Product	Lookup(Product)
		Standard Field
		Record Number	Auto Number
		Custom Fields
		Active	Checkbox
		Product Line	Picklist
		Product Family	Picklist
Preventive Maintenance	PM Forecast Schedule Template (New)	Custom Relationship Fields
		PM Plan Template	Master-Detail(PM Plan Template)
		Work Order Purpose	Lookup(Task Template)
		Standard Field
		Record Number	Auto Number
		Custom Fields
		Advanced Expression	Text(255)
		Expression Display Value	Text(255)
		Expression Internal Value	Long Text Area(32768)
		Sequence	Number(4, 0)
Product Structure	Variance Product Assignment (New)	Custom Relationship Fields
		Product	Lookup(Product)
		Variance Configuration	Lookup (Variance Configuration)
		Standard Field
		Record Number	Auto Number
	Variance Details (New)	Custom Relationship Fields
		Product	Lookup (Product)
		Top Level Product Structure	Lookup (Product Structure)
		Top Level IB	Lookup (Installed Product)
		Standard Field
		Record Number	Auto Number
		Custom Fields
		Delta Quantity	Integer(4,0)
		IB Quantity	Integer(4,0)
		PS Quantity	Integer(4,0)
		Variance Type	Text(200)
	Option (New)	Standard Field
		Record Number	Auto Number
		Custom Fields
		External Id	Text(255) External Id
		Option Name	Text(255)
	Option Choice (New)	Custom Relationship Fields
		Option	Lookup (Option)
		Standard Field
		Record Number	Auto Number
		Custom Fields
		Choice Name	Text(255)
		External Id	Text(255) External Id
	Software Build (New)	Custom Relationship Fields
		Product	Lookup (Product)
		Custom Fields
		Software Build Name	Text
		Build Number	Text(255)
	IB Option Configuration (New)	Custom Relationship Fields
		Installed Product	Lookup (Installed Product)
		Option Choice	Lookup (Option Choice)
		Standard Field
		Record Number	Auto Number
Investigation	Investigation Observation	Custom Fields
		Origin	Picklist
		Status	Picklist
	Investigation Root Cause	Custom Fields
		Origin	Picklist
		Status	Picklist
	Investigation Solution	Custom Fields
		Origin	Picklist
		Status	Picklist
	Solution	Custom Relationship Fields
	Solution	Work Plan	Lookup(Work Plan)
Product Structure	Product Structure	Custom Fields
	Product Structure	Sort Key	Text (255)
	Installed Product	Custom Fields
		Variance	Integer (4,2)
		Missing Parts	Integer(4,0)
		Non-Compliant Parts	Integer(4,0)
		IB Part Count	Integer(4,0)
		PS Part Count	Integer(4,0)
		Variance Calculated On	Datatime
		Variance Calculation Notes	Long Text Area(32000)
	Product Structure Configuration	Custom Fields
	Product Structure Configuration	Is Product Structure Enabled	Checkbox
Parts Usage	Part Usage Transaction	Custom Fields
		Include in Return	Checkbox
		Is Return Order Line Processed	Checkbox
	Parts Order Line	Custom Relationship Fields
	Parts Order Line	Part Usage Transaction	Lookup(Part Usage Transaction)
Depot	Depot Queue Item	Custom Fields
		Is Hold	Checkbox
		Hold Reason	Picklist
		Hold On Date	Datetime
		Priority	Picklist
	Depot Queue Item History	Custom Fields
		Current Hold On Date	Datetime
		Previous Hold On Date	Datetime
Field Change Order	Change Order Log	Custom Fields
		File Id	Text(18)
		Hosted At	Text(50)
		Search Status	Text(20)
		Sequence	Number(3,0)
Work Plan	Applicable Work Plan	Custom Relationship Fields
	Applicable Work Plan	PM Forecast Schedule Template	Lookup(PM Forecast Schedule Template)
	Service Task	Custom Relationship Fields
		Technical Attributes Template	Lookup(Attributes Template)
		Custom Fields
		Select Template At Runtime	Checkbox
		Scheduled Date Time	Datetime
	Work Plan Task	Custom Relationship Fields
		Technical Attributes Template	Lookup(Attributes Template)
		Custom Fields
		Select Template At Runtime	Checkbox
	Covered Work Plan	Custom Relationship Fields
		Product Warranty	Lookup( Warranty)
		Warranty Terms	Lookup(Warranty Term)
		Service Plan	Lookup(Service Plan)
		Custom Fields
		Expense Coverage	Percent
		Labor Coverage	Percent
		Part Coverage	Percent
		Unlimited Coverage	Boolean (Default = false)
	Service Product	Custom Relationship Fields
	Service Product	Product Warranty	Lookup(Product Warranty)
	Work Plan Assignment	Custom Relationship Fields
		Product Warranty	Lookup(Product Warranty)
		Work Plan	Lookup(Work Plan)
	Service Pricebook Entry	Custom Relationship Fields
		Work Plan	Lookup(Work Plan)
		Product	Lookup(Product)
	Work Plan	Custom Relationship Fields
	Work Plan	Dependency Management	Lookup (Dependency Management)
	ServiceMax Event	Custom Relationship Fields
	ServiceMax Event	Service Task	Lookup (Service Task)
	IB Technical Attribute	Custom Fields
		What Id	Text(18)
		Lookup Information	Long Text Area(1000)
	Work Order Dependency	Custom Relationship Fields
		Primary Work Plan Task	Lookup(Work Plan Task)
		Secondary Work Plan Task	Lookup(Work Plan Task)
		Primary Service Task	Lookup(Service Task)
		Secondary Service Task	Lookup(Service Task)
		Primary Work Plan Assignment	Lookup(Work Plan Assignment)
		Secondary Work Plan Assignment	Lookup(Work Plan Assignment)

Apex Trigger

Feature	Trigger Name	Object	Trigger Details
Investigation	RSE_ObservationTrigger	Observation	Used to validate and identify duplicate Observation records
	RSE_RootCauseTrigger	RootCause	Used to validate and identify duplicate Rootcause records
	RSE_SolutionTrigger	Solution	Used to validate and identify duplicate Solution records
	RSE_ObservationApplicabilityTrigger	Observation Applicability	Used to validate Observation applicability records to populate only single field on the record and check for duplicates records
	RSE_RootCauseApplicabilityTrigger	Root Cause Applicability	Used to validate Rootcause applicability records to populate only single field on the record and check for duplicates records
	RSE_SolutionApplicabilityTrigger	Solution Applicability	Used to validate Solution applicability records to populate only single field on the record and check for duplicates records
Product Structure	PSTR_ProductStructureTrigger	Product Structure	Used to validate parent reference, Validate top level, Validate ServiceBOM/ProductTemplate uniqueness and Auto populate top level
Technical Attributes	TA_AttributeTemplateTrigger	Attributes Template	Used to delete the Product Attrbutes related to Attribute Template

Updates to Object Relationship Diagrams

The following are the Object Relationship Diagram changes for the ServiceMax Core 25.2 release:

• Investigations

• Preventive Maintenance Template and Plan

• Preventive Maintenance Template and Plan — Work Plan

• Product Structure

• Product Structure Configuration

• Work Plans and Task Management

Was this helpful?