Table: Employees

Table: UPEMPL
View: UP0014
Record length: 1372
Flags: A R 

Keys: 6

Title  Flags  Fields

Employee  EMPLOYEE
Last Name  M  LASTNAME, FIRSTNAME, MIDDLENAME, EMPLOYEE
Class 1  M  CLASS1, EMPLOYEE
Class 2  M  CLASS2, EMPLOYEE
Class 3  M  CLASS3, EMPLOYEE
Class 4  M  CLASS4, EMPLOYEE

Fields: 81

Field  Type  Title  Presentation 

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: %-2C
ZIP  String*20  ZIP Code  Mask: %-5d-%-4d
COUNTRY  String*30  Country   
SSN  String*11  Social Security Number  Mask: %-3d-%-2d-%-4d
BIRTHDATE  Date  Birth Date   
STATUS  Integer  Employment Status  List: 3 entries
1=Active
2=Inactive
3=Terminated
HIREDATE  Date  Hire Date   
FIREDATE  Date  Termination Date   
POSITION  String*25  Position   
PARTTIME  Boolean  Part-Time   
PAYFREQ  Integer  Pay Frequency  List: 9 entries
2=Daily
3=Weekly
4=Biweekly
5=Semimonthly
10=Twenty-two per Year
9=Thirteen per Year
6=Monthly
8=Ten per Year
7=Quarterly
CHECKLANG  Integer  Check 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  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
1=
2=Male
3=Female
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  Comp. Time ID   
SSNFORMAT  Integer  SSN Format   
DISABILITY  String*6  RESERVED - Cdn Only   
RPP  String*7  RESERVED - Cdn Only   
WORKPROV  Integer  State of Hire   
TCUSERID  String*8  Timecard User ID  Mask: %-8N
DEPOSIT  Boolean  Direct Deposit   
TRNSFRNAME  String*30  Bank Transfer Name  Mask: %-22c
REFERENCE  String*19  Reference  Mask: %-15c
DISCREDATA  String*2  Discretionary Data   
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=FLSA-Hourly
4=FLSA-Salary Fixed Hours
CNTRYCODE  String*3  Country Code  Mask: %-2C
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   

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.