Table Definitions - Dispatches

02=PIN

ADS_PIN

PIN_NUMBER

Size: 10

03=Security Code

ADS_PIN

SECURITY_CODE

Size: 4

04=Location 1

ADS_PIN

LOCATION_1

Size: 4

04=Location 1

ADS_PIN

LOCATION_1_NAME

Detailed Explanation of code. Size: 30

05=Location 2

ADS_PIN

LOCATION_2

Size: 4

05=Location 2

ADS_PIN

LOCATION_2_NAME

Detailed Explanation of code. Size: 30

06=Location 3

ADS_PIN

LOCATION_3

Size: 4

06=Location 3

ADS_PIN

LOCATION_3_NAME

Detailed Explanation of code. Size: 30

07=Location 4

ADS_PIN

LOCATION_4

Size: 4

07=Location 4

ADS_PIN

LOCATION_4_NAME

Detailed Explanation of code. Size: 30

08=Location 5

ADS_PIN

LOCATION_5

Size: 4

08=Location 5

ADS_PIN

LOCATION_5_NAME

Detailed Explanation of code. Size: 30

02=Enable Text Messages [Y/N]

ADS_TEXT_MESSAGE_INFO

TEXT_MSG_YN

Size: 10

03=Text Message --> Start Time

ADS_TEXT_MESSAGE_INFO

TEXT_START_TIME

Size: 10

04=Text Message --> End Time

ADS_TEXT_MESSAGE_INFO

TEXT_END_TIME

Size: 10

05=Enable E-Mails [Y/N]

ADS_TEXT_MESSAGE_INFO

EMAIL_MSG_YN

Size: 10

06=E-Mail --> Start Time

ADS_TEXT_MESSAGE_INFO

EMAIL_START_TIME

Size: 10

07=E-Mail --> End Time

ADS_TEXT_MESSAGE_INFO

EMAIL_END_TIME

Size: 10

08=E-Mail Address 1

ADS_TEXT_MESSAGE_INFO

EMAIL_ADDRESS_1

Size: 30

09=E-Mail Address 2

ADS_TEXT_MESSAGE_INFO

EMAIL_ADDRESS_2

Size: 30

10=Use District E-Mail [Y/N]

ADS_TEXT_MESSAGE_INFO

SEND_TO_DIST_EMAIL_YN

Size: 10

11=Cell Phone 1

ADS_TEXT_MESSAGE_INFO

CELL_PHONE_1

