/
Data Conversion - Data Grooming

Data Conversion - Data Grooming

Owned by Matthew Garrett
Last updated: Oct 17, 2021
4 min read

Article Index

Data Conversion Data Grooming Process

In the Framework application Framework Advanced Register Management (FWARM), a register has been created which lists basic information that should be updated for jobs that have been converted into Framework from another system (i.e. Databuild).  This register includes the following basic content:

  • Job Number – locked and for information only

  • Client Name

  • Lot #

  • Land Street Address

  • Land Street Number

  • Land Suburb

  • Land Postcode

  • Sale Reported

  • Initial Deposit

  • Pre-Admin Administrator

  • PreAdministration Complete Date

  • Admin Administrator

  • Contract Signed Date

  • Contract Amount ex GST – note that this and the Contract GST Amount and Contract Amount inc GST figures MUST all add up to the calculated figure

  • Contract GST Amount – note that this and the Contract Amount ex GST and Contract Amount inc GST figures MUST all add up to the calculated figure

  • Contract Amount inc GST – note that this and the Contract Amount ex GST Amount and Contract GST Amount figures MUST all add up to the calculated figure

  • Administration Complete Date

  • Construction Manager

  • Construction Supervisor

  • Construction Administrator

  • Site Start Date

  • Base Complete Date

  • Frame Complete Date

  • Fix Complete Date

  • Lockup Complete Date

  • PCI Complete Date

  • Settlement Date

  • Construction Complete Date

  • DLP Expiry Complete

Updating this data across the converted jobs will include basic information required against a job and also ensure that it is in the correct Work Flow stage for reporting purposes.  Updating data into these fields within FWARM will result in the data being updated immediately into Framework.

Data Grooming

Running the Register in FWARM to commence the data entry for data grooming

  1. Log into FWARM and select “Register” from the two options on the Home page:




  2. Select the “Data Conversion Data Grooming Register” Workbook and “Data Conversion Data Grooming Register“ worksheet as per the below two screen shots.  Then hit the Refresh button.







  3. A list of all the converted jobs will appear




  4. Start entering the data for the selected jobs in the fields listed.  Any field shaded yellow (i.e. job number) is just shown on the Register for information purposes and cannot be edited/updated.



If you would like to add fields to the Register to capture additional content as part of the data grooming of the jobs or remove any fields as they are not required, please advise the Insula consultant and they will update the Register.



REPORTING

Once the data entry has been completed for the jobs, run the update Work Flow stage database tool in Framework. 

  1. From the File menu, select "Database Tools".


     

  2. Select "Update Workflow Stage" from the left and on the right, click on the arrow next to "Apply To" and select "All Jobs".  Click "Start" to apply the update



The following reports can then be run to confirm that all jobs are sitting in their correct Work Flow stage:

Pre-Administration

Report Profile #136 – Work Flow:  Pre-Administration Overview

 

Administration

Report Profile Work Flow: Admin Overview - A3



Construction

Report Profile Work Flow:  A3 Construction Overview