Data, Academic Planning & Institutional Research

UA PAYROLL DED MISC

DATA VIEW NAME
UA_PAYROLL_DED_MISC
OVERVIEW
This view displays payroll deduction records for miscellaneous
deductions generated during a payroll period not covered by views
below. The views contain classified, unclassified and student personnel.
Related views that deal with deductions:
UA_PAYROLL_DED_INSURANCE – deductions for health,life, income continuation, catastrophic, etc.
UA_PAYROLL_DED_RETIREMENT – deductions for retirement and TSA’s
UA_PAYROLL_DED_TAXES – deduction that tax related FICA, Federal withholding, State income tax, etc.
LOAD FREQUENCY
The data will be after each payroll calculation.
Once a month for Unclassified.
Every two weeks for Classified and Students.
DATA CUSTODIAN
Human Resources Office
Contact:Catharine Derubeis
AUTHORIZATION
You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
SPECIAL
CONSIDERATIONS
QUESTIONS
Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED
06/98 New data view.
08/00 Additional DED_DEDUCTION_CODES added.
09/01 Added Ded_Deduction Codes 500, 51C, 51D, 830. Deleted codes 493, 680. Some documentation cleanup. C4J
10/01 Added Ded_Deduction_Code 580.
11/01 Added Ded_Deduction_Code 696. C4j.
11/01 Added Ded_Deduction_Codes 680, 681, 682, 683, 685, 686, 690, 692, 693, 694. C4j.
4/02 Added Ded_Deduction_Codes 836, 837, 838, 839 C4j.
9/02 Added Ded_Dedcution_Codes 310, 311 and 581 C4j
11/02 Added Ded_Deduction_Code 629. C4j
11/02 Added Ded_Deduction_Code 829. C4j
8/03 Added Ded_Deduction_Code 582-583 c4j
10/03 Added Ded_Deduction_Code 584 c4j
2/04 Added Ded_Deduction_Code 840-841 c4j
6/05 Added Ded_Deduction_Code 857 c4j
6/05 Added Ded_Deduction_Code 756 c4j
7/05 Added Ded_Deduction_Code 661 and removed 857 c4j
8/05 Added Ded_Deduction_Code 740 c4j
9/05 Added Ded_Deduction_Code 790 c4j
9/06 Added Ded_Deduction_Code 697 c4j
10/06 Added Ded_Deduction_Code 74M c4j
11/06 Removed Ded_Deduction_Code 475, 478, 479 c4j
11/06 Added Ded_Deduction_Code 645 c4j
11/06 Added Ded_Deduction_Code 842, 843 c4j
11/07 Added Ded_Deduction_Code 698 c4j
2/08 Added Ded_Deduction_Code 586 c4j
4/08 Added Ded_Deduction_Code 699 c4j
6/09 Added Ded_Deduction_Code 759 c4j
9/09 Added Ded_Deduction_Code 587 c4j
3/10 Data Custodian Change c4j
3/10 Added Ded_Deduction_Codes 74N and 74P. c4j
5/10 Removed Ded_Special_Amt c4j
9/10 Added Ded_Deduction_Codes 552 and 588 c4j.
12/10 Allow code 63S thru as union code.C4j
1/11 Added Ded_Deduction_Code 589. c4j
1/11 Added Ded_Deduction_Code 620 c4j
11/11 Data Custodian Change c4J
DATA FORMATS
The codes following the field names in this document define the field.
The different types are:
A – Alphanumeric field. This indicates the field may contain letters and/or numbers. The number following is the field length.
Example: a field defined as A5 could contain ‘E10LN’.
NS – Numeric-Signed field. This indicates the field may contain only numbers. The number following is the field length. If two digits with a decimal point in between are present the first indicates the number of positions before the decimal point and the second the number of digits after the decimal point.
For example: a field defined as NS4.2 would be in the format 9999.99 whereas NS6 would be in the format 999999.
D – Date field. This indicates the field may contain only dates. Please note for the documentation what kind of date format it is — whether YYYYMMDD-19980921 MMDDYY-092198 etc. are present the first indicates the number of positions before the decimal point and the second the number of digits after the decimal point.
Example: a field that is defined as PS4.2 would be in the format 9999.99 whereas PS6 would be in the format 999999.
Column Name Format Description
DED_CALC_NUMBER A9 The unique identifier for a calculation processed in the payroll system. Consists of calendar year, payroll paid month, and sequence number. The scheduled calculations will be assigned a calculation number in advance and a listing of these numbers can be found at http://www.bussvc.wisc.edu/ecbs/forms.html (form #UW1087) Special calculations will be given a calculation number in between the sequence numbers of scheduled calculations.
For example:
199309100 = August Regular Unclassified
199309200 = August B Classified
199309300 = August B Student
199309400 = August End of Month
Unclassified
199309500 = August C Classified
199309600 = September A Student
UNIT A1 This Unit the person belongs to.
A = Madison
G = Parkside
N = Whitewater
B = Milwaukee
H = Platteville
R = Center System
C = Eau Claire
J = River Falls
T = Extension
D = Green Bay
K = Stevens Point
V = Regional Inter-Institutional Program
E = LaCrosse
L = Stout
W = System Admin
F = Oshkosh
M = Superior
Y = System Wide
DED_PERSON_ID_CAL A8 The unique number assigned to each person at the time of payment.
DED_PERSON_ID_CUR A8 The current unique number assigned to each person.
DED_PERSON_SSN A9 The social security number is a nine-digit identifier number assigned by the social security administration.
DED_PERSON_NAME A30 Name of employee being paid. First name, Last name.
DED_CHANGE_NUMBER NS7.2 A sequential number assigned when a change for a person’s payment and/or deductions is initiated. Zeros if original.
DED_DEDUCTION_CODE A6 A code indicating what type of deduction to be taken. The Deduction Description reflects current deductions. The codes may have been used for another deduction in the past.
Misc deduction codes include:

