|
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 |
|
o_corp |
CORP |
INT UNSIGNED |
N |
Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system.. |
|
o_ampno |
AMPNO |
CHAR(6) |
N |
Amplifier number feeding a section of the plant. Valid Values: Based on value of amp predecessor, arup.ampfield. |
|
o_ampdate |
AMPDATE |
DATETIME |
N |
Date and time the first t/c is received on this amp. If no calls have been received, this columnwill contain the date and time this amp was lastcleared.. Valid Values: Any valid date/time. |
|
o_ampcnt |
AMPCNT |
SMALLINT UNSIGNED |
N |
Number of calls counted towards an outage in current time interval. |
|
o_amptot |
AMPTOT |
INT UNSIGNED |
N |
Number of calls received since last totals cleared. |
|
o_outdate |
OUTDATE |
DATETIME |
Y |
Date and time of last outage on this amp. |
|
o_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 |
|
o_ampout |
Beginning o_ampout delimiter |
|||
|
code |
AMPOUT |
SMALLINT UNSIGNED |
N |
Codes identifying outage status. Valid Values: blank=none, 1=stage 1, 2=stage 2 |
|
description |
CHAR(8) |
Outage status description |
||
|
/o_ampout |
Ending o_ampout delimiter |
|||
|
o_ampclrdate |
AMPCLRDATE |
DATETIME |
Y |
Date to clear the AMP ... used in the outage module...in ARU or OE. |
|
o_whosetclr |
WHOSETCLR |
CHAR(3) |
N |
Operator id that set the Amp clear date. |
|
o_arucalls |
ARUCALLS |
SMALLINT UNSIGNED |
N |
Number of calls from the ARU. |
|
o_progsetclr |
PROGSETCLR |
CHAR(3) |
N |
Program that set or cleared the outage. Valid Values: The 3 numbers of the program DDP2 100 B |
|
o_probcode1 |
Beginning o_probcode1 delimiter |
|||
|
code |
PROBCODE1 |
CHAR(2) |
N |
One of the problem codes associated with the outage.. Valid Values: Any valid problem code from the T/C Problem 95code table. |
|
shortdescription |
CHAR(8) |
Problem code short description |
||
|
longdescription |
CHAR(30) |
Problem code long description |
||
|
/o_probcode1 |
Ending o_probcode1 delimiter |
|||
|
o_probcode2 |
Beginning o_probcode2 delimiter |
|||
|
code |
PROBCODE2 |
CHAR(2) |
N |
One of the problem codes associated with the outage.. Valid Values: Any valid problem code from the T/C Problem 95code table. |
|
shortdescription |
CHAR(8) |
Problem code short description |
||
|
longdescription |
CHAR(30) |
Problem code long description |
||
|
/o_probcode2 |
Ending o_probcode2 delimiter |
|||
|
o_probcode3 |
Beginning o_probcode3 delimiter |
|||
|
code |
PROBCODE3 |
CHAR(2) |
N |
One of the problem codes associated with the outage.. Valid Values: Any valid problem code from the T/C Problem 95code table. |
|
shortdescription |
CHAR(8) |
Problem code short description |
||
|
longdescription |
CHAR(30) |
Problem code long description |
||
|
/o_probcode3 |
Ending o_probcode3 delimiter |
|||
|
o_ampcustcnt |
AMPCUSTCNT |
INT UNSIGNED |
N |
Number of customers on this AMP. |
|
o_amppred |
AMPPRED |
CHAR(6) |
N |
Preceeding amp # in amp tree.. Valid Values: Must be a valid amp number, based on the ampdesignator (arup.ampfield). |
|
o_outagetype |
Beginning o_outagetype delimiter |
|||
|
code |
OUTAGETYPE |
SMALLINT UNSIGNED |
N |
The type of outage. Valid Values: 0,1 = DISTRO, 2 = TRUNK, 3 = HEADEND, 4 = CHANNEL |
|
description |
CHAR(10) |
Outage type description |
||
|
/o_outagetype |
Ending o_outagetype delimiter |
|||
|
o_channelsout |
CHANNELSOUT |
SMALLINT UNSIGNED |
N |
Number of channels effected in a Channel type outage.. Valid Values: Numeric, 1-999. |