|
XML Tag |
Definition |
Rules |
|
comcorp |
Five digits |
5 digit system number assigned to each corp |
|
dqd_qgrpnum |
One digit |
quota group number; 1 - 8 |
|
dqd_qarea |
1 character field |
1-9, A-Z |
|
dqd_qtaday |
YYYY-MM-DD |
Schedule day being requested; blank = get earliest |
|
w_pts |
Numeric |
Number of points of job |
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
comcorp |
COMCORP |
N |
||
| lastdayrouted | VL-LSTROUTE | Date | N | YYYY-MM-DD, latest day the route select process was run (begins process for creating CDW file and work orders) |
|
dqd_quotagroup |
dqd_quotagroup beginning delimiter |
|||
|
dqd_qtaday |
DQD_QTADAY |
Date |
N |
YYYY-MM-DD |
|
dqd_dayofweek |
DQD_DAYOFWEEK |
5 character field |
N |
|
|
dqd_slotgroup |
dqd_slotgroup beginning delimiter |
|||
|
dqd_slot_number |
DQD_SLOT_NUMBER |
2 digit field |
N |
Slot number; valid values = 1 - 12 |
|
qp_quotaslotdesc |
QP_QUOTASLOTDESC |
10 character field |
||
|
dqd_nedslot |
DQD_NEDSLOT |
SMALLINT UNSIGNED |
N |
Need points for this slot |
|
dqd_havslot |
DQD_HAVSLOT |
SMALLINT UNSIGNED |
N |
Have points for this slot |
|
dqd_statslot |
DQD_STATSLOT |
1 character field |
N |
Status of slot; 1 = open, 2 = closed, 3 = forced open, 4 = less points than required by job |
|
dqd_jobslot |
DQD_JOBSLOT |
SMALLINT UNSIGNED |
N |
Number of jobs schedule in this slot |
|
dqd_mspslot |
DQD_MSPSLOT |
SMALLINT UNSIGNED |
N |
Must do points in this slot |
|
dqd_msjslot |
DQD_MSJSLOT |
SMALLINT UNSIGNED |
N |
Must do jobs in this slot |
|
/dqd_slotgroup |
dqd_slotgroupending delimiter |
|||
|
dqd_nedtot |
DQD_NEDTOT |
SMALLINT UNSIGNED |
Total need points |
|
|
dqd_havtot |
DQD_HAVTOT |
SMALLINT UNSIGNED |
Total have points |
|
|
dqd_jobtot |
DQD_JOBTOT |
SMALLINT UNSIGNED |
Total number of jobs scheduled this day in this schedule area and this quota group. |
|
|
/dqd_quotagroup |
dqd_quotagroup ending delimiter |