Input XML Tags

XML Tag	Definition
comcorp	Five digit system number assigned to each corp.
bnumb	14 digit converter number

Output XML Tags

XML Tag	Column Name	Data Type	Nullable	Definition
binv_corp	CORP	INT UNSIGNED	N	Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system..
binv_bnumb	BNUMB	CHAR(14)	N	Box serial number. Valid Values: Alpha/Numeric
binv_addleq	ADDLEQ	CHAR(8)	N	Any additional equipment information pertaining tothis box, such as remote control number.
binv_bequip	BEQUIP	CHAR(1)	N	Equipment Code. (No longer used)
binv_mfg				Beginning binv_mfg delimiter
code	MFG	CHAR(1)	N	Manufacturer code.
shortdescription		CHAR(8)		Manufacturer code short description
longdescription		CHAR(30)		Manufacturer code long description
binv_mfg				Ending binv_mfg delimiter
binv_lot	LOT	CHAR(3)	N	User key-in value indicating a lot number.
binv_purchdate	PURCHDATE	DATETIME	Y	Date the equipment was purchased.
binv_cost	COST	NUMERIC UNSIGNED	N	The cost of the box.
binv_prevhouse	PREVHOUSE	CHAR(6)	N	Previous house this box assigned to.
binv_prevcust	PREVCUST	CHAR(2)	N	Previous customer number this box assigned to.
binv_optn1				Beginning binv_optn1 delimiter
code	OPTN1	CHAR(1)	N	Code obtained from user defined table indicating option in box.
shortdescription		CHAR(8)		Option short description
longdescription		CHAR(30)		Option long description
/binv_optn1				Ending binv_optn1 delimiter
binv_optn2				Beginning binv_optn2 delimiter
code	OPTN2	CHAR(1)	N	Code obtained from user defined table indicating option in box.
shortdescription		CHAR(8)		Option short description
longdescription		CHAR(30)		Option long description
/binv_optn2				Ending binv_optn2 delimiter
binv_optn3				Beginning binv_optn3 delimiter
code	OPTN3	CHAR(1)	N	Code obtained from user defined table indicating option in box.
shortdescription		CHAR(8)		Option short description
longdescription		CHAR(30)		Option long description
/binv_optn3				Ending binv_optn3 delimiter
binv_tech	TECH	SMALLINT UNSIGNED	N	Tech or installer number. Valid Values: 1 thru 999
binv_loc				Beginning binv_loc delimiter
code	LOC	CHAR(1)	N	Indicates the location of the box (house or inventory).
shortdescription		CHAR(8)		Location short description
longdescription		CHAR(30)		Location long description
/binv_loc				Ending binv_loc delimiter
binv_place	PLACE	CHAR(4)	N	User key-in value indicating further location of Box in inventory.
binv_recstat	RECSTAT	CHAR(1)	N	Not used (to be deleted from table).
binv_bxstatus				Beginning binv_bxstatus delimiter
code	BXSTATUS	CHAR(1)	N	Inventory status of the box, such as: A=test new, B=new stock, C=truck out, D=house,. Valid Values: E=truck ret, F=test used, G=old stock, H=scrap, I=vendor bad, J=stolen, K=arrive bad, L =at vendor
description		CHAR(30)		Box status description
/binv_bxstatus				Ending binv_bxstatus delimiter
binv_addrsable	ADDRSABLE	CHAR(1)	N	Box addressability flag. Valid Values: Y = addressable box
binv_evtcpbl	EVTCPBL	CHAR(1)	N	Event capable flag for this box. Valid Values: Y = yes
binv_numrepairs	NUMREPAIRS	SMALLINT UNSIGNED	N	Cumulative number of repairs performed on this equipment...used as a counter.
binv_lastdate	LASTDATE	DATETIME	N	The date of the last record update OR date of the last collection step.
binv_lastprog				Beginning binv_lastprog delimiter
code	LASTPROG	CHAR(1)	N	Last program to modify this row ie. R=Repair Prog(such as Box Repair). Valid Values: 1=O/P, 2=Disp, 3=ChkIn, 4=DB Mt, 5=Box Mt, 6=Upload, 7=BoxDrvr, 8=CollRun, 9=OLVQ, A=ARU Drvr, B=EvtSched, C=PPV Chg, D=PPV Mt, E =ARU, F=OPA Mt, G=CycUpd, H=Post, I=H/C Mt, J=ColChg, K=P/A, L=CustPrge, M=LBox, N=Cutoff, Z=Recalc Rates
description		CHAR(30)		Last program description
/binv_lastprog				Ending binv_lastprog delimiter
binv_brgpin	BRGPIN	CHAR(4)	N	Personal identification number.
binv_brgratg				Beginning binv_brgratg delimiter
code	BRGRATG	CHAR(1)	N	Highest rating level this customer wishes to view on this outlet. Valid Values: 0=G, 1=PG, 2=R, 3=X.
description		CHAR(30)		Rating description
/binv_brgratg				Ending binv_brgratg delimiter
binv_brgppv	BRGPPV	CHAR(1)	N	Is customer allowed to order PPV on this box. Valid Values: 1= yes blank = no
binv_brgemg	BRGEMG	CHAR(1)	N	Flag to show if emergency alert feature of box is being used. Valid Values: 1=yes, blank=no
binv_cable	CABLE	CHAR(1)	N	Not used (to be deleted from table).
binv_fmt	FMT	CHAR(1)	N	Format (vendor identifier) of this addressable device. Valid Values: 0-9, A-Z
binv_tiers	TIERS	CHAR(128)	N	Indicates tags authorized for this box.
binv_spcls	SPCLS	CHAR(64)	N	Tags for PPV events that have been ordered. Valid Values: values are Hex :00 for controller event systems. Tags=0-63 for tag-based systems
binv_prom	PROM	INT UNSIGNED	N	Box prom number. Digital address used by some formats to address box on controller.
binv_hub	HUB	CHAR(2)	N	Hub number.
binv_tinitflag	TINITFLAG	CHAR(1)	N	Specifies whether TAC sent or Jerrold/Tocom/Pioneer initialized.
binv_noresp				Beginning binv_noresp delimiter
code	NORESP	CHAR(1)	N	Flag field used to indicate that a two-way box isnot responding to poll/status requests sent by thecontroller (normally used to request upload ofIPPV order info from the box to the controller).. Valid Values: Blank = Box has responded to most recent poll.0-9,A-Z = Box not responding to controller poll requests. The actual field value tells how many times the box has not responded
description		CHAR(20)		Not a table column. Description added based on the noresp values read from the =boxinvtry table.Valid descriptions are: Responding, Not Responding.
/binv_noresp				Ending binv_noresp delimiter
binv_deldate	DELDATE	DATETIME	Y	Delete Date for this converter
binv_dwo				Beginning binv_dwo delimiter
code	DWO	CHAR(1)	N	P/DS off mask to use. Or off mask used.. Valid Values: 1=QC mask 2=TEST mask 3=TESTX mask 4=NONPAY mask 5=OFF mask 6= BULK mask blank=not off
description		CHAR(20)		Not a table column. Description added based on the code values read from the =boxinvtry table.
/binv_dwo				Ending binv_dwo delimiter
binv_hibit	HIBIT	SMALLINT UNSIGNED	N	To define if IPPV inhibited at this box. Valid Values: 0=enable, 1=IPPV inhibit, 2=customer request inhibit & IPPV inhibited
binv_outlet	OUTLET	SMALLINT SIGNED	N	Outlet number. Valid Values: 1-60
binv_house	HOUSE	CHAR(6)	N	House number. Valid Values: Alpha/Numeric
binv_cust	CUST	CHAR(2)	N	Customer number.
binv_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
binv_opaid	OPAID	CHAR(14)	N	An addressable module associated with multiple houses.
binv_opalogport	OPALOGPORT	SMALLINT UNSIGNED	N	The logical port number in the OPA device
binv_opadrop	OPADROP	CHAR(1)	N	Indicates if the OPA device has a Drop. Valid Values: " " = no drop, "1"= has drop
binv_opasubmod	OPASUBMOD	CHAR(1)	N	Indicates if the OPA device contains a sub module. Valid Values: " "=no sub module, "1" = submodule
binv_partition	PARTITION	CHAR(2)	N	Data hashing value for database management - equals the last 2 digits of the house #.
binv_opr	OPR	CHAR(3)	N	ID of the operator responsible for latest transaction. Valid Values: "---" = ARU, "***" = Upload "###" = VOD API
binv_boxequip				Beginning binv_boxequip delimiter
code	BOXEQUIP	CHAR(2)	N	EQUIPMENT CODE. Valid Values: or 0 - 99
shortdescription	SHORTDESC	CHAR(8)	N	Short description.
longdescription	LONGDESC	CHAR(20)	N	Long description.
msocode	MSOCODE	CHAR(2)	N	Code to use in MSO reporting. Valid Values: 00-ZZ
digital	DIGITAL	SMALLINT UNSIGNED	N	Indicator value for digital rate code*or* Indicates whether or not equipment is digitalfor =SUPPORTED_EQUIPMENT.. Valid Values: 0=analog event 1=digital*or*0=not digital 1=digital
analog	ANALOG	SMALLINT UNSIGNED	N	Value to indicate whether or not the converterequipment type is analog capable.*Changed default to 1 on release 3.4.. Valid Values: 0=not analog 1=analog
ippv	IPPV	SMALLINT UNSIGNED	N	Value to indicate whether or not the converterequipment is IPPV capable. Valid Values: 1=IPPV capable
tel_rf				beginning tel_rf delimiter
code	TEL_RF	SMALLINT UNSIGNED	N	2-way converter return type. Valid Values: 0=not two=way, 1=2-way phone return, 3=2-way RFreturn
description		CHAR(20)		tel_rf description
/tel_rf				Ending tel_rf delimiter
credit_debit_hit	CREDIT_DEBIT_HIT	SMALLINT UNSIGNED	N	credit/debit hit indicator. Valid Values: 1= send credit/debit hits
vndr_code	VNDR_CODE	SMALLINT UNSIGNED	N	TCI equipment code.
/binv_boxequip				Ending binv_boxequip delimiter
binv_nvodcapable	NVODCAPABLE	CHAR(1)	N	Identifies the box as being capable of showingnear video on demand events.. Valid Values: Y/N
binv_ippvpin	IPPVPIN	CHAR(5)	N	Personal ID number for upstream, IPPV purchasetransactions.. Valid Values: 00000-99999 right justified leading zeros.
binv_featuremap1	FEATUREMAP1	INT UNSIGNED	N	Bitmap of enabled vendor 'features' enabled forthe box. Bit ON means feature enabled, OFF meansfeature disabled. Bits are logically numbered 0-31 with the least significant bit on the right.. Valid Val ues: Any bit pattern
binv_featuremap2	FEATUREMAP2	INT UNSIGNED	N	Bitmap of enabled vendor 'features' enabled forthe box. Bit ON means feature enabled, OFF meansfeature disabled. Bits are logically numbered32-63 with the least significant bit on the right.. Valid Val ues: Any bit pattern.
binv_sub_type	SUB_TYPE	INT UNSIGNED	Y	Secondary identifier of set top. Valid Values: 00000-99999
binv_unit_add	UNIT_ADD	CHAR(16)	Y	Unit address for digital converter. Valid Values: xxx-xxxxxxxxxx-xxx
binv_prevtiers	PREVTIERS	CHAR(128)	Y	Used to store the previous version of Tiers.
binv_polling_date	POLLING_DATE	DATETIME	Y	Timestamp of the last polling transactionreceived from the controller.. Valid Values: YYYY-MM-DD:HH:MM:SS.NNNNNN
binv_config_id_num	CONFIG_ID_NUM	SMALLINT SIGNED	N	Configuration ID number on the addressablecontroller.. Valid Values: 00-99
binv_equipment_class				Beginning binv_equipment_class delimiter
code	EQUIPMENT_CLASS	SMALLINT UNSIGNED	N	Indicates box equipment class: 0=format; 1=HSDS;2=setttop.
description		CHAR(30)		Equipment class description
/binv_equipment_class				Ending binv_equipment_class delimiter
binv_deliverysysid	DELIVERYSYSID	CHAR(20)	N	External system identifier. Each delivery systemis responsible for provisioning and/or deliveringa specific data service.. Valid Values: Alphanumeric character string
binv_model	MODEL	CHAR(30)	N	Cable modem model identifier. Valid Values: character string
binv_macaddress	MACADDRESS	CHAR(17)	N	Media Access Control Address. Valid Values: Alphanumeric to 17 positions
binv_ipaddr	IPADDR	CHAR(15)	N	Internet protocol address. Valid Values: alpha/numeric string in the form nnn.nnn.nnn.nnnwhere nnn is a number between 0 and 255
binv_modemid	MODEMID	CHAR(30)	N	External record identifier for the deliverysystem.. Valid Values: alpha/numeric
binv_highpri_remove	HIGHPRI_REMOVE	DATETIME	Y	Date to remove box from high priority.. Valid Values: Datetime year-to-day

Source Tables

• binv = boxinvtry