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 EMPLOYEEPERENDTIMECARD
Timecard TIMECARDEMPLOYEEPEREND

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