< back

BalanceAAP > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data and Reference Tables

Applicant

 

Applicant

Field Name

Data Type

Length

Required

Master Plan Required

Applicant No

Text

11

No

No

First Name

Text

50

No

No

Last Name

Text

50

No

No

Last Name Text>50No No
Race Code

Text

20

No

No

Gender Code

Text

20

No

No

Job Code

Text

20

Yes

Yes

Dept Code

Text

20

No

No

Disp Code

Text

20

Yes

Yes

Hire Date

Date

No

No

Application Date

Date

No

No

Req #

Text

50

No

No

Referral Source

Text

50

No

No

Plan Code

Text

20

No

No

UserField

Text

255

No

No

Drilldown Field Text  

Yes*

Yes*
Rollup Field Text  

No

No

Applicant Disposition

Field Name

Data Type

Length

Required

Master Plan Required

Disp Code

Text

20

Yes

Yes

Hired

True/False

No

No

Offer Extended

True/False

No

No

Internal Successful

True/False

No

No

Reason

Text

50

No

No

Exclude

True/False

No

No

UserField

Text

255

No

No

Department

Field Name

Data Type

Length

Required

Master Plan Required

Dept Code

Text

20

Yes

Yes

Dept Name

Text

50

No

No

Reports To

Text

20

No

No

UserField

Text

255

No

No

Grade

Field Name

Data Type

Length

Required

Master Plan Required

Grade

Text

20

Yes

Yes

Salary Midpoint

Number

No

No

UserField

Text

255

No

No

Job Code

Field Name

Data Type

Length

Required

Master Plan Required

Job Code

Text

20

Yes

Yes

Job Title

Text

50

No

No

Grade

Text

20

No

No

Job Group

Text

20

Yes

Yes

Census Code

Text

3

No

No

UserField

Text

255

No

No

Job Group

Field Name

Data Type

Length

Required

Master Plan Required

Job Group

Text

20

Yes

Yes

Group Name

Text

50

No

No

EEO Code

Text

3

Yes

Yes

UserField

Text

255

No

No

New Hire

Field Name

Data Type

Length

Required

Master Plan Required

Employee

Text

11

Yes

Yes

First Name

Text

50

No

No

Last Name

Text

50

No

No

Race

Text

20

Yes

Yes

Gender

Text

20

Yes

Yes

Veteran Code

Text

5

No

No

Vets Date

Date

  No No

Job Code

Text

20

Yes

Yes

Dept Code

Text

20

No