| 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 |
|
|
| 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 |
Mask: %-6N |
| 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
|
| ETHNIC |
Integer |
|
|
| EMERNAME |
String*60 |
Emergency Contact |
|
| EMERPHON |
String*30 |
Emergency Phone |
Mask: (%-3C) %-3C-%-24C |
| OPTTXTFLD1 |
String*2 |
Optional Field 1 |
|
| OPTTXTFLD2 |
String*3 |
Optional Field 2 |
|
| OPTTXTFLD3 |
String*4 |
Optional Field 3 |
|
| OPTTXTFLD4 |
String*12 |
Optional Field 4 |
|
| OPTTXTFLD5 |
String*15 |
Optional Field 5 |
|
| OPTTXTFLD6 |
String*30 |
Optional Field 6 |
|
| OPTAMTFLD |
BCD*10.3 |
Optional Amount Field |
|
| OPTDATEFLD |
Date |
Optional Date Field |
|
| 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 |
|
|