Table Definitions - Job Posting

01=Employee No

APPLICATION

*EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

04=Application Date

APPLICATION

APPLICATION_DATE

Size: 11 Format: DD-MMM-YYYY

05=Available Date

APPLICATION

AVAILABLE_DATE

Size: 11 Format: DD-MMM-YYYY

06=Reference Check Date

APPLICATION

REFERENCE_CHECKED_DATE

Size: 11 Format: DD-MMM-YYYY

07=Interview Date

APPLICATION

INTERVIEW_DATE

Size: 11 Format: DD-MMM-YYYY

08=Acceptance Date

APPLICATION

ACCEPTANCE_DATE

Size: 11 Format: DD-MMM-YYYY

09=Reason

APPLICATION

REASON

Size: 10

09=Reason

APPLICATION

REASON_DESCRIPTION

Detailed Explanation of code. Size: 30

11=Local Applicant

APPLICATION

LOCAL_APPLICANT_YN

Internal Lookup: Y=YES, N=NO, Size: 3

12=Student Teacher

APPLICATION

STUDENT_TEACHER_YN

Internal Lookup: Y=YES, N=NO, Size: 3

13=Purge [Y/N]

APPLICATION

PURGE_YN

Internal Lookup: Y=YES, N=NO, Size: 3

20=Comment

APPLICATION

COMMENT_1

Size: 50

21=Comment

APPLICATION

COMMENT_2

Size: 50

22=Comment

APPLICATION

COMMENT_3

Size: 50

The key to this is that HRW requires that you specify a 'range' of APPLICATION:POSTING_NOs in the selection fields.  

All postings within the specified range will appear across the top of the report as a separate column.

This will allow you to see what postings each employee has applied to.

Was Job Filled

POSTING

FILLED_YN

Internal Lookup: Y=FILLED, N=NOT FILLED, C=CANCELLED, R=RELEASED, BLANK=BLANK, Size: 6

Comment 1

POSTING

COMMENT_1

Size: 30

Comment 2

POSTING

COMMENT_2

Size: 30

Comment 3

POSTING

COMMENT_3

Size: 30

Comment 4

POSTING

COMMENT_4

Size: 30

Comment 5

POSTING

COMMENT_5

Size: 30

01=Subject

POSTING

SUBJECT_01

Size: 10

02=Level

POSTING

LEVEL_01

Size: 4

03=Hours/FTE

POSTING

FTE_01

Size: 10 Format: ########.##

04=Subject

POSTING

SUBJECT_02

Size: 10

05=Level

POSTING

LEVEL_02

Size: 4

06=Hours/FTE

POSTING

FTE_02

Size: 10 Format: ########.##

07=Subject

POSTING

SUBJECT_03

Size: 10

08=Level

POSTING

LEVEL_03

Size: 4

09=Hours/FTE

POSTING

FTE_03

Size: 10 Format: ########.##

10=Subject

POSTING

SUBJECT_04

Size: 10

11=Level

POSTING

LEVEL_04

Size: 4

12=Hours/FTE

POSTING

FTE_04

Size: 10 Format: ########.##

13=Subject

POSTING

SUBJECT_05

Size: 10

14=Level

POSTING

LEVEL_05

Size: 4

15=Hours/FTE

POSTING

FTE_05

Size: 10 Format: ########.##

16=Subject

POSTING

SUBJECT_06

Size: 10

17=Level

POSTING

LEVEL_06

Size: 4

18=Hours/FTE

POSTING

FTE_06

Size: 10 Format: ########.##

19=Subject

POSTING

SUBJECT_07

Size: 10

20=Level

POSTING

LEVEL_07

Size: 4

21=Hours/FTE

POSTING

FTE_07

Size: 10 Format: ########.##

22=Subject

POSTING

SUBJECT_08

Size: 10

23=Level

POSTING

LEVEL_08

Size: 4

24=Hours/FTE

POSTING

FTE_08

Size: 10 Format: ########.##

25=Subject

POSTING

SUBJECT_09

Size: 10

26=Level

POSTING

LEVEL_09

Size: 4

27=Hours/FTE

POSTING

FTE_09

Size: 10 Format: ########.##

28=Subject

POSTING

SUBJECT_10

Size: 10

29=Level

POSTING

LEVEL_10

Size: 4

30=Hours/FTE

POSTING

FTE_10

Size: 10 Format: ########.##

All Subject and Level Codes

POSTING

SUBJ_AND_LEV_CODES

Size: 30

All Subject and Level Descriptions

POSTING

SUBJ_AND_LEV_DESCS

Size: 30

Hours/FTE: 03,06,09,12,15,18,21,24,27,30

POSTING

HOURS_OR_FTE

Size: 10 Format: ########.##

Level: 02,05,08,11,14,17,20,23,26,29

POSTING

LEVEL_CODES

Size: 30

Level: 02,05,08,11,14,17,20,23,26,29

POSTING

LEVEL_DESCS

Size: 30

Subject, Level Codes and Hours/FTE

POSTING

SUBJ_LEV_FTE_CODES

Size: 30

Subject, Level Descriptions and Hours/FTE

POSTING

SUBJ_LEV_FTE_DESCS

Detailed Explanation of code. Size: 30

Subject: 01,04,07,10,13,16,19,22,25,28

