Child pages
  • Deduction Master File Information
Skip to end of metadata
Go to start of metadata

Deduction Master File Information (Data on DEDNAM)

Fields listed in each table that are bolded are required for adding new data or updating current data. The ADD or UPDATE option is specified by each bolded field and is located in the description column. Fields that are italicized only may be required, dependent upon another field's value.

  

  

 

 

Description Format Req. Column Desc. Possible Values

Deduction code-(ADD OR UPDATE)

9(3)

DEDUCTION_CODE

Must be between 003 - 988 (excluding 001, 002, 400, 450, 590, 591, 690-695 which are reserved)

Deduction abbreviation

X(8)

ABBREVIATION

All Deduction types

Deduction company name

X(30)

DEDUCTION_NAME

 

Deduction company pay to name

X(30)

PAY_TO_NAME

 

Deduction company second pay to name

X(30)

SECOND_PAY_TO_NAME

 

Deduction company address 1

X(24)

STREET

 

Deduction company address 2

X(24)

STREET_2

 

Deduction company city

X(15)

CITY

 

Deduction company state-(ADD)

X(2)

STATE

 

Deduction company zip code

X(9)

ZIP_CODE

 

Deduction company phone

X(10)
Area Code, Exchange, Number

PHONE_NUMBER

 

Deduction company fax

X(10)
Area Code, Exchange, Number

FAX_NUMBER

 

Job level flag

X(1)

JOB_LEVEL_FLAG

(1,Y,Yes)= Yes
(0,N,No)= No

Deduction type-(ADD)

X(4)

DEDUCTION_TYPE

01, 1, FED, FEDERAL
02, 2, OH, OHIO
03, 3, CITY
04, 4, ST, STATE
05, 5, SERS
06, 6, STRS
07, 7, ANN, ANNUITY
08, 8, ANSERS
09, 9, ANSTRS
10, BBSTRS
11, REG, REGULAR
12, PUSERS
13, PUSTRS
14, MEDFIC, MEDFICA
15, PUMF
16, SB, SBOND
17, DD, DIRDEP
18, OSDI
19, BBSERS
20, MSA
21, ADOP, ADOPT, ADOPTION
22, CHILD
23, DEPCARE

Exempt Annuity Flag-(ADD - FEDERAL and STATE only)

X(1)

ANNUITIES_EXEMPT_FLAG_TYPE

(Y) - Annuities exempt from this tax

(N) - Annuities are not exempt from this tax

Annuity type-(ADD - ANN type-mandatory)

X(1)

ANNUITIES_EXEMPT_FLAG_TYPE

A - 401 (k)

B - 401 (a), SERS and STRS

C - 403 (b)

D - Section 125, treated as nonwages

E - 457

F - 408 (k) (6)

G - 501 (c) (18) (d)

H - Section 125, treated as wages

I - Section 125, Health Savings Acct (HSA)

OSDI code-(ADD)

X(4)

OSDI_CODE

 

Payment cycle to pay deduction

X(1)

PAYMENT_CYCLE

P, Every payroll,Every
M, Monthly
Q, Quarterly
A, Annually
1 - 9 - User defined

Certified object code

X(3)

CERTIFIED_OBJECT

SERS,
STRS,
STRSPU,
BBSTRS,
REG,
MSA,
DEPCARE

Classified object code

X(3)

CLASSIFIED_OBJECT

SERS,
STRS,
STRSPU,
BBSTRS,
REG,
MSA,
DEPCARE

Other object code

X(3)

OBJECT

SERS,
STRS,
STRSPU,
BBSTRS,
REG,
MSA,
DEPCARE

Tax entity code

X(5)

TAX_ENTITY_CODE

 

State ID number

X(12)

STATE_ID_NUMBER

State-Other

W2 name abbreviation

X(15)

W2_NAME_ABBREVIATION

 

Vendor number

9(6)

VENDOR_NO

All deduction types

Tax Medicare/FICA Board Pickup

X(1)

TAX_MEDICARE_FICA_PICKUP

(1,Y,Yes)= Yes
(0,N,No)= No

Tax Non Cash Earnings

X(1)

TAX_NONCASH_FLAG

(1,Y,Yes)= Yes
(0,N,No)= No

Required

X(1)

REQUIRED_FLAG

All deduction types except Federal
(1)= May be required
(2)=Required for all employees

Pay deduction electronically

X(1)

ELECTRONIC_REMITTANCE_FLAG

(1,Y,Yes)= Yes
(0,N,No)= No

Regional Income Tax Agency code

X(3)

RITA_CODE

City

Regional Income Tax Agency description

X(25)

RITA_DESC

City

Central Collection Agency code

X(3)

CCA_CODE

City

Central Collection Agency description

X(25)

CCA_DESC

City

Print on checkstub

X(1)

PRINT_ON_CHECKSTUB

SERS,STRS,ANN,REG, SERSBDPU,STRSBDPU, MEDFICA,MEDFICAPU,MSA,ADOPT,DEPCARE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 401K annuity (ADD - CITY and OTHER STATE only)

X(1)

HONOR_401K_ANNUITY

CITY ,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 401A annuity (ADD - CITY and OTHER STATE only)

X(1)

HONOR_401A_ANNUITY

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 403B annuity (ADD - CITY and OTHER STATE only)

X(1)

HONOR_403B_ANNUITY

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 457 annuity - (ADD - CITY and OTHER STATE only)

X(1)

HONOR_457_ANNUITY

CITY, OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 408K annuity - (ADD - CITY and OTHER STATE only)

X(1)

HONOR_408K_ANNUITY

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 501C annuity - (ADD - CITY and OTHER STATE only)

X(1)

HONOR_501C_ANNUITY

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 125 nonwages - (ADD - CITY and OTHER STATE only)

X(1)

HONOR_125NONWAGES

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor 125 wages - (ADD - CITY and OTHER STATE only)

X(1)

HONOR_125WAGES

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Honor other annuity - (ADD - CITY and OTHER STATE only)

X(1)

HONOR_OTHER_ANNUITY

CITY,OTHER STATE
(1,Y,Yes)= Yes
(2,N,No)= No

Designated Roth

X(1)

DESIGNATED_ROTH

REGULAR
(1)= 401K
(2)=403B

(3)=457B

Dirdep ACH Trans

X(3)

DIRDEP_TRANS_TYPE

HSA

Include as employer-sponsored health coverage?

X(1)

EMPLR_HEALTH_COV

(Y)=Inlcude employee and employer amounts in Box 12, Code DD

(N) or (Space)=Do NOT include employee and employer amounts in Box 12, Code DD

Regional Income Tax Agency flag X(1)  RITA_FLAG 

Does this municipality report to RITA?
(Y)= Yes
(N, space)= No

Central Collection Agency flag X(1)  CCA_FLAG 

Does this municipality report to CCA?
(Y)= Yes
(N, space)= No 

  • No labels