GetWIPInfo

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

cust

Two digit customer number

wpcnt

Single digit WIP Count value from GetCustomerInfo API columns hwstat, tcstat, srostat

XML Tag

Column Name

Data Type

Nullable

Definition

wipmastergroup

Beginning wipmastergroup delimiter

wipmasterrow

Beginning wipmasterrow delimiter

w_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system.

w_partition

PARTITION

CHAR(2)

N

Data hashing value for database management - equals the last 2 digits of the house #.

w_house

HOUSE

CHAR(6)

N

House number. Valid Values: Alpha/Numeric

w_cust

CUST

CHAR(2)

N

Customer number.

w_wpcnt

WPCNT

CHAR(1)

N

Is a counter to link wip records.A wpcnt of '5' would link all records with wpcnt 5 to one transactn. Valid Values: The next transaction would have wpcnt '6' and so forth. Links the house, wip, wip com ment

w_wpcddate

WPCDDATE

DATETIME

Y

Schedule date for this job.

w_tech

TECH

SMALLINT UNSIGNED

N

Tech or installer number. Valid Values: 1 thru 999

w_dslot

DSLOT

INT UNSIGNED

N

Number indicating position of a job within a tech's work for that day. Valid Values: Minumum value = 1000

w_dseq

DSEQ

CHAR(3)

N

Sequence of this job in the total work assigned to the technician.

w_wstat

Beginning w_wstat delimiter

code

WSTAT

CHAR(1)

N

Status of this job 1=p/in 2=p/rs 3=p/ch 4=p/ds 5=cp/in 6=cp/rs7=cp/ch. Valid Values: 8=cp/ds a=x/in b=x/rs c=x/ch d=x/ds f=p/tc g=x/tc h=cp/tc i=p/sr j=x/sr k=cp/sr

description

CHAR(8)

N

Wip Status Description

/w_wstat

Ending w_wstat delimiter

w_wform

WFORM

CHAR(1)

N

Billing form.

w_wmode

WMODE

CHAR(1)

N

Billing mode.

w_wmsg

WMSG

CHAR(2)

N

Message number on Pay 80 to use for this customer's bill.

w_wdiscnt

Beginnign w_wdiscnt delimiter

code

WDISCNT

CHAR(1)

N

Discount code.

shortdescription

CHAR(8)

Discount code short description

longdescription

CHAR(20)

Discount code long description

/w_wdiscnt

Ending w_wdiscnt delimiter

w_pts

PTS

SMALLINT UNSIGNED

N

Quota points for this job.

w_wrem

WREM

CHAR(1)

N

Reminder Scheme. Valid Values: A-D only

w_wcycle

WCYCLE

CHAR(1)

N

Billing cycle code. Valid Values: A-D

w_wordate

WORDATE

DATETIME

N

Date the order was keyed

w_wpro

Beginning w_pro delimiter

code

WPRO

CHAR(1)

N

Prorate plan number.

shortdescription

CHAR(8)

Prorate plan short description

longdescription

CHAR(20)

Prorate plan long description

/w_wpro

Ending w_wpro delimiter

w_wsent

WSENT

SMALLINT UNSIGNED

N

Indicates at what status the disconnect was sent to DDP Financials. Valid Values: 1=pending disconnect,2=completed disconnect

w_wloc

WLOC

CHAR(3)

N

Locator.

w_w1st5

W1ST5

CHAR(5)

N

First 5 characters of street name.

w_slsrep

SLSREP

CHAR(3)

N

Sales rep who sold this account.

w_wjob

Beginning w_wjob delimiter

code

WJOB

SMALLINT UNSIGNED

N

Designates Job type. Valid Values: 1=install, 2=restart, 3=change, 4=disconnect 7=trouble call 8= SRO

description

CHAR(20)

Job type description

/w_wjob

Ending w_wjob delimiter

w_adlotlcnt

ADLOTLCNT

SMALLINT UNSIGNED

N

Total outlet count for this job. Valid Values: 1-6

w_wresc

WRESC

SMALLINT UNSIGNED

N

Number of times the job has been rescheduled.

w_wcampg

Beginning w_wcampg delimiter

