GetWarnings

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

cust

Two digit customer number

XML Tag

Column Name

Data Type

Nullable

Definition

warnings

Beginning warnings delimiter

wrn_c_haspin

custpin in custmaster

SMALLINT

Y

Customer has a PIN on their account. If the custpin column in the custmaster table has values this tag is set to TRUE.

wrn_c_haspin_desc

hardcoded values

CHAR(50)

wrn_c_hasoutstandingwork

stat in custmaster

SMALLINT

Y

Customer has outstanding work. If the cust is P/DS check for P/TC or P/SR in =housemaster.

wrn_c_hasoutstandingwork_desc

hardcoded values

CHAR(50)

wrn_c_istransfered

Check the CustData structure.

SMALLINT

Y

Customer was transfered from another account. If the XfrTo and XfrAcct fields in the CustData structure has valid data set this tag to true.

wrn_c_istransfered_desc

hardcoded values

CHAR(50)

wrn_c_hasoutstandingevents

BoxEvt in CustData structure.

SMALLINT

Y

Customer has events that have yet to complete. If BoxEvt is set to 1 set this tag to true.

wrn_c_hasoutstandingevents_desc

hardcoded values

CHAR(50)

warninglinegroup

Beginning warninglinegroup delimiter

wrn_warning_line

In =wipmaster look at the following columns: wordrsn, wncomt, notrkreason,poolflag, routing.

CHAR(200)

Y

Use the existing pathway msg id WARNING_WIP_READ check in the wipmaster table for warning messages to be displayed.

/warninglinegroup

Ending warninglinegroup delimiter

wrn_opa_outlet

outlet from =boxinventory

SMALLINT SIGNED

Y

Customer has an "Off-Premesis Addressability" outlet.

wrn_opa_unit

opaid from =boxinventory

CHAR(14)

Y

OPA Unit

wrn_opa_box

bnumb from =boxinventory

CHAR(14)

Y

OPA Box Number

wrn_opa_stat

Beginning wrn_opa_stat delimiter

code

opastat from =opamaster

CHAR(1)

Y

OPA Status

description

hardcoded values

CHAR(30)

Y

Based on the value of wrn_opa_stat: if wrn_opa_stat = 3 the value of the description is "connected otlt #" if wrn_opa_stat = 2 than the description is "needs equip otlt #". In both cases the warning screen will display the bin.outlet value right after the description mentioned above. The binv (=boxinvtry) fields can be obtained via the GetBoxInfo api.

/wrn_opa_stat

Ending wrn_opa_stat delimiter

wrn_transfer_from_acct

house + cust from =custtransfer

CHAR(8)

Y

Account number this customer was transfered from.

wrn_transfer_from_addr

stnum + fract + dir + name + # + aptn from =housemaster

CHAR(80)

Y

Address this customer was transfered from.

wrn_ppv_club_nbr

pvclb in custmaster

CHAR(1)

Y

PPV Club Number customer belongs to.

wrn_ppv_club_desc

clubdesc1 - clubdesc6 in =ppvparams.

CHAR(8) * 6

Y

PPV Club Description

wrn_cefts_type

eftstype in custefts

CHAR(1)

Y

EFTS Type

wrn_cefts_bank

bank in custefts

CHAR(8)

Y

EFTS Bank

wrn_cefts_acct

bacct in custefts

CHAR(17)

Y

EFTS Bank Account Number

wrn_cefts_carddesc

cardtype in custefts

CHAR(1)

Y

EFTS Credit Card Description Type1 Visa, Type 2 M/C

wrn_cefts_cardnbr

cardnmbr in custefts

CHAR(19)

Y

EFTS Credit Card Number

eftsinfo

hardcoded values

CHAR(50)

wrn_cluster

longdesc from =code95

CHAR(20)

Y

Cluster this house is located in. Using the clust value from =housemaster find the long description in the =code95 table.

wrn_cancel_reason

longdesc from =code36

CHAR(20)

Y

Cancel reason associated with customer. Long description in =code36 table for the cxrsn in =custmaster.

wrn_cust_type

longdesc from =code36

CHAR(20)

Y

Customer Type. Long description from the =code36 table of =custmaster.ctype .

wrn_cust_info

longdesc from =code36

CHAR(20)

Y

Customer Info. Long description from the =code36 table of =custmaster.cinfo.

wrn_cust_class

longdesc from =code36

CHAR(20)

Y

Customer Class. Long description from the =code36 table of =custmaster.class.

wrn_write_off_amount

wrt from =custmaster

NUMERIC SIGNED

Y

