View: Timecard Header

RotoID: UP0031
Table: UPTCHD
Protocol: Header
DLL:UPTCHD

Compositions: 2

RotoID Tables Title DLL
UP0032 UPTCDT Timecard Detail UPTCDT
UP0127 UPTCHO Timecard Optional Field Values UPTCHO

Keys: 2

Title Fields
Employee Timecard EMPLOYEE, PEREND, TIMECARD
Timecard TIMECARD, EMPLOYEE, PEREND

Fields: 74

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
PEREND 2 Date Period End Date E A K R 
TIMECARD 3 String*6 Timecard E A K R  Mask: %-6N
TCARDDESC 4 String*15 Description E A 
TIMESLATE 5 Integer Times late E A 
REUSECARD 6 Boolean Reusable E A 
ACTIVE 7 Boolean Active flag E A 
SEPARATECK 8 Boolean Separate Check flag E A 
PROCESSED 9 Boolean Processed Flag E A C 
CREGHRS 11 BCD*4.3 Regular Hours A C 
CSHIFTHRS 12 BCD*4.3 Shift Hours A C 
CVACHRSP 13 BCD*4.3 Vacation Hours Paid A C 
CVACHRSA 14 BCD*4.3 Vacation Hours Accrued A C 
CSICKHRSP 15 BCD*4.3 Sick Hours Paid A C 
CSICKHRSA 16 BCD*4.3 Sick Hours Accrued A C 
CCOMPHRSP 17 BCD*4.3 Compensatory Time Hours Paid A C 
CCOMPHRSA 18 BCD*4.3 Comp. Time Hours Accrued A C 
CVACAMTP 19 BCD*10.3 Vacation Dollars Paid A C 
CVACAMTA 20 BCD*10.3 Vacation Dollars Accrued A C 
CSICKAMTP 21 BCD*10.3 Sick Time Dollars Paid A C 
CSICKAMTA 22 BCD*10.3 Sick Time Dollars Accrued A C 
CCOMPAMTP 23 BCD*10.3 Comp. Time Dollars Paid A C 
CCOMPAMTA 24 BCD*10.3 Comp. Time Dollars Accrued A C 
CDISIHRSP 25 BCD*4.3 RESERVED - Cdn Only A C 
CDISIHRSA 26 BCD*4.3 RESERVED - Cdn Only A C 
CDISIAMTP 27 BCD*10.3 RESERVED - Cdn Only A C 
CDISIAMTA 28 BCD*10.3 RESERVED - Cdn Only A C 
LASTNAME 29 String*20 Last Name A C 
FIRSTNAME 30 String*15 First Name A C 
MIDDLENAME 31 String*15 Middle Name A C 
GREGHRS 32 BCD*4.3 Total Regular Hours A C 
GSHIFTHRS 33 BCD*4.3 Total Shift Hours A C 
GVACHRSP 34 BCD*4.3 Total Vacation Hours Paid A C 
GVACHRSA 35 BCD*4.3 Total Vacation Hours Accrued A C 
GSICKHRSP 36 BCD*4.3 Total Sick Hours Paid A C 
GSICKHRSA 37 BCD*4.3 Total Sick Hours Accrued A C 
GCOMPHRSP 38 BCD*4.3 Total Comp. Time Hours Paid A C 
GCOMPHRSA 39 BCD*4.3 Total Comp. Time Hours Accrued A C 
GVACAMTP 40 BCD*10.3 Total Vacation Dollars Paid A C 
GVACAMTA 41 BCD*10.3 Total Vacation Dollars Accrued A C 
GSICKAMTP 42 BCD*10.3 Total Sick Time Dollars Paid A C 
GSICKAMTA 43 BCD*10.3 Total Sick Time Dollars Accrued A C 
GCOMPAMTP 44 BCD*10.3 Total Comp. Time Dollars Paid A C 
GCOMPAMTA 45 BCD*10.3 Total Comp. Time Dollars Accrued A C 
KEYACTION 46 Integer INTERNAL USE - Key Action E A C 
GDISIHRSP 47 BCD*4.3 RESERVED - Cdn Only A C 
GDISIHRSA 48 BCD*4.3 RESERVED - Cdn Only A C 
GDISIAMTP 49 BCD*10.3 RESERVED - Cdn Only A C 
GDISIAMTA 50 BCD*10.3 RESERVED - Cdn Only A C 
HIREDATE 51 Date Hire Date E A 
FIREDATE 52 Date Termination Date E A 
PARTTIME 53 Boolean Part-Time E A 
PAYFREQ 54 Integer Pay Frequency E A 
OTSCHED 55 String*6 Overtime Schedule E A 
COMPTIME 56 String*6 Comp. Time ID E A 
SHIFTSCHED 57 String*6 Shift Differential Schedule E A 
SHIFTNUM 58 Integer Shift Number E A 
WORKPROV 59 Integer RESERVED - Cdn Only E A 
STATUS 60 Integer Employment Status E A 
INACTDATE 61 Date Inactive Date E A 
PROCESSCMD 62 Integer Process Command Code E A C  List:2 entries
0 = Key Action
1 = Insert Optional Fields
GOTHOURS 63 BCD*4.3 Total Overtime Hours A C 
OTCALCTYPE 64 Integer Overtime Calculation A C 
HRSPERDAY 65 BCD*4.3 Regular Hours Per Day E A 
WORKCODE 66 String*6 Work Classification A C 
TOTALJOBS 67 Long Total Jobs E A C 
USERSEC 68 Integer Security Flag E A 
WKLYFLSA 69 Boolean Calc OT on a Weekly Basis A C 
VALUES 75 Long Number of Optional Fields E A C 
OTOVERRIDE 76 Boolean Overtime Override E A 
COTHOURS 77 BCD*4.3 Overtime Hours A C 
TCDLINES 78 Integer Timecard Lines E A C 
SWJOB 79 Boolean Job Related E A X 
SRCEAPPL 80 String*2 Source Application E A  Mask: %-2A

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).