code

WCAMPG

CHAR(1)

N

Campaign code on this job.

shortdescription

CHAR(8)

Campaign code short description

longdescription

CHAR(20)

Campaign code long description

/w_wcampg

Ending w_wcampg delimiter

w_wsalrn

Beginning w_wsalrn delimiter

code

WSALRN

CHAR(1)

N

Sales reasonon this job.

shortdescription

CHAR(8)

Sales reason short description

longdescription

CHAR(20)

Sales reason long description

/w_wsalrn

Ending w_wsalrn delimiter

w_wproty

Beginning w_wproty delimiter

code

WPROTY

CHAR(2)

N

Job Priority - if trouble call then the priority is the 1st problem code..otherwise from pri table.

shortdescription

CHAR(8)

Job priority - short description

longdescription

CHAR(20)

Job priority - long description

/w_wproty

N

Ending w_wproty delimiter

w_wspcl1

N

Beginning w_wspcl1 delimiter

code

WSPCL[1]

CHAR(1)

N

Special instruction codes.

shortdescription

CHAR(8)

Campaign code short description

longdescription

CHAR(20)

Campaign code long description

/w_wspcl1

Ending w_wspcl1 delimiter

w_wspcl2

Beginning w_wspcl2 delimiter

code

WSPCL[2]

CHAR(1)

Special instruction codes.

shortdescription

CHAR(8)

Campaign code short description

longdescription

CHAR(20)

Campaign code long description

/w_wspcl2

Ending w_wspcl2 delimiter

w_wspcl3

Beginning w_wspcl3 delimiter

code

WSPCL[3]

CHAR(1)

Special instruction codes.

shortdescription

CHAR(8)

Campaign code short description

longdescription

CHAR(20)

Campaign code long description

/w_wspcl3

Ending w_wspcl3 delimiter

w_wcomt

WCOMT

CHAR(1)

N

Flag indicating comment exists in the comment table.

w_wtimcd

Beginning w_wtimcd delimiter

code

WTIMCD

CHAR(1)

N

Time code preferred by customer.

shortdescription

CHAR(8)

Time code short description

longdescription

CHAR(20)

Time code long description

/w_wtimcd

Ending w_wtimcd delimiter

w_wcod

Beginning w_wcod delimiter

code

WCOD

CHAR(1)

N

User defined COD code. Valid Values: any valid value in the =CODTABLEset up in Dir. Maint - Control Tables

shortdescription

CHAR(8)

Order reason short description

longdescription

CHAR(20)

Order reason long description

/w_wcod

Ending w_wcod delimiter

w_wncomt

WNCOMT

CHAR(1)

N

Flag indicating an order comment exists in the comment table.

w_wordrsn

Beginning w_wordrsn delimiter

code

WORDRSN

CHAR(1)

N

Order reason.

shortdescription

CHAR(8)

Order reason short description

longdescription

CHAR(30)

Order reason long description

/w_wordrsn

Ending w_wordrsn delimiter

w_wchrsn

B eginning w_wchrsn delimiter

code

WCHRSN

CHAR(1)

N

Reason for the change of service.

shortdescription

CHAR(8)

Change of service reason short description

longdescription

CHAR(20)

Change of service reason long description

/w_wchrsn

Ending w_wchrsn delimiter

w_wquota

WQUOTA

SMALLINT UNSIGNED

N

Quota group number. Valid Values: 1-8

w_wbsentdt

WBSENTDT

DATETIME

Y

Date the bill was sent.

w_whwseq

WHWSEQ

CHAR(1)

N

Honeywell sequence number used by Pay 80 to process/charge this customer.

w_wbdate

WBDATE

DATETIME

Y

Start/stop bill date for the order.

w_wcdrsn

Beginning w_wcdrsn delimiter

code

WCDRSN

CHAR(1)

N

Disconnect reason.

shortdescription

CHAR(8)

Disconnect reason short description

longdescription

CHAR(20)

Disconnect reason long description

/w_wcdrsn

Ending w_wcdrsn delimiter

w_wchdate

WCHDATE

DATETIME

N

Last change date.

w_wchprog

