View: Employees

RotoID: CP0014
Table: CPEMPL
Protocol: Header
DLL:CPEMPL

Compositions: 7

RotoID Tables Title DLL
CP0008 CPEMPD Employee Earnings/Deductions CPEMPD
CP0010 CPEMPT Employee Taxes CPEMPT
CP0053 CPEMPC Employee Notes CPEMPC
CP0201 CPEMBK Employee EFT Banks CPEMBK
CP0122 CPEMPO Employee Optional Field Values CPEMPO
CP0118 CPEMCS Employee Garnishment CPEMCS
CP0119 CPECMM Employee Comments CPECMM

Keys: 8

Title Fields
Employee EMPLOYEE
Last Name LASTNAME, FIRSTNAME, MIDDLENAME, EMPLOYEE
Class 1 CLASS1, EMPLOYEE
Class 2 CLASS2, EMPLOYEE
Class 3 CLASS3, EMPLOYEE
Class 4 CLASS4, EMPLOYEE
Timecard User TCUSERID, EMPLOYEE
Sync Master GUID MASTGUID

Fields: 98

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
LASTMAINT 2 Date Last Maintained E A C 
TEMPLATE 3 String*12 Employee Template E A  Mask: %-12N
LASTNAME 4 String*20 Last Name E A 
FIRSTNAME 5 String*15 First Name E A 
MIDDLENAME 6 String*15 Middle Name E A 
FULLNAME 7 String*60 Full Name E A C 
ADDRESS1 8 String*60 Address Line 1 E A 
ADDRESS2 9 String*60 Address Line 2 E A 
ADDRESS3 10 String*60 Address Line 3 E A 
ADDRESS4 11 String*60 Address Line 4 E A 
CITY 12 String*30 City E A 
STATE 13 String*30 State/Province E A P  Mask: %-30C
ZIP 14 String*20 Postal Code E A P  Mask: %-3N %-3N
COUNTRY 15 String*30 Country E A 
SSN 16 String*11 Social Insurance Number E A P X  Mask: %-3d-%-3d-%-3d
BIRTHDATE 17 Date Birth Date E A 
STATUS 18 Integer Employment Status E A P  List:5 entries
1 = Active
4 = Inactive - ROE Pending
2 = Inactive
5 = Terminated - ROE Pending
3 = Terminated
HIREDATE 19 Date Hire Date E A 
FIREDATE 20 Date Termination Date E A 
POSITION 21 String*25 Position E A 
PARTTIME 22 Boolean Part-Time E A 
PAYFREQ 23 Integer Pay Frequency E A P  List:8 entries
2 = Daily
3 = Weekly
4 = Biweekly
5 = Semimonthly
10 = Twenty-two per Year
9 = Thirteen per Year
6 = Monthly
8 = Ten per Year
CHECKLANG 24 Integer Cheque Language E A P  List:7 entries
5658 = English
7092 = French
5845 = Spanish
738 = Australian
15719 = Mexican
2857 = Chinese (Simplified)
2863 = Chinese (Traditional)
HRSPERPER 25 BCD*4.3 Hours per Period E A 
WCC 26 String*6 Workers' Compensation Code X 
OTSCHED 27 String*6 Overtime Schedule E A  Mask: %-6N
SHIFTSCHED 28 String*6 Shift Differential Schedule E A  Mask: %-6N
SHIFTNUM 29 Integer Shift Number X 
TIMESLATE 30 Integer Times Late E A 
ENTRYSEQ 31 Long Entry Sequence E A 
CLASS1 32 String*6 Class 1 E A  Mask: %-6N
CLASS2 33 String*6 Class 2 E A  Mask: %-6N
CLASS3 34 String*6 Class 3 E A  Mask: %-6N
CLASS4 35 String*6 Class 4 E A  Mask: %-6N
GLSEG1 36 String*15 Segment Code 1 E A  Mask: %-15N
GLSEG2 37 String*15 Segment Code 2 E A  Mask: %-15N
GLSEG3 38 String*15 Segment Code 3
PHONE 39 String*30 Phone E A  Mask: (%-3C) %-3C-%-24C
SUPERVSR 40 String*25 Manager E A 
REVWDATE 41 Date Last Review Date E A 
LASTRAISE 42 Date Date of Last Raise E A 
ALTADDR1 43 String*60 Alternate Address Line 1 E A 
ALTADDR2 44 String*60 Alternate Address Line 2 E A 
ALTADDR3 45 String*60 Alternate Address Line 3 E A 
ALTADDR4 46 String*60 Alternate Address Line 4 E A 
ALTCITY 47 String*30 Alternate City E A 
ALTSTATE 48 String*30 Alternate State/Province E A 
ALTZIP 49 String*20 Alternate ZIP/Postal Code E A 
ALTCNTRY 50 String*30 Alternate Country E A 
GENDER 51 Integer Gender E A  List:4 entries
1 =
2 = Male
3 = Female
4 = Non-binary
EMERNAME 52 String*60 Emergency Contact E A 
EMERPHON 53 String*30 Emergency Phone E A  Mask: (%-3C) %-3C-%-24C
MINWAGE 62 BCD*10.3 Minimum Wage E A 
VACATION 63 String*6 Vacation ID E A C 
SICK 64 String*6 Sick Pay ID E A C 
COMPTIME 65 String*6 Banked Time ID E A C 
SSNFORMAT 66 Integer SIN Format E A C 
DISABILITY 67 String*6 RESERVED - Disability E A C 
RPP 68 String*7 Registered Pension Plan Number E A  Mask: %-7D
WORKPROV 69 Integer Province of Employment E A  List:15 entries
0 =
1 = Alberta
2 = British Columbia
3 = Manitoba
4 = New Brunswick
5 = Newfoundland & Labrador
6 = Northwest Territories
7 = Nova Scotia
8 = Ontario
9 = Outside Canada
10 = Prince Edward Island
11 = Quebec
12 = Saskatchewan
13 = Yukon Territory
14 = Nunavut
TCUSERID 70 String*8 Timecard User ID E A  Mask: %-8N
DEPOSIT 71 Boolean Direct Deposit E A 
TRNSFRNAME 72 String*30 Bank Transfer Name E A  Mask: %-30c
REFERENCE 73 String*19 Reference E A  Mask: %-19c
DISCREDATA 74 String*2 RESERVED - US Only
WCCGROUP 75 String*6 Workers Comp. Group E A  Mask: %-6N
INACTDATE 76 Date Inactive Date E A 
VALUES 77 Long Number of Optional Fields E A C 
HRSPERDAY 78 BCD*4.3 Regular Hours Per Day E A 
OTCALCTYPE 79 Integer Overtime Calculation E A P X  List:5 entries
0 = Hourly Rate
1 = Minimum Wage
2 = Shift Rate
3 = Regular Rate-Hourly
4 = Regular Rate-Salary Fixed Hours
CNTRYCODE 80 String*3 Country Code E A  Mask: %-3C
WORKCODE 81 String*6 Work Classification Code E A  Mask: %-6N
HRSPERWEEK 82 BCD*4.3 Hours per Week X 
SRCEAPPL 83 String*2 Source Application E A  Mask: %-2A
EMAIL 84 String*50 E-mail E A 
WKLYFLSA 85 Boolean Calc OT on a Weekly Basis X 
USCITIZEN 86 Boolean US Citizen E A X 
WORKLOC 87 String*50 Work Location E A 
WLADDR2 88 String*60 Work Location Address 2 E A 
WLADDR3 89 String*60 Work Location Address 3 E A 
WLADDR4 90 String*60 Work Location Address 4 E A 
WLCITY 91 String*30 Work Location City E A 
WLSTATE 92 String*30 Work Location State/Prov E A P  Mask: %-30c
WLPOSTAL 93 String*20 Work Location Zip/Postal Code E A P  Mask: %-20c
WLCOUNTRY 94 String*30 Work Location Country E A 
GLSEG4 95 String*15 RESERVED - Segment Code 4
GLSEG5 96 String*15 RESERVED - Segment Code 5
GLSEG6 97 String*15 RESERVED - Segment Code 6
MASTGUID 98 String*36 RESERVED - US Only E A 
ELECW2 99 Integer RESERVED - US Only E A P X  List:2 entries
0 = No
1 = Yes
PROCESSCMD 100 Integer Process Command Code E A C  List:3 entries
0 = Copy Employee Template
1 = Insert Optional Fields
2 = Check for Timecard and Manual Cheques
USERSEC 101 Integer Employee Security Flag1 E A 
NOUSERSEC 102 Integer Employee Security Flag2 E A 
SELECTLIST 103 String*8 INTERNAL USE - Selection List E A 
EEOJOBCATE 104 Integer RESERVED - US Only E A  List:11 entries
0 =
1 = Executive/Senior Level Officials and Managers
2 = First/Mid-Level Officials and Managers
3 = Professionals
4 = Technicians
5 = Sales Workers
6 = Administrative Support Workers
7 = Craft Workers
8 = Operatives
9 = Laborers and Helpers
10 = Service Workers
EEOETHNIC 105 Integer RESERVED - US Only E A  List:15 entries
0 =
1 = A - Hispanic or Latino Male
2 = B - Hispanic or Latino Female
3 = C - White Male
4 = D - Black or African American Male
5 = E - Native Hawaiian or Pacific Islander Male
6 = F - Asian Male
7 = G - Native American or Alaska Native Male
8 = H - Two or more races Male
9 = I - White Female
10 = J - Black or African American Female
11 = K - Native Hawaiian or Pacific Islander Female
12 = L - Asian Female
13 = M - Native American or Alaska Native Female
14 = N - Two or more races Female
CAEEOETHN 106 Integer RESERVED - US Only E A  List:22 entries
0 =
1 = A10 - Hispanic/Latino - Male
2 = A20 - Hispanic/Latino - Female
3 = A30 - Hispanic/Latino - Non-Binary
4 = B10 - Non-Hispanic/Non-Latino - Male - White
5 = B20 - Non-Hispanic/Non-Latino - Male - Black or African American
6 = B30 - Non-Hispanic/Non-Latino - Male - Native Hawaiian or Other Pacific Islander
7 = B40 - Non-Hispanic/Non-Latino - Male - Asian
8 = B50 - Non-Hispanic/Non-Latino - Male - American Indian or Alaskan Native
9 = B60 - Non-Hispanic/Non-Latino - Male - Two or more races
10 = C10 - Non-Hispanic/Non-Latino - Female - White
11 = C20 - Non-Hispanic/Non-Latino - Female - Black or African American
12 = C30 - Non-Hispanic/Non-Latino - Female - Native Hawaiian or Other Pacific Islander
13 = C40 - Non-Hispanic/Non-Latino - Female - Asian
14 = C50 - Non-Hispanic/Non-Latino - Female - American Indian or Alaskan Native
15 = C60 - Non-Hispanic/Non-Latino - Female - Two or more races
16 = D10 - Non-Hispanic/Non-Latino - Non-Binary - White
17 = D20 - Non-Hispanic/Non-Latino - Non-Binary - Black or African American
18 = D30 - Non-Hispanic/Non-Latino - Non-Binary - Native Hawaiian or Other Pacific Islander
19 = D40 - Non-Hispanic/Non-Latino - Non-Binary - Asian
20 = D50 - Non-Hispanic/Non-Latino - Non-Binary - American Indian or Alaskan Native
21 = D60 - Non-Hispanic/Non-Latino - Non-Binary - Two or more races

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