DUBBER Dimension Tables | |||
DUBBERDUBPOINTDIMENSION | |||
| # | Column Name | Snowflake Type | Description |
|---|---|---|---|
| 1 | DDPD_ID | NUMBER(38,0) | Primary key |
| 2 | DDPD_DUBPOINTID | VARCHAR(64) | The DUB Point unique identifier |
| 3 | DDPD_TYPE | VARCHAR(64) | DUB Point type |
| 4 | DDPD_LABEL | VARCHAR(64) | DUB Point label |
| 5 | DDPD_STATUS | VARCHAR(64) | DUB Point status |
| 6 | DDPD_USER | VARCHAR(256) | The user identifier on which the DUB point assigned to |
| 7 | DDPD_AI | BOOLEAN | Indicates if AI enabled/disabled |
| 8 | DDPD_PLAYBACK | BOOLEAN | Indicates if playback enabled/disabled |
| 9 | DDPD_PRODUCT | VARCHAR(64) | Product name |
| 10 | DDPD_SERVICEPROVIDER | VARCHAR(32) | The service provider identifier |
| 11 | DDPD_EXTERNALTYPE | VARCHAR(64) | External type - BroadWorks |
| 12 | DDPD_EXTERNALGROUP | VARCHAR(64) | The broadsoft group identifier |
| 13 | DDPD_EXTERNALIDENTIFIER | VARCHAR(64) | The broadsoft user identifier |
| 14 | DDPD_EIPID | VARCHAR(16) | The EIP account identifier |
| 15 | DDPD_PARENTEIPID | VARCHAR(16) | The parent account identifier |
DUBBER Fact Tables | ||||
DUBBERCALLRECORDINGFACT | ||||
| # | Column Name | Snowflake Type | Description | References |
|---|---|---|---|---|
| 1 | CRF_ID | NUMBER(38,0) | Primary key | |
| 2 | CRF_RECORDINGID | NUMBER(38,0) | The recording unique identifier | |
| 3 | CRF_DUBPOINTID | VARCHAR(20) | The DUB point unique identifier | |
| 4 | CRF_EXTERNALCALLID | VARCHAR(162) | The external call identifier (related to BroadWorks) | |
| 5 | CRF_EXTERNALUSERID | VARCHAR(161) | The external user identifier (BroadWorks User) | |
| 6 | CRF_EXTERNALGROUPID | VARCHAR(25) | The external group identifier (BroadWorks group) | |
| 7 | CRF_EXTERNALSERVICEPROVIDER | VARCHAR(25) | The external service provider identifier (EIP enterprise identifier) | |
| 8 | CRF_NAME | VARCHAR(65) | Recording name | |
| 9 | CRF_TYPE | VARCHAR(15) | Recording type | |
| 10 | CRF_DIRECTION | VARCHAR(15) | Call direction: inbound/outbound | |
| 11 | CRF_OTHERPARTICIPANT | VARCHAR(162) | Other participants | |
| 12 | CRF_DURATION | NUMBER(38,0) | Recording duration | |
| 13 | CRF_DATETIMECREATED | TIMESTAMP_TZ(9) | Recording creation timestamp | |
| 14 | CRF_DATECREATED | VARCHAR(10) | Recording creation date | |
| 15 | CRF_TIMECREATED | VARCHAR(8) | Recording creation time | |
| 16 | CRF_SENTIMENTLABEL | VARCHAR(15) | Sentimental label: positive, negative or neutral | |
| 17 | CRF_SENTIMENTSCORE | NUMBER(8,6) | Sentimental score | |
| 18 | CRF_JOY | NUMBER(8,6) | Joy tone label from 0 to 1 | |
| 19 | CRF_CONFIDENT | NUMBER(8,6) | Confident tone label from 0 to 1 | |
| 20 | CRF_ANGER | NUMBER(8,6) | Anger oy tone label from 0 to 1 | |
| 21 | CRF_SADNESS | NUMBER(8,6) | Sadness tone label from 0 to 1 | |
| 22 | CRF_TENTATIVE | NUMBER(8,6) | Tentative tone label from 0 to 1 | |
| 23 | CRF_ANALYTICAL | NUMBER(8,6) | Analytical tone label from 0 to 1 | |
| 24 | CRF_FEAR | NUMBER(8,6) | Fear tone label from 0 to 1 | |
| 25 | CRF_EXCITED | NUMBER(8,6) | Exited tone label from 0 to 1 | |
| 26 | CRF_SATISFIED | NUMBER(8,6) | Satisfied tone label from 0 to 1 | |
| 27 | CRF_FRUSTRATED | NUMBER(8,6) | Frustrated tone label from 0 to 1 | |
| 28 | CRF_SAD | NUMBER(8,6) | Sad tone label from 0 to 1 | |
| 29 | CRF_SYMPATHETIC | NUMBER(8,6) | Sympathetic tone label from 0 to 1 | |
| 30 | CRF_POLITE | NUMBER(8,6) | Polite tone label from 0 to 1 | |
| 31 | CRF_IMPOLITE | NUMBER(8,6) | Impolite tone label from 0 to 1 | |
| 32 | CRF_TAGS | VARCHAR(256) | Recording tags | |
| 33 | CRF_DATECREATEDUTC | NUMBER(38,0) | Foreign key to the date in UTC time | DateDimension |
| 34 | CRF_TIMECREATEDUTC | NUMBER(38,0) | Foreign key to the recording creation time of day in UTC time | TimeOfDayDimension |
| 35 | CRF_DUBPOINTFK | NUMBER(38,0) | Foreign key to DUB point | DUBBERDUBPOINTDIMENSION |