Beginning w_wchprog delimiter

code

WCHPROG

SMALLINT UNSIGNED

N

Last program which changed this order. Valid Values: 1=O/E,2=Disp,3=Chkin,4=DB Maint,5=Post,6=Coll Run7=Cyc Upd,9=ARU,10=Coll Chg,11=PPV Charge,12=H/C Maint,13=Pay/Adj,14=Lockbox,15=PPV Maint,16=Cutoff

description

CHAR (20)

N

/w_wchprog

Ending w_wchprog delimiter

w_worchg

WORCHG

CHAR(1)

N

Flag indicating order was changed at check-in. Valid Values: 1 = was changed at checkin

w_wpdper

WPDPER

CHAR(1)

N

Period code the hot tap disconnect was setn to DDP Financials.

w_wordtime

WORDTIME

DATETIME

Y

Time wip comment was entered during a rescheduleor current time if no-sched or current time whendispatch status changes or prev entered or currenttime when completed in Check-In.. Valid Values: A valid time.

w_wrdate

WRDATE

DATETIME

Y

Written when job completed...if cdw job is the schedule date...if no truck is the date completed.

w_wdwo

WDWO

CHAR(1)

N

DWO flag. Valid Values: 1=Non-pay Disconnect (NPD) order

w_wperiod

WPERIOD

CHAR(1)

N

Period code this WIP record was completed. Valid Values: a-x

w_widate

WIDATE

DATETIME

Y

Work done date.

w_wfindate

WFINDATE

DATETIME

Y

Date the job was checked in or no truck completed.

w_wfinprg

Beginning w_wfinprg delimiter

code

WFINPRG

SMALLINT UNSIGNED

N

Program that finalized this job. Valid Values: 1= o/e, 2 = dispatch, 3 = check- in, 4 = nightlies 5 = posting, 6 = collections, 7 = mone status, 8

description

CHAR(20)

Finalization program description.

/w_wfinprg

Ending w_wfinprg delimiter

w_wnwdrp

WNWDRP

CHAR(1)

N

Flag indicating new drop. Valid Values: 1=new drop

w_wntrk

WNTRK

SMALLINT UNSIGNED

N

No truck type order. Valid Values: 1 = No Truck order

w_wadvnc

WADVNC

CHAR(1)

N

Order has advance start/stop date. Valid Values: 1 = advance service order

w_dccomplete

Beginning w_dccomplete delimiter

code

DCCOMPLETE

CHAR(1)

N

CDW status. Valid Values: 1=complete,2=not done,3=alert#,4=next 5=reschedule,6=cancel,9=reassign

description

CHAR(20)

CDW Status description.

/w_dccomplete

Ending w_dccomplete delimiter

w_sa

SA

CHAR(1)

N

Schedule area. Valid Values: 1-9,a-z

w_dwoprt

DWOPRT

CHAR(1)

N

Work order print flag. Valid Values: 1=printed

w_calrt

CALRT

CHAR(1)

N

Checkin alert flag. Valid Values: 1=no auto checkin allowed for this job

w_dmoney

DMONEY

NUMERIC SIGNED

N

Money collected on this job.

w_wcxrsn

Beginning w_wcxrsn delimiter

code

WCXRSN

CHAR(1)

N

Cancel reason code.

shortdescription

CHAR(8)

Cancel reason short description

longdescription

CHAR(20)

Cancel reason long description.

/w_wcxrsn

Ending w_wcxrsm delimiter

w_who

WHO

CHAR(3)

N

ID of the operator responsible for taking this order. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API

w_tccomtim

TCCOMTIM

DATETIME

Y

Trouble call complete time.

w_tcrectim

TCRECTIM

DATETIME

Y

Trouble call receive time.

w_routing

Beginning w_routing delimiter

code

ROUTING

CHAR(1)

N

Routing flag. Valid Values: blank=not routed,S=selected,1=in the CDW,2=in the pool

description

CHAR (20)

N

/w_routing

Ending w_routing delimiter

w_schdat

SCHDAT

DATETIME

Y

Day the job is scheduled to be done.. Valid Values: NULL= no schedule, $$$ = no truck

w_mgt