Size: 15 Format: (###)###-####

12=Serv Provider 1

ADS_TEXT_MESSAGE_INFO

CELL_1_PROVIDER_CODE

Size: 10

13=Cell Phone 2

ADS_TEXT_MESSAGE_INFO

CELL_PHONE_2

Size: 15 Format: (###)###-####

14=Serv Provider 2

ADS_TEXT_MESSAGE_INFO

CELL_2_PROVIDER_CODE

Size: 10

02=Loc 1

PERM_EMP_SEARCH_CRITERIA

LOCATION_01

Size: 4

02=Loc 1 (Name)

PERM_EMP_SEARCH_CRITERIA

LOCATION_01_NAME

Detailed Explanation of code. Size: 30

03=Loc 2

PERM_EMP_SEARCH_CRITERIA

LOCATION_02

Size: 4

03=Loc 2 (Name)

PERM_EMP_SEARCH_CRITERIA

LOCATION_02_NAME

Detailed Explanation of code. Size: 30

04=Loc 3

PERM_EMP_SEARCH_CRITERIA

LOCATION_03

Size: 4

04=Loc 3 (Name)

PERM_EMP_SEARCH_CRITERIA

LOCATION_03_NAME

Detailed Explanation of code. Size: 30

05=Loc 4

PERM_EMP_SEARCH_CRITERIA

LOCATION_04

Size: 4

05=Loc 4 (Name)

PERM_EMP_SEARCH_CRITERIA

LOCATION_04_NAME

Detailed Explanation of code. Size: 30

06=Loc 5

PERM_EMP_SEARCH_CRITERIA

LOCATION_05

Size: 4

06=Loc 5 (Name)

PERM_EMP_SEARCH_CRITERIA

LOCATION_05_NAME

Detailed Explanation of code. Size: 30

07=Subj 1

PERM_EMP_SEARCH_CRITERIA

SUBJECT_01

Size: 10

07=Subj 1 (Desc)

PERM_EMP_SEARCH_CRITERIA

SUBJECT_01_DESC

Detailed Explanation of code. Size: 30

08=Lev 1

PERM_EMP_SEARCH_CRITERIA

LEVEL_01

Size: 4

08=Lev 1

PERM_EMP_SEARCH_CRITERIA

LEVEL_01_DESC

Detailed Explanation of code. Size: 30

09=Subj 2

PERM_EMP_SEARCH_CRITERIA

SUBJECT_02

Size: 10

09=Subj 2 (Desc)

PERM_EMP_SEARCH_CRITERIA

SUBJECT_02_DESC

Detailed Explanation of code. Size: 30

10=Lev 2

PERM_EMP_SEARCH_CRITERIA

LEVEL_02

Size: 4

11=Subj 3

PERM_EMP_SEARCH_CRITERIA

SUBJECT_03

Size: 10

11=Subj 3 (Desc)

PERM_EMP_SEARCH_CRITERIA

SUBJECT_03_DESC

Detailed Explanation of code. Size: 30

12=Lev 3

PERM_EMP_SEARCH_CRITERIA

LEVEL_03

Size: 4

13=Subj 4

PERM_EMP_SEARCH_CRITERIA

SUBJECT_04

Size: 10

13=Subj 4 (Desc)

PERM_EMP_SEARCH_CRITERIA

SUBJECT_04_DESC

Detailed Explanation of code. Size: 30

14=Lev 4

PERM_EMP_SEARCH_CRITERIA

LEVEL_04

Size: 4

15=Subj 5

PERM_EMP_SEARCH_CRITERIA

SUBJECT_05

Size: 10

15=Subj 5 (Desc)

PERM_EMP_SEARCH_CRITERIA

SUBJECT_05_DESC

Detailed Explanation of code. Size: 30

16=Lev 5

PERM_EMP_SEARCH_CRITERIA

LEVEL_05

Size: 4

17 - 21 --> Names of Requested Employees 1 to 5

PERM_EMP_SEARCH_CRITERIA

REQUESTED_EMP_01_NAME

Size: 30

17 - 21 --> Requested Employees 1 to 5

PERM_EMP_SEARCH_CRITERIA

REQUESTED_EMPLOYEES

Detailed Explanation of code. Size: 100

22=Dispatch Priority

PERM_EMP_SEARCH_CRITERIA

DISPATCH_PRIORITY

Size: 2

02=Refusal Date

REFUSAL

REFUSAL_DATE

Size: 11 Format: DD-MMM-YYYY

03=Part of Day [F/A/P]

REFUSAL

AM_OR_PM

Size: 10

04=Start Time

REFUSAL

START_TIME

Size: 10

05=End Time

REFUSAL

END_TIME

Size: 10

06=Refusal Code

REFUSAL

REASON_CODE

Size: 10

06=Refusal Code

REFUSAL

REASON_DESCRIPTION

Detailed Explanation of code. Size: 30

07=Location

REFUSAL

LOCATION_CODE

Size: 10

07=Location

REFUSAL

LOCATION_NAME

Detailed Explanation of code. Size: 30

08=Comment

REFUSAL

COMMENT

Size: 30

01=Employee

DISPATCH_PREFERENCES

* 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

02=Status

DISPATCH_PREFERENCES

STATUS

Internal Lookup: A=Active, I=Inactive, Size: 2

03=Area Description

DISPATCH_PREFERENCES

AREA_01_DESC

Size: 30

03=Areas

DISPATCH_PREFERENCES

AREA_01_CODE

Size: 4

04=Area Description

DISPATCH_PREFERENCES

AREA_02_DESC

Size: 30

04=Areas

DISPATCH_PREFERENCES

AREA_02_CODE

Size: 4

05=Area Description

DISPATCH_PREFERENCES

AREA_03_DESC

Size: 30

05=Areas

DISPATCH_PREFERENCES

AREA_03_CODE

Size: 4

06=Area Description

DISPATCH_PREFERENCES

AREA_04_DESC

Size: 30

06=Areas

DISPATCH_PREFERENCES

AREA_04_CODE

Size: 4

07=Area Description

DISPATCH_PREFERENCES

AREA_05_DESC

Size: 30

07=Areas

DISPATCH_PREFERENCES

AREA_05_CODE

Size: 4

08=Loc Types

DISPATCH_PREFERENCES

LOCATION_TYPE_01_CODE

Size: 1

08=Location Type Description

DISPATCH_PREFERENCES

LOCATION_TYPE_01_DESC

Size: 30

09=Loc Types

DISPATCH_PREFERENCES

LOCATION_TYPE_02_CODE

Size: 1

09=Location Type Description

DISPATCH_PREFERENCES

LOCATION_TYPE_02_DESC

Size: 30

10=Loc Types

DISPATCH_PREFERENCES

LOCATION_TYPE_03_CODE

Size: 1

10=Location Type Description

DISPATCH_PREFERENCES

LOCATION_TYPE_03_DESC

Size: 30

11=Loc Types

DISPATCH_PREFERENCES

LOCATION_TYPE_04_CODE

Size: 1

11=Location Type Description

DISPATCH_PREFERENCES

LOCATION_TYPE_04_DESC

Size: 30

12=Loc Types

DISPATCH_PREFERENCES

LOCATION_TYPE_05_CODE

Size: 1

12=Location Type Description

DISPATCH_PREFERENCES

LOCATION_TYPE_05_DESC

Size: 30

13=First Subject

DISPATCH_PREFERENCES

SUBJECT_01_CODE

Size: 10

13=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_01_DESC

Size: 30

14=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_01_CODE

Size: 4

14=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_01_DESC

Detailed Explanation of code. Size: 30

15=First Subject

DISPATCH_PREFERENCES

SUBJECT_02_CODE

Size: 10

15=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_02_DESC

Size: 30

16=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_02_CODE

Size: 4

16=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_02_DESC

Detailed Explanation of code. Size: 30

17=First Subject

DISPATCH_PREFERENCES

SUBJECT_03_CODE

Size: 10

17=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_03_DESC

Size: 30

18=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_03_CODE

Size: 4

18=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_03_DESC

Detailed Explanation of code. Size: 30

19=First Subject

DISPATCH_PREFERENCES

SUBJECT_04_CODE

Size: 10

19=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_04_DESC

Size: 30

20=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_04_CODE

Size: 4

20=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_04_DESC

Detailed Explanation of code. Size: 30

21=First Subject

DISPATCH_PREFERENCES

SUBJECT_05_CODE

Size: 10

21=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_05_DESC

Size: 30

22=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_05_CODE

Size: 4

22=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_05_DESC

Detailed Explanation of code. Size: 30

23=First Subject

DISPATCH_PREFERENCES

SUBJECT_06_CODE

Size: 10

23=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_06_DESC

Size: 30

24=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_06_CODE

Size: 4

24=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_06_DESC

Detailed Explanation of code. Size: 30

25=First Subject

DISPATCH_PREFERENCES

SUBJECT_07_CODE

Size: 10

25=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_07_DESC

Size: 30

26=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_07_CODE

Size: 4

26=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_07_DESC

Detailed Explanation of code. Size: 30

27=First Subject

DISPATCH_PREFERENCES

SUBJECT_08_CODE

Size: 10

27=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_08_DESC

Size: 30

28=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_08_CODE

Size: 4

28=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_08_DESC

Detailed Explanation of code. Size: 30

29=First Subject

DISPATCH_PREFERENCES

SUBJECT_09_CODE

Size: 10

29=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_09_DESC

Size: 30

30=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_09_CODE

Size: 4

30=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_09_DESC

Detailed Explanation of code. Size: 30

31=First Subject

DISPATCH_PREFERENCES

SUBJECT_10_CODE

Size: 10

31=First Subject Description

DISPATCH_PREFERENCES

SUBJECT_10_DESC

Size: 30

32=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_10_CODE

Size: 4

32=Level (First Subject)

DISPATCH_PREFERENCES

LEVEL_10_DESC

Detailed Explanation of code. Size: 30

33=Second Subject

DISPATCH_PREFERENCES

SUBJECT2_01_CODE

Size: 10

33=Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_01_DESC

Size: 30

34=Level (Second Subject)

DISPATCH_PREFERENCES

LEVEL2_01_CODE

Size: 4

34=Level (Second Subject)

DISPATCH_PREFERENCES

LEVEL2_01_DESC

Detailed Explanation of code. Size: 30

35=Second Subject

DISPATCH_PREFERENCES

SUBJECT2_02_CODE

Size: 10

35=Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_02_DESC

Size: 30

36=Level (Second Subject)

DISPATCH_PREFERENCES

LEVEL2_02_CODE

Size: 4

36=Level (Second Subject)

DISPATCH_PREFERENCES

LEVEL2_02_DESC

Detailed Explanation of code. Size: 30

37=Second Subject

DISPATCH_PREFERENCES

SUBJECT2_03_CODE

Size: 10

37=Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_03_DESC

Size: 30

38=Level (Second Subject)

DISPATCH_PREFERENCES

LEVEL2_03_CODE

Size: 4

38=Level (Second Subject)

DISPATCH_PREFERENCES

LEVEL2_03_DESC

Detailed Explanation of code. Size: 30

39=Com1

DISPATCH_PREFERENCES

COMMENT_01

Size: 80

40=Com2

DISPATCH_PREFERENCES

COMMENT_02

Size: 80

41=Dispatching Subgroup

DISPATCH_PREFERENCES

SUB_GROUP_KEY

Size: 5

All Level Descriptions

DISPATCH_PREFERENCES

ALL_LEVEL_DESCS

Fields: 14,16,18,20,22,24,26,28,30,32 Size: 50

Area Description

DISPATCH_PREFERENCES

ALL_AREA_DESCS

Fields: 03,04,05,06,07 Size: 50

Areas

DISPATCH_PREFERENCES

ALL_AREA_CODES

Fields: 03,04,05,06,07 Size: 50

Current Status

DISPATCH_PREFERENCES

ADS_STATUS

i.e. Active Teacher On Call Size: 3

First Level Codes

DISPATCH_PREFERENCES

ALL_LEVEL_CODES

Fields: 14,16,18,20,22,24,26,28,30,32 Size: 50

First Subject Codes

DISPATCH_PREFERENCES

ALL_SUBJECT_CODES

Fields: 13,15,17,19,21,23,25,27,29,31 Size: 50

First Subject Descriptions

DISPATCH_PREFERENCES

ALL_SUBJECT_DESCS

Fields: 13,15,17,19,21,23,25,27,29,31 Size: 50

First Subject and Level Codes

DISPATCH_PREFERENCES

ALL_SUB_LEV_CODES

Fields 13 to 32 Size: 50

First Subject and Level Descriptions

DISPATCH_PREFERENCES

ALL_SUB_LEV_DESCS

Fields 13 to 32 Size: 50

Future call count

DISPATCH_PREFERENCES

FUTURE_CALL_COUNT

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

Last Date Called

DISPATCH_PREFERENCES

CALL_DATE

Size: 11 Format: DD-MMM-YYYY

Loc Type Codes

DISPATCH_PREFERENCES

ALL_LOCATION_TYPE_CODES

Fields: 08,09,10,11,12 Size: 50

Location Type Descriptions

DISPATCH_PREFERENCES

ALL_LOCATION_TYPE_DESCS

Fields: 08,09,10,11,12 Size: 50

Number of times called

DISPATCH_PREFERENCES

CALL_DATE_COUNT

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

Priority

DISPATCH_PREFERENCES

DISPATCH_DIST_PRIORITY

Size: 10

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_04_CODE

Size: 4

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_05_CODE

Size: 4

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_06_CODE

Size: 4

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_07_CODE

Size: 4

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_08_CODE

Size: 4

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_09_CODE

Size: 4

Second Level Code

DISPATCH_PREFERENCES

LEVEL2_10_CODE

Size: 4

Second Level Codes

DISPATCH_PREFERENCES

ALL_2_LEVEL_CODES

Fields: 34,36,38 Size: 50

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_04_DESC

Size: 30

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_05_DESC

Size: 30

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_06_DESC

Size: 30

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_07_DESC

Size: 30

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_08_DESC

Size: 30

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_09_DESC

Size: 30

Second Level Description

DISPATCH_PREFERENCES

LEVEL2_10_DESC

Size: 30

Second Level Descriptions

DISPATCH_PREFERENCES

ALL_2_LEVEL_DESCS

Fields: 34,36,38 Size: 50

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_04_CODE

Size: 10

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_05_CODE

Size: 10

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_06_CODE

Size: 10

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_07_CODE

Size: 10

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_08_CODE

Size: 10

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_09_CODE

Size: 10

Second Subject Code

DISPATCH_PREFERENCES

SUBJECT2_10_CODE

Size: 10

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_04_DESC

Size: 30

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_05_DESC

Size: 30

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_06_DESC

Size: 30

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_07_DESC

Size: 30

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_08_DESC

Size: 30

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_09_DESC

Size: 30

Second Subject Description

DISPATCH_PREFERENCES

SUBJECT2_10_DESC

Size: 30

Second Subject Descriptions

DISPATCH_PREFERENCES

ALL_2_SUBJECT_DESCS

Fields: 33,35,37 Size: 50

Second Subject and Level Codes

DISPATCH_PREFERENCES

ALL_2_SUB_LEV_CODES

Fields: 33 to 38 Size: 50

Second Subject and Level Descriptions

DISPATCH_PREFERENCES

ALL_2_SUB_LEV_DESCS

Fields: 33 to 38 Size: 50

Second Subjects

DISPATCH_PREFERENCES

ALL_2_SUBJECT_CODES

Fields: 33,35,37 Size: 50

01=Location Code

DISPATCH_PREFERENCES

LOC_CODE_WILL_WORK_AT

First Location choice to work at Size: 4

01=Location Name

DISPATCH_PREFERENCES

LOC_NAME_WILL_WORK_AT

First Location choice to work at Size: 30

Location Codes

DISPATCH_PREFERENCES

LOC_CODES_WILL_NOT_WORK_AT

Locations where employee will not work Size: 30

Location Codes

DISPATCH_PREFERENCES

LOC_CODES_WILL_OR_WONT_WORK_AT

Size: 30

Location Codes

DISPATCH_PREFERENCES

LOC_CODES_WILL_WORK_AT

Locations where employee will work at. Fields 01 to 34 Size: 30

Location Names

DISPATCH_PREFERENCES

LOC_NAMES_WILL_NOT_WORK_AT

Locations where employee will NOT work Size: 30

Location Names

DISPATCH_PREFERENCES

LOC_NAMES_WILL_OR_WONT_WORK_AT

Size: 30

Location Names

DISPATCH_PREFERENCES

LOC_NAMES_WILL_WORK_AT

Locations where employee will work at. Fields 01 to 34 Size: 30

Group Key

DISPATCH_PREFERENCES

GROUP_KEY

Size: 10

Group Key / Sub Group

DISPATCH_PREFERENCES

GROUP_AND_SUB_GROUP_KEY

Size: 10

Last Called

DISPATCH_PREFERENCES

LAST_PHONED_DATE

Size: 20 Format: DD-MMM-YYYY H

Last Worked

DISPATCH_PREFERENCES

LAST_WORKED_DATE

Size: 11 Format: DD-MMM-YYYY

Refusals

DISPATCH_PREFERENCES

REFUSAL_COUNT

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

Sort Key

DISPATCH_PREFERENCES

SORT_KEY

Size: 30

03=Comment

DISPATCHES

COMMENT

Size: 80

05=Tentative

DISPATCHES

TENTATIVE

Internal Lookup: Y=Yes, N=No, Size: 4

12=Cost Centre

DISPATCHES

COST_CENTER

Size: 10

02=Start Date

UNAVAILABILITY

START_DATE

Size: 11 Format: DD-MMM-YYYY

03=End Date

UNAVAILABILITY

END_DATE

Size: 11 Format: DD-MMM-YYYY

03=End Date

UNAVAILABILITY

END_DATE_NO_BLANKS

Size: 11 Format: DD-MMM-YYYY

04=Refusal Code

UNAVAILABILITY

REASON

Size: 6

04=Refusal Code

UNAVAILABILITY

REASON_DESCRIPTION

Detailed Explanation of code. Size: 30

05=Portions of Days

UNAVAILABILITY

WEEK_DAYS

Size: 7

05=Portions of Days

UNAVAILABILITY

WEEK_DAYS WITH DOTS

Size: 7

06=Start Time

UNAVAILABILITY

MONDAY_START_TIME

Size: 10

07=End Time

UNAVAILABILITY

MONDAY_END_TIME

Size: 10

08=Start Time

UNAVAILABILITY

TUESDAY_START_TIME

Size: 10

09=End Time

UNAVAILABILITY

TUESDAY_END_TIME

Size: 10

10=Start Time

UNAVAILABILITY

WEDNESDAY_START_TIME

Size: 10

11=End Time

UNAVAILABILITY

WEDNESDAY_END_TIME

Size: 10

12=Start Time

UNAVAILABILITY

THURSDAY_START_TIME

Size: 10

13=End Time

UNAVAILABILITY

THURSDAY_END_TIME

Size: 10

14=Start Time

UNAVAILABILITY

FRIDAY_START_TIME

Size: 10

15=End Time

UNAVAILABILITY

FRIDAY_END_TIME

Size: 10

16=Start Time

UNAVAILABILITY

SATURDAY_START_TIME

Size: 10

17=End Time

UNAVAILABILITY

SATURDAY_END_TIME

Size: 10

18=Start Time

UNAVAILABILITY

SUNDAY_START_TIME

Size: 10

19=End Time

UNAVAILABILITY

SUNDAY_END_TIME

Size: 10

20=Comment

UNAVAILABILITY

COMMENT

Size: 40

Friday Caption

UNAVAILABILITY

FRIDAY

Size: 11

Monday Caption

UNAVAILABILITY

MONDAY

Size: 11

Saturday Caption

UNAVAILABILITY

SATURDAY

Size: 11

Sunday Caption

UNAVAILABILITY

SUNDAY

Size: 11

Thursday Caption

UNAVAILABILITY

THURSDAY

Size: 11

Tuesday Caption

UNAVAILABILITY

TUESDAY

Size: 11

Wednesday Caption

UNAVAILABILITY

WEDNESDAY

Size: 11

Absence ID (Internal)

WBW_REFUSAL

LONG_ABSENCE_ID

Size: 14

Employee Name

WBW_REFUSAL

CREATOR_EMPLOYEE_NAME

Size: 30

Employee Number

WBW_REFUSAL

CREATOR_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

Timestamp

WBW_REFUSAL

REFUSAL_TIMESTAMP

When tiime was refusal done? Size: 20 Format: DD-MMM-YYYY H

Voice ID

WBW_REFUSAL

SHORT_ABSENCE_ID

Size: 10