{ "currentVersion": 10.91, "id": 27, "name": "F_CIRCUIT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CIRCUITNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CIRCUITNAME", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "CIRCUITLENGTH", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "CHANNEL", "type": "esriFieldTypeString", "alias": "Channel", "length": 255, "domain": { "type": "codedValue", "name": "WS2_Fiber Circuit Channel", "description": "", "codedValues": [ { "name": "CHAN01", "code": "CHAN01" }, { "name": "CHAN02", "code": "CHAN02" }, { "name": "CHAN03", "code": "CHAN03" }, { "name": "CHAN04", "code": "CHAN04" }, { "name": "CHAN05", "code": "CHAN05" }, { "name": "CHAN06", "code": "CHAN06" }, { "name": "CHAN07", "code": "CHAN07" }, { "name": "CHAN08", "code": "CHAN08" }, { "name": "CHAN09", "code": "CHAN09" }, { "name": "CHAN10", "code": "CHAN10" }, { "name": "CHAN11", "code": "CHAN11" }, { "name": "CHAN12", "code": "CHAN12" }, { "name": "CHAN13", "code": "CHAN13" }, { "name": "CHAN14", "code": "CHAN14" }, { "name": "CHAN15", "code": "CHAN15" }, { "name": "CHAN16", "code": "CHAN16" }, { "name": "CHAN17", "code": "CHAN17" }, { "name": "CHAN18", "code": "CHAN18" }, { "name": "CHAN19", "code": "CHAN19" }, { "name": "CHAN20", "code": "CHAN20" }, { "name": "CHAN21", "code": "CHAN21" }, { "name": "CHAN22", "code": "CHAN22" }, { "name": "CHAN23", "code": "CHAN23" }, { "name": "CHAN24", "code": "CHAN24" }, { "name": "CHAN25", "code": "CHAN25" }, { "name": "CHAN26", "code": "CHAN26" }, { "name": "CHAN27", "code": "CHAN27" }, { "name": "CHAN28", "code": "CHAN28" }, { "name": "CHAN29", "code": "CHAN29" }, { "name": "CHAN30", "code": "CHAN30" }, { "name": "CHAN31", "code": "CHAN31" }, { "name": "CHAN32", "code": "CHAN32" }, { "name": "CHAN33", "code": "CHAN33" }, { "name": "CHAN34", "code": "CHAN34" }, { "name": "CHAN35", "code": "CHAN35" }, { "name": "CHAN36", "code": "CHAN36" }, { "name": "CHAN37", "code": "CHAN37" }, { "name": "CHAN38", "code": "CHAN38" }, { "name": "CHAN39", "code": "CHAN39" }, { "name": "CHAN40", "code": "CHAN40" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIRCUITOTDRATTEN1310", "type": "esriFieldTypeDouble", "alias": "OTDRAtten1310", "domain": null }, { "name": "CIRCUITOTDRATTEN1550", "type": "esriFieldTypeDouble", "alias": "OTDRAtten1550", "domain": null }, { "name": "OTDRDATE", "type": "esriFieldTypeDate", "alias": "OTDRDATE", "length": 8, "domain": null }, { "name": "CIRCUITPOWERMETERATTEN1310", "type": "esriFieldTypeDouble", "alias": "CIRCUITPOWERMETERATTEN1310", "domain": null }, { "name": "CIRCUITPOWERMETERATTEN1550", "type": "esriFieldTypeDouble", "alias": "CIRCUITPOWERMETERATTEN1550", "domain": null }, { "name": "POWERMETERDATE", "type": "esriFieldTypeDate", "alias": "POWERMETERDATE", "length": 8, "domain": null }, { "name": "OTDR_FILE_HOTLINK", "type": "esriFieldTypeString", "alias": "OTDR_FILE_HOTLINK", "length": 255, "domain": null }, { "name": "OTDR_FILE_DATE", "type": "esriFieldTypeDate", "alias": "OTDR_FILE_DATE", "length": 8, "domain": null }, { "name": "EMERGENCYCONTACTNAME", "type": "esriFieldTypeString", "alias": "EMERGENCYCONTACTNAME", "length": 255, "domain": null }, { "name": "EMERGENCYCONTACTPHONENUM", "type": "esriFieldTypeString", "alias": "EMERGENCYCONTACTPHONENUM", "length": 50, "domain": null }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "CREATIONUSER", "length": 255, "domain": null }, { "name": "CREATIONDATE", "type": "esriFieldTypeDate", "alias": "CREATIONDATE", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "LASTUSER", "length": 255, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "length": 8, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FIBERPARENT", "type": "esriFieldTypeGUID", "alias": "FIBERPARENT", "length": 38, "domain": null }, { "name": "THISFIBERCLASSMODELNAME", "type": "esriFieldTypeString", "alias": "THISFIBERCLASSMODELNAME", "length": 255, "domain": null }, { "name": "FIBERPARENTCLASSMODELNAME", "type": "esriFieldTypeString", "alias": "FIBERPARENTCLASSMODELNAME", "length": 255, "domain": null }, { "name": "FIBERCHILDCLASSMODELNAME", "type": "esriFieldTypeString", "alias": "FIBERCHILDCLASSMODELNAME", "length": 255, "domain": null }, { "name": "WORKREQUESTID", "type": "esriFieldTypeString", "alias": "Work Request ID", "length": 20, "domain": null }, { "name": "DESIGNID", "type": "esriFieldTypeString", "alias": "Design ID", "length": 20, "domain": null }, { "name": "WORKLOCATIONID", "type": "esriFieldTypeString", "alias": "Work Location ID", "length": 20, "domain": null }, { "name": "WORKFLOWSTATUS", "type": "esriFieldTypeInteger", "alias": "Work Flow Status", "domain": { "type": "codedValue", "name": "WS2_MM Work Flow Status", "description": "Miner & Miner Work Flow Status", "codedValues": [ { "name": "None", "code": 0 }, { "name": "In Design", "code": 1 }, { "name": "Pending Approval", "code": 2 }, { "name": "Construction Approved", "code": 3 }, { "name": "In Construction", "code": 4 }, { "name": "Built", "code": 5 }, { "name": "Closed", "code": 6 }, { "name": "Cancelled", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WORKFUNCTION", "type": "esriFieldTypeInteger", "alias": "Work Function", "domain": { "type": "codedValue", "name": "WS2_MM Work Function", "description": "Miner & Miner Work Function", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Install", "code": 1 }, { "name": "Remove", "code": 2 }, { "name": "Abandon", "code": 32 }, { "name": "Retire", "code": 16 }, { "name": "Replace", "code": -10 }, { "name": "Existing", "code": 8192 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FIBERCIRCUITHEADERCLASS", "type": "esriFieldTypeString", "alias": "FIBERCIRCUITHEADERCLASS", "length": 255, "domain": null }, { "name": "FIBERCIRCUITHEADERGLOBALID", "type": "esriFieldTypeGUID", "alias": "FIBERCIRCUITHEADERGLOBALID", "length": 38, "domain": null }, { "name": "FIBERCIRCUITTRACESTYLE", "type": "esriFieldTypeInteger", "alias": "FIBERCIRCUITTRACESTYLE", "domain": { "type": "codedValue", "name": "WS2_TraceStyle", "description": "", "codedValues": [ { "name": "Y-style", "code": 0 }, { "name": "X-style", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FIBERCIRCUITGROUP", "type": "esriFieldTypeString", "alias": "FiberCircuitGroup", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Fiber Circuit Group", "description": "", "codedValues": [ { "name": "10-100 Ethernet", "code": "10-100 Ethernet" }, { "name": "10G Ethernet", "code": "10G Ethernet" }, { "name": "CWDM", "code": "CWDM" }, { "name": "DS0", "code": "DS0" }, { "name": "DS1", "code": "DS1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIRCUITSTATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Fiber Circuit Status", "description": "", "codedValues": [ { "name": "Dark", "code": "Dark" }, { "name": "Lit", "code": "Lit" }, { "name": "Reserved", "code": "Reserved" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FIBERLAMBDA", "type": "esriFieldTypeDouble", "alias": "Wavelength", "domain": null }, { "name": "FIBERCIRCUITGRAPH", "type": "esriFieldTypeString", "alias": "Graph", "length": 1073741822, "domain": null }, { "name": "CIRCUITTYPE", "type": "esriFieldTypeString", "alias": "CIRCUITTYPE", "length": 255, "domain": { "type": "codedValue", "name": "WS2_Fiber Circuit Type", "description": "", "codedValues": [ { "name": "1G Ethernet", "code": "1G Ethernet" }, { "name": "10G Ethernet", "code": "10G Ethernet" }, { "name": "10M Ethernet", "code": "10M Ethernet" }, { "name": "CWDM", "code": "CWDM" }, { "name": "Dark Fiber", "code": "Dark Fiber" }, { "name": "DWDM", "code": "DWDM" }, { "name": "OC3", "code": "OC3" }, { "name": "OC12", "code": "OC12" }, { "name": "OC48", "code": "OC48" }, { "name": "OC192", "code": "OC192" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R18_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_18", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G98FIBERCIRCUITH", "fields": "FIBERCIRCUITHEADERGLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G98FIBERPARENT", "fields": "FIBERPARENT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }