Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value

Table SDR_EXT_REQUEST_FACT

Description

Introduced: 8.5.004.09. Supported in Genesys Cloud deployments only.
Modified: 8.5.010.16 (UPDATE_AUDIT_KEY added)

In partitioned databases, this table is partitioned.


Each row in this table describes a particular invocation of an external service, starting when the request was made and ending with the outcome of the service.

Column List

Legend

Column Data Type P M F DV

CREATE_AUDIT_KEY

numeric(19) X X

SESSION_ID

varchar(50) X X

START_DATE_TIME_KEY

integer X X X

SEQUENCE_ID

integer X X

START_TS_MS

numeric(19) X

DURATION_MS

numeric(19) X 0

SDR_EXT_REQUEST_KEY

integer X X -2

SDR_EXT_HTTP_REST_KEY

integer X X -2

SDR_EXT_REQUEST_OUTCOME_KEY

integer X X -2

SDR_EXT_SERVICE_OUTCOME_KEY

integer X X -2

SDR_APPLICATION_KEY

integer X X -2

UPDATE_AUDIT_KEY

numeric(19) X

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.

SESSION_ID

The ORS session ID. You can use the SESSION_ID to link the SDR_EXT_REQUEST_FACT record with an SDR_SESSION_FACT.

START_DATE_TIME_KEY

Identifies the start of a 15-minute interval in which the fact began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension.

SEQUENCE_ID

The unique identifier of the external request block within the SDR. In combination with SESSION_ID, the SEQUENCE_ID forms a value of the composite primary key for this table.

START_TS_MS

The UTC-equivalent value, in milliseconds, of the date and time at which the request for an external service was submitted.

DURATION_MS

The duration, in milliseconds, of the external service.

SDR_EXT_REQUEST_KEY

The surrogate key that is used to join this table to the SDR_EXT_REQUEST dimension, to identify the external request.

SDR_EXT_HTTP_REST_KEY

The surrogate key that is used to join this table to the SDR_EXT_HTTP_REST dimension, to identify the external request.

SDR_EXT_REQUEST_OUTCOME_KEY

The surrogate key that is used to join this table to the SDR_EXT_REQUEST_OUTCOME dimension, to identify the outcome of the external request.

SDR_EXT_SERVICE_OUTCOME_KEY

The surrogate key that is used to join this table to the SDR_EXT_SERVICE_OUTCOME dimension, to identify the outcome of the external service.

SDR_APPLICATION_KEY

The surrogate key that is used to join this table to the SDR_APPLICATION dimension, to identify the Designer application that managed the session.

UPDATE_AUDIT_KEY

Introduced: Release 8.5.010.16
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.


Index List

CODE U C Description

I_SDR_EXT_REQUEST_FACT_SDT

Improves access time, based on the Start Date Time key.

Index I_SDR_EXT_REQUEST_FACT_SDT

Field Sort Comment
START_DATE_TIME_KEY Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 28 March 2017, at 22:41.