Ded Codes Ded Description
310 Commuter Benefits Pre Tax
311 Commuter Beneftis Post Tax
470-474 Advanced Repaymts
476-477 Deferred Tuition
482-483 Advance Repaymts
491-492 Advance Repaymts
494-499 Advance Repaymts
500 Bike Locker
501 Accts Rec-Milw
502 Panther Card-Milw
503 Accts. Rec-Madison
506 Oshkosh Accts Rec
507-529 Pre-Tax Transportation
530 Van Pool-Post Tax Deductions
532 Travel Adv Repay-Madison
533 Parking Post-Tax, UW Madison
534 Accts Rec-LaCrosse
535 Accts Rec-Green Bay
536 Residence Dining-Stout |
537 UW Madison Housing
538 Housing-River Falls
539 Accts Rec-Platt
540 Pioneer Passport Acct-Platt
541-542 Accts Rec-Osh & Stout
543 Tickets-Milw Basketball-Women
544 Weight Room-Osh
545 Recreation-Madison
546-551 Tickets
552 Kress Membership, UW GB
553-559 Tickets
560 Univ Fitness-WW
561 Travel Adv Repay-Sup
562-565 Accts Rec
566 Aramark Services
567 Travel Adv Repay-Osh
568 Hlth Enhancerment Center-SP
569 Recreation-LaCrosse
570 Purple Points-WW
571 Tickets-Sup
572 Accts Rec-SP
573 Recreation-LX-Strength Ctr
574 Fitness Center-Superior
575-576 Tickets
577 Cardio Center, UWSP
578-580 Tickets
581 Meal Plan PKS
582-583 Tickets
584 Recreation-LaCrosse
585 Dining Plan
586 Pioneer Activity Center
587 Children’s Ctr UWMIL
588 Fitness Ctr, UW Stout
589 Children’s Ctr UW Whitewater
610-619 Union Dues
62A UWEC Faculty Union Dues
62B-62Z Union Dues
620 UWEC Faculty Union Dues
622-625 Union Dues
626-628 Employee Org
629 Union Dues
63A-63S Union Dues
630-639 Union Dues
640-642 Union Dues
643-644 Employee Org
645-660 Union Dues
661 WLEA Dues
662-671 Union Dues
672 Employee Org
673 Union Dues
674 Employee Org
675 Foundation-Milw
676-678 Union Dues
679 Employee Org
680-686 Union Dues
687 Employee Org
688-694 Union Dues
695-699 Employee Org
734 12-Pay Ded Plan
740-754 Credit Unions (including 74A–74P)
755 Student Loan
756 Credit Union
757 Employee Org
758 Edvest
759 Credit Union
760 MGAA Adjustment
771-772 Housing
790 Employee Org
791-794 Foundation
795 Employee Org
796-797 Foundation
798 Employee Org
799 Foundation
800 Badger Fund
801 Foundation
802-803 Employee Org
804 Bond Deds
80A-80J Bond Deds
805-822 Charities & Foundations
823 Klotscke Center-Milw
824-843 Charities & Foundations
845 Wage Assignments-WI Lump Sum Deds
846 Wage Assignments-WI 17% Deds
847 Wage Assignments-WI 25% Deds
848 Wage Assignments-WI 29% Deds
849-976 Wage Assignments
977-979 Wage Assignment Fees
9AA-9ZZ Wage Assignments

