Actual time spent on a work order by an operator is recorded using the Clock In and Clock Out capability. This time input is used to charge the manual resource transactions for calculating the work in process inventory value for particular accounting periods. MES for Discrete Manufacturing can be integrated other time and attendance systems to collect actual time. Third party systems are often deployed to collect definite and exact actual recorded times, and pass the data to a payroll application. These systems might be used by organizations where labor costs are high, or actual time recording is a mandatory requirement for government regulations.
To integrate other time and attendance systems into MES, an interface table and concurrent program are used:
The WIP_TIME_ENTRY_INTERFACE table is used to enter records for direct labor hours and actual attendance hours.
The Import Time Entry Records concurrent program moves records from this table and imports them into the MES system.
The TIME_ENTRY_TYPE column is used for differentiating between various time type records and records for Direct Labor Hours, Scheduled Available Hours, and Actual Attendance Hours.
If the WIP_ENTITY_TYPE or JOB_NAME columns are null - the record entered is considered either Scheduled Available Hours or Actual Attendance Hours.
If these columns not null, the record entered is considered Direct Labor Hours.
| Column Name | Type | Description |
|---|---|---|
| INTERFACE_ID | NUMBER | Unique record identification |
| TIME_ENTRY_TYPE | NUMBER | Time entry record types:
|
| ORGANIZATION_ID | NUMBER | Organization identifier |
| ORGANIZATION_CODE | VARCHAR2 | Organization code |
| WIP_ENTITY_ID | NUMBER | Work order identifier |
| JOB_NAME | VARCHAR2 | Job name |
| OPERATION_SEQ_NUMBER | NUMBER | Operation sequence number |
| DEPARTMENT_CODE | VARCHAR2 | Department code |
| DEPARTMENT_ID | NUMBER | Department identifier |
| RESOURCE_SEQ_NUM | NUMBER | Resource sequence number |
| RESOURCE_CODE | VARCHAR2 | Resource code |
| RESOURCE_ID | NUMBER | Resource identifier |
| UOM_CODE | VARCHAR2 | Unit of Measure code |
| EMPLOYEE_ID | NUMBER | Employee identifier |
| ACTUAL_START_DATE | DATE | Actual start date |
| ACTUAL_END_DATE | DATE | Actual end date |
| DURATION | NUMBER | Duration |
| ACTION_FLAG | NUMBER | Action:
|
| PROCESS_STATUS | NUMBER | Process status |
| ERROR | VARCHAR2 | Error Message |
| REQUEST_ID | NUMBER | Concurrent request identification |
| PROGRAM_ID | NUMBER | Program identification |
| PROGRAM_APPLICATION_ID | NUMBER | Program application identification |
| Program_update_date PROGRAM_UPDATE_DATE | DATE | Program update date |
| CREATED_BY | NUMBER | Created by |
| CREATION_DATE | DATE | Record date creation |
| LAST_UPDATED_BY | NUMBER | Last updated by action |
| LAST_UPDATE_DATE | DATE | Last update date |
| LAST_UPDATE_LOGIN | NUMBER | Login information for last update |
The Import Time Entry concurrent request imports actual times captured through the WIP_TIME_ENTRY_INTERFACE table into MES for calculation of labor performance metrics.
For each valid row in the interface table, the API, WIP_TIME_ENTRY_PUB.process reads all pending transactions for the given organization, and performs the following validations:
Actual times are imported for valid badges (employee identification numbers), job operations, and organizations.
If the Departmental Access parameter is set to Assigned, Clock In and Clock Out times are imported if the employee is attached as a resource instance for a department.
If the Shift In and Shift Out flags are enabled in the Time Entry Mode parameter, captured attendance hour records are not imported.
If Clock In and Clock Out flags are enabled in the Time Entry Mode parameter, labor hours are not imported.