Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • format: Format of the result.  Valid formats are:

    • json [Default]

    • xml

  • areas: Comma separated list of Area Id’s to include in the result data.

  • machines: Comma separated list of Machine Id’s to include in the result data; if both areas and machines are specified then machines parameter will be used and areas parameter will be ignored.

  • groupby: Comma separated list of options to group the resulting data with.  Valid options are:

    • area

      • Groups the result data based on top-level areas from the specified starting area.  Ie. Company divisions.

        • Associated field:

          • areaGroupRoot: Area ID to use as the starting area.  Data will be grouped by first generation areas underneath thisarea.  Default is areaGroupRoot = 0.

    • plant

      • Groups result data into Plants.

    • machine

      • Groups result data into individual Machines.

    • jobName

      • Groups result data by Job Name (if the same Job Name is run at different times the corresponding data will be added together into one group).

    • jobInstance

      • Groups result data by individual Job instances (if the same Job Instance is run at different times the corresponding data will be put into separate groups).  If both jobName and jobInstance are provided then jobName will be ignored and jobInstance will be used.

    • shiftName

      • Groups result data by Shift Name (all data with the same Shift Name will be added together into a single group)  If both shiftName and shiftInstance are provided then shiftName will be ignored and shiftInstance will be used.

    • shiftInstance

      • Groups result data by individual Shift instances (each day a particular Shift occurs will become a separate group).

  • jobFilter: Comma separated list of filters and filter values.  When specified the result data will only include data with jobs matching the specified values.  All other data will be filtered out.

    • Example: jobFilter=Filter3,abc,Filter7,14.2

      • This would match against jobs where Filter1=abc and Filter7=14.2

  • subJobFilter: Comma separated list of subjob filters and subjob filter values.  When specified the result data will only include data with sub jobs matching the specified values.  This filter only affects the subJobs metric (described below), no other data is affected.  All other data will be filtered out.

    • Example: subjobFilter=Filter1,abc,Filter3,24.0

      • This would match against jobs where Filter1=abc and Filter3=24.0

  • shiftFilter: Comma separated list of Shift Names to include in the results.  Data associated with other Shift Names will be filtered out.

  • classificationFilter: Comma separated list specifying what Classification values the data must have to be included in the results.  Data associated with other Classification values will be filtered out.  Valid Classification values are:

    • performance

    • availability

    • capacity

  • reasonNameFilter: Comma separated list specifying what reasons to include in the results.  Data associated with other reason names will be filtered out.  Example: "Safety Guard Open"

  • reasonGroupFilter: Comma separated list specifying what reason groups to include in the results.  Data associated with other reason groups will be filtered out.  Example: "Maintenance"

  • jobFilterType: Specify whether Job Filter is Inclusive or Exclusive. eg. "jobfiltertype=exclusive"

  • subJobFilterType: Specify whether SubJob Filter is Inclusive or Exclusive.

  • shiftFilterType: Specify whether Shift Filter is Inclusive or Exclusive.

  • classificationFilterType: Specify whether Classification Filter is Inclusive or Exclusive. 

  • reasonNameFilterType: Specify whether Reason Name Filter is Inclusive or Exclusive.

  • reasonGroupFilterType: Specify whether Reason Group Filter is Inclusive or Exclusive. 

  • stateInstance: Returns every instance of states, True or False

  • reasonInstance: Returns every instance of reasons, True or False

  • scrapReasonInstance: Returns every instance of scrap reasons, True or False

  • stateReasonInstance: Returns every instance of state reasons, True or False

  • Metrics: Comma separated list specifying what Metrics to return in the result data.  Valid options are:

    • oeeUptimeHours: [Default] Total scheduled duration where state is either uptime or speedloss (Used for OEE calculation).

    • uptimeHours: [Default] Total uptime in hours.

    • uptimeSeconds: [Default] Total uptime in seconds

    • speedLossHours: [Default] Total speedloss in hours

    • speedLossSeconds: [Default] Total speedloss in seconds

    • downtimeHours: Total downtime in hours.

    • downtimeSeconds: Total downtime in seconds.

    • setupHours: Total setup time in hours.

    • setupSeconds: Total setup time in seconds.

    • total: Total parts produced in base units.  

    • scrap: Scrap production in base units.

    • oee: Overall Equipment Effectiveness as %.

    • oeeC: Overall Equipment Effectiveness as % factoring in Capacity.

    • availability: % of Uptime over Scheduled Time

    • performance: % of Actual Production Rate / Expected Production Rate

    • performanceC: % of Actual Production Rate / Expected Production Rate (with capacity)

    • quality: % of Good production / Total production 

    • qualityC: % of Good production / Total production (with capacity)

    • capacity: % of Scheduled time over Total Time 

    • cycleTimeSeconds: average cycle time in seconds per cycle.

    • jobs: When the jobs option is specified the resulting metrics will include a summary of what jobs occurred, For each job, all job details will be provided.

    • subJobs: When the subJobs option is specified the resulting metrics will include a summary of what sub jobs occurred.  For each sub job the following will be included:

      • id: the subjob’s ID

      • filters: list of filter values for the subjob

      • total: Total parts produced, in base units, for the sub job

      • scrap: Scrap production, in base units, for the sub job

    • scrapReasons: When the scrapReasons option is specified the resulting metrics will include a summary of what scrap reasons occurred.  For each scrap reason the following will be included:

      • name: The scrap reason’s name.

      • group: The scrap reason variable’s Group.

      • amount: The amount of scrap production, in base units, for this scrap reason.

    • states: When the states option is specified the resulting metrics will include a summary of what machine states occurred.  For each machine state the following will be included:

      • name: The machine state’s name.

      • classification: The machine state’s classification (

      • duration: The machine state’s duration.

      • occurrences: The number of occurrences for this machine state.

    • reasons: When the reasons option is specified the resulting metrics will include a summary of what reasons occurred.  For each reason the following will be included:

      • name: The reason’s name.

      • group: The reason’s group.

      • classification: The reason’s classification.

      • duration: The reason’s duration.

      • occurrences: The reason’s occurrences.

    • stateReasons: When the stateReasons option is specified the resulting metrics will include a summary of the combined machine states with reasons that occurred.  For each unique machine state and reason combination the following will be included:

      • stateName: The machine state’s name.

      • reasonName: The reason’s name.

      • classification: The record’s classification.

      • duration: The record’s duration.

      • occurrences: The record’s number of occurrences.

    • comments: When the comments option is specified the resulting metrics will include a list of what comments occurred.  For each comment the following will be included:

      • Start: Beginning of the first comment.

      • End: End of the last comment

      • target: the event (machine state / reason / scrap) the comment is associated with.

      • comment: the text value of the comment.

      • duration: The record’s duration.

      • occurrences: The record’s number of occurrences.

    • Adoption: Metrics used to determine the extent our Customer is adopting, integrating with, and using Shoplogix technologies. The following will be included:

      • PercentOnlineMachines: The percentage of online machines

      • PercentReasonsApplied: the Percentage of Reasons Applied vs Not Applied.

      • PercentReportingScrap: Percent of machines reporting scrap. (If a client does not report scrap, they will be penalized as it is good practice).

      • PercentGoodPerformance: Percent of machines with good performance.

      • PercentTargetComments: Percentage of daily comments input.

      • AdoptionScore: Average final score of the above metrics.

Appendix

  • Xml Schema document:

View file
nameShoplogix_DataExport.xsd