REQUISITIONNUMBER_I

i4

4

Y

Not applicable

Requistion number

REQSTATUS_I

i4

2

Y

Not applicable

Status

1=Open,

2=Closed,

3=On Hold

4=Immediate

DEPARTMENTCODE_I

string

7

Y

Not applicable

Department

POSITIONCODE_I

string

7

Y

Not applicable

Position

COMPANYCODE_I

string

5

Y

Not applicable

Company code

DIVISIONCODE_I

string

7

N

<blank>

Division

MANAGER_I

string

31

N

<blank>

Manager

SUPERVISORCODE_I

string

7

N

<blank>

Supervisor

STRTDATE

datetime

16

N

<blank>

Internal post date

ENDDATE

datetime

16

N

<blank>

Internal close date

OPENINGDATE_I

datetime

16

N

<blank>

Opening date

RECRUITER_I

string

31

N

<blank>

Recruiter

RECRUITMENT_I

i4

2

N

<blank>

Job Title

0 = Internal

1 = External

ADVERTISINGLIST_I_1

string

15

N

<blank>

Advertising

ADVERTISINGLIST_I_2

string

15

N

<blank>

Advertising

ADVERTISINGLIST_I_3

string

15

N

<blank>

Advertising

ADVERTISINGLIST_I_4

string

15

N

<blank>

Advertising

ADVERTISINGLIST_I_5

string

15

N

<blank>

Advertising

POSITIONSAVAILABLE_I

i4

2

N

<blank>

Positions available

POSITIONSFILLED_I

i4

2

N

<blank>

Positions filled

APPLICANTSAPPLIED_I

i4

2

N

<blank>

Applicants

APPSINTERVIEWED_I

i4

2

N

<blanke>

Applicants interviewed

ADVERTISINGCOSTS_I

number

21

N

<blank>

Advertising costs

RECRUITERSFEES_I

number

21

N

<blank>

Recruiter fees

CHANGEBY_I

string

15

N

<blank>

Changed by

UpdateIfExists

i4

1

N

1

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

0=Create only;

1=Update if exists;

2=Create, do NOT update(no error)

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