Jump to: navigation, search
m (1 revision imported: Cleaned up for It. 6)
(Modified comment string <onlyinclude> with <onlyinclude>)
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
= View RESOURCE_SKILL_FACT =
 
= View RESOURCE_SKILL_FACT =
 
    
 
    
−
  <onlyinclude>
+
<onlyinclude>
−
  {{PDMView
+
{{PDMView
−
  |viewName = RESOURCE_SKILL_FACT
+
|viewName = RESOURCE_SKILL_FACT
−
  |shortDesc =  Describes an agent's skills and proficiency levels.
+
|shortDesc =  Describes an agent's skills and proficiency levels.
−
  |viewDesc =  Each row describes one skill at a particular proficiency level that one agent possesses. The grain of the fact is an accumulating snapshot that represents the duration of the configured skill and proficiency, which are identified by a unique ID in the configuration database.
+
|viewDesc =  Each row describes one skill at a particular proficiency level that one agent possesses. The grain of the fact is an accumulating snapshot that represents the duration of the configured skill and proficiency, which are identified by a unique ID in the configuration database.
−
  |introduced =   
+
|introduced =   
−
  |subjectAreas = Facts,Resource_Skill
+
|subjectAreas = Facts,Resource_Skill
−
  |SQL =  <source lang="xml" enclose="div">select
+
|dataExport = yes
 +
|SQL =  <source lang="xml" enclose="div">select
 
   RESOURCE_SKILL_FACT_KEY,
 
   RESOURCE_SKILL_FACT_KEY,
 
   START_DATE_TIME_KEY,
 
   START_DATE_TIME_KEY,
Line 27: Line 28:
 
   from RESOURCE_SKILL_FACT_
 
   from RESOURCE_SKILL_FACT_
 
   </source>
 
   </source>
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = RESOURCE_SKILL_FACT_KEY
+
|colName = RESOURCE_SKILL_FACT_KEY
−
  |colDesc = The primary key of this view.
+
|colDesc = The primary key of this view.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = START_DATE_TIME_KEY
+
|colName = START_DATE_TIME_KEY
−
  |colDesc = Identifies the start of a 15-minute interval in which the skill at the specified level was added to the resource in the contact center configuration. 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.
+
|colDesc = Identifies the start of a 15-minute interval in which the skill at the specified level was added to the resource in the contact center configuration. 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.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = END_DATE_TIME_KEY
+
|colName = END_DATE_TIME_KEY
−
  |colDesc = Identifies the start of a 15-minute interval in which the skill at the specified level was removed from the resource in the contact center configuration. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts related to the same interval and/or convert the END_TS timestamp to an appropriate time zone.
+
|colDesc = Identifies the start of a 15-minute interval in which the skill at the specified level was removed from the resource in the contact center configuration. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts related to the same interval and/or convert the END_TS timestamp to an appropriate time zone.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = TENANT_KEY
+
|colName = TENANT_KEY
−
  |colDesc = The surrogate key that is used to join the TENANT dimension to the fact tables.
+
|colDesc = The surrogate key that is used to join the TENANT dimension to the fact tables.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = RESOURCE_KEY
+
|colName = RESOURCE_KEY
−
  |colDesc = The surrogate key that is used to join the RESOURCE_ dimension to the fact tables.
+
|colDesc = The surrogate key that is used to join the RESOURCE_ dimension to the fact tables.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = SKILL_KEY
+
|colName = SKILL_KEY
−
  |colDesc = The surrogate key that is used to join the SKILL dimension to the fact tables.
+
|colDesc = The surrogate key that is used to join the SKILL dimension to the fact tables.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = CREATE_AUDIT_KEY
+
|colName = CREATE_AUDIT_KEY
−
  |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 &mdash; that is, applications that need to identify newly added data.
+
|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 &mdash; that is, applications that need to identify newly added data.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = UPDATE_AUDIT_KEY
+
|colName = UPDATE_AUDIT_KEY
−
  |colDesc = The surrogate key used to join to the CTL_AUDIT_LOG dimension. Specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools &mdash; that is, applications that need to identify recently modified data.
+
|colDesc = The surrogate key used to join to the CTL_AUDIT_LOG dimension. Specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools &mdash; that is, applications that need to identify recently modified data.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = START_TS
+
|colName = START_TS
−
  |colDesc = The UTC-equivalent value of the date and time when the skill, at the specified level, was added to the resource in the contact center configuration.
+
|colDesc = The UTC-equivalent value of the date and time when the skill, at the specified level, was added to the resource in the contact center configuration.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = END_TS
+
|colName = END_TS
−
  |colDesc = The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the UTC-equivalent value of the date and time when the skill, at the specified level, was removed from the resource in contact center configuration. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null.
+
|colDesc = The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the UTC-equivalent value of the date and time when the skill, at the specified level, was removed from the resource in contact center configuration. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = TOTAL_DURATION
+
|colName = TOTAL_DURATION
−
  |colDesc = The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the total duration, in seconds, that the resource had the skill at the specified level. For an active row, this field represents the duration, in seconds, that the resource has had the skill at the specified level, from start time to the time that the ETL last executed.
+
|colDesc = The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the total duration, in seconds, that the resource had the skill at the specified level. For an active row, this field represents the duration, in seconds, that the resource has had the skill at the specified level, from start time to the time that the ETL last executed.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = ACTIVE_FLAG
+
|colName = ACTIVE_FLAG
−
  |colDesc = Indicates whether the resource currently has the skill at the specified level: 0 = No, 1 = Yes.
+
|colDesc = Indicates whether the resource currently has the skill at the specified level: 0 = No, 1 = Yes.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = SKILL_LEVEL
+
|colName = SKILL_LEVEL
−
  |colDesc = The skill level or proficiency.
+
|colDesc = The skill level or proficiency.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = PURGE_FLAG
+
|colName = PURGE_FLAG
−
  |colDesc = This field is reserved.
+
|colDesc = This field is reserved.
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentTable = DATE_TIME
+
|parentTable = DATE_TIME
−
  |foreignKey = START_DATE_TIME_KEY
+
|parentColumn = DATE_TIME_KEY
−
  }}
+
|foreignKey = START_DATE_TIME_KEY
−
 
+
}}
−
  {{PDMRef
+
 
−
  |parentTable = DATE_TIME
+
{{PDMRef
−
  |foreignKey = END_DATE_TIME_KEY
+
|parentTable = DATE_TIME
−
  }}
+
|parentColumn = DATE_TIME_KEY
−
 
+
|foreignKey = END_DATE_TIME_KEY
−
  {{PDMRef
+
}}
−
  |parentView = TENANT
+
 
−
  |foreignKey = TENANT_KEY
+
{{PDMRef
−
  }}
+
|parentView = TENANT
−
 
+
|parentColumn = TENANT_KEY
−
  {{PDMRef
+
|foreignKey = TENANT_KEY
−
  |parentTable = RESOURCE_
+
}}
−
  |foreignKey = RESOURCE_KEY
+
 
−
  }}
