BENEFIT

string

6

Y

Not applicable

Benefit

DSCRIPTN

string

30

Y

Not applicable

Deduction description

INACTIVE

i4

1

N

0

Inactive:

0=False;

1=True

BNFBEGDT

datetime

16

Y

Not applicable

Benefit begin date

BNFENDDT

datetime

16

N

<blank>

Benefit end date

VARBENFT

i4

1

N

0

Variable benefit/transaction required:

0=False;

1=True

BNFTFREQ

i4

2

N

1

Benefit frequency:

1=Weekly;

2=Biweekly;

3=Semimonthly;

4=Monthly;

5=Quarterly;

6=Semiannually;

7=Annually;

8=Daily/miscellaneous

SBJTFDTX

i4

1

N

0

Subject to federal tax: 0=False; 1=True

SBJTSSEC

i4

1

N

0

Subject to FICA Social Security tax:

0=False;

1=True

SBJTMCAR

i4

1

N

0

Subject to FICA Medicare tax:

0=False;

1=True

SBJTSTTX

i4

1

N

0

Subject to state tax:

0=False;

1=True

SBJTLTAX

i4

1

N

0

Subject to local tax:

0=False;

1=True

SBJTFUTA

i4

1

N

0

Subject to FUTA tax:

0=False;

1=True

SBJTSUTA

i4

1

N

0

Subject to SUTA tax:

0=False;

1=True

FFEDTXRT

number

21

N

0

Flat federal tax rate

FLSTTXRT

number

21

N

0

Flat state tax rate

BORCDTYP

i4

2

N

1

Based on record type:

1=Paycodes;

2=Deductions

BSDORCDS

i4

2

N

0

Based on records:

0=False;

1=True

BNFTMTHD

i4

2

N

1

Benefit method:

1=% of gross;

2=% of net wages;

3=% of deduction;

4=Fixed amount;

5=Amount per unit

BNFFRMLA

i4

2

N

0

Benefit formula

BNFPRCNT_1

number

21

N

0

Benefit percent 1

BNFPRCNT_2

number

21

N

0

Benefit percent 2

BNFPRCNT_3

number

21

N

0

Benefit percent 3

BNFPRCNT_4

number

21

N

0

Benefit percent 4

BNFPRCNT_5

number

21

N

0

Benefit percent 5

BNFITAMT_1

number

21

N

0

Benefit amount 1

BNFITAMT_2

number

21

N

0

Benefit amount 2

BNFITAMT_3

number

21

N

0

Benefit amount 3

BNFITAMT_4

number

21

N

0

Benefit amount 4

BNFITAMT_5

number

21

N

0

Benefit amount 5

BNFTRMAX_1

number

21

N

0

Benefit tier maximum 1

BNFTRMAX_2

number

21

N

0

Benefit tier maximum 2

BNFTRMAX_3

number

21

N

0

Benefit tier maximum 3

BNFTRMAX_4

number

21

N

0

Benefit tier maximum 4

BNFTRMAX_5

number

21

N

0

Benefit tier maximum 5

BNTRMXUN_1

number

21

N

0

Benefit tier maximum units 1

BNTRMXUN_2

number

21

N

0

Benefit tier maximum units 2

BNTRMXUN_3

number

21

N

0

Benefit tier maximum units 3

BNTRMXUN_4

number

21

N

0

Benefit tier maximum units 4

BNTRMXUN_5

number

21

N

0

Benefit tier maximum units 5

BNPAYPMX

number

21

N

0

Benefit pay period Maximum

BNFYRMAX

number

21

N

0

Benefit year maximum

Benefit_Fiscal_Max

number

21

N

0

Benefit Fiscal Year Maximum

BNFLFMAX

number

21

N

0

Benefit lifetime 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 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