INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_REF_CD

Req

C 15

ID referring to Customer-specific work order information.

CUS_REF_VALUE

Opt

C 30

The value for the associated Customer Reference Code.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number that uniquely identifies this record within an interface request.

EMP_ID

Req

X

Id of the Employee.

D_PRD_END_DATE

Opt

D

If System Option 161 is Y, the date must be +/- 14 days from the system date.

If Reimbursement Number, Amount, or Applied Account contains a value, Week Ending Date or Reimbursement Date must contain a value.

TC_DAY1_HRS

Opt

F 10.3

Hours – Day 1 of week

TC_DAY2_HRS

Opt

F 10.3

Hours – Day 2 of week

TC_DAY3_HRS

Opt

F 10.3

Hours – Day 3 of week

TC_DAY4_HRS

Opt

F 10.3

Hours – Day 4 of week

TC_DAY5_HRS

Opt

F 10.3

Hours – Day 5 of week

TC_DAY6_HRS

Opt

F 10.3

Hours – Day 6 of week

TC_DAY7_HRS

Opt

F 10.3

Hours – Day 7 of week

HR_CLASS_NUM

Opt

I 3

If this column does not contain a value, PENTA uses the distribution type as the default.

JOB_ID

Opt

X

If Job Id is not null, Cost Type Code and Costcode cannot be null.

COST_TYPE_CD

Opt

C 4

The cost category where PENTA charges labor costs associated with the timecard.

CC

Opt

X

The costcode where PENTA charges labor costs associated with the timecard.

CO_ID

Opt

X

The job-related Change Request associated with a cost distribution.

DR_OU_ID

Opt

X

If Debit OU Id has a value, Debit Account Number must have a value.

DR_ACCT_NUM

Opt

X

The Debit Account Number on the timecard. If the Debit OU Id has a value, Debit Account Number must also have a value.

FA_ID

Opt

X

If Fixed Asset Id is not null, Fixed Asset Expense Category cannot be null.

FA_EXP_CAT_NUM

Opt

I 3

Checked to insure the expense category number is valid for the associated Fixed Asset Id.

HR_TYPE_CD

Opt

C 1

This defaults from the Hour Class

OTH_PAY_AMT

Opt

F 15.2

Miscellaneous pay amount

DESCR

Opt

C 30

Description of the timecard entry.

SPEC_PAY_RT

Opt

F 6.3

The Special Pay Rate.

PR_CLASS_NUM

Opt

I 8

Id of the Payroll class.

PAY_RT_NUM

Opt

I 4

Id of the Pay Rate.

WH_ST_CD

Opt

C 4

Status of the Warehouse.

UC_ST_CD

Opt

C 4

Unemployment Compensation State Code. Override value.

LCL_CD

Opt

C 3

Local Taxing Authority. Override value.

WC_CD

Opt

I 4

Override value

PL_CD

Opt

I 4

Public Liability Code. Override value.

STD_CHRG_RT

Opt

F 15.4

Standard Charge Rate.

SHIFT_NUM

Opt

I 1

Id of the shift.

HAZ_DUTY_NUM

Opt

I 3

Id of the Hazardous Duty.

CREW_ID

Opt

C 8

Id of the Crew.

ADDL_FA_ID

Opt

X

Additional Fixed Asset Id.

FA_COST_TYPE_CD

Opt

C 4

Fixed Asset Cost Type Code.

FA_STD_CHRG_RT

Opt

F 15.4

Equipment charge rate.

TIME_CD

Opt

C 4

Required based on Job Type.

PR_CHK_SORT_
GROUP

Opt

C 5

Id of the Payroll Check Sort Group.

REIMB_NUM

Opt

I 3

If Reimbursement Number is not null, Reimbursement Amount and Reimbursement Applied Account cannot be null. Validated against the Reimbursement table.

REIMB_AMT

Opt

F 15.2

If Reimbursement Amount is not null, Reimbursement Number and Reimbursement Applied Account cannot be null.

REIMB_CR_ACCT_
NUM

Opt

X

