# Table: Employees

Table: CPEMPL
View: CP0014
Record length: 1322
Flags: A R

## Keys: 6

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

## Fields: 80

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: 5 entries
5658 | = | English
7092 | = | French
5845 | = | Spanish
738 | = | Australian
15719 | = | Mexican
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 | Supervisor |
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: 3 entries
1 | = |
2 | = | Male
3 | = | Female
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: 14 entries
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

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.