REMOTE_SERVICES_REQUESTS table

Edit online

The REMOTE_SERVICES_REQUESTS table stores asynchronous requests or requests that are made while reconciliation is in progress. It also stores requests issued while a resource is in a failed state.

Table 1. REMOTE_SERVICES_REQUESTS table
Column Name Description Data type
PROVIDER_ID Unique ID for each resource provider. References RESOURCE, PROVIDERS, and(PROVIDER_ID). Character (20)
REQUEST_ID* ID of the request made. Primary key. Character (20)
TYPE Request type:

0 – generic requests

1 – asynchronous requests

2 – intra-reconciliation requests

3 – service deferred requests

 Numeric
OPERATION Type of operation:

0 – No operation

1 – Add request

2 – Modify request

3 – Delete request

4 – Suspend request

5 – Restore request

6 – Change password request

 Numeric
REQUEST_TIME Time that the request was made. Date
EXPIRATION_TIME Time that the request expires. If null, the request never expires. Date
TARGET The owner of the account for an add request or the account distinguished name for other types of operations. Character (2000)
SERVICE_DN* The distinguished name of the service instance in the directory. Character (2000)
DATA The data for the request (attribute values for Add and Modify requests). This information is a serialized Java™ Collection and is Base64 encoded and GZIP compressed. Long Character
CONNECTION_POINT The callback to complete the workflow process. This information is a serialized Java object. Binary

* Indicates the column is required and not null.