Variables

Description

Current Time

[PCSDB.current_time]

The time at which the expression is evaluated.  In expression time must be written with four digits in 24 hour format.  For example, 7:00 am would be 07:00 and 7 pm would be 19:00. Note when comparing this in an expression the comparison must always have 4 digits. Ex. (07:00)

Custom Variable Time{}

[PCSDB.custom_variable_time]{variableName}

Stores the amount of time in seconds that the custom variable has had the current value.

DX General Equipment Status

[PCSDB.general_equipment_status]

This will always be one of the four General statuses; In Cycle, Planned Downtime, Unplanned Downtime, or Unknown Downtime.  If any cycle status is active then the General Equipment Status is Active.  Likewise for Unplanned and Planned downtimes.

DX Current Cycle Status Code

[PCSDB.current_cycle_status_code]

The most recent cycle status code that went Active.  Can also be used with the {identifier.group{groupName}}  parameter to see if the current status code is within the specified group name.

DX Has Cycle Status Code{}

[PCSDB.has_cycle_status_code] {CYCLE STATUS CODE}

The parameter will be a Specific Status Code.  The variable returns True or False depending on if the specified status code is active or not.

DX General Equipment Status Time

[PCSDB.general_equipment_status_time]

The amount of time in minutes the equipment has been in the same general status

DX Current Cycle Status Code Time

[PCSDB.current_cycle_status_code_time]

The amount of time in minutes the equipment has been in the same cycle status code

DX Cycle Status Code Time{}

[PCSDB.cycle_status_code_time] {CYCLE STATUS CODE}

The parameter will be a Cycle Specific Status Code. The amount of time in minutes the equipment has been in the same specific status code

DX Equipment Group

[PCSDB.equipment_group]

The current group that machine is assigned to

Poll Count

[PCSDB.poll_count]

The amount of polls to the Source that have taken place.

Current Plant Name

[PCSDB.plant]

The plant the the equipment is associated with

DX Current Planned Downtime Status Code

[PCSDB.current_pdt_status_code]

The most recent planned downtime status code that went Active. Can also be used with the {identifier.group{groupName}}  parameter to see if the current status code is within the specified group name.

DX Current Unplanned Downtime Status Code

[PCSDB.current_updt_status_code]

The most recent unplanned downtime status code that went Active. Can also be used with the {identifier.group{groupName}}  parameter to see if the current status code is within the specified group name.

DX Current Planned Downtime Status Code Time

[PCSDB.current_pdt_status_code_time]

The amount of time in minutes the equipment has been in the same planned downtime status code

DX Current Unplanned Downtime Status Code Time

[PCSDB.current_updt_status_code_time]

The amount of time in minutes the equipment has been in the same unplanned downtime status code

DX Planned Downtime Status Code Time{}

[PCSDB.pdt_status_code_time]  {DOWNTIME CODE}

The parameter will be a Planned Downtime Specific Status Code. The amount of time in minutes the equipment has been in the same specific status code

DX Unplanned Downtime Status Code Time{}

[PCSDB.updt_status_code_time]  {DOWNTIME CODE}

The parameter will be a Unplanned Downtime Specific Status Code. The amount of time in minutes the equipment has been in the same specific status code

Active Shift

[PCSDB.active_shift]

The active shift name if the equipment is currently in an active shift

Custom Variable Value{}

[PCSDB.custom_variable_value]{variableName}

A custom variable to store custom information

Custom Variable Indicator{}

[PCSDB.custom_variable_indicator]{variableName}

Stores a user definable color code for the custom variable

In Shift

[PCSDB.in_shift]

This will return True or False depending on if the equipment is currently in a defined shift

In Shift Break

[PCSDB.in_shift_break]

This will return True or False depending on if the equipment is currently in a defined shift break

Shift Break DT Identifier

[PCSDB.shift_break_DT_identifier]

If the equipment is in a defined shift break this will hold the identifier for the assigned planned downtime

Shift Break DT Name

[PCSDB.shift_break_DT_name]

If the equipment is in a defined shift break this will hold the name of the assigned planned downtime

Custom Command Notes

[PCSDB.custom_command_notes]

Returns the last note entered into the ODI Screen for Custom Commands

Equipment Status Notes

[PCSDB.equipment_status_notes]

Returns the last note entered into the ODI Screen for Equipment Statuses

Scrap Part Notes

[PCSDB.scrap_part_notes]

Returns the last note entered into the ODI Screen for Scrap Parts

Backfill unknown downtime from ODI

[PCSDB.Unknown_Downtime_Start_Time]

Using Modify Time Stamp - backfill unknown downtime from the ODI. 

