< back

BalanceAAP > File Structure Details / Reference Tables

RETURN TO: Understanding BALANCEaap Data and Reference Tables

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