CA Clarity PPM Connector Type Data Mapping

CA Clarity PPM Connector and Domain Manager Interaction › CA Clarity PPM Connector USM Data Mapping › CA Clarity PPM Connector Type Data Mapping

CA Clarity PPM Connector Type Data Mapping

Objects that are imported from CA Clarity PPM to the CA Clarity PPM connector are normalized into USM format. This section describes the property mapping for the CIs that the CA Clarity PPM connector supports out of the box.

The following table is the CI Property Map for USM Person CI to Resource object in CA Clarity PPM:

USM (Person)	CA Clarity PPM (Resource XOG Attributes)
Label	(determined by global connector policy)
NamedAliases	displayName
UserName	userName
EmployeeID	user_id (NSQL query)
MdrElementID	resourceId
IsActive	isActive
FamilyName	lastName
FirstName	firstName
EmailAddresses	emailAddress
JobTitle	jobTitle

The following table is the CI Property Map for USM Project CI to Project object in CA Clarity PPM:

USM (Project)	CA Clarity PPM (Project XOG Attributes)
Label	(determined by global connector policy)
Description	description
MdrElementID	projectIntId
ProjectID	projectId
ApprovalStatus	status
IsActive	active
Progress	progress
ProjectPriority	priority
RiskDegree	statusIndicator
RiskComment	statusComment
StartDate	start
EndDate	finish
PlannedCost	plannedCostTotal
ActualToDateCost	(sum of ActCost segments)
Currency	currencyISOcode
Significance	defaultAllocationPercent

The following table is the supported USM relationships:

USM	CA Clarity PPM
IsComposedOf	Project/Subproject
IsManagerFor	Project/Resource