Overview
Advanced analytics is an optional add-on module to Manufacton which allows companies to gain access to additional Manufacton Data through a MySQL database:
- Combine manufacton data with any other source (Financial data, project data, etc.)
- Analyze prefab shop’s backlog
- Identify which assemblies are produced most or least efficiently
- Visualize usage trends of materials
- Identify opportunities to standardize materials and assemblies.
This KB Article covers the following topics:
- Connecting to your Database
- Details
Connecting to your Database
Once Analytics has been enabled a new sub-tab will be created:
- Select App & Project Setup
- Select Manufacton Settings
- Select Analytics (the new sub-tab)
- The credentials for your database will be provided on the left pane
- Host (in Amazon Web Services)
- Username
- Password
- Database name
- A list of available tables will be shown on the right pane
Various analytic tools connect in various ways, the example below shows how a connection to your database would be made in Microsoft's PowerBI:
- Select Get Data (you may have to select "more..." from the initial dropdown list to get to the Get Data dialog shown in step 2)
- Select MySQL Database
- Enter the Server Name (aka "Host/URL") and Database provided from step 4 above
- Select Database to enter the credentials
- Enter the User Name and Password provided from step 4 above
NOTES: One of the most common mistakes on step 4 Entering
Windows Credentials rather than Database Credentials
You must select Database and enter the
credentials there!
_______________________________________________________
Before you can connect to a MySQL database, you need to
install MySQL Connector for Microsoft Windows
on your computer.
Details
The Analytics Module enables three critical requirements.
-
Standardizes the Manufacton data
- Allowing access to key data and metrics from Manufacton in a standard MySQL environment,
- Enables any desired 3rd party tool to be used
- Allowing Manufacton data to be accessed and extracted as needed.
- Allows Manufacton data to be merged with other data sources
- Allowing for the creation of simple dashboards, complex analytics combined with other data sources, or other requirements.
Here's a list and definition of the tables and columns Manufacton publishes:
Tables
Production Tables
Manufacton_v2 production_orders - Production Orders from Supply Chain Manager
Manufacton_v2 production_ runs_items - Production Work Steps and Item data
Manufacton_v2_material_requisition - Material item request data
Manufacton_v2 shipping_items - Items within Shipping Orders
Manufacton_v2 shipping_orders - Shipping Orders from Supply Chain Manager
Manufacton_v2_weld_information - Weld Information data
Material Catalog/Inventory Tables
Manufacton_v2 catalog_parts - Parts from the Parts Catalog
Manufacton_v2 catalog_assembly - Assemblies from the Assembly Catalog
Manufacton_v2 material_items - Material Items from Supply Chain Manager (Individual Item list)
Manufacton_v2 material_orders- Material Orders from Supply Chain Manager
Manufacton_v2 Inventory - Prefab and Materials in Inventory
Manufacton_v2 Locations - Company, Common and Project Location data
Form Tables
Manufacton_v2 forms - Standard and QA/QC Forms Templates that have been created
Manufacton_v2 questions - The list of questions available within standard forms
Manufacton_v2 answers - Every answer which has been provided for a question within a standard form
Manufacton_v2 qaQcQuestions - Every QA/QC check available within QA/QC Forms
Manufacton_v2 qaQcAnswers - Every answer which has been provided for a question within a QA/QC form
Other Tables
Manufacton_v2 projects - Company Projects
Manufacton_v2 qrs - QR strings for Items, Production Orders, and Shipping Orders
Columns
Production Orders ("Manufacton_v2 production_orders")
| Column Name | Description | Data Type |
|
activity |
The Activity field. If using Primavera Cloud, this is the schedule activity | Text |
|
actual |
The actual number of seconds recorded towards a Work Step | Number |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the order's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| batch_id | The Lot/Batch/Release # field | Text |
| budgeted | The planned number of seconds for a Work Step | Number |
| company | The company associated with the production order | Text |
| coordinated_at | The actual date that the Production Order moved to Detailing | Date |
| coordination | The planned date that the Production Order should move to Detailing | Date |
| created | The date on which the production order was created | Date |
| detail_by | The planned date that the Production Order should move to Manufacturing | Date |
| detailed_at | The actual date that the Production Order moved to Manufacturing | Date |
| id | A system-generated, unique number for each Order | Number |
| item_perc | The percentage of items that have been completed | Number |
| kit_id | The Kit's ID that the Production Order is a part of | Text |
| level | The Production Order's "Level" | Text |
| location | The current location of the Production Order | Text |
| manufacture_by | The planned date that the Production Order should move to QA or Shipping | Date |
| manufactured_at | The actual date that the Production Order moved to QA or Shipping | Date |
| modified | The most recent date on which the order was updated | Date |
| mongo_id | A system-generated unique id from the Manufacton database to identify the order (used to link to the Production Run-Items Table) | Text |
| name | The name of the Production Order | Text |
| notes | Production Order notes | Text |
| on_site_at | The actual date that the Production Order was marked complete | Date |
| onsite | The planned date that the Production Order should be marked complete | Date |
| order_id | The Production Order's ID | Text |
| owner | The current owner of the Production Order | Text |
| perComplete | The percentage of Work Steps that have been completed | Number |
| pf | The productivity factor of the Production Order | Number |
| productivity_enabled | Indicates whether productivity tracking has been enabled for a Production Order (0="no", 1="yes") | Text |
| project | The name of the project in which the Production Order is a part | Text |
| project_id | The mongo_id of the project to which the Production Order belongs | Text |
| qa_by | The planned date that the Production Order should move to from QA to Shipping | Date |
| qaed_at | The actual date that the Production Order moved from QA to Shipping | Date |
|
qr_code_string |
Universal QR Code string - enables sharing QR code with other applications |
Text |
| runs_perc | The percentage of Work Steps that have been completed | Number |
| stage | The current stage of the Production Order | Text |
| status | The current status of the Production Order | Text |
| updated_on | The date on which the Production Order was last updated in the MySQL database | Date |
| zone | The Production Order's "Zone" | Text |
Production Run-Items ("Manufacton_v2 production_ runs_items")
| Column Name | Description | Data Type |
| actual | The actual number of seconds recorded toward a Work Step | Number |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the Work Step or item's creation date. | Date |
| budgeted | The planned number of seconds to complete the Work Step for an item | Number |
| completed_at | The date on which the Work Step was completed | Date |
| id | A system-generated, unique number for each Order | Number |
| item_id | The ID of the item | Text |
| item_meaure | The measure value of the item | Number |
| item_measure_units | The measure unit of the item | Text |
| item_name | The item name | Text |
| item_notes | Item notes | Text |
| item_stage | The stage of the order in which the item exists | Text |
| item_status | The status of the order in which the item exists | Text |
| manager_created | The date the production order in which the item exists was created | Date |
| order_archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| order_id | The ID of the order in which the item exists | Text |
| order_mongo_id | A system-generated unique id from the Manufacton database to identify the order (used to link to the Production Order Table) | Text |
| order_name | The name of the order in which the item exists | Text |
| perc_complete | The percent complete of the run-item | Number |
| pf | The productivity factor of the run-item | Number |
| project | The project associated with the run-item | Text |
| project_id | The mongo_id of the project to which the run-item belongs | Text |
| quantity | The number of items in the Work Step | Number |
|
qr_code_string |
Universal QR Code string - enables sharing a QR code with other applications |
Text |
| run_end_by | The date on which a Work Step should be completed | Date |
| run_id | A system-generated, unique number for each Work Step | Text |
| run_location | The location in which the Work Step should be performed | Text |
| run_name | The name of the Work Step | Text |
| run_owner | The "Owner" of the Work Step | Text |
| run_sequence | The Work Step's sequence within an Order | Number |
| run_start_by | The date on which a Work Step should be started | Date |
| updated_on | The date on which the run-item was last updated in the MySQL database | Date |
Material Requisition (Manufacton_v2_material_requisition")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the material item's creation date. | Date |
| cat_id | The Catalog ID of each part | Text |
| cost_code | The cost code of each part | Text |
| id | A system-generated, unique number for each Order | Number |
| item_status | The status of the order in which the item exists | Text |
| material_item_id | The ID of the item | Text |
| material_item_mongo_id | A system-generated unique id from the Manufacton database to identify the item | Text |
| material_item_name | The item name | Text |
| meaure | The measure value of the item | Number |
| measure_units | The measure unit of the item | Text |
| onsite | The planned delivery date for the material item | Date |
| po_mongo_id | The Production Order's mongo id (used to link the Material Requisition table to the Production Order table) | Text |
| project_mongo_id | The mongo_id of the project to which the material item belongs | Text |
| project_name | The name of the project to which the material item belongs | Text |
| quantity | The quantity of the material item | Number |
| requisition_order_kit_id | The Kit ID to which the material requisition order is related | Text |
| requisition_order_mongo_id | A system-generated unique id from the Manufacton database to identify the requisition material order to which the item is related | Text |
| requisition_order_name | The name of the requisition material order to which the item is related | Text |
| requisition_order_status | The status of the requisition order to which the material item belongs ("active"/"archived") | Text |
| stage | The stage that the item is currently in | text |
| updated_on | The date on which the material item was last updated in the MySQL database | Date |
Shipping Items ("Manufacton_v2 shipping_items")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the form's creation date. | Date |
| catalog_id | The item's Catalog ID | Text |
| id | A system-generated, unique number for each item | Number |
| install_locations | The value of the items "Installation Location" | Text |
| item_id | The ID of the item | Text |
| item_name | The name of the item | Text |
| level | The item's "level" | Text |
| order_archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| order_mongo_id | A system-generated unique id from the Manufacton database to identify the order's Mongo ID (used to link to the Shipping Orders table) | Text |
| order_name | The name of the shipment's Order | Text |
| quantity | The quantity of the item | Number |
| sorce_mongo_id | Mongo ID of any associated Production Order(s) (used to link to the Production Orders table) | Text |
| updated_on | The date on which the Shipping Item was last updated in the MySQL database | Date |
| zone | The item's "zone" | Text |
Shipping Orders ("Manufacton_v2 shipping_orders")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the order's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| created | The date on which the order was created in the system | Date |
| current_location | The current location of the Shipping Order | Text |
| deliver | The planned delivery date of the Shipment | Date |
| delivery_location | The location to which the shipment is intended | Text |
| earliest_onsite | The earliest onsite date of item(s) in the order | Date |
| fulfilled_on | The date the items in the Shipping Order were marked final | Date |
| id | A system-generated, unique number for each Order | Number |
| kit_id | The Kit's ID that the Shipping Order is a part of | Text |
| modified | the most recent date on which the order was updated | Date |
| mongo_id | A system-generated id from the Manufacton database | Text |
| name | The name of the Shipping Order | Text |
| notes | Shipping Order notes | Text |
| owner | The Shipping Order's owner | Text |
| project | The name of the project to which the Shipping Order belongs | Text |
| project_id |
The mongo_id of the project to which the Shipping Order belongs |
Text |
| received_on | The date the items in the Shipping Order were received | Date |
| recipient | The recipient of the Shipping Order | Text |
| released_on | The date the items in the Shipping Order were released to Inventory | Date |
| ship_by | The date by which the Shipping Order should be shipped | Date |
| status | The current status of the Shipping Order | Text |
| updated_on | The date on which the Shipping Order was last updated in the MySQL database | Date |
Weld Information ("Manufacton_v2_weld_information")
| Column Name | Description | Data Type |
| added_on | The date when the row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the item's creation date. | Date |
| id | A system-generated, unique number for each part entry | Number |
| order_mongo_id | The mongo_id of the Production Order for which the weld information represents (used to link the Weld Information table to the Production Order table) | Text |
| project | The mongo_id of the project to which the weld information is related | Text |
| type | The type of information captured ("weld") | Text |
| updated_on | The date on which the weld information was last updated in the MySQL database | Date |
| value | The value of the weld information | Number |
Parts Catalog ("Manufacton_v2 catalog_parts")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the part's creation date. | Date |
| catalog_id | The part's Catalog ID | Text |
| category | The category of the part | Text |
| created | The date on which the part was added to the catalog | Date |
| custom_id | The part's ID | Text |
| description | The part's description | Text |
| id | A system-generated, unique number for each part entry | Number |
| measure_units | The units of measure defined for the part | Text |
| modified | The most recent date the part was updated in the catalog | Date |
| mongo_id | A system-generated id from the Manufacton database | Text |
| name | The part name | Text |
| sub_category | The sub-category of the assembly | Text |
| type | The type of Assembly | Text |
| updated_on | The date on which the assembly was last updated in the MySQL database | Date |
Assembly Catalog ("Manufacton_v2 catalog_assembly")
| Column Name | Description | Data Type |
| added_on | The most recent date that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the Assembly's creation date. | Date |
| catalog_id | The assembly's Catalog ID | Text |
| category | The category of the assembly | Text |
| created | the date on which the assembly was added to the catalog | Date |
| custom_id | The assembly's ID | Text |
| description | The assembly's description | Text |
| id | A system-generated, unique number for each assembly entry | Number |
| modified | The most recent data the assembly was updated in the catalog | Date |
| name | The assembly name | Text |
| part_cat_id | The Catalog ID of each part associated with the Assembly | Text |
| part_qty | The quantity of each part associated with the Assembly | Number |
| sub_category | The sub-category of the assembly | Text |
| type | The type of Assembly | Text |
| updated_on | The date on which the assembly was last updated in the MySQL database | Date |
Material Items ("Manufacton_v2 material_items")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the item's creation date. | Date |
| available | The target date by when the item should be available | Date |
| cat_id | The Part Catalog ID of the item | Text |
| company | The Company for the Order in which the item exists | Text |
| cost_code | The cost code of the item | Text |
| id | A system-generated, unique number for each part entry | Number |
| item_id | The ID of the item | Text |
| kit_id | The Kit to which the item's Material Order belongs | Text |
| leadTime | The number of days ahead of onsite date required to order a part | Number |
| location |
The current location of the Material Order in which the item exists |
Text |
| measure | The measure value for the item | Text |
| measure_units | The units of measure defined for the part | Text |
| mongo_id | A system-generated id from the Manufacton database | Text |
| name | The name of the item | Text |
| notes | The note associated with the item | Text |
| onsite | The desired onsite date of the item | Date |
| onsite_at | The actual onsite date of the item | Date |
| order_archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| order_by | The desired date for the item to be ordered | Date |
| ordered_at | The actual date on which the item was ordered | Date |
| order_mongo_id | A system-generated unique id from the Manufacton database to identify the order (used to link to the Material Orders table) | Text |
| owner | The current owner of the Material Order in which the item exists | Text |
| project | The Project in which the Material Order in which the item exists | Text |
| project_id | The mongo_id of the project to which the material item belongs | Text |
| quantity | The number of material items | Number |
| ship_by | The desired date by which the Material Order needs to be shipped | Date |
| source | The name of the Order in which the material item exists | Text |
| stage | The stage of the Order in which the material item exists | Text |
| totalCost | The total cost of an item based on the quantity purchased (unitCost*quantity) | Number |
| unitCost | The cost of a single quantity of an item | Numberd |
| updated on | The date on which the Material Order in which the item exists was last updated in the MySQL database | Date |
Material Orders ("Manufacton_v2 material_orders")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the order's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| available | The target date by when the Material Order should be available | Date |
| company | The Company for the Order in which the item exists | Text |
| created | The date on which the order was created | Date |
| id | A system-generated, unique number for each Order | Number |
| kit_id | The Kit to which the item's Material Order belongs | Text |
| level | The Material Order's "level" | Text |
| location | The current location of the Material Order | Text |
| modified | The most recent date on which the order was updated | Date |
| mogno_id | A system-generated unique id from the Manufacton database to identify the order (used to link to the Material Items table) | Text |
| name | The name of the Material Order | Text |
| notes | The note associated with the Material Order | Text |
| onsite | The desired onsite date of the Material Order | Date |
| onsite_at | The actual onsite date of the Material Order | Date |
| order_by | The desired date for the Material Order to be ordered | Date |
| ordered_at | The actual date on which the Material Order was ordered | Date |
| owner | The current owner of the Material Order | Text |
| project | The Project in which the Material Order exists | Text |
| project_id | The mongo_id of the project to which the material order belongs | Text |
| recipient | The current "recipient" of the Material Order | Text |
| ship_by | The desired date by which the Material Order needs to be shipped | Date |
| stage | The stage of the Material Order | Text |
| status | The status of the Material Order | Text |
| vendor | The Material Order's vendor | Text |
| updated on | The date on which the Material Order was last updated in the MySQL database | Date |
| Zone | The Material Order's "zone" | Text |
Inventory ("Manufacton_v2 inventory")
| Column Name | Description | Data Type |
|
added_on |
The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the order's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| cat_id | The Part or Assembly Catalog ID of the item in inventory | Text |
| consumed | The number of items used as part of production orders | Number |
| id | A system-generated, unique number for each Order | Number |
| in_delivery | The number of parts in delivery | Number |
| in_stock | The number of items in stock | Number |
| inventory_item_id | The items "Item ID" in the system | Text |
| Inventory_item_name | The name of the item | Text |
| inventory_notes | Notes related to the item in inventory | Text |
| item_type | The type of item, "Assembly" or "Part" | Text |
| location | The inventory's location | Text |
| max_stock | The maximum allowable stock of an item in a location | Number |
| min_stock | The minimum allowable stock of an item in a location | Number |
| project_id | The system generated ID for the project associated with the inventory item | Text |
| project_name | The project associated with the inventory item | Text |
| reserved | The number of items in reserve and to be consumed as part of production orders | Number |
| updated_on | The date on which the Inventory was last updated in the MySQL database | Date |
Locations ("Manufacton_v2 locations")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the order's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Tet |
| id | A system-generated, unique number for each Order | Number |
| location | A system-generated unique identifier for a location | Text |
| location_name | The name of the location | Text |
| type | The type of location ("company", "General", "Project" | Text |
| updated_on | The date on which the Inventory was last updated in the MySQL database | Date |
Forms ("Manufacton_v2 forms" - refers to Standard and QA/QC Form Templates)
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the form's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| completed_count | The number of forms associated with an order which have been completely filled-out | Number |
| created | The date on which the form template was created | Date |
| created_count | The number of forms associated with an order | Number |
| form_template_id | A system-generated id from the Manufacton database | Text |
| id | A system-generated, unique number for each Order | Number |
| last_modified | The date on which the form template was last modified | Date |
| name | The name of the form template | Text |
| notes | For QA/QC forms - The descriptive notes given to each Quality Check | Text |
| type | Indicates to which type the form is referencing, Standard "form' or "qaQcForm" | Text |
| updated_on | The date on which the Form was last updated in the MySQL database | Date |
Standard Form Questions ("Manufacton_v2 questions")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the form's creation date. | Date |
| archived | Identifies if the order is active or archived (0="active", 1="archived") | Text |
| form_template_id | A system-generated id from the Manufacton database | Text |
| id | A system-generated, unique number for each Order | Number |
| question | The data input filed name | Text |
| question_id | A system-generated id from the Manufacton database | Text |
| type | The type of data input filed type | Text |
| updated_on | The date on which the Question was last updated in the MySQL database | Date |
Standard Form Answers ("Manufacton_v2 answers")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the answer's creation date. | Date |
| answer | The answer provided | Text |
| form_id | A reference to the Form in the Forms Table for which the answer is provided | Text |
| form_template_id | A reference to the Form Template in the Forms Table for which the answer is provided | Text |
| id | A system-generated, unique number for each Order | Number |
| order_archived | Identifies if the order to which the answer is related is active or archived (0="active", 1="archived") | Text |
| order_id | A system-generated id from the Manufacton database of the order to which the answer is associated | Text |
| order_name | The name of the associated order | Text |
| order_type | The type of order (Production, Material, Shipping) to which the answer is associated | Text |
| project_id | A system-generated id from the Manufacton database of the project to which the answer is associated | Text |
| Project_name | The name of the project to which the answer is associated | Text |
| project_status | Identifies if the project to which the answer is related is active or archived (0="active", 1="archived") | Text |
| question_id | A system-generated id from the Manufacton database of the question to which the answer is associated | Text |
| updated_on | The date on which the answer was last updated in the MySQL database | Date |
QA/QC Questions ("Manufacton_v2 qaQcQuestions")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the answer's creation date. | Date |
| archived | Identifies if the order to which the answer is related is active or archived (0="active", 1="archived") | Text |
| form_id | A system-generated id from the Manufacton database indicating to which specific QA/QC Form the question is provided. | Text |
| form_template_id | A reference to the Form Template in the Forms Table for which the question is provided | Text |
| id | A system-generated, unique number for each Order | Number |
| question | The question or check being asked or performed | Text |
| question_id | A system-generated id from the Manufacton database | Text |
| type | Indicates the type of question being asked; "simple" or "w/criteria" | Text |
| updated_on | The date on which the answer was last updated in the MySQL database | Date |
QA/QC Answers ("Manufacton_v2 qaQcAnswers")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the answer's creation date. | Date |
| answer | The answer provided | Text |
| answer_id | A system-generated id from the Manufacton database | Text |
| archived | Identifies if the order to which the answer is related is active or archived (0="active", 1="archived") | Text |
| form_id | A system-generated id from the Manufacton database indicating to which specific QA/QC Form the answer is provided. | Text |
| form_template_id | A reference to the Form Template in the Forms Table for which the answer is provided | Text |
| id | A system-generated, unique number for each Order | Number |
| issue_type | For failed QA/QC checks, the Issue Type provided at the time of the failure | Text |
| lastModifiedBy | The user who last modified the QA/QC answer | Text |
| lasModifiedOn | The date the QA/QC answer was last modified | Date |
| order_id | A system-generated id from the Manufacton database of the order to which the answer is associated | Text |
| order_name | The name of the associated order | Text |
| project_id | A system-generated id from the Manufacton database of the project to which the answer is associated | Text |
| project_name | The name of the project to which the answer is associated | Text |
| question_id | A system-generated id from the Manufacton database of the question to which the answer is associated (links to the "question_id" in the qaQcQuestions table) | Text |
| run_name | The Work Step to which the QA/QC form is assigned within an order | Text |
| status | The status of the QA/QC check, "notStarted", "fail", "inspect", "pass" | Text |
| updated_on | The date on which the answer was last updated in the MySQL database | Date |
Projects ("Manufacton_v2 projects")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the answer's creation date. | Date |
| companyId | The mongo_id of the company | Text |
| customId | The Project ID | Text |
| id | A system-generated, unique number for each Project | Number |
| name | The name of the Project | Text |
| projectId | The mongo_id of the project | Text |
| status | Identifies if the project is active or archived | Text |
| updated_on | The date on which the project was last updated in the MySQL database | Date |
QR Codes ("Manufacton_v2 qrs")
| Column Name | Description | Data Type |
| added_on | The date when that row was added to the SQL table. This field is primarily for internal/manufacton use and has no relation to the answer's creation date. | Date |
| id | A system-generated, unique number for each Order | Number |
| item_mongo_id | The mongo_id for the item | Text |
| order_archived | Identifies if the order is active or archived (0="active", 1="archived") | Number |
| order_mongo_id | The mongo_id for the order | Text |
| qr_code_string | The QR Code string | Text |
| updated_on | The date on which the QR string was last updated in the MySQL database | Date |
Linking Tables
For many of the tables, there are columns that are included to help link the tables together. Although there are many ways to link tables that depend on how you want to report on things, Manufacton has included a few columns specifically designed for table linking. In PowerBI this links can be set up as follows:
Production Related Table Links
Material Related Table Links
Shipping Related Table Links
Catalog and Inventory Related Table Links
Form & QA/QC Related Table Links
Notes:
o Other relationships can be defined, like between Kit_id in various
tables (if Kits are being used in your environment), but caution should
be taken and testing conducted when creating relationships between
tables to ensure the reports are providing the expected output.
o By default, PowerBI (and potentially other database tools) may link
the ID columns between the tables. The ID column is simply the row
number within each table and in no way represents any relationship.
This relationship SHOULD BE DELETED if inter-table reports are to
be generated.
How it Works
- When your company subscribes to Manufacton’s Advanced Analytics module
- We publish your production data to a MySQL database on AWS and provide you with the location and credentials to that database. Once you have those credentials, you can access that database and the tables within
- And perform your own analytics to your own standards in tools like PowerBI, Tableau, Domo, etc.
Manufacton synchs the data to the MySQL database multiple times per day to ensure your reports are as up-to-date as possible.
Once the data is there, a wide variety of analytics can be run against the data from the tables imported from Manufacton and data from other data sources. There are virtually an infinite number of reports you can generate, such as
Tracking the number of production and material orders in each stage on a project-by-project basis
Measuring against the Capacity of various organizations like BIM or Shop Teams
Measuring actual vs budgeted time over various time periods
Measuring actual vs budgeted by prefab type
With Manufacton’s advanced analytics, it is possible to more closely measure LEAN initiatives and optimize all aspects of the production process and workflow!
For a quick video, please see Introducing Advanced Analytics
To find out more, and request a demo, please Connect with our Customer Success Team
Comments
0 comments
Please sign in to leave a comment.