POSTING

SUBJECT CODES

Size: 30

Subject: 01,04,07,10,13,16,19,22,25,28

POSTING

SUBJECT_DESCS

Size: 30

01=Posting Number

POSTING

POSTING_NO

Size: 10

02=Desc

APPLICATION

POSTING_DESCRIPTION

Detailed Explanation of code. Size: 30

02=Desc

POSTING

POSTING_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Posting Type

APPLICATION

POSTING_TYPE_CODE

Size: 10

03=Posting Type

POSTING

POSTING_TYPE_CODE

Size: 10

03=Posting Type

POSTING

POSTING_TYPE_DESC

Detailed Explanation of code. Size: 30

04=Filled [Y/N/C/R]

APPLICATION

POSTING_FILLED

Internal Lookup: Y=FILLED, N=NOT FILLED, C=CANCELLED, R=RELEASED, BLANK=BLANK, Size: 6

05=Round

APPLICATION

APPLICATION_ROUND

Size: 5

05=Round

POSTING

ROUND_CODE

Size: 5

05=Round

POSTING

ROUND_DESC

Detailed Explanation of code. Size: 30

06=Reqn Date

POSTING

REQUISITIONED_DATE

Size: 11 Format: DD-MMM-YYYY

07=Reqn Emp

POSTING

REQUISITIONED_EMP_NAME

Detailed Explanation of code. Size: 30

07=Reqn Emp

POSTING

REQUISITIONED_EMP_NO

Size: 10

08=Posting Date

POSTING

POSTING_DATE

Size: 11 Format: DD-MMM-YYYY

08=Posting Date

POSTING

POSTING_DATE_AND_TIME_(YYYYMMD

Size: 14 Format: DD-MMM-YYYY H

09=Closing Date

APPLICATION

POSTING_CLOSING_DATE

Size: 11 Format: DD-MMM-YYYY

09=Closing Date

POSTING

CLOSING_DATE

Size: 11 Format: DD-MMM-YYYY

09=Closing Date

POSTING

CLOSING_DAY_AND_DATE

Detailed Explanation of code. Size: 20

10=Position

POSTING

POSITION_CODE

Size: 8

10=Position

POSTING

POSITION_DESC

Detailed Explanation of code. Size: 30

11=Location

POSTING

LOCATION_CODE

Size: 4

11=Location

POSTING

LOCATION_NAME

Detailed Explanation of code. Size: 30

12=Start Date

POSTING

START_DATE

Size: 11 Format: DD-MMM-YYYY

13=End Date

POSTING

END_DATE

Size: 11 Format: DD-MMM-YYYY

16=Shift

POSTING

SHIFT_CODE

Size: 5

17=Cycle

POSTING

CYCLE_CODE

Size: 5

18=Period

POSTING

PERIOD

Size: 6

55=Successful Applicant Name

POSTING

SUCC_APPL_NAME_1

Size: 30

55=Successful Applicant Name&No

POSTING

SUCC_APPL_NAME_AND_NO_1

Size: 30

55=Successful Applicant Number

POSTING

SUCC_APPL_EMPLOYEE_NO_1

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

56=Successful Application Accept Date

POSTING

SUCC_APPL_ACCEPT_DATE_1

Size: 11 Format: DD-MMM-YYYY

57=Successful Applicant Comment

POSTING

SUCC_APPL_COMMENT_1

Size: 30

58=Successful Applicant Name

POSTING

SUCC_APPL_NAME_2

Size: 30

58=Successful Applicant Name&No

POSTING

SUCC_APPL_NAME_AND_NO_2

Size: 30

58=Successful Applicant Number

POSTING

SUCC_APPL_EMPLOYEE_NO_2

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

59=Successful Application Accept Date

POSTING

SUCC_APPL_ACCEPT_DATE_2

Size: 11 Format: DD-MMM-YYYY

60=Successful Applicant Comment

POSTING

SUCC_APPL_COMMENT_2

Size: 30

61=Successful Applicant Name

POSTING

SUCC_APPL_NAME_3

Size: 30

61=Successful Applicant Name&No

POSTING

SUCC_APPL_NAME_AND_NO_3

Size: 30

61=Successful Applicant Number

POSTING

SUCC_APPL_EMPLOYEE_NO_3

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

62=Successful Application Accept Date

POSTING

SUCC_APPL_ACCEPT_DATE_3

Size: 11 Format: DD-MMM-YYYY

63=Successful Applicant Comment

POSTING

SUCC_APPL_COMMENT_3

Size: 30

64=Successful Applicant Name

POSTING

SUCC_APPL_NAME_4

Size: 30

64=Successful Applicant Name&No

POSTING

SUCC_APPL_NAME_AND_NO_4

Size: 30

64=Successful Applicant Number

POSTING

SUCC_APPL_EMPLOYEE_NO_4

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

65=Successful Application Accept Date

POSTING

SUCC_APPL_ACCEPT_DATE_4

Size: 11 Format: DD-MMM-YYYY

66=Successful Applicant Comment

POSTING

SUCC_APPL_COMMENT_4

Size: 30

Rage or Salary offerred

POSTING

RATE_OR_SALARY

Size: 10 Format: ########.##

Time Job Posted

POSTING

POSTING_TIME_(24HR-HHMM)

Size: 10