# View: Employee

RotoID: PM0002
Table: PMSTAFF
DLL: PMSTAFF

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
PM0511 | PMSTAFFO | Employee Optional Fields | PMSTAFFO

## Keys: 1

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

## Fields: 31

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
STAFFCODE | 1 | String*16 | Employee Number | E A K R | Mask: %-16N
NAME | 2 | String*60 | Name | E A |
COMMENT | 3 | String*250 | Comments | E A |
INACTIVE | 4 | Integer | Status | E A | List: 2 entries
0 | = | Active
1 | = | Inactive
DATELASTMN | 5 | Date | Last Maintained | A C |
DATEINACTV | 6 | Date | Date Inactive | A C |
GROUP | 7 | String*10 | Group | E A |
UNITCOST | 8 | BCD*10.6 | Unit Cost | E A |
PAYRATE | 9 | Integer | Pay Rate | E A | List: 4 entries
1 | = | Hour
2 | = | Week
3 | = | Month
4 | = | Annum
STDHOURS | 10 | BCD*10.2 | Default Hours | E A |
TYPE | 11 | Integer | Type | E A | List: 3 entries
1 | = | Salary
2 | = | Timecard
3 | = | Contractor
PAYROLL | 12 | String*40 | Payroll Code | E A |
BILLRATE | 13 | BCD*10.6 | Billing Rate | E A |
CCY | 14 | String*3 | Currency | E A | Mask: %-3N
USERID | 15 | String*8 | User ID | E A | Mask: %-8C
EMAIL1 | 16 | String*50 | E-mail | E A |
EMAIL2 | 17 | String*50 | E-mail | E A |
PAYTYPE | 18 | Integer | Payroll Type | E A X | List: 2 entries
3 | = | None
2 | = | Canadian Payroll
EARNCODE | 19 | String*16 | Earnings Code | E A | Mask: %-16N
ARITEM | 20 | String*16 | A/R Item No. | E A | Mask: %-16C
UOM | 21 | String*10 | Unit of Measure | E A | Mask: %-10C
STUNITCOST | 22 | Integer | Unit Cost | E A |
STTOTCOST | 23 | Integer | Total Cost | E A |
STUNITBILL | 24 | Integer | Billing Rate | E A |
STTOTBILL | 25 | Integer | Billing Amount | E A |
STBILLTYPE | 26 | Integer | Billing Type | E A |
SETOTCOST | 27 | Integer | Total Cost | E A |
SETOTBILL | 28 | Integer | Billing Amount | E A |
SEBILLTYPE | 29 | Integer | Billing Type | E A |
VALUES | 30 | Long | Optional Fields | E A C |
INPAYROLL | 1000 | Integer | Description | A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.