LLASTNAME_I

string

21

Y

Not applicable

Last name

FFIRSTNAME_I

string

15

Y

Not applicable

First name

APPLYDATE_I

datetime

16

Y

Not applicable

Application date

APPLICANTNUMBER_I

number

21

Y

Not applicable

Applicant number - Optional/Required - Required if Updating a duplicate Last /First Name combination

ISEQUENCENUMBER_I

i4

2

Y

Not applicable

Line Sequence Number - Null = create or update if single line for the Applicant. Not Null = update

MIDLNAME

string

15

N

<blank>

Middle name

SSN_I

string

15

N

<blank>

Social security number

ADDRESS1

string

61

N

<blank>

Address information

ADDRESS2

string

61

N

<blank>

Address information

CITY

string

35

N

<blank>

Address city

STATE

string

29

N

<blank>

Address state

ZIPCODE_I

string

11

N

<blank>

Postal code

COUNTRY

string

61

N

<blank>

Country

HOMEPHONE

string

21

N

<blank>

Phone 1

WORKPHONE

string

21

N

<blank>

Phone 2

EXT_I

string

5

N

<blank>

Telephone extension

REQUISITIONNUMBER_I

i4

4

N

0

Requisition number

COMPANYCODE_I

string

5

Y

Not applicable

Company ID

DIVISIONCODE_I

string

7

N

<blank>

Division

DEPARTMENTCODE_I

string

7

N

<blank>

Department

POSITIONCODE_I

string

7

N

<blank>

Position

LOCATNID

string

15

N

<blank>

Location

STATUS0_I

i4

2

N

0

Status

0 = Blank,

1 = Active,

2 = Open,

3 = Rejected,

4 = Hired

5 = Other

REJECTREASON_I

i4

2

N

<blank>

Reject Reason

1 = Testing,

2 = Interview,

3 = References,

4 = Experience,

5 = Education

6 = Other

DSCRIPTN

string

31

N

<blank>

Rejection comments

RELOCATION_I

i4

2

N

<blank>

Relocation

0 = Yes

1 = No

REPLYLETTERSENT_I

i4

1

N

<blank>

Reply Letter Sent

0 = False

1 = True

COLORCODE_I

i4

2

N

<blank>

Color Code

1 = Blue,

2 = Green,

3 = Yellow,

4 = Red,

5 = N/A

REFSOURCEDDL_I

i4

2

N

<blank>

Referral Source

0 = None,

1 = Word of Mouth,

2 = Referred by Employee,

3 = Referred by an Agency,

4 = Newspaper,

5 = Other,

6 = Internet

REFERENCESOURCE_I

string

31

N

<blank>

Referral Source Description

GENDERGB_I

i4

2

N

<blank>

Gender

0 = Male,

1 = Female

2 = Unknown

EEOETHNICORIGIN_I

i4

2

N

<blank>

Ethic Origin

1 = White,

2 = American Indian or Alaskan Native,

3 = Black or African American,

4 = Asian,

5 = Hispanic or Latino,

6 = Two or More Races,

7 = N/A

8 = Native Hawaiian or Pacific Islander

EEOAGE_I

i4

2

N

<blank>

Age

1 = 18 to 25,

2 = 26 to 35,

3 = 36 to 45,

4 = 46 to 55,

5 = 56 +,

6 = Unknown

7 = 00 to 17

HANDICAPPED

i4

1

N

<blank>

Handicapped

0 = False

1 = True

VETERAN

i4

1

N

<blank>

Veteran

0 = False

1 = True

DISABLEDVETERAN

i4

1

N

<blank>

Disabled Veterans

0 = False

1 = True

VIETNAMVETERAN

i4

1

N

<blank>

Vietnam Veterans

0 = False

1 = True

OTHERVET

i4

1

N

<blank>

Other Veterans

0 = False

1 = True

CHANGEBY_I

string

15

N

<blank>

Changed by

DATE1_I

datetime

16

N

<blank>

Date 1

For extra date fields

DATE2_I

datetime

16

N

<blank>

Date 2

For extra date fields

DATE3_I

datetime

16

N

<blank>

Date 3

For extra date fields

DATE4_I

datetime

16

N

<blank>

Date 4

For extra date fields

DATE5_I

datetime

16

N

<blank>

Date 5

For extra date fields

STRINGS_I_1

string

31

N

<blank>

String 1

For extra fields

STRINGS_I_2

string

31

N

<blank>

String 2

For extra fields

STRINGS_I_3

string

31

N

<blank>

String 3

For extra fields

STRINGS_I_4

string

31

N

<blank>

String 4

For extra fields

STRINGS_I_5

string

31

N

<blank>

String 5

For extra fields

NUMERICEXTRA_1

i4

4

N

<blank>

Alpha/Numeric 1

For extra number fields

NUMERICEXTRA_2

i4

4

N

<blank>

Alpha/Numeric 2

For extra number fields

NUMERICEXTRA_3

i4

4

N

<blank>

Alpha/Numeric 3

For extra number fields

NUMERICEXTRA_4

i4

4

N

<blank>

Alpha/Numeric 4

For extra number fields

NUMERICEXTRA_5

i4

4

N

<blank>

Alpha/Numeric 5

For extra number fields

DOLLARS_I_1

number

21

N

<blank>

Currency 1

For extra currency fields

DOLLARS_I_2

number

21

N

<blank>

Currency 2

For extra currency fields

DOLLARS_I_3

number

21

N

<blank>

Currency 3

For extra currency fields

DOLLARS_I_4

number

21

N

<blank>

Currency 4

For extra currency fields

DOLLARS_I_5

number

21

N

<blank>

Currency 5

For extra currency fields

CHECKBOXES_I_1

i4

1

N

<blank>

Checkboxes 1

For extra checkbox fields

CHECKBOXES_I_2

i4

1

N

<blank>

Checkboxes 2

For extra checkbox fields

CHECKBOXES_I_3

i4

1

N

<blank>

Checkboxes 3

For extra checkbox fields

CHECKBOXES_I_4

i4

1

N

<blank>

Checkboxes 4

For extra checkbox fields

CHECKBOXES_I_5

i4

1

N

<blank>

Checkboxes 5

For extra checkbox fields

UpdateIfExists

i4

1

N

1

Flag to allow Applicant data to be updated if it exists.

0=no,

1=yes

RequesterTrx

i4

2

N

0

Requester Transaction

0=false,

1=true

if true then 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