MGT

SMALLINT UNSIGNED

N

Management area for this record.

w_ftax

FTAX

SMALLINT UNSIGNED

N

Franchise area for this house. Valid Values: 1-99

w_cvrprt

CVRPRT

CHAR(1)

N

Cover sheet printed for this order. Valid Values: 1=printed

w_rtecardnbr

RTECARDNBR

SMALLINT UNSIGNED

N

Route card number.

w_poolflag

POOLFLAG

SMALLINT UNSIGNED

N

This job is in the pool. Valid Values: 1= in pool

w_changeopr

CHANGEOPR

CHAR(3)

N

Operator who cancelled or rescheduled the job. Valid Values:

w_qtaslot

Beginning w_qtaslot delimiter

code

QTASLOT

SMALLINT SIGNED

N

Quota slot.

shortdescription

CHAR(8)

Quota slot short description qgtsmnxx field from =quotaparams table.

longdescription

CHAR(20)

Quota slot long description qgtsxx field from the =quotaparams table

/w_qtaslot

Ending w_qtaslot delimiter

w_mustdo

MUSTDO

CHAR(6)

w_newmovein

CHAR(6)

w_notrkreason

Beginning w_notrkreason delimiter

code

NOTRKREASON

CHAR(1)

N

No Truck Reason Code from 36 code table. Valid Values: 0-9,A-Z

shortdescription

CHAR(8)

No Truck Reason short description

longdescription

CHAR(20)

No Truck Reason long description.

/w_notrkreason

Ending w_notrkreason delimiter

w_annivday

ANNIVDAY

SMALLINT SIGNED

N

Day of the month specified as the customer's anniversary day. Valid Values: 1-31

w_schedondate

SCHEDONDATE

DATETIME

Y

The last date a reschedule happen or if not rescheduled then the order date...the last time scheduli. Valid Values: ng happen. If a 'no schedule' the date is null.

w_compliance

Beginning w_compliance delimiter

code

COMPLIANCE

SMALLINT UNSIGNED

N

If within the compliance parameters or not...type of compliance.. Valid Values: 0=not tracked or no sched 1=in compliance 2=out ofcompliance 3=out/custom 4=out/cust req 5=notruck

description

CHAR(30)

Compliance type description.

/w_compliance

Ending w_compliance delimiter

w_busdays

BUSDAYS

SMALLINT UNSIGNED

N

Number of business days it took to get the job done.. Valid Values: 0=same day 1=next day 2=2 days out etc

w_tcstartby

TCSTARTBY

DATETIME

Y

Date/Time the technician must begin work for alljob types to be in compliance.. Valid Values: date/time - year to minute

w_reschnotdone

Beginning w_reschnotdone delimiter

code

RESCHNOTDONE

SMALLINT SIGNED

N

0=default, 1=reschedule, 2=not done. Valid Values: 0=default, 1=reschedule, 2=not done

description

CHAR(20)

Reschedule/Not Done description.

/w_reschnotdone

Ending w_reschnotdone delimiter

w_svcintrpt

SVCINTRPT

CHAR(1)

N

Y=this is a service interrupt. Valid Values: Y or N

w_beginwork

BEGINWORK

DATETIME

Y

The date and time this job was started after the tech arrived at the house.. Valid Values: date/time - year to minute

w_cdwsortvar

CDWSORTVAR

VARCHAR(66)

Y

Holds variable sort sequence for Route Selectsfinal sort operation.. Valid Values: holds combination of housemaster & wipmastervariables

w_ordertime

ORDERTIME

DATETIME

Y

Order time.

/wipmasterrow

Ending wipmasterrow delimiter

wipmastergroup

Ending wipmastergroup delimiter

wipoutletgroup

Beginning wipoutletgroup delimiter

wipoutletrow

Beginning wipoutletrow delimiter

wo_wpcnt

WPCNT

CHAR(1)

N

Is a counter to link wip records.A wpcnt of '5' would link all records with wpcnt 5 to one transaction. Valid Values: The next transaction would have wpcnt '6' and so forth. Links the house, wip, wip comment

wo_outlet

OUTLET

SMALLINT SIGNED