If Reimbursement Applied Account is not null, Reimbursement Amount and Reimbursement Number cannot be null.

D_REIMB_DATE

Opt

D

If Reimbursement Number, Amount, or Applied Account contains a value, Reimbursement Date or Week Ending Date must contain a value.

REIMB_JOB_ID

Opt

X

Id of the Reimbursement’s Job. If this has a value, Reimbursement Cost Type Code and Reimbursement Costcode must have values.

REIMB_COST_TYPE_
CD

Opt

C 4

Id of the Reimbursement’s Cost Type.

Required if the Reimbursement Job Id has a value; otherwise, do not enter a value.

REIMB_CC

Opt

X

Id of the Reimbursement’s Costcode.

Required if the Reimbursement Job Id has a value; otherwise, do not enter a value.

REIMB_CO_ID

Opt

X

Id of the Reimbursement’s Change Request.

REIMB_DR_OU_ID

Opt

X

Id of the Reimbursement’s Debit OU Account.

Required if the Reimbursement OU Id has a value; otherwise, do not enter a value.

REIMB_DR_ACCT_
NUM

Opt

X

The Reimbursement’s Debit Account Number.

Required if the Reimbursement OU Id has a value; otherwise, do not enter a value.

REIMB_FA_ID

Opt

X

Id of the Reimbursement’s Fixed Asset Id.

REIMB_FA_EXP_CAT_NUM

Opt

I 3

Id of the Reimbursement’s Asset Expense Category.

Required if the Reimbursement Fixed Asset Id has a value; otherwise, do not enter a value.

DED_NUM

Opt

I 3

Id of the Deduction. Required if Deduction Date has a value.

D_DED_DATE

Opt

D

Date of the deduction.

DED_AMT

Opt

F 15.2

Amount of the deduction.

Required if Deduction Date has a value; otherwise, do not enter a value.

TRANX_REF_ID

Opt

C 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

ITEM_NUM

Opt

X

This is the Work Code column on eTimesheets.

ADJUST_CD

Opt

C! 1

Indicates whether this record is an eTimesheet correction timesheet. Possible values: Y or N.

WO_ID

Opt

C! 25

The Id of the work order.

Note: You can only use the following work order distribution columns when the Work Order Id has a value.

WO_OU_ID

Opt

X

The Id of the OU associated with the work order.

WO_COST_TYPE_CD

Opt

C 4

The Cost Type code of the work order.

WO_CUS_LOC_CD

Opt

C 8

The Customer Location code of the work order.

WO_CUS_EQ_ID

Opt

C 15

The Id of the customer equipment associated with the work order.

WO_TASK_ID

Opt

C! 10

The Task Id associated with the work order.

WO_FA_ID

Opt

X

The Id of the fixed asset associated with the work order.

WO_FA_EXP_CAT_
NUM

Opt

I 3

Work order fixed asset category expense number.

WO_MAINT_SCHD_
NUM

Opt

I 6

Work order maintenance schedule number.

WO_MAINT_CONTRACT_ID

Opt

C! 15

Work order maintenance contract Id.

REIMB_WO_ID

Opt

C 25

The reimbursement associated with the work order.

Note: You can only use the following reimbursement work order distribution columns when the Reimbursement Work Order Id has a value.

REIMB_WO_OU_ID

Opt

X

Reimbursement work order OU Id.

REIMB_WO_COST_
TYPE_CD

Opt

C 4

Reimbursement work order Cost Type code.

REIMB_WO_CUS_LOC_CD

Opt

C 8

Reimbursement work order Customer Location code.

REIMB_WO_CUS_EQ_
ID

Opt

C 15

Reimbursement work order customer equipment Id.

REIMB_WO_TASK_ID

Opt

C! 10

Reimbursement work order task Id.

REIMB_WO_FA_ID

Opt

X

Reimbursement work order fixed asset Id.

REIMB_WO_FA_EXP_
CAT_NUM

Opt

I 3

Reimbursement work order fixed asset category expense number.

REIMB_WO_MAINT_
SCHD_NUM

Opt

I 6

Reimbursement work order maintenance schedule number.