For a more detailed list of deductions go the Deduction Listing link in the UWPC Payroll Services Processing Manual
DED_DEDUCTN_GROUP A9 A code grouping specific deduction codes together. Valid codes are 005-060. For a more detailed list, see http://www.bussvc.wisc.edu/uwpc/instman.html.
DED_PERIOD_ID A9 Used for May Faculty calc to identify the extra deductions taken for June, July and August.
DED_DEDUCTION_TYPE A1 The type of deduction that was processed. Acceptable Values:
R = Regular
A = Adjustment
P = Prepayment
C = Correction
DED_CHANGE_STATUS A1 Indicates if record has been changed through the change procedure.
H = Historical Record
Blank = Current Record
DED_DEDUCTN_AMOUNT NS7.2 The amount of money that was processed for the deduction. If taken, the amount is subtracted from the gross to compute net pay.
DED_STATE_SHR_AMT NS7.2 The amount charged to employers for the employee deduction amount taken from salary. For certain deferred deductions only.
DED_EMP_PAID_AMT NS7.2 The difference between the state share amount taken and the deduction amount taken.
DED_RETIRE_BASE A1 The retirement plan that covers this appointment.
Acceptable values are:
‘4’ = Classified 1%, Last Two digits of
Class code = 21,22,24,26,27
‘D’ = Classified Protective 2%. Title
Code = 65670, 65661, 65662, 65580,
65590, 65760, 65540, 65740, 65910,
65920, 65930, 65560 and 65663.
‘E’,’5′ or ‘6’ = Faculty 1%. Last two
digits of Class code = 11,17,19.
‘G’ = Faculty Executive 1.5%. Last two
digits of Class code 19.
‘ ‘ = No retirement coverage.
DED_VISA_CODE A2 Indicator for Foreign Employees with a Visa. The field is used to determine tax status and fringe benefit eligibility of Foreign Employees.
Acceptable values are:
1 – Employees from a Foreign Country who
have a type ‘F’ or ‘J” Visa
2 – All other temporary Visas.
3 – All immigrant permanent visas.
DED_TAKEN_PERIOD A6 The monthly payroll period identifier for the regular deductions processed in the calculation. (Now this is the same as earned period.)
Format CCYYMM.
DED_CRED_UNION A13 Employee account number at a credit union used to deposit the amount of the deduction. (only for deduction codes 745 and 775) Source of the credit union account number is provided by the various credit unions and entered into a deduction application (employee deduction PDED).
DED_REPORT_NAME A30 Name of deduction used in report headings. If it is an assignment deduction, then the last six positions (45-50) should contain the case number which the payroll check writer program will use to print on the ‘pay to order of’ line.
DED_COMPUTATN_AMT NS9.2 The wage amount used to compute the deduction amount, for example, taxes or retirement.
DED_SPECIAL_CODE A6 This code is used when insurance deductions are taken for 9-month appointments during May for the summer. This field is blank on this view.