Asset Group Rule Attribute
The Asset Group Rule Attribute view object contains information about the group number to which the asset is assigned. An asset could be assigned to single or multiple groups based on the rule the group is set up on.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetGroupRuleAttributeExtractPVO
Primary Keys : RuleAttributeId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the asset group number descriptive flexfield. |
| AttributeChar1 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar10 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar11 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar12 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar13 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar14 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar15 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar16 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar17 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar18 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar19 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar2 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar20 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar3 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar4 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar5 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar6 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar7 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar8 | Character segment for the asset group number descriptive flexfield. |
| AttributeChar9 | Character segment for the asset group number descriptive flexfield. |
| AttributeCode | Code segment for the asset group number descriptive flexfield. |
| AttributeDate1 | Date segment for the asset group number descriptive flexfield. |
| AttributeDate2 | Date segment for the asset group number descriptive flexfield. |
| AttributeDate3 | Date segment for the asset group number descriptive flexfield. |
| AttributeDate4 | Date segment for the asset group number descriptive flexfield. |
| AttributeDate5 | Date segment for the asset group number descriptive flexfield. |
| AttributeNumber1 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber10 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber2 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber3 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber4 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber5 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber6 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber7 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber8 | Number segment for the asset group number descriptive flexfield. |
| AttributeNumber9 | Number segment for the asset group number descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the asset group number descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the asset group number descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the asset group number descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the asset group number descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the asset group number descriptive flexfield. |
| ColumnName | Name of the column from which the attribute is pulled for grouping and validations. |
| CreatedBy | User who created the asset group number record. |
| CreationDate | Date and time when the user created the asset group number record. |
| DataTypeCode | Value of the data type of the pk_column_name attribute. |
| EntityCode | Values that specifies the entity from which the attribute is to be used for grouping. The entity could be the asset itself or any other referential entity on which a foreign key exist in the asset. |
| EntityObjectAttribute | Name of the entity object attribute. |
| EntityObjectName | Name of the entity object that's constructed on top of the de-formalized assets view - CSE_ASSETS_FLAT_V. |
| EntityObjectPkAttribute | Name of the primary key attribute in the entity object. |
| LastUpdateDate | Date and time when the user most recently updated the asset group number record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the asset group number record. |
| LastUpdatedBy | User who most recently updated the asset group number record. |
| ObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| PkColumnName | Primary key column name in CSE_ASSETS_FLAT_V table that can be used to drive the grouping of assets. |
| PrimaryFlag | Indicates whether the attribute is primarily drawn from the asset business object. A change in the primary attribute on the asset affects the membership of the group. |
| RangeFlag | Indicates whether the grouping criteria is driven by the range values. |
| RuleAttributeId | This is the foreign key to the grouping rule attribute identifier of the Asset Group Rule Attribute view object. |
| RuleId | This is the foreign key to the rule identifier of the Asset Group Rule Attribute view object. |
| SequenceNumber | Value that indicates the order of the attributes to be used in the grouping criteria. |
| TableName | Name of the table. The attribute reference from the physical table used in constructing the group by clause in the query. |
| ValueId | The foreign key reference to the value identifier from the value set where the seed data for the attribute is stored. |