Jump to: navigation, search
Line 2: Line 2:
  
 
{{PDMColumn
 
{{PDMColumn
−
|colName=RESOURCE_KEY
+
|colName=GROUP_COMBINATION_KEY
−
|colDesc=The primary key that is used to join this table to the RESOURCE_ dimension.
+
|colDesc=The surrogate key that is used to join this dimension with the fact and aggregate tables. All the rows that represent the groups that make up the group combination share the same GROUP_COMBINATION_KEY.
 
}}
 
}}
  
 
{{PDMColumn
 
{{PDMColumn
−
|colName=TENANT_KEY
+
|colName=GROUP_KEY
−
|colDesc=The surrogate key that is used to join this dimension to the TENANT dimension.
+
|colDesc=The surrogate key that is used to join this table to the GROUP_ dimension, to identify one group among the groups that make up the resource group combination.  
 
}}
 
}}
  
 
{{PDMColumn
 
{{PDMColumn
−
|colName=SECTIONNAME
+
|colName=TENANT_KEY
−
|colDesc=The name of the configuration section on the Annex tab of the configuration object in which the specified option is located. This value equals the value of the GC_ANNEX.SECTIONNAME IDB field for a respective DN, Person, or Switch record.
+
|colDesc=The surrogate key that is used to join records in this table to a specific tenant in the TENANT dimension, to identify to which tenant the groups belong.  
−
}}
 
−
 
 
−
{{PDMColumn
 
−
|colName=KEYNAME
 
−
|colDesc=The name of the configuration option that is set on the Annex tab of the configuration object. If the object type is Person, the option specifies the geographical location, business line, or organization structure. This value equals the value of the GC_ANNEX.KEYNAME field in IDB for a respective DN, Person, or Switch record.
 
−
}}
 
−
 
 
−
{{PDMColumn
 
−
|colName=VALUE
 
−
|colDesc=The value of the configuration option that is set on the Annex tab of the configuration object. This value equals the value of the GC_ANNEX.VALUE field in IDB for a respective DN, Person, or Switch record.
 
−
}}
 
−
 
 
−
{{PDMColumn
 
−
|colName=END_TS
 
−
|colDesc=The UTC-equivalent value of the date and time at which the configuration was changed (for example, the option, section, or object was removed). This value equals the value of the GC_ANNEX.DELETED field in IDB for a respective DN, Person, or Switch record.
 
−
}}
 
−
 
 
−
{{PDMColumn
 
−
|colName=CFGOBJECTID
 
−
|colDesc=The DBID of the configuration object. This value equals the value of the GC_ANNEX.CFGOBJECTID field in IDB for a respective DN, Person, or Switch record.
 
−
}}
 
−
 
 
−
{{PDMColumn
 
−
|colName=CFGOBJECTTYPE
 
−
|colDesc=The type of the configuration object. This value equals the value of the GC_ANNEX.CFGOBJECTTYPE field in IDB for a respective DN, Person, or Switch record.
 
 
}}
 
}}
  
Line 49: Line 24:
 
|colName=UPDATE_AUDIT_KEY
 
|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.
 
|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=ACTIVE_FLAG
 
−
|colDesc=Indicates whether the specified configuration option is currently active: 0 = No, 1 = Yes.
 
 
}}
 
}}
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 20:26, May 5, 2016

Table RESOURCE_GROUP_COMBINATION

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