{"id":262,"date":"2020-04-29T00:32:41","date_gmt":"2020-04-29T00:32:41","guid":{"rendered":"https:\/\/dxhelpdev.wpengine.com\/?post_type=epkb_post_type_1&p=262"},"modified":"2024-08-20T21:31:22","modified_gmt":"2024-08-20T21:31:22","slug":"pcsdb-constants-and-variables","status":"publish","type":"epkb_post_type_1","link":"https:\/\/dxhelp.scytec.com\/?epkb_post_type_1=pcsdb-constants-and-variables","title":{"rendered":"PCSDB Constants and Variables"},"content":{"rendered":"\n

PCSDB Source Variables<\/h2>\n\n\n\n

PCSDB Source Variables pull data from the Scytec DataXchange Database.<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
<\/td>Variables<\/strong><\/th>Description<\/strong><\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>DX Current Cycle Status Code [PCSDB.current_cycle_status_code]<\/td>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.<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Cycle Status Code Time [PCSDB.current_cycle_status_code_time]<\/td>The amount of time in minutes the equipment has been in the same cycle status code.<\/td>\n<\/tr>\n
\"\"<\/td>DX Cycle Status Code Time [PCSDB.cycle_status_code_time] {CYCLE STATUS CODE}<\/td>The amount of time in minutes the equipment has been in the status code specified in the parameter.<\/td>\n<\/tr>\n
\"\"<\/td>DX General Equipment Status [PCSDB.general_equipment_status]<\/td>This will always be one of the four General statuses: [PCSDB.CYCLING], [PCSDB.UNKNOWN_DOWNTIME], [PCSDB.Unplanned_Downtime], or [PCSDB.Planned_Downtime].\u00a0If any cycle status is active then the General Cycle Equipment Status is Active.\u00a0Likewise for Unplanned and Planned downtimes.<\/td>\n<\/tr>\n
\"\"<\/td>DX General Equipment Status Time [PCSDB.general_equipment_status_time]<\/td>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.<\/td>\n<\/tr>\n
\"\"<\/td>DX Specific Equipment Status Time [PCSDB.specific_equipment_status_time]<\/td>The amount of time in minutes the equipment has been in the same specific status.<\/td>\n<\/tr>\n
\"\"<\/td>DX Has Cycle Status Code [PCSDB.has_cycle_status_code] {CYCLE STATUS CODE}<\/td>Returns True or False depending on if the cycle status code specified in the parameter is active or not.<\/td>\n<\/tr>\n
\"\"<\/td>Active Shift [PCSDB.active_shift]<\/td>The active shift name if the equipment is currently in an active shift<\/td>\n<\/tr>\n
\"\"<\/td>Constant [PCSDB.constant] {CONSTANTVARIABLE}<\/td>Returns the value of the specified PCSDB Constant.<\/td>\n<\/tr>\n
\"\"<\/td>Current Plant Name [PCSDB.plant]<\/td>The plant the equipment is associated with<\/td>\n<\/tr>\n
\"\"<\/td>Current Program Number [PCSDB.current_program_number]<\/td>Returns the current active program number on the Equipment.<\/td>\n<\/tr>\n
\"\"<\/td>Current Time [PCSDB.current_time]<\/td>The time at which the expression is evaluated.\u00a0In expression time must be written as HH:MM in 24 hour format.\u00a0For 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)<\/td>\n<\/tr>\n
\"\"<\/td>Current Time Stamp [PCSDB.current_timestamp]<\/td>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.<\/td>\n<\/tr>\n
\"\"<\/td>Custom Command Notes [PCSDB.custom_command_notes]<\/td>Returns the last note entered into the ODI Screen for Custom Commands<\/td>\n<\/tr>\n
\"\"<\/td>Custom Variable Indicator [PCSDB.custom_variable_indicator]{variableName}<\/td>The current color code of the specified custom variable.<\/td>\n<\/tr>\n
\"\"<\/td>Custom Variable Time [PCSDB.custom_variable_time]{variableName}<\/td>The amount of time in seconds that the custom variable has had the current value.<\/td>\n<\/tr>\n
\"\"<\/td>Custom Variable Value [PCSDB.custom_variable_value]{variableName}<\/td>The current value of the specified Custom Variable.<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Planned Downtime Status Code [PCSDB.current_pdt_status_code]<\/td>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}}\u00a0parameter to see if the current status code is within the specified group name and will return True or False.<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Planned Downtime Status Code Time [PCSDB.current_pdt_status_code_time]<\/td>The amount of time in minutes the equipment has been in the current planned downtime status.<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Unplanned Downtime Status Code [PCSDB.current_updt_status_code]<\/td>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}}\u00a0parameter to see if the current status code is within the specified group name and will return True or False.<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Unplanned Downtime Status Code Time [PCSDB.current_updt_status_code_time]<\/td>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.<\/td>\n<\/tr>\n
\"\"<\/td>DX Planned Downtime Status Code Time [PCSDB.pdt_status_code_time] {DOWNTIME CODE}<\/td>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.<\/td>\n<\/tr>\n
\"\"<\/td>DX Unplanned Downtime Status Code Time [PCSDB.updt_status_code_time] {DOWNTIME CODE}<\/td>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<\/td>\n<\/tr>\n
\"\"<\/td>DX ODI Flashing State [PCSDB.current_odi_flashing]<\/td>Returns True or False based on if the machine is currently flashing on the ODI.<\/td>\n<\/tr>\n
\"\"<\/td>Equipment Status Notes [PCSDB.equipment_status_notes]<\/td>Returns the last note entered into the ODI Screen for Equipment Statuses<\/td>\n<\/tr>\n
\"\"<\/td>In Scheduled Downtime [PCSDB.in_scheduled_downtime]<\/td>Returns True if currently in a Scheduled Downtime, otherwise false.<\/td>\n<\/tr>\n
\"\"<\/td>In Shift [PCSDB.in_shift]<\/td>Returns True if the equipment is currently in a defined shift, otherwise False.<\/td>\n<\/tr>\n
\"\"<\/td>In Shift Break [PCSDB.in_shift_break]<\/td>Returns True if the equipment is currently in a defined shift break, otherwise False.<\/td>\n<\/tr>\n
\"\"<\/td>Scheduled Planned Downtime Code [PCSDB.scheduled_planned_downtime_code]<\/td>The currently active scheduled planned downtime identifier, such as 201, or 202.<\/td>\n<\/tr>\n
\"\"<\/td>Scrap Part Notes [PCSDB.scrap_part_notes]<\/td>Returns the current ODI Scrap Count Note.<\/td>\n<\/tr>\n
\"\"<\/td>Shift Break DT Identifier [PCSDB.shift_break_DT_identifier]<\/td>If the equipment is in a defined Shift Break this will hold the identifier for the Planned Downtime assigned to the Shift Break.<\/td>\n<\/tr>\n
\"\"<\/td>Shift Break DT Name [PCSDB.shift_break_DT_name]<\/td>If the equipment is in a defined Shift Break this will hold the name of the Planned Downtime assigned to the Shift Break.<\/td>\n<\/tr>\n
\"\"<\/td>Status Identifier for Cycle End [PCSDB.SI_Cycle_End] {CYCLE STATUS CODE}<\/td>The status identifier for a Cycle end signal - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Status Identifier for Cycle Start [PCSDB.SI_Cycle_Start] {CYCLE STATUS CODE} <\/td>The status identifier for a Cycle start signal - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Status Identifier for Planned Downtime End [PCSDB.SI_Planned_DT_End] {PLANNED STATUS CODE} <\/td>The status identifier for a planned downtime end signal - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Status Identifier for Planned Downtime Start [PCSDB.SI_Planned_DT_Start] {PLANNED STATUS CODE} <\/td>The status identifier for a Planned Downtime start signal - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Status Identifier for Unplanned Downtime End [PCSDB.SI_Unplanned_DT_End] {UNPLANNED STATUS CODE} <\/td>The status identifier for an Unplanned Downtime end signal - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Status Identifier for Unplanned Downtime Start [PCSDB.SI_Unplanned_DT_Start] {UNPLANNED STATUS CODE} <\/td>The status identifier for an Unplanned Downtime start signal - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Unknown Downtime Start Time<\/td>Returns the start time of Unknown Downtime, if the machine is in Unknown Downtime.<\/td>\n<\/tr>\n
\"\"<\/td>Alarms [PCSDB.alarms]<\/td>Returns active Alarm numbers and descriptions.<\/td>\n<\/tr>\n
\"\"<\/td>Part Identifier for Part Start [PCSDB.PI_part_start]<\/td>Returns the Part Start identifier for making a part active - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Current Logged on User [PCSDB.current_logged_on_user]<\/td>Returns the username of the active user for the machine<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Part Number [PCSDB.current_part_number]<\/td>Returns the current active part number on the Equipment<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Part Number Time [PCSDB.current_part_number_time]<\/td>Returns the amount of time in minutes the current part number has been active on Equipment<\/td>\n<\/tr>\n
\"\"<\/td>Ideal Cycle Time [PCSDB.ideal_cycle_time]<\/td>Returns the Ideal Cycle Time for the active part number on the Equipment<\/td>\n<\/tr>\n
\"\"<\/td>Ideal Operation Time [PCSDB.ideal_operation_time]<\/td>Returns the Ideal Operation Time for the active part number on the Equipment<\/td>\n<\/tr>\n
\"\"<\/td>Ideal Setup Time [PCSDB.ideal_setup_time]<\/td>Returns the Ideal Setup Time on the Equipment<\/td>\n<\/tr>\n
\"\"<\/td>Part Count Identifier for Add Good Part [PCSDB.PCI_add_good_part]<\/td>Returns the Part Count Identifier for Adding a Good Part - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Part Count Identifier for Add Scrap Part [PCSDB.PCI_add_scrap_part]<\/td>Returns the Part Count Identifier for Adding a Scrap Part - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Part Count Identifier for Subtract Good Part [PCSDB.PCI_subtract_good_part]<\/td>Returns the Part Count Identifier for Subtracting a Good Part - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Part Count Identifier for Subtract Scrap Part [PCSDB.PCI_subtract_scrap_part]<\/td>Returns the Part Count Identifier for Subtracting a Scrap Part - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Part Identifier for Part End [PCSDB.PI_part_end]<\/td>Returns the Part End identifier for making a part inactive - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Part Number Active [PCSDB.part_number_active]<\/td>Returns True if a Part Number is active, otherwise false<\/td>\n<\/tr>\n
\"\"<\/td>Parts Per Hour Percent [PCSDB.pph_percent] {PARTS PER HOUR PERCENT} <\/td>Returns Parts Per Hour Percent for current equipment and part number<\/td>\n<\/tr>\n
\"\"<\/td>Parts Per Hour Plan [PCSDB.pph_plan] {PARTS PER HOUR PLAN}<\/td>Returns Parts Per Hour Plan for current equipment and part number<\/td>\n<\/tr>\n
\"\"<\/td>User Active [PCSDB.user_active]<\/td>Returns True if a User is active, otherwise false<\/td>\n<\/tr>\n
\"\"<\/td>User Identifier for User End [PCSDB.UI_user_end]<\/td>Returns the User End identifier - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>User Identifier for User Start [PCSDB.UI_user_start]<\/td>Returns the User Start identifier - Used with Data Listeners and ODI<\/td>\n<\/tr>\n
\"\"<\/td>Work Order Active [PCSDB.work_order_active]<\/td>Returns True if a Work Order is active, otherwise false<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

PCSDB Constants<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t
<\/td>Constant Name<\/th>Description<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>General Cycling [PCSDB.CYCLING]<\/td>Constant value representing general Cycle status.<\/td>\n<\/tr>\n
\"\"<\/td>General Planned Downtime [PCSDB.Planned_Downtime]<\/td>Constant value representing general Planned Downtime.<\/td>\n<\/tr>\n
\"\"<\/td>General Unknown Downtime [PCSDB.UNKNOWN_DOWNTIME]<\/td>Constant value representing general Unknown Downtime.<\/td>\n<\/tr>\n
\"\"<\/td>General Unplanned Downtime [PCSDB.Unplanned_Downtime]<\/td>Constant value representing general Unplanned Downtime.<\/td>\n<\/tr>\n
\"\"<\/td>Is Empty Value [PCSDB.IS_EMPTY]<\/td>A constant representing an empty string value.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

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

Historical (Target)<\/h2>\n\n\n\n

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)<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
<\/td>Variable<\/th>Description<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>Send Historical Cycle End to DX [PCSDB.send_end_cycle_historical]{Cycle Status CODE, TIMESTAMP}<\/td>Ends a general or specific historical cycle.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Cycle Start to DX [PCSDB.send_end_cycle_historical]{Cycle Status CODE, TIMESTAMP}\u00a0<\/td>Starts a general or specific historical cycle.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Part End to DX [PCSDB.send_part_end_historical]{PART NUMBER, TIMESTAMP}<\/td>Ends a specified part number in history. Not intended for use with Work Orders.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Part Start to DX [PCSDB.send_part_start_historical]{PART NUMBER, TIMESTAMP}<\/td>Starts a specified part number in history. Not intended for use with Work Orders.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Planned Downtime End to DX [PCSDB.send_planned_DT_end_historical]{Planned Status CODE, TIMESTAMP}<\/td>Ends general or specific planned historical.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Planned Downtime Start to DX [PCSDB.send_planned_DT_start_historical]{Planned Status CODE, TIMESTAMP}<\/td>Starts general or specific planned historical.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Program End to DX [PCSDB.send_program_end_historical]{PROGRAM NUMBER, TIMESTAMP}<\/td>Ends a specified program number in history.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Program Start to DX [PCSDB.send_program_start_historical]{PROGRAM NUMBER, TIMESTAMP}<\/td>Starts a specified program number in history.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Unplanned Downtime End to DX [PCSDB.send_unplanned_DT_end_historical]{Unplanned Status CODE, TIMESTAMP}<\/td>Ends a general or specific unplanned historical.<\/td>\n<\/tr>\n
\"\"<\/td>Send Historical Unplanned Downtime Start to DX [PCSDB.send_unplanned_DT_start_historical]{Unplanned Status CODE, TIMESTAMP}<\/td>Starts a general or specific unplanned historical.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

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

[PCSDB.send_start_cycle]<\/code><\/p>\n\n\n\n

If specific cycle status are being used then the cycle status to change should be placed in the brackets:<\/p>\n\n\n\n

[PCSDB.send_start_cycle] {100}<\/code><\/p>\n\n\n\n

Work Orders (Source)<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
<\/td>Variable<\/th>Description<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>DX Current Work Order [PCSDB.current_work_order]<\/td>Returns the current work order<\/td>\n<\/tr>\n
\"\"<\/td>DX Current Work Order Operation [PCSDB.current_wo_operation]<\/td>Returns the current work order operation<\/td>\n<\/tr>\n
\"\"<\/td>Current work order build quantity [PCSDB.wo_build_qty]<\/td>Returns the build quantity for the current work order.<\/td>\n<\/tr>\n
\"\"<\/td>Work Order confirm part counts[PCSDB.wi_wo_confirmed_part_counts]<\/td>Returns the work order identifier to confirm work order part counts - Used with Data Listeners and ODI.<\/td>\n<\/tr>\n
\"\"<\/td>Work Order update build quantity [PCSDB.wi_wo_build_qty]<\/td>Returns the work order identifier to update build quantity - Used with Data Listeners and ODI.<\/td>\n<\/tr>\n
\"\"<\/td>Work Order Close [PCSDB.wi_wo_closed]<\/td>Returns the work order identifier to close the work order - Used with Data Listeners and ODI.<\/td>\n<\/tr>\n
\"\"<\/td>Work Order End (inactivate) [PCSDB.wi_wo_end]<\/td>Returns the work order identifier to end the work order - Used with Data Listeners and ODI.<\/td>\n<\/tr>\n
\"\"<\/td>Work Order Start [PCSDB.wi_wo_start]<\/td>Returns the work order identifier to start the work order - Used with Data Listeners and ODI.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Work Orders (Target)<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t
<\/td>Variable<\/th>Description<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>Send build quantity to DX [PCSDB.send_wo_build_qty] {WORK ORDER DATA}<\/td>Updates the selected work order build quantity<\/td>\n<\/tr>\n
\"\"<\/td>Close work order [PCSDB.send_wo_closed] {WORK ORDER DATA}<\/td>Marks the selected work order closed<\/td>\n<\/tr>\n
\"\"<\/td>Current work order build quantity [PCSDB.send_wo_confirmed_part_counts] {WORK ORDER DATA}<\/td>Updates the current work order with confirmed good and scrap part count<\/td>\n<\/tr>\n
\"\"<\/td>Inactivate work order [PCSDB.send_wo_end]<\/td>Marks the selected work order inactive<\/td>\n<\/tr>\n
\"\"<\/td>Activate work order [PCSDB.send_wo_start]{work_order,operation_number}<\/td>Marks the selected work order active<\/td>\n<\/tr>\n
\"\"<\/td>Activate work order, part number, and operation [PCSDB.send_wo_part_op_start] {WORK ORDER DATA}<\/td>Marks the selected work order, part number, and operation as active<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Scheduled Planned Downtime<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t
<\/td>Variable<\/th>Description<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>Scheduled Planned Downtime Code[PCSDB.scheduled_planned_downtime_code]<\/td>The currently active scheduled planned downtime identifier, such as 201, or 202.<\/td>\n<\/tr>\n
\"\"<\/td>Prev Scheduled Planned Downtime Code[PCSDB.prev_scheduled_planned_downtime_code]<\/td>The identifier of the scheduled planned downtime that was active on the previous poll<\/td>\n<\/tr>\n
\"\"<\/td>In Scheduled Downtime[PCSDB.in_scheduled_downtime]<\/td>This variable will hold a value of True if the equipment is currently in an active scheduled downtime<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Program Numbers (Source)<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t
<\/td>Variable Name<\/strong><\/th>Variable Syntax<\/strong><\/th>Description<\/strong><\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>Current Program Number<\/td>PCSDB.current_program_number<\/td>Returns the current active program number on the Equipment.<\/td>\n<\/tr>\n
\"\"<\/td>Current Program Number (Previous)<\/td>PCSDB.prev_current_program_number<\/td>Returns active program number on the Equipment from the previous poll.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Program Numbers (Target)<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t
<\/td>Variable Name<\/strong><\/th>Variable Syntax<\/strong><\/th>Description<\/strong><\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>Send program number end to DX<\/td>[PCSDB.send_program_number_end] {PROGRAM NUMBER}<\/td>Marks the selected program as not active<\/td>\n<\/tr>\n
\"\"<\/td>Send program start to DX<\/td>[PCSDB.send_program_number_start] {PROGRAM NUMBER}<\/td>Marks the selected program as active<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Connectivity (Source)<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t
<\/td>Variable<\/th>Description<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>[Source.connect_time]<\/td>The time of the last successful poll. Each source has its own connect_time variable.<\/td>\n<\/tr>\n
\"\"<\/td>[Source.prev_connect_time]<\/td>The previous time of the last successful poll. Each source has its own prev_connect_time variable.<\/td>\n<\/tr>\n
\"\"<\/td>[Source.connected_time]<\/td>Returns the amount of time in seconds since a successful connection to the source. Each source has its own connected_time variable.<\/td>\n<\/tr>\n
\"\"<\/td>[Source.prev_connected_time]<\/td>The connected time value from the previous evaluation. Each source has its own prev_connected_time variable.<\/td>\n<\/tr>\n
\"\"<\/td>[PCSDB.connectivity]<\/td>Returns the state of the connection. Details regarding these values can be found here<\/a>.<\/td>\n<\/tr>\n
\"\"<\/td>[PCSDB.connectivity_status]<\/td>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.<\/td>\n<\/tr>\n
\"\"<\/td>[PCSDB.poll_count]<\/td>Returns the number of polls that have taken place.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Connectivity (Target)<\/h2>\n\n\n\n\n\n\n\t\n\n\t\n\t
<\/td>Variable Name<\/th>Notes<\/th>\n<\/tr>\n<\/thead>\n
\"\"<\/td>Send Connectivity Start [PCSDB.send_connectivity_start]<\/td>Sends a start event to mark when connectivity to the Source has been established.<\/td>\n<\/tr>\n
\"\"<\/td>Send Connectivity End [PCSDB.send_connectivity_end]<\/td>Sends an end event to mark when connectivity to the Source has been lost.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n

Most variables also have a corresponding Previous variable which will hold the status from the last time a poll took place.<\/p>\n\n\n\n

    \n
  • PCSDB.prev_connectivity<\/code><\/li>\n\n\n\n
  • PCSDB.prev_connectivity_status<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_logged_on_user<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_program_number<\/code><\/span><\/li>\n\n\n\n
  • PCSDB.prev_current_part_number<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_part_number_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_work_order<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_wo_operation<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_cycle_status_code<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_cycle_status_code_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_pdt_status_code<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_pdt_status_code_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_updt_status_code<\/code><\/li>\n\n\n\n
  • PCSDB.prev_current_updt_status_code_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_custom_command_notes<\/code><\/li>\n\n\n\n
  • PCSDB.prev_custom_variable_indicator<\/code><\/li>\n\n\n\n
  • PCSDB.prev_custom_variable_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_custom_variable_value<\/code><\/li>\n\n\n\n
  • PCSDB.prev_cycle_status_code_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_general_equipment_status<\/code><\/li>\n\n\n\n
  • PCSDB.prev_general_equipment_status_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_specific_equipment_status_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_has_cycle_status_code<\/code><\/li>\n\n\n\n
  • PCSDB.prev_pdt_status_code_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_updt_status_code_time<\/code><\/li>\n\n\n\n
  • PCSDB.prev_equipment_status_notes<\/code><\/li>\n\n\n\n
  • PCSDB.prev_in_scheduled_downtime<\/code><\/li>\n\n\n\n
  • PCSDB.prev_active_shift<\/code><\/li>\n\n\n\n
  • PCSDB.prev_in_shift<\/code><\/li>\n\n\n\n
  • PCSDB.prev_in_shift_break<\/code><\/li>\n\n\n\n
  • PCSDB.prev_shift_break_DT_identifier<\/code><\/li>\n\n\n\n
  • PCSDB.prev_shift_break_DT_name<\/code><\/li>\n\n\n\n
  • PCSDB.prev_scheduled_planned_downtime_code<\/code><\/li>\n\n\n\n
  • PCSDB.prev_scrap_part_notes<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

    PCSDB Source Variables PCSDB Source Variables pull data from the Scytec DataXchange Database. PCSDB Constants PCSDB Target Commands and Variables 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) The information in the curly brackets are parameters.  If general cycle […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"epkb_post_type_1_category":[52],"epkb_post_type_1_tag":[],"class_list":["post-262","epkb_post_type_1","type-epkb_post_type_1","status-publish","hentry","epkb_post_type_1_category-pcsdb-constants-and-variables"],"_links":{"self":[{"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1\/262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1"}],"about":[{"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=\/wp\/v2\/types\/epkb_post_type_1"}],"author":[{"embeddable":true,"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=262"}],"version-history":[{"count":0,"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=\/wp\/v2\/epkb_post_type_1\/262\/revisions"}],"wp:attachment":[{"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=262"}],"wp:term":[{"taxonomy":"epkb_post_type_1_category","embeddable":true,"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fepkb_post_type_1_category&post=262"},{"taxonomy":"epkb_post_type_1_tag","embeddable":true,"href":"https:\/\/dxhelp.scytec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fepkb_post_type_1_tag&post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}