N

Outlet number. Valid Values: 1-60

wo_serl

SERL

CHAR(14)

N

Box serial number on this outlet.

wo_task01

Beginning wo_task01 delimiter

code

TASK01

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task01

Ending wo_task01 delimiter

wo_task02

Beginning wo_task02 delimiter

code

TASK02

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task02

Ending wo_task02 delimiter

wo_task03

Beginning wo_task03 delimiter

code

TASK03

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task03

Ending wo_task03 delimiter

wo_task04

Beginning wo_task04 delimiter

code

TASK04

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task04

Endingng wo_task04 delimiter

wo_task05

Beginning wo_task05 delimiter

code

TASK05

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task05

Ending wo_task05 delimiter

wo_task06

Beginning wo_task06 delimiter

code

TASK06

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task06

Ending wo_task06 delimiter

wo_task07

Beginning wo_task07 delimiter

code

TASK07

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task07

Ending wo_task07 delimiter

wo_task08

Beginning wo_task08 delimiter

code

TASK08

CHAR(2)

N

Task/problem code depending on job type.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_task08

Ending wo_task08 delimiter

wo_fixed01

Beginning wo_fixed01 delimiter

code

FIXED01

CHAR(2)

N

User defined codes identifying fix.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_fixed01

Ending wo_fixed01 delimiter

wo_fixed02

Beginning wo_fixed02 delimiter

code

FIXED02

CHAR(2)

N

User defined codes identifying fix.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_fixed02

Ending wo_fixed02 delimiter

wo_fixed03

Beginning wo_fixed03 delimiter

code

FIXED03

CHAR(2)

N

User defined codes identifying fix.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_fixed03

Ending wo_fixed03 delimiter

wo_fixed04

Beginning wo_fixed04 delimiter

code

FIXED04

CHAR(2)

N

User defined codes identifying fix.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_fixed04

Ending wo_fixed04 delimiter

wo_fixed05

Beginning wo_fixed05 delimiter

code

FIXED05

CHAR(2)

N

User defined codes identifying fix.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_fixed05

Ending wo_fixed05 delimiter

wo_fixed06

Beginning wo_fixed06 delimiter

code

FIXED06

CHAR(2)

N

User defined codes identifying fix.

shortdescription

CHAR(8)

short description

longdescription

CHAR(20)

long description

/wo_fixed06

Ending wo_fixed06 delimiter

wo_bxret

Beginning wo_bxret delimiter

code

BXRET

CHAR(1)

N

Box return reason code.

shortdescription

CHAR(8)

Outlet location short description

longdescription

CHAR(30)

Outlet location long description

/wo_bxret

Beginning wo_bxret delimiter

wo_boxloc

Beginning wo_boxloc delimiter

code

BOXLOC

CHAR(1)

N

Outlet location code.

shortdescription

CHAR(8)

Outlet location short description

longdescription

CHAR(20)

Outlet location long description

/wo_boxloc

Ending wo_boxloc delimiter

wo_tskct01

TSKCT01

CHAR(2)

N

Item count for task count '11'.

wo_tskct02

TSKCT02

CHAR(2)

N

Item count for task count '22'.

wo_tskct03

TSKCT03

CHAR(2)

N

Item count for task count '33'.

wo_tskct04

TSKCT04

CHAR(2)

N

Item count for task count '44'.

wo_tskct05

TSKCT05

CHAR(2)

N

Item count for task count '55'.

wo_pts

PTS

SMALLINT UNSIGNED

N

Quota points for this job.

wo_chngprg

Beginning wo_chgprg delimiter

code

CHNGPRG

CHAR(1)

N

Program that made the change. Valid Values: 1=WIP, 2=T/C, 3=SRO, *=opt. 13, +=box maint

description

CHAR(20)

description

/wo_chngprg

Ending wo_chgprg delimiter

wo_addleq

ADDLEQ

CHAR(8)

N

Any additional equipment information pertaining tothis box, such as remote control number.

wo_pin

PIN

CHAR(4)

N

Personal identification number for ppv.

wo_rating

Beginning wo_rating delimiter

code

RATING

CHAR(1)

N

