View: Employee Timecard Detail

RotoID: UP0103
Table: UPUTCD
Protocol: Detail, Ordered revisions
DLL:UPUTCD

Compositions: 3

RotoID Tables Title DLL

UP0102 UPUTCH Employee Timecard Header UPUTCH
UP0132 UPUTDO Empl Timecard Details Opt Flds UPUTDO
UP0044 UPUTJB Employee Timecard Job Details UPUTJB

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 RESERVED - Cdn Only X 
TIPSBASE 15 BCD*10.3 RESERVED - Cdn Only 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