| RotoID | Tables | Title | DLL | Compositions |
|---|---|---|---|---|
| UP0001 | Payroll Activation | UPACTV | ||
| UP0006 | UPCLAS | Class Codes | UPCLAS | |
| UP0007 | UPDTLM | Earnings/Deductions | UPDTLM | UP0015, UP0015, UP0015, UP0015, UP0015, UP0009, UP0123, UP0040 |
| UP0008 | UPEMPD | Employee Earnings/Deductions | UPEMPD | UP0014, UP0125, UP0041 |
| UP0009 | UPDIST | Distribution | UPDIST | UP0029, UP0007 |
| UP0010 | UPEMPT | Employee Taxes | UPEMPT | UP0014, UP0062, UP0126 |
| UP0012 | UPHSTH | Employee History Control | UPHSTH | UP0013 |
| UP0013 | UPHSHO | Employee History Optional Field Values | UPHSHO | UP0012 |
| UP0014 | UPEMPL | Employees | UPEMPL | UP0008, UP0010, UP0053, UP0201, UP0122 |
| UP0015 | UPINCL | Include List | UPINCL | UP0007, UP0029 |
| UP0016 | US Payroll Integrity Checker | UPDCHK | ||
| UP0017 | UPSTAT | Status | UPSTAT | |
| UP0018 | Delete Inactive Records | UPMAIN | ||
| UP0019 | UPMCHD | Manual Check Header | UPMCHD | UP0020, UP0129 |
| UP0020 | UPMCDT | Manual Check Detail | UPMCDT | UP0019, UP0130, UP0043 |
| UP0021 | UPHHAU | History Audit Headers | UPHHAU | UP0024, UP0135 |
| UP0022 | UPOTSC | Overtime Schedules | UPOTSC | |
| UP0023 | UPOPTS | Company Options | UPOPTS | |
| UP0024 | UPHDAU | History Audit Details | UPHDAU | UP0021, UP0136 |
| UP0025 | UPSHFT | Shift Differential Schedule | UPSHFT | UP0038 |
| UP0026 | Concurrency controller | UPCTRL | ||
| UP0027 | UPWRKC | Work Classification Codes | UPWRKC | |
| UP0029 | UPTXMS | Company Payroll Taxes | UPTXMS | UP0015, UP0015, UP0015, UP0009, UP0124 |
| UP0031 | UPTCHD | Timecard Header | UPTCHD | UP0032, UP0127 |
| UP0032 | UPTCDT | Timecard Detail | UPTCDT | UP0031, UP0128, UP0042 |
| UP0036 | UPWCCH | Workers Compensation Master | UPWCCH | UP0037 |
| UP0037 | UPWCCD | Workers Compensation Codes | UPWCCD | UP0036 |
| UP0038 | UPSHFD | Shift Differential Detail | UPSHFD | UP0025, UP0039 |
| UP0039 | UPSHFB | Shift Differential Billing Detail | UPSHFB | UP0038 |
| UP0040 | UPDTLB | Earnings Billing Detail | UPDTLB | UP0007 |
| UP0041 | UPEMDB | Employee Billing Details | UPEMDB | UP0008 |
| UP0042 | UPTCJB | Timecard Job Details | UPTCJB | UP0032, UP0141 |
| UP0043 | UPMCJB | Manual Check Job Details | UPMCJB | UP0020, UP0142 |
| UP0044 | UPUTJB | Employee Timecard Job Details | UPUTJB | UP0103, UP0143 |
| UP0045 | UPESLH | Employee Selection Lists | UPESLH | UP0046 |
| UP0046 | UPESLD | Employee Selection List Members | UPESLD | UP0045 |
| UP0047 | UPYTDS | Employee YTD Summaries | UPYTDS | |
| UP0048 | UPCHKH | Check Header | UPCHKH | UP0049, UP0052, UP0202, UP0133, UP0134 |
| UP0049 | UPCHKD | Check Details | UPCHKD | UP0048, UP0134, UP0056 |
| UP0050 | Payroll Posting Superview | UPPOST | ||
| UP0051 | UPGLBM | Globally Modify List | UPGLBM | |
| UP0052 | UPCHKC | Check Comment Detail | UPCHKC | UP0048 |
| UP0053 | UPEMPC | Employee Notes | UPEMPC | UP0014 |
| UP0056 | UPCHJB | Check Job Details | UPCHJB | UP0049, UP0144 |
| UP0057 | UPGLREF | G/L Reference Integration | UPGLREF | |
| UP0058 | Globally Modify Process | UPGMET | UP0008, UP0041 | |
| UP0059 | G/L Acct Desc Report Extraction | UPGLDX | ||
| UP0060 | UPGLDD | G/L Acct Desc Report List | UPGLDD | |
| UP0062 | UPEMTF | Employee Tax Fields | UPEMTF | UP0010 |
| UP0064 | UPXCPT | Calc PR Exceptions | UPXCPT | |
| UP0065 | Process Manual Checks | UPPMAN | UP0138 | |
| UP0077 | UPCHKS | Check History Summary | UPCHKS | |
| UP0078 | Print Checks Control | UPPCKS | ||
| UP0079 | UPPCKH | Print Checks Header Extension | UPPCKH | UP0080 |
| UP0080 | UPPCKD | Print Checks Detail Extension | UPPCKD | UP0079 |
| UP0081 | Earnings Hours Report | UPERHR | ||
| UP0082 | Check Reconciliation | UPCREC | ||
| UP0083 | Calculate Payroll | UPCALC | UP0137 | |
| UP0084 | UPCALE | E/D/T List | UPCALE | |
| UP0085 | UPCALT | Timecard List | UPCALT | |
| UP0086 | UPCALA | Cost Center Allocations | UPCALA | |
| UP0087 | UPCALO | Timecard Earnings List | UPCALO | |
| UP0088 | UPCHKR | Check Run Header | UPCHKR | UP0139 |
| UP0089 | UPPCKF | Print Checks Trans. | UPPCKF | |
| UP0093 | UPEHRP | Earnings Hourly Report | UPEHRP | |
| UP0094 | Payroll Register G/L Accounts | UPPREG | ||
| UP0097 | PRRSTRT | Restart | PRRSTRT | |
| UP0099 | UPDTLX | Earnings/Deductions (virtual) | UPDTLX | |
| UP0100 | UPTXMC | Temporary Tax List | UPTXMC | |
| UP0101 | Empl Timecards Transfer Ctrl | UPUTTR | ||
| UP0102 | UPUTCH | Employee Timecard Header | UPUTCH | UP0103, UP0131 |
| UP0103 | UPUTCD | Employee Timecard Detail | UPUTCD | UP0102, UP0132, UP0044 |
| UP0104 | Employee Activity | UPEMAC | ||
| UP0105 | Find Duplicate SSN | UPESIN | ||
| UP0106 | UPEDUP | Duplicate SSN | UPEDUP | |
| UP0107 | Create G/L Batch | UPGLTR | ||
| UP0108 | Copy Timecard | UPTCCP | ||
| UP0109 | Employee Sel Lists Superview | UPESLC | UP0045, UP0046 | |
| UP0110 | UPINCX | Include List (virtual) | UPINCX | |
| UP0111 | G/L Drill Down | UPDLDN | ||
| UP0112 | Check Selection Superview | UPCHKX | ||
| UP0113 | UPCHKL | Check Selection List | UPCHKL | |
| UP0115 | UPACCO | Accrual Carry-over Log File | UPACCO | |
| UP0120 | UPOFH | Optional Field Locations | UPOFH | UP0121 |
| UP0121 | UPOFD | Optional Field Values | UPOFD | UP0120 |
| UP0122 | UPEMPO | Employee Optional Field Values | UPEMPO | UP0014 |
| UP0123 | UPDTLO | Earnings/Deductions Opt Fields | UPDTLO | UP0007 |
| UP0124 | UPTXMO | Taxes Optional Field Values | UPTXMO | UP0029 |
| UP0125 | UPEMDO | Empl Earn/Ded Optional Fields | UPEMDO | UP0008 |
| UP0126 | UPEMTO | Empl Taxes Optional Fields | UPEMTO | UP0010 |
| UP0127 | UPTCHO | Timecard Optional Field Values | UPTCHO | UP0031 |
| UP0128 | UPTCDO | Timecard Details Optional Field Values | UPTCDO | UP0032 |
| UP0129 | UPMCHO | Manual Check Optional Field Values | UPMCHO | UP0019 |
| UP0130 | UPMCDO | MC Details Opt Field Values | UPMCDO | UP0020 |
| UP0131 | UPUTHO | Empl Timecard Optional Fields | UPUTHO | UP0102 |
| UP0132 | UPUTDO | Empl Timecard Details Opt Flds | UPUTDO | UP0103 |
| UP0133 | UPCHHO | Check Header Optional Field Values | UPCHHO | UP0048 |
| UP0134 | UPCHDO | Check Details Optional Fields | UPCHDO | UP0049 |
| UP0135 | UPHHOA | History Audit Header Opt Fields | UPHHOA | UP0021 |
| UP0136 | UPHDOA | History Audit Detail Opt Fields | UPHDOA | UP0024 |
| UP0137 | UPCLCO | Calculate Payroll Optional Fields | UPCLCO | UP0083 |
| UP0138 | UPPMCO | Process Manual Check Optional Fields | UPPMCO | UP0065 |
| UP0139 | UPCHKO | Check Run Optional Field Values | UPCHKO | UP0088 |
| UP0140 | PR Optional Field Callbacks | UPOFCMD | ||
| UP0141 | UPTCJO | Timecard Jobs Optional Field Values | UPTCJO | UP0042 |
| UP0142 | UPMCJO | Manual Check Jobs Opt Fields | UPMCJO | UP0043 |
| UP0143 | UPUTJO | Employee TC Jobs Opt Field Values | UPUTJO | UP0044 |
| UP0144 | UPCHJO | Check Jobs Optional Fields Values | UPCHJO | UP0056 |
| UP0200 | UPCOBK | Company EFT Banks | UPCOBK | |
| UP0201 | UPEMBK | Employee EFT Banks | UPEMBK | UP0014 |
| UP0202 | UPCHKE | Check EFT Details | UPCHKE | UP0048 |
| UP0203 | EFT Run Superview | UPERUN | ||
| UP0204 | UPEREG | EFT Run History Header | UPEREG | UP0205 |
| UP0205 | UPETRN | EFT Run History Details | UPETRN | UP0204 |
| UP0206 | UPEMULH | EFT Combine File Header | UPEMULH | UP0207 |
| UP0207 | UPEMULD | EFT Combine File Detail | UPEMULD | UP0206 |
| UP0208 | UPELST | EFT Combine File List | UPELST | |
| UP0209 | UPEMRGH | EFT Files Combine Setup Header | UPEMRGH | UP0210 |
| UP0210 | UPEMRGD | EFT Files Combine Setup Detail | UPEMRGD | UP0209 |
| UP0211 | EFT Combine Superview | UPECOMB | UP0208 | |
| UP0220 | UPAUDM | Delete Inactive Records Audit | UPAUDM | UP0221, UP0222 |
| UP0221 | UPAUDMI | Delete Audit Inactive Details | UPAUDMI | UP0220 |
| UP0222 | UPAUDMH | Delete Audit Transaction Details | UPAUDMH | UP0220 |
| UP0223 | UPAUDE | Update Earn/Ded Audit | UPAUDE | UP0224 |
| UP0224 | UPAUDED | Update Earn/Ded Audit Details | UPAUDED | UP0223 |
| UP0225 | UPAUDT | Update Taxes Audit | UPAUDT | UP0226 |
| UP0226 | UPAUDTD | Update Taxes Audit Details | UPAUDTD | UP0225 |
| UP0227 | UPAUDA | Assign Earn/Ded Audit | UPAUDA | UP0228 |
| UP0228 | UPAUDAD | Assign Earn/Ded Audit Details | UPAUDAD | UP0227, UP0229 |
| UP0229 | UPAUDAB | Assign Earn/Ded Audit Billing | UPAUDAB | UP0228 |
| Table | RotoID | Title |
|---|---|---|
| UPACCO | UP0115 | Accrual Carry-over Log File |
| UPAUDA | UP0227 | Assign Earn/Ded Audit |
| UPAUDAB | UP0229 | Assign Earn/Ded Audit Billing |
| UPAUDAD | UP0228 | Assign Earn/Ded Audit Details |
| UPAUDE | UP0223 | Update Earn/Ded Audit |
| UPAUDED | UP0224 | Update Earn/Ded Audit Details |
| UPAUDM | UP0220 | Delete Inactive Records Audit |
| UPAUDMH | UP0222 | Delete Audit Transaction Details |
| UPAUDMI | UP0221 | Delete Audit Inactive Details |
| UPAUDT | UP0225 | Update Taxes Audit |
| UPAUDTD | UP0226 | Update Taxes Audit Details |
| UPCALA | UP0086 | Cost Center Allocations |
| UPCHDO | UP0134 | Check Details Optional Fields |
| UPCHHO | UP0133 | Check Header Optional Field Values |
| UPCHJB | UP0056 | Check Job Details |
| UPCHJO | UP0144 | Check Jobs Optional Fields Values |
| UPCHKC | UP0052 | Check Comment Detail |
| UPCHKD | UP0049 | Check Details |
| UPCHKE | UP0202 | Check EFT Details |
| UPCHKH | UP0048 | Check Header |
| UPCHKL | UP0113 | Check Selection List |
| UPCHKO | UP0139 | Check Run Optional Field Values |
| UPCHKR | UP0088 | Check Run Header |
| UPCHKS | UP0077 | Check History Summary |
| UPCLAS | UP0006 | Class Codes |
| UPCLCO | UP0137 | Calculate Payroll Optional Fields |
| UPCOBK | UP0200 | Company EFT Banks |
| UPDIST | UP0009 | Distribution |
| UPDTLB | UP0040 | Earnings Billing Detail |
| UPDTLM | UP0007 | Earnings/Deductions |
| UPDTLO | UP0123 | Earnings/Deductions Opt Fields |
| UPEDUP | UP0106 | Duplicate SSN |
| UPEHRP | UP0093 | Earnings Hourly Report |
| UPELST | UP0208 | EFT Combine File List |
| UPEMBK | UP0201 | Employee EFT Banks |
| UPEMDB | UP0041 | Employee Billing Details |
| UPEMDO | UP0125 | Empl Earn/Ded Optional Fields |
| UPEMPC | UP0053 | Employee Notes |
| UPEMPD | UP0008 | Employee Earnings/Deductions |
| UPEMPL | UP0014 | Employees |
| UPEMPO | UP0122 | Employee Optional Field Values |
| UPEMPT | UP0010 | Employee Taxes |
| UPEMRGD | UP0210 | EFT Files Combine Setup Detail |
| UPEMRGH | UP0209 | EFT Files Combine Setup Header |
| UPEMTF | UP0062 | Employee Tax Fields |
| UPEMTO | UP0126 | Empl Taxes Optional Fields |
| UPEMULD | UP0207 | EFT Combine File Detail |
| UPEMULH | UP0206 | EFT Combine File Header |
| UPEREG | UP0204 | EFT Run History Header |
| UPESLD | UP0046 | Employee Selection List Members |
| UPESLH | UP0045 | Employee Selection Lists |
| UPETRN | UP0205 | EFT Run History Details |
| UPGLBM | UP0051 | Globally Modify List |
| UPGLDD | UP0060 | G/L Acct Desc Report List |
| UPGLREF | UP0057 | G/L Reference Integration |
| UPHDAU | UP0024 | History Audit Details |
| UPHDOA | UP0136 | History Audit Detail Opt Fields |
| UPHHAU | UP0021 | History Audit Headers |
| UPHHOA | UP0135 | History Audit Header Opt Fields |
| UPINCL | UP0015 | Include List |
| UPMCDO | UP0130 | MC Details Opt Field Values |
| UPMCDT | UP0020 | Manual Check Detail |
| UPMCHD | UP0019 | Manual Check Header |
| UPMCHO | UP0129 | Manual Check Optional Field Values |
| UPMCJB | UP0043 | Manual Check Job Details |
| UPMCJO | UP0142 | Manual Check Jobs Opt Fields |
| UPOFD | UP0121 | Optional Field Values |
| UPOFH | UP0120 | Optional Field Locations |
| UPOPTS | UP0023 | Company Options |
| UPOTSC | UP0022 | Overtime Schedules |
| UPPCKD | UP0080 | Print Checks Detail Extension |
| UPPCKH | UP0079 | Print Checks Header Extension |
| UPPMCO | UP0138 | Process Manual Check Optional Fields |
| UPSHFB | UP0039 | Shift Differential Billing Detail |
| UPSHFD | UP0038 | Shift Differential Detail |
| UPSHFT | UP0025 | Shift Differential Schedule |
| UPSTAT | UP0017 | Status |
| UPTCDO | UP0128 | Timecard Details Optional Field Values |
| UPTCDT | UP0032 | Timecard Detail |
| UPTCHD | UP0031 | Timecard Header |
| UPTCHO | UP0127 | Timecard Optional Field Values |
| UPTCJB | UP0042 | Timecard Job Details |
| UPTCJO | UP0141 | Timecard Jobs Optional Field Values |
| UPTXMO | UP0124 | Taxes Optional Field Values |
| UPTXMS | UP0029 | Company Payroll Taxes |
| UPUSLD | ||
| UPUSLH | ||
| UPUTCD | UP0103 | Employee Timecard Detail |
| UPUTCH | UP0102 | Employee Timecard Header |
| UPUTDO | UP0132 | Empl Timecard Details Opt Flds |
| UPUTHO | UP0131 | Empl Timecard Optional Fields |
| UPUTJB | UP0044 | Employee Timecard Job Details |
| UPUTJO | UP0143 | Employee TC Jobs Opt Field Values |
| UPWCCD | UP0037 | Workers Compensation Codes |
| UPWCCH | UP0036 | Workers Compensation Master |
| UPWRKC | UP0027 | Work Classification Codes |
| UPXCPT | UP0064 | Calc PR Exceptions |
| UPYTDS | UP0047 | Employee YTD Summaries |
This page was generated on 2009-Nov-19
Copyright © 2001–2009 Sage Software, Inc. All rights reserved.