Part Identifier for Part Start

[PCSDB.PI_part_start]

Returns the Part Start identifier for making a part active

Part Identifier for Part End

[PCSDB.PI_part_end]

Returns the Part End identifier for making a part inactive

Part Count Identifier for Add Good Part

[PCSDB.PCI_add_good_part]

Returns the Part Count Identifier for Adding a Good Part

Part Count Identifier for Subtract Good Part

[PCSDB.PCI_subtract_good_part]

Returns the Part Count Identifier for Subtracting a Good Part

DX Current Part Number

[PCSDB.current_part_number]

Returns the current active part number on the Equipment

DX Current Part Number Time

[PCSDB.current_part_number_time]

Returns the amount of time in minutes the current part number has been active on Equipment

Ideal Cycle Time

[PCSDB.ideal_cycle_time]

Returns the Ideal Cycle Time for the active part number on the Equipment

Ideal Setup Time

[PCSDB.ideal_setup_time]

Returns the Ideal Setup Time on the Equipment

Update the Ideal Setup Time

[PCSDB.ideal_setup_time_update]{}

Using this Ideal Setup Time variable combined with script, you are able to dynamically update your Ideal Setup Time

Update the Ideal Cycle Time

[PCSDB.ideal_cycle_time_update]{}

Using this Ideal Cycle Time variable combined with script, you are able to dynamically update your Ideal Cycle Time

Update the Operation Time

[PCSDB.ideal_operation_time_update]{}

Using this Operation Time variable combined with script, you are able to dynamically update your Ideal Operation Time

DX Current Work Order

[PCSDB.current_work_order]

Returns the current work order

Prev Work Order

[PCSDB.prev_current_work_order]

Returns the value from the previous poll for active work order.

Current work order build quantity

[PCSDB.wo_build_qty]

Returns the build quantity for the current work order.

Current work order build quantity

[PCSDB.wi_wo_confirmed_parts_counts]

Returns the work order identifier to confirm work order part counts

Current work order update

[PCSDB.wi_wo_build_qty]

Returns the work order identifier to update build quantity

Closes existing Work Order

[PCSDB.wi_wo_closed]

Returns the work order identifier to close the work order

Ends an existing Work Order

[PCSDB.wi_wo_end]

Returns the work order identifier to end the work order

Starts a Work Order

[PCSDB.wi_wo_start]

Returns the work order identifier to start the work order

Send build quantity to DX

[PCSDB.send_wo_build_qty] {WORK ORDER DATA}

Updates the selected work order build quantity

Prev Work Order

[PCSDB.send_wo_closed] {WORK ORDER DATA}

Marks the selected work order closed

Current work order build quantity

[PCSDB.send_wo_confirmed_part_counts] {WORK ORDER DATA}

Updates the current work order with confirmed goo and scrap part count

Current work order build quantity

[PCSDB.send_wo_end]

Marks the selected work order inactive

Current work order update

[PCSDB.send_wo_start]

Marks the selected work order active

Closes existing Work Order

[PCSDB.send_wo_part_op_start] {WORK ORDER DATA}

Marks the selected work order part number and operation as active

Scheduled Planned Downtime Code

[PCSDB.scheduled_planned_downtime_code]

The currently active scheduled planned downtime identifier, such as 201, or 202.

Prev Scheduled Planned Downtime Code

[PCSDB.prev_scheduled_planned_downtime_code]

The identifier of the scheduled planned downtime that was active on the previous poll

In Scheduled Downtime

[PCSDB.in_scheduled_downtime]

This variable will hold a value of True if the equipment is currently in an active scheduled downtime

Variable Name

Variable Syntax

Description

Current Program Number

PCSDB.current_program_number

Returns the current active program number on the Equipment.

Current Program Number (Previous)

PCSDB.prev_current_program_number

Returns active program number on the Equipment from the previous poll.

Variable Name

Variable Syntax

Description

Send program number end to DX

[PCSDB.send_program_number_end] {PROGRAM NUMBER}

Marks the selected program as not active

Send program start to DX

[PCSDB.send_program_number_start] {PROGRAM NUMBER}

Marks the selected program as active

Focas.connect_time

The connect time for the current Focas poll

Focas.prev_connect_time

The previous connect time

Focas.connected_time

Returns the amount of time in seconds since a successful connection to the source

Focas.prev_connected_time

The previous connected time

MTC.connect_time

The connect time for the current MTConnect poll

MTC.prev_connect_time

The previous connect time

MTC.connected_time

Returns the amount of time in seconds since a successful connection to the source

MTC.prev_connected_time

The previous connected time

SRC.connect_time

The connect time for the current SRC poll

