Use the Employee Interface to load PENTA Employee information using data from external applications. Information you load using this interface adds to or updates the data already stored in PENTA.

Data files you load must have Request Types assigned to the E Interface Type.

If the Data Check Verified field in the Header Record is blank, PENTA loads the file. If the Data Check Verifier field in the Header Record contains a value, the file undergoes several high-level tests for integrity. Only if the following is true will PENTA attempt to process the Detail Records:

The Batch Number matches the file name.

The record count of the header equals the number of Detail Records.

The data check verifier of the header is:

The sum of the ASCII value of each character in each Detail Record’s Employee ID.

Truncated (from the left) to the eight least significant digits.

Example: The calculated number is 1234567890, truncated to 34567890. The ASCII value is used because companies may use character or numeric employee Ids.

If PENTA rejects a Detail Record for an exception within a Record Type, then it rejects all records of that Record Type.

PENTA supports USA and CAN employee information.

You can view the Employee data that loaded through the interface program in the Employee Payroll Information and Employee HR Information windows.

A Note About Detail Records

The Detail Record(s) identify the data that is to be added, deleted, or modified. There are types of Detail Records, and each type is associated with a specific PENTA table or set of tables.

The Record Type identifies the scope of the data involved, which helps you find and correct errors.

Add an Employee

If you are adding an employee:

A Detail record with an activity code of A must exist for each of the following Record Types: EMP, RATE, STAT, and TAX.

Data must exist for the fields listed as Key or Req under each of the above Record Types.

Update Existing Employees

If you are updating an existing employee:

You can enter any number of Record Types (assuming a PENTA user set up the employee earlier in the data file, a previous data file, or directly into PENTA).

Data must exist for the following:

Fields listed as Key under each record. PENTA does not process the record if these fields contain no values.

Fields with previously entered information that you would like to retain. If you do not supply data for a (non-Key) field, PENTA updates the field to null (empty).

Available Records

1 Badge (BADGE) Detail Record
2 Canadian Payroll (CANPR) Detail Record
3 Compensations (COMP) Detail Record
4 Deductions (DED) Detail Record
5 Employee Canadian Payroll Provincial Parameters (PROV) Detail Record
6 Employee Canadian Payroll Tax Account Number (BNTAX) Detail Record
7 Employee Canadian Payroll Tax Exemptions (XEMPT) Detail Record
8 Employee Certification (CERT) Detail Record
9 Employee (EMP) Detail Record
10 Employee Status (STAT) Detail Record
11 Estimated Hourly Benefit Value (BNVAL) Detail Record
12 Employee Header Record
13 Labor Productivity (PROD) Detail Record
14 Minimum Hourly Rate (MINRT) Detail Record
15 Paid Time Off (PTO) Detail Record
16 Pay Rate (RATE) Detail Record
17 Reimbursement (REIMB) Detail Record
18 Tax (TAX) Detail Record
19 User Defined Field (UDF) Detail Record

Badge (BADGE) Detail Record

After interfacing employee badge data, you can review it in the Employee Payroll Information window’s Badge Information pop-up window or the Employee HR Information window’s Badges tab.

#	Field	Entry	Format	Description

#	Field	Entry	Format	Description
1	Employee ID	Key	X	Id of the employee whose gate hours you are tracking. Note: This may default from the Badge ID.
2	Record Type	Key	C! 5	This value must be BADGE.
3	Activity Code	Key	C! 1	Required for all activity. Possible values are: A (Add) – If the Badge ID already exists, PENTA records an error. C (Change) – Update an existing record. If the field cannot be updated, PENTA records an error. D (Delete) – Delete the record. If the record does not exist or was not created by the interface, PENTA records an error. U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied field in the existing record.
4	Badge ID	Opt	C! 30	The badge ID associated with the Employee. You cannot assign the same Badge ID to multiple employees.
5	Assigned Date	Req	D	The date the Badge was assigned to the Employee.

Canadian Payroll (CANPR) Detail Record

The following fields are included in the “CANPR” Detail record. Use this Record Type for employees with PR_COUNTRY_CD = CAN only.

#	Field	Entry	Format	Description

#	Field	Entry	Format	Description
1	Employee Id	Key	X	Employee Id
2	Record Type	Key	C! 5	The value should be CANPR.
3	Activity Code	Key	C! 1	Required for all activity. Possible values are: A (Add) – Adds the record to the database. PENTA provides an error message if the record already exists in the database. C (Change) – Update an existing record. If the field is not updateable, PENTA issues an error. U (Update) – Add if the record does not exist and update if the record already exists, replacing any supplied field in the existing record.
4	Effective Date	Req	D	Effective Date.
5	Full or Part Time	Req	C! 1	Full or Part Time Code. Enter F for full time or P for part time. This field defaults as F.
6	Tax Calculation Method	Req	C! 1	Tax Calculation Method Code. Must be either: A (Cumulative Averaging) C (Commission Only) G (General Tax Formula) If you are adding the employee and you do not enter a value, PENTA defaults this field to G.
7	Employment Province	Req	C! 4	Employment Province Code. Must be valid, active Canadian Province Code.
8	Work Province	Req	C! 4	Work Province Code. Must be valid, active Canadian Province Code. If you are adding the employee and you do not enter a value, PENTA defaults this field to the Employment Province Code value.
9	Statutory Vacation Pay Code	Req	C! 1	This value must be Y or N. If you do not enter this value while adding an Employee, PENTA defaults this field to N.
10	Statutory Vacation Pay Rate	Opt	F 7.4	This is only enterable if Statutory Vacation Pay Code is Y. Must be between 0 and 100.
11	Labor-Sponsored Funds Credit – Federal	Opt	F 15.2	Federal Labor-Sponsored Funds Credit
12	Authorized Reductions in Tax Deductions (Form T1213)	Opt	F 15.2	Authorized Reductions in Tax Deductions from an employee’s completed Form T1213 if applicable.
13	Authorized Tax Credits - Medical/Charitable/Other	Opt	F 15.2	Authorized Tax Credits for Medical, Charitable, or Other reasons.
14	Est Annual Pension Deduction - Commission Only Employees	Opt	F 15.2	Est Annual Pension Deduction. Use if applicable when Tax Calculation Method is C (Commission Only).