GetByKey Method (JobStepData)
- Last UpdatedNov 06, 2025
- 2 minute read
The GetByKey() method retrieves the specified job step data record from the Job_Step_Data table.
'Usage
Dim rowId As Integer
Dim value As DataSet
value = JobStepData.GetByKey(rowId)
Parameters
- rowId
- Required. Holds the row ID of the job step data record.
Return Value
Returns a DataSet that contains the DataRow of the specified job step data in the Job_Step_Data table. If no matching record for the specified job step data is found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
| Column Name | Description |
|---|---|
| wo_id | A string that is the ID of the work order. |
| oper_id | A string that is the ID of the operation. |
| seq_no | An integer that is the operation sequence number of the job. |
| step_no | An integer that is the step number. |
| lot_no | A string that is the lot number of the item that results from the job. |
| sublot_no | A string that is the sublot number of the item that results from the job. |
| state_cd | An integer that is the JobStateCode enumeration that indicates the step state. |
| act_start_time_utc | A datetime that is the time the step was started, in UTC. |
| act_start_time_local | A datetime that is the time the step was started, in the local time of the entity. |
| act_finish_time_utc | A datetime that is the time the step was finished, in UTC. |
| act_finish_time_local | A datetime that is the time the step was finished, in the local time of the entity. |
| step_data | A string that is the data that was logged for the step. |
| step_data_time_utc | A datetime that is the time the step data was entered, in UTC. |
| step_data_time_local | A datetime that is the time the step data was entered, in the local time of the entity. |
| start_user_id | A string that is the ID of the user who started the step. |
| finish_user_id | A string that is the ID of the user who finished the step. |
| data_user_id | A string that is the ID of the user who entered the step data. |
| form_done | A Boolean that indicates whether data entry has been performed for this step. |
| spare1 | A string that is the contents of the user-defined spare1 field. field. |
| spare2 | A string that is the contents of the user-defined spare2 field. field. |
| spare3 | A string that is the contents of the user-defined spare3 field. field. |
| spare4 | A string that is the contents of the user-defined spare4 field. field. |
| spare5 | A string that is the contents of the user-defined spare5 field. field. |
| spare6 | A string that is the contents of the user-defined spare6 field. field. |
| last_edit_comment | A string that contains comments about why the record was added or updated. |
| last_edit_by | A string that is the ID of the user who added or last updated this record. |
| last_edit_at | A datetime that indicates when the record was added or last updated. |
| row_id | An integer that is unique row ID of the record. |