View: Timecard Header

RotoID: CP0031
Table: CPTCHD
Protocol: Header
DLL:CPTCHD

Compositions: 2

RotoID Tables Title DLL
CP0032 CPTCDT Timecard Detail CPTCDT
CP0127 CPTCHO Timecard Optional Field Values CPTCHO

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 Banked Time Hours Paid A C 
CCOMPHRSA 18 BCD*4.3 Banked 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 Banked Time Dollars Paid A C 
CCOMPAMTA 24 BCD*10.3 Banked Time Dollars Accrued A C 
CDISIHRSP 25 BCD*4.3 RESERVED - Disability A C 
CDISIHRSA 26 BCD*4.3 RESERVED - Disability A C 
CDISIAMTP 27 BCD*10.3 RESERVED - Disability A C 
CDISIAMTA 28 BCD*10.3 RESERVED - Disability 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 Banked Time Hours Paid A C 
GCOMPHRSA 39 BCD*4.3 Total Banked 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 Banked Time Dollars Paid A C 
GCOMPAMTA 45 BCD*10.3 Total Banked Time Dollars Accrued A C 
KEYACTION 46 Integer INTERNAL USE - Key Action E A C 
GDISIHRSP 47 BCD*4.3 RESERVED - Disability A C 
GDISIHRSA 48 BCD*4.3 RESERVED - Disability A C 
GDISIAMTP 49 BCD*10.3 RESERVED - Disability A C 
GDISIAMTA 50 BCD*10.3 RESERVED - Disability 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 Banked Time ID E A 
SHIFTSCHED 57 String*6 Shift Differential Schedule E A 
SHIFTNUM 58 Integer Shift Number E A 
WORKPROV 59 Integer Province of Employment 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 2022-Aug-18

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