Table: Employees

Table: CPEMPL
View: CP0014
Record Length: 1805

Flags: A R 

Keys: 8

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

Fields: 99

Field Type Title Presentation
EMPLOYEE String*12 Employee Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LASTMAINT Date Last Maintained
TEMPLATE String*12 Employee Template Mask: %-12N
LASTNAME String*20 Last Name
FIRSTNAME String*15 First Name
MIDDLENAME String*15 Middle Name
FULLNAME String*60 Full Name
ADDRESS1 String*60 Address Line 1
ADDRESS2 String*60 Address Line 2
ADDRESS3 String*60 Address Line 3
ADDRESS4 String*60 Address Line 4
CITY String*30 City
STATE String*30 State/Province Mask: %-30C
ZIP String*20 Postal Code Mask: %-3N %-3N
COUNTRY String*30 Country
SSN String*11 Social Insurance Number Mask: %-3d-%-3d-%-3d
BIRTHDATE Date Birth Date
STATUS Integer Employment Status List:5 entries
1 = Active
4 = Inactive - ROE Pending
2 = Inactive
5 = Terminated - ROE Pending
3 = Terminated
HIREDATE Date Hire Date
FIREDATE Date Termination Date
POSITION String*25 Position
PARTTIME Boolean Part-Time
PAYFREQ Integer Pay Frequency 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 Integer Cheque Language List:7 entries
5658 = English
7092 = French
5845 = Spanish
738 = Australian
15719 = Mexican
2857 = Chinese (Simplified)
2863 = Chinese (Traditional)
HRSPERPER BCD*4.3 Hours per Period
WCC String*6 Workers' Compensation Code
OTSCHED String*6 Overtime Schedule Mask: %-6N
SHIFTSCHED String*6 Shift Differential Schedule Mask: %-6N
SHIFTNUM Integer Shift Number
TIMESLATE Integer Times Late
ENTRYSEQ Long Entry Sequence
CLASS1 String*6 Class 1 Mask: %-6N
CLASS2 String*6 Class 2 Mask: %-6N
CLASS3 String*6 Class 3 Mask: %-6N
CLASS4 String*6 Class 4 Mask: %-6N
GLSEG1 String*15 Segment Code 1 Mask: %-15N
GLSEG2 String*15 Segment Code 2 Mask: %-15N
GLSEG3 String*15 Segment Code 3
PHONE String*30 Phone Mask: (%-3C) %-3C-%-24C
SUPERVSR String*25 Manager
REVWDATE Date Last Review Date
LASTRAISE Date Date of Last Raise
ALTADDR1 String*60 Alternate Address Line 1
ALTADDR2 String*60 Alternate Address Line 2
ALTADDR3 String*60 Alternate Address Line 3
ALTADDR4 String*60 Alternate Address Line 4
ALTCITY String*30 Alternate City
ALTSTATE String*30 Alternate State/Province
ALTZIP String*20 Alternate ZIP/Postal Code
ALTCNTRY String*30 Alternate Country
GENDER Integer Gender List:4 entries
1 =
2 = Male
3 = Female
4 = Non-binary
ETHNIC Integer
EMERNAME String*60 Emergency Contact
EMERPHON String*30 Emergency Phone Mask: (%-3C) %-3C-%-24C
MINWAGE BCD*10.3 Minimum Wage
VACATION String*6 Vacation ID
SICK String*6 Sick Pay ID
COMPTIME String*6 Banked Time ID
SSNFORMAT Integer SIN Format
DISABILITY String*6 RESERVED - Disability
RPP String*7 Registered Pension Plan Number Mask: %-7D
WORKPROV Integer Province of Employment 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 String*8 Timecard User ID Mask: %-8N
DEPOSIT Boolean Direct Deposit
TRNSFRNAME String*30 Bank Transfer Name Mask: %-30c
REFERENCE String*19 Reference Mask: %-19c
DISCREDATA String*2 RESERVED - US Only
WCCGROUP String*6 Workers Comp. Group Mask: %-6N
INACTDATE Date Inactive Date
VALUES Long Number of Optional Fields
HRSPERDAY BCD*4.3 Regular Hours Per Day
OTCALCTYPE Integer Overtime Calculation List:5 entries
0 = Hourly Rate
1 = Minimum Wage
2 = Shift Rate
3 = Regular Rate-Hourly
4 = Regular Rate-Salary Fixed Hours
CNTRYCODE String*3 Country Code Mask: %-3C
WORKCODE String*6 Work Classification Code Mask: %-6N
HRSPERWEEK BCD*4.3 Hours per Week
SRCEAPPL String*2 Source Application Mask: %-2A
EMAIL String*50 E-mail
WKLYFLSA Boolean Calc OT on a Weekly Basis
USCITIZEN Boolean US Citizen
WORKLOC String*50 Work Location
WLADDR2 String*60 Work Location Address 2
WLADDR3 String*60 Work Location Address 3
WLADDR4 String*60 Work Location Address 4
WLCITY String*30 Work Location City
WLSTATE String*30 Work Location State/Prov Mask: %-30c
WLPOSTAL String*20 Work Location Zip/Postal Code Mask: %-20c
WLCOUNTRY String*30 Work Location Country
GLSEG4 String*15 RESERVED - Segment Code 4
GLSEG5 String*15 RESERVED - Segment Code 5
GLSEG6 String*15 RESERVED - Segment Code 6
MASTGUID String*36 RESERVED - US Only
ELECW2 Integer RESERVED - US Only List:2 entries
0 = No
1 = Yes
EEOJOBCATE Integer RESERVED - US Only 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 Integer RESERVED - US Only 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 Integer RESERVED - US Only 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).