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