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_USER_INPUT

Description

Introduced: 8.5.004.09

In partitioned databases, this table is not partitioned.


This dimension table enables Session Detail Record (SDR) facts to be described based on the type of user input the Application received — voice or DTMF.

Column List

Legend

Column Data Type P M F DV

ID

NUMBER(10) X X

CREATE_AUDIT_KEY

NUMBER(19) X X

USER_INPUT_TYPE

VARCHAR2(50 CHAR) X NO_VALUE

ID


The primary key of this table.

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.

USER_INPUT_TYPE


The manner in which the user provided input. Possible values are:

  • voice
  • DTMF


Index List

CODE U C Description

I_SDR_USER_INPUT

X Ensures that the combinations of values that are stored in the dimension table are unique.

Index I_SDR_USER_INPUT

Field Sort Comment
USER_INPUT_TYPE Ascending

No subject area information available.

 

Comment on this article:

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