How can we help?

PCSDB Constants and Variables

You are here:
< All Topics

PCSDB Source Variables

PCSDB Source Variables pull data from the Scytec DataXchange Database.

VariablesDescription
DX Current Cycle Status Code [PCSDB.current_cycle_status_code]The most recently active Cycle Status code if the machine is In Cycle. Returns NA if current General Status is not In Cycle. Can also be used with the {identifier.group{groupName}} parameter to see if the current status code is within the specified group name and will return True or False.
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 amount of time in minutes the equipment has been in the status code specified in the parameter.
DX General Equipment Status [PCSDB.general_equipment_status]This will always be one of the four General statuses: [PCSDB.CYCLING], [PCSDB.UNKNOWN_DOWNTIME], [PCSDB.Unplanned_Downtime], or [PCSDB.Planned_Downtime]. If any cycle status is active then the General Cycle Equipment Status is Active. Likewise for Unplanned and Planned downtimes.
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 Has Cycle Status Code [PCSDB.has_cycle_status_code] {CYCLE STATUS CODE}Returns True or False depending on if the cycle status code specified in the parameter is active or not.
Active Shift [PCSDB.active_shift]The active shift name if the equipment is currently in an active shift
Constant [PCSDB.constant] {CONSTANTVARIABLE}Returns the value of the specified PCSDB Constant.
Current Plant Name [PCSDB.plant]The plant the equipment is associated with
Current Program Number [PCSDB.current_program_number]Returns the current active program number on the Equipment.
Current Time [PCSDB.current_time]The time at which the expression is evaluated. In expression time must be written as HH:MM 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)
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.
Custom Command Notes [PCSDB.custom_command_notes]Returns the last note entered into the ODI Screen for Custom Commands
Custom Variable Indicator [PCSDB.custom_variable_indicator]{variableName}The current color code of the specified custom variable.
Custom Variable Time [PCSDB.custom_variable_time]{variableName}The amount of time in seconds that the custom variable has had the current value.
Custom Variable Value [PCSDB.custom_variable_value]{variableName}The current value of the specified Custom Variable.
DX Current Planned Downtime Status Code [PCSDB.current_pdt_status_code]The currently active Planned Downtime status code. Returns NA if the current General Status is not Planned Downtime. Can also be used with the {identifier.group{groupName}} parameter to see if the current status code is within the specified group name and will return True or False.
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 current planned downtime status.
DX Current Unplanned Downtime Status Code [PCSDB.current_updt_status_code]The currently active Unplanned Downtime status code. Returns NA if the current General Status is not Unplanned Downtime. Can also be used with the {identifier.group{groupName}} parameter to see if the current status code is within the specified group name and will return True or False.
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 Unplanned Downtime specified by the status code in the parameter, if the machine is in that status.
DX Planned Downtime Status Code Time [PCSDB.pdt_status_code_time] {DOWNTIME CODE}The amount of time in minutes the equipment has been in the Planned Downtime specified by the status code in the parameter if the machine is in that status.
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
DX ODI Flashing State [PCSDB.current_odi_flashing]Returns True or False based on if the machine is currently flashing on the ODI.
Equipment Status Notes [PCSDB.equipment_status_notes]Returns the last note entered into the ODI Screen for Equipment Statuses
In Scheduled Downtime [PCSDB.in_scheduled_downtime]Returns True if currently in a Scheduled Downtime, otherwise false.
In Shift [PCSDB.in_shift]Returns True if the equipment is currently in a defined shift, otherwise False.
In Shift Break [PCSDB.in_shift_break]Returns True if the equipment is currently in a defined shift break, otherwise False.
Scheduled Planned Downtime Code [PCSDB.scheduled_planned_downtime_code]The currently active scheduled planned downtime identifier, such as 201, or 202.
Scrap Part Notes [PCSDB.scrap_part_notes]Returns the current ODI Scrap Count Note.
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 Planned Downtime assigned to the Shift Break.
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 Planned Downtime assigned to the Shift Break.
Status Identifier for Cycle End [PCSDB.SI_Cycle_End] {CYCLE STATUS CODE}The status identifier for a Cycle end signal - Used with Data Listeners and ODI
Status Identifier for Cycle Start [PCSDB.SI_Cycle_Start] {CYCLE STATUS CODE} The status identifier for a Cycle start signal - Used with Data Listeners and ODI
Status Identifier for Planned Downtime End [PCSDB.SI_Planned_DT_End] {PLANNED STATUS CODE} The status identifier for a planned downtime end signal - Used with Data Listeners and ODI
Status Identifier for Planned Downtime Start [PCSDB.SI_Planned_DT_Start] {PLANNED STATUS CODE} The status identifier for a Planned Downtime start signal - Used with Data Listeners and ODI
Status Identifier for Unplanned Downtime End [PCSDB.SI_Unplanned_DT_End] {UNPLANNED STATUS CODE} The status identifier for an Unplanned Downtime end signal - Used with Data Listeners and ODI
Status Identifier for Unplanned Downtime Start [PCSDB.SI_Unplanned_DT_Start] {UNPLANNED STATUS CODE} The status identifier for an Unplanned Downtime start signal - Used with Data Listeners and ODI
Unknown Downtime Start TimeReturns the start time of Unknown Downtime, if the machine is in Unknown Downtime.
Alarms [PCSDB.alarms]Returns active Alarm numbers and descriptions.
Part Identifier for Part Start [PCSDB.PI_part_start]Returns the Part Start identifier for making a part active - Used with Data Listeners and ODI
Current Logged on User [PCSDB.current_logged_on_user]Returns the username of the active user for the machine
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 Operation Time [PCSDB.ideal_operation_time]Returns the Ideal Operation Time for the active part number on the Equipment
Ideal Setup Time [PCSDB.ideal_setup_time]Returns the Ideal Setup Time on the Equipment
Part Count Identifier for Add Good Part [PCSDB.PCI_add_good_part]Returns the Part Count Identifier for Adding a Good Part - Used with Data Listeners and ODI
Part Count Identifier for Add Scrap Part [PCSDB.PCI_add_scrap_part]Returns the Part Count Identifier for Adding a Scrap Part - Used with Data Listeners and ODI
Part Count Identifier for Subtract Good Part [PCSDB.PCI_subtract_good_part]Returns the Part Count Identifier for Subtracting a Good Part - Used with Data Listeners and ODI
Part Count Identifier for Subtract Scrap Part [PCSDB.PCI_subtract_scrap_part]Returns the Part Count Identifier for Subtracting a Scrap Part - Used with Data Listeners and ODI
Part Identifier for Part End [PCSDB.PI_part_end]Returns the Part End identifier for making a part inactive - Used with Data Listeners and ODI
Part Number Active [PCSDB.part_number_active]Returns True if a Part Number is active, otherwise false
Parts Per Hour Percent [PCSDB.pph_percent] {PARTS PER HOUR PERCENT} Returns Parts Per Hour Percent for current equipment and part number
Parts Per Hour Plan [PCSDB.pph_plan] {PARTS PER HOUR PLAN}Returns Parts Per Hour Plan for current equipment and part number
User Active [PCSDB.user_active]Returns True if a User is active, otherwise false
User Identifier for User End [PCSDB.UI_user_end]Returns the User End identifier - Used with Data Listeners and ODI
User Identifier for User Start [PCSDB.UI_user_start]Returns the User Start identifier - Used with Data Listeners and ODI
Work Order Active [PCSDB.work_order_active]Returns True if a Work Order is active, otherwise false

