m (1 revision imported: Iteration 7 schema updates) |
m (1 revision imported: Iteration 7 schema updates) |
||
| Line 186: | Line 186: | ||
{{PDMRef | {{PDMRef | ||
|parentTable = INTERACTION_FACT | |parentTable = INTERACTION_FACT | ||
| + | |parentColumn = INTERACTION_ID | ||
|foreignKey = INTERACTION_ID | |foreignKey = INTERACTION_ID | ||
}} | }} | ||
| Line 191: | Line 192: | ||
{{PDMRef | {{PDMRef | ||
|parentView = TENANT | |parentView = TENANT | ||
| + | |parentColumn = TENANT_KEY | ||
|foreignKey = TENANT_KEY | |foreignKey = TENANT_KEY | ||
}} | }} | ||
Revision as of 10:15, August 31, 2017
View CDR
Description
Reserved
Column List
| Column | Description |
|---|---|
| ID | |
| INTERACTION_ID | |
| MEDIA_TYPE | |
| INTERACTION_TYPE | |
| ORIGINATOR | |
| TARGET | |
| PARTY_TYPE | |
| PARTY_NAME | |
| STATUS | |
| START_TS | The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration. |
| END_TS | The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration. |
| TIME_ZONE_CODE | |
| START_DATE_TIME_STRING | |
| END_DATE_TIME_STRING | |
| FIRST_LEG_FLAG | |
| CONNECTED_FLAG | |
| ELAPSED_DURATION | |
| ENGAGE_DURATION | |
| CONFERENCE_ENGAGE_DURATION | |
| CONSULTATION_ENGAGE_DURATION | |
| HOLD_DURATION | |
| ORDINAL | |
| TECHNICAL_RESULT | |
| PARTY_ROLE | |
| TENANT_KEY | The surrogate key that is used to join to the TENANT dimension. |
References
The summary List of References will include the following entries for this table or view:
| Child Table/View | Child Table/View Column | Parent Table/View | Parent Table/View Column |
|---|---|---|---|
| CDR | INTERACTION_ID | INTERACTION_FACT | INTERACTION_ID |
| CDR | TENANT_KEY | TENANT | TENANT_KEY |
Comments or questions about this documentation? Contact us for support!