Module List > Module UPR tables UPR00100
You are currently viewing the COMPANY database.
Change

COMPANY..UPR00100 Table Definition

(COMPANY..Payroll Master)
Employee Master table, one record per employee

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
EMPLCLAS char(15)
''
Employee C...(more) Join Now
join ... more text available
INACTIVE tinyint
0
Set to 1 t...(more) Join Now
LASTNAME char(21)
''
Last Name:...(more) Join Now
FRSTNAME char(15)
''
First Name...(more) Join Now
MIDLNAME char(15)
''
(Optional)...(more) Join Now
ADRSCODE char(15)
''
Address Co...(more) Join Now
SOCSCNUM char(15)
''
(Required ...(more) Join Now
BRTHDATE datetime
'1/1/1900'
(Optional)...(more) Join Now
GENDER smallint
0
Genderbr /...(more) Join Now
ETHNORGN smallint
0
This field...(more) Join Now
Calc_Min_Wage_Bal tinyint
0
Calc Min W...(more) Join Now
DIVISIONCODE_I char(7)
''
*Division:...(more) Join Now
DEPRTMNT char(7)
''
Department...(more) Join Now
join ... more text available
JOBTITLE char(7)
''

SUPERVISORCODE_I char(7)
''
Supervisor...(more) Join Now
LOCATNID char(15)
''

join ... more text available
WCACFPAY smallint
0
Which Cash...(more) Join Now
ACTINDX int
0
Account In...(more) Join Now
join ... more text available
WKHRPRYR smallint
0
Work Hours...(more) Join Now
STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now
DEMPINAC datetime
'1/1/1900'
Date Emplo...(more) Join Now
RSNEMPIN char(31)
''
Reason Emp...(more) Join Now
MINETPAY numeric(19,5)
0.00
Minimum Ne...(more) Join Now
SUTASTAT char(3)
''
Suta State...(more) Join Now
WRKRCOMP char(7)
''
Workers Co...(more) Join Now
ATACRVAC tinyint
0
Auto Accru...(more) Join Now
VACCRAMT int
0
Vacation A...(more) Join Now
VACCRMTH smallint
0
Vacation A...(more) Join Now
VACAPRYR int
0
Vacation H...(more) Join Now
VACAVLBL int
0
Vacation A...(more) Join Now
WRNVCNFLSBLWZR tinyint
0
Warn Vacat...(more) Join Now
ATACRSTM tinyint
0
Auto Accru...(more) Join Now
STMACMTH smallint
0
Sick Time ...(more) Join Now
SKTMACAM int
0
Sick Time ...(more) Join Now
SIKTIMAV int
0
Sick Time ...(more) Join Now
SKTMHPYR int
0
Sick Time ...(more) Join Now
WRNSTFLSBLWZR tinyint
0
Warn Sick ...(more) Join Now
USERDEF1 char(21)
''
User Defin...(more) Join Now
USERDEF2 char(21)
''
User Defin...(more) Join Now
EMPLOYMENTTYPE smallint
0
Type of Em...(more) Join Now
MARITALSTATUS smallint
0
1 = Marrie...(more) Join Now
BENADJDATE datetime
'1/1/1900'
*Ben Adj D...(more) Join Now
LASTDAYWORKED_I datetime
'1/1/1900'
Last Day W...(more) Join Now
BIRTHDAY smallint
0
*Birth Day...(more) Join Now
BIRTHMONTH smallint
0
*Birth Mon...(more) Join Now
SPOUSE char(15)
''

SPOUSESSN char(15)
''
Spouse SSN...(more) Join Now
NICKNAME char(21)
''

ALTERNATENAME char(21)
''
Alternate ...(more) Join Now
HRSTATUS smallint
0
HR Status:...(more) Join Now
DATEOFLASTREVIEW_I datetime
'1/1/1900'
*Date Of ...(more) Join Now
DATEOFNEXTREVIEW_I datetime
'1/1/1900'
*Date Of ...(more) Join Now
BENEFITEXPIRE_I datetime
'1/1/1900'
*Benefit E...(more) Join Now
HANDICAPPED tinyint
0
*Handicapp...(more) Join Now
VETERAN tinyint
0
*Veteran: ...(more) Join Now
VIETNAMVETERAN tinyint
0
*Vietnam V...(more) Join Now
DISABLEDVETERAN tinyint
0
*Disabled ...(more) Join Now
UNIONEMPLOYEE tinyint
0
*Union Emp...(more) Join Now
SMOKER_I tinyint
0
*Smoker: ...(more) Join Now
CITIZEN tinyint
0
*Citizen: ...(more) Join Now
VERIFIED tinyint
0
*Verified:...(more) Join Now
I9RENEW datetime
'1/1/1900'
*I9renew: ...(more) Join Now
Primary_Pay_Record char(7)
''
Primary Pa...(more) Join Now
join ... more text available
CHANGEBY_I char(15)
''
*Change By...(more) Join Now
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
NOTEINDX2 numeric(19,5)
0.00
Note Index...(more) Join Now
UNIONCD char(7)
''
Union Code...(more) Join Now
RATECLSS char(15)
''
Rate Class...(more) Join Now
FEDCLSSCD char(11)
''
Federal ...(more) Join Now
OTHERVET tinyint
0
Other Vete...(more) Join Now
Military_Discharge_Date datetime
'1/1/1900'
Military ...(more) Join Now
EMPLSUFF char(5)
''

STATUSCD char(15)
''

Workflow_Approval_Status smallint
0
Workflow A...(more) Join Now
Workflow_Priority smallint
0
Workflow P...(more) Join Now
Workflow_Status smallint
0

DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
AFSMVET tinyint
0

RECSEPVET tinyint
0

USERID char
''
The user t...(more) Join Now
join ... more text available
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3