PCSDB Constants

Constant NameDescription
General Cycling [PCSDB.CYCLING]Constant value representing general Cycle status.
General Planned Downtime [PCSDB.Planned_Downtime]Constant value representing general Planned Downtime.
General Unknown Downtime [PCSDB.UNKNOWN_DOWNTIME]Constant value representing general Unknown Downtime.
General Unplanned Downtime [PCSDB.Unplanned_Downtime]Constant value representing general Unplanned Downtime.
Is Empty Value [PCSDB.IS_EMPTY]A constant representing an empty string value.

PCSDB Target Commands and Variables

PCSDB Command NameDescription
Send Cycle Start [PCSDB.send_start_cycle] {CYCLE STATUS CODE}Start the specified Cycle Status code.
Send Cycle End [PCSDB.send_end_cycle] {CYCLE STATUS CODE}End the specified Cycle Status code.
Send Planned Downtime End Any [PCSDB.send_planned_DT_end_any]Ends the currently active Planned Downtime.
Send Unplanned Downtime End Any [PCSDB.send_unplanned_DT_end_any]End the currently active Unplanned Downtime.
Send Custom Variable Current Value [PCSDB.send_custom_variable_value] {VARIABLENAME} == VALUESets the value for the defined custom variable. Set to empty by omitting "== VALUE"
Send Custom Variable Current Indicator [PCSDB.send_custom_variable_indicator] {VARIABLENAME} == COLORSets the color associated with the defined custom variable. Set to empty by omitting "== COLOR"
Send Planned Downtime Start [PCSDB.send_planned_DT_start] {DOWNTIME CODE}Start the specified Planned Downtime code.
Send Planned Downtime End [PCSDB.send_planned_DT_end] {DOWNTIME CODE}End the specified Planned Downtime code.
Send Unplanned Downtime Start [PCSDB.send_unplanned_DT_start] {DOWNTIME CODE}Start the specified Unplanned Downtime code.
Send Unplanned Downtime End [PCSDB.send_unplanned_DT_end] {DOWNTIME CODE}End the specified Unplanned Downtime code.
Send Downtime End Any [PCSDB.send_DT_end_any]End the currently active downtime, whether Planned or Unplanned.
Send Custom Command Notes [PCSDB.send_custom_command_notes]Set and save the notes to store custom command information
Send ODI Flash [PCSDB.send_odi_flash] {On | Off}Turns ODI Flashing on or off for the machine
Ideal Cycle Time Update [PCSDB.ideal_cycle_time_update]{VALUE}Sets Ideal Cycle Time to the value provided.
Ideal Operation Time Update [PCSDB.ideal_operation_time_update]{VALUE}Sets Ideal Operation Time to the value provided.
Ideal Setup Time Update [PCSDB.ideal_setup_time_update]{VALUE}Sets Ideal Setup Time to the value provided.
Send Acquired Data Value [PCSDB.send_data] {VARIABLENAME}Send the value of the data acquired the last time a poll took place
Send Active Alarms to DX [PCSDB.send_alarms] {ALARMS} Send Active Alarms information to DataXchange
Send Add Good Part [PCSDB.send_add_good_part]{QUANTITY}Increments the quantity of good parts by the value provided in the parameter. 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 by the value provided in the parameter. If used without any parameters then the quantity will be 1.
Send all TMAC data items [PCSDB.send_all_tmac_dataitems]Send and store all TMAC data items.
Send and Save Custom Variable Value [PCSDB.send_save_custom_variable_value] {VARIABLENAME} == VALUESet and save the value for a custom variable to store custom information
Send and Save Custom Variable Indicator [PCSDB.send_save_custom_variable_indicator] {VARIABLENAME} == COLORSet and save the value for a custom variable to store a user definable color code
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 Subtract Good Part [PCSDB.send_subtract_good_part]{QUANTITY}Decrements the quantity of good parts by the value provided in the parameter. 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 by the value provided in the parameter. If used without any parameters then the quantity will be 1.
Send User End to DX [PCSDB.send_user_end] {USER NAME} Marks the selected user as not active
Send User Start to DX [PCSDB.send_user_start] {USER NAME} Marks the selected user as active
Send High Speed Acquired Data Value [PCSDB.send_data_hs] {VARIABLENAME}Send the value of the high speed data acquired the last time a poll took place

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
Send Historical Cycle End to DX [PCSDB.send_end_cycle_historical]{Cycle Status CODE, TIMESTAMP}Ends a general or specific historical cycle.
Send Historical Cycle Start to DX [PCSDB.send_end_cycle_historical]{Cycle Status CODE, TIMESTAMP} Starts a general or specific historical cycle.
Send Historical Unplanned Downtime End to DX [PCSDB.send_unplanned_DT_end_historical]{Unplanned Status CODE, TIMESTAMP}Ends a general or specific unplanned historical.
Send Historical Unplanned Downtime Start to DX [PCSDB.send_unplanned_DT_start_historical]{Unplanned Status CODE, TIMESTAMP}Starts a general or specific unplanned historical.
Send Historical Planned Downtime End to DX [PCSDB.send_planned_DT_end_historical]{Planned Status CODE, TIMESTAMP}Ends general or specific planned historical.
Send Historical Planned Downtime Start to DX [PCSDB.send_planned_DT_start_historical]{Planned Status CODE, TIMESTAMP}Starts 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}

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.
Work Order confirm part counts[PCSDB.wi_wo_confirmed_part_counts]Returns the work order identifier to confirm work order part counts - Used with Data Listeners and ODI.
Work Order update build quantity [PCSDB.wi_wo_build_qty]Returns the work order identifier to update build quantity - Used with Data Listeners and ODI.
Work Order Close [PCSDB.wi_wo_closed]Returns the work order identifier to close the work order - Used with Data Listeners and ODI.
Work Order End (inactivate) [PCSDB.wi_wo_end]Returns the work order identifier to end the work order - Used with Data Listeners and ODI.
Work Order Start [PCSDB.wi_wo_start]Returns the work order identifier to start the work order - Used with Data Listeners and ODI.

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 (Source)

VariableDescription
[Source.connect_time]The time of the last successful poll. Each source has its own connect_time variable.
[Source.prev_connect_time]The previous time of the last successful poll. Each source has its own prev_connect_time variable.
[Source.connected_time]Returns the amount of time in seconds since a successful connection to the source. Each source has its own connected_time variable.
[Source.prev_connected_time]The connected time value from the previous evaluation. Each source has its own prev_connected_time variable.
[PCSDB.connectivity]Returns the state of the connection. Details regarding these values can be found here.
[PCSDB.connectivity_status]Returns the most recent connectivity status that was written to the database. The expression result [PCSDB.send_connectivity_start] will set this to true and [PCSDB.send_connectivity_end] will set this to false.
[PCSDB.poll_count]Returns the number of polls that have taken place.

Connectivity (Target)

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 End [PCSDB.send_connectivity_end]Sends an end event to mark when connectivity to the Source has been lost.

Most 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_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_custom_command_notes
  • PCSDB.prev_custom_variable_indicator
  • PCSDB.prev_custom_variable_time
  • PCSDB.prev_custom_variable_value
  • 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
Table of Contents