SRC.prev_connect_time

The previous connect time

SRC.connected_time

Returns the amount of time in seconds since a successful connection to the source

SRC.prev_connected_time

The previous connected time

PCSDB Connectivity

Returns the state of the connection

PCSDB Connectivity_status

Returns the most recent connectivity status that was written to the database

Constant Name

Syntax

General Cycling

PCSDB.Cycling

General Unknown Downtime

PCSDB.Unknown_Downtime

General Unplanned Downtime

PCSDB.Unplanned_Downtime

General Planned Downtime

PCSDB.Planned_Downtime

PCSDB Command Name

Description

Send Cycle Start

[PCSDB.send_start_cycle] {CYCLE STATUS CODE}

A cycle start will be sent to the database to start the specified cycle status. 

Send Cycle End

[PCSDB.send_end_cycle] {CYCLE STATUS CODE}

A cycle end will be sent to the database to end the specified cycle status. 

Custom Variable Value{}

PCSDB.custom_variable_value{variableName}

Sets the value for the defined custom variable

Custom Variable Indicator{}

PCSDB.custom_variable_indicator{variableName}

Sets the color associated with the defined custom variable

Send Planned Downtime Start

[PCSDB.send_planned_DT_start] {DOWNTIME CODE}

A planned downtime start will be sent to the database to start the specified planned downtime.

Send Planned Downtime End

[PCSDB.send_planned_DT_end] {DOWNTIME CODE}

A planned downtime end will be sent to the database to end the specified planned downtime.

Send Planned Downtime End Any

[PCSDB.send_planned_DT_end_any]

A planned downtime end will be sent to the database to end any active planned downtime.

Send Unplanned Downtime Start {}

[PCSDB.send_unplanned_DT_start] {DOWNTIME CODE}

An unplanned downtime start will be sent to the database to start the specified unplanned downtime.

Send Unplanned Downtime End {}

[PCSDB.send_unplanned_DT_end] {DOWNTIME CODE}

An unplanned downtime end will be sent to the database to end the specified unplanned downtime.

Send Unplanned Downtime End Any

[PCSDB.send_unplanned_DT_end_any]

An unplanned downtime end will be sent to the database to end any active unplanned downtime.

Send Downtime End Any

[PCSDB.send_DT_end_any]

A downtime end will be sent to the database to end any active downtime, regardless if it's planned or unplanned.

Shift Break Downtime Identifier

[PCSDB.shift_break_DT_identifier]

An identifier that can be used in target expressions.  For example, if a shift break is active the shift break downtime identifier can be used to start the downtime.

Shift Break Downtime Name

[PCSDB.shift_break_DT_name]

A name that can be used in emails to provide a description of the shift break downtime

Send Part Number Start {}

PCSDB.send_part_start{PART NUMBER}

Marks the selected part as active

Send Part Number End {}

PCSDB.send_part_end{PART NUMBER}

Marks the selected part as not active

Send Add Good Part {}

PCSDB.send_add_good_part {QUANTITY}

Increments the quantity of good parts. The parameter is the quantity.  If used without any parameters then the quantity will be 1.

Send Subtract Good Part {}

PCSDB.send_subtract_good_part{QUANTITY}

Decrements the quantity of good parts. The parameter is the quantity.  If used without any parameters then the quantity will be 1.

Send Add Scrap Part to DX {}

[PCSDB.send_add_scrap_part] {SCRAP REASON, QUANTITY}

Increments the quantity of scrap parts. The parameter is the quantity and scrap reason.  If used without any parameters then the quantity will be 1.

Send Subtract Scrap Part to DX {}

[PCSDB.send_subtract_scrap_part] {SCRAP REASON, QUANTITY}

Decrements the quantity of scrap parts. The parameter is the quantity and scrap reason.  If used without any parameters then the quantity will be 1.

[PCSDB.send_end_cycle_historical]{Cycle Status CODE, TIMESTAMP}

Ends a general or specific historical cycle.

[PCSDB.send_end_cycle_historical]{Cycle Status CODE, TIMESTAMP} 

Starts a general or specific historical cycle.

[PCSDB.send_unplanned_DT_start_historical]{Unplanned Status CODE, TIMESTAMP}

Starts a general or specific unplanned historical.

[PCSDB.send_unplanned_DT_end_historical]{Unplanned Status CODE, TIMESTAMP}

Ends a general or specific unplanned historical.

[PCSDB.send_planned_DT_start_historical]{Planned Status CODE, TIMESTAMP}

Starts general or specific planned historical.

[PCSDB.send_planned_DT_end_historical]{Planned Status CODE, TIMESTAMP}

Ends general or specific planned historical.