Data Dictionary Mandatory Field Name Type Length Precision Format Description DB / App DEL_AUDIT_NO Integer 10 0 Primary key. Unique identifier for each Deleted record M / M TARGET String 32 - The file that the record was deleted from. This will be M / M one of the following: Milestone, Item, Invoice TARGET_KEY String 32 The name of the Foreign key. This will either be M / M Milestone_no, Order_Item_no or Invoice No) TARGET_VALUE String 128 - Foreign key. The ConSol value for the Target Key M / M CONTEXT String 32 - The entity that the deleted item related to Either O / O – Project View or Order CONTEXT_ID String 32 - Either the Order Id or the Project View No O / O Foreign key. that the deleted item related to DELETED_DATE Date 23 - yyyy/mm/dd The date and time at which the deletion occurred M / M hh:mm:ss DELETED_BY String 71 - The full name of the user who undertook the action that M / M triggered the deletion DESCRIPTION String 1000 - Text Description of the action that occurred M / M DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the Datamart at M / M hh:mm:ss 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 list of deleted Invoices, Milestones & Items, where deletion occurred within the processing window. All deleted records can be associated to an Order or PV and if that Order or PV has either been issued to or Issued by the customer, the deleted item would have been included in an extract and should be removed. Records in other extracts that reference the deleted event as a Foreign key should also be deleted
Data Dictionary Field Name Type Length Precision Format Description Mandatory DB / App DEL_AUDIT_NO Integer 10 0 Primary key. Unique identifier for each Deleted record M / M TARGET String 32 - The file that the record was deleted from. This will be one of the following: Milestone, Item, Invoice M / M TARGET_KEY String 32 The name of the Foreign key. This will either be Milestone_no, Order_Item_no or Invoice No) M / M TARGET_VALUE String 128 - Foreign key. The ConSol value for the Target Key M / M CONTEXT String 32 - The entity that the deleted item related to – Either Project View or Order O / O CONTEXT_ID String 32 - Foreign key. Either the Order Id or the Project View No that the deleted item related to O / O DELETED_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date and time at which the deletion occurred M / M DELETED_BY String 71 - The full name of the user who undertook the action that triggered the deletion M / M DESCRIPTION String 1000 - Text Description of the action that occurred M / 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 (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Rules: Extract includes list of deleted Invoices, Milestones & Items, where deletion occurred within the processing window. All deleted records can be associated to an Order or PV and if that Order or PV has either been issued to or Issued by the customer, the deleted item would have been included in an extract and should be removed. Records in other extracts that reference the deleted event as a Foreign key should also be deleted
ConSol_Datamart_Specification_v6.0.docx