PROJ_VIEW_NO Integer 10 0 Foreign key. Unique identifier for the Project to O / O this attribute is attached if it is a project attribute, null otherwise. ORDER_ID String 8 - Foreign key. The unique ConSol order ID to which O / O this attribute is attached if it is a order attribute, null otherwise. ORDER_ITEM_NO Integer 10 - 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. ATTRIBUTE_TYPE_NO Integer 10 0 Foreign key. Uniquely identifies the attribute type. O / M ATTRIBUTE_LIST_NO Integer 10 0 Foreign key. Uniquely identifies the attribute list O / O value. ATTRIBUTE_NAME String 64 - The name of the attribute whose value was changed. O / M DATA_TYPE String 15 - ConSol currently supports five distinct data types for O / M attributes. These are: a string of text that ‘text’ – accepts most character values; a date in ‘date’ – format; a defined list of coded ‘list’ – values and descriptions; numeric value ‘currency’ – in currency format ($9999.99); and ‘number’ – numeric value. ATTRIBUTE_VALUE String 255 - The Attribute Value O / O 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. (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Rules Extract includes current attribute value for each entity Each record will only have one of Proj_View_No, Order_id or Order_item_no populated
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 order ID to which this attribute is attached if it is a order attribute, null otherwise. O / O ORDER_ITEM_NO Integer 10 - 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 ATTRIBUTE_TYPE_NO Integer 10 0 Foreign key. Uniquely identifies the attribute type. O / M ATTRIBUTE_LIST_NO Integer 10 0 Foreign key. Uniquely identifies the attribute list value. O / O ATTRIBUTE_NAME String 64 - The name of the attribute whose value was changed. O / M DATA_TYPE String 15 - ConSol currently supports five distinct data types for attributes. These are: ‘text’ – a string of text that accepts most character values; ‘date’ – a date in format; ‘list’ – a defined list of coded values and descriptions; ‘currency’ – numeric value in currency format ($9999.99); and ‘number’ – numeric value. O / M ATTRIBUTE_VALUE String 255 - The Attribute Value O / O 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 (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Rules Extract includes current attribute value for each entity Each record will only have one of Proj_View_No, Order_id or Order_item_no populated
ConSol_Datamart_Specification_v5.1.docx