How can we help?
PCSDB Constants and Variables
PCSDB Source Variables
PCSDB Source Variables pull data from the Scytec DataXchange Database.
| Variables | Description | |
|---|---|---|
 | 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. Note this value may reset when a machine changes between Cycle Status types. |
| DX Specific Equipment Status Time [PCSDB.specific_equipment_status_time] | The amount of time in minutes the equipment has been in the same specific 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 Time | Returns 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 Name | Description | |
|---|---|---|
| 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 Name | Description | |
|---|---|---|
| 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} == VALUE | Sets the value for the defined custom variable. Set to empty by omitting "== VALUE" |
| Send Custom Variable Current Indicator [PCSDB.send_custom_variable_indicator] {VARIABLENAME} == COLOR | Sets 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} == VALUE | Set 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} == COLOR | Set 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)
| Variable | Description | |
|---|---|---|
| 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 Part End to DX [PCSDB.send_part_end_historical]{PART NUMBER, TIMESTAMP} | Ends a specified part number in history. Not intended for use with Work Orders. |
| Send Historical Part Start to DX [PCSDB.send_part_start_historical]{PART NUMBER, TIMESTAMP} | Starts a specified part number in history. Not intended for use with Work Orders. |
| 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. |
| Send Historical Program End to DX [PCSDB.send_program_end_historical]{PROGRAM NUMBER, TIMESTAMP} | Ends a specified program number in history. |
| Send Historical Program Start to DX [PCSDB.send_program_start_historical]{PROGRAM NUMBER, TIMESTAMP} | Starts a specified program number in history. |
| 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. |
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)
| Variable | Description | |
|---|---|---|
| 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)
| Variable | Description | |
|---|---|---|
| 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
| Variable | Description | |
|---|---|---|
| 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 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. |
Program Numbers (Target)
| 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 |
Connectivity (Source)
| Variable | Description | |
|---|---|---|
| [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 Name | Notes | |
|---|---|---|
| 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_connectivityPCSDB.prev_connectivity_statusPCSDB.prev_current_logged_on_userPCSDB.prev_current_program_numberPCSDB.prev_current_part_numberPCSDB.prev_current_part_number_timePCSDB.prev_current_work_orderPCSDB.prev_current_wo_operationPCSDB.prev_current_cycle_status_codePCSDB.prev_current_cycle_status_code_timePCSDB.prev_current_pdt_status_codePCSDB.prev_current_pdt_status_code_timePCSDB.prev_current_updt_status_codePCSDB.prev_current_updt_status_code_timePCSDB.prev_custom_command_notesPCSDB.prev_custom_variable_indicatorPCSDB.prev_custom_variable_timePCSDB.prev_custom_variable_valuePCSDB.prev_cycle_status_code_timePCSDB.prev_general_equipment_statusPCSDB.prev_general_equipment_status_timePCSDB.prev_specific_equipment_status_timePCSDB.prev_has_cycle_status_codePCSDB.prev_pdt_status_code_timePCSDB.prev_updt_status_code_timePCSDB.prev_equipment_status_notesPCSDB.prev_in_scheduled_downtimePCSDB.prev_active_shiftPCSDB.prev_in_shiftPCSDB.prev_in_shift_breakPCSDB.prev_shift_break_DT_identifierPCSDB.prev_shift_break_DT_namePCSDB.prev_scheduled_planned_downtime_codePCSDB.prev_scrap_part_notes