Events rating flag OR percentage of TV householdsviewing at an interval time. Valid Values: 0=NR 1=G 2=PG 3=PG13 4=NC17 5=R 6=X or 0-100

description

CHAR(20)

description

/wo_rating

Ending wo_rating delimiter

wo_ppv

PPV

CHAR(1)

N

PPV enable flag.

wo_emgflg

EMGFLG

CHAR(1)

N

Emergency authorization flag on this outlet.

/wipoutletrow

Ending wipoutletrow delimiter

/wipoutletgroup

Ending wipoutletgroup delimiter

wipordcommsgroup

Begiing wipordcommsgroup delimiter

wipordcommsrow

Beginning wipordcommsrow delimiter

woc_comtyp

Beginning woc_comtyp delimiter

code

COMTYP

CHAR(1)

N

Type of comment record in WIPORDCOMMS will be N,W. Valid Values: n = order, w = wip

description

CHAR(20)

description

/woc_comtyp

Ending woc_comtyp delimiter

woc_wpcomcnt

WPCOMCNT

CHAR(1)

N

WIP Comment Counter.

woc_opr

OPR

CHAR(3)

N

ID of the operator responsible for latest transaction. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API

woc_tmstp

TMSTP

DATETIME

N

Timestamp of when the comment was keyed.

woc_commt

COMMT

VARCHAR(350)

N

Text of a free form comment.

/wipordcommsrow

Ending wipordcommsrow delimiter

/wipordcommsgroup

Ending wipordcommsgroup delimiter

wipotlrategroup

Beginning wipotlrategroup delimiter

wipotlraterow

Beginning wipotlraterow delimiter

wor_wpcnt

WPCNT

CHAR(1)

N

Is a counter to link wip records.A wpcnt of '5' would link all records with wpcnt 5 to one transactn. Valid Values: The next transaction would have wpcnt '6' and so forth. Links the house, wip, wip com ment

wor_outlet

OUTLET

SMALLINT SIGNED

N

Outlet number. Valid Values: 1-60

wor_ratecd

Beginning wor_ratecd delimiter

code

RATECD

CHAR(2)

N

Rate code associated with this charge level.

shortdescription

CHAR(8)

Rate code short description

longdescription

CHAR(30)

Rate code long description

/wor_ratecd

Ending wor_ratecd delimiter

wor_cnt

CNT

SMALLINT UNSIGNED

N

Rate code count for the service on this outlet *OR* collection forecast step count.

/wipotlraterow

Ending wipotlraterow delimiter

/wipotlrategroup

Ending wipotlrategroup

cdwhistorygroup

Beginning cdwhistorygroup delimiter

cdwhistoryrow

Beginning cdwhistoryrow delimiter

cdwh_corp

CORP

CHAR(5)

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system.

cdwh_cddate

CDDATE

DATETIME

N

Schedule date for this job.

cdwh_tech

TECH

SMALLINT UNSIGNED

N

Tech or installer number. Valid Values: 1 thru 999

cdwh_dslot

DSLOT

INT UNSIGNED

N

Number indicating position of a job within a tech's work for that day. Valid Values: Minumum value = 1000

cdwh_totech

TOTECH

SMALLINT UNSIGNED

N

Tech job has been reassigned to.

cdwh_toseq

TOSEQ

CHAR(3)

N

New job number in the 'reassigned to' technicians list of jobs.

cdwh_pts

PTS

SMALLINT UNSIGNED

N

Quota points for this job.

cdwh_qtaslot

QTASLOT

SMALLINT SIGNED

N

Quota slot.

cdwh_dcstat

DCSTAT

CHAR(1)

N

Job status keyed in dispatch. Valid Values: 1=complete,2=not done,3=Alert#,4=Next,5=reschedule6=cancel,9=reassign

cdwh_dcstat_desc

CHAR(20)

description

cdwh_wordrsn

Beginning cdwh_wordrsn delimiter

code

WORDRSN

CHAR(1)

N

Order reason.

shortdescription

CHAR(8)

order reason short description

longdescription

CHAR(30)

order reason long description

/cdwh_wordrsn

Ending cdwh_wordrsn delimiter

