# Table: Employee

Table: PMSTAFF
View: PM0002
Record length: 621
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Employee Number |  | STAFFCODE

## Fields: 34

Field | Type | Title | Presentation
--- | --- | --- | ---
STAFFCODE | String*16 | Employee Number | Mask: %-16N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
NAME | String*60 | Name |
COMMENT | String*250 | Comments |
INACTIVE | Integer | Status | List: 2 entries
0 | = | Active
1 | = | Inactive
DATELASTMN | Date | Last Maintained |
DATEINACTV | Date | Date Inactive |
GROUP | String*10 | Group |
UNITCOST | BCD*10.6 | Unit Cost |
PAYRATE | Integer | Pay Rate | List: 4 entries
1 | = | Hour
2 | = | Week
3 | = | Month
4 | = | Annum
STDHOURS | BCD*10.2 | Default Hours |
TYPE | Integer | Type | List: 3 entries
1 | = | Salary
2 | = | Timecard
3 | = | Contractor
PAYROLL | String*40 | Payroll Code |
BILLRATE | BCD*10.6 | Billing Rate |
CCY | String*3 | Currency | Mask: %-3N
USERID | String*8 | User ID | Mask: %-8C
EMAIL1 | String*50 | E-mail |
EMAIL2 | String*50 | E-mail |
PAYTYPE | Integer | Payroll Type | List: 2 entries
3 | = | None
2 | = | Canadian Payroll
EARNCODE | String*16 | Earnings Code | Mask: %-16N
ARITEM | String*16 | A/R Item No. | Mask: %-16C
UOM | String*10 | Unit of Measure | Mask: %-10C
STUNITCOST | Integer | Unit Cost |
STTOTCOST | Integer | Total Cost |
STUNITBILL | Integer | Billing Rate |
STTOTBILL | Integer | Billing Amount |
STBILLTYPE | Integer | Billing Type |
SETOTCOST | Integer | Total Cost |
SETOTBILL | Integer | Billing Amount |
SEBILLTYPE | Integer | Billing Type |
VALUES | Long | Optional Fields |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.