| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F06106 | Employee Pay Instructions | 11 | YM | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
2 | F069106 | Union Benefits Master | 12 | Y1 | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
3 | F069116 | Payroll Transaction Constants | 10 | YC | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
TOP07: Payroll |
4 | F07107 | Employee Wage Attachment Rules | 56 | JW | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
5 | F071072 | Employee Level Multi Child Support Overrides | 4 | JX | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
6 | F071073 | Employee Level Multi Wage Attachment Rules | 6 | J3 | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
7 | F071074 | Wage Attachment Exemption Rules | 6 | WE | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
8 | F0729 | Employee DBA Override Instructions | 13 | Y9 | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
9 | F051371 | ADP Employee DBA Instructions | 16 | AD | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
10 | F051375 | ADP Payroll DBA Transaction Constants | 12 | AD | DESQ | Source of Calculation | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 06 / DB (Source of Calculation Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | 0 | Wage Attachment Fees | | Y |
2 | 1 | Gross-(Taxes+All Ded) | | |
3 | 2 | Gross-(Taxes+Mand Ded) | | |
4 | 3 | Gross-(Taxes) | | Y |
5 | 4 | Gross-(Taxes+Tips+Mand Ded) | | Y |
6 | 5 | Gross-(Taxes+Tips+All Ded) | | Y |
7 | 6 | Gross-(Taxes+Tip Cr+Mand Ded) | | Y |
8 | 7 | Gross-(Taxes+Tip Cr+All Ded) | | Y |
9 | 8 | RESERVED FOR GLW CALCULATIONS | | |
10 | 9 | RPP-CPP | | |
11 | B | Basis of Calc - Taxes | | Y |
12 | C | Current Month - based on Trans | | |
13 | F | Fiscal Period History | | |
14 | G | Current Period | | |
15 | I | Inception-to-Date | | |
16 | L | Prior Year | | |
17 | M | Month-to-Date | | |
18 | P | Prior Month | | |
19 | R | Remaining Balance | | Y |
20 | T | Table Periods | | |
21 | Y | Year-to-Date | | |