DEDUCTION

string

6

Y

Not applicable

Deduction

DSCRIPTN

string

30

Y

Not applicable

Deduction description

INACTIVE

i4

1

N

0

Inactive:

0=False;

1=True

DEDBEGDT

datetime

16

Y

Not applicable

Begin date

DEDENDDT

datetime

16

N

<blank>

End date

DEDTYPE

i4

2

N

1

Deduction Type

1 = Standard

2 = Garnishment

GARNCAT

i4

2

Y

0

Garnishment Category

Required if Deduction Type is set to a 2

1= Support Order,

2 = Tax Levy,

3 = Bankruptcy,

4 = Garnishment

5 = Other

VARDEDTN

i4

1

N

0

Variable deduction:

0=False;

1=True

DEDNFREQ

i4

2

N

1

Deduction frequency:

1=Weekly;

2=Biweekly;

3=Semimonthly;

4=Monthly;

5=Quarterly;

6=Semiannually;

7=Annually;

8=Daily/miscellaneous

SFRFEDTX

i4

1

N

0

Sheltered from federal tax: 0=False; 1=True

SHFRFICA

i4

1

N

0

Sheltered from FICA tax:

0=False;

1=True

SHFRSTTX

i4

1

N

0

Sheltered from state tax:

0=False;

1=True

SFRLCLTX

i4

1

N

0

Sheltered from local tax:

0=False;

1=True

BSDORCDS

i4

2

N

0

Based on records:

0=All;

1=Selected

DEDNMTHD

i4

2

N

1

Deduction method:

1=Percentage of gross wages;

2=Percentage of net wages;

3=Fixed amount;

4=Amount per unit

5=Percentage of earnings wage

DEDFRMLA

i4

2

N

0

Deduction formula:

0=Single;

1=Multiple

EARNINGSCODE

string

15

N

<blank>

Earning code

DEDCAMNT_1

number

21

N

0

Deduction amount 1

DEDCAMNT_2

number

21

N

0

Deduction amount 2

DEDCAMNT_3

number

21

N

0

Deduction amount 3

DEDCAMNT_4

number

21

N

0

Deduction amount 4

DEDCAMNT_5

number

21

N

0

Deduction amount 5

DEDNPRCT_1

number

21

N

0

Deduction percentage 1

DEDNPRCT_2

number

21

N

0

Deduction percentage 2

DEDNPRCT_3

number

21

N

0

Deduction percentage 3

DEDNPRCT_4

number

21

N

0

Deduction percentage 4

DEDNPRCT_5

number

21

N

0

Deduction percentage 5

DEDTRMAX_1

number

21

N

0

Deduction tier maximum 1

DEDTRMAX_2

number

21

N

0

Deduction tier maximum 2

DEDTRMAX_3

number

21

N

0

Deduction tier maximum 3

DEDTRMAX_4

number

21

N

0

Deduction tier maximum 4

DEDTRMAX_5

number

21

N

0

Deduction tier maximum 5

DETRMXUN_1

number

21

N

0

Deduction tier maximum units 1

DETRMXUN_2

number

21

N

0

Deduction tier maximum units 2

DETRMXUN_3

number

21

N

0

Deduction tier maximum units 3

DETRMXUN_4

number

21

N

0

Deduction tier maximum units 4

DETRMXUN_5

number

21

N

0

Deduction tier maximum units 5

DEPYPRMX

number

21

N

0

Deduction pay period maximum

DEDYRMAX

number

21

N

0

Deduction year maximum

Deduction_Fiscal_Yr_Max

number

21

N

0

Deduction Fiscal Year Maximum

DEDLTMAX

number

21

N

0

Deduction life maximum

W2BXNMBR

i4

2

N

0

W-2 box number

W2BXLABL

string

6

N

<blank>

W-2 box label

W2BXNMBR2

i4

2

N

0

W-2 Box Number 2

W2BXLABL2

string

6

N

<blank>

W-2 Box Label 2

W2BXNMBR3

i4

2

N

0

W-2 Box Number 3

W2BXLABL3

string

6

N

<blank>

W-2 Box Label 3

W2BXNMBR4

i4

2

N

0

W-2 Box Number 4

W2BXLABL4

string

6

N

<blank>

W-2 Box Label 4

DATAENTDFLT

i4

1

N

0

Data entry default:

0=False;

1=True

UpdateIfExists

i4

1

N

1

Flag to allow customer data to be updated if it currently exists:

0=No;

1=Yes

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only