Transaction prompts define where and in what order the data collection module populates information in Datastream 7i. You can validate incoming data at the field level, as well as at conditional navigation between prompts.
Referring to the data collection plan created earlier, determine what data to enter (Fixed, Computed, or Calculated), in what sequence it should be gathered, and how to group data for processing to APIs. Define data prompts for each barcode transaction type.
For equipment audits, create scanner prompts with the Interface type A (Equipment Audits) and L (Equipment Audit Lines).
Define the directory for the scanner prompts on the Installation codes form (BNINST).
Follow these steps to define transaction prompts.
Open the Data collection tracking prompts form (TMASTP).
Transaction type—Click to select the transaction type for which to define prompts. The values shown belong to the TKTP entity.
Transaction sequence—Enter a unique code identifying the prompt/processing definition line within the scanning transaction. The first process in the sequence must be 1, and you may not skip numbers. The maximum number of transactions in a sequence is 50.
Description/prompt—Enter the prompt as it is to appear. The maximum number of characters is 22.
Data type—Click to select one of the following options:
A (Alphabetic)—Select for alphabetic characters.
N (Numeric)—Select for numeric characters.
F (Fixed)—Select for Datastream 7i to automatically enter a fixed value.
C (Computed)—Select for Datastream 7i to automatically make a calculation.
D (Date)—Select for Datastream 7i to prompt for data that has a time component.
Choose one of the following options:
If you selected F (Fixed) for Data type—Enter, for Fixed data, the fixed data value for this prompt. For example, if equipment type will always be Asset, enter A.
If you selected C (Computed) for Data type—Enter, for Computed data, the SQL command string used for the calculation. Use TKD_PROMPTDATA1, TKD_PTOMPTDATA2, etc., to refer to the relevant column on the tracking transaction table.
If you selected D (Date) for Data type—Enter, for Date format mask, a date format mask. The date format mask should match the data that is being entered in the data collection upload columns.
Archive column—Click to select the column where Datastream 7i archives transaction data.
Interface type—Click to select one of the following APIs:
A (Equipment audits)—Select to indicate the equipment audit starting point and designate a batch number.
E (Events (work order) interface)—Select to create and update work orders and activities.
H (Booked hrs interface)—Select to book labor hours on a work order activity.
I (Inventory issues)—Select to track inventory transactions of assets or parts, such as issues, returns, store-to-store movements, etc.
IRI (Inspection results interface)—Select to track inspection results.
L (Equipment audit lines)—Select to indicate the equipment audit data.
MANF (Manufacturers interface)—Select to track manufacturer information.
O (Equipment interface)—Select to track assets, hierarchies, and user attributes.
PART (Parts interface)—Select to create and update part information.
PURC (Purchase order interface)—Select to download, create, and update purchase orders.
R (P.o. receipt)—Select to receive assets and parts with or without a purchase order.
READ (Readings interface)—Select to record meter readings.
REQ (Requisition interface)—Select to create and update requisitions for Goods requested transactions.
STTK (Stocktake interface)—Select to enter physical inventory counts.
TOUS (Tool usage interface)—Select to track tool usage information.
Group sequence—Enter the sequence in which to group data collection transactions.
Upload column—Click to select the interface column into which to load the data.
Action code—Click to select the action that the selected interface performs on this data.
Prompt sequence—Enter the chronological order in which this prompt occurs. The maximum number of digits is five. Do not skip sequence numbers.
SQL code—Click to select the SQL code that defines a list of values for this prompt.
Minimum size—Enter the minimum number of characters required for the data to enter at the prompt. The maximum number of digits is five. Enter nothing or 0 to make this prompt optional.
Maximum size—Enter the maximum number of characters required for the data to enter at the prompt. The maximum number of digits is five. The value you enter must be greater than or equal to Minimum size.
Duplicate previous value—Select to allow the value from the previous record to be duplicated (by pressing the F1 key on the barcode scanner).
Pattern match—Enter the pattern matching to be performed by the scanner. Pattern characters can include the following values:
. (period)—Represents a single alphabetical character, A through Z
# (pound sign)—Represents any single number, 0 through 9
_ (underscore)—Represents any single alphanumeric character, A through Z and 0 through 9
% (percent)—Represents a string of alphanumeric characters
, (comma)—Represents an OR condition
: (colon)—Represents a THROUGH condition
Any character(s) or number(s)—Indicates that exact character or number in that position
! any character(s) or number(s)—Indicates data entered should not match what follows the "!"
For example, if you enter S## for the slot prompt, Datastream 7i accepts a response that begins with S and is followed by two numbers. You can also combine patterns using the comma (or condition: S##, F##) or the colon (through condition: F##:S##). The maximum number of digits is 45.
If data is—Enter branch conditions, as necessary. Branch conditions include the following values:
> represents greater than
< represents less than
= represents equal to
>= represents greater than or equal to
<= represents less than or equal to
!= represents not equal
|
Datastream suggests that you prompt the user once and then use a calculated field for each subsequent time. |
Pattern—Enter the pattern of the data collected. You can enter only one pattern.
Go to—Enter the prompt to display if the result of If data is and Pattern is true.
Validate file—Enter the filename of an ASCII text file against which to validate entries. The filename must be in DOS format. For example, you can enter a file containing a list of authorized employee codes. When you enter an employee code, the reader accesses the file and validates the scanned code against the employee list.
LOV attached—Select to make the list of values defined by SQL Code available. If you do not select this field, Datastream 7i still validates data against SQL Code, but the list of values is not available.
Not available—Select to ensure data entered is not in the list of values.
Override—Select to allow users to enter nonvalid data if Not available is unselected or to enter valid data if Not available is selected.
Next prompt—Enter the next prompt to display on the barcode scanner. The maximum number of digits is five.
Click Validate. Datastream 7i validates all transactions for proper syntax, for correct prompt sequence starts, and for gaps in sequences, etc.
If Datastream 7i encounters a problem, it displays an error message. Correct the problem, and then revalidate.
Choose File | Save from the menu bar. Datastream 7i saves the information to the database.