View: Employee Timecard Header

RotoID: CP0102
Table: CPUTCH
Protocol: Header
DLL:CPUTCH

Compositions: 2

RotoID Tables Title DLL
CP0103 CPUTCD Employee Timecard Detail CPUTCD
CP0131 CPUTHO Empl Timecard Optional Fields CPUTHO

Keys: 1

Title Fields
Timecard Employee EMPLOYEE, ENDDATE

Fields: 26

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 
TCARDDESC 3 String*15 Description E A 
STATUS 4 Integer Status E A  List:4 entries
0 = New
1 = Ready for Approval
3 = Reviewed
2 = Approved
VALUES 5 Long Number of Optional Fields E A C 
UNIQUE 6 Integer Unique Key Field E A C 
SWJOB 7 Boolean Job Related E A 
STARTDATE 20 Date Start Date A C 
TOTALHOURS 21 BCD*4.3 Total Hours E A C 
TOTALTIPS 22 BCD*10.3 Total Tips E A C 
TOTALEXP 23 BCD*10.3 Total Expenses E A C 
OPCODE 24 Integer Process Control Code E A  List:3 entries
0 = No Action
1 = Insert Default Details
2 = Insert Optional Fields
SHIFTSCHED 25 String*6 Default Shift Schedule A 
SHIFTNUM 26 Integer Default Shift Number A 
PARTTIME 27 Boolean Part-Time E A 
EMPSTATUS 28 Integer Employment Status E A 
HIREDATE 29 Date Hire Date E A 
FIREDATE 30 Date Termination Date E A 
INACTDATE 31 Date Inactive Date E A 
TOTALPIECE 32 BCD*10.3 Total Pieces E A C 
TOTALSALES 33 BCD*10.3 Total Sales E A C 
WORKCODE 34 String*6 Work Classification A C 
TOTALJOBS 35 Long Total Jobs E A C 
TOTALSICK 36 BCD*4.3 Total Sick Payments E A C 
TOTALVAC 37 BCD*4.3 Total Vacation Payments E A C 
USERSEC 38 Integer E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).