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

COMPANY..UPR00900 Table Definition

(COMPANY..Payroll Employee Summary)

Formula for the SUTAWAGS fields. 

The idea is UPR30300 pay - UPR30300 deductions where SHFRSTTX = 1

SELECT e.EMPLOYID, pay.Pay, deds.deds , pay.Pay - deds.deds AS SUTAWAGS
    FROM upr00100 e
        JOIN (
            SELECT ut.EMPLOYID, SUM(ut.UPRTRXAM) AS Pay
                FROM upr30300 ut
                WHERE ut.EMPLOYID = '22'
                    AND ut.PYRLRTYP = 1
                    AND ut.CHEKDATE BETWEEN '1/1/2024' AND '3/31/2024'
                GROUP BY ut.EMPLOYID
        ) pay ON e.EMPLOYID = pay.EMPLOYID
        JOIN (
            SELECT ut.EMPLOYID, SUM(ut.UPRTRXAM) AS deds
                FROM upr30300 ut
                    LEFT JOIN upr00500 ded ON ded.EMPLOYID = ut.EMPLOYID AND ded.DEDUCTON = ut.PAYROLCD
                WHERE ut.EMPLOYID = '22'
                    AND ut.PYRLRTYP = 2
                    AND ded.SHFRSTTX = 1
                    AND ut.CHEKDATE BETWEEN '1/1/2024' AND '3/31/2024'
                GROUP BY ut.EMPLOYID
        ) deds ON deds.EMPLOYID = e.EMPLOYID

 


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
LPCHKNUM char(21)
''
Last Paych...(more) Join Now
LSTPCKDT datetime
'1/1/1900'
Last Paych...(more) Join Now
LPCHKAMT numeric(19,5)
0.00
Last Paych...(more) Join Now
GROSWAGS_1 numeric(19,5)
0.00
Gross Wage...(more) Join Now
GROSWAGS_2 numeric(19,5)
0.00

GROSWAGS_3 numeric(19,5)
0.00

GROSWAGS_4 numeric(19,5)
0.00

GROSWAGS_5 numeric(19,5)
0.00

GROSWAGS_6 numeric(19,5)
0.00

GROSWAGS_7 numeric(19,5)
0.00

GROSWAGS_8 numeric(19,5)
0.00

GROSWAGS_9 numeric(19,5)
0.00

GROSWAGS_10 numeric(19,5)
0.00

GROSWAGS_11 numeric(19,5)
0.00

GROSWAGS_12 numeric(19,5)
0.00

FDWTHLDG_1 numeric(19,5)
0.00
Federal Wi...(more) Join Now
FDWTHLDG_2 numeric(19,5)
0.00

FDWTHLDG_3 numeric(19,5)
0.00

FDWTHLDG_4 numeric(19,5)
0.00

FDWTHLDG_5 numeric(19,5)
0.00

FDWTHLDG_6 numeric(19,5)
0.00

FDWTHLDG_7 numeric(19,5)
0.00

FDWTHLDG_8 numeric(19,5)
0.00

FDWTHLDG_9 numeric(19,5)
0.00

FDWTHLDG_10 numeric(19,5)
0.00

FDWTHLDG_11 numeric(19,5)
0.00

FDWTHLDG_12 numeric(19,5)
0.00

FICASSWG_1 numeric(19,5)
0.00
FICA/Socia...(more) Join Now
FICASSWG_2 numeric(19,5)
0.00

FICASSWG_3 numeric(19,5)
0.00

FICASSWG_4 numeric(19,5)
0.00

FICASSWG_5 numeric(19,5)
0.00

FICASSWG_6 numeric(19,5)
0.00

FICASSWG_7 numeric(19,5)
0.00

FICASSWG_8 numeric(19,5)
0.00

FICASSWG_9 numeric(19,5)
0.00

FICASSWG_10 numeric(19,5)
0.00

FICASSWG_11 numeric(19,5)
0.00

FICASSWG_12 numeric(19,5)
0.00

FICAMWGS_1 numeric(19,5)
0.00
FICA/Medic...(more) Join Now
FICAMWGS_2 numeric(19,5)
0.00

FICAMWGS_3 numeric(19,5)
0.00

FICAMWGS_4 numeric(19,5)
0.00

FICAMWGS_5 numeric(19,5)
0.00

FICAMWGS_6 numeric(19,5)
0.00

FICAMWGS_7 numeric(19,5)
0.00

FICAMWGS_8 numeric(19,5)
0.00

FICAMWGS_9 numeric(19,5)
0.00

FICAMWGS_10 numeric(19,5)
0.00

