Field Mappings

The following table show how the fields in Remedy map to CA Clarity PPM using CA Technologies Clarity Service Connect add-in:

Remedy Field	Type	CA Clarity PPM Field	Notes
"REMEDY"	string	sourceCode	The external source for the incident; "REMEDY" in this case.
Assignee_Login_Name	string	assignedTo effort/resourceCode	Mapped to user login name.
Case_ID	string	externalId incidentCode	Use the "RMD_" prefix.
Case_Type	string	typeCode	Mappings from Remedy to CA Clarity PPM are: Incident == INCIDENT Question == SERVICE_REQUEST Request == SERVICE_REQUEST Problem == INCIDENT
Category	string	categoryCode
Create_Time	dateTime	startDate
Description	string	description
Estimated_Total_Time	int	estimatedEffort	Expressed in minutes.
Request_Impact	string	impactCode	Mappings from Remedy to CA Clarity PPM are: Low == 1 Medium == 2 High == 3
Modified_Time	dateTime	effort/transactionDate	This is also used by the integration script.
Priority	string	priorityCode	Mappings from Remedy to CA Clarity PPM are: Low == 1 Medium == 2 High == 3 Urgent == 3
Request_Impact	string	impactCode	Mappings from Remedy to CA Clarity PPM are: Low == 1 Medium == 2 High == 3
Request_Urgency	string	urgencyCode	Mappings from Remedy to CA Clarity PPM are: Low == 1 Medium == 2 High == 3 Urgent == 3
Requester_Login_Name	string	reportedBy	Mapped to user login name.
Resolved_Time	dateTime	resolution_Date
Status	string	statusCode	Mappings from Remedy to CA Clarity PPM are: New == NEW Assigned == ASSIGNED Work In Progress == WORK_IN_PROGRESS Pending == ON_HOLD Resolved == RESOLVED Closed == CLOSED
Summary	string	subject
Total_Time_Spent	int	effort/quantity	Quantity is expressed in hours (Total_Time_Spent / 60 = quantity) The first time that Total Time Spent is passed to CA Clarity PPM, it is sent as a financial transaction effort. When values change for that field in Remedy, they are not imported into CA Clarity PPM when this process executes again.

The following table shows the mapping between Remedy and CA Clarity PPM to the source object:

Remedy Field	CA Clarity PPM Field	Source Object
Time	Effort	Financial Transactions
Category	Category Code	Incident (references Incident Category)
Type	Type	Incident
Item	External ID	Incident
Summary	Subject /Short Description	Incident
Status	Status	Incident
Priority	Priority	Incident
Resolution	Note	Notes
Contact	Name	Resource
Email	Email	Resource Contact
Assigned To	Assigned To	Incident (references Resource)
Elapsed Time	not applicable	not applicable
Request ID	Tracking ID	Incident
Date Opened	Start Date	Incident
Resolution Date	Resolution Date	Incident
not applicable	Expected Resolution Date	Incident