EMPLOYID

string

15

Y

Not applicable

Employee ID

DEDUCTON

string

6

Y

Not applicable

Deduction

INACTIVE

i4

1

N

0

Inactive:

0=False;

1=True

DEDBEGDT

datetime

16

N

<blank>

Deduction start date; required if not using deduction code as the default, so UseDefaultCoDeduction=0; optional if using the default and then UseDefaultCoDeduction=1

DEDENDDT

datetime

16

N

<blank>

Deduction end date

VARDEDTN

i4

1

N

Default from setup

Variable deduction: 0=False; 1=True

DEDNFREQ

i4

2

N

Default from setup

Deduction frequency:

1=Weekly;

2=Biweekly;

3=Semimonthly;

4=Monthly;

5=Quarterly;

6=Semiannually;

7=Annually;

8=Daily/miscellaneous

SFRFEDTX

i4

1

N

Default from setup

Sheltered from federal tax:

0=False;

1=True

SHFRFICA

i4

1

N

Default from setup

Sheltered from FICA tax:

0=False;

1=True

SHFRSTTX

i4

1

N

Default from setup

Sheltered from state tax:

0=False;

1=True

SFRLCLTX

i4

1

N

Default from setup

Sheltered from local tax:

0=False;

1=True

BSDORCDS

i4

2

N

Default from setup

Based on records:

0=All;

1=Selected

DEDNMTHD

i4

2

N

Default from setup

Deduction method:

1=Percentage of gross wages;

2=Percentage of net wages;

3=Fixed amount;

4=Amount per unit

5=Percentatge of earnings wage

DEDFRMLA

i4

2

N

Default from setup

Deduction formula:

0=Single;

1=Multiple

DEDNPRCT_1

number

21

N

Default from setup

Deduction percentage 1

DEDNPRCT_2

number

21

N

Default from setup

Deduction percentage 2

DEDNPRCT_3

number

21

N

Default from setup

Deduction percentage 3

DEDNPRCT_4

number

21

N

Default from setup

Deduction percentage 4

DEDNPRCT_5

number

21

N

Default from setup

Deduction percentage 5

DEDCAMNT_1

number

21

N

Default from setup

Deduction amount 1

DEDCAMNT_2

number

21

N

Default from setup

Deduction amount 2

DEDCAMNT_3

number

21

N

Default from setup

Deduction amount 3

DEDCAMNT_4

number

21

N

Default from setup

Deduction amount 4

DEDCAMNT_5

number

21

N

Default from setup

Deduction amount 5

DEDTRMAX_1

number

21

N

Default from setup

Deduction tier maximum 1

DEDTRMAX_2

number

21

N

Default from setup

Deduction tier maximum 2

DEDTRMAX_3

number

21

N

Default from setup

Deduction tier maximum 3

DEDTRMAX_4

number

21

N

Default from setup

Deduction tier maximum 4

DEDTRMAX_5

number

21

N

Default from setup

Deduction tier maximum 5

DETRMXUN_1

number

21

N

Default from setup

Deduction tier maximum units 1

DETRMXUN_2

number

21

N

Default from setup

Deduction tier maximum units 2

DETRMXUN_3

number

21

N

Default from setup

Deduction tier maximum units 3

DETRMXUN_4

number

21

N

Default from setup

Deduction tier maximum units 4

DETRMXUN_5

number

21

N

Default from setup

Deduction tier maximum units 5

DEPYPRMX

number

21

N

Default from setup

Deduction pay period maximum

DEDYRMAX

number

21

N

Default from setup

Deduction year maximum

Deduction_Fiscal_Yr_Max

number

21

N

0

Deduction fiscal year maximum

DEDLTMAX

number

21

N

Default from setup

Deduction life maximum

W2BXNMBR

i4

2

N

Default from setup

W-2 box number

W2BXLABL

string

6

N

Default from setup

W-2 box label

W2BXNMBR2

i4

2

N

<blank>

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

Default from setup

Data entry default:

0=False;

1=True

UseDefaultCoDeduction

i4

2

N

1

Use default company deduction:

0=False;

1=True

EARNINGSCODE

string

15

N

<blank>

Earnings code

COURTDATE

datetime

16

N

<blank>

Court Date

COURTNAME

string

31

N

<blank>

Court name

DOCDESCR

string

31

N

<blank>

Document ID

ORIGINALAMOUNT

number

21

N

0

Original amount

AMNTTAKEN

number

21

N

0

Amount taken

FEDMAXDED

string

15

N

<blank>

Federal maximum deduction

STATEMAXDED

string

15

N

<blank>

State maximum deduction

VENDORID

string

15

N

<blank>

Vendor ID

UpdateIfExists

i4

1

N

1

Flag to allow address 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 the 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