Acroprint Time Q User's Guide download pdf (Page 48)

timeQplus Administrator Functions – Export

06-0414-000 Rev. C

N4 Numeric 4 decimals

implied

File Layout

If an employee only has hours worked with no cost center or rate overrides, the following layout may be

used.

Field # Positions Length Format Field Name and Description

1 1-3 3 AN Company Identifier; Ex "PMC"

2 4-5 2 N Group Identifier Ex: 05

3 6-14 9 AN Social Security Number (no dashes)

4 15-20 6 A

Space Fill

5 21-22 2 AN Literal ‘85’

6 23-27 5 AN Sequence Field ‘YMMDD’

7 28 1 AN Literal ‘1’

8 29-30 2 N Earning number Ex ‘01’ for Regular

9 31-36 6 N2 Hours, Units or Dollars and Cents

If no additional Earnings are needed, space fill the

remaining fields

10 37-38 2 N Earning number Ex ‘02’ for Overtime

11 39-44 6 N2 Hours, Units or Dollars and Cents

12 45-46 2 N Earning Number Ex ‘03’ for Doubletime

13 47-52 6 N2 Hours, Units or Dollars and Cents

14 53-54 2 N Earning Number Ex ‘05’ for Shift 2

15 55-60 6 N2 Hours, Units or Dollars and Cents

16 61-62 2 N Earning Number Ex ‘17’ Holiday

17 63-68 6 N2 Hours, Units or Dollars and Cents

18 69-70 2 N Earning Number Ex ‘19’ Jury Duty

19 71-76 6 N2 Hours, Units or Dollars and Cents

20 77-80 4 A Space Fill

If an employee has cost center or rate overrides, the following layout may be used.

Field # Positions Length Format Field Name and Description

1 1-3 3 AN Company Identifier; Ex "PMC"

2 4-5 2 N Group Identifier Ex: 05

3 6-14 9 AN Social Security Number (no dashes)

4 15-20 6 A

Space Fill

5 21-22 2 AN Literal ‘82’

6 23-27 5 AN Sequence Field ‘YMMDD’

1 2 ... 43 44 45 46 47 48 49 50 51 52 53 ... 88 89

No comments

Acroprint Time Q User's Guide Page 48