Design Rules: The extract will include duplicate for every Item that has one or more variations generated during the processing window Attribute History Extract Delta This is a table of all attribute changes that occurred within the processing window Data Dictionary Mandatory Field Name Type Length Precision Format Description DB / App PROJ_VIEW_NO Integer 10 0 Unique identifier for the Project to O / O Foreign key. this attribute is attached, if it is a project attribute, null otherwise. ORDER_ID String 8 - Foreign key. The unique ConSol ID to which this O / O attribute is attached, if it is an order attribute, null otherwise. ORDER_ITEM_NO Integer 10 0 Foreign key. A unique identifier for the order item O / O to which this attribute is attached if it is an item attribute, null otherwise. HISTORY_DATE Date 23 - yyyy/mm/dd The date and time at the attribute value was M / M hh:mm:ss updated. UPDATE_USER String 71 - The full name of the user who made the attribute O / M change ATTRIBUTE_NAME String 32 - The name of the attribute value was changed. M / M ATTRIBUTE_VALUE String 4000 - The that was set on the attribute. O / M DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the M / M hh:mm:ss Datamart at defined intervals. This field indicates the date at which this record was read from the application.
Design Rules: The extract will include duplicate for every Item that has one or more variations generated during the processing window Attribute History Extract Delta This is a table of all attribute changes that occurred within the processing window Data Dictionary Field Name Type Length Precision Format Description Mandatory DB / App PROJ_VIEW_NO Integer 10 0 Foreign key. Unique identifier for the Project to this attribute is attached, if it is a project attribute, null otherwise. O / O ORDER_ID String 8 - Foreign key. The unique ConSol ID to which this attribute is attached, if it is an order attribute, null otherwise. O / O ORDER_ITEM_NO Integer 10 0 Foreign key. A unique identifier for the order item to which this attribute is attached if it is an item attribute, null otherwise. O / O HISTORY_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date and time at the attribute value was updated. M / M UPDATE_USER String 71 - The full name of the user who made the attribute change O / M ATTRIBUTE_NAME String 32 - The name of the attribute value was changed. M / M ATTRIBUTE_VALUE String 4000 - The that was set on the attribute. O / M DATA_REFRESH_DATE Date 23 - yyyy/mm/dd hh:mm:ss Data propagates from the application to the Datamart at defined intervals. This field indicates the date at which this record was read from the application. M / M