|
| | DD00100 | Direct Deposit Employee Master |
|
Direct Deposit Employee Master
|
| | DD00200 | Direct Deposit Employee Account Master |
|
|
 | UPR00100 | Payroll Master |
|
Employee Master table, one record per employee
|
| | UPR00102 | Payroll Address Master |
|
|
| | UPR00111 | Payroll Master Dependent |
|
|
| | UPR00112 | Payroll Master Education |
|
|
| | UPR00113 | Payroll Master Contacts |
|
|
| | UPR00200 | uprMstrTimeonBehalf |
|
|
| | UPR00201 | uprMstrTimeonBehalfDept |
|
|
| | UPR00202 | uprMstrTimeonBehalfClass |
|
|
| | UPR00203 | uprMstrTimeonBehalfEmp |
|
|
| | UPR00210 | uprMstrTCAssignment |
|
|
| | UPR00211 | uprMstrTCAssignmentDetail |
|
|
| | UPR00220 | uprTimecardTemplateTrx |
|
|
| | UPR00221 | uprTimecardTemplateTrxDtl |
|
|
| | UPR00222 | uprTimecardTemplateStartStop |
|
|
| | UPR00300 | Payroll Tax Information Master |
|
|
| UPR00400 | Payroll Pay Code Master |
|
|
| | UPR00402 | Payroll Post Dated Pay Code Master |
|
|
| | UPR00500 | Payroll Deduction Master |
|
|
| | UPR00501 | Payroll Deduction Based On Master |
|
This file holds the 'Based On’ fields for a deduction of the 'Based On Records' field =1 in the Payroll Deductions Master file. If the deduction 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 not available. All deductions in SBM are based on pay codes.
|
| | UPR00502 | Payroll Deduction Sequence Master |
|
|
| | UPR00600 | Payroll Benefit Master |
|
Contains the information on employee benefits.
|
| | UPR00601 | 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.
|
| | UPR00700 | Payroll State Tax Master |
|
This file contains State Tax information on each employee. There could be multiple records for the employee in this file if the employee changed addresses.
|
| | UPR00800 | Payroll Local Tax Master |
|
Contains information about withholding local taxes.
|
| | UPR00900 | 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
|
| | UPR00901 | Payroll Employee Tips Summary |
|
Can view tips wage and receipt information, tax withheld on tips wages, and any uncollected tax amounts on tips wages. The data within this table is automatically updated when checks are posted.
|
| | UPR00902 | Payroll Employee Fiscal Summary |
|
|
| | UPR00903 | Payroll Employee Tips Fiscal Summary |
|
|
| | UPR00904 | Payroll Master Dependent ACA |
|
|
| | UPR00905 | Payroll Master Employee ACA |
|
|
|
|
|
| | DD10100 | Direct Deposit Employee Deposits Work |
|
|
| | DD10200 | Direct Deposit ACH Copy |
|
|
| | DD10300 | Direct Deposit ACH Cross Reference |
|
|
| | DD10400 | Direct Deposit ACH Header |
|
|
| | DD10500 | Direct Deposit ACH Items |
|
|
| | DD10600 | Direct Deposit Prenotes Completed |
|
|
| | DD10700 | Direct Deposit Exceptions |
|
|
| | DD20100 | ESS Direct Deposit Employee Work |
|
|
| | DD20101 | ESS Direct Deposit Employee Account Work |
|
|
| | UPR10100 | Payroll Year End Header |
|
|
| | UPR10101 | Payroll Year End Wage |
|
|
| | UPR10103 | Payroll Year End Pension |
|
|
| | UPR10104 | Payroll Year End Special |
|
|
| | UPR10105 | Payroll Year End State |
|
|
| | UPR10106 | Payroll Year End Local |
|
|
| | UPR10107 | Payroll Year End Other |
|
|
| | UPR10108 | Payroll Year End Dependent ACA History |
|
|
| | UPR10109 | Payroll Year End Dependent ACA |
uprYearEndDependentACA
|
| | UPR10200 | Payroll Work Master |
|
|
| | UPR10201 | Payroll Work Master Detail |
|
|
| | UPR10202 | Payroll Work Header |
|
|
| | UPR10203 | Payroll Work Pay Code |
|
|
| | UPR10204 | Payroll Work Deduction |
|
|
| | UPR10205 | Payroll Work Benefit |
|
|
| | UPR10206 | Payroll Work State Tax |
|
|
| | UPR10207 | Payroll Work Local Tax |
|
|
| | UPR10208 | Payroll Work Check |
|
|
| | UPR10209 | Payroll Work Post |
|
|
| | UPR10210 | Payroll Build Check Defaults |
|
|
| | UPR10211 | Payroll Build Check File Defaults Detail |
|
|
| | UPR10212 | Payroll Temp Report Destination |
|
|
| | UPR10213 | Payroll Check Descriptions |
|
|
| | UPR10214 | Payroll Work Check YTD Amounts |
|
|
| | UPR10215 | Payroll Work Void Check Reasons |
|
|
| | UPR10216 | Payroll Duplicate Checks |
|
|
| | UPR10301 | Payroll Batches |
|
|
| | UPR10302 | Payroll Transactions |
|
|
| | UPR10303 | Payroll Transaction Audit |
|
|
| | UPR10307 | Payroll Manual Check |
|
|
| | UPR10308 | Payroll Manual Check Detail |
|
|
| | UPR10309 | Payroll Keys Master |
|
|
| | UPR10310 | Payroll Manual Check Distributions |
|
|
| | UPR10400 | Payroll Distribution Work |
|
|
| | UPR10500 | uprTimecardHdr |
|
|
| | UPR10501 | uprTimecardDtl |
|
|
| | UPR10502 | uprTimecardStartStopDtl |
|
|
| | UPR19900 | Payroll Flat Tax Records |
|
|
| | UPR19901 | Payroll Account Cache |
|
|
|
|
| | DD30100 | Direct Deposit Transaction History Header |
|
|
| | DD30101 | Direct Deposit Transaction History Detail |
|
|
| UPR30100 | Payroll Check History |
|
|
| | UPR30200 | Payroll Tax Liability |
|
|
| UPR30300 | Payroll Transaction History |
|
|
| | UPR30301 | Payroll Transaction History Header |
|
|
| | UPR30400 | Payroll Distribution History Header |
|
|
| | UPR30401 | Payroll Distribution History Detail |
|
|
| | UPR30500 | uprTmcdHdrHIST |
|
|
| | UPR30501 | uprTmcdDtlHIST |
|
|
| | UPR30502 | uprTmcdStartStopHIST |
|
|
| | UPR30600 | ESS Profile |
|
|
| | UPR30601 | ESS Profile Personal |
|
|
| | UPR30602 | ESS Profile Contacts |
|
|
| | UPR30603 | ESS Profile Dependents |
|
|
| | UPR30604 | Payroll ESS W4 History |
|
|
|
| |
| | DD40100 | Direct Deposit Setup |
|
|
| | DD40200 | Direct Deposit Check Messages Setup |
|
|
| | DD40400 | Direct Deposit ACH Header Setup |
|
|
| | DD40500 | Direct Deposit ACH Prenotes Setup |
|
|
| | DD40600 | Direct Deposit Deduction Link Setup |
|
|
| | DD40700 | MUPR_DDNextIdx |
|
|
| | UPR40100 | Payroll Unemployment Setup |
|
|
| | UPR40101 | Payroll Unemployment TSA |
|
|
| | UPR40104 | MUPR_Setup |
|
|
| | UPR40105 | UPR 1095 Setup File |
|
|
| | UPR40200 | Payroll Setup |
|
|
| | UPR40201 | Payroll Auto Assign Employee ID |
|
|
| | UPR40202 | UPR_SETP_Timecard_Options |
|
|
| | UPR40300 | Payroll Department Setup |
|
|
| | UPR40301 | Payroll Position Setup |
|
|
| | UPR40500 | Payroll Accounts Setup |
|
This file contains payroll posting account information for a company. Default values are created during install and when data is cleared from the file. Defaults exist for:
Federal Tax Withholding:
EFIC/M Employee FICA Medicare Tax
EFIC/S Employee FICA Social Security Tax
FED Federal Tax Withholding
FICA/M FICA Medicare Tax Withholding
FICA/S FICA Social Security Tax Withholding
Employer’s Tax Expense:
FIC/ME FICA Medicare Tax Expense
FIC/SE FICA Social Security Tax Expense.
|
| | UPR40501 | Payroll Tax Expense/Withholding Setup |
|
|
| | UPR40600 | Payroll Pay Code Setup |
|
|
| | UPR40700 | Payroll Workers Comp Setup |
|
|
| | UPR40800 | Payroll Benefit Setup |
|
|
| | UPR40801 | Payroll Benefit Based On Setup |
|
|
| | UPR40900 | Payroll Deduction Setup |
|
|
| | UPR40901 | Payroll Deduction Based On Setup |
|
|
| | UPR40902 | Payroll Deduction Sequence Setup |
|
|
| | UPR41100 | Payroll State Code Setup |
|
|
| | UPR41200 | Payroll Class Setup |
|
|
| | UPR41201 | Payroll Class Detail Setup |
|
|
| | UPR41400 | Payroll Local Tax Setup |
|
|
| | UPR41401 | Payroll Local Tax Table Setup |
|
|
| | UPR41500 | Payroll Shift Code Setup |
|
|
| | UPR41700 | Payroll Setup Supervisor |
|
|
| | UPR41800 | Payroll Maximum Deduction Setup |
|
|
| | UPR41801 | Payroll State / Fed Setup |
|
|
| | UPR41900 | Payroll Earnings Setup |
|
|
| | UPR41901 | Payroll Earnings Paycodes |
|
|
| | UPR41902 | Payroll Earnings Deductions |
|
|
| | UPR42000 | Payroll Secondary Status Setup |
|
|
| | UPR42100 | uprSetupPayScheduleHdr |
|
|
| | UPR42101 | uprSetupPayScheduleDtl |
|
|
| | UPR42102 | uprSetupPayScheduleLocation |
|
|
| | UPR42103 | uprSetupPayScheduleDept |
|
|
| | UPR42104 | uprSetupPaySchedulePosition |
|
|
| | UPR42105 | uprSetupPayScheduleClass |
|
|
| | UPR42106 | uprSetupPayScheduleEmployee |
|
|
| | UPR42110 | uprSetupScheduleSequence |
|
|
| | UPR42200 | uprSetupTimeonBehalf |
|
|
| | UPR42201 | uprSetupTimeonBehalfDept |
|
|
| | UPR42202 | uprSetupTimeonBehalfClass |
|
|
| | UPR42203 | uprSetupTimeonBehalfEmp |
|
|
| | UPR42300 | uprSetupTCAssignment |
|
|
| | UPR42301 | uprSetupTCAssignmentDetail |
|
|
| | UPR42400 | uprSetupTimeCardRestrictions |
|
|
| | UPR42401 | uprSetupTimeCardRestrictionsDTL |
|
|
| | UPR42402 | uprSetupTimeCardRestrictionsLocation |
|
|
| | UPR42403 | uprSetupTimeCardRestrictionsDept |
|
|
| | UPR42404 | uprSetupTimeCardRestrictionsPosition |
|
|
| | UPR42405 | uprSetupTimeCardRestrictionsClass |
|
|
| | UPR42406 | uprSetupTimeCardRestrictionsEmployee |
|
|
| | UPR42500 | uprSetupBatchPrefix |
|
|
| | UPR42501 | uprSetupBatchPrefixLocation |
|
|
| | UPR42502 | uprSetupBatchPrefixDept |
|
|
| | UPR42503 | uprSetupBatchPrefixPosition |
|
|
| | UPR42504 | uprSetupBatchPrefixClass |
|
|
| | UPR42505 | uprSetupBatchPrefixEmployee |
|
|
| | UPR70500 | Payroll Report Options |
|
|
| | UPR70501 | Payroll Cross Company Report Options |
|
|
|