|
|
| Line 1: |
Line 1: |
| − | = Table SDR_SESSION_FACT=
| |
| | | | |
| − | <onlyinclude>
| + | s98x1o3080x5r6fejh6zidwvs99fqor |
| − | {{PDMTable
| |
| − | |tableName = SDR_SESSION_FACT
| |
| − | |shortDesc = Represents caller activity in an SDR application.
| |
| − | |tableDesc = This table describes caller activity within an SDR session.
| |
| − | |subjectAreas = PLACEHOLDER
| |
| − | |introduced = {{Editgrn_open}}8.5.002{{Editgrn_close}}
| |
| − | |modified = {{Editgrn_open}}8.5.003. New dimension keys have been added.{{Editgrn_close}}
| |
| − | |discontinued =
| |
| − | |group = SDR
| |
| − | |partitioned = yes
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = CREATE_AUDIT_KEY
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = 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.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SESSION_ID
| |
| − | |dataType_Ora = VARCHAR2(50 CHAR)
| |
| − | |dataType_MSSQL = varchar(50)
| |
| − | |dataType_Postgre = varchar(50)
| |
| − | |primaryKey = yes
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = Session ID as assigned {{Editgrn_open}}(to the call?){{Editgrn_close}} by Orchestration Server.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = INTERACTION_ID
| |
| − | |dataType_Ora = VARCHAR2(50 CHAR)
| |
| − | |dataType_MSSQL = varchar(50)
| |
| − | |dataType_Postgre = varchar(50)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The unique identifier of the interaction, as assigned by SIP Server.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = CONNECTION_ID
| |
| − | |dataType_Ora = VARCHAR2(255 CHAR)
| |
| − | |dataType_MSSQL = varchar(255)
| |
| − | |dataType_Postgre = varchar(255)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = NO_VALUE
| |
| − | |colDesc = The connection ID of the call.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = ANI
| |
| − | |dataType_Ora = VARCHAR2(50 CHAR)
| |
| − | |dataType_MSSQL = varchar(50)
| |
| − | |dataType_Postgre = varchar(50)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = NO_VALUE
| |
| − | |colDesc = The phone number of the caller.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = AS_DURATION_MS
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Duration, in miliseconds, of the Assisted Service phase.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SS_DURATION_MS
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = Duration, in miliseconds, of the Self-Service phase.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = START_TS_MS
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The timestamp (in what format?), with millisecond precision, of the date and time at which the call or the application started.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = END_TS_MS
| |
| − | |dataType_Ora = NUMBER(19)
| |
| − | |dataType_MSSQL = numeric(19)
| |
| − | |dataType_Postgre = numeric(19)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default =
| |
| − | |colDesc = The timestamp (in what format?), with millisecond precision, of the date and time at which the call or the application completed.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = START_DATE_TIME_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey = yes
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = Identifies the start of a 15-minute interval in which the call began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = END_DATE_TIME_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = Identifies the start of a 15-minute interval in which the call ended. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = INPUT_COUNT
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The number of user input blocks the caller encountered (during the call? session?).
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = MENU_COUNT
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = 0
| |
| − | |colDesc = The number of menu blocks the caller encountered (during the call? session?).
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = DTMF_PATH
| |
| − | |dataType_Ora = VARCHAR2(255 CHAR)
| |
| − | |dataType_MSSQL = varchar(255)
| |
| − | |dataType_Postgre = varchar(255)
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey =
| |
| − | |default = NO_VALUE
| |
| − | |colDesc = The sequence of DTMF keys that the caller pressed when going through the application's menu.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_ENTRY_POINT_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_ENTRY_POINT dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_EXIT_POINT_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_EXIT_POINT dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_APPLICATION_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_APPLICATION dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_GEO_LOCATION_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_GEO_LOCATION dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_LANGUAGE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_LANGUAGE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = STRIKEOUT_SDR_MILESTONE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the STRIKEOUT milestone value in the SDR_MILESTONE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = BAILOUT_SDR_MILESTONE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the BAILOUT milestone value in the SDR_MILESTONE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = DEFLECTION_SDR_MILESTONE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the DEFLECTION milestone value in the SDR_MILESTONE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = FINAL_SDR_MILESTONE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the FINAL milestone value in the SDR_MILESTONE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SELF_HELPED_SDR_MILESTONE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory =
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SELF_HELPED milestone value in the SDR_MILESTONE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = DEFLECTION_SDR_MESSAGE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the DEFLECTION_MESSAGE value in the SDR_MESSAGE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_CALL_DISPOSITION_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_CALL_DISPOSITION dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMColumn
| |
| − | |colName = SDR_CALL_TYPE_KEY
| |
| − | |dataType_Ora = NUMBER(10)
| |
| − | |dataType_MSSQL = int
| |
| − | |dataType_Postgre = integer
| |
| − | |primaryKey =
| |
| − | |mandatory = yes
| |
| − | |foreignKey = yes
| |
| − | |default =
| |
| − | |colDesc = The key that is used to join the SDR_CALL_TYPE dimension to the fact tables.
| |
| − | |introduced =
| |
| − | |modified =
| |
| − | |discontinued =
| |
| − | }}
| |
| − | | |
| − | {{PDMIndex}}
| |
| − | {{PDMIndexItem
| |
| − | |indexName = I_SDR_SESSION_FACT_SDT
| |
| − | |indexDesc = Improves access time, based on the Start Date Time key.
| |
| − | |indexPresentInPartitioned = yes
| |
| − | |indexKey = START_DATE_TIME_KEY
| |
| − | |keyPresentInNonpartitioned = yes
| |
| − | |sort = Ascending
| |
| − | |unique =
| |
| − | |cluster =
| |
| − | }}
| |
| − | | |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = DATE_TIME
| |
| − | |foreignKey = START_DATE_TIME_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = DATE_TIME
| |
| − | |foreignKey = END_DATE_TIME_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_ENTRY_POINT
| |
| − | |foreignKey = SDR_ENTRY_POINT_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_EXIT_POINT
| |
| − | |foreignKey = SDR_EXIT_POINT_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_APPLICATION
| |
| − | |foreignKey = SDR_APPLICATION_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_GEO_LOCATION
| |
| − | |foreignKey = SDR_GEO_LOCATION_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_LANGUAGE
| |
| − | |foreignKey = SDR_LANGUAGE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_MILESTONE
| |
| − | |foreignKey = STRIKEOUT_SDR_MILESTONE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_MILESTONE
| |
| − | |foreignKey = BAILOUT_SDR_MILESTONE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_MILESTONE
| |
| − | |foreignKey = DEFLECTION_SDR_MILESTONE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_MILESTONE
| |
| − | |foreignKey = FINAL_SDR_MILESTONE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_MILESTONE
| |
| − | |foreignKey = SELF_HELPED_SDR_MILESTONE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_MESSAGE
| |
| − | |foreignKey = DEFLECTION_SDR_MESSAGE_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = SDR_CALL_DISPOSITION
| |
| − | |foreignKey = SDR_CALL_DISPOSITION_KEY
| |
| − | }}
| |
| − | | |
| − | {{PDMRef
| |
| − | |parentTable = CALL_TYPE
| |
| − | |foreignKey = SDR_CALL_TYPE_KEY
| |
| − | }}
| |
| − | | |
| − | </onlyinclude>
| |
| − | [[Category:V:GIM:8.5DRAFT]]
| |