cdwh_wproty

Beginning cdwh_wproty delimiter

code

WPROTY

CHAR(2)

N

Job Priority - if trouble call then the priority is the 1st problem code..otherwise from pri table.

shortdescription

CHAR(8)

Job priority - short description

longdescription

CHAR(30)

Job prirority - long description

/cdwh_wproty

Ending cdwh_wproty delimiter

cdwh_disptime

DISPTIME

DATETIME

Y

Time dispatch assigned the job to a tech.

cdwh_who

WHO

CHAR(3)

N

ID of the operator responsible for taking this order. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API

cdwh_flash

FLASH

CHAR(1)

N

Code indicating the status of a flash at the tech or amp level. Valid Values: Amp table 1=not acknowledged, 2=acknowledged CDW *=acknowledged, $=not acknowledged

cdwh_wtimcd

WTIMCD

CHAR(1)

N

Time code preferred by customer.

cdwh_wjob

WJOB

SMALLINT UNSIGNED

N

Designates Job type. Valid Values: 1=install, 2=restart, 3=change, 4=disconnect 7=trouble call 8= SRO

cdwh_wloc

WLOC

CHAR(3)

N

Locator.

cdwh_chkinstat

CHKINSTAT

CHAR(1)

N

Check-in status. Valid Values: 1=checkin started

cdwh_arucp

ARUCP

CHAR(1)

N

Flag indicating the job was dispatch completed by an ARU. Valid Values: 1=complete

cdwh_chngtime

CHNGTIME

DATETIME

Y

Most recent time the job was last changed.

cdwh_fromtech

FROMTECH

SMALLINT UNSIGNED

N

The tech# this job was reassigned from in dispatch.

cdwh_fromseq

FROMSEQ

CHAR(3)

N

The sequence number of the from tech's job that was reassigned in dispatch.

cdwh_calrt

CALRT

CHAR(1)

N

Checkin alert flag. Valid Values: 1=no auto checkin allowed for this job

cdwh_dseq

DSEQ

CHAR(3)

N

Sequence of this job in the total work assigned to the technician.

cdwh_wkordprt

WKORDPRT

SMALLINT SIGNED

N

Denotes if work order has been printed. Valid Values: 1=work order printed

cdwh_cvrprt

CVRPRT

SMALLINT SIGNED

N

Cover sheet printed for this order. Valid Values: 1=printed

cdwh_orgpts

ORGPTS

SMALLINT SIGNED

N

Cover sheet printed for this order. Valid Values: 1=printed

/cdwhistoryrow

Ending cdwhistoryrow delimiter

/cdwhistorygroup

Ending cdwhistorygroup delimiter

cdwflashesgroup

Beginning cdwflashesgroup

cdwflashesrow

Beginning cdwflashesrow

cdwf_corp

CORP

CHAR(5)

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system.

cdwf_cddate

CDDATE

DATETIME

N

Schedule date for this job.

cdwf_tech

TECH

SMALLINT UNSIGNED

N

Tech or installer number. Valid Values: 1 thru 999

cdwf_dslot

DSLOT

INT UNSIGNED

N

Number indicating position of a job within a tech's work for that day. Valid Values: Minumum value = 1000

cdwf_dackstat

DACKSTAT

CHAR(1)

N

Flash status. Valid Values: * =acknowledged,$ =not acknowledged by dispatcher

cdwf_dflash

DFLASH

VARCHAR(350)

N

Flash message text.

cdwf_flash

FLASH

CHAR(1)

N

Code indicating the status of a flash at the tech or amp level. Valid Values: Amp table 1=not acknowledged, 2=acknowledged CDW *=acknowledged, $=not acknowledged

cdwf_who

WHO

CHAR(3)

N

ID of the operator responsible for taking this order. Valid Values: Operator Id or "---" = ARU

/cdwflashesrow

Ending cdwflashesrow

/cdwflashesgroup

Ending cdwflashesgroup

6/11/01

Added wo_wpcnt to wipoutletrow grouping of the wipoutletgroup grouping

6/12/01

Changed field layouts for w_wcod and wo_bxret in specifications to match XML output documents