FICAMWGS_11 numeric(19,5)
0.00

FICAMWGS_12 numeric(19,5)
0.00

FICASSWH_1 numeric(19,5)
0.00
FICA/Socia...(more) Join Now
FICASSWH_2 numeric(19,5)
0.00

FICASSWH_3 numeric(19,5)
0.00

FICASSWH_4 numeric(19,5)
0.00

FICASSWH_5 numeric(19,5)
0.00

FICASSWH_6 numeric(19,5)
0.00

FICASSWH_7 numeric(19,5)
0.00

FICASSWH_8 numeric(19,5)
0.00

FICASSWH_9 numeric(19,5)
0.00

FICASSWH_10 numeric(19,5)
0.00

FICASSWH_11 numeric(19,5)
0.00

FICASSWH_12 numeric(19,5)
0.00

FICAMWDG_1 numeric(19,5)
0.00
FICA/Medic...(more) Join Now
FICAMWDG_2 numeric(19,5)
0.00

FICAMWDG_3 numeric(19,5)
0.00

FICAMWDG_4 numeric(19,5)
0.00

FICAMWDG_5 numeric(19,5)
0.00

FICAMWDG_6 numeric(19,5)
0.00

FICAMWDG_7 numeric(19,5)
0.00

FICAMWDG_8 numeric(19,5)
0.00

FICAMWDG_9 numeric(19,5)
0.00

FICAMWDG_10 numeric(19,5)
0.00

FICAMWDG_11 numeric(19,5)
0.00

FICAMWDG_12 numeric(19,5)
0.00

SUTAWAGS_1 numeric(19,5)
0.00
SUTA Wages...(more) Join Now
SUTAWAGS_2 numeric(19,5)
0.00

SUTAWAGS_3 numeric(19,5)
0.00

SUTAWAGS_4 numeric(19,5)
0.00

SUTAWAGS_5 numeric(19,5)
0.00

SUTAWAGS_6 numeric(19,5)
0.00

SUTAWAGS_7 numeric(19,5)
0.00

SUTAWAGS_8 numeric(19,5)
0.00

SUTAWAGS_9 numeric(19,5)
0.00

SUTAWAGS_10 numeric(19,5)
0.00

SUTAWAGS_11 numeric(19,5)
0.00

SUTAWAGS_12 numeric(19,5)
0.00

FUTAWAGS_1 numeric(19,5)
0.00
FUTA Wages...(more) Join Now
FUTAWAGS_2 numeric(19,5)
0.00

FUTAWAGS_3 numeric(19,5)
0.00

FUTAWAGS_4 numeric(19,5)
0.00

FUTAWAGS_5 numeric(19,5)
0.00

FUTAWAGS_6 numeric(19,5)
0.00

FUTAWAGS_7 numeric(19,5)
0.00

FUTAWAGS_8 numeric(19,5)
0.00

FUTAWAGS_9 numeric(19,5)
0.00

FUTAWAGS_10 numeric(19,5)
0.00

FUTAWAGS_11 numeric(19,5)
0.00

FUTAWAGS_12 numeric(19,5)
0.00

NETWAGES_1 numeric(19,5)
0.00
Net Wages:...(more) Join Now
NETWAGES_2 numeric(19,5)
0.00

NETWAGES_3 numeric(19,5)
0.00

NETWAGES_4 numeric(19,5)
0.00

NETWAGES_5 numeric(19,5)
0.00

NETWAGES_6 numeric(19,5)
0.00

NETWAGES_7 numeric(19,5)
0.00

NETWAGES_8 numeric(19,5)
0.00

NETWAGES_9 numeric(19,5)
0.00

NETWAGES_10 numeric(19,5)
0.00

NETWAGES_11 numeric(19,5)
0.00

NETWAGES_12 numeric(19,5)
0.00

YEAR1 smallint
0
Year: The ...(more) Join Now
Federal_Wages_1 numeric(19,5)
0.00
Federal Wa...(more) Join Now
Federal_Wages_2 numeric(19,5)
0.00

Federal_Wages_3 numeric(19,5)
0.00

Federal_Wages_4 numeric(19,5)
0.00

Federal_Wages_5 numeric(19,5)
0.00

Federal_Wages_6 numeric(19,5)
0.00

Federal_Wages_7 numeric(19,5)
0.00

Federal_Wages_8 numeric(19,5)
0.00

Federal_Wages_9 numeric(19,5)
0.00

Federal_Wages_10 numeric(19,5)
0.00

Federal_Wages_11 numeric(19,5)
0.00

Federal_Wages_12 numeric(19,5)
0.00

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