- DATA VIEW NAME
- UA_PAYROLL_DED_INSURANCE
- OVERVIEW
- This view displays payroll deduction records for health, life, income continuation, catastrophic, etc. 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_MISC – miscellaneous deductions
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
- Payroll and Benefits
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 - This contains deduction information for all campuses you may want to use unit equals as one of the criteria. Please be aware that if your query involves multiple deductions or employees with multiple pay types, they maybe listed or counted multiple times in your query.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 06/98 New data view.
04/01 Added deduction code 441. C4J
09/01Cleaned up code descriptions. C4J
01/02 Added deduction codes 469 and 480. C4J
08/03 Corrected Deduction Insurance Code descriptions. Modified the definition for DED_SPECIAL _CODE pka
2/04 Added deduction codes 401 C4J
3/04 Added deduction codes 402, 403, 478, and 479
8/04 Added deduction code 442 C4J
3/05 Added deduction codes 45A thru 45J
3/06 Added deduction code 443 C4j
12/09 Added deduction codes 410, 411 C4J
3/10 Data Custodian Change C4j
4/10 Added Ded_Fringe_Benefit_Amt and Ded_Pre_Tax_Waiver_Ind
to end of record. C4j
5/10 Removed Ded_Special_Amt 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. For 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-19980921or MMDDYY-092198 etc.
| 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/ecabs/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 the Unit the person belongs to. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||
| 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 detailed listing can be found at http://www.bussvc.wisc.edu/uwpc/instman.html under Payroll Services processing Instruction Manual (Training Manual) then go to the end of the section 6. The Deduction Description reflects current deductions. The codes may have been used for another deduction in the past.
|
||||||||||||||||||||||||||||||||||||||||||
| DED_DEDUCTN_GROUP | A9 | A code grouping specific deduction codes together. The detailed listing can be found at http://www.bussvc.wisc.edu/uwpc/instman.html. Valid Codes are 005 – 060. | ||||||||||||||||||||||||||||||||||||||||||
| 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 to indicate health insruance information. i.e a code of 13FY2A indicates county code of 13, family coverage (F and 2), zero premium (Y), full state share (A). | ||||||||||||||||||||||||||||||||||||||||||
| DED_FRINGE_BENEFIT_AMT | NS5.2 | The amount of the fringe benefit that increases the taxable gross for Federal Tax, State Tax, Fica Tax and Social Security Tax. | ||||||||||||||||||||||||||||||||||||||||||
| DED_PRE_TAX_WAIVER_IND | A1 | Indicates that the employee has chosen to have the benefit deduction taken after taxes. The deduction amount will not reduce the taxable gross for Federal Tax, State Tax, Fica Tax and Social Security Tax. |