| 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
|
| 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 |
|
| EMPLERDENT |
Integer |
Employer Offered Dental |
List:5 entries
| 0 |
= |
1 - No dental insurance or coverage of any kind |
| 1 |
= |
2 - Payee only |
| 2 |
= |
3 - Payee, spouse and dependent children |
| 3 |
= |
4 - Payee and their spouse |
| 4 |
= |
5 - Payee and their dependent children |
|
| PAYERDENT |
Integer |
Payer Offered Dental |
List:5 entries
| 0 |
= |
1 - No dental insurance or coverage of any kind |
| 1 |
= |
2 - Payee only |
| 2 |
= |
3 - Payee, spouse and dependent children |
| 3 |
= |
4 - Payee and their spouse |
| 4 |
= |
5 - Payee and their dependent children |
|
| WLCOUNTY |
String*30 |
RESERVED - US Only |
|
|