Data Model Changes
The following are the data model changes for the ServiceMax Core 23.2 release:
The number of Custom Objects added: 9
The number of Custom Relationship fields added: 19
The number of Standard fields added: 9
The number of Custom fields added: 41
The number of Record Type fields added: 2
The following table lists the custom fields updated in the data dictionary for the ServiceMax Core 23.2 release:
Object Name
Field Name
Data Type
Shift Segment (new object)
Custom Relationship Fields
Assigned Resource
LOOKUP(TECHNICIAN/EQUIPMENT)
Standard Fields
Name
AUTO NUMBER
Custom Fields
Is Available
CHECKBOX
Shift Segment End
DATETIME
Shift Segment Start
DATETIME
Shift Segment Type
PICKLIST
Shift Type
PICKLIST
Solution (new object)
Standard Fields
Solution Title
TEXT (80)
Custom Fields
Active
CHECKBOX
Solution Description
TEXT (255)
Investigation (new object)
Custom Relationship Fields
Case
LOOKUP(CASE)
Completed By
LOOKUP(USER)
Installed Product
LOOKUP(INSTALLED PRODUCT)
Product
LOOKUP(PRODUCT)
Service Request
LOOKUP(SERVICE REQUEST)
Work Order
LOOKUP(WORK ORDER)
Standard Fields
Record Number
AUTO NUMBER
Custom Fields
Completed On
DATETIME
Investigation Notes
LONG TEXT AREA(131072)
Status
PICKLIST
Observation (new object)
Standard Fields
Observation Title
TEXT (80)
Custom Fields
Active
CHECKBOX
Observation Type
PICKLIST
Observation Description
TEXT (255)
Custom Relationship Fields
Affected Part
LOOKUP(PRODUCT)
Installed Product
LOOKUP(INSTALLED PRODUCT)
Investigation
MASTER-DETAIL(INVESTIGATION)
Observation
LOOKUP(OBSERVATION)
Standard Fields
Record Number
AUTO NUMBER
Custom Fields
Comments
LONG TEXT AREA(131072)
Custom Relationship Fields
Installed Product
LOOKUP(INSTALLED PRODUCT)
Investigation
MASTER-DETAIL(INVESTIGATION)
Solution
LOOKUP(SOLUTION)
Standard Fields
Record Number
AUTO NUMBER
Custom Fields
Comments
LONG TEXT AREA(131072)
Root Cause (new object)
Standard Fields
Root Cause Title
TEXT (80)
Custom Fields
Active
CHECKBOX
Root Cause Description
TEXT (255)
Custom Relationship Fields
Investigation
MASTER-DETAIL(INVESTIGATION)
Root Cause
LOOKUP(ROOT CAUSE)
Standard Fields
Record Number
AUTO NUMBER
Custom Fields
Comments
LONG TEXT AREA(131072)
Custom Relationship Fields
Investigation
LOOKUP(INVESTIGATION)
Investigation Solution
LOOKUP(INVESTIGATION SOLUTION)
Required Part
LOOKUP(PRODUCT)
Standard Fields
Record Number
AUTO NUMBER
Custom Fields
Required Quantity
NUMBER(13, 5)
Custom Fields
Disable Technical Attribute Processing
CHECKBOX
Custom Fields
Business Hours Duration (Previously called Duration)
NUMBER(16,2)
Non-Business Hours Duration
NUMBER(16,2)
Total Duration
NUMBER(16,2)
Custom Fields
Total Business Hours (Previously called Total Hours )
NUMBER(16,2)
Total Non-Business Hours
NUMBER(16,2)
Custom Fields
Total Business Hours (Previously called Total Hours)
NUMBER(16,2)
Total Non-Business Hours
NUMBER(16,2)
Custom Fields
Target Stock Level
NUMBER(13,5)
Standard Fields
RECORD TYPE
Custom Fields
Part Repairable
CHECKBOX
Part Procurable
CHECKBOX
Start of Service Life
DATE
Custom Fields
Active
CHECKBOX
Custom Fields
Replacement Type
PICKLIST
Custom Fields
Duration of Travel Coverage
NUMBER(18,0)
Travel % Covered
PERCENT(3,0)
Unit of Time for Travel Coverage
PICKLIST
Custom Fields
End Date Travel Covered
DATE
Custom Fields
Datetime Value
DATETIME
Date Value
DATE
Last Occurrence
LONG TEXT AREA(32000)
Time of Occurrence
DATETIME
Product Record Type
Record Type Label
Record Type Name
Description
Part
SM_Part
Parts within a product
Product
SM_Product
Top-level product serviced
For the complete list of the data model, see Data Model.
Was this helpful?