+
{{PDMRef
−
 
+
|parentTable = RESOURCE_
−
  {{PDMRef
+
|parentColumn = RESOURCE_KEY
−
  |parentTable = SKILL
+
|foreignKey = RESOURCE_KEY
−
  |foreignKey = SKILL_KEY
+
}}
−
  }}
+
 
−
 
+
{{PDMRef
−
  {{PDMRef
+
|parentView = SKILL
−
  |parentTable = CTL_AUDIT_LOG
+
|parentColumn = ID
−
  |foreignKey = CREATE_AUDIT_KEY
+
|foreignKey = SKILL_KEY
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentTable = CTL_AUDIT_LOG
+
|parentTable = CTL_AUDIT_LOG
−
  |foreignKey = UPDATE_AUDIT_KEY
+
|parentColumn = AUDIT_KEY
−
  }}
+
|foreignKey = CREATE_AUDIT_KEY
 +
}}
 +
 
 +
{{PDMRef
 +
|parentTable = CTL_AUDIT_LOG
 +
|parentColumn = AUDIT_KEY
 +
|foreignKey = UPDATE_AUDIT_KEY
 +
}}
 
    
 
    
 
    
 
    

Latest revision as of 22:53, June 16, 2020

View RESOURCE_SKILL_FACT

Description

Each row describes one skill at a particular proficiency level that one agent possesses. The grain of the fact is an accumulating snapshot that represents the duration of the configured skill and proficiency, which are identified by a unique ID in the configuration database.

Column List

Column Description
RESOURCE_SKILL_FACT_KEY The primary key of this view.
START_DATE_TIME_KEY Identifies the start of a 15-minute interval in which the skill at the specified level was added to the resource in the contact center configuration. 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.
END_DATE_TIME_KEY Identifies the start of a 15-minute interval in which the skill at the specified level was removed from the resource in the contact center configuration. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts related to the same interval and/or convert the END_TS timestamp to an appropriate time zone.
TENANT_KEY The surrogate key that is used to join the TENANT dimension to the fact tables.
RESOURCE_KEY The surrogate key that is used to join the RESOURCE_ dimension to the fact tables.
SKILL_KEY The surrogate key that is used to join the SKILL dimension to the fact tables.
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.
UPDATE_AUDIT_KEY The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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.
START_TS The UTC-equivalent value of the date and time when the skill, at the specified level, was added to the resource in the contact center configuration.
END_TS The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the UTC-equivalent value of the date and time when the skill, at the specified level, was removed from the resource in contact center configuration. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null.
TOTAL_DURATION The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the total duration, in seconds, that the resource had the skill at the specified level. For an active row, this field represents the duration, in seconds, that the resource has had the skill at the specified level, from start time to the time that the ETL last executed.
ACTIVE_FLAG Indicates whether the resource currently has the skill at the specified level: 0 = No, 1 = Yes.
SKILL_LEVEL The skill level or proficiency.
PURGE_FLAG This field is reserved.


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
RESOURCE_SKILL_FACT CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
RESOURCE_SKILL_FACT END_DATE_TIME_KEY DATE_TIME DATE_TIME_KEY
RESOURCE_SKILL_FACT RESOURCE_KEY RESOURCE_ RESOURCE_KEY
RESOURCE_SKILL_FACT SKILL_KEY SKILL ID
RESOURCE_SKILL_FACT START_DATE_TIME_KEY DATE_TIME DATE_TIME_KEY
RESOURCE_SKILL_FACT TENANT_KEY TENANT TENANT_KEY
RESOURCE_SKILL_FACT UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
This page was last edited on June 16, 2020, at 22:53.
Comments or questions about this documentation? Contact us for support!