The table that holds ITPAM workflow instances to Request ID mapping

book

Article ID: 221774

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Catalog CA Process Automation Base

Issue/Introduction

What is the CA Service Catalog table where the relationship with ITPAM flow and their states are stored?

Environment

CA Service Management 17.1 and higher.

Resolution

Table: usm_object_wf_instance_ref

  • object_id1 - Refers to Request ID
  • object_id2 - Refers to Subscription Detail ID

Object_type:

  • OBJ_TYPE_OFFERING = 1; // Request item/offering object type
  • OBJ_TYPE_REQUEST_ITEM = 2; // Request item object type
  • OBJ_TYPE_REQUEST = 3; // Request object type

Workflow_type:

  1. CA Workflow
  2. PAM
  3. Policy

public static final int WF_TY_CA_WF = 1;
public static final int WF_TY_CA_ITPAM = 2;
public static final int WF_TY_CA_POLICY_ENGINE = 3;