The table below identifies the available Context Names for importing data and the mandatory fields that must be included in the import.
An import’s Context Name is defined on the Destination Records tab of the Import Definition form.
The mandatory and non-mandatory fields that will be imported are defined in the Source Fields and Record Value Map tabs of the Import Definition form.
When you map your source data to a field name (via the Source Fields and Record Value Map tabs), the IMPORT_FILES service imports the data and populates the applicable table columns in Shop Floor Time. You can map your source data to multiple contexts/field names.
For a complete list of all the fields that can be included in each import context, see doc-INTERFACE-events-AUTOTIME.
Context Name |
Mandatory Field Names |
Leave Type Code Balance Year Person Num/Employee |
|
Action |
Post Event Name |
Activity |
Activity Num Activity Type Charge Type Element Name Element Value Operation Num Order Num |
Attendance Points |
Person Num Points Post Date |
Charge Element |
Charge Type Element Name Element Value Sender Name When using a Charge Element import to delete charge elements (making them Inactive), you must delete parent and child elements (e.g., an order and its operations) independently. Deleting the parent element will not automatically delete its child elements. The import file must specify that each element (e.g., an order number or an operation number) is to be deleted. For example, to delete a work order and all its operations, the import file needs to set Action to "D" for the order number and for each individual operation number.
|
Charge Filter |
Charge Filter Name Charge Type |
Delegation |
Delegated Manager Num Hierarchy Name Hierarchy Type Manager Num |
Department |
Charge Type Element Name Element Value |
Dictionary Name Label Name Label Type Module Name Long Label Short Label |
|
Hierarchy |
Element Name Hierarchy Name Hierarchy Type Level Num |
Message |
Receiver Num Sender Num |
Operation |
Charge Type Element Name Element Value Operation Num See Also: |
Order |
Charge Type Element Name Element Value Order Num Order Status |
Pay Scales |
Pay Scale Name |
Person/Employee |
Person Number First Name (required for Add but not for Update) |
Person Adhoc |
Code Name Code Value Person Num Record Status This import context will validate the Person Num and update the person_adhoc table accordingly. These records can be viewed on the Ad Hoc tab of the Employee form. |
Employee Assignment |
Employee Num |
Action Duration (not required if Action is Delete) Hours Type Pay Period Date Person Num
|
|
Employee Direct Manager |
Mandatory Fields: Manager Num Employee Num The Employee Direct Manager context is designed specifically for DIRECT_MANAGER Employee Groups. This context is used to:
If an Employee Direct Manager import record has EXCLUSIVE_DIRECT_GROUP set to Y, then the person's membership in any other DIRECT_MANANGER groups will be end dated so the person will only have one Direct Manager at a given time.
|
Employee Group |
Mandatory Fields: Employee Group Employee Group Type This context is used to add, update, and delete Employee Groups, Employee Group Members, and Employee Group Managers.
|
Person Pay Scale |
Employee Number |
Person Pin |
Employee Num Pin You cannot include the following characters in the PIN: # % \ ' ? = + |
Employee/Person Schedule |
End Timestamp Person Num Post Date Start Timestamp |
Employee/Person Schedule Event |
Event End Timestamp Event Name Event Start Timestamp Employee Num Post Date |
Employee/Person Setting |
Employee Num Setting Type Setting Value |
Processemployeeworktime |
The only mandatory Source Field for this import context is Post Event Name. The other Source Fields that are available for the Processemployeeworktime Context are the same fields that are available for the Action Context. The Processemployeeworktime Context is used for importing data from Solumina.
|
Pto Request |
End Date Event Name Employee Num Start Date |
Transaction Error |
Error Code Error Description Transaction Id Transaction Process Name Transaction Process Status |
Employee Num Rate Type Vendor Name Vendor Num Vendor Site Code |