# View: Employee Timecard Detail

RotoID: CP0103
Table: CPUTCD
Protocol: Detail, Ordered revisions
DLL: CPUTCD

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
CP0102 | CPUTCH | Employee Timecard Header | CPUTCH
CP0132 | CPUTDO | Empl Timecard Details Opt Flds | CPUTDO
CP0044 | CPUTJB | Employee Timecard Job Details | CPUTJB

## Keys: 2

Title | Fields
--- | ---
Timecard Date | EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE
Timecard Earning | EMPLOYEE, ENDDATE, EARNDED, UNIQUE, PAYDATE

## Fields: 33

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R | Mask: %-12N
ENDDATE | 2 | Date | End Date | E A K R |
PAYDATE | 3 | Date | Pay Date | E A K R |
EARNDED | 4 | String*6 | Earning/Exp/Tip/Accrual Code | E A K R | Mask: %-6N
UNIQUE | 5 | Integer | Unique Key Field | E A K R |
CATEGORY | 6 | Integer | Category | A C | List: 7 entries
0 | = | Hours
1 | = | Tips
2 | = | Expense
3 | = | Piece Rate
4 | = | Sales Commissions
5 | = | Sick Accrual Payment
6 | = | Vacation Accrual Payment
STARTTIME | 7 | Integer | Start Time | E A X |
STOPTIME | 8 | Integer | Stop Time | E A X |
HOURS | 9 | BCD*4.3 | Hours Worked | E A X |
TIPSEXP | 10 | BCD*9.5 | Tips/Expense/Pieces/Sales Amount | X |
SHIFTSCHED | 11 | String*6 | Shift Differential Schedule | E A X | Mask: %-6N
SHIFTNUM | 12 | Integer | Shift Number | X |
VALUES | 13 | Long | Number of Optional Fields | E A C |
POOLEDTIPS | 14 | BCD*10.3 | Pooled Tips | X |
TIPSBASE | 15 | BCD*10.3 | Tips Based On | X |
JOBS | 16 | Long | Jobs | E A C X |
WORKCODE | 17 | String*6 | Work Classification Code | E A | Mask: %-6N
JOBHOURS | 18 | BCD*4.3 | Total Job Hours | E A C X |
JOBBASE | 19 | BCD*10.3 | Total Job Pieces/Sales/Amt | C X |
DOW | 20 | Integer | Day of the Week | A | List: 7 entries
1 | = | Sunday
2 | = | Monday
3 | = | Tuesday
4 | = | Wednesday
5 | = | Thursday
6 | = | Friday
7 | = | Saturday
PROCESSCMD | 21 | Integer | Process Command Code | E A C | List: 3 entries
0 | = | No Action
1 | = | Insert Optional Fields
2 | = | Update Info to Match Jobs
CALCMETH | 22 | Integer | Calculation Method | E A C |
EDCATEGORY | 23 | Integer | Earn/Ded Category | E A C |
EARDEDTYPE | 24 | Integer | Earn/Ded Type | E A C |
GLSEG1 | 25 | String*15 | G/L Segment One | E A C |
GLSEG2 | 26 | String*15 | G/L Segment Two | E A C |
GLSEG3 | 27 | String*15 | G/L Segment Three | E A C |
GLSEGID1 | 28 | String*6 | G/L Segment Name One | E A C |
GLSEGDESC1 | 29 | String*60 | G/L Segment Description One | E A C |
GLSEGID2 | 30 | String*6 | G/L Segment Name Two | E A C |
GLSEGDESC2 | 31 | String*60 | G/L Segment Description Two | E A C |
GLSEGID3 | 32 | String*6 | G/L Segment Name Three | E A C |
GLSEGDESC3 | 33 | String*60 | G/L Segment Description Three | E A C |

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.