Company Job Costing Specification Sheet

General Information

 

Field Name

Column

Max Field Length

Description

*Client ID

A

8

  • Client ID; alphanumeric.

  • * Required field.

*Job Segment Number 1

B

25

  • * Required field.

  • Maximum field length is 25.

  • Alphabetic values are valid.

  • Numeric values are valid.

  • Invalid +<>=;*%

  • If the job number will be segmented, the segment structure must be set up by Paychex prior to Import.

  • 25 is the max length allowed for all the job segments combined.

  • If segments are not used, duplicate job numbers are invalid.

  • If segments are used, then duplicates are valid. For example, the following are both valid Jobs that use three segments:

    123 456 789
    123 456 123

Job Segment Number 2

C

25

  • Optional field.

  • Maximum field length is specified by the client setup.

  • Alphabetic values are valid.

  • Numeric values are valid.

  • Invalid +<>=;*%

  • Segment structure must be set up by Paychex prior to Import.

  • Segment 1 must be set up prior to Segment 2.

Job Segment Number 3

D

25

  • Optional field.

  • Maximum field length is specified by the client setup.

  • Alphabetic values are valid.

  • Numeric values are valid.

  • Invalid +<>=;*%

  • Segment structure must be set up by Paychex prior to Import.

  • Segment 1 and 2 must be set up prior to Segment 3.

Job Name

E

30

  • Optional field.

  • Maximum field length is 30.

  • Invalid +<>=;*%

  • Duplicate job names are not valid.

  • The combination of the Job Number and the Job Name must be unique.  Example: All the Names could be the same, but the job number would be different. Or if the Job Numbers are all the same and the Job Names are different.

State

F

2

  • Optional field

  • Valid 2 digit postal State code is provided.

  • The assumption is that State is already set up by Paychex.

Local Jurisdiction

G

2

  • Optional field.

  • Maximum field length is 2.

  • State code associated with the Local in column H.

  • Local Jurisdiction field is required when the Local field is populated.

Local

H

15

  • Optional field.

  • Abbreviated regulation name is used.

  • Maximum field length is 15.

  • Alphabetic values are valid.

  • Numeric values are valid.

  • The assumption is that Locals are already set up by Paychex.

Workers' Comp Class Code State

I

2

  • Optional field.

  • Client must have a Workers' Comp Policy.

  • Maximum field length is 2.

  • Valid 2 digit postal State code is provided.

  • PEO clients are unable to modify the field.

  • Workers’ Comp Class Code State is required when the Workers’ Comp Class Code is populated.

  • This field is populated by Paychex.

Workers' Comp Class Code

J

6

  • Optional field.

  • Client must have a Workers' Comp Policy.

  • Maximum field length is 6.

  • Alphanumeric values are valid for Washington State only.

  • Numeric values are valid.

  • PEO clients are unable to modify the field.

  • Workers’ Comp Class Code is required when the Workers' Comp Class Code State is populated.

  • This field is populated by Paychex.

Workers' Comp Suffix

K

2

  • Optional field.

  • Workers' Comp Class Code suffix is 2 characters.

  • Alphanumeric values are valid for Washington State only.

  • Alphabetic Values are valid.

  • PEO clients are unable to modify the field.

  • This field is populated by Paychex.

Pay Rate

L

9

  • Optional field.

  • Maximum field length is 9 (example: XXXX.XXXX).

  • Range is between 0.0001 and <= 9999.9999.

  • Alphabetic values are invalid.

  • Numeric values are valid.

  • If the pay rate is populated, the pay rate # cannot be used.

Pay Rate #

M

1

  • Optional field.

  • Maximum field length is 1.

  • Valid entry is 1, 2, 3, 4, or 5.

  • Alphabetic values are invalid.

  • If the pay rate # is populated, the pay rate cannot be used.

Burden Factor Amount

N

7

  • Optional field.

  • Maximum field length is 7 (example: XXX.XXX).

  • Alphabetic values are invalid.

  • Numeric values are valid.

  • If the burden factor amount is populated, the burden factor % cannot be used.

Burden Factor %

O

6

  • Optional field.

  • Maximum field length is 6 (example XXX.XX).

  • Alphabetic values are invalid.

  • Numeric values are valid.

  • If the burden factor % is populated, the burden factor amount cannot be used.

Shift Name

P

30

  • Optional field.

  • Maximum field length is 30.

  • Alphabetic values are valid.

  • Numeric values are valid.

  • Shifts must be set up by Paychex prior to import.  

Start Date

Q

10

  • Optional field.

  • The default start date of the import is the system date.

  • Valid date format is MM/DD/YYYY.