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 EMPLOYEEENDDATEPAYDATEEARNDEDUNIQUE
Timecard Earning EMPLOYEEENDDATEEARNDEDUNIQUEPAYDATE

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