How can we help?

PCSDB Constants and Variables

You are here:
< All Topics

PCSDB Source Variables

 VariablesDescription
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)
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
Custom Variable Time [PCSDB.custom_variable_time]{variableName}Stores the amount of time in seconds that the custom variable has had the current value.
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
Current Time Stamp [PCSDB.current_timestamp]Returns the time stamp when the expression is evaluated, in the format "MM/DD/YYYY HH:MM:SS.mmmmmmm" - Use |'[PCSDB.current_timestamp]'| in expressions to prevent / being interpreted as a math operation.
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
DX ODI Flashing State [PCSDB.current_odi_flashing]Returns True if the machine is currently flashing on the ODI.
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
Part Number Active [PCSDB.part_number_active]Returns True if a Part Number is active, otherwise false
Work Order Active [PCSDB.work_order_active]Returns True if a Work Order is active, otherwise false
User Active [PCSDB.user_active]Returns True if a User is active, otherwise false

Work Orders (source)

 VariableDescription
DX Current Work Order [PCSDB.current_work_order]Returns the current work order
DX Current Work Order Operation [PCSDB.current_wo_operation]Returns the current work order operation
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

Work Orders (target)

 VariableDescription
Send build quantity to DX [PCSDB.send_wo_build_qty] {WORK ORDER DATA}Updates the selected work order build quantity
Close 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 good and scrap part count
Inactivate work order [PCSDB.send_wo_end]Marks the selected work order inactive
Activate work order [PCSDB.send_wo_start]{work_order,operation_number}Marks the selected work order active
Activate work order, part number, and operation [PCSDB.send_wo_part_op_start] {WORK ORDER DATA}Marks the selected work order part number and operation as active

Scheduled Planned Downtime

 VariableDescription
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

Program Numbers (Source)

 Variable NameVariable SyntaxDescription
Current Program NumberPCSDB.current_program_numberReturns the current active program number on the Equipment.
Current Program Number (Previous)PCSDB.prev_current_program_numberReturns active program number on the Equipment from the previous poll.

Program Numbers (Target)

 Variable NameVariable SyntaxDescription
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

Connectivity

VariableDescription
Focas.connect_timeThe connect time for the current Focas poll
Focas.prev_connect_timeThe previous connect time
Focas.connected_timeReturns the amount of time in seconds since a successful connection to the source
Focas.prev_connected_timeThe previous connected time
MTC.connect_timeThe connect time for the current MTConnect poll
MTC.prev_connect_timeThe previous connect time
MTC.connected_timeReturns the amount of time in seconds since a successful connection to the source
MTC.prev_connected_timeThe previous connected time
SRC.connect_timeThe connect time for the current SRC poll
SRC.prev_connect_timeThe previous connect time
SRC.connected_timeReturns the amount of time in seconds since a successful connection to the source
SRC.prev_connected_timeThe previous connected time
PCSDB ConnectivityReturns the state of the connection
PCSDB Connectivity_statusReturns the most recent connectivity status that was written to the database

Connectivity Target Variables

 Variable NameNotes
Send Connectivity Start[PCSDB.send_connectivity_start]Sends a start event to mark when connectivity to the Source has been established.
Send Connectivity Lost End[PCSDB.send_connectivity_end]Sends an end event to mark when connectivity to the Source has been lost.

Connectivity Source Variables

 Variable Name                                                                Notes
Connectivity[PCSDB.connectivity]Returns True if connectivity to the Source is currently in good health. The connectivity variable is set by using the two target variables defined above.
Connectivity[PCSDB.poll_count]Returns the amount of polls that have taken place.

Many of these variables also have a corresponding Previous variable which will hold the status from the last time a poll took place. 

  • PCSDB.prev_connectivity
  • PCSDB.prev_connectivity_status
  • PCSDB.prev_current_logged_on_user
  • PCSDB.prev_custom_command_notes
  • PCSDB.prev_current_program_number
  • PCSDB.prev_current_part_number
  • PCSDB.prev_current_part_number_time
  • PCSDB.prev_current_work_order
  • PCSDB.prev_current_wo_operation
  • PCSDB.prev_current_cycle_status_code
  • PCSDB.prev_current_cycle_status_code_time
  • PCSDB.prev_current_pdt_status_code
  • PCSDB.prev_current_pdt_status_code_time
  • PCSDB.prev_current_updt_status_code
  • PCSDB.prev_current_updt_status_code_time
  • PCSDB.prev_cycle_status_code_time
  • PCSDB.prev_general_equipment_status
  • PCSDB.prev_general_equipment_status_time
  • PCSDB.prev_has_cycle_status_code
  • PCSDB.prev_pdt_status_code_time
  • PCSDB.prev_updt_status_code_time
  • PCSDB.prev_equipment_status_notes
  • PCSDB.prev_in_scheduled_downtime
  • PCSDB.prev_active_shift
  • PCSDB.prev_in_shift
  • PCSDB.prev_in_shift_break
  • PCSDB.prev_shift_break_DT_identifier
  • PCSDB.prev_shift_break_DT_name
  • PCSDB.prev_scheduled_planned_downtime_code
  • PCSDB.prev_scrap_part_notes

PCSDB Constants

Constant NameSyntax
General CyclingPCSDB.Cycling
General Unknown DowntimePCSDB.Unknown_Downtime
General Unplanned DowntimePCSDB.Unplanned_Downtime
General Planned DowntimePCSDB.Planned_Downtime

PCSDB Target Commands and Variables

 PCSDB Command NameDescription
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
Current Time Stamp [PCSDB.current_timestamp]Returns the time stamp when the expression is evaluated, in the format "MM/DD/YYYY HH:MM:SS.mmmmmmm"
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.

Historical (Target)

TIMESTAMP =  Time stamp is in one of the following formats: mm/dd/yyyy hh:mm AM/PM (12 hrs format) or mm/dd/yyyy HH:mm (24 hrs format)

 VariableDescription
[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.

The information in the curly brackets are parameters.  If general cycle status is being recorded then the parameter, including the brackets can be removed:

[PCSDB.send_start_cycle]

If specific cycle status are being used then the cycle status to change should be placed in the brackets:

[PCSDB.send_start_cycle] {100}

Table of Contents