REIMB_WO_MAINT_

CONTRACT_ID

Opt

C! 15

Reimbursement work order maintenance contract Id.

COMP_PROPERTY_
CHRG_CD

Opt

C! 1

Create Equipment Timecard value. Possible values are Y and N.

REIMB_SUBSISTENCE_DAYS

Opt

I 3

Value is required and enterable only when the REIMB_NUM is associated with Calculation Base #9 in the Master Reimbursements window. Use this column to enter the number of subsistence days to process for the timecard record.

EMPLOYMENT_PROV_CD

Opt

C 4

Employment Province Code.

Note: You can only enter this value for a Canadian Payroll Employee.

WORK_PROV_CD

Opt

C 4

Enter the work province. This value determines the workers compensation province and work location-related tax province (e.g., NWT payroll tax). This value defaults on timecards, but you can override it during timecard entry for individual timecards. Note: You can only enter this value for a Canadian Payroll Employee.

CHRG_CURR_CD

Opt

C! 1

Id of the charge Currency.

CERT_CD

Opt

C 1

Determines if the timecard information should be included on Certified Payroll reports. Possible values are: Y or N.

ACTIVITY_LOG_SA_
NUM

Opt

I 8

The System Assigned Number associated with a Crew Activity Log. PENTA automatically defaults this value; do not manually set it.

WORK_PR_CLASS_
NUM

Opt

I 8

The Payroll Class assigned to the work location union affected by a Union Reciprocity Rule. PENTA automatically defaults this value; do not manually set it.

WORK_PAY_RT_NUM

Opt

I 4

The Pay Rate Number assigned to the work location union affected by a Union Reciprocity Rule. PENTA automatically defaults this value; do not manually set it.

TC_DAY1_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 1 of week.

TC_DAY2_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 2 of week.

TC_DAY3_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 3 of week.

TC_DAY4_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 4 of week.

TC_DAY5_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 5 of week.

TC_DAY6_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 6 of week.

TC_DAY7_UNITS

Opt

F 12.3

Number of completed units for the Unit_Pay_CD – Day 7 of week.

UNIT_PAY_CD

Opt

C 15

Unit Pay Code.

Required if the Hour Class is a Unit Rate Payroll hour class; otherwise, do not enter a value.

Note: If you need different unit pay codes for certain days/hours, create a detail row for each different unit pay code.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

D_DISTR_DATE

Opt

D

Use format YYYYMMDD. PENTA uses this date as the distribution date for the timecard entries in the batch.

PFW_EDIT_CD

Opt

C! 1

Determines whether this timecard batch is loaded into the Time/Equipment/Production Units Entry window or the Timecards by Selected Attributes window. Possible values are Y or N. If set to Y, interface batch can be accessed via the Time/Equipment/Production Units Entry Window (if System Option 125 is set to not distribute the batch during the interface process).

RAPID_CHK_CD

Opt

C! 1

Determines whether PENTA distributes this batch as a rapid check batch. Possible values are Y or N.

D_RAPID_CHK_DATE

Opt

D

The check date assigned to rapid checks. Can only be used if RAPID_CHK_CD is Y. Use date format YYYY/MM/DD.

CONVERT_TO_CHK_
CD

Opt

C! 1

You can only use this value if RAPID_CHK_CD is Y. Possible values are Y or N. If you enter Y, employees that typically receive direct deposit will receive a check.

OFFSET_DED_NUM

Opt

N 3

To create a manual AP check to pay the employee, suppress check generation by entering a Deduction Number to use for the offset. Can only be used if RAPID_CHK_CD is Y.

AUTO_REDUCE_DED_CD

Opt

C! 1

If the net pay on a payroll check is negative, PENTA will reduce voluntary after tax deductions until net pay is zero if set to Y. Can only be used if RAPID_CHK_CD is Y.

CHK_DATE_DISTR_CD

Opt

C! 1

Use Check Date as Distr Date column.

If your System Option 288 setting is Y or N, you can enter a value in this position. If the value of your System Option 288 is X, you cannot enter a value in this position. Possible values are Y and N.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.