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

COMPANY..UPR00601 Table Definition

(COMPANY..Payroll Benefit Based On Master)

This file holds the 'Based On’ fields for a benefit of the 'Based On Records' field =1 in the Payroll Benefits Master file. If the benefit is based on more than one code (but not all the pay codes) then there would be multiple lines in this file.

In SBM, this table is only available if the 'Based On Record Type' field is set to 2 in the Payroll Benefits Master table. In other words, in SBM, this file only contains records that are related to the Payroll Benefits Master records with ‘Based On Records’ = 1 and ‘Based On Record Type’ = 2.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
BENEFIT char(7)
''

BORCDTYP smallint
0
Based On ...(more) Join Now
BSDONCDE char(7)
''
Based On C...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
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