In AutoTime 6, APIs are used to import data into Shop Floor Time. For example, the BADG API is used to add badge numbers to the database and associate them with employee numbers. The ENTY API is used to add entity records (work orders, operations, and so on) to the database. The AutoTime 6 APIs provide a fixed-length structure for the data that is being imported.
If you are upgrading from AutoTime 6 to Shop Floor Time, you can use your API records to import master data into Shop Floor Time. Shop Floor Time includes predefined Import Definitions that map the API data to the Shop Floor Time database. The steps for using the AutoTime 6 API imports are explained below.
For a list of the AutoTime 6 APIs and their fields that are supported by the Shop Floor Time interface, see Supported APIs and Fields.
See Also:
1. Set up your Shop Floor Time database with configuration data such as hierarchies, shifts, schedules, and employee groups (facilities and policy groups).
2. If necessary, modify the AutoTime 6 API transactions in the Distribution Model form.
3. Set up the Import Definitions for the AutoTime 6 APIs.
4. Place the AutoTime 6 API data in the interface_in_queue table.
5. Run the IN_QUEUE_TEXT Service.
Before you import your AutoTime 6 API data, you will need to setup your Shop Floor Time database with configuration data, such as:
Hierarchy
Shifts
Schedules
Pay Scales
Employee Groups for Facility and Policy Group
Terminal Filtration
Event Filtration
The Distribution Model form (Main Menu > Configuration > Interfaces > Distribution Model) lists the transaction names for each of the supported AutoTime 6 APIs. These transactions are pre-defined with the Sender Name AUTOTIM6, Receiver Name AUTOTIME, and the default Import Definition for that API. You can modify and enable/disable these transactions as necessary.
The IN_QUEUE_TEXT service uses its SENDER_NAME and TRANSACTION_GROUP parameters to look up a record in the Distribution Model that will indicate the Import Name to use. The Import Name, defined in the Import Definition form, defines the API source data that will be imported from the interface_in_queue table.
Each of the supported AutoTime 6 APIs has its own pre-defined Import Definition. You can view and modify these Import Definitions as necessary in the Import Definition form (Main Menu > Configuration > Interfaces > Import Definition).
It is recommended that you copy the system-defined Import Definitions and modify the duplicate versions, if you plan on changing them.
For a list of the AutoTime 6 APIs and their fields that are supported by the Shop Floor Time interface, see Supported APIs and Fields.
You will need to place your AutoTime 6 API records in the interface_in_queue table in Shop Floor Time. The IN_QUEUE_TEXT service will extract this data and insert it in the appropriate Shop Floor Time database tables based on the Import Definition associated with the transaction.
The Process Name for these records must be set to CONVERT_TEXT.
The IN_QUEUE_TEXT service will take the AutoTime 6 API records from the interface_in_queue table (which can be viewed in the Interface In Queue form), convert the records to a format that Shop Floor Time can read, and imports the data into the appropriate Shop Floor Time tables.
This section lists the fields in the supported AutoTime 6 APIs that can be imported to Shop Floor Time.
If a field is Not Supported, it will be ignored by the import service, unless you specifically map it to another field such as a flex field.
The BADG API in AutoTime 6 is used to associate badges with employees.
The table below shows how the fields in the BADG API will be mapped to the Shop Floor Time database.
BADG API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
PERSON |
FI_ACTION |
BADGE_NUM |
20 |
PERSON |
FI_BADGE_NUM |
TYPE_OF_BADGE |
1 |
PERSON |
FI_BADGE_TYPE. Needs translation. |
ISSUE_STATUS |
1 |
|
Not Supported |
EMP_NUM |
20 |
PERSON |
FI_PERSON_NUM |
ISSUE_DATE |
14 |
PERSON |
FI_START_DATE |
EXPIR_DATE |
14 |
PERSON |
FI_END_DATE |
CREATE_DATE |
14 |
|
Not Supported |
FI_BADGE_TYPE Field Translation
Shop Floor Time Interface Field Name |
AutoTime 6 API Value |
Shop Floor Time Translated Value |
FI_BADGE_TYPE |
C |
CONTRACT |
FI_BADGE_TYPE |
P |
PERMANENT |
FI_BADGE_TYPE |
T |
TEMPORARY |
The BANK API in AutoTime 6 inserts the Bank History records that accumulate and track employee time-off bank hours.
The table below shows how the fields in the BANK API will be mapped to the Shop Floor Time database.
BANK API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
ACCRUAL |
FI_ACTION |
EMPLOYEE_NUM |
20 |
ACCRUAL |
FI_PERSON_NUM |
BANK_TYPE |
10 |
ACCRUAL |
FI_BALANCE_CODE. Needs translation. |
BANK_YEAR |
4 |
ACCRUAL |
FI_BALANCE_YEAR |
EARNED_HOURS |
8 |
ACCRUAL |
FI_EARN_VALUE |
CARRYOVER_HOURS |
8 |
ACCRUAL |
FI_CARRY_OVER_VALUE |
USED_PAID_HOURS |
8 |
ACCRUAL |
FI_USED_PAID_VALUE |
USED_UNPAID_HOURS |
8 |
ACCRUAL |
FI_USED_UNIPAID_VALUE |
START_DATE |
14 |
ACCRUAL |
FI_START_DATE |
END_DATE |
14 |
ACCRUAL |
FI_END_DATE |
BANK_UNITS |
1 |
ACCRUAL |
FI_UNIT |
FI_BALANCE_CODE Field Translation
Shop Floor Time Interface Field Name |
AutoTime 6 API Value |
Shop Floor Time Translated Value |
FI_BALANCE_CODE |
V |
VACATION |
FI_BALANCE_CODE |
I |
SICK |
FI_BALANCE_CODE |
P |
PERSONAL |
The EADH API in AutoTime 6 inserts user-defined code information into the emp_ad_hoc table and links the records to the user_codes table and the emp_profile table. This data can be used to create user-defined reports.
The table below shows how the fields in the EADH API will be mapped to the Shop Floor Time database.
EADH API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
PERSON_ADHOC |
FI_ACTION |
EMP_NUM |
20 |
PERSON_ADHOC |
FI_PERSON_NUM |
CODE_NAME |
5 |
PERSON_ADHOC |
FI_CODE_NAME |
CODE_VALUE |
10 |
PERSON_ADHOC |
FI_CODE_VALUE– Conditional |
START_DATE |
14 |
PERSON_ADHOC |
Not supported |
END_DATE |
14 |
PERSON_ADHOC |
Not supported |
LONG_CODE_VALUE |
20 |
PERSON_ADHOC |
FI_CODE_VALUE – Conditional |
EADH Import/PERSON_ADHOC Record - Record Value Maps
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
FI_RECORD_STATUS |
STATIC |
A |
FI_CODE_VALUE |
CONDITION |
LONG_CODE_VALUE if populated, else CODE_VALUE. |
The EASN API in AutoTime 6 inserts employee assignment records into the emp_assgn table to establish a link between employees and their policy groups, schedule groups, facilities, default locations, and current payroll information.
The table below shows how the fields in the EASN API will be mapped to the Shop Floor Time database.
EASN API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
PERSON |
FI_ACTION |
EMP_NUM |
20 |
PERSON_GROUP PERSON_ASSIGNMENT |
FI_PERSON_NUM FI_PERSON_NUM |
ASSGN_TYPE |
1 |
PERSON_ASSIGNMENT |
FI_OVERRIDE_ASSIGNMENT_FLAG. Needs translation. |
POL_GRP |
10 |
PERSON_GROUP |
FI_PERSON_GROUP_NAME FI_PERSON_GROUP_TYPE will be set to static value POLICY_GROUP |
ORG_PTR |
10 |
PERSON_ASSIGNMENT |
FI_ASSIGNMENT_VALUE FI_ASSIGNMENT_TYPE will be set to static value HOME_LOCATION_HR |
SCH_GRP |
10 |
|
Not Supported |
SUB_SCH_NUM |
2 |
PERSON_ASSIGNMENT |
FI_ASSIGNMENT_VALUE. Important: This field will need translation because in AutoTime 6 this value is only 2 characters long. FI_ASSIGNMENT_TYPE will be set to static value SCHEDULE_CYCLE |
DEF_SHIFT |
2 |
PERSON_ASSIGNMENT |
FI_ASSIGNMENT_VALUE. Important: This field will need translation because in AutoTime 6 this value is only 2 characters long. FI_ASSIGNMENT_TYPE will be set to static value SHIFT |
PAY_CLASS |
10 |
PAY_SCALES |
FI_PAY_SCALE |
PAY_RATE |
6 |
PERSON_ASSIGNMENT |
FI_ASSIGNMENT_VALUE FI_ASSIGNMENT_TYPE will be set to static value PERSON_PAYROLL_RATE |
LAST_CHANGE_REASON |
30 |
|
Not Supported |
LAST_INCREASE_DATE |
14 |
|
Not Supported |
START_DATE |
14 |
PAY_SCALES PERSON_ASSIGNMENT |
FI_START_DATE FI_START_DATE |
END_DATE |
14 |
PAY_SCALES PERSON_ASSIGMNET |
FI_END_DATE FI_END_DATE |
PAY_LEVEL |
7 |
PAY_SCALES |
FI_PAY_LEVEL |
TERMINAL_ACCESS_GRP |
10 |
FI_PERSON_GROUP |
|
FILTRATION_GRP |
10 |
|
Not Supported |
LONG_PAY_RATE |
13 |
PERSON_ASSIGNMENT |
FI_ASSIGNMENT_VALUE. See EASN Import - Record Value Maps. FI_ASSIGNMENT_TYPE will be set to static value PERSON_PAYROLL_RATE |
FI_OVERRIDE_ASSIGNMENT_FLAG Field Translation
Shop Floor Time Interface Field Name |
AutoTime 6 API Value |
Shop Floor Time Translated Value |
FI_OVERRIDE_ASSIGNMENT_FLAG |
D (Default) |
0 |
FI_OVERRIDE_ASSIGNMENT_FLAG |
O (Override) |
1 |
FI_OVERRIDE_ASSIGNMENT_FLAG |
T (Temporary) |
Not supported |
EASN Import - Record Value Maps
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
HOME_LOCATION_HR |
FI_ASSIGNMENT_TYPE |
STATIC |
HOME_LOCATION_HR |
PAY_SCALES |
FI_PAYROLL_RATE_AMOUNT |
CONDITIONAL |
LONG_PAY_RATE if populated else PAY_RATE |
POLICY_GROUP |
FI_ASSIGNMENT_TYPE |
STATIC |
POLICY_GROUP |
PERSON_PAYROLL_RATE |
FI_ASSIGNMENT_TYPE |
STATIC |
PERSON_PAYROLL_RATE |
PERSON_PAYROLL_RATE |
FI_ASSIGNMENT_VALUE |
CONDITIONAL |
LONG_PAY_RATE if populated else PAY_RATE |
SCHEDULE_CYCLE |
FI_ASSIGNMENT_TYPE |
STATIC |
SCHEDULE_CYCLE |
SHIFT |
FI_ASSIGNMENT_TYPE |
STATIC |
HOME_LOCATION_HR |
The EMSU API in AutoTime 6 populates the Supervisor Control table (emp_super).
The table below shows how the fields in the EMSU API will be mapped to the Shop Floor Time records for Direct Manager (populating Employee Group, Employee Group Member, and Employee Group Manager).
EMSU API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
PERSON_DIRECT_MANAGER |
FI_ACTION |
EMP_NUM |
20 |
PERSON_DIRECT_MANAGER |
FI_PERSON_NUM |
SUPER_NUM |
20 |
PERSON_DIRECT_MANAGER |
FI_MANAGER_NUM |
START_DATE |
14 |
PERSON_DIRECT_MANAGER |
FI_START_DATE |
END_DATE |
14 |
PERSON_DIRECT_MANAGER |
FI_END_DATE |
EMSU Import - Record Value Map
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
PERSON_DIRECT_MANAGER |
FI_EXCLUSIVE_DIRECT_GROUP |
STATIC |
N |
The ENTY API in AutoTime 6 inserts entity records (work orders, tool orders, operations, and so on) into the database.
The table below shows how the fields in the ENTY API will be mapped to the Shop Floor Time records for interface order and interface operation.
ENTY API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
ORDER OPERATION |
FI_ACTION FI_ACTION |
ENTITY_TYPE |
1 |
ORDER OPERATION |
FI_CHARGE_TYPE FI_CHARGE_TYPE |
ENTITY_NUM |
20 |
ORDER OPERATION ORDER |
ORDER_NUM FI_PARENT_ELEMENT_VALUE ELEMENT_VALUE |
ORDER_SOURCE |
1 |
|
Not supported |
PLANT_ID |
20 |
ORDER |
FI_CHARGE_FILTRATION_GROUP1 |
PARENT_NUM |
20 |
ORDER |
FI_PARENT_ORDER_NUM |
REFRENCE_NUM |
30 |
ORDER |
FI_REFERENCE_ORDER_NUM |
DESCRIPTION |
40 |
ORDER |
FI_DESCRIPTION |
PART_TYPE |
2 |
|
Not supported |
MAKE_BUY |
1 |
|
Not supported |
CHARGE_TYPE |
1 |
|
Not supported |
LAB_CHRG_OR_IND_NUM |
20 |
ORDER |
FI_FLEX_VALUE7 |
SETUP_CHRG_OR_IND_NUM |
20 |
ORDER |
FI_FLEX_VALUE8 |
REWORK_CHRG_OR_IND_NUM |
20 |
ORDER |
FI_FLEX_VALUE9 |
ORDER_QUANTITY |
12 |
ORDER |
FI_ORDER_QUANTITY_PLANNED |
PRIORITY |
7 |
ORDER |
FI_PRIORITY |
START_DATE |
14 |
ORDER |
FI_START_DATE |
END_DATE |
14 |
ORDER |
FI_END_DATE |
ENTITY_HEADER_KEY |
7 |
|
Not supported |
EVENT |
10 |
|
Not supported |
SEQUENCE_NUM |
7 |
|
Not supported |
OPERATION_NUM |
7 |
OPERATION |
FI_OPERATION_NUM |
FLOOR_LOCATION |
10 |
ORDER |
FI_LOCATION_VALUE |
OPERATION_STATUS |
1 |
OPERATION |
FI_OPERATION_STATUS. Will need translation. |
PAY_POINT |
7 |
|
Not supported |
REPORTING_UNITS |
7 |
|
Not supported |
STAND_BASIS |
7 |
OPERATION |
FI_OPERATION_LABOR_STANDARD_BASIS |
CURR_STAND |
7 |
OPERATION |
FI_OPERATION_LABOR_STANDARD_HOURS |
FROZ_STAND |
7 |
|
Not supported |
PAY_CLASS |
10 |
|
Not supported |
PAY_RATE_PER_PIECE |
8 |
|
Not supported |
OPER_STAGE |
2 |
OPERATION |
FI_OPERATION_STAGE |
QUANTITY_IN |
12 |
OPERATION |
FI_QUANTITY_AVAILABLE |
QUANTITY_OUT |
12 |
OPERATION |
FI_QUANTITY_COMPLETED |
SUB_CODE1 |
10 |
ORDER |
FI_FLEX_FIELD_VALUE1 |
SUB_CODE2 |
10 |
ORDER |
FI_FLEX_FIELD_VALUE2 |
SUB_CODE3 |
10 |
ORDER |
FI_FLEX_FIELD_VALUE3 |
SUB_CODE4 |
10 |
ORDER |
FI_FLEX_FIELD_VALUE4 |
WORK_RATES_KEY |
7 |
|
Not Supported |
CURR_SETUP_RATE |
6 |
|
Not Supported |
FROZ_SETUP_RATE |
6 |
|
Not Supported |
CURR_LAB_RATE |
6 |
|
Not Supported |
FROZ_LAB_RATE |
6 |
|
Not Supported |
CURR_REWORK_RATE |
6 |
|
Not Supported |
FROZ_REWORK_RATE |
6 |
|
Not Supported |
FIX_BUR_PERC |
3 |
|
Not Supported |
VARIABLE_BUR_PERC |
3 |
|
Not Supported |
MACHINE_NUM |
20 |
|
|
TASK_NUM |
20 |
|
|
SETUP_STAND_BASIS |
7 |
|
Not Supported |
SETUP_CURR_STAND |
7 |
OPERATION |
FI_OPERATION_SETUP_STANDARD_HOURS |
SETUP_FROZ_STAND |
7 |
|
Not supported |
FILLER1 |
16 |
|
Not supported |
OPERATION_COMP |
1 |
|
Not supported |
BACKFLUSH |
1 |
|
Not supported |
SOURCE_COMPANY |
20 |
|
Not supported |
CERTIF_REQD |
1 |
|
Not supported |
IS_HELD |
1 |
|
|
OPERATION_NUM_LONG |
20 |
OPERATION |
Conditional Logic. See ENTY Import - Record Value Maps. |
ENTITY_NUM_LONG |
40 |
OPERATION |
Conditional Logic. See ENTY Import - Record Value Maps. |
DESCRIPTION |
60 |
|
FI_DESCRIPTION |
PLAN_QUANTITY |
12 |
|
|
OVERREPORTING_LEVEL |
1 |
|
Shop Floor Time only supports header level |
OVERREPORTING_TYPE |
1 |
ORDER |
FI_OVERREPORTING_TYPE |
OVEREPORTING_AMOUNT |
12 |
ORDER |
FI_OVERREPORTING_AMOUNT |
OPERATION_START_DATE |
14 |
|
|
REWORK_OPERATION |
1 |
|
No need to identify in Shop Floor Time. |
QTY_SCRAP |
12 |
OPERATION |
FI_QUANTITY_SCRAPPED |
BLOCK_OP_FLAG |
1 |
|
Not supported |
ENTY Import - Record Value Maps
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
OPERATION |
FI_CHARGE_TYPE |
STATIC |
OPERATION |
OPERATION |
FI_ELEMENT_NAME |
STATIC |
OPERATION |
OPERATION |
FI_ELEMENT_VALUE |
CONDITIONAL |
OPERATION_NUM_LONG if populated else OPERATION_NUM |
OPERATION |
FI_PARENT_ELEMENT_NAME |
STATIC |
ORDER |
OPERATION |
FI_PARENT_ELEMENT_VALUE |
CONDITIONAL |
ENTITY_NUM_LONG if populated else ENTITY_NUM |
OPERATION |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
ORDER |
FI_CHARGE_TYPE |
STATIC |
ORDER |
ORDER |
FI_ELEMENT_NAME |
STATIC |
ORDER |
ORDER |
FI_ELEMENT_VALUE |
CONDITIONAL |
ENTITY_NUM_LONG if populated else ENTITY_NUM |
ORDER |
FI_EXTERNAL_ORDER_STATUS |
STATIC |
OPEN (Can be mapped if conditional logic needed) |
ORDER |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
The EPRO API in AutoTime 6 inserts employee master files used by Shop Floor Time and to validate the employee within the system.
The table below shows how the fields in the EPRO API will be mapped in the Shop Floor Time database.
EPRO API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
PERSON |
FI_ACTION |
EMP_NUM |
20 |
PERSON |
FI_PERSON_NUM |
EMP_CAT |
1 |
PERSON |
FI_CLASSIFICATION_TYPE |
EMP_STATUS |
1 |
PERSON |
FI_EMPLOYMENT_STATUS |
EMP_TYPE |
1 |
PERSON |
FI_PERSON_TYPE |
EMP_TYPE1 |
1 |
|
|
ENTRY_TYPE |
1 |
PERSON |
FI_ATTENDANCE_ENTRY_TYPE |
FIRST_NAME |
15 |
PERSON |
FI_FIRST_NAME |
LAST_NAME |
20 |
PERSON |
FI_LAST_NAME |
MIDDLE_INITIAL |
1 |
PERSON |
FI_MIDDLE_NAME |
GOVERNMENT_ID_NUM |
11 |
PERSON |
FI_RCD_NUM |
HIRE_DATE |
14 |
PERSON |
FI_HIRE_DATE |
SENIORITY_DATE |
14 |
PERSON |
FI_SERVICE_DATE |
TERMINATION_DATE |
14 |
PERSON |
FI_END_DATE |
DIRECT_INDIRECT |
1 |
PERSON |
FI_DIRECT_IND |
IS_A_GRP_LEADER |
1 |
|
Not supported |
IS_A_UNION_OFFICER |
1 |
|
Not supported |
UNION_RANK |
4 |
|
Not Supported |
ORG_PTR |
10 |
|
Not Supported. Will use Assignment Value See EASN. |
DEF_SHIFT |
2 |
|
Not Supported. Will use Assignment Value See EASN. |
START_DATE |
14 |
PERSON |
FI_START_DATE |
END_DATE |
14 |
PERSON |
FI_END_DATE. Because TERMINATION_DATE (see above) is also mapped to FI_END_DATE, may need to use conditional logic. |
EMPLOYER |
20 |
|
Not supported |
SCR_PROFILE_ID |
20 |
|
|
LDAP_LOGIN_ID |
20 |
PERSON |
FI_LOGIN_NAME |
RESERVED |
1 |
|
Not supported |
EMAIL_ADDRESS |
100 |
PERSON |
FI_EMAIL_ADDRESS1 |
DOB |
14 |
PERSON |
FI_BIRTH_DATE |
FIRST_NAME_LONG |
40 |
PERSON |
FI_FIRST_NAME. Conditional logic |
LAST_NAME_LONG |
40 |
PERSON |
FI_LAST_NAME Conditional logic |
OPT_OUT |
1 |
|
Not supported |
EUROPEAN_OT_WEEK |
2 |
|
Not supported |
LDAP_LOGIN_ID |
60 |
PERSON |
FI_LOGIN_NAME. |
EPRO Import – Field Translations
EPRO API Field |
AutoTime 6 Source Value |
Shop Floor Time Destination Value |
EMP_CAT |
H |
Hourly |
EMP_CAT |
N |
Nonexempt |
EMP_CAT |
S |
Salaried |
EMP_STATUS |
A |
Active |
EMP_STATUS |
I |
Inactive |
EMP_STATUS |
T |
Terminated |
EMP_TYPE |
C |
CONTRACTOR |
EMP_TYPE |
F |
EMPLOYE |
EMP_TYPE |
P |
INTERIM |
ENTRY_TYPE |
A |
EXCEPTION |
ENTRY_TYPE |
B |
ELAPSED |
ENTRY_TYPE |
P |
PUNCHED |
The ORGH API in AutoTime 6 inserts the records that define the various organizational groups and group hierarchy.
The table below shows how the fields in the ORGH API will be mapped in the Shop Floor Time database.
ORGH API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
HIERARCHY |
FI_ACTION |
DUAL_PURPOSE_INDICATOR |
1 |
|
Not supported |
PLANT_ID |
20 |
|
Not supported |
ORG_GRP |
10 |
HIERARCHY |
FI_HIERARCHY_NAME |
ORG_PTR |
10 |
HIERARCHY |
FI_ELEMENT_VALUE |
LEVEL_NUM |
1 |
HIERARCHY |
FI_LEVEL_NUM |
DESCRIPTION |
20 |
HIERARCHY |
FI_DESCRIPTION – See ORGH Import - Record Value Maps. |
ORG_PTR_LOCAL |
10 |
|
Not supported |
PARENT_ORG_PTR |
10 |
HIERARCHY |
FI_PARENT_ELEMENT_VALUE1 |
ORG_PTR_FUNC |
10 |
|
Not supported |
WORK_RATES_KEY |
7 |
|
Not supported |
START_DATE |
14 |
|
Not supported |
END_DATE |
14 |
|
Not supported |
CURR_LAB_RATE |
6 |
HIERARCHY |
FI_HEIRARCHY_FLEX_FIELD_VALUE1 |
CURR_SETUP_RATE |
6 |
HIERARCHY |
FI_HEIRARCHY_FLEX_FIELD_VALUE2 |
CURR_REWORK_RATE |
6 |
HIERARCHY |
FI_HEIRARCHY_FLEX_FIELD_VALUE3 |
FROZ_LAB_RATE |
6 |
HIERARCHY |
FI_HEIRARCHY_FLEX_FIELD_VALUE4 |
FROZ_SETUP_RATE |
6 |
HIERARCHY |
FI_HEIRARCHY_FLEX_FIELD_VALUE5 |
FROZ_REWORK_RATE |
6 |
HIERARCHY |
FI_HEIRARCHY_FLEX_FIELD_VALUE6 |
VARIABLE_BUR_PERC |
3 |
|
Not supported |
FIX_BUR_PERC |
3 |
|
Not supported |
LONG_DESCRIPTION |
40 |
HIERARCHY |
FI_DESCRIPTION – See ORGH Import - Record Value Maps. |
ORGH Import - Record Value Maps
Record Name |
Shop Floor Time
Interface |
Record Value Map – Field Value Type |
Field Value |
HIERARCHY |
FI_HIERARCHY_NAME |
STATIC |
Organization Hierarchy |
HIERARCHY |
FI_ELEMENT_NAME |
STATIC |
COSTCENTER |
HIERARCHY |
FI_HIERARCHY_FLEX_FIELD_NAME1 |
STATIC |
CURRENT_LABOR_RATE |
HIERARCHY |
FI_HIERARCHY_FLEX_FIELD_NAME2 |
STATIC |
CURRENT_SETUP_RATE |
HIERARCHY |
FI_HIERARCHY_FLEX_FIELD_NAME3 |
STATIC |
CURRENT_REWORK_RATE |
HIERARCHY |
FI_HIERARCHY_FLEX_FIELD_NAME4 |
STATIC |
FROZEN_LABOR_RATE |
HIERARCHY |
FI_HIERARCHY_FLEX_FIELD_NAME5 |
STATIC |
FROZEN_SETUP_RATE |
HIERARCHY |
FI_HIERARCHY_FLEX_FIELD_NAME6 |
STATIC |
FROZEN_REWORK_RATE |
HIERARCHY |
FI_DESCRIPTION |
CONDITIONAL |
LONG_DESCRIPTION if populated else DESCRIPTION |
The PACT API in AutoTime 6 inserts records in the proj_activity table.
The table below shows how the fields in the PACT API will be mapped to the destination records for project/task charge elements in the Shop Floor Time database.
PACT API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Record Name |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
|
Not supported |
SEQUENCE |
7 |
|
|
Not supported |
CREATED_ON |
12 |
|
|
Not supported |
ACTION |
1 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_ACTION |
PLANT_ID |
20 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_CHARGE_FILTRATION_GROUP1 |
ACTIVITY |
10 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_ELEMENT_VALUE |
START_DATE |
14 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_START_DATE |
END_DATE |
14 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_END_DATE |
DESCRIPTION |
40 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_DESCRIPTION |
CHRG_ACCT |
20 |
|
|
Not Supported |
PROJ_NUM |
40 |
CHARGE_ELEMENT |
PROJECT_TASK |
FI_PARENT _ELEMENT_VALUE |
PACT Import - Record Value Maps
Record Name |
Shop Floor Time
Interface |
Record Value Map – Field Value Type |
Field Value |
PROJECT_TASK |
FI_ELEMENT_NAME |
STATIC |
TASK |
PROJECT_TASK |
FI_PARENT_ELEMENT_NAME |
STATIC |
PROJECT |
PROJECT_TASK |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
The PJAC API in AutoTime 6 links a project to a valid account number against an established facility.
The table below shows how the fields in the PJAC API will be mapped to the destination records for project/account charge elements in the Shop Floor Time database.
PJAC API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Record Name |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
|
Not supported |
SEQUENCE |
7 |
|
|
Not supported |
CREATED_ON |
12 |
|
|
Not supported |
ACTION |
1 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
FI_ACTION |
CHRG_ACCT |
20 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
FI_ELEMENT_VALUE - Conditional |
PLANT_ID |
20 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
FI_CHARGE_FILTRATION_GROUP1 |
PROJ_NUM |
40 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
FI_PARENT _ELEMENT_VALUE |
START_DATE |
14 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
FI_START_DATE |
END_DATE |
14 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
FI_END_DATE |
BUDGET_TYPE |
1 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
Not supported |
PROJ_CHRG |
1 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
Not supported |
DESCRIPTION |
40 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
Conditional |
LONG_DESC |
255 |
CHARGE_ELEMENT |
PROJECT_ACCOUNT |
Conditional |
PJAC Import - Record Value Maps
Record Name |
Shop Floor Time
Interface |
Record Value Map – Field Value Type |
Field Value |
PROJECT_ACCOUNT |
FI_DESCRIPTION |
CONDITIONAL |
LONG_DESC if populated else DESCRIPTION |
PROJECT_ACCOUNT |
FI_ELEMENT_NAME |
STATIC |
ACCOUNT |
PROJECT_ACCOUNT |
FI_PARENT_ELEMENT_NAME |
STATIC |
PROJECT |
The PJCT API in AutoTime 6 creates a project record under a valid facility.
The table below shows how the fields in the PJCT API will be mapped to the Shop Floor Time database.
PJCT API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Record Name |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
|
Not supported |
SEQUENCE |
7 |
|
|
Not supported |
CREATED_ON |
12 |
|
|
Not supported |
ACTION |
1 |
CHARGE_ELEMENT |
PROJECT |
FI_ACTION |
CHRG_ACCT |
20 |
CHARGE_ELEMENT |
ACCOUNT |
|
PLANT_ID |
20 |
CHARGE_ELEMENT |
PROJECT |
FI_CHARGE_FILTRATION_GROUP1 |
PROJ_NUM |
40 |
CHARGE_ELEMENT |
PROJECT ACCOUNT |
FI_ELEMENT_VALUE FI_PARENT_ELEMENT_VALUE |
DESCRIPTION |
40 |
CHARGE_ELEMENT |
PROJECT |
FI_DESCRIPTION |
START_DATE |
14 |
CHARGE_ELEMENT |
PROJECT ACCOUNT |
FI_START_DATE |
END_DATE |
14 |
CHARGE_ELEMENT |
PROJECT ACCOUNT |
FI_END_DATE |
SOURCE_COMPANY |
20 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE1 |
PROJ_SET_NAME |
20 |
CHARGE_ELEMENT |
PROJECT |
FI_CHARGE_FILTRATION_GROUP2 |
BUDGET_HRS |
12 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE2 |
BUDGET_COST |
12 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE3 |
TASK_START_DATE |
8 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE4 |
TASK_END_DATE |
8 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE5 |
PERCENT_COMP |
3 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE6 |
REMAINING_HRS |
12 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE7 |
PJCT Import - Record Value Maps
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
PROJECT |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
PROJECT |
FI_ELEMENT_NAME |
STATIC |
PROJECT |
PROJECT |
FI_CHARGE_TYPE |
STATIC |
PROJECT |
PROJECT |
FI_FLEX_FIELD_NAME1 |
STATIC |
SOURCE_COMPANY |
PROJECT |
FI_FLEX_FIELD_NAME2 |
STATIC |
BUDGET_HOURS |
PROJECT |
FI_FLEX_FIELD_NAME3 |
STATIC |
BUDGET_COST |
PROJECT |
FI_FLEX_FIELD_NAME4 |
STATIC |
TASK_START_DATE |
PROJECT |
FI_FLEX_FIELD_NAME5 |
STATIC |
TASK_END_DATE |
PROJECT |
FI_FLEX_FIELD_NAME6 |
STATIC |
PERCENT_COMPLETE |
PROJECT |
FI_FLEX_FIELD_NAME7 |
STATIC |
REMAINING_HOURS |
ACCOUNT |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
ACCOUNT |
FI_ELEMENT_NAME |
STATIC |
ACCOUNT |
ACCOUNT |
FI_PARENT_ELEMENT_NAME |
STATIC |
PROJECT |
The PRJT API in AutoTime 6 inserts a project record and links the project to a valid account number against an established facility.
The table below shows how the fields in the PRJT API will be mapped to project and project/account charge elements in the Shop Floor Time database.
PRJT API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Record Name |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
|
Not supported |
SEQUENCE |
7 |
|
|
Not supported |
CREATED_ON |
12 |
|
|
Not supported |
ACTION |
1 |
CHARGE_ELEMENT |
PROJECT |
FI_ACTION |
CHRG_ACCT |
20 |
|
ACCOUNT |
FI_ELEMENT_VALUE |
PLANT_ID |
20 |
CHARGE_ELEMENT |
PROJECT |
FI_CHARGE_FILTRATION_GROUP1 |
PROJ_NUM |
20 |
CHARGE_ELEMENT |
PROJECT |
Conditional. See PRJT Import - Record Value Maps. |
DESCRIPTION |
40 |
CHARGE_ELEMENT |
PROJECT |
FI_DESCRIPTION |
START_DATE |
14 |
CHARGE_ELEMENT |
PROJECT |
FI_START_DATE |
END_DATE |
14 |
CHARGE_ELEMENT |
PROJECT |
FI_END_DATE |
BUDGET_TYPE |
1 |
CHARGE_ELEMENT |
PROJECT |
Not supported |
SOURCE_COMPANY |
20 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE1 |
PROJ_CHRG |
1 |
CHARGE_ELEMENT |
PROJECT |
Not supported |
DESCRIPTION |
40 |
CHARGE_ELEMENT |
ACCOUNT |
FI_DESCRIPTION |
LONG_DESC |
255 |
CHARGE_ELEMENT |
PROJECT |
FI_DESCRIPTION |
PROJ_NUM_LONG |
40 |
CHARGE_ELEMENT |
PROJECT |
Conditional. See PRJT Import - Record Value Maps. |
PROJ_SET_NAME |
20 |
CHARGE_ELEMENT |
PROJECT |
FI_CHARGE_FILTRATION_GROUP2 |
START_DATE |
14 |
CHARGE_ELEMENT |
PROJECT |
FI_START_DATE |
END_DATE |
14 |
CHARGE_ELEMENT |
PROJECT |
FI_END_DATE |
BUDGET_HRS |
12 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE2 |
BUDGET_COST |
12 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE3 |
TASK_START_DATE |
8 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE4 |
TASK_END_DATE |
8 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE5 |
PERCENT_COMP |
3 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE6 |
REMAINING_HRS |
12 |
CHARGE_ELEMENT |
PROJECT |
FI_FLEX_FIELD_VALUE7 |
PRJT Import - Record Value Maps
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
PROJECT |
FI_CHARGE_TYPE |
STATIC |
PROJECT |
PROJECT |
FI_DESCRIPTION |
CONDITIONAL |
LONG_DESC if populated else DESCRIPTION |
PROJECT |
FI_ELEMENT_NAME |
STATIC |
PROJECT |
PROJECT |
FI_ELEMENT_VALUE |
CONDITIONAL |
PROJECT_NUM_LONG if populated else PROJ_NUM |
PROJECT |
FI_FLEX_FIELD_NAME1 |
STATIC |
SOURCE_COMPANY |
PROJECT |
FI_FLEX_FIELD_NAME2 |
STATIC |
BUDGET_HOURS |
PROJECT |
FI_FLEX_FIELD_NAME3 |
STATIC |
BUDGET_COST |
PROJECT |
FI_FLEX_FIELD_NAME4 |
STATIC |
TASK_START_DATE |
PROJECT |
FI_FLEX_FIELD_NAME5 |
STATIC |
TASK_END_DATE |
PROJECT |
FI_FLEX_FIELD_NAME6 |
STATIC |
PERCENT_COMPLETE |
PROJECT |
FI_FLEX_FIELD_NAME7 |
STATIC |
REMAINING_HOURS |
PROJECT |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
ACCOUNT |
FI_ELEMENT_NAME |
STATIC |
ACCOUNT |
ACCOUNT |
FI_PARENT_ELEMENT_NAME |
STATIC |
PROJECT |
ACCOUNT |
FI_PARENT_ELEMENT_VALUE |
CONDITIONAL |
PROJECT_NUM_LONG if populated else PROJ_NUM |
ACCOUNT |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
The SASS API in AutoTime 6 populates the supervisor assignment table, used to assign supervisors to Organization Groups, Reporting Groups, and Schedules.
The table below shows how the fields in the SASS API will be mapped to the destination records for hierarchy in the Shop Floor Time database.
SASS API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
HIERARCHY |
FI_ACTION |
PLANT_ID |
20 |
|
Not supported |
ORG_GRP |
10 |
HIERARCHY |
FI_HIERARCHY_NAME |
SUPER_NUM |
20 |
HIERARCHY |
FI_PERSON_NUM |
SUPER_TIER_LEVEL |
1 |
HIERARCHY |
FI_LEVEL_NUM |
REPORTING_GRP |
10 |
HIERARCHY |
FI_ELEMENT_NAME |
SUB_SCH_NUM |
2 |
|
Not supported |
SASS Import - Record Value Maps
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
HIERARCHY |
FI_HIERARCHY_TYPE |
STATIC |
Organization Hierarchy |
HIERARCHY |
FI_IS_MANAGER |
STATIC |
Y |
The TASK API in AutoTime 6 loads data to the tasks table.
The table below shows how the fields in the TASK API will be mapped to the destination records for interface order and interface operation in the Shop Floor Time database.
TASK API Field |
Length |
Shop Floor Time Interface Context |
Shop Floor Time Interface Field |
IDENTIFIER |
4 |
|
Not supported |
SEQUENCE |
7 |
|
Not supported |
CREATED_ON |
12 |
|
Not supported |
ACTION |
1 |
PROJECT_TASK ACTIVITY |
FI_ACTION |
TASK_NUM |
20 |
PROJECT_TASK ACTIVITY |
FI_ELEMENT_VALUE FI_ACTIVITY_NUM Conditional. See TASK Import - Record Value Maps. |
PLANT_ID |
20 |
PROJECT_TASK ACTIVITY |
FI_CHARGE_FILTRATION_GROUP1 |
TASK_TYPE |
1 |
|
|
DESCRIPTION |
40 |
PROJECT_TASK |
FI_DESCRIPTION |
PROJ_NUM |
20 |
PROJECT_TASK |
FI_PARENT_ELEMENT_VALUE Conditional. See TASK Import - Record Value Maps. |
START_DATE |
14 |
PROJECT_TASK |
FI_START_DATE |
END_DATE |
14 |
PROJECT_TASK |
FI_END_DATE |
PROJ_NUM_LONG |
40 |
PROJECT_TASK |
FI_PARENT_ELEMENT_VALUE Conditional. See TASK Import - Record Value Maps. |
ENTITY_NUM |
40 |
ACTIVITY |
FI_PARENT_ELEMENT_VALUE1 |
OPERATION_NUM |
20 |
ACTIVITY |
FI_PARENT_ELEMENT_VALUE |
TASK Import - Record Value Maps
Record Name |
Shop Floor Time Interface Field Name |
Record Value Map – Field Value Type |
Field Value |
PROJECT_TASK |
FI_CHARGE_TYPE |
STATIC |
PROJECT |
PROJECT_TASK |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
PROJECT_TASK |
FI_PARENT_ELEMENT_NAME |
STATIC |
PROJECT |
ACTIVITY |
FI_CHARGE_TYPE |
STATIC |
ORDER |
ACTIVITY |
FI_SENDER_NAME |
STATIC |
AUTOTIME6 |
ACTIVITY |
FI_PARENT_ELEMENT_NAME |
STATIC |
OPERATION |
ACTIVITY |
FI_PARENT_ELEMENT_NAME1 |
STATIC |
ORDER |
ACTIVITY |
FI_LEVEL_NUM |
STATIC |
3 |
ACTIVITY |
FI_RECORD_STATUS |
STATIC |
A |
ACTIVITY |
FI_ELEMENT_VALUE |
CONDITIONAL |
TASK_NUM if TASK_TYPE not equal to 5 else NULL |
ACTIVITY |
FI_ACTIVITY_NUM |
CONDITIONAL |
TASK_NUM if TASK_TYPE not equal to 5 else NULL |
PROJECT_TASK |
FI_PARENT_ELEMENT_VALUE |
CONDITIONAL |
PROJECT_NUM_LONG if populated else PROJ_NUM |
PROJECT_TASK |
FI_ELEMENT_VALUE |
CONDITIONAL |
TASK_NUM if TASK_TYPE equal to 5 else NULL |
TASK Import – Skip Record Setting
Destination Record Name |
Skip Record Setting |
ACTIVITY |
1 |
PROJECT_TASK |
1 |