Automated Dispatch Databases / Employee PIN Database
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
Automated Dispatch Databases / Employee Text Notification Profile
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
Employee Search Criteria
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
Refusals
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
Sub/Cas Preferences
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
Unavailability
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |
WBW Refusal
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
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 |