Table: Employees

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

Keys: 7

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

Fields: 82

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   
GLSEG2  String*15  Segment Code 2   
GLSEG3  String*15  Segment Code 3   
PHONE  String*30  Phone  Mask: %-30c
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: %-30c
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
EMAIL  String*50  E-mail   
WKLYFLSA  Boolean  Calc OT on a Weekly Basis   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.