Amount written off for this customer.

wrn_delquent_amount

This value is calculated from the following columns in custmaster: crdprorat + twlprorate + memocrdt + cur + c30 + c60 + c90 + c120 + wrt

NUMERIC SIGNED

Y

Current delinquent balance.

wrn_is_nonpay_disc

Not a column value.

SMALLINT

Y

Customer was non-pay disconnected. Set this tag to True using the =orderparams.npaydisrsn and =custmaster.drsn fields.

wrn_is_nonpay_disc_desc

hardcoded values

CHAR(50)

wrn_has_unreturned_converter

Not a column value.

SMALLINT

Y

Disconnected customer still has an unreturned converter. Set this tag to true using the =custmaster.cvtr field.

wrn_has_unreturned_converter_desc

hardcoded values

CHAR(50)

wrn_is_vip

Not a column value.

SMALLINT

Y

Customer is a VIP. Use =custmaster.vip.

wrn_is_vip_desc

hardcoded values

CHAR(50)

wrn_is_ppv_hold

Not a column value.

SMALLINT

Y

Customer has a PPV hold set. Set this tag to true if the =custmaster.hold is set to 2.

wrn_is_ppv_hold_desc

hardcoded values

CHAR(50)

wrn_is_upgrade_hold

Not a column value.

SMALLINT

Y

Customer has an upgrade hold set. True if =custmaster.hold is 1.

wrn_is_upgrade_hold_desc

hardcoded values

CHAR(50)

wrn_is_transfer_hold

Not a column value.

SMALLINT

Y

Customer has a transfer hold set. True if =custmaster.hold is 3.

wrn_is_transfer_hold

hardcoded values

CHAR(50)

wrn_house_info

longdesc from =code36

CHAR(20)

Y

House information. Long description from =code36 table of =housemaster.info.

wrn_dwell

longdesc from =code36

CHAR(20)

Y

Dwelling. Long description from =code36 table of =housemaster.dwell.

wrn_construction

longdesc from =code36

CHAR(20)

Y

Construction Area. Long description from =code36 table of =housemaster.carea.

wrn_dualacctname

init + lname from =custmaster

CHAR(15)

Y

Name from Dual account associated with this customer.

wrn_dualacct

dual in =housemaster

CHAR(6)

Y

Account number of the Dual account.

wrn_dualstat

stat in custmaster

CHAR(1)

Y

Status of the Dual Account.

wrn_dualtype

enhdualtype from =housemaster

CHAR(1)

Y

Enhanced dual type P primary account, S secondary account.

wrn_dual_isin_collections

colst from =custmaster

CHAR(1)

Y

Flag indicating the associated Dual account is in collections.

wrn_dual_isin_collections_desc

hardcoded values

CHAR(50)

wrn_ampoutage_stage

ampout from =outage

SMALLINT

Y

Stage description of the existing amp outage. Valid values: blank, 1, 2.

wrn_ampoutage_stage_desc

hardcoded values

CHAR(50)

wrn_markettype

longdesc from =code36

CHAR(20)

Y

Market type for this house. Long description from =code36 table of =housemaster.mkt.

wrn_has_no_zip

Not a column value.

SMALLINT

Y

Flag indicating this house does not have a zip code associated with it. Use the =housemaster.zipcode columns to set this tag to true/false.

wrn_has_no_zip_desc

CHAR(20)

wrn_complex

complex

CHAR(5)

Y

Complex number this house is in =complexmaster.

wrn_complexinst

iinst

CHAR(20)

Y

Installer instructions in =complexmaster.

wrn_complexname

cname

CHAR(20)

Y

Complex name (=complexmaster) for this house.

wrn_inboundcontact

custmaster.incntcttype1-code95.shortdes, custmaster.incntcttype2-code95.shortdes, custmaster.incntcttype3-code95.shortdes,

CHAR(2)-CHAR(8) * 3

Y

Customer has inbound contact information.

wrn_outboundcontact

custmaster.outcntcttype1-code95.shortdes, custmaster.outcntcttype2-code95.shortdes, custmaster.outcntcttype3-code95.shortdes

CHAR(2)-CHAR(8) * 3

Y

Customer has outbound contact information.

wrn_is_xfer_from_diffcorp

Not a column value.

SMALLINT

Y

Flag indicating that this customer was transfered from a different corp. Comseq, XfrFromSeq, and CustData.OldHouse fields are used to set this tag to true or false.

wrn_is_xfer_from_diffcorp_desc

hardcoded values

CHAR(50)

wrn_hsds

SMALLINT

/warnings

Ending warnings delimiter