AutoTime 6 API Support

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:

Using the AutoTime 6 APIs

Supported APIs and Fields

 

Using the AutoTime 6 APIs

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.

 

Set Up Your Shop Floor Time Database with Configuration Data

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

 

Modify the AutoTime 6 API transactions in the Distribution Model form

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.

 

Set Up the Import Definitions for the AutoTime 6 APIs

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.

 

Place the AutoTime 6 API Data in the interface_in_queue Table

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.

 

Run the IN_QUEUE_TEXT Service

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.

 

Supported APIs and Fields

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.

 

BADG (Badge) API

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

 

BANK (Bank History) API

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

 

EADH (Employee Ad Hoc) API

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.

 

EASN (Employee Assignment) API

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

 

EMSU (Employee/Supervisor Control) API

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

 

ENTY (Entity) API

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

 

EPRO (Employee Profile) API

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
Requires translation.

EMP_STATUS

1

PERSON

FI_EMPLOYMENT_STATUS
Requires translation.

EMP_TYPE

1

PERSON

FI_PERSON_TYPE
Requires translation.

EMP_TYPE1

1

 

 

ENTRY_TYPE

1

PERSON

FI_ATTENDANCE_ENTRY_TYPE
Requires translation.

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

 

ORGH (Organization Pointer Hierarchy) API

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
Set F_HIERARCHY_TYPE to static value of ORGANIZATION HIERARCHY.

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
Set FI_HEIRARCHY_FLEX_FIELD_NAME1to static value CURRENT LABOR RATE.

CURR_SETUP_RATE

6

HIERARCHY

FI_HEIRARCHY_FLEX_FIELD_VALUE2
Set FI_HEIRARCHY_FLEX_FIELD_NAME2 to static value CURENT SETUP RATE.

CURR_REWORK_RATE

6

HIERARCHY

FI_HEIRARCHY_FLEX_FIELD_VALUE3
Set FI_HEIRARCHY_FLEX_FIELD_NAME3 to static value CURRENT REWORK RATE.

FROZ_LAB_RATE

6

HIERARCHY

FI_HEIRARCHY_FLEX_FIELD_VALUE4
Set FI_HEIRARCHY_FLEX_FIELD_NAME4 to static value FROZEN LABOR RATE.

FROZ_SETUP_RATE

6

HIERARCHY

FI_HEIRARCHY_FLEX_FIELD_VALUE5
Set FI_HEIRARCHY_FLEX_FIELD_NAME5 to FROZEN SETUP RATE.

FROZ_REWORK_RATE

6

HIERARCHY

FI_HEIRARCHY_FLEX_FIELD_VALUE6
Set FI_HEIRARCHY_FLEX_FIELD_NAME6 to FROZEN REWORK RATE.

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
Field Name

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

 

PACT (Project Activity) API

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
Field Name

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

 

PJAC (Account to Project) API

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
Field Name

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

 

PJCT (Project) API

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
FI_START_DATE

END_DATE

14

CHARGE_ELEMENT

PROJECT

ACCOUNT

FI_END_DATE
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

 

PRJT (Project) API

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
ACCOUNT

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

 

SASS (Supervisor Assignment) API

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

 

TASK API

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