Tables
This section includes all the Fiber Manager XI non-spatial tables.
The topics are ordered to match the order in which they appear in the Fiber Manager XI default published map service.
Structure Junction Object
This object table is present because it is required by the Utility Network (UN). Thus, it is a part of the Fiber Manager XI data model, but Fiber Manager XI does not functionally use it.
Name: Structure Junction Object
Display Field: SubNetworkName
Type: Table
|
Field |
Alias |
Type |
|---|---|---|
|
assetgroup |
Asset group |
Integer |
|
assettype |
Asset type |
SmallInteger |
|
associationstatus |
Association status |
SmallInteger |
|
creationdate |
Creation date |
Date |
|
creator |
Creator |
String |
|
diameter |
Diameter |
Double |
|
globalid |
Global ID |
GlobalID |
|
inservicedate |
In-Service Date |
Date |
|
installdate |
Install Date |
Date |
|
lastupdate |
Last update |
Date |
|
lifecyclestatus |
Lifecycle Status |
SmallInteger |
|
maintby |
Maintained by |
SmallInteger |
|
networklevel |
Network Level |
SmallInteger |
|
objectid |
Object ID |
OID |
|
ownedby |
Owned By |
SmallInteger |
|
retireddate |
Retired Date |
Date |
|
spatialconfidence |
Spatial Confidence |
SmallInteger |
|
spatialsource |
Spatial Source |
SmallInteger |
|
subnetworkname |
Supported subnetwork name |
String |
|
updatedby |
Updated by |
String |
|
wallid |
Wall ID |
SmallInteger |
Structure Edge Object
This object table is present because it is required by the Utility Network (UN). Thus, it is a part of the Fiber Manager XI data model, but Fiber Manager XI does not functionally use it.
Name: Structure Edge Object
Display Field: SubnetworkName
Type: Table
|
Field |
Alias |
Type |
|---|---|---|
|
assetgroup |
Asset group |
Integer |
|
assetid |
Asset ID |
String |
|
assettype |
Asset type |
SmallInteger |
|
associationstatus |
Association status |
SmallInteger |
|
availablecapacity |
Number of Open Ducts |
SmallInteger |
|
creationdate |
Creation date |
Date |
|
creator |
Creator |
String |
|
depth |
Depth |
Double |
|
diameter |
Duct Diameter |
Double |
|
diameterwidth |
Diameter Width: Conduit Diameter, Duct Diameter, Tray Width, Trench Width |
Double |
|
ductavailable |
Duct Availability Indicator |
SmallInteger |
|
ductcrosssectionshape |
Duct Cross Section Shape |
SmallInteger |
|
ductdiameter |
Diameter |
Double |
|
ductid |
Duct ID |
String |
|
fromport |
From Port |
SmallInteger |
|
globalid |
Global ID |
GlobalID |
|
insertaction |
Insert Action |
String |
|
inservicedate |
In-Service Date |
Date |
|
installdate |
Install Date |
Date |
|
isavailable |
Is Available |
SmallInteger |
|
isoccupied |
Is Occupied |
SmallInteger |
|
lastupdate |
Last update |
Date |
|
lifecyclestatus |
Lifecycle Status |
SmallInteger |
|
maintby |
Maintained by |
SmallInteger |
|
material |
Material |
SmallInteger |
|
maximumcapacity |
Maximum Capacity |
SmallInteger |
|
measuredlength |
Measured Length |
Double |
|
minimumbendradius |
Minimum Bend Radius in Duct |
Double |
|
networklevel |
Network Level |
SmallInteger |
|
objectid |
Object ID |
OID |
|
ownedby |
Owned By |
SmallInteger |
|
retireddate |
Retired Date |
Date |
|
spatialconfidence |
Spatial Confidence |
SmallInteger |
|
spatialsource |
Spatial Source |
SmallInteger |
|
subnetworkname |
Supported subnetwork name |
String |
|
toport |
To Port |
SmallInteger |
|
updatedby |
Updated by |
String |
Communications Junction Object
This object table is present because it is required by the Utility Network (UN). Thus, it is a part of the Fiber Manager XI data model, but Fiber Manager XI does not functionally use it.
Name: Communications Junction Object
Display Field: SubnetworkControllerName
Type: Table
|
Field |
Alias |
Type |
|---|---|---|
|
aisle |
Aisle |
String |
|
antennarotation |
Antenna Rotation Angle |
Double |
|
assetgroup |
Asset group |
Integer |
|
assetid |
Asset ID |
String |
|
assettype |
Asset type |
SmallInteger |
|
associationstatus |
Association Status |
SmallInteger |
|
azimuth |
Angular Placement of Antenna |
Double |
|
band |
Band |
SmallInteger |
|
bandwidth |
Radio Bandwidth |
Double |
|
bay |
Bay |
String |
|
building |
Building |
String |
|
coaxsubnetwork |
Coax Subnetwork |
String |
|
connectorusage |
Connector Type |
SmallInteger |
|
coppersubnetwork |
Copper Subnetwork |
String |
|
creationdate |
Creation Date |
Date |
|
creator |
Creator |
String |
|
depth |
Depth |
Double |
|
devicetype |
Device Type |
SmallInteger |
|
diameter |
Diameter |
Double |
|
ductflagoutlineid |
Duct Flag Outline ID |
GUID |
|
dwnlinkbwhgh |
Downlink Bandwidth High |
Double |
|
dwnlinkbwlow |
Downlink Bandwidth Low |
Double |
|
fibersubnetwork |
Fiber Subnetwork |
String |
|
floor |
Floor |
String |
|
frequency |
Frequency |
Double |
|
fullbeamwidth |
Antenna Full Power Beamwidth |
Double |
|
globalid |
Global ID |
GlobalID |
|
halfbeamwidth |
Antenna Half Power Beamwidth |
Double |
|
inports |
Input Port Count |
SmallInteger |
|
insertaction |
Insert Action |
String |
|
inservicedate |
In-Service Date |
Date |
|
installdate |
Install Date |
Date |
|
isconnected |
Is connected |
SmallInteger |
|
issubnetworkcontroller |
Is Subnetwork Controller |
SmallInteger |
|
lastupdate |
Last Update |
Date |
|
lifecyclestatus |
Lifecycle Status |
SmallInteger |
|
maintby |
Maintained By |
SmallInteger |
|
manufacturer |
Equipment Manufacturer |
SmallInteger |
|
material |
Material |
String |
|
model |
Equipment Model Identifier |
SmallInteger |
|
mountheight |
Antenna Mounting Height |
Double |
|
networkcard |
Network Card |
String |
|
networkequipment |
Network Equipment |
String |
|
networklevel |
Network Level |
SmallInteger |
|
networkname |
Network Name |
String |
|
networkrack |
Network Rack |
String |
|
networkshelf |
Network Shelf |
String |
|
networkside |
Network Site |
String |
|
networkslot |
Network Slot |
String |
|
networksubrack |
Network Sub Rack |
String |
|
nodeid |
Node ID |
String |
|
numavailableducts |
Number of Available Ducts |
SmallInteger |
|
objectid |
Object ID |
OID |
|
outports |
Output Port Count |
SmallInteger |
|
ownedby |
Owned By |
SmallInteger |
|
propagatedstrandstate |
Propagated Strand State |
SmallInteger |
|
radius |
Antenna Signal Radius |
Double |
|
retireddate |
Retired Date |
Date |
|
room |
Room |
String |
|
rxmimo |
Receive MIMO Configuration |
SmallInteger |
|
rxthroughput |
Receive Through Put |
Double |
|
sectornumber |
Sector Number |
String |
|
servicetype |
Service Type |
SmallInteger |
|
spatialconfidence |
Spatial Confidence |
SmallInteger |
|
spatialsource |
Spatial Source |
SmallInteger |
|
spectrum |
Spectrum |
SmallInteger |
|
strandstate |
Strand State |
SmallInteger |
|
subnetworkcontrollername |
Subnetwork Controller Name |
String |
|
supportedsubnetworkname |
Supported Subnetwork Name |
String |
|
supportingsubnetworkname |
Supporting Subnetwork Name |
String |
|
switchsubnetwork |
Switch Subnetwork |
String |
|
technology |
Technology |
SmallInteger |
|
terminalconfiguration |
Terminal Path |
String |
|
tiername |
Tier Name |
Integer |
|
tierrank |
Tier Rank |
Integer |
|
tilt |
Antenna Tilt Angle |
Double |
|
txmimo |
Transmit MIMO Configuration |
SmallInteger |
|
txthroughput |
Transmit Through Put |
Double |
|
updatedby |
Updated By |
String |
|
uplinkbwhgh |
Uplink Bandwidth High |
Double |
|
uplinkbwlow |
Uplink Bandwidth Low |
Double |
|
wavelength |
Wavelength |
Double |
Communications Edge Object
This object table is present because it is required by the Utility Network (UN). Thus, it is a part of the Fiber Manager XI data model, but Fiber Manager XI does not functionally use it.
Name: Communications Edge Object
Display Field: SupportedSubnetworkName
Type: Table
|
Field |
Alias |
Type |
|---|---|---|
|
assetgroup |
Asset group |
Integer |
|
assettype |
Asset type |
SmallInteger |
|
associationstatus |
Association status |
SmallInteger |
|
coaxsubnetwork |
CoaxSubnetwork |
String |
|
coppersubnetwork |
CopperSubnetwork |
String |
|
creationdate |
Creation date |
Date |
|
creator |
Creator |
String |
|
endfrequency |
Splitter End of Frequency Banc |
Double |
|
fibersubnetwork |
FiberSubnetwork |
String |
|
globalid |
Global ID |
GlobalID |
|
insertaction |
insertaction |
String |
|
inservicedate |
In-Service Date |
Date |
|
installdate |
Install Date |
Date |
|
isconnected |
Is connected |
SmallInteger |
|
lastupdate |
Last update |
Date |
|
lifecyclestatus |
Lifecycle Status |
SmallInteger |
|
maintby |
Maintained by |
SmallInteger |
|
measuredlength |
Measured Length |
Double |
|
networklevel |
Network Level |
SmallInteger |
|
objectid |
Object ID |
OID |
|
opticallength |
Optical Length |
Double |
|
ownedby |
Owned By |
SmallInteger |
|
propagatedstrandstate |
Propagated Strand State |
SmallInteger |
|
retireddate |
Retired Date |
Date |
|
spatialconfidence |
Spatial Confidence |
SmallInteger |
|
spatialsource |
Spatial Source |
SmallInteger |
|
startfrequency |
Splitter Start of Frequency Banc |
Double |
|
strandgrade |
Strand Grade |
SmallInteger |
|
strandgroupid |
Strand Group Color |
SmallInteger |
|
strandid |
Strand Color |
SmallInteger |
|
strandstatus |
Strand Status |
SmallInteger |
|
supportedsubnetworkname |
Supported subnetwork name |
String |
|
supportingsubnetworkname |
Supporting subnetwork name |
String |
|
switchsubnetwork |
SwitchSubnetwork |
String |
|
updatedby |
Updated by |
String |
Active Device
Name: ActiveDevice
Display Field: DeviceName
Type: Table
This is an object class to represent a fiber device that is powered (for example, switching equipment).
|
Field |
Alias |
Type |
|---|---|---|
|
created_date |
created_date |
Date |
|
created_user |
created_user |
String |
|
deviceheight |
Height |
Double |
|
devicename |
Name |
String |
|
deviceposition |
Position |
Integer |
|
devicewidth |
Width |
Double |
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
fiberparent |
FiberParent |
GUID |
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
globalid |
GlobalID |
GlobalID |
|
last_edited_date |
last_edited_date |
Date |
|
last_edited_user |
last_edited_user |
String |
|
numberofportcolumns |
# of Columns |
Integer |
|
numberofportrows |
# of Rows |
Integer |
|
objectid |
ObjectID |
OID |
|
sides |
Sides |
String |
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
ActiveCommonPort
Name: ActiveCommonPort
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the receive port on an active device.
|
Field |
Alias |
Type |
|---|---|---|
|
created_date |
created_date |
Date |
|
created_user |
created_user |
String |
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
fibercircuitglobalid |
FiberCircuitGlobalID |
GUID |
|
fiberparent |
FiberParent |
GUID |
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
globalid |
GlobalID |
GlobalID |
|
height |
Height |
Integer |
|
lambdamax |
LambdaMax |
Double |
|
lambdamin |
LambdaMin |
Double |
|
last_edited_date |
last_edited_date |
Date |
|
last_edited_user |
last_edited_user |
String |
|
objectid |
ObjectID |
OID |
|
portname |
Name |
String |
|
portnumber |
PortNumber |
Integer |
|
portpositionondevice |
Position |
Integer |
|
portstatus |
Port Status |
Integer |
|
porttype |
Type |
String |
|
sides |
Sides |
String |
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
toplevelcmn |
TopLevelCMN |
String |
|
toplevelguid |
TopLevelGuid |
GUID |
|
width |
Width |
Integer |
ActiveSplitPort
Name: ActiveSplitPort
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the transmit port on an active device.
|
Field |
Alias |
Type |
|---|---|---|
|
created_date |
created_date |
Date |
|
created_user |
created_user |
String |
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
fibercircuitglobalid |
FiberCircuitGlobalID |
GUID |
|
fiberparent |
FiberParent |
GUID |
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
globalid |
GlobalID |
GlobalID |
|
height |
Height |
Integer |
|
impliedalignment |
ImpliedAlignment |
Integer |
|
impliedconnectionsourceguid |
ImpliedConnectionSourceGUID |
GUID |
|
lambdamax |
Wavelength Max |
Double |
|
lambdamin |
Wavelength Min |
Double |
|
last_edited_date |
last_edited_date |
Date |
|
last_edited_user |
last_edited_user |
String |
|
objectid |
OBJECTID |
OID |
|
portname |
Name |
String |
|
portnumber |
Number |
Integer |
|
portpositionondevice |
Position |
Integer |
|
portstatus |
Port Status |
Integer |
|
porttype |
Type |
String |
|
sides |
Sides |
String |
|
subtype |
Subtype |
Integer |
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
toplevelcmn |
TopLevelCMN |
String |
|
toplevelguid |
TopLevelGuid |
GUID |
|
width |
Width |
Integer |
BackPort
Name: BackPort
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the back side of the fiber ports. Typically, the back sides of the ports connect to the fiber strands.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultheight |
DefaultHeight |
Integer |
|
|
defaultwidth |
DefaultWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
impliedconnectionsourceguid |
ImpliedConnectionSourceGuid |
GUID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portname |
Name |
String |
|
|
portnumber |
Num |
Integer |
|
|
portpositiononcard |
PortPositionOnCard |
Integer |
|
|
portstatus |
Port Status |
Integer |
|
|
porttype |
Type |
String |
|
|
sidesofrackshownon |
SidesOfRackShownOn |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
BufferTube
Name: BufferTube
Display Field: BufferTubeName
Type: Table
This is an object class to represent the buffer tubes inside a fiber optic cable. In the field, buffer tubes are used to group, protect, and identify fibers within a cable. In Fiber Manager, buffer tubes are used to display fibers within their designated groups and identify specific fibers (Blue Buffer/Blue Fiber = Fiber 1, Blue Buffer/Orange Fiber = Fiber 2,…) within a cable. In the field, buffer tubes may not always be plastic sleeves that surround glass fibers. They can also be stainless steel tubes (OPGW Cables), plastic notches in a helical divider (European Cables), or even painted marks on fibers (underground and submarine cables)
|
Field |
Alias |
Type |
|---|---|---|
|
buffertubecolor |
Color |
String |
|
buffertubename |
Name |
String |
|
buffertubenumber |
Num |
Integer |
|
buffertubeposition |
Position |
Integer |
|
created_date |
created_date |
Date |
|
created_user |
created_user |
String |
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
fiberparent |
FiberParent |
GUID |
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
globalid |
GlobalID |
GlobalID |
|
last_edited_date |
last_edited_date |
Date |
|
last_edited_user |
last_edited_user |
String |
|
objectid |
ObjectID |
OID |
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
Bundle
Name: Bundle
Display Field: Bundle Name
Type: Table
The bundle is a collection of ribbons (and a ribbon is a collection of fiber strands). These act in a similar way to buffertubes: they provide organization for all the fibers.
|
Field |
Alias |
Type |
|---|---|---|
|
bundlecolor |
Bundle Color |
String |
|
bundlename |
Bundle Name |
String |
|
bundlenumber |
Bundle Number |
Integer |
|
bundleposition |
Bundle Position |
Integer |
|
created_date |
created_date |
Date |
|
created_user |
created_user |
String |
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
fiberparent |
FiberParent |
GUID |
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
globalid |
GlobalID |
GlobalID |
|
last_edited_date |
last_edited_date |
Date |
|
last_edited_user |
last_edited_user |
String |
|
objectid |
ObjectID |
OID |
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
Circuit
Name: Circuit
Display Field: CircuitName
Type: Table
A circuit represents a "chain of glass" from one location to another. This chain of glass should have a port on either end and strands of fiber in between that are connected end to end.
|
Field |
Alias |
Type |
|---|---|---|
|
channel |
Channel |
String |
|
circuitlength |
Length |
Double |
|
circuitname |
Name |
String |
|
circuitstatus |
Status |
String |
|
created_date |
created_date |
Date |
|
created_user |
created_user |
String |
|
fibercircuitgraph |
FiberCircuitGraph |
String |
|
fibercircuitheaderclass |
FiberCircuitHeaderClass |
String |
|
fibercircuitheaderglobalid |
FiberCircuitHeaderGlobalID |
GUID |
|
fiberlambda |
Wavelength (nm) |
Double |
|
globalid |
GlobalID |
GlobalID |
|
last_edited_date |
last_edited_date |
Date |
|
last_edited_user |
last_edited_user |
String |
|
lastuser |
LastUser |
String |
|
objectid |
ObjectID |
OID |
CircuitComponent
Name: CircuitComponent
Display Field: ElementModelName
Type: Table
This object table is designed to keep track of all facilities that compose each circuit. However, it is currently not used by the application and is likely to be deprecated. It remains in the data model for now, as it is easier to remove a deprecated table later than add one back in.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
circuitguid |
CircuitGuid |
GUID |
|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
elementguid |
ElementGuid |
GUID |
|
|
elementmodelname |
ElementModelName |
String |
|
|
featureguid |
FeatureGuid |
GUID |
|
|
featuremodelname |
FeatureModelName |
String |
|
|
globalid |
globalid |
GlobalID |
|
|
graphid |
GraphId |
Integer |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
Dev
Name: Dev
Display Field: Name
Type: Table
This is an object class to represent the physical device located at the site.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultdeviceheight |
DefaultDeviceHeight |
Integer |
|
|
defaultdevicewidth |
DefaultDeviceWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
field |
Field |
Integer |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
name |
Name |
String |
|
|
numberofportcolumns |
NumberOfPortColumns |
Integer |
|
|
numberofportrows |
NumberOfPortRows |
Integer |
|
|
objectid |
ObjectID |
OID |
|
|
positiononrack |
PositionOnRack |
Integer |
|
|
sideofrackshownon |
SideOfRackShownOn |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
DevPort
Name: DevPort
Display Field: PortNumber
Type: Table
This is an object class to represent the ports on the device. Because this kind of device is an end point, the fiber strands are connected to the ports, and there are no subsequent connections.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultheight |
DefaultHeight |
Integer |
|
|
defaultwidth |
DefaultWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberdsllambda |
FiberDslLambda |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
lambdamax |
LambdaMax |
Double |
|
|
lambdamin |
LambdaMin |
Double |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portnumber |
Num |
Integer |
|
|
portpositiononcard |
PositionOnCard |
Integer |
|
|
portpositionondevice |
PortPositionOnDevice |
Integer |
|
|
portstatus |
PortStatus |
Integer |
|
|
porttype |
Type |
String |
|
|
sideofrackshownon |
SideOfRackShownOn |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
Strand
Name: Strand
Display Field: FiberName
Type: Table
This is an object class to represent a single glass strand within a buffer tube that is used to transmit light from one location to another. This strand table is the child of buffertube, as opposed to ribbon strand, which is the child of ribbon.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
available |
Available |
Integer |
|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fibercolor |
Color |
String |
|
|
fibername |
Name |
String |
|
|
fibernumber |
Num |
Integer |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
modetype |
ModeType |
String |
|
|
objectid |
ObjectID |
OID |
|
|
status |
Status |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
Connection
Name: Connection
Display Field: ContainerClassModelName
Type: Table
This object table is used to create connections between fibers, ports, device ports, and splitter ports. These objects are represented as the lines that connect objects in the Fiber Connections dialog.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
aclassmodelname |
AClassModelName |
String |
|
|
aconnectionobjectglobalid |
AConnectionObjectGlobalID |
GUID |
|
|
attenuation1310 |
Atten1310 |
Double |
|
|
attenuation1550 |
Atten1550 |
Double |
|
|
bclassmodelname |
BClassModelName |
String |
|
|
bconnectionobjectglobalid |
BConnectionObjectGlobalID |
GUID |
|
|
containerclassmodelname |
ContainerClassModelName |
String |
|
|
containerglobalid |
ContainerGlobalID |
GUID |
|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
splicetype |
SpliceType |
String |
|
|
traynumber |
Tray |
Integer |
FrontPort
Name: FrontPort
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the front side of the fiber ports. Typically, the front sides of the ports provide service to customer devices or can act as jumper points.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultheight |
DefaultHeight |
Integer |
|
|
defaultwidth |
DefaultWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portname |
Name |
String |
|
|
portnumber |
Num |
Integer |
|
|
portpositiononcard |
Position |
Integer |
|
|
portstatus |
Port Status |
Integer |
|
|
porttype |
Type |
String |
|
|
sidesofrackshownon |
SidesOfRackShownOn |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
Passive Device Common Port
Name: Passive Device Common Port
Display Field: Port Name or PortNumber
Type: Table
This is an object class to represent the common port on a passive device. It receives the signal.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberdsllambda |
FiberDslLambda |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
height |
Height |
Integer |
|
|
lambdamax |
LambdaMax |
Double |
|
|
lambdamin |
LambdaMin |
Double |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portname |
PortName |
String |
|
|
portnumber |
PortNumber |
Integer |
|
|
portpositionondevice |
PortPositionOnDevice |
Integer |
|
|
portstatus |
Port Status |
Integer |
|
|
porttype |
PortType |
String |
|
|
sides |
Sides |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
|
|
width |
Width |
Integer |
Passive Device
Name: Passive Device
Display Field: DeviceName
Type: Table
This is an object class to represent a fiber device that is not powered (for example, an optical splitter). They are typically intermediary devices between the source and receiving ends of the signal.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
deviceheight |
DeviceHeight |
Integer |
|
|
devicename |
DeviceName |
String |
|
|
deviceposition |
DevicePosition |
Integer |
|
|
devicewidth |
DeviceWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
sides |
Sides |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
Passive Device Split Port
Name: Passive Device Split Port
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the split port on a passive device. After the device splits the signal, it transmits out these split ports. The ports are related “siblings” to the common port.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberdsllambda |
FiberDslLambda |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
height |
Height |
Integer |
|
|
impliedalignment |
ImpliedAlignment |
Integer |
|
|
impliedconnectionsourceguid |
ImpliedConnectionSourceGuid |
GUID |
|
|
lambdamax |
LambdaMax |
Double |
|
|
lambdamin |
LambdaMin |
Double |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portname |
PortName |
String |
|
|
portnumber |
PortNumber |
Integer |
|
|
portpositionondevice |
PortPositionOnDevice |
Integer |
|
|
portstatus |
Port Status |
Integer |
|
|
porttype |
PortType |
String |
|
|
sides |
Sides |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
|
|
width |
Width |
Integer |
PP
Name: PP
Display Field: Name
Type: Table
This is an object class to represent the panel that holds the cards.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultcardheight |
DefaultCardHeight |
Integer |
|
|
defaultcardwidth |
DefaultCardWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
name |
Name |
String |
|
|
numberofcardcolumns |
NumberOfCardColumns |
Integer |
|
|
numberofcardrows |
NumberOfCardRows |
Integer |
|
|
objectid |
ObjectID |
OID |
|
|
rackposition |
RackPosition |
Integer |
|
|
racksides |
RackSides |
String |
|
|
slotorientation |
SlotOrientation |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
PPCard
Name: PPCard
Display Field: ObjectID
Type: Table
This is an object class to represent the patch panel card that holds the ports. The card is the piece of hardware that is inserted into a patch panel, and it contains one or more optical ports. From a data model perspective, the card forms a convenient “container” to group a collection of ports within a patch panel. The card does not have many distinct characteristics beyond this purpose.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
appearsonracksides |
AppearsOnRackSides |
String |
|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultportheight |
DefaultPortHeight |
Integer |
|
|
defaultportwidth |
DefaultPortWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
numberofportcolumns |
NumberOfPortColumns |
Integer |
|
|
numberofportrows |
NumberOfPortRows |
Integer |
|
|
objectid |
ObjectID |
OID |
|
|
slotposition |
Position |
Integer |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
Rack
Name: Rack
Display Field: Name
Type: Table
This is an object class to represent the physical rack that holds the patch panels in a patch location facility.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
defaultslotheight |
DefaultSlotHeight |
Integer |
|
|
defaultslotwidth |
DefaultSlotWidth |
Integer |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
name |
Name |
String |
|
|
objectid |
ObjectID |
OID |
|
|
sides |
Sides |
String |
|
|
slotcolumns |
SlotColumns |
Integer |
|
|
slotrows |
SlotRows |
Integer |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
Ribbon
Name: Ribbon
Display Field: Name
Type: Table
The ribbon is a collection of fiber strands that provides organization for all the fibers (and ribbons are organized together in bundles). These act in a similar way to buffertubes.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
color |
Color |
String |
|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
name |
Name |
String |
|
|
objectid |
ObjectID |
OID |
|
|
ribbonnumber |
Number |
Integer |
|
|
ribbonposition |
Position |
Integer |
|
|
ribonname |
Color Name |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
Ribbon Strand
Name: RibbonStrand
Display Field: Fiber Name
Type: Table
This is an object class to represent a single glass strand within a bundle/ribbon that is used to transmit light from one location to another. This ribbon strand table is the child of ribbon, as opposed to strand, which is the child of buffertube.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
available |
Available |
String |
|
|
cablenumber |
Cable Number |
Integer |
|
|
color |
Color |
String |
|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fibername |
Fiber name |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
modetype |
Mode Type |
String |
|
|
objectid |
ObjectID |
OID |
|
|
status |
Status |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
SE_AU_EXEC_OPTIONS__
Name: SE_AU_EXEC_OPTIONS__
Display Field: created_user
Type: Table
This is an object class that acts as a “staging table” for auto-updaters. As end users interact with fiber assets, this table collects and stores information that is then processed by auto-updaters. As rows are processed, they are removed from this table automatically.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
OBJECTID |
OBJECTID |
OID |
|
|
GlobalID |
GlobalID |
GlobalID |
|
|
created_user |
created_user |
String |
|
|
created_date |
created_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
OPTIONS |
OPTIONS |
BLOB |
Shelf
Name: Shelf
Display Field: ShelfName
Type: Table
This is an object class to represent the shelf on which fiber devices sit inside a patch location. It serves the same purpose as a rack: it supports fiber assets inside a patch location.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
numberofdevicecolumns |
NumberOfDeviceColumns |
Integer |
|
|
numberofdevicerows |
NumberOfDeviceRows |
Integer |
|
|
objectid |
ObjectID |
OID |
|
|
rackposition |
RackPosition |
Integer |
|
|
shelfheight |
ShelfHeight |
Integer |
|
|
shelfname |
ShelfName |
String |
|
|
shelfwidth |
ShelfWidth |
Integer |
|
|
sides |
Sides |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
SplitIn
Name: SplitIn
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the input or common port.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portnumber |
Port Number |
Integer |
|
|
portname |
Port Name |
String |
|
|
portstatus |
Port Status |
Integer |
|
|
porttype |
Type |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |
SplitOut
Name: SplitOut
Display Field: PortName or PortNumber
Type: Table
This is an object class to represent the split ports. The ports are related “siblings” to the input port.
|
Field |
Alias |
Type |
Notes |
|---|---|---|---|
|
created_date |
created_date |
Date |
|
|
created_user |
created_user |
String |
|
|
fiberchildclassmodelname |
FiberChildClassModelName |
String |
|
|
fiberparent |
FiberParent |
GUID |
|
|
fiberparentclassmodelname |
FiberParentClassModelName |
String |
|
|
globalid |
GlobalID |
GlobalID |
|
|
impliedalignment |
ImpliedAlignment |
Integer |
|
|
impliedconnectionsourceguid |
ImpliedConnectionSourceGuid |
GUID |
|
|
last_edited_date |
last_edited_date |
Date |
|
|
last_edited_user |
last_edited_user |
String |
|
|
objectid |
ObjectID |
OID |
|
|
portnumber |
Port Number |
Integer |
|
|
portstatus |
Port Status |
Integer |
|
|
porttype |
Type |
String |
|
|
thisfiberclassmodelname |
ThisFiberClassModelName |
String |
|
|
toplevelcmn |
TopLevelCMN |
String |
|
|
toplevelguid |
TopLevelGuid |
GUID |