Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table SM_RES_STATE_REASON_FACT =
 
= Table SM_RES_STATE_REASON_FACT =
  
 +
{{PDMColumn
 +
|colName=SM_RES_STATE_REASON_FACT_KEY
 +
|colDesc=The primary key of this table. This value is generated by the database. This key determines the state reason sequence in the scenario when more than one reason occur within a period of one second for the same agent on the same media.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TENANT_KEY
 +
|colDesc=The surrogate key that is used to join this table to the TENANT dimension, to identify a specific tenant to which the agent belongs.
 +
}}
 +
 +
{{PDMColumn
 +
|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--that is, applications that need to identify newly added data.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=UPDATE_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 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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=START_DATE_TIME_KEY
 +
|colDesc=Identifies the start of a 15-minute interval in which the resource state reason 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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=END_DATE_TIME_KEY
 +
|colDesc=Identifies the start of a 15-minute interval in which the resource state reason 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 END_TS timestamp to an appropriate time zone.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=RESOURCE_STATE_KEY
 +
|colDesc=The surrogate key that is used to join this table to the RESOURCE_STATE dimension, to identify the specific state that is associated with this reason.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=RESOURCE_STATE_REASON_KEY
 +
|colDesc=The surrogate key that is used to join this table to the RESOURCE_STATE_REASON dimension, to identify the hardware or software reason and work mode that are associated with this summarized state reason.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=MEDIA_TYPE_KEY
 +
|colDesc=The surrogate key that is used to join this table to the MEDIA_TYPE dimension, to identify the media type of this state reason.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=RESOURCE_KEY
 +
|colDesc=The surrogate key that is used to join this table to the RESOURCE_ dimension, to identify the agent that is associated with this state reason.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=RESOURCE_GROUP_COMBINATION_KEY
 +
|colDesc=The surrogate key that is used to join records in this table to a specific combination of resource groups in the RESOURCE_GROUP_COMBINATION dimension. This field identifies the groups to which the agent was a member when the resource state reason began.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=SM_RES_SESSION_FACT_SDT_KEY
 +
|colDesc=The value of the START_DATE_TIME_KEY field of the record in the SM_RES_SESSION_FACT table. On a partitioned database, SM_RES_SESSION_FACT_SDT_KEY in combination with SM_RES_
 +
SESSION_FACT_KEY forms a value of the composite primary key for the SM_RES_SESSION_FACT table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=SM_RES_SESSION_FACT_KEY
 +
|colDesc=The value of the primary key of the SM_RES_SESSION_FACT table. This surrogate key is used to join records in this table to the SM_RES_SESSION_FACT table, to associate the summarized state reason of the resource with the summarized login session.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=SM_RES_STATE_FACT_SDT_KEY
 +
|colDesc=The value of the START_DATE_TIME_KEY field of the record in the SM_RES_STATE_FACT table. On a partitioned database, SM_RES_STATE_FACT_SDT_KEY in combination with SM_RES_
 +
STATE_FACT_KEY forms a value of the composite primary key for the SM_RES_STATE_FACT table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=SM_RES_STATE_FACT_KEY
 +
|colDesc=The value of the primary key of the SM_RES_STATE_FACT table. This surrogate key is used to join records in this table to the SM_RES_STATE_FACT dimension table, to associate the summarized state reason of the resource with the summarized state.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=START_TS
 +
|colDesc=The UTC-equivalent value of the date and time at which the resource state reason began.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=END_TS
 +
|colDesc=The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the UTC-equivalent value of the date and time by which the resource state ended. This value results from calculation of the summarized resource state and does not necessarily match the END_TS value in the underlying GIDB table(s). 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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TOTAL_DURATION
 +
|colDesc=The total duration, in seconds, that the resource has been in the state for the prescribed reason, irrespective of the interval(s) in which the state-reason combination may endure.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=LEAD_CLIP_DURATION
 +
|colDesc=For resource states that span multiple time intervals, this field facilitates the aggregation of interval aggregates by providing the lead duration, in seconds, that the resource has been in a particular state for the prescribed reason. This duration is measured from the start of the resource state reason to the end of the first interval.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TRAIL_CLIP_DURATION
 +
|colDesc=For resource states that span multiple time intervals, this field facilitates the aggregation of interval aggregates by providing the trailing duration, in seconds, that the resource has been in a particular state for the prescribed reason. This duration is measured from the start of the last interval to the end of the resource reason state.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=ACTIVE_FLAG
 +
|colDesc=Indicates whether the resource state reason is currently active: 0 = No, 1 = Yes. For completed state reasons, this value is 0.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=PURGE_FLAG
 +
|colDesc=This field is reserved.
 +
}}
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 22:08, May 5, 2016

Table SM_RES_STATE_REASON_FACT

Comments or questions about this documentation? Contact us for support!