EMPLOYID

string

15

Y

Not applicable

Employee ID

STATECD

string

15

Y

Not applicable

State code

TXFLGSTS

string

30

N

<blank>

Tax filing status

EXMFBLND

i4

1

N

0

Exemption for blind:

0=False;

1=True

EXFBLSPS

i4

1

N

0

Exemption for blind spouse:

0=False;

1=True

EXFORO65

i4

1

N

0

Exemption for over 65:

0=False;

1=True

EXMFRSLF

i4

1

N

0

Exemption for self:

0=False;

1=True

EXMFSPAL

i4

1

N

0

Exemption for special allowance:

0=False;

1=True

EXMFRSPS

i4

1

N

0

Exemption for spouse:

0=False;

1=True

EXFSPO65

i4

1

N

0

Exemption for spouse over 65:

0=False;

1=True

PRSNEXPT

i4

2

N

0

Personal exemption

DEPNDNTS

i4

2

N

0

Dependents

ADNLALOW

i4

2

N

0

Additional allowances

ESTDEDAL

i4

2

N

0

Estimated deduction allowance

EXMTAMNT

number

21

N

0

Exemption amount

ADSTWHDG

number

21

N

0

Additional state withholding

ESTSTWHD

number

21

N

0

Estimated state withholding

INACTIVE

i4

1

N

0

Inactive:

0=False;

1=True

UpdateIfExists

i4

1

N

1

Flag to allow employee data to 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