Datadictionary description

(RINGBESTEMMINGDETAIL)
Aanmeldaccounts(AANMELDACCOUNTS)
Aanvraag(AANVRAAG)
Accesspoint(TABAP)
Afwerkeenheidnamen(AFWERKEENHEIDNAMEN)
Aggregation(AGGR)
Annotations(ANNOTATIONS)
Annotation_ductbank(ANNOTATION_DUCTBANK)
Annotation_ospspan(ANNOTATION_OSPSPAN)
Area contract(AREA_CONTRACT)
Atriggerlog(ATRIGGERLOG)
Building(TABBDG)
Cable(CABLE)
Calendar(CALENDAR)
Calendarautorization(CALENDARAUT)
Changed splice(SPLICETRAY_CHANGED)
Coconblocked(COCONBLOCKED)
Coconchanges(COCONCHANGES)
Coconcolors(COCONCOLORS)
Coconsettings(COCONSETTINGS)
Coconstyles(COCONSTYLES)
Cocontimer(COCONTIMER)
Cocontimer_mi(COCONTIMER_MI)
Coconuse(COCONUSE)
Coconuser(COCONUSER)
Coconusergroup(COCONUSERGROUP)
Connectordetail(SOORTAFWERKEENHEIDDETAIL)
Contact person(CONTACTS)
Contract(KLANTCONTRACT)
Contractcontacts(CONTRACTCONTACTS)
Contracttype(CONTRACTTYPE)
Crc32files(CRC32FILES)
Ctwbackup(CTWBACKUP)
Ctwsync(CTWSYNC)
Customer(KLANT)
Customer user(USER_KLANT_ACCESS)
DP area(TABDP)
Drawing(DRAWINGINFO)
Drawing object(TABMID)
Drawing revision(DRAWINGREVISION)
Drawing trace(DRAWINGTRACE)
Drilling(TABBOR)
Duct(INNERDUCT)
Ductsplice(DUCTSPLICE)
Email address(EMAILADRESSEN)
Enclosure(ENCLOSURE)
Enclosure(TABENC)
Equipmentports(EQUIPMENTPORTS)
Equipmenttypes(EQUIPMENTTYPES)
Expression(EXPR)
Fiberusage(FIBERUSAGE)
Frame(FIBERMNGR)
Frame(TABFRA)
Functie(FUNCTIE)
Functieaut(FUNCTIEAUT)
Incident(INCIDENT)
Incidentobject(INCIDENTOBJECT)
Installcompany user(USER_INSTALLCOMPANY)
Kabelwerkdwgcalc(KABELWERKDWGCALC)
Kabelwerkitems(KABELWERKITEMS)
Kastblokkering(KASTBLOKKERING)
KLIC drawing(DRAWINGKLIC)
Label(LABEL)
Leaselines(LEASELINES)
Locatie_vertaling(LOCATIE_VERTALING)
Location(PLACE)
Matrixcategory(MATRIXCATEGORY)
Mutaties(MUTATIES)
Network area(NET_AREA)
Networkspeed(NETWORKSPEED)
Net_trouble(NET_TROUBLE)
Ospspanfiber(OSPSPANFIBER)
Outage(OUTAGE)
Outageobject(OUTAGEOBJECT)
Patch(PATCHNW)
Patch order(PATCHORDER)
Patch position(PPS_LIJNBENAMING)
Pcc_aanvraag(PCC_AANVRAAG)
Pcc_adres(PCC_ADRES)
Pcc_autorisatie(PCC_AUTORISATIE)
Pcc_relaties(PCC_RELATIES)
Permit(TABGUN)
POP contract(PLACE_CONTRACT)
Project(KABELWERK)
Project asset(PROJECTASSETS)
Project calculation(PROJECTCALCULATE)
Project log(PROJECTLOG)
Projectbevestiging(PROJECTBEVESTIGING)
Projectcontrols(PROJECTCONTROLS)
Projectdocuments(PROJECTDOCUMENTS)
Projectmeldingen(PROJECTMELDINGEN)
Projectstructure(PROJECTSTRUCTURE)
Question(QUESTIONS)
RASS termination point(AFWERKPUNT_RASS)
RASS termination unit(AFWERKEENHEID_RASS)
Regionaut(REGIONAUT)
Reserveringsbuffer(RESERVERINGSBUFFER)
Rfts(RFTS)
Ring_tabel(RING_TABEL)
Route(ROUTE)
Routeaddress(ROUTEADRES)
Routerequest(ROUTEREQUEST)
Saplease(SAPLEASE)
Section(SECTIE)
Server(SERVER)
Service(SITESRV)
Signaltypes(SIGNALTYPES)
Soortafwerkeenheid(SOORTAFWERKEENHEID)
Span(OSPSPAN)
Span(SPAN)
Spanlength(SPANLENGTH)
Splice(SPLICETRAY)
Spliceunit(SPLICEUNIT)
Stati(STATI)
Statusaut(STATUSAUT)
Survey object(TABSUR)
Tabblo(TABBLO)
Tabcab(TABCAB)
Tablelock(TABLELOCK)
Tablog(TABLOG)
Tabmes(TABMES)
Tabmsg(TABMSG)
Tabrem(TABREM)
Tabsla(TABSLA)
Tabwijz(TABWIJZ)
Teller(TELLER)
Termination point(AFWERKPUNT_PPS)
Termination unit(AFWERKEENHEID_PPS)
Thematic Project(THEMATICPROJECT)
Tracedocuments(TRACEDOCUMENTS)
Tracelas(TRACELAS)
Traceoutage(TRACEOUTAGE)
Tracepatch(TRACEPATCH)
Traceproject(TRACEPROJECT)
Tracetabrem(TRACETABREM)
Traceuser(TRACEUSER)
Trench(DUCTBANK)
Trench(TABCON)
UI setting(UISETTING)
Userlog(USERLOG)
Verbinding(VERBINDING)
Web session(WEBSESSION)
Web statistics(WEBSTATS)
WorkOn file(WORKONFILE)
WorkOn splice(WORKONLAS)
Workonobject(WORKONOBJECT)

Aanmeldaccounts (AANMELDACCOUNTS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
ACCOUNT* Account Alphanumeric(50) No
MOBIELNUMMER Mobielnummer Alphanumeric(20) No
CERTIFICAATNUMMER Certificaatnummer Alphanumeric(50) No
STARTDATUM_CERTIFICAAT Startdatum_certificaat Datetime No
EINDDATUM_CERTIFICAAT Einddatum_certificaat Datetime No
TYPE_BLOKKERING Type_blokkering Alphanumeric(50) No
REDEN_BLOKKERING Reden_blokkering Alphanumeric(500) No
STARTDATUM_BLOKKERING Startdatum_blokkering Datetime No
EINDDATUM_BLOKKERING Einddatum_blokkering Datetime No
GEBOORTEDATUM_ACCOUNT Geboortedatum_account Datetime No
UPDATEUSER Edited by Alphanumeric(50) No
UPDATETIME Edited Datetime No

Aanvraag (AANVRAAG)
Request for new labels
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
AANVRAGER Applicant Alphanumeric(50) No Requesting user
AANVRAAGDATUM Aanvraagdatum Datetime No Date of the request
VERLOOPDATUM Verloopdatum Datetime No Date when request expires
PROJECTNUMMER Projectnummer Alphanumeric(40) Yes Hoofdletters Identification of the project

Afwerkeenheidnamen (AFWERKEENHEIDNAMEN)
Naming convention
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
SOORT* Soort Alphanumeric(50) No Identification of the object
NAAM* Naam Alphanumeric(50) No Description of the allowed name # = numeric position @ = Alpha numeric position

Termination unit (AFWERKEENHEID_PPS)
Patch units above the ground
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
PLACE_ID* Location Numeric non-decimal(11) Yes Verwijst naar: Location
LOCATIE_ID Location Numeric non-decimal(11) No Identification of the object
AFWERKEENHEID_NAAM* Frame Alphanumeric(50) No Hoofdletters Name of termination unit (frame name)
AFWERKEENHEIDNUMMER* Patch unit nr Alphanumeric(50) No Hoofdletters Number of the patch panel
SOORT_AFWERKEENHEID Type Alphanumeric(25) No Verwijst naar: Soortafwerkeenheid Identification of the object
STATUS* Status Alphanumeric(1) Yes Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
KASTZIJDE* Frame side Alphanumeric(2) Yes Lijstwaarde: KASTZIJDE Side of the frame (front or rear)
LEFTPOSITION Left position Numeric decimal(6,1) No
HOOGTE_EENHEID Height unit Numeric non-decimal(5) Yes Identification of the heigth position in a frame
INSTALLCOMPANY Install company Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF
PROJECTNUMMER Project Alphanumeric(50) Yes Hoofdletters, Verwijst naar: Project Identification of the project
DATUM_GESCHOOND Preview date Date No Date when patch unit was last checked and cleaned
RESERVERINGSDATUM Date reservation Datetime Yes Date of reservation
OWNER Owner Alphanumeric(20) Yes Lijstwaarde: OWNER Purpose of the object (access, core etc.)
AVAILABLE_FOR_SALES Available for sales Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
SERIENUMMER Serial number Alphanumeric(50) No
AANVRAGER Applicant Alphanumeric(50) no User who requested the reservation
TEKENINGNUMMER Drawing number Alphanumeric(250) no Number or name of a drawing involved
EXTERNAL_REF External ref Alphanumeric(32) No
OLO Olo Numeric non-decimal(11) No
ETT Ett Numeric non-decimal(2) Yes
DETAILSTATUS Detailstatus Alphanumeric(1) No
MONITOR_IN_USE Monitor in use Numeric non-decimal(1) No
MAINTAINER Maintainer Numeric non-decimal(11) No
MONITOR_IN_USE_INFO Monitor in use info Alphanumeric(255) No
COMMENTS Comments Alphanumeric(500) No
EQUIPMENTTYPE_ID Equipmenttype id Numeric non-decimal(11) No
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record

RASS termination unit (AFWERKEENHEID_RASS)
Splice units above the ground
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
PLACE_ID* Place id Numeric non-decimal(11) Yes Verwijst naar: Location
LOCATIE_ID Location Numeric non-decimal(11) No Identification of the object
AFWERKEENHEID_NAAM* Frame Alphanumeric(50) No Name of termination unit (frame name)
AFWERKEENHEIDNUMMER* Splice. unit nr Alphanumeric(50) No Number of the splicing shelf
SOORT_AFWERKEENHEID Type Alphanumeric(25) No Verwijst naar: Soortafwerkeenheid Identification of the object
STATUS* Status Alphanumeric(1) Yes Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
KASTZIJDE* Frame side Alphanumeric(2) Yes Lijstwaarde: KASTZIJDE Side of the frame (front or rear)
LEFTPOSITION Left position Numeric decimal(6,1) No
HOOGTE_EENHEID Height unit Numeric non-decimal(5) Yes Identification of the heigth position in a frame
RESERVERINGSDATUM Reservation date Datetime Yes Date of reservation
PROJECTNUMMER Project Alphanumeric(50) Yes Hoofdletters, Verwijst naar: Project Identification of the project
OWNER Owner Alphanumeric(20) Yes Lijstwaarde: OWNER Purpose of the object (access, core etc.)
INSTALLCOMPANY Install company Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF
DATUM_GESCHOOND Preview date Datetime No Date when patch unit was last checked and cleaned
SERIENUMMER Serial number Alphanumeric(50) No
AANVRAGER Applicant Alphanumeric(50) no User who requested the reservation
TEKENINGNUMMER Drawing number Alphanumeric(250) no Number or name of a drawing involved
EXTERNAL_REF External ref Alphanumeric(32) No
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
OLO Olo Numeric non-decimal(11) No
AVAILABLE_FOR_SALES Available for sales Alphanumeric(1) No

Termination point (AFWERKPUNT_PPS)
Trays in patch units
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
AFWERKEENHEID_ID Termination unit Numeric non-decimal(11) No Verwijst naar: Termination unit Unique id for a patch panel
TRAYNUMMER Tray Alphanumeric(10) Yes Number of the tray
POSITIE_LAAG Position from Numeric non-decimal(5) No Lowest position on the tray for the concerning record
KABEL_ID Cable ID Numeric non-decimal(11) Yes Verwijst naar: Span Identification of the object
VEZEL_LG Fiber from Numeric non-decimal(11) No Fiber number from
VEZEL_HG Fiber to Numeric non-decimal(11) No Fiber number to
AANTAL_POSITIES # positions Numeric non-decimal(5) No Number of postions in a tray
KABEL_NAAM Cable name Alphanumeric(50) Yes Hoofdletters Name or number of a cable(span)
BESTEMMING Destination Alphanumeric(103) No Direction of the cable
CONNECTORTYPE Connector type Alphanumeric(20) No Stamtabel: CONNECTORTYPE Type of connector used on the invloved positions
PROJECTNUMMER Project number Alphanumeric(50) Yes Hoofdletters, Verwijst naar: Project Identification of the project
STATUS State Alphanumeric(1) Yes Status of the object 0(reserved), 1 (in use), 2 (cease)
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
COMMENTS Comments Alphanumeric(50) No

RASS termination point (AFWERKPUNT_RASS)
Cassettes in spliceunits
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
AFWERKEENHEID_ID Termination unit Numeric non-decimal(11) No Verwijst naar: RASS termination unit Unique id for a splicing shelf
NAARPPSNUMMER To patchunit Alphanumeric(50) no Patch panel number at the other side of the pigtail
TRAYNUMMER To tray Alphanumeric(10) Yes Number of the tray where pigtail goes
CASSETTENUMMER Cassette Alphanumeric(3) Yes Number of the cassette in a splicing shelf
POSITIENUMMER Position Numeric non-decimal(11) Yes Number of the position in the cassette
KABEL_ID Cable ID Numeric non-decimal(11) No Verwijst naar: Span Identification of the object
VEZEL_LG Fiber from Numeric non-decimal(11) No Fiber number from
VEZEL_HG Fiber to Numeric non-decimal(11) No Fiber number to
BESTEMMING End point Alphanumeric(60) Yes Direction of the cable
KABEL_NAAM Cable name Alphanumeric(50) Yes Hoofdletters Name or number of a cable(span)
NAARAFWERKEENHEID_NAAM To termination unit Alphanumeric(50) No Name of the splicing shelf related to the splice (other side)
NAARRASS To rass Alphanumeric(50) no Number of the splicing shelf related to the splice (other side)
NAARCASSETTE To casette Alphanumeric(3) No Number of the cassette related to the splice (other side)
NAARPOS Position Numeric non-decimal(11) No Position number related to the splice (other side)
NAAROK Splice Alphanumeric(1) Yes Indication the splice on a splicing shelf is correctly registered
CASSTEMP Casstemp Alphanumeric(50) No Temporarely field
PROJECTNUMMER Project number Alphanumeric(40) Yes Hoofdletters, Verwijst naar: Project Identification of the project
STATUS Status Alphanumeric(1) Yes Status of the object 0(reserved), 1 (in use), 2 (cease)
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change

Aggregation (AGGR)
Properties
Technical name Label Type Mandatory Entry info Description
ACTIVE_OPERATORS Active operators Alphanumeric(50) No
ADDRESS_FIBER Address fiber Numeric non-decimal(3) Yes
ADDRESS_SLACK_DISTANCE Distance slack house Numeric decimal(10,2) No
ADMINISTRATORS Administrators Alphanumeric(50) No
AREA_ACTIVE_OPERATORS Area active operators Alphanumeric(50) No
AREA_ADMINISTRATORS Area administrators Alphanumeric(50) No
AREA_OPERATORS Area operators Alphanumeric(50) No
AREA_PROVIDERS Area providers Alphanumeric(50) No
BAG_ADDRESSES Number of BAG addresses Numeric non-decimal(3) Yes
BBLOCATION BB location Alphanumeric(50) No
BB_LENGTH BB length Numeric decimal(10,2) No
BLOW_LENGTH Blow length Numeric decimal(10,2) No
COCONLOCATION FTTH location Alphanumeric(50) No
DIG_LENGTH Dig length Numeric non-decimal(10) No
ENVIRONMENT_IMAGE Environment image Blob No
FIBERMNGR_FRAME Frame Alphanumeric(50) No
HIGHWAY_CROSSINGS Highway crossings Numeric non-decimal(10) No
KMZ_FILE Kmz file Blob No
MAINROAD_CROSSINGS Mainroad crossings Numeric non-decimal(10) No
MIGRATED_OPERATOR_ORDERID Migrated operator orderid Alphanumeric(32) Yes
MIGRATED_ORDER Migrated order Numeric non-decimal(10) No
MONTHLYCODE Monthy amount address code Alphanumeric(5) No
NETWORK_LENGTH Network length Numeric non-decimal(10) No
NUM_CONNECTIONS Number of connections Numeric non-decimal(10) No
NUM_FIBERS Number of fibers Numeric non-decimal(10) No
ODF_FIBER_PLANNED_ORDER Planned odf fiber order Numeric non-decimal(10) No
ONCEONLYCODE Once-only amount address code Alphanumeric(5) No
OPERATORS Operators Alphanumeric(50) No
PATCH_PAYABLE_FROM Patch payable from Datetime Yes
PATCH_PAYABLE_TO Patch payable to Datetime Yes
PATCH_RELEASED Patch released Datetime Yes
PATCH_RENEWED Patch renewed Datetime Yes
PATCH_SUCCEEDED Patch succeeded Datetime Yes
PLANNED_ALTERNATE_ORDER Planned order other fiber Numeric non-decimal(10) No Planned order for other address fiber
PREVIOUS_ALTERNATE_ORDER Previous order other fiber Numeric non-decimal(10) No Previous closed order for other address fiber
PREVIOUS_ORDER Previous order Numeric non-decimal(10) No Previous closed order for same address fiber
PROVIDERS Providers Alphanumeric(50) No
RAILWAY_CROSSINGS Railway crossings Numeric non-decimal(10) No
REDEMPTIONCODE Redemption amount address code Alphanumeric(5) No
ROUTING_LENGTH Routing length Numeric non-decimal(10) No
SLACK Slack Numeric non-decimal(1) No Lijstwaarde: YESNO
WATERWAYSLENGTH Waterwayslength Numeric decimal(10,2) No
WATER_CROSSINGS Water crossings Numeric non-decimal(10) No

Annotations (ANNOTATIONS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
DEPTH Depth Numeric non-decimal(22) Yes
COMMENTS Comments Alphanumeric(1000) No
UPDATEUSER Updateuser Alphanumeric(50) No
UPDATETIME Updatetime Datetime No
MI_SYMBOLOGY Mi_symbology Alphanumeric(50) No
GEOLOC Geo Geometry Yes

Annotation_ductbank (ANNOTATION_DUCTBANK)
Properties
Technical name Label Type Mandatory Entry info Description
ANNOTATION_ID Annotation_id Numeric non-decimal(11) Yes Systeemveld, Verwijst naar: Annotations
DUCTBANK_ID Ductbank_id Numeric non-decimal(11) Yes Systeemveld, Verwijst naar: Trench

Annotation_ospspan (ANNOTATION_OSPSPAN)
Properties
Technical name Label Type Mandatory Entry info Description
ANNOTATION_ID Annotation_id Numeric non-decimal(11) Yes Systeemveld, Verwijst naar: Annotations
OSPSPAN_ID Ospspan_id Numeric non-decimal(11) Yes Systeemveld, Verwijst naar: Span

Area contract (AREA_CONTRACT)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
NET_AREA_ID* Area Numeric non-decimal(10) Yes Verwijst naar: Network area
KLANTCONTRACT_ID* Contract Numeric non-decimal(10) Yes Verwijst naar: Contract
FIBERS_USED Fibers to be used Numeric non-decimal(1) Yes Lijstwaarde: FIBERS_USED
FTTH FTTH Numeric non-decimal(1) Yes Lijstwaarde: YESNO
FTTO FTTO Numeric non-decimal(1) Yes Lijstwaarde: YESNO
FTTS FTTS Numeric non-decimal(1) Yes Lijstwaarde: YESNO
P2P P2P Numeric non-decimal(1) Yes Lijstwaarde: YESNO
COAX Coax Numeric non-decimal(1) Yes Lijstwaarde: YESNO
ADMINISTRATION Administration Numeric non-decimal(1) Yes Lijstwaarde: YESNO
LEASE Lessee Numeric non-decimal(1) Yes Lijstwaarde: YESNO
SERVICES Services Numeric non-decimal(1) Yes Lijstwaarde: YESNO

Atriggerlog (ATRIGGERLOG)
Properties
Technical name Label Type Mandatory Entry info Description
TIME Time Datetime No Systeemveld
TRIGGER Trigger Alphanumeric(21) No Systeemveld
LINE Line Alphanumeric(2) No Systeemveld
NEW_LOCATIE_ID New_locatie_id Numeric non-decimal(11) No Systeemveld
NEW_PLACE_ID New_place_id Numeric non-decimal(11) No Systeemveld
OLD_LOCATIE_ID Old_locatie_id Numeric non-decimal(11) No Systeemveld
OLD_PLACE_ID Old_place_id Numeric non-decimal(11) No Systeemveld

Cable (CABLE)
Physical part of a cable, part of a span, lines or slacks
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Objectid Numeric non-decimal(11) Yes Unique identification of this object
PLACEOBJECTID Placeobjectid Numeric non-decimal(11) No Verwijst naar: Location ID of location
DESCRIPTION Description Alphanumeric(10) No Indicates that a cable part is a line or a slack
COMMENTS Comments Alphanumeric(250) No Comments field, free format
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)

Calendar (CALENDAR)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
CALENDARNAME* Calendarname Alphanumeric(40) Yes
UPDATETIME Edited Datetime Yes Systeemveld
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld

Calendarautorization (CALENDARAUT)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
STATUSID Statusid Numeric non-decimal(11) No
GROUPID Groupid Numeric non-decimal(11) No
CALENDARID Calenderid Numeric non-decimal(11) Yes Verwijst naar: Calendar

Coconblocked (COCONBLOCKED)
For userid's who logged in three times in a wrong way
Properties
Technical name Label Type Mandatory Entry info Description
COMPUTERNAME Computername Alphanumeric(100) No Name of the computer
USERNAME Username Alphanumeric(100) No Login name of the user
DATUMTIJD Datumtijd Datetime No Date and time locking the user

Coconchanges (COCONCHANGES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(22) Yes Systeemveld
ACTION Action Numeric decimal(22) Yes
GEOLOC Geo Geometry No
MI_STYLE Mi_style Alphanumeric(254) No
STATUS Status Numeric decimal(22) Yes
UPDATEUSER Edited by Alphanumeric(50) No
SUBMITTED Submitted Datetime No
PROCESSED Processed Datetime No
PARAMS Params Alphanumeric(4000) No
RESULT Result Alphanumeric(250) No

Coconcolors (COCONCOLORS)
Colorcodes and detailed information on cable types
Properties
Technical name Label Type Mandatory Entry info Description
TYPEID Typeid Alphanumeric(50) Yes Type of the object
VEZELNUMMER Fiber number Numeric non-decimal(5) Yes Fiber number
TUBENUMMER Tuber number Numeric non-decimal(5) No Number of the tube
KABELKLEUR Cable color Alphanumeric(50) No Color abbreviation
TUBEKLEUR Tube color Alphanumeric(50) No Color abbreviation
VEZELKLEUR Fiber color Alphanumeric(50) No Color abbreviation
KABELKLEURCODE Color code Alphanumeric(50) No Colorcode representing the color of the cable in a numeric way
TUBEKLEURCODE Tube color code Alphanumeric(50) No Colorcode representing the color of the tube in a numeric way
VEZELKLEURCODE Fiber color code Alphanumeric(50) No Colorcode representing the color of the fiber in a numeric way
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
VEZEL_TYPE Fiber type Alphanumeric(10) No Type of quality of the fiber (G.652 etc)
VEZELSTATUS Fiber status Numeric non-decimal(2) No
VEZELTWIST Fiber twist Numeric decimal(3,1) No

Coconsettings (COCONSETTINGS)
Special settings for Cocon
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
SECTION* Section Alphanumeric(255) Yes Lijstwaarde: COCONSETTING_SECTION
KEY* Key Alphanumeric(255) Yes
VALUE Value Alphanumeric(255) No
COMMENTS Comments Alphanumeric(3000) No Comments field, free format

Coconstyles (COCONSTYLES)
Styles, colors, symbols etc. per type of object per status
Properties
Technical name Label Type Mandatory Entry info Description
TABEL* Tabel Alphanumeric(20) No Table involved
STATUS* Status Alphanumeric(6) No Status of the object 0(reserved), 1 (in use), 2 (cease)
OBJECTTYPE* Objecttype Alphanumeric(200) No Type of object involved
PEN Pen Alphanumeric(30) No Mi-code for pen stype of the object
BRUSH Brush Alphanumeric(30) No Mi-code for brush (filling) stype of the object
SYMBOL Symbol Alphanumeric(40) No Indicates the symbol used in the geography

Cocontimer (COCONTIMER)
Execution times for sql-statements with an executiontime longer than given time
Properties
Technical name Label Type Mandatory Entry info Description
DATUMTIJD Datumtijd Datetime Yes Date and time slow sql
LOOPTIJD Looptijd Numeric non-decimal(38) Yes Duration of a SQL statement
SQLSTATEMENT Sqlstatement Alphanumeric(4000) No Statement used for performance measurements
USERNAAM Usernaam Alphanumeric(50) No Login name of the user

Cocontimer_mi (COCONTIMER_MI)
Execution times for mapinfo-statements with an executiontime longer than given time
Properties
Technical name Label Type Mandatory Entry info Description
DATUMTIJD Datumtijd Datetime Yes Date and time slow sql
LOOPTIJD Looptijd Numeric non-decimal(38) Yes Duration of a Mapinfo statement
SQLSTATEMENT Sqlstatement Alphanumeric(4000) No Mapinfo command
USERNAAM Usernaam Alphanumeric(50) No Login name of the user

Coconuse (COCONUSE)
History with average performance of the appliaction
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(38) Yes Systeemveld Identification of the object
DATUMTIJD Datumtijd Datetime Yes
AANTALGEBRUIKERS Aantalgebruikers Numeric non-decimal(38) Yes
RESPONSTIJD Responstijd Numeric non-decimal(38) Yes

Coconuser (COCONUSER)
User info
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
USERID* Name Alphanumeric(50) No Login name of the user
GROUPID Group Alphanumeric(50) No Name of the group users
VOORNAAM First name Alphanumeric(20) Yes Firstname of user
ACHTERNAAM Last name Alphanumeric(30) Yes Last name of the user
USER_ALIAS Alias Alphanumeric(50) no
AFDELING Department Alphanumeric(20) Yes Department of the user
GEBOUW Building Alphanumeric(30) Yes Building of the room
KAMERNUMMER Room Alphanumeric(20) Yes Room number of the cocon user
EMAILADRES Mail address Alphanumeric(50) Yes Email address
TELEFOONNUMMER Telephone number Alphanumeric(15) Yes Telephone number
GEINSTALLEERD Installed Numeric non-decimal(1) No Lijstwaarde: YESNO Indication Cocon is installed
INSTALLATIEDATUM Installed Date No Date of installation
GEBRUIKCOCON Use Cocon Alphanumeric(1) Yes Lijstwaarde: YESNO_UPPER Indication may use Cocon
GEBRUIKCOCONTHEWEB Use CoconTheWeb Alphanumeric(1) Yes Lijstwaarde: YESNO_UPPER Indication may use CoconTheWeb
GEBRUIKKLICONTHEWEB Use KliconTheWeb Alphanumeric(1) No Lijstwaarde: YESNO_UPPER
TOONRFTS Show RFTS Numeric non-decimal(1) No Lijstwaarde: YESNO Indication may see
KLANTID Customer Numeric non-decimal(11) No Verwijst naar: Customer Identification of the object
INSTALLCOMPANY Contractor Alphanumeric(50) no STATI_OMS:INSTALLATIEBEDRIJF
ISLASSER Welder Alphanumeric(1) No Lijstwaarde: YESNO_UPPER
AUTORISATIE_MELDINGEN Authorizatiion messages Alphanumeric(1) No Lijstwaarde: YESNO_UPPER
WACHTWOORDCHANGE Pwd change Numeric non-decimal(1) No Lijstwaarde: YESNO Password must be changed
AUTORISATIEAANVRAAG Authorization request Datetime No Date of requesting the user autorization
PWCHANGED Pwd changed Datetime No Password must be changed
VALID_TELEFOONNUMMER Valid telephone niumber Alphanumeric(10) no
WACHTWOORD Wachtwoord Alphanumeric(255) No Password
EINDDATUM Einddatum Date No
MAGCONCON11STARTEN Magcocon11starten Alphanumeric(1) No
WINDOWSVERSION Windowsversion Alphanumeric(40) No
MAGCOCON10GEBRUIKEN Magcocon10gebruiken Alphanumeric(1) No
USERCM Usercm Alphanumeric(50) No
WACHTWOORDCM Wachtwoordcm Alphanumeric(255) No
COMPONENTVERSIE Componentversie Alphanumeric(1) Yes
MAPINFOINSTALLED Mapinfoinstalled Numeric non-decimal(1) No Indicates that MapInfo is correctly installed
EMAILADRESFOUTIEF Emailadresfoutief Numeric non-decimal(11) No Identification of the object
WW1 Ww1 Alphanumeric(255) No Password history
WW2 Ww2 Alphanumeric(255) No Password history
WW3 Ww3 Alphanumeric(255) No Password history
WW4 Ww4 Alphanumeric(255) No Password history
WW5 Ww5 Alphanumeric(255) No Password history
WW6 Ww6 Alphanumeric(255) No Password history
ORACLEDRIVERAANWEZIG Oracledriveraanwezig Numeric non-decimal(1) No Indication Oracle-client correct installed
DOTNETVERSIE Dotnetversie Alphanumeric(10) No
ORACLECLIENTVERSIE Oracleclientversie Alphanumeric(10) No
EXTERNAL_REF External ref Alphanumeric(32) No

Coconusergroup (COCONUSERGROUP)
Usergroup info
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
GROUPID* Groupid Alphanumeric(50) No Name of the group users
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)

Contact person (CONTACTS)
Contact persons (contract or customer)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
KLANTID* Customer Numeric non-decimal(11) Yes Verwijst naar: Customer Identification of the object
CONTACTNAAM* Name Alphanumeric(150) no Hoofdletters Name of contact person
FUNCTIE Function Alphanumeric(50) no Contact persons function
CONTACTTYPE Main contact Alphanumeric(1) Yes Lijstwaarde: COCONCONTACTTYPE Indication of the type of contract
STRAAT Street Alphanumeric(50) no Street of contactperson
HUISNUMMER House number Alphanumeric(21) no Hoofdletters Year of installing the object
POSTCODE Zipcode Alphanumeric(6) no Hoofdletters Zipcode of contact
PLAATSNAAM City Alphanumeric(50) no Hoofdletters City of contact person
TELEFOONNUMMER Telephone Alphanumeric(50) no Telephone number
MOBIELNUMMER Mobile phone Alphanumeric(50) no Mobile number of contact person
TELEFOONNUMMERWEEKEND Telephone weekend Alphanumeric(50) no Telephone number in weekend
EMAILADRES Email address Alphanumeric(255) no Emailaddress of a contact
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record
EXTERNAL_REF External ref Alphanumeric(32) No Link between EOS, WorkOn/Cocon/CRUD

Contractcontacts (CONTRACTCONTACTS)
Contacts per contract
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
CONTRACTID* Contract Numeric non-decimal(11) Yes Verwijst naar: Contract Identification of the object
CONTACTSID* Contact Numeric non-decimal(11) Yes Verwijst naar: Contact person Identification of the object
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record

Contracttype (CONTRACTTYPE)
Default contracts
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
OMSCHRIJVING* Contract type Alphanumeric(50) no Description of the type of contract
MAXTTR Maxttr Alphanumeric(20) no Maximum TIME TO repair
SERVICEFROM Servicefrom Alphanumeric(5) no Hour the service may start
SERVICETO Serviceto Alphanumeric(5) no Hour the service must stop
SERVICEFROM_WEEKEND Servicefrom_weekend Alphanumeric(5) no Hour the service may start in the weekend
SERVICETO_WEEKEND Serviceto_weekend Alphanumeric(5) no Hour the service must stop in the weekend
INTERRUPTNOTIFICATION Interruptnotification Numeric non-decimal(3) Yes Number of days before outage
WORKNOTIFICATION_SA Worknotification_sa Numeric non-decimal(3) Yes Number of days before actual work SA
WORKNOTIFICATION_PSA Worknotification_psa Numeric non-decimal(3) Yes Number of days before actual workPSA
PENALTY_PER_HOUR Penalty_per_hour Numeric non-decimal(5) Yes Penalty per hour
PENALTY_PER_DAY Penalty_per_day Numeric non-decimal(5) Yes Penalty per day
HOURS_PENALTY_FREE Hours_penalty_free Numeric non-decimal(5) Yes Penalty free period
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record

Crc32files (CRC32FILES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes
OBJECTTYPE* Objecttype Alphanumeric(15) Yes
SUBFOLDER* Subfolder Alphanumeric(80) No
FILENAME* Filename Alphanumeric(70) Yes
OBJECTID Objectid Numeric non-decimal(10) No
DATECREATED Datecreated Datetime Yes
DATEMODIFIED Datemodified Datetime Yes
DATEACCEPTED Dateaccepted Datetime No
CRC32 Crc32 Alphanumeric(50) No

Ctwbackup (CTWBACKUP)
Properties
Technical name Label Type Mandatory Entry info Description
TABLE_NAME Table_name Alphanumeric(40) No
PK_FIELD1 Pk_field1 Alphanumeric(40) No
PK_FIELD2 Pk_field2 Alphanumeric(40) No
PK_FIELD3 Pk_field3 Alphanumeric(40) No
PK_VALUE1 Pk_value1 Alphanumeric(100) No
PK_VALUE2 Pk_value2 Alphanumeric(100) No
PK_VALUE3 Pk_value3 Alphanumeric(100) No
ACTION Action Alphanumeric(1) No
STATUS Status Numeric non-decimal(1) No
TIME_STAMP Time_stamp Datetime No
PK_NEWVALUE1 Pk_newvalue1 Alphanumeric(100) No
PK_NEWVALUE2 Pk_newvalue2 Alphanumeric(100) No
PK_NEWVALUE3 Pk_newvalue3 Alphanumeric(100) No
PK_FIELD4 Pk_field4 Alphanumeric(40) No
PK_VALUE4 Pk_value4 Alphanumeric(100) No
PK_NEWVALUE4 Pk_newvalue4 Alphanumeric(100) No

Ctwsync (CTWSYNC)
Properties
Technical name Label Type Mandatory Entry info Description
TABLE_NAME Table_name Alphanumeric(40) No
PK_FIELD1 Pk_field1 Alphanumeric(40) No
PK_FIELD2 Pk_field2 Alphanumeric(40) No
PK_FIELD3 Pk_field3 Alphanumeric(40) No
PK_VALUE1 Pk_value1 Alphanumeric(100) No
PK_VALUE2 Pk_value2 Alphanumeric(100) No
PK_VALUE3 Pk_value3 Alphanumeric(100) No
ACTION Action Alphanumeric(1) No
STATUS Status Numeric non-decimal(1) No
TIME_STAMP Time_stamp Datetime No
PK_NEWVALUE1 Pk_newvalue1 Alphanumeric(100) No
PK_NEWVALUE2 Pk_newvalue2 Alphanumeric(100) No
PK_NEWVALUE3 Pk_newvalue3 Alphanumeric(100) No
PK_FIELD4 Pk_field4 Alphanumeric(40) No
PK_VALUE4 Pk_value4 Alphanumeric(100) No
PK_NEWVALUE4 Pk_newvalue4 Alphanumeric(100) No

Drawing (DRAWINGINFO)
Support table for Reggefiber
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
TEKENING* Drawing Alphanumeric(50) Yes
POPNAAM POP Alphanumeric(50) No
BOUWNUMMER Buildnumber Alphanumeric(10) No
STATUS Status Alphanumeric(1) No
STATUSUPDATETIME Statusupdatetime Datetime No
UPDATETIME Edited Datetime No
VERVANGENDOOR_ID Vervangendoor id Numeric non-decimal(10) No Verwijst naar: Drawing
VERVALLEN Vervallen Alphanumeric(1) No

KLIC drawing (DRAWINGKLIC)
Support table for Reggefiber
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
DRAWINGINFO_ID* Drawinginfo id Numeric non-decimal(10) Yes Verwijst naar: Drawing
FOLDER Folder Alphanumeric(200) No
VERWERKT Verwerkt Datetime No

Drawing revision (DRAWINGREVISION)
Support table for Reggefiber
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
DRAWINGINFO_ID* Drawinginfo id Numeric non-decimal(10) Yes Verwijst naar: Drawing
REVISIENUMMER* Revisienummer Numeric non-decimal(10) Yes
CREATEREASON Createreason Alphanumeric(1) Yes
CREATEINFO Createinfo Alphanumeric(50) No
CREATED Created Datetime Yes
CREATEAANNEMER Createaannemer Alphanumeric(50) No
CREATEUSER Createuser Alphanumeric(100) No
TRENCHLENGTH Trench length Numeric non-decimal(11) No
ACCESSLENGTH Accessnet length Numeric non-decimal(11) No

Drawing trace (DRAWINGTRACE)
Support table for Reggefiber
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
DRAWINGINFO_ID Drawinginfo id Numeric non-decimal(10) Yes Verwijst naar: Drawing
CREATEREASON Createreason Alphanumeric(1) Yes
CREATEINFO Createinfo Alphanumeric(50) No
CREATED Created Datetime Yes
CREATEAANNEMER Createaannemer Alphanumeric(50) No
CREATEUSER Createuser Alphanumeric(100) No
DRAWINGTIME Drawingtime Datetime No
EXECUTED Executed Datetime No
FOUTMELDING Error Alphanumeric(255) No

Trench (DUCTBANK)
Duct routes non-geo
Properties
Technical name Label Type Mandatory Entry info Description
PLACEOBJECTID Object ID Numeric non-decimal(11) Yes ID of location
DUCTBANKID Name Alphanumeric(50) No Hoofdletters Identification of the object
DUCTBANKTYPE Type Alphanumeric(50) No Stamtabel: SOORTTRAJECT Type of ductroute
START_PLACE Start location Alphanumeric(100) No Hoofdletters, Verwijst naar: Location Name of the location where duct route ends
END_PLACE End location Alphanumeric(100) No Hoofdletters, Verwijst naar: Location Name of the location where duct route starts
STAGE State Alphanumeric(20) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
OWNER Owner Alphanumeric(50) No Lijstwaarde: OWNER Purpose of the object (access, core etc.)
WORKORDER Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Project number
INSTALLCOMPANY Install company Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF Company who installed the involved objects
INSTALLYEAR Install year Numeric non-decimal(11) No Year of installing the object
INSTALLMONTH Install month Numeric non-decimal(11) No The month the object was built
INSTALLDAY Install day Numeric non-decimal(11) No The day the object was built
PRECISION Precision Numeric non-decimal(4) Yes Indication of precision
ROUTEID Route Numeric non-decimal(10) No Verwijst naar: Network area Indicating to which route a duct route belongs
ROUTETYPE Route type Alphanumeric(10) No Lijstwaarde: ROUTETYPE Type route (fiber or copper)
ROUTE_INDIV Area Alphanumeric(50) No Indicates that a duct route is manualy linke to a route
OPENBAARREGISTERSTATUS Public register status Numeric non-decimal(1) No Stamtabel: OPENBAARREGISTER
WIONGEDEPONEERD Wion deposited Date No
USER1 User1 Alphanumeric(15) No Not used
COMMENTS Comments Alphanumeric(250) No Comments field, free format
EXTERNAL_REF External ref Alphanumeric(32) No
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Ductsplice (DUCTSPLICE)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
PLACEOBJECTID Placeobjectid Numeric non-decimal(10) Yes Verwijst naar: Location
BUIS_ID_A Buis id a Numeric non-decimal(10) Yes Verwijst naar: Duct
BUIS_ID_B Buis id b Numeric non-decimal(10) Yes Verwijst naar: Duct
SPLICED Spliced Numeric non-decimal(1) No Lijstwaarde: YESNO
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld
UPDATETIME Edited Datetime No Systeemveld

Email address (EMAILADRESSEN)
Validated mailadressen
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
AANNEMER* Aannemer Alphanumeric(100) Yes
EMAILADRES* Emailadres Alphanumeric(100) Yes

Enclosure (ENCLOSURE)
Enclosures (splice units mainly under ground)
Properties
Technical name Label Type Mandatory Entry info Description
ENCLOSUREID Enclosure id Alphanumeric(50) Yes Hoofdletters Name of the enclosure
OBJECTID* Object id Numeric non-decimal(11) No Unique identification of this object
PLACEOBJECTID Location Numeric non-decimal(11) Yes Verwijst naar: Location ID of location
TYPEID Type Alphanumeric(50) Yes Stamtabel: ENCLOSURE Type of the object
WORKORDER Project Alphanumeric(40) Yes Verwijst naar: Project Project number
STAGE Status Alphanumeric(25) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
ENCLOSUREOWNER Owner Alphanumeric(40) No Stamtabel: OLO Owner of the enclosure
DEFAULTNACHTWERK Default night work Alphanumeric(1) No
INSTALLCOMPANY Install company Alphanumeric(50) Yes STATI_OMS:INSTALLATIEBEDRIJF Company who installed the involved objects
INSTALLYEAR Install year Numeric non-decimal(11) No Year of installing the object
INSTALLMONTH Install month Numeric non-decimal(11) No The month the object was built
INSTALLDAY Install day Numeric non-decimal(11) No The day the object was built
EXTERNAL_REF Extrenal ref Alphanumeric(32) No
ZVALUECM Z in cm Numeric non-decimal(5) No
ENCLOSURECOMMENTS Comments Alphanumeric(1000) Yes Comments field, free format
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Equipmentports (EQUIPMENTPORTS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
EQUIPMENTTYPE_ID* Equipmenttype_id Numeric non-decimal(11) Yes Verwijst naar: Equipmenttypes
IDX* Idx Numeric non-decimal(11) Yes
LABEL* Label Alphanumeric(50) Yes
PORTMODE* Portmode Numeric non-decimal(3) Yes
SIGNALTYPE_ID Signaltype_id Numeric non-decimal(11) No Verwijst naar: Signaltypes
CONNECTORTYPE Connectortype Alphanumeric(50) Yes
FORWARD Forward Numeric non-decimal(1) Yes
ATTENUATION Attenuation Numeric decimal(10,1) Yes

Equipmenttypes (EQUIPMENTTYPES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
NAME* Name Alphanumeric(50) Yes
DESCRIPTION Description Alphanumeric(255) Yes
MONITOR Monitor Numeric non-decimal(1) Yes
POWERED Powered Numeric non-decimal(1) Yes
BLOCKED Blocked Numeric non-decimal(1) Yes
HEIGHT Height Numeric non-decimal(11) Yes
WIDTH Width Numeric non-decimal(11) Yes
DEPTH Depth Numeric non-decimal(11) Yes
UPDATEUSER Updateuser Alphanumeric(50) No
UPDATETIME Updatetime Datetime Yes

Expression (EXPR)
Properties
Technical name Label Type Mandatory Entry info Description
AANTAL_DP Count dp Numeric non-decimal(10) No
ACTIVE Active Numeric non-decimal(1) No
AFSTAND Distance Numeric non-decimal(10) No
AFSTAND2 Distance2 Numeric non-decimal(10) No
ALIAS Alias Alphanumeric(32) No
ALIGNMENT Align Alphanumeric(1) No Lijstwaarde: ALIGNMENT
APPLICATION Application Alphanumeric(16) No
AVAILABLE_SERVICE Available service Numeric non-decimal(1) No Lijstwaarde: AVAILABLE_SERVICE
AVERAGE Average Numeric non-decimal(10) No
BUIS2_14 Buis2*14 Numeric non-decimal(10) No
BUIS2_16 Buis2*16 Numeric non-decimal(10) No
CHILDREN Children Numeric non-decimal(1) No
CODE Code Alphanumeric(12) No
COLUMNWIDTH Width Numeric non-decimal(3) No
CONDITION Condition Alphanumeric(255) No
CONNECTSTRING Connectstring Alphanumeric(255) No
CONTEXT Context Alphanumeric(255) No
CUSTOMER Customer Alphanumeric(32) No
DELIVERED Delivered Datetime No
DEMP1310 Attn1310 Numeric decimal(10) No
DEMP1550 Attn1550 Numeric decimal(10) No
DEMP1625 Attn1625 Numeric decimal(10) No
DESCENDING Descending Numeric non-decimal(1) No Lijstwaarde: YESNO
DESCRIPTION Description Alphanumeric(50) No
DISPLAY Display Numeric non-decimal(10) No Lijstwaarde: YESNO
DISPLAYFORMAT Displayformat Alphanumeric(24) No
DISTANCE Distance Numeric decimal(10,2) No
DRILLINGCOLUMN Drilling Alphanumeric(10) No
DUMMY Dummy Alphanumeric(10) No
DURATION Duration Numeric non-decimal(5) No
DURATION_IN_SEC Duration Numeric non-decimal(5) No
EINDAFWERKING Eindafwerking Alphanumeric(120) Yes Systeemveld
ERROR Error description Memo No
FCODE Fcode Alphanumeric(10) No
FIELD Field Alphanumeric(24) No
FUNCTION Function Alphanumeric(16) No
GEOLOC Geometry Geometry No
GRAPH Graph Blob No
IMAGE Image Alphanumeric(0) No
INGEO In Geo Alphanumeric(10) No
INSTALLDATE Install date Date No
INV_AFSTAND Inv afstand Numeric non-decimal(10) No
INV_FRAME_ENC Inv frame enc Alphanumeric(100) No
INV_LOCATIENAAM Inv locatienaam Alphanumeric(100) No
KABEL2VEZ Cable 2 fibers Numeric non-decimal(10) No
KABEL96VEZ Cable 96 fibers Numeric non-decimal(10) No
KANAAL Channel Numeric non-decimal(20) No Hoofdletters
LABEL Label Alphanumeric(24) No
LASTCHANGE Last change Datetime No
LOOKUP Lookup Alphanumeric(16) No
MANDATORY Mandatory Numeric non-decimal(1) No Lijstwaarde: YESNO
MAXIMUM Maximum Numeric non-decimal(10) No
MINIMUM Minimum Numeric non-decimal(10) No
MODULE Module Alphanumeric(24) No
NAME Name Alphanumeric(24) No
NETWORK_CONCEPT Network concept Alphanumeric(2) No Lijstwaarde: NETWORK_CONCEPT
NOWRAP No wrap Numeric non-decimal(1) No Lijstwaarde: YESNO
OBJECT Object (Trace/HH/Drill) Alphanumeric(10) No
ODF_PORT_STATE ODF port state Numeric non-decimal(1) No Lijstwaarde: ODF_PORT_STATE
OPERAND_TYPE Type Numeric non-decimal(1) No Lijstwaarde: OPERAND_TYPE
OPERATION Operation Alphanumeric(5) No
ORDER Order Alphanumeric(50) No Lijstwaarde: ORDER
PARAMETERS Parameters Alphanumeric(255) No
PARSEMOMENT Parse moment Numeric non-decimal(10) No Lijstwaarde: PARSEMOMENT
PROPERTY Property Alphanumeric(24) No
RECORDCOUNT Recordcount Numeric non-decimal(10) No
RECORDNUMBER Recordnumber Numeric non-decimal(5) No
ROUTING_ERROR Routing error Memo No
SEARCH_CABLEID Cable ID Numeric non-decimal(10) No
SEARCH_OBJECTID ObjectID Alphanumeric(10) No
SEARCH_OBJECTNAME Object name Alphanumeric(100) No
SEARCH_STA Sta Numeric non-decimal(1) No
SEGMENT Segment Numeric non-decimal(10) No
SEQUENCE Sequence Numeric non-decimal(10) No
SOURCE_VALUE Source value Alphanumeric(255) No
SUM Sum Numeric non-decimal(10) No
TABLAAG Tablayer Alphanumeric(10) No
TABLE Table Alphanumeric(12) No
TARGET_VALUE Target value Alphanumeric(255) No
TOTAAL1310 Total1310 Numeric decimal(10) No
TOTAAL1550 Total1550 Numeric decimal(10) No
TOTAAL1625 Total1625 Numeric decimal(10) No
TOTAAL_BORINGEN Total drilling Numeric non-decimal(10) No
TOTAAL_DP_WONINGEN Total dp houses Numeric non-decimal(10) No
TOTAAL_LENGTE_GEUL Total length trace Numeric non-decimal(10) No
TREELEVEL Treelevel Numeric non-decimal(3) No
TYPE Type Alphanumeric(24) No
UPDATEFIELD Field to update Numeric non-decimal(10) No
VALUE Value Alphanumeric(50) No
VERSION Version Numeric non-decimal(6) No
VIA_LOCATIONS Via locations Alphanumeric(255) No
WEEK Weeknumber Numeric non-decimal(2) No

Frame (FIBERMNGR)
Frames
Properties
Technical name Label Type Mandatory Entry info Description
FIBERMNGRID Frame name Alphanumeric(100) Yes Hoofdletters Name of a frame
OBJECTID* Object id Numeric non-decimal(11) No Unique identification of this object
PLACEOBJECTID Location Numeric non-decimal(11) No Verwijst naar: Location ID of location
SOORTKAST Type of frame Alphanumeric(50) No Stamtabel: SOORTKAST Type of frame
TYPEID Default termination unit Alphanumeric(50) Yes
VERDIEPING Floor Alphanumeric(50) No Floor
RUIMTE Room Alphanumeric(500) No Room/place/spot
RIJ Row Alphanumeric(8) No
FLOORTILE Floortile Alphanumeric(8) No
INSTALLCOMPANY Install company Alphanumeric(50) Yes STATI_OMS:INSTALLATIEBEDRIJF Company who installed the involved objects
WORKORDER Project number Alphanumeric(40) Yes Verwijst naar: Project Project number
INSTALLYEAR Install year Numeric non-decimal(11) No Year of installing the object
INSTALLMONTH Install month Numeric non-decimal(11) No The month the object was built
INSTALLDAY Install day Numeric non-decimal(11) No The day the object was built
STAGE Status Alphanumeric(25) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
DATUM_GESCHOOND Date last survey Date No Date cleaned
FRAMEOWNER Owned by Alphanumeric(50) No Stamtabel: OLO
AUTORISATIENIVEAU Authorisation level Alphanumeric(2) no Lijstwaarde: AUTORISATIENIVEAU
COUNTFROMBOTTOM Count from bottom Alphanumeric(1) No Lijstwaarde: JANEE
COMMENTS Comments Alphanumeric(200) Yes Comments field, free format
TEKENINGNUMMER Drawing number Alphanumeric(250) No Number or name of a drawing involved
EXTERNAL_REF External ref Alphanumeric(32) No
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Fiberusage (FIBERUSAGE)
Fibers with an indication if they are in use or will be used for (ac)counting
Properties
Technical name Label Type Mandatory Entry info Description
SPANID Spanid Numeric non-decimal(11) Yes Verwijst naar: Ospspanfiber Unique number for a cable(span) between two manipulatable locations
VEZELNUMMER Vezelnummer Numeric non-decimal(11) Yes Verwijst naar: Ospspanfiber
VRIJ Vrij Alphanumeric(1) No
BEPAALD Bepaald Alphanumeric(1) No

Functie (FUNCTIE)
Functions in Cocon
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
MENUNAAM* Menunaam Alphanumeric(50) No Menu name in Cocon
PRESENTEREN Presenteren Numeric non-decimal(5) No Must the function be visible
LOKAALTOEGESTAAN Lokaaltoegestaan Numeric non-decimal(1) No Indication function may be used in the local version of cocon

Functieaut (FUNCTIEAUT)
Function autorized to users
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
GROUPID Groupid Numeric non-decimal(11) No Verwijst naar: Coconusergroup Name of the group users
USERID Userid Numeric non-decimal(11) No Verwijst naar: Coconuser Login name of the user
FUNCTIEID Functieid Numeric non-decimal(11) No Verwijst naar: Functie Identification of the object
ALLOWED Allowed Numeric non-decimal(11) No Indication is a function allowed or not

Incident (INCIDENT)
Incidents on network objects
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
STARTDATUM Startdatum Datetime Yes Date when incident started
STARTTIJD Starttijd Alphanumeric(5) No Time incident started
EINDDATUM Einddatum Datetime No Date when incident was finished
EINDTIJD Eindtijd Alphanumeric(5) No Time incident ended
BESCHRIJVING Beschrijving Alphanumeric(2000) Yes Description of the incident
STATUS Status Alphanumeric(20) Yes Status of the incident
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
KENMERK Kenmerk Alphanumeric(50) No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Incidentobject (INCIDENTOBJECT)
Objects involved in a incident
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
INCIDENTID* Incidentid Numeric non-decimal(11) Yes Verwijst naar: Incident Identification of the object
OBJECTID* Objectid Numeric non-decimal(11) Yes Unique identification of this object
OBJECTSOORT* Objectsoort Alphanumeric(8) Yes Indicates the type of linked object
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
Y Y Numeric decimal(10,1) No
X X Numeric decimal(10,1) No

Duct (INNERDUCT)
Duct
Properties
Technical name Label Type Mandatory Entry info Description
AUTOINDEX Id Numeric non-decimal(11) Yes Systeemveld Unique id for this object
PLACEOBJECTID* Trench Numeric non-decimal(11) No Verwijst naar: Trench ID of location
BUISNUM* Tube number Alphanumeric(50) No Hoofdletters Number/name/color of a duct
SUBDUCT* Subduct Alphanumeric(50) No Hoofdletters Identification of the object
TYP Type Alphanumeric(50) No Stamtabel: SUBDUCTSYSTEEM Type of the object
SPANID Cable ID Numeric non-decimal(11) No Verwijst naar: Span Unique number for a cable(span) between two manipulatable locations
OWNER Owner Alphanumeric(50) No Lijstwaarde: OWNER Purpose of the object (access, core etc.)
STATUS State Alphanumeric(1) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
DIAMETER Diameter Numeric decimal(126) No Diameter
SUBDUCTDIAMETER Subduct diameter Numeric decimal(11) No Diameter of the sub duct
GAUGE Size inside Alphanumeric(15) No Size inside
BUISKLEUR Duct color Alphanumeric(6) no Color of the duct
SUBDUCTKLEUR Subduct color Alphanumeric(10) no Color of subduct
USED Used Numeric non-decimal(1) No Systeemveld Detremines when a duct is inuse
DUCTOWNER Duct owner Alphanumeric(40) Yes Stamtabel: OLO Owner of the duct
DUCTUSER User Alphanumeric(40) Yes User of the duct
DUCTCOMMENTS Remarks Alphanumeric(40) Yes Comments field, free format
REELNUMBER Reel number Alphanumeric(50) No Number of the reel
COMMENTS Remarks Alphanumeric(200) No Comments field, free format
MEASUREA Measure A Numeric decimal(11,1) No Measurement line side a
MEASUREB Measure B Numeric decimal(11,1) No Measurement line side b
PORT_A Port A Alphanumeric(8) No
PORT_B Port B Alphanumeric(8) No
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
MAINTAINER Maintainer Numeric non-decimal(11) No
BUISVERBINDINGNUMMER To be deleted Numeric non-decimal(11) No Systeemveld

Project (KABELWERK)
Project info
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
TTNR* Project name Alphanumeric(40) Yes Hoofdletters Trouble ticketnumber = projectnumber
PROJECTSOORT Type Alphanumeric(1) Yes Stamtabel: PROJECTSRT Identification of the type of project
PROJECTOWNER Project owner Alphanumeric(50) Yes Identification of the project
AFGESLOTEN Project closed Alphanumeric(1) No Lijstwaarde: JANEE_UPPER Project is closed
STATUS Status Alphanumeric(1) Yes Stamtabel: KABELWERK Status of the project
DETAILSTATUS Detailed status Alphanumeric(1) Yes Stamtabel: DETAILSTATUS
PROJECTSTATUS Progress status Alphanumeric(1) no Lijstwaarde: PROJECTSTATUS
PROJECTCODE AP projectcode Alphanumeric(15) No
STARTDATUM Start date Datetime Yes Date when project starts
EINDDATUM End date Datetime Yes Date when project will be ready
GEACCEPTEERD Accepted Datetime No
INBEHEER In maintainance Datetime No
ENGINEERINGDATUM Engineering date Datetime Yes Date when engineering will be ready
TECHNISCHDATUM Ready for service date Datetime Yes Date when project will be technical ready
MEETRAPPORTENDATUM OTDR processed date Datetime Yes Date when measurements will be ready
REVISIEDATUM Ready for operation date Datetime Yes Date when the revision will be ready
DEFAULT_INSTALLDATE Default installdate Date No Default value for installation date
BEVROREN Frozen Datetime No
CHANGED_INSTALLDATE Changed installdate Datetime No Real date when the installation will be carried out
KOPPEL_TEKST Main project Alphanumeric(255) No Verwijst naar: PLANON_MAINPROJECT
ENGINEERINGGEREED Engineering complete Numeric non-decimal(1) Yes Lijstwaarde: YESNO Indication engineering ready
TECHNISCHGEREED Ready for service Numeric non-decimal(1) Yes Lijstwaarde: YESNO Indication if the project is technical ready
MEETRAPPORTENVERWERKT OTDR processed Numeric non-decimal(1) Yes Lijstwaarde: YESNO Indication measurement reports are ready
REVISIEVERWERKT Ready for operation Numeric non-decimal(1) Yes Lijstwaarde: YESNO Indication revision is ready
VRAAGBUNDELING40 Requestbundle 4.0 Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
FIBERSTRIKE Fiberstrike Numeric non-decimal(1) Yes Lijstwaarde: YESNO
GENERATEDRAWING CTTH drawing Numeric non-decimal(1) Yes Lijstwaarde: YESNO
CIVILWORK Civil work Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
BLOWWORK Blowwork Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
SPLICEWORK Splicework Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
ACTIVEWORK Active work Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
GEW_INSTALLDATE Changed installdate Numeric non-decimal(1) Yes Lijstwaarde: YESNO Indication if the project is technical changed
PROJECTMEMO Project memo Alphanumeric(4000) No
DEFAULT_INSTALLCOMPANY Default installcompany Alphanumeric(50) no STATI_OMS:INSTALLATIEBEDRIJF
PLANNEDWORKCONTACT Planned work contact Alphanumeric(50) no Contact person (mail address) in a cablework (project)
MAINTENANCECONTACT Maintenance contact Alphanumeric(50) no Contact person (mail address) in a cablework (project)
EXTERNCONTACT External contact Alphanumeric(255) no Email address of an external contact
CITYPOP City POP Alphanumeric(50) No
POP POP Alphanumeric(50) no
PVE_NUMBER PVE number Numeric decimal(2,1) No
NETBEHEERDER Operator Alphanumeric(10) No
OMSCHRIJVING Description Alphanumeric(2000) Yes Description of the cable work (project)
PROJECTDIRECTORY Project directory Alphanumeric(400) No Project directory
MAINPROJECT_PREV Previous main project Alphanumeric(50) No
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
GESLOTEN Date closed Datetime No Close date of cablework
GESLOTEN_GEBRUIKER Closed by Alphanumeric(50) No Cablework closed by user
ADDRESSES_SYNCED Addresses synced Datetime No For WorkOnPlanner

Kabelwerkdwgcalc (KABELWERKDWGCALC)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
TTNR Ttnr Alphanumeric(40) Yes
FILENAME Filename Alphanumeric(128) Yes
FILE_UPDATED File_updated Datetime Yes
FILESIZE Filesize Numeric non-decimal(11) Yes
BIS Bis Numeric decimal(11) Yes
HAS Has Numeric decimal(11) Yes
TOLERANCE Tolerance Numeric decimal(11) Yes
UPDATETIME Updatetime Datetime Yes
UPDATEUSER Updateuser Alphanumeric(50) Yes

Kabelwerkitems (KABELWERKITEMS)
Items belonging to project
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
KABELWERKID Kabelwerkid Numeric non-decimal(11) No Verwijst naar: Project
GRID Grid Numeric non-decimal(1) No
RIJ Rij Numeric non-decimal(3) No
KOLOM Kolom Numeric non-decimal(3) No
WAARDE Waarde Alphanumeric(1000) No

Kastblokkering (KASTBLOKKERING)
Individual positions on a frame which has been blocked
Properties
Technical name Label Type Mandatory Entry info Description
LOCATIE_ID Locatie_id Numeric non-decimal(11) No Identification of the object
AFWERKEENHEID_NAAM Afwerkeenheid_naam Alphanumeric(50) Yes Name of termination unit (frame name)
HOOGTE_EENHEID Hoogte_eenheid Numeric non-decimal(5) Yes Identification of the heigth position in a frame
KASTZIJDE Kastzijde Alphanumeric(1) Yes
WIDTH Width Numeric decimal(6,1) No
LEFT Left Numeric decimal(6,1) No
AANTAL_HOOGTE_EENHEDEN Aantal_hoogte_eenheden Numeric non-decimal(3) No
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
PLACE_ID Place id Numeric non-decimal(11) Yes Verwijst naar: Location

Customer (KLANT)
Customer information
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
KLANTNAAM* Name Alphanumeric(50) Yes Name of the customer
KLANTCODE Customer code Alphanumeric(5) no Hoofdletters
STRAAT Street Alphanumeric(50) no Name of the customer
HUISNUMMER Housenr Alphanumeric(21) no Hoofdletters Houseno of the customer
POSTCODE Zipcode Alphanumeric(12) no Hoofdletters Zipcode of customer
PLAATSNAAM City Alphanumeric(50) no Hoofdletters City of customer
LAND Country Alphanumeric(60) no
PLANNEDWORKPRIORITEIT Planned work color Alphanumeric(4) no
ACCESSCODE Access code Alphanumeric(10) no
OVERIG Other Alphanumeric(200) No Extra information
SERVICEPRIORITEIT Service priority Alphanumeric(2) No
AFWIJKENDPRIOTOESTAAN Different prio Alphanumeric(1) Yes Lijstwaarde: JANEE_UPPER
SERVERTYPE Default servertype Alphanumeric(50) no Stamtabel: SERVERTYPE
CORRESPONDINENGLISH No dutch Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER
CALL_BEFORE_DEFAULT Call before Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER Default value for Call customer before
CALL_AFTER_DEFAULT Call after Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER Default value for Call customer afterwards
MAIL_BEFORE Mail before Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER
MAIL_AFTER Mail after Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER
MEET_VERBINDING Measure connections after outage Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER Should connection be measured after an outage
MELD_PSA Report PSA to customer Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER Should PSA messages be reported
MELD_MULTIPLE_OUTAGES Multiple outages within one week Alphanumeric(1) no Lijstwaarde: JANEE_SPACE_UPPER
SA_PSA_ANN_APARTMELDEN Notify SA, PSA and cancellations in separate mails Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
PERONDERBREKING1MAIL Send 1 mail per outage Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
PERLIJNBENAMING1MAIL Send 1 mail per section name Alphanumeric(1) No Lijstwaarde: JANEE_UPPER
STORINGSMAILADRES Failure email Alphanumeric(250) no
STORINGSTELEFOONNUMMER Failure phone Alphanumeric(15) no
EXTERNAL_REF External ref Alphanumeric(32) No
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record

Contract (KLANTCONTRACT)
Customer contracts
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
CONTRACTNUMMER* Number Alphanumeric(50) no Hoofdletters Name or number of the contract
KLANTID Customer Numeric non-decimal(11) Yes Verwijst naar: Customer Identification of the object
CONTRACTTYPEID Type Numeric non-decimal(11) Yes Verwijst naar: Contracttype Identification of the object
CONTRACT_START_DATE Contract start date Date No
CONTRACT_END_DATE End date Datetime Yes End contract date
CONTRACTPERIOD Contract period Numeric non-decimal(38) No
SERVICEPRIORITEIT Service priority Alphanumeric(2) No
SERVICEFROM Srv.Wind start Mo/Fr Alphanumeric(5) no Hour the service may start
SERVICETO Srv.wind end Mo/Fr Alphanumeric(5) no Hour the service must stop
AFWIJKENDPRIOTOESTAAN Different prio Alphanumeric(1) Yes Lijstwaarde: JANEE_UPPER
SERVICEFROM_WEEKEND Srv.wind start Sa/Su Alphanumeric(5) no Hour the service may start in the weekend
SERVICETO_WEEKEND Srv.wind end Sa/Su Alphanumeric(5) no Hour the service must stop in the weekend
WORKNOTIFICATION_SA Work notification SA Numeric non-decimal(3) Yes Number of days before actual work SA
WORKNOTIFICATION_PSA Work notification PSA Numeric non-decimal(3) Yes Number of days before actual work PSA
MAXTTR Max repairtime Alphanumeric(20) no Maximum TIME TO repair
INTERRUPTNOTIFICATION Interruptnotification Numeric non-decimal(3) Yes Number of days before outage
PENALTY_PER_HOUR Penalty per hour Numeric non-decimal(5) Yes Penalty per hour
PENALTY_PER_DAY Penalty per day Numeric non-decimal(5) Yes Penalty per day
HOURS_PENALTY_FREE Penaltyfree period Numeric non-decimal(5) Yes Penalty free period
OVERIG Other Alphanumeric(200) No Extra information
COMMENTS Comments Alphanumeric(4000) no Comments field, free format
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record
KLANTCONTRACTOWNER Owner Alphanumeric(50) No Stamtabel: OLO The owner of the customercontract

Label (LABEL)
Unique number per type of object
Properties
Technical name Label Type Mandatory Entry info Description
LETTER Letter Alphanumeric(3) Yes Determines the type of label
VOLGNR Volgnr Numeric non-decimal(11) Yes Maximum value of already existing label of this type
LABEL* Label Alphanumeric(50) Yes Union of letter and ordernumber
STATUS Status Numeric non-decimal(5) No Status of the object 0(reserved), 1 (in use), 2 (cease)
AANVRAAG_ID Aanvraag_id Numeric non-decimal(11) No Verwijst naar: Aanvraag Identification of the object

Leaselines (LEASELINES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
ARCHIEF_NUMMER Archief_nummer Numeric non-decimal(11) Yes
CONTRACT_NUMMER Contract_nummer Alphanumeric(50) Yes
LEASECONTRACTSTATUS Leasecontractstatus Numeric non-decimal(2) Yes
OLO Olo Numeric non-decimal(3) Yes
OFF_AANV_DATUM Off_aanv_datum Datetime No
OFF_ONTV_DATUM Off_ontv_datum Datetime No
ORDER_DATUM Order_datum Datetime No
GEWENST_OPL_DATUM Gewenst_opl_datum Datetime No
BEVEST_OPL_DATUM Bevest_opl_datum Datetime No
WERKEL_OPL_DATUM Werkel_opl_datum Datetime No
CONTRACT_EIND_DATUM Contract_eind_datum Datetime No
OPZEGTERMIJN Opzegtermijn Numeric non-decimal(5) No
STIL_VERLENG Stil_verleng Numeric non-decimal(1) Yes
RAAMCONTRACT Raamcontract Numeric non-decimal(2) Yes
VERMOED_EIND_DATUM Vermoed_eind_datum Datetime No
OPZEG_DATUM Opzeg_datum Datetime No
UPDATETIME Edited Datetime No
UPDATEUSER Edited by Alphanumeric(50) Yes
LOCATIE_A Locatie_a Numeric non-decimal(11) No
FRAME_A Frame_a Alphanumeric(200) No
AFWERK_A Afwerk_a Numeric non-decimal(2) No
TRAY_A Tray_a Numeric non-decimal(2) No
POS_A Pos_a Numeric non-decimal(2) No
FIBER_COAX_A Fiber_coax_a Numeric non-decimal(1) Yes
LOCATIE_B Locatie_b Numeric non-decimal(11) No
FRAME_B Frame_b Alphanumeric(200) No
AFWERK_B Afwerk_b Numeric non-decimal(2) No
TRAY_B Tray_b Numeric non-decimal(2) No
POS_B Pos_b Numeric non-decimal(2) No
FIBER_COAX_B Fiber_coax_b Numeric non-decimal(1) Yes
BESCHIKBAARHEID Beschikbaarheid Alphanumeric(15) no
OPMERKINGEN Opmerkingen Alphanumeric(200) no
HYPERLINK Hyperlink Alphanumeric(200) No
SECTIE_ID Sectie_id Numeric non-decimal(11) No
LIJNBENAMING_OLO Lijnbenaming_olo Alphanumeric(50) No
TYPE_HUURLIJN Type_huurlijn Numeric non-decimal(2) Yes
SAPLEASE_ID Saplease_id Numeric non-decimal(11) No
KLANTCONTRACT_ID Klantcontract_id Numeric non-decimal(11) No
ORG_IN_DATUM Org_in_datum Datetime No
ORG_EIND_DATUM Org_eind_datum Datetime No
ORGMAANDTAR Orgmaandtar Numeric decimal(9,2) No
ORGEENMALIG Orgeenmalig Numeric decimal(9,2) No
ORGOPM Orgopm Alphanumeric(200) No
VERLENG_IN_DATUM1 Verleng_in_datum1 Datetime No
VERLENG_EIND_DATUM1 Verleng_eind_datum1 Datetime No
VERLENGMAANDTAR1 Verlengmaandtar1 Numeric decimal(9,2) No
VERLENGEENMALIG1 Verlengeenmalig1 Numeric decimal(9,2) No
VERLENGOPM1 Verlengopm1 Alphanumeric(200) No
VERLENG_IN_DATUM2 Verleng_in_datum2 Datetime No
VERLENG_EIND_DATUM2 Verleng_eind_datum2 Datetime No
VERLENGMAANDTAR2 Verlengmaandtar2 Numeric decimal(9,2) No
VERLENGEENMALIG2 Verlengeenmalig2 Numeric decimal(9,2) No
VERLENGOPM2 Verlengopm2 Alphanumeric(200) No
VERLENG_IN_DATUM3 Verleng_in_datum3 Datetime No
VERLENG_EIND_DATUM3 Verleng_eind_datum3 Datetime No
VERLENGMAANDTAR3 Verlengmaandtar3 Numeric decimal(9,2) No
VERLENGEENMALIG3 Verlengeenmalig3 Numeric decimal(9,2) No
VERLENGOPM3 Verlengopm3 Alphanumeric(200) No
ACRIGHT Acright Numeric non-decimal(1) No
ACLEFT Acleft Numeric non-decimal(1) No

Locatie_vertaling (LOCATIE_VERTALING)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
LOCATIE_NAAM_ORG Locatie_naam_org Alphanumeric(50) No
LOCATIE_NAAM_NW Locatie_naam_nw Alphanumeric(50) No
KAST_NAAM_ORG Kast_naam_org Alphanumeric(50) No
KAST_NAAM_NW Kast_naam_nw Alphanumeric(50) No
PPS_NAAM_ORG Pps_naam_org Alphanumeric(50) No
PPS_NAAM_NW Pps_naam_nw Alphanumeric(50) No
SOORTAFWERKEENHEID Soortafwerkeenheid Alphanumeric(50) No
CONNECTORTYPE Connectortype Alphanumeric(20) No
OLO Olo Alphanumeric(50) No
X X Numeric decimal(10,1) No
Y Y Numeric decimal(10,1) No

Matrixcategory (MATRIXCATEGORY)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
NAME* Name Alphanumeric(50) Yes
MATRIX Matrix Alphanumeric(4000) No
UPDATEUSER Updateuser Alphanumeric(50) No
UPDATETIME Updatetime Datetime No

Mutaties (MUTATIES)
History info on table pps_lijnbenaming
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
MUTATIE_TYPE Change type Alphanumeric(50) No Description of the type of mutation
POSITIEID Positieid Numeric non-decimal(11) No Verwijst naar: Patch position Identification of the object
AFWERKEENHEID_ID Afwerkeenheid_id Numeric non-decimal(11) No Verwijst naar: Termination unit Unique id for a patch panel
AFWERKPUNT_ID Afwerkpunt_id Numeric non-decimal(11) No Verwijst naar: Termination point Unique id for a tray in a patch panel
TRAYNUMMER Tray Alphanumeric(10) No Number of the tray
POSITIENUMMER Pos Numeric non-decimal(11) No Number of the position in the tray
LIJNBENAMING Section name Alphanumeric(80) No Unique section name indicating the usage of a connection
KABEL_NAAM Cable name Alphanumeric(50) No Name or number of a cable(span)
KABEL_ID SpanID Numeric non-decimal(11) No Verwijst naar: Span Identification of the object
VEZELNUMMER Fiber Numeric non-decimal(11) No Fiber number
RICHTING End point Alphanumeric(103) No Endpoint of the connection, seen from this point
STATUS_RESERVERING Status Alphanumeric(1) No Status of the reservation
RESERVERINGSDATUM Reservation date Date No Date of reservation
RESERVERINGSEINDDATUM End date Date No Date when reservation expires
PROJECTNUMMER Project number Alphanumeric(50) No Verwijst naar: Project Identification of the project
AANVRAAGUSER Applicant Alphanumeric(50) No User who requested the reservation
UPDATED Updated Alphanumeric(1) No Tempfield
TRACEUPDATEUSER Traceupdateuser Alphanumeric(50) No Username of the update user
TRACEUPDATETIME Change date Datetime No Date of the trace
SERVICEPRIORITEIT Service priority Alphanumeric(2) No Indicating the priority of the connection
DEMPINGFIBER Dempingfiber Numeric decimal(10,8) No Extra attenuation on a fiber
POWERMETING Powermeting Numeric decimal(10,7) No Value of the measurement on a fiber
APPARATUURPOORT Apparatuurpoort Alphanumeric(100) No Information on the port connected to the ODF-position
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Networkspeed (NETWORKSPEED)
Registration of the speed of the involved computer network
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
DATUMTIJD Datumtijd Datetime Yes Date and time of measure
GEBRUIKER Gebruiker Alphanumeric(50) Yes Userid on the network
WERKSTATION Werkstation Alphanumeric(50) Yes Work station
MBYTESPERSECONDE Mbytesperseconde Numeric decimal(11,2) Yes Speed

Network area (NET_AREA)
Routes and businessareas for (ac)counting
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
NAME* Name Alphanumeric(50) No Name of the object
SHORTNAME Short name Alphanumeric(10) no
OWNER Type Alphanumeric(20) No STATI_OMS:ADRESGEBIED Purpose of the object (access, core etc.)
STATUS Status Alphanumeric(1) Yes Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
INSTALLCOMPANY Install company Alphanumeric(50) no STATI_OMS:INSTALLATIEBEDRIJF
MONTHLY_COSTS Monthly costs Numeric decimal(10,2) No
MIN_STARTUP_COSTS Min startup costs Numeric decimal(10,2) No
MAX_STARTUP_COSTS Max startup costs Numeric decimal(10,2) No
PRICE_PER_METER Price per meter Numeric decimal(10,2) No
COSTS_TEXT_1 Costs text 1 Alphanumeric(1000) No
COSTS_TEXT_2 Costs text 2 Alphanumeric(1000) No
COSTS_TEXT_3 Costs text 3 Alphanumeric(1000) No
FTTO_STATUS FTTO status Alphanumeric(50) No Lijstwaarde: FTTO_STATUS
FTTO_ACTIE FTTO action Alphanumeric(50) No
FTTO_PARTNER FTTO partner Alphanumeric(100) No
FTTO_LEVERTIJD FTTO delivery time Numeric non-decimal(3) No
BUILDSTATUS Build status Alphanumeric(3) No Stamtabel: BUILDSTATUS
BUILDER_URL URL builder Alphanumeric(80) No
NETWORKLENGTH Network length Numeric decimal(11,2) No Systeemveld
COSTTEMPLATE Routing costtemplate Alphanumeric(50) No
ONCEONLYCODE Once-only amount code Alphanumeric(5) No COCONSETTING:ONCEONLYAMOUNTCODES
MONTHLYCODE Monthy amount code Alphanumeric(5) No COCONSETTING:MONTHLYAMOUNTCODES
REDEMPTIONCODE Redemption amount code Alphanumeric(5) No COCONSETTING:REDEMPTIONCODES
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
EXTERNAL_REF External reference Alphanumeric(32) No
USERINFO User info Alphanumeric(254) No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

Net_trouble (NET_TROUBLE)
Project areas
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
TR_TICKET* Tr_ticket Alphanumeric(40) No Verwijst naar: Project Trouble ticket number = project number
COMMENTS Comments Alphanumeric(254) No Comments field, free format
STATUS Status Alphanumeric(20) Yes Status of the object 0(reserved), 1 (in use), 2 (cease)
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)
ZWAARTEPUNT_X Zwaartepunt_x Numeric non-decimal(22) No
ZWAARTEPUNT_Y Zwaartepunt_y Numeric non-decimal(22) No
MAX_WONINGEN_PER_DP Max_woningen_per_dp Numeric non-decimal(6) No
AANTAL_WONINGEN Aantal_woningen Numeric non-decimal(6) No
PLAATSNAAM Plaatsnaam Alphanumeric(50) no
DATETIME_CALC Datetime_calc Datetime No
PLAATS_VOLGNR Plaats_volgnr Numeric non-decimal(3) No
HOOGSTE_DP Hoogste_dp Numeric non-decimal(3) No

Span (OSPSPAN)
Logical view on the cables
Properties
Technical name Label Type Mandatory Entry info Description
SPANID Span ID Numeric non-decimal(11) Yes Verwijst naar: Span Unique number for a cable(span) between two manipulatable locations
KABELNAAM Cable name Alphanumeric(50) no Hoofdletters Name or number of a cable(span)
KABELTYPE Cable type Alphanumeric(50) no Stamtabel: KABELTYPE Cable type
LOCATIETYPEA Type A Alphanumeric(20) no Lijstwaarde: LOCATIETYPE A-side : typ of location
LOCATIE_NAAM_A Location A Alphanumeric(50) no Hoofdletters, Verwijst naar: Location A-side : name of location
FRAMEA Frame A Alphanumeric(100) no A-side : name of the frame
LOCATIETYPEB Type B Alphanumeric(20) no Lijstwaarde: LOCATIETYPE B-side : typ of location
LOCATIE_NAAM_B Location B Alphanumeric(50) no Hoofdletters, Verwijst naar: Location B-side : name of location
FRAMEB Frame B Alphanumeric(100) no B-side : name of the frame
KABELCAPACITEIT Capacity Alphanumeric(50) no Capacity of the cable
STATUS Status Alphanumeric(1) Yes Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
PROJECTNUMMER Project number Alphanumeric(60) Yes Hoofdletters, Verwijst naar: Project Identification of the project
OWNER Owner Alphanumeric(20) Yes Lijstwaarde: OWNER Purpose of the object (access, core etc.)
LENGTE Length Numeric non-decimal(11) No Length of a cable(span)
CABLECATEGORY Cable category Alphanumeric(2) Yes Stamtabel: KABELCATEGORIEN Category of cable
KNIPKABEL Cut cable Numeric non-decimal(1) No Lijstwaarde: YESNO
POORT_A Port A Alphanumeric(10) no Sub port at the end of involved cable
POORT_B Port B Alphanumeric(10) no Sub port at the end of involved cable
BEZET_PERC_CAP Usage % Numeric decimal(5,1) Yes Percentage used fibers in a cable
MELDEN_BIJ_PERC_CAP Melden_bij_perc_cap Numeric decimal(5,1) Yes At this used capacity a cable must be reported again
MELDEN_NA_TIJD_CAP Melden_na_tijd_cap Numeric non-decimal(8) Yes After this time a cable must be reported again
PRIORITEIT_CAP Prioriteit_cap Numeric non-decimal(1) Yes Priority of reported capacity
ADRES_A Address a Alphanumeric(50) no A-side : zipcode + houseno_from+houseno_extention_from +houseno_to+houseno_extention_to
ADRES_B Address b Alphanumeric(50) no B-side : zipcode + houseno_from+houseno_extention_from +houseno_to+houseno_extention_to
OPMERKING_CAP Opmerking_cap Alphanumeric(200) Yes Comment on reported capacity of a cable
UPGRADEYEAR Upgrade year Alphanumeric(4) no
UPGRADEPRIO Upgrade prio Alphanumeric(1) no
UPGRADEALERTDATE Upgrade alert date Date No
UPGRADEALERTSTATUS Upgrade alert status Alphanumeric(1) no Lijstwaarde: UPGRADEALERTSTATUS
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
MAX_USABLE_CAPACITY Max usable capacity Numeric non-decimal(10) No
CUTSPAN Cutspan Numeric non-decimal(11) No

Ospspanfiber (OSPSPANFIBER)
Child tabel of ospspan with all individual fibers
Properties
Technical name Label Type Mandatory Entry info Description
SPANID Spanid Numeric non-decimal(11) Yes Verwijst naar: Span Unique number for a cable(span) between two manipulatable locations
VEZELNUMMER Vezelnummer Numeric non-decimal(11) Yes Fiber number
VERBINDINGNUMMER Verbindingnummer Numeric non-decimal(11) No Verwijst naar: Verbinding Unique number for connection
VOLGNUMMER Volgnummer Numeric non-decimal(11) No Order number of a fiber within a connection
RINGID Ringid Numeric non-decimal(11) No Verwijst naar: Ring_tabel Identification of the object
VEZELFUNCTIE Vezelfunctie Alphanumeric(20) no Indicates the type of usage of a fiber (core/access etc.)
VEZEL_TYPE Fiber type Alphanumeric(10) No Type of quality of the fiber (G.652 etc)
STATUS Status Alphanumeric(2) No Status of the object 0(reserved), 1 (in use), 2 (cease)
VEZELFUNCTIEGEZET Vezelfunctiegezet Alphanumeric(1) Yes Indicates that a fiber has a manualy entered fiber function
KABELWERKID Kabelwerkid Numeric non-decimal(11) No Verwijst naar: Project Identification of the object
LASZIJDE Laszijde Alphanumeric(1) Yes Side where fiber is spliced a/b/n(ot)/e(both)
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
VEZELCODE Vezelcode Numeric non-decimal(11) Yes A unique number for a fiber per location
VEZELDEMPING Vezeldemping Numeric decimal(10,1) No Attenuation at 1310 nm according to the supplier
VEZEL_LENGTE Vezel_lengte Numeric non-decimal(10) No Length of a fiber according to the supplier
VEZELDEMPING2 Vezeldemping2 Numeric decimal(11,1) No Attenuation at 1550 nm according to the supplier
CONTRACT_ID Contract_id Numeric non-decimal(11) No Verwijst naar: Contract Identification of the object
TUBEPOSITIEA Tubepositiea Alphanumeric(8) Yes Position of the tube a-side
TUBEPOSITIEB Tubepositieb Alphanumeric(8) Yes Position of the tube b-side

Outage (OUTAGE)
Outages
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
PROJECTNUMMER Projectnummer Alphanumeric(40) Yes Hoofdletters Identification of the project
OMSCHRIJVING Omschrijving Alphanumeric(300) Yes Description of the outage
STARTDATE Startdate Datetime No Date (and time) of message
ENDDATE Enddate Datetime No Date (and time) of response
OUTAGEFROM Outagefrom Numeric non-decimal(3) No Hour usage will start
CALENDARID Calendarid Numeric decimal(11) No
OUTAGETO Outageto Numeric non-decimal(3) No Hour outage ends
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
RECURRENCE Recurrence Alphanumeric(1) No
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
TICKETNUMMER Ticketnummer Alphanumeric(10) no Trouble ticket number = project number
STATUS Status Alphanumeric(1) no Status of outage
STANDAARDTEKST Standaardtekst Alphanumeric(2000) No
INITIATOR Initiator Alphanumeric(50) No
ANNULEERTEKST Annuleertekst Alphanumeric(500) No
NIETUITGEVOERD Nietuitgevoerd Alphanumeric(1) No
OUTAGETYPE Outagetype Alphanumeric(40) No
INSTALLCOMPANY Installcompany Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF
CITY City Alphanumeric(30) No City
FREQUENCY Frequency Alphanumeric(2) No Frequency of outage
OUTLOOKCODE Outlookcode Alphanumeric(40) No
OUTLOOKSEQUENCE Outlooksequence Numeric non-decimal(4) No
START_UITVOER Start work Datetime No Datetime start work
EIND_UITVOER End work Datetime No
MOBIELNUMMER Cellphone number Alphanumeric(20) No
CREATIONDATE Creationdate Datetime No Systeemveld Date (and time) of submission
STARTDATETIME Start work Datetime No Datetime start work
ENDDATETIME Enddatetime Datetime No

Outageobject (OUTAGEOBJECT)
Objects involved in outages
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
OUTAGEID* Outageid Numeric non-decimal(11) Yes Verwijst naar: Outage Identification of the object
OBJECTID* Objectid Numeric non-decimal(11) Yes Verwijst naar: Span Identification of the object
SUBOBJECTID* Subobjectid Numeric non-decimal(11) No Identification of the object
OUTAGETYPE PSA/SA Alphanumeric(3) Yes Type of outage
UPDATETIME* Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
FORCED_SA Forced_sa Alphanumeric(1) Yes Object is forced to be service affecting
STATE Outage state Numeric non-decimal(1) No Lijstwaarde: OUTAGESTATUS
TABMSG_ID Tabmsg id Numeric non-decimal(10) No

Patch (PATCHNW)
Patches
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
POSITIE_ID_1* Patch position 1 Numeric non-decimal(11) No Verwijst naar: Patch position Id of the first patch position
POSITIE_ID_2* Patch position 2 Numeric non-decimal(11) No Verwijst naar: Patch position Identification of the object
ZIJDE_1* Side 1 Alphanumeric(6) Yes Side of patch panel
ZIJDE_2* Side 2 Alphanumeric(6) Yes Side of patch panel
STATUS* Status Alphanumeric(1) Yes Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
PATCHLABEL Label Alphanumeric(50) No Patch cord label
PATCHCORDTYPE Type Alphanumeric(30) No Stamtabel: PATCHCORDTYPE Type of patch cord
INSTALLCOMPANY Install company Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF
PATCHDATUM Patch date Date No
PROJECTNUMMER Project Alphanumeric(40) Yes Hoofdletters, Verwijst naar: Project Identification of the project
PATCHUSER Patch user Alphanumeric(50) No Name of person who made the patch
LENGTE Length Numeric decimal(10,1) No
UITVOERSTATUS Implementation state Alphanumeric(1) No Lijstwaarde: COCON_UITVOERSTATUS
UITVOERTOELICHTING Implementation explanation Alphanumeric(500) No
PATCHCOMMENTS Comments Alphanumeric(500) No
EXTERNAL_REF External ref Alphanumeric(32) No
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Patch order (PATCHORDER)
Properties
Technical name Label Type Mandatory Entry info Description
ID Patch order id Numeric non-decimal(10) Yes Systeemveld
OPERATOR_KLANT_ID* Operator Numeric non-decimal(10) Yes Verwijst naar: Customer
OPERATOR_ORDERID* Operator orderid Alphanumeric(32) Yes
ADDRESS_ID* Address Numeric non-decimal(10) Yes LineID (planon)
ADDRESS_FIBER* Address fiber Numeric non-decimal(3) Yes
CPTASKSET_ID Taskset Numeric non-decimal(10) No Systeemveld
TYPE Type Alphanumeric(1) Yes Lijstwaarde: PATCHORDER_TYPE
STATUS Status Numeric non-decimal(2) Yes Lijstwaarde: PATCHORDER_STATUS
KIND* Kind Numeric non-decimal(10) No Systeemveld
EXECUTED Executed Datetime No
PROVIDER_ID Provider Numeric non-decimal(10) No Verwijst naar: PLANON_PROVIDER
PPS_LIJNBENAMING_ID Patch position Numeric non-decimal(10) No Systeemveld, Verwijst naar: Patch position
ACTIVE_POP Active POP Alphanumeric(50) No
ACTIVE_FRAME Active frame Alphanumeric(50) No
ACTIVE_ROW Active row Numeric non-decimal(2) No
ACTIVE_BLOCK Active block Alphanumeric(2) No
ACTIVE_MODULE Active module Alphanumeric(20) No
ACTIVE_PORT Active port Alphanumeric(50) No Sometimes complete string instead of split up in all active fields
SLA_TIME SLA time Datetime No Last datetime to be delivered (wishdate), used for type I and R
EXECUTION_TIME To be executed Datetime No Used for type M
PLAN_TIME Planned Datetime No
CLOSECODE Close code Numeric non-decimal(3) No Lijstwaarde: PATCHORDER_CLOSECODE Preset by contractor
CLOSETEXT Close text Alphanumeric(100) No
HOLDDATETIME Hold Datetime No
HOLDCODE Hold code Numeric non-decimal(3) No Lijstwaarde: PATCHORDER_HOLDCODE Preset by contractor
HOLDTEXT Hold text Alphanumeric(255) No Preset by contractor
RESUMECODE Resume code Numeric non-decimal(3) No Lijstwaarde: PATCHORDER_RESUMECODE
RESUMETEXT Resume text Alphanumeric(255) No
CANCELACCEPTCODE Cancelaccept code Numeric non-decimal(3) No Lijstwaarde: PATCHORDER_CANCELCODE Preset by contractor
CANCELACCEPTTEXT Cancelaccept text Alphanumeric(100) No
DENYCODE Deny code Numeric non-decimal(3) No Lijstwaarde: PATCHORDER_DENYCODE
DENYTEXT Deny text Alphanumeric(100) No
REMARKS Remarks Alphanumeric(1000) No
SYNC_CHANGE Sync change Datetime No
SYNC Synchronize Numeric non-decimal(1) No Lijstwaarde: YESNO
SYNC_MIGRATION Sync migration Numeric non-decimal(1) No Lijstwaarde: YESNO
ACCEPTED Accepted Datetime No Order accepted by contractor
CREATED Created Datetime Yes Systeemveld
CREATEUSER Created by Alphanumeric(50) No Systeemveld
UPDATETIME Edited Datetime Yes Systeemveld
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld

Pcc_aanvraag (PCC_AANVRAAG)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
POSTCODE Postcode Alphanumeric(6) Yes
HUISNUMMER Huisnummer Numeric non-decimal(10) Yes
TOEVOEGING Toevoeging Alphanumeric(6) No
KAMERNUMMER Kamernummer Alphanumeric(64) No
AANVRAAGDATUMTIJD Aanvraagdatumtijd Datetime No
IPADRES Ipadres Alphanumeric(24) No
AANVRAAGTYPE Aanvraagtype Alphanumeric(1) No
BEDRIJFSNAAM Bedrijfsnaam Alphanumeric(100) No
NAAM Naam Alphanumeric(50) No
EMAILADRES Emailadres Alphanumeric(50) No
FUNCTIE Functie Alphanumeric(50) No
TELEFOONNUMMER Telefoonnummer Alphanumeric(20) No

Pcc_adres (PCC_ADRES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
POSTCODE Postcode Alphanumeric(6) Yes
HUISNUMMER Huisnummer Alphanumeric(5) Yes
TOEVOEGING Toevoeging Alphanumeric(6) No
KAMERNUMMER Kamernummer Alphanumeric(64) No
UPDATEDATUM_DIST Updatedatum dist Datetime No
UPDATEDATUM_CVOAX Updatedatum cvoax Datetime No
UPDATEDATUM_BUITEN Updatedatum buiten Datetime No
CONTRACTGEBIED Contractgebied Alphanumeric(50) No
BEDRIJVENTERREIN Bedrijventerrein Alphanumeric(50) No
COAX_STATUS Coax status Alphanumeric(50) No
FTTH_STATUS Ftth status Alphanumeric(50) No
FTTO_STATUS Ftto status Alphanumeric(50) No
FTTO_ACTIE Ftto actie Alphanumeric(50) No
FTTO_PARTNER Ftto partner Alphanumeric(100) No
BUITENGEBIED Buitengebied Alphanumeric(1) No
POPNAAM Popnaam Alphanumeric(100) No
CATEGORY Category Alphanumeric(30) No
DISTANCE Distance Numeric non-decimal(10) No
INITIALDISTANCE Initialdistance Numeric non-decimal(10) No
RAILWAYS Railways Numeric non-decimal(10) No
WATER Water Numeric non-decimal(10) No
MOTORWAYS Motorways Numeric non-decimal(10) No
MAJORROADS Majorroads Numeric non-decimal(10) No

Pcc_autorisatie (PCC_AUTORISATIE)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
ACCOUNTNAAM Accountnaam Alphanumeric(50) No
WACHTWOORD Wachtwoord Alphanumeric(50) No
ACCOUNTTYPE Accounttype Alphanumeric(1) No
EMAILADRES Emailadres Alphanumeric(50) No
TELEFOONNUMMER Telefoonnummer Alphanumeric(50) No

Pcc_relaties (PCC_RELATIES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
ISP_ID Isp id Numeric non-decimal(10) Yes
PARTNER_ID Partner id Numeric non-decimal(10) Yes
TYPE Type Alphanumeric(1) No
CONTRACTGEBIED Contractgebied Alphanumeric(50) No
POPNAAM Popnaam Alphanumeric(100) No
GEENDIENST Geendienst Alphanumeric(1) No

Location (PLACE)
Locations (buildings and accesspoints)
Properties
Technical name Label Type Mandatory Entry info Description
PLACEOBJECTID Id Numeric non-decimal(11) Yes Systeemveld ID of location
NAME* Location name Alphanumeric(100) Yes Hoofdletters
DESCRIPTION Kind Alphanumeric(30) Yes Lijstwaarde: PLACE_DESCRIPTION Indicates that a location is a building or an accesspoint
TYP Type Alphanumeric(200) Yes Type of the object
STREET Street Alphanumeric(50) Yes
HOUSENR House number Alphanumeric(5) No
SUFFIX Suffix Alphanumeric(6) No
ROOM Room Alphanumeric(64) No
HOUSENR_HIGH House number high Alphanumeric(5) No
SUFFIX_HIGH Suffix high Alphanumeric(6) No
ROOM_HIGH Room high Alphanumeric(64) No
ZIP Zipcode Alphanumeric(12) No Hoofdletters
CITY City Alphanumeric(50) Yes
STATE State Alphanumeric(20) Yes Status of the object 0 (reserved), 1 (in use), 2 (cease)
ALTZIPCODE Alternative zipcode Alphanumeric(10) No Hoofdletters
ADDRESSNOTES Address notes Alphanumeric(100) Yes Zipcode + housno_from + houseno_extension_from + housno_to + houseno_extension_to
WORKORDER Project number Alphanumeric(40) No Verwijst naar: Project
STAGE Status Alphanumeric(25) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
INSTALLCOMPANY Install company Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF Company who installed the involved objects
INSTALLYEAR Install year Numeric non-decimal(11) No Year of installing the object
INSTALLMONTH Install month Numeric non-decimal(3) No The month the object was built
INSTALLDAY Install day Numeric non-decimal(3) No The day the object was built
OWNER Owner Alphanumeric(30) No Lijstwaarde: OWNER Purpose of the object (access, core etc.)
CUSTOMERNAME Customer Alphanumeric(150) No Customer name
CUSTOMERTYPE Customer type Alphanumeric(50) No Stamtabel: SOORTKLANT
ACCESSPOINTOWNER Owned by Alphanumeric(40) Yes Stamtabel: OLO Owner of an accesspoint
COMMENTS Remarks Alphanumeric(500) Yes Comments field, free format
PRECISION Precision Numeric non-decimal(4) Yes Indication of precision
ZOOMLVL Zoom Numeric non-decimal(5) Yes Default zoomlevel for object
FLOOR Floor Alphanumeric(50) no Floor number
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
ROUTETYPE Route type Alphanumeric(10) No Lijstwaarde: ROUTETYPE Type route (fiber or copper)
POP Pop Alphanumeric(25) No Systeemveld
UNISORT_DATA Unisort data Alphanumeric(100) No
BOUWBESTANDSTATUS Construction file status Alphanumeric(2) No
PATCHCOSTS Patch costs Numeric decimal(10,2) No
RADIOBEREIK Frequency range Numeric decimal(10,2) No
RADIOHOOGTE Frequency height Numeric decimal(10,2) No
ROUTEID Route Numeric non-decimal(10) No Verwijst naar: Network area
FREE_OWNER_CHANGE Free owner change Numeric non-decimal(1) No Lijstwaarde: YESNO
LAST_VISIT_DATE Visit date Date No
LAST_VISIT_PERSON Last visit by Alphanumeric(100) No
BAANVAKNR Sectionnr Numeric non-decimal(3) No
KILOMETER_AANDUIDING Kilometer indication Numeric decimal(10,3) No
EANNUMMER EAN Numeric non-decimal(20) No
EXTERNAL_REF External reference Alphanumeric(32) No
COAXSTATUS Coaxstatus Alphanumeric(1) No
LOCATIE_ID Locatie id Numeric non-decimal(11) No

POP contract (PLACE_CONTRACT)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
PLACE_ID* POP Numeric non-decimal(10) Yes Verwijst naar: Location
KLANTCONTRACT_ID* Contract Numeric non-decimal(10) Yes Verwijst naar: Contract
FIBERS_USED Fibers to be used Numeric non-decimal(1) Yes Lijstwaarde: FIBERS_USED
FTTH FTTH Numeric non-decimal(1) Yes Lijstwaarde: YESNO
FTTO FTTO Numeric non-decimal(1) Yes Lijstwaarde: YESNO
FTTS FTTS Numeric non-decimal(1) Yes Lijstwaarde: YESNO
P2P P2P Numeric non-decimal(1) Yes Lijstwaarde: YESNO
COAX Coax Numeric non-decimal(1) Yes Lijstwaarde: YESNO
ADMINISTRATION Administration Numeric non-decimal(1) Yes Lijstwaarde: YESNO
LEASE Lessee Numeric non-decimal(1) Yes Lijstwaarde: YESNO
SERVICES Services Numeric non-decimal(1) Yes Lijstwaarde: YESNO

Patch position (PPS_LIJNBENAMING)
Alle individual patchpositions including the usage
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
AFWERKEENHEID_ID* Termination unit Numeric non-decimal(11) No Verwijst naar: Termination unit Unique id for a patch panel
TRAYNUMMER* Tray number Alphanumeric(10) No Number of the tray
POSITIENUMMER* Position Numeric non-decimal(11) No Number of the position in the tray
KABEL_ID* Span Numeric non-decimal(11) No Verwijst naar: Ospspanfiber Identification of the object
VEZELNUMMER* Fiber number Numeric non-decimal(11) No Verwijst naar: Ospspanfiber Fiber number
KABEL_NAAM Cable name Alphanumeric(50) No Hoofdletters Name or number of a cable(span)
AFWERKPUNT_ID Termination point Numeric non-decimal(11) No Verwijst naar: Termination point Unique id for a tray in a patch panel
LIJNBENAMING Section name Alphanumeric(50) No Hoofdletters, Verwijst naar: Section Unique section name indicating the usage of a connection
STATUS_RESERVERING Reservation status Alphanumeric(1) No Status of the reservation
RESERVERINGSDATUM Revervation date Date No Date of reservation
RESERVERINGSEINDDATUM Reservation end date Date No Date when reservation expires
PROJECTNUMMER Project number Alphanumeric(50) No Hoofdletters, Verwijst naar: Project Identification of the project
AANVRAAGUSER Applicant Alphanumeric(50) No User who requested the reservation
RICHTING Direction Alphanumeric(103) No Endpoint of the connection, seen from this point
SPLITTERZIJDE Splitter side Alphanumeric(1) Yes Side of the splitter I(n) or O(ut)
APPARATUURPOORT Device port Alphanumeric(100) No
POWERMETING Measurement (dBm) Numeric decimal(10,7) No Value of the measurement on a fiber
UPDATED Updated Alphanumeric(1) No Tempfield
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
SERVICEPRIORITEIT Service priority Alphanumeric(2) No Indicating the priority of the connection
COMMENTS Comments Alphanumeric(1000) no Comments field, free format
DEMPINGFIBER Attenuation (dB) Numeric decimal(10,8) No Extra attenuation on a fiber
SUBSECTIE Subsection Alphanumeric(50) No
OTDR_ID OTDR ID Numeric non-decimal(11) No

Project asset (PROJECTASSETS)
Table with assets which can be used for a project
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
STATI_ID Stati_id Numeric non-decimal(11) No
PROJECT_ID Project_id Numeric non-decimal(11) No
UPDATETIME Edited Datetime No
UPDATEUSER Edited by Alphanumeric(50) No
TYPE Type Alphanumeric(50) No

Projectbevestiging (PROJECTBEVESTIGING)
History with information on all project confermations
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
PROJECTNUMMER Projectnummer Alphanumeric(50) No Hoofdletters, Verwijst naar: Project Identification of the project
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
TEKST1 Tekst1 Alphanumeric(4000) No Text field because of limitation of 4000 characters
TEKST2 Tekst2 Alphanumeric(4000) No Text field because of limitation of 4000 characters
TEKST3 Tekst3 Alphanumeric(4000) No Text field because of limitation of 4000 characters
TEKST4 Tekst4 Alphanumeric(4000) No Text field because of limitation of 4000 characters
TEKST5 Tekst5 Alphanumeric(4000) No Text field because of limitation of 4000 characters
TEKST6 Tekst6 Alphanumeric(4000) No Text field because of limitation of 4000 characters
TEKST7 Tekst7 Alphanumeric(4000) No Text field because of limitation of 4000 characters

Project calculation (PROJECTCALCULATE)
Calculations per project
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
PROJECTID Projectid Numeric non-decimal(10) Yes Verwijst naar: Project
POPNAAM Popnaam Alphanumeric(50) No
BOUWNUMMER Bouwnummer Alphanumeric(50) No
AANVRAAG_DATUM Aanvraag datum Datetime No
AANVRAAGUSERID Aanvraaguserid Alphanumeric(50) No
DATUM_BEREKENING Datum berekening Datetime No
LENGTE_HOOFDGEUL Lengte hoofdgeul Numeric non-decimal(10) No
LENGTE_HOOFDGEUL_GEEN_OVERLAP Lengte hoofdgeul geen overlap Numeric non-decimal(10) No
LENGTE_HOOFDGEUL_MET_OVERLAP Lengte hoofdgeul met overlap Numeric non-decimal(10) No
LENGTE_HUISAFTAKKINGEN Lengte huisaftakkingen Numeric non-decimal(10) No
AANTAL_DPS Aantal dps Numeric non-decimal(10) No
AANTAL_ADRESSEN Aantal adressen Numeric non-decimal(10) No
AANTAL_BORINGEN Aantal boringen Numeric non-decimal(10) No
LENGTE_BORINGEN Lengte boringen Numeric non-decimal(10) No
AANTAL_TUINBORINGEN Aantal tuinboringen Numeric non-decimal(10) No

Projectcontrols (PROJECTCONTROLS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Controlid Numeric non-decimal(11) Yes Systeemveld
CATEGORY Category Alphanumeric(30) Yes
SUBCATEGORY Subcategory Alphanumeric(40) Yes
TYPE Type Numeric non-decimal(11) Yes
NAME Name Alphanumeric(300) Yes
DESCRIPTION Description Alphanumeric(500) No
COMMAND Command Alphanumeric(3000) Yes
GRAAFWERK Graafwerk Alphanumeric(1) Yes
BLAASWERK Blaaswerk Alphanumeric(1) Yes
LASWERK Laswerk Alphanumeric(1) Yes
ACTIVE Active Numeric non-decimal(11) Yes
DELAY Delay Numeric non-decimal(11) Yes
RESULT Result Alphanumeric(50) No
RESULT_MESSAGE Result message Alphanumeric(200) No

Projectdocuments (PROJECTDOCUMENTS)
Maintained documents for projects
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
DOCUMENTNAME Documentname Alphanumeric(500) No
DATE_IN Date_in Datetime No
DATE_OUT Date_out Datetime No
STATUS Status Alphanumeric(1) No
PROJECTNUMMER Projectnummer Alphanumeric(40) No Hoofdletters
MAINTAINER Maintainer Alphanumeric(50) No
UPDATETIME Edited Datetime No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld
BMOETVERWIJDERDWORDEN Bhastobedeleted Alphanumeric(1) No
AFGEKEURD Afgekeurd Alphanumeric(1) No
EXCEPTIONSTRING Exceptionstring Alphanumeric(255) no

Project log (PROJECTLOG)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
UPDATEUSER Edited by Alphanumeric(50) Yes
UPDATETIME Edited Date No
PROJECTID Project id Alphanumeric(40) Yes
RESULT Result Numeric non-decimal(1) Yes
OVERRIDE Override Numeric non-decimal(1) Yes
DETAILS Details Blob Yes
EXTRA Extra Alphanumeric(50) No

Projectmeldingen (PROJECTMELDINGEN)
Contacts who received a notification
Properties
Technical name Label Type Mandatory Entry info Description
GUI ID Alphanumeric(32) no Global unique identification
CONTACTSID Contacts ID Numeric non-decimal(11) Yes Identification of the object
CONTRACTID Contract ID Numeric non-decimal(11) No Identification of the object
NOTIFICATIONDATE Notification date Datetime No Date (and time) of message
RESPONSEDATE Response date Datetime No Date (and time) of response
APPROVAL Approval Alphanumeric(1) no Did customer agree on the outage
RESPONSETEXT Response text Alphanumeric(500) no Comment of customer
CALL_BEFORE Call before Alphanumeric(1) no Call customer before
CALL_AFTER Call_after Alphanumeric(1) no Call customer afterwards
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record
EMAILADRES Email Alphanumeric(255) No
DEACTIVEER Deactivate Alphanumeric(1) No Message must be deactivated
OUTAGETYPE Outagetype Alphanumeric(3) No
OUTAGEID Outage ID Numeric non-decimal(11) Yes Verwijst naar: Outage Identification of the object
REFERENCE Reference Alphanumeric(250) No
NOREACTIONLASTSEND Noreactionlastsend Datetime No
NUMBEROFWARNINGEMAILSSEND Numberofwarningemailssend Numeric non-decimal(38) Yes
EMAILCONTENT Emailcontent Alphanumeric(4000) no
STUUROUTAGEOMSCHRIJVING Stuuroutageomschrijving Numeric non-decimal(1) No
STANDAARDTEKST Standaardtekst Alphanumeric(1000) no
EMAILADDRESSNOPSA Emailaddressnopsa Alphanumeric(100) no
CANCELATIONDATE Cancelationdate Datetime No

Projectstructure (PROJECTSTRUCTURE)
Structure of project documents
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
DIRECTORYNAME* Directoryname Alphanumeric(500) No
MAINTAINED Maintained Alphanumeric(1) No
BACKUPED Backuped Alphanumeric(1) No
BRONDIRECTORY Brondirectory Alphanumeric(500) No
DIRECTORY_PER_OBJECT Directory_per_object Alphanumeric(1) No
UPDATETIME Edited Datetime No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld
CIVILWORK Civilwork Alphanumeric(1) No
BLOWWORK Blowwork Alphanumeric(1) No
SPLICEWORK Splicework Alphanumeric(1) No
ACTIVEWORK Activework Alphanumeric(1) No
MAX_DELAY Max delay Numeric non-decimal(3) No
KLANT_ID Klant id Numeric non-decimal(11) No Systeemveld

Question (QUESTIONS)
Table with questions and answers for objects
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
QUESTIONID Questionid Numeric non-decimal(11) Yes Verwijst naar: Stati
OBJECTID Objectid Numeric non-decimal(11) Yes
OBJECTTYPE Objecttype Alphanumeric(20) Yes
QUESTIONUSERID Questionuserid Alphanumeric(50) Yes
QUESTIONDATE Questiondate Datetime No
ANSWERUSERID Answeruserid Alphanumeric(50) Yes
ANSWERDATE Answerdate Datetime No
PROCESSEDUSERID Processeduserid Alphanumeric(50) Yes
PROCESSEDDATE Processeddate Datetime No
ANSWER Answer Alphanumeric(3000) Yes

Regionaut (REGIONAUT)
Regions user for autorization
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
GROUPID Groupid Numeric non-decimal(11) No
USERID Userid Numeric non-decimal(11) No
REGIONID Regionid Numeric non-decimal(11) No
BLOCKED Blocked Alphanumeric(1) No

Reserveringsbuffer (RESERVERINGSBUFFER)
Buffer for routing a fiber connection
Properties
Technical name Label Type Mandatory Entry info Description
USERNAME Username Alphanumeric(50) Yes Login name of the user
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)

Rfts (RFTS)
Measurements of the remote fiber test system
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(38) Yes Systeemveld Identification of the object
TIJDSTIP Tijdstip Datetime Yes
REGION Region Alphanumeric(50) No
RTU Rtu Alphanumeric(50) No
LINK Link Alphanumeric(100) No
ALARMTYPE Alarmtype Alphanumeric(50) No
EVENTID Eventid Numeric non-decimal(38) No
ALARMID Alarmid Numeric non-decimal(38) No
EVENTCODE Eventcode Numeric non-decimal(38) No
EVENTTRIGDATE Eventtrigdate Alphanumeric(50) No
EVENTDESCRIPTION Eventdescription Alphanumeric(100) No
SEVERITY Severity Alphanumeric(50) No
DESC_LEVEL Desc_level Alphanumeric(50) No
STATUS Status Alphanumeric(50) No Status of the object 0(reserved), 1 (in use), 2 (cease)
FROMLANDMARK Fromlandmark Alphanumeric(50) No
TOLANDMARK Tolandmark Alphanumeric(50) No
FROMMARKER Frommarker Alphanumeric(50) No
TOMARKER Tomarker Alphanumeric(50) No
UNIT Unit Alphanumeric(50) No
FROMOTDR Fromotdr Numeric decimal(10,2) No
DIST_UNIT Dist_unit Alphanumeric(50) No
DIST_FROMLANDMARK Dist_fromlandmark Numeric decimal(10,2) No
DIST_TOLANDMARK Dist_tolandmark Numeric decimal(10,2) No
DIST_FROMMARKER Dist_frommarker Numeric decimal(10,2) No
DIST_TOMARKER Dist_tomarker Numeric decimal(10,2) No

(RINGBESTEMMINGDETAIL)
Detailed info on ring destinations
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
RINGBESTEMMINGID Ringbestemmingid Numeric non-decimal(11) No
VERBINDINGCATEGORIEID Verbindingcategorieid Numeric non-decimal(11) No
TUBENUMMER Tubenummer Numeric non-decimal(4) No

Ring_tabel (RING_TABEL)
Rings
Properties
Technical name Label Type Mandatory Entry info Description
RINGID RingID Numeric non-decimal(11) Yes
RING_NAME* Ring name Alphanumeric(50) no
RING_DESCRIPTION Ring description Alphanumeric(50) no
TYPE Type Alphanumeric(50) no Type of the object
OMGEVING Pop Area Alphanumeric(50) no
RINGSTATUS State Alphanumeric(2) no
RINGBESTEMMING Usage Alphanumeric(50) no
RINGKLEUR Color Alphanumeric(50) no
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld Userid who made the last change on the record
DATUM_LAATSTE_WIJZ Date last change Datetime Yes

Route (ROUTE)
All individual trenches based upon (generated from) TABCON
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Objectid Numeric non-decimal(38) Yes Unique identification of this object
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)
OWNER Owner Alphanumeric(50) Yes Lijstwaarde: OWNER Purpose of the object (access, core etc.)

Routeaddress (ROUTEADRES)
Special addresses for routing
Properties
Technical name Label Type Mandatory Entry info Description
ZIPCODE Zipcode Alphanumeric(20) Yes
HOUSENO HouseNo Alphanumeric(5) Yes
SUFFIX Suffix Alphanumeric(6) Yes
X X-Position Numeric decimal(10,1) No
Y Y-Position Numeric decimal(10,1) No
TOTAL_COSTS Total cost Numeric non-decimal(10) No
TOTAL_LENGTH Total length Numeric non-decimal(10) No
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld
TYP_ADDRESS Type of address Numeric non-decimal(1) No
UPDATETIME Edited Datetime No Systeemveld
CHANGED Changed Numeric non-decimal(2) No
STREET Street Alphanumeric(30) No
CITY City Alphanumeric(30) No City
ADDRESS_INVISIBLE Address invisible Numeric non-decimal(2) No
MARK_FOR_DELETE Delete Numeric non-decimal(2) No
ORIGINAL_X Original X position Numeric decimal(10,1) No
ORIGINAL_Y Original Y position Numeric decimal(10,1) No
ORIGINAL_HERKOMST Original Origin Alphanumeric(1) No

Routerequest (ROUTEREQUEST)
Route calculation requests (bid requests)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
REQUEST_ID Request_id Alphanumeric(20) No
WEBSERVICEPHASE Webservicephase Numeric non-decimal(1) No Lijstwaarde: WEBSERVICEPHASE
OPERATOR Operator Alphanumeric(24) No
MESSAGEHEADER Messageheader Alphanumeric(200) No
VERBINDING_ID Verbinding_id Alphanumeric(20) No
PROJECTNUMMER Projectnummer Alphanumeric(250) No Identification of the project
REQUESTTYPE Requesttype Alphanumeric(20) No
LOCATION_ID_A Location_id_a Alphanumeric(50) No
LOCATION_A Location_a Alphanumeric(50) No
ZIPCODE_A Zipcode_a Alphanumeric(20) No
HOUSENO_A Houseno_a Alphanumeric(50) No
STREET_A Street_a Alphanumeric(50) No
CITY_A City_a Alphanumeric(50) No
LOCATION_ID_B Location_id_b Alphanumeric(50) No
LOCATION_B Location_b Alphanumeric(50) No
ZIPCODE_B Zipcode_b Alphanumeric(20) No
HOUSENO_B Houseno_b Alphanumeric(50) No
STREET_B Street_b Alphanumeric(50) No
CITY_B City_b Alphanumeric(50) No
SPEED Speed Alphanumeric(10) No
PRODUCT Product Alphanumeric(20) No
ROUTINGTYPE Routingtype Numeric non-decimal(1) No
ERRORSTRING Errorstring Alphanumeric(300) No
NETWORKERRORSTRING Networkerrorstring Alphanumeric(300) No
POP Pop Alphanumeric(50) No
PATCHCOSTS Patchcosts Numeric decimal(12,2) No
EQUIPMENTCOSTS Euipmentcosts Numeric decimal(12,2) No
COSTSNETWORK Costsnetwork Numeric decimal(12,2) No
NETWORKLENGTH Networklength Numeric non-decimal(10) No
FIBERLENGTH Fiberlength Numeric non-decimal(10) No
TOTAL_LENGTH Total_length Numeric non-decimal(10) No
TOTAL_COSTS Total_costs Numeric non-decimal(10) No
ERRORSTRING_A Errorstring a Alphanumeric(300) No
OFFCOSTSCIVILPERM_A Offcostscivilperm a Numeric decimal(12,2) No
OFFCOSTSFIBERINSTALL_A Offcostsfiberinstall a Numeric decimal(12,2) No
DIGGINGCOSTS_A Diggingcosts a Numeric decimal(12,2) No
DIGGINGLENGTH_A Digginglength a Numeric non-decimal(10) No
RECONSTRUCTIONLENGTH_A Reconstructionlength a Numeric non-decimal(10) No
BLOWCOSTS_A Blowcosts a Numeric decimal(12,2) No
BLOWLENGTH_A Blowlength a Numeric non-decimal(10) No
BLOCKEDAREACOSTS_A Blockedareacosts a Numeric decimal(12,2) No
CONNECTIONCOSTS_A Connectioncosts a Numeric non-decimal(1) No Lijstwaarde: YESNO
BBHANDHOLECOSTS_A Bbhandholecosts a Numeric non-decimal(1) No Lijstwaarde: YESNO
RAILWAYS_A Railways a Numeric non-decimal(4) No
WATERWAYS_A Waterways a Numeric non-decimal(4) No
WATERWAYLENGTH_A Waterwaylength a Numeric non-decimal(10) No
WATERWAYLENGTHS_A Waterwaylengths a Alphanumeric(80) No
MOTORWAYS_A Motorways a Numeric non-decimal(4) No
MAJORROADS_A Majorroads a Numeric non-decimal(4) No
SECONDARYROADS_A Secondaryroads a Numeric non-decimal(4) No
LOCALROADS_A Localroads a Numeric non-decimal(4) No
CONNECTINGROADS_A Connectingroads a Numeric non-decimal(4) No
ONNET_A Onnet a Numeric non-decimal(1) No
OUTSIDESPECS_A Outsidespecs a Numeric non-decimal(1) No
ERRORSTRING_B Errorstring b Alphanumeric(300) No
OFFCOSTSCIVILPERM_B Offcostscivilperm b Numeric decimal(12,2) No
OFFCOSTSFIBERINSTALL_B Offcostsfiberinstall b Numeric decimal(12,2) No
DIGGINGCOSTS_B Diggingcosts b Numeric decimal(12,2) No
DIGGINGLENGTH_B Digginglength b Numeric non-decimal(10) No
RECONSTRUCTIONLENGTH_B Reconstructionlength b Numeric non-decimal(10) No
BLOWCOSTS_B Blowcosts b Numeric decimal(12,2) No
BLOWLENGTH_B Blowlength b Numeric non-decimal(10) No
BLOCKEDAREACOSTS_B Blockedareacosts b Numeric decimal(12,2) No
CONNECTIONCOSTS_B Connectioncosts b Numeric non-decimal(1) No Lijstwaarde: YESNO
BBHANDHOLECOSTS_B Bbhandholecosts b Numeric non-decimal(1) No Lijstwaarde: YESNO
RAILWAYS_B Railways b Numeric non-decimal(4) No
WATERWAYS_B Waterways b Numeric non-decimal(4) No
WATERWAYLENGTH_B Waterwaylength b Numeric non-decimal(10) No
WATERWAYLENGTHS_B Waterwaylengths b Alphanumeric(80) No
MOTORWAYS_B Motorways b Numeric non-decimal(4) No
MAJORROADS_B Majorroads b Numeric non-decimal(4) No
LOCALROADS_B Localroads b Numeric non-decimal(4) No
SECONDARYROADS_B Secondaryroads b Numeric non-decimal(4) No
CONNECTINGROADS_B Connectingroads b Numeric non-decimal(4) No
ONNET_B Onnet b Numeric non-decimal(1) No
OUTSIDESPECS_B Outsidespecs b Numeric non-decimal(1) No
MOTORWAYCOSTS Motorwaycosts Numeric decimal(12,2) No
SECONDARYROADCOSTS Secondaryroadcosts Numeric decimal(12,2) No
MAJORROADCOSTS Majorroadcosts Numeric decimal(12,2) No
LOCALROADCOSTS Localroadcosts Numeric decimal(12,2) No
CONNECTINGROADCOSTS Connectingroadcosts Numeric decimal(12,2) No
FIXEDNETWORKCOSTS Fixednetworkcosts Numeric decimal(12,2) No
RAILWAYCOSTS Railwaycosts Numeric decimal(12,2) No
WATERWAYCOSTS Waterwaycosts Numeric decimal(12,2) No
WATERWAYMETERCOSTS Waterwaymetercosts Numeric decimal(12,2) No
BLOWCOSTS Blowcosts Numeric non-decimal(10) No
EQ_COSTS1 Eq costs1 Numeric non-decimal(10) No
EQ_COSTS2 Eq costs2 Numeric non-decimal(10) No
NETWORK_STRAIGHT Network straight Numeric decimal(10,2) No
DIGGING_STRAIGHT Digging straight Numeric decimal(10,2) No
DIGCOSTS Digcosts Numeric non-decimal(10) No
RECONSTRUCTIONCOSTS Reconstructioncosts Numeric non-decimal(10) No
EXISTING_HH_LIMIT Existing hh limit Numeric non-decimal(10) No
CONNECTIONCOSTS Connectioncosts Numeric non-decimal(10) No
BACKBONEHHCOSTS Backbonehhcosts Numeric non-decimal(10) No
MAX_WATER_DRILLINGS Max water drillings Numeric non-decimal(10) No
MAX_BLOW_DISTANCE Max blow distance Numeric non-decimal(10) No
MAX_DIG_DISTANCE Max dig distance Numeric non-decimal(10) No
MAX_TAIL_COSTS Max tail costs Numeric non-decimal(10) No
MAX_NETWORK_LENGTH Max network length Numeric non-decimal(10) No
MIN_BLOW_DISTANCE Min blow distance Numeric non-decimal(10) No
NETWORKCOSTS Networkcosts Numeric non-decimal(10) No
STARTUP Startup Numeric non-decimal(10) No
STARTUP_ONNET_CUST Startup onnet cust Numeric non-decimal(10) No
STARTUP_ONNET_POP Startup onnet pop Numeric non-decimal(10) No
RISK_PERCENTAGE Risk percentage Numeric non-decimal(10) No
CROSS_RAILWAYS Cross railways Numeric non-decimal(1) No Lijstwaarde: YESNO
CABLES_REQUIRED Cables required Numeric non-decimal(1) No Lijstwaarde: YESNO
NO_NEW_HH No new hh Numeric non-decimal(1) No Lijstwaarde: YESNO
SENDRESPONSEERROR Sendresponseerror Alphanumeric(180) No
ROUTINGRESULT_ID Routingresult id Numeric non-decimal(10) No
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change

Saplease (SAPLEASE)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
SAP_BES_NUMMER Sap_bes_nummer Alphanumeric(50) Yes
SAP_POS_NUMMER Sap_pos_nummer Alphanumeric(50) Yes
EIND_DATE_SAP_BEST Eind_date_sap_best Datetime No
BEDRIJFSPROCES Bedrijfsproces Alphanumeric(50) No
SAP_ACTIVITEIT Sap_activiteit Alphanumeric(50) No
SAPNETWERKPLANNUMMER Sapnetwerkplannummer Alphanumeric(50) No
AANSLUITTARIEF Aansluittarief Numeric decimal(9,2) No
MAANDTARIEF Maandtarief Numeric decimal(9,2) No
EENMALIGE_KOSTEN Eenmalige_kosten Numeric decimal(9,2) No
DATUM_EENMALIGE_KOST Datum_eenmalige_kost Datetime No

Section (SECTIE)
Section names
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
CLIENT* Sectie Alphanumeric(50) No Hoofdletters Identification of the object
SERVER* Server Alphanumeric(50) no Hoofdletters, Verwijst naar: Server Name of the server for this client
CONTRACTID Contract Numeric non-decimal(11) No Verwijst naar: Contract Number of a contract
KLANTID Customer Numeric non-decimal(38) No Verwijst naar: Customer Identification of the object
KLANTNAAM Customer name Alphanumeric(50) no Name of the customer
LINKNAAM Link Alphanumeric(60) no Name of the linked logical connection
IMPORT Imported Alphanumeric(1) No Lijstwaarde: JANEE_UPPER Indicates that a section has been imported from another system
RINGNAAM Ring name Alphanumeric(50) No Name of the ring
IPADRES IP address Alphanumeric(30) no IP-address linked to a section name
LASWERKGEREED Gutter ready Alphanumeric(1) No Lijstwaarde: JANEE_SPACE_LOWER
METINGGEREED Measurement ready Alphanumeric(1) No Lijstwaarde: JANEE_SPACE_LOWER
AANTAL_OPENSTAANDE_ACTIES_BB Number of open tasks bb Numeric non-decimal(3) No
AANTAL_OPENSTAANDE_ACTIES_ALL Number of open tasks all Numeric non-decimal(3) No
GEMELD_AAN_NEIS External notification Alphanumeric(1) Yes Lijstwaarde: JANEE_UPPER
REVERSED Reversed Numeric non-decimal(1) No Lijstwaarde: YESNO Client and server reversed (used for multi layer modal at EF Belgium in case of protection)
APPARATUURGROEP Equipment group Alphanumeric(120) no Name of the linked equipment group
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record

Server (SERVER)
Servers section names on a higher level
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
SERVER* Server name Alphanumeric(50) Yes Hoofdletters Identification of the object
TYPE Type Alphanumeric(50) Yes Type of the object
AANTALCLIENTS Number of clients Numeric non-decimal(11) No Number of used clients in a server
AANTALVRIJ Number free Numeric non-decimal(11) No Number of free clients in a server
UPDATETIME Edited Datetime No Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Userid who made the last change on the record

Signaltypes (SIGNALTYPES)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
NAME* Name Alphanumeric(50) Yes
FAMILY* Family Numeric non-decimal(4) Yes
WAVELEN_PICO* Wavelen_pico Numeric non-decimal(11) No
UPDATETIME Updatetime Datetime Yes
UPDATEUSER Updateuser Alphanumeric(50) No

Service (SITESRV)
Services available on location
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
PLACE_ID* Location Numeric non-decimal(10) Yes Verwijst naar: Location
SERVICE_ID* Service Numeric non-decimal(10) Yes

Soortafwerkeenheid (SOORTAFWERKEENHEID)
All possible types of termination units
Properties
Technical name Label Type Mandatory Entry info Description
SOORTAFWERKEENHEID Soortafwerkeenheid Alphanumeric(25) Yes Identification of the object
TYPE Type Alphanumeric(50) No Type of the object
AANTAL_AFWERKEENHEDEN Aantal_afwerkeenheden Numeric non-decimal(5) No Maximum number of patch panels in a frame
AANTAL_TRAYS Aantal_trays Numeric non-decimal(5) No Maximum number of trays in a patch panel
AANTAL_POSITIES_PER_TRAY Aantal_posities_per_tray Numeric non-decimal(5) No Maximum number of positions in a tray in a patch panel
AANTAL_LASEENHEDEN Aantal_laseenheden Numeric non-decimal(5) No Maximum number of splicing shelfs in a frame
AANTAL_LASCASSETTES Aantal_lascassettes Numeric non-decimal(5) No Maximum number of cassettes in a splicing shelf
AANTAL_POSITIES_PER_CASSETTE Aantal_posities_per_cassette Numeric non-decimal(5) No Maximum number of positions in a cassette in a splicing shelf
AANTAL_HOOGTE_EENHEDEN Aantal_hoogte_eenheden Numeric non-decimal(5) No Number of height units
COMBI Combi Alphanumeric(1) Yes Indicates that a patch panel is comined with a splicing shelf
DEFAULT_CONNECTOR Default_connector Alphanumeric(50) No The connector type default used at this type of equipment
AANTAL_KABELS Aantal_kabels Numeric non-decimal(3) No Number of cables alowed on a patch unit
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
KOSTEN Kosten Numeric decimal(11,2) No
EENHEID Eenheid Alphanumeric(250) No
BREEDTE Width Numeric decimal(6,1) No
BLOCKED Blocked Numeric non-decimal(1) Yes Lijstwaarde: YESNO
KLANTAANSLUITING Customerconnection Numeric non-decimal(1) No Lijstwaarde: YESNO
KLANTAANSLUITINGRASS Customerconnection rass Numeric non-decimal(1) No Lijstwaarde: YESNO

Connectordetail (SOORTAFWERKEENHEIDDETAIL)
Detailed info on connector types
Properties
Technical name Label Type Mandatory Entry info Description
SOORTAFWERKEENHEID Soortafwerkeenheid Alphanumeric(25) Yes
POSITIE_LAAG Positie laag Numeric decimal(5) Yes
POSITIE_HOOG Positie hoog Numeric decimal(5) No
DEFAULT_CONNECTOR Default connector Alphanumeric(50) no
EVEN_ONEVEN Even oneven Alphanumeric(1) Yes

Span (SPAN)
Spans, collection of one or more cables and slacks
Properties
Technical name Label Type Mandatory Entry info Description
SPANID Spanid Numeric non-decimal(11) Yes Unique number for a cable(span) between two manipulatable locations
TYPEID Type Alphanumeric(50) No Stamtabel: KABELTYPE Type of the object
SPANKABELNAAM Name Alphanumeric(50) No Hoofdletters Name of the cable
STAGE Status Alphanumeric(25) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
INSTALLCOMPANY Install company Alphanumeric(50) Yes STATI_OMS:INSTALLATIEBEDRIJF Company who installed the involved objects
INSTALLYEAR Install year Numeric non-decimal(11) No Year of installing the object
INSTALLMONTH Install month Numeric non-decimal(11) No The month the object was built
INSTALLDAY Install day Numeric non-decimal(11) No The day the object was built
WORKORDER Project Alphanumeric(40) Yes Verwijst naar: Project Project number
MEDIUM Medium Alphanumeric(50) No Lijstwaarde: ROUTETYPE Type of fiber
OWNER Owner Alphanumeric(50) No Lijstwaarde: OWNER Purpose of the object (access, core etc.)
ROUTEID Route Numeric non-decimal(10) No Verwijst naar: Network area Indicating to which route a cable belongs
COSTS Costs Numeric non-decimal(11) No Costs ot the cable
DEPRECIATION Depreciation Numeric non-decimal(11) No
CONTRACTOR Cable owner Alphanumeric(50) no Stamtabel: OLO
CONTRACTDATE Contract date Datetime No End date contract with owner cable
FIBERLENGTH Fiber length Numeric non-decimal(11) No Fiber length given by external supplier
FIBERDAMPING Fiber attenuation Numeric decimal(10,2) No Fiber attenuation at 1310 nm given by external supplier
FIBERDAMPING2 Fiber attenuation 2 Numeric decimal(10,2) No Fiber attenuation at 1550 nm given by external supplier
AVAILABLE_FOR_SALES Available for sale Alphanumeric(1) No Lijstwaarde: JANEE_UPPER Indicates that a cable may be used for new customer drops
REELNUMBER Reel number Alphanumeric(50) No Hoofdletters Number of the reel
VERVANGT_SPANID Replaces spanid Numeric non-decimal(11) No
COMMENTS Comments Alphanumeric(250) Yes Comments field, free format
EXTERNAL_REF External ref Alphanumeric(32) No
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
PUBLICREGISTERSTATUS PublicregisterstatE Numeric non-decimal(11) No
MAINTAINER Maintainer Numeric non-decimal(11) No

Spanlength (SPANLENGTH)
Detailed collection of the spans
Properties
Technical name Label Type Mandatory Entry info Description
AUTOINDEX* Autoindex Numeric non-decimal(11) No Systeemveld Unique id for this object
SPANID Spanid Numeric non-decimal(11) Yes Verwijst naar: Span Unique number for a cable(span) between two manipulatable locations
OBJECTID Objectid Numeric non-decimal(11) No Unique identification of this object
LENGTHIN Lengthin Numeric non-decimal(11) Yes Length indication where span enters the handhole
LENGTHOUT Lengthout Numeric non-decimal(11) Yes Length indication where span leaves the handhole
TOTALLENGTH Totallength Numeric non-decimal(11) Yes Total length of a part of a cable(span)
ORD Ord Numeric non-decimal(5) Yes Order of a cable part within the span
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
TYP Typ Alphanumeric(15) No Type of the object
OPMERKING Opmerking Alphanumeric(5) No

Splice (SPLICETRAY)
Splices
Properties
Technical name Label Type Mandatory Entry info Description
LASID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
LOCATIE_NAAM* Location Alphanumeric(50) Yes Hoofdletters, Verwijst naar: Location Name of the location
ENCLOSUREID* Enclosure Alphanumeric(50) Yes Hoofdletters Name of the enclosure
ZIJDE Side Alphanumeric(1) Yes Lijstwaarde: SPLICETRAY_SIDE Side of the enclosure
TRAY Tray Numeric non-decimal(11) No Number of the cassette in an enclosure
TRAYPOS Position Numeric non-decimal(5) Yes Position of a fiber in the cassette in an enclosure
SPANA* Span A Numeric non-decimal(11) No Verwijst naar: Span Unique number for a cable(span) between two locations a-side
FIBERAFROM* Fiber from A Numeric non-decimal(5) No A-side : fiber from
FIBERATO* Fiber to A Numeric non-decimal(5) No A-side : fiber to
SPANB* Span B Numeric non-decimal(11) No Verwijst naar: Span Unique number for a cable(span) between two locations b-side
FIBERBFROM* Fiber from B Numeric non-decimal(5) No B-side : fiber from
FIBERBTO* Fiber to B Numeric non-decimal(5) No B-side : fiber to
SPLICETYPE Splice type Alphanumeric(50) Yes Lijstwaarde: SPLICETYPE Splice or no-splice
TRAYTYPE Tray type Alphanumeric(8) Yes Type of cassette in an enclosure
PROJECTNUMMER Project Alphanumeric(40) Yes Hoofdletters, Verwijst naar: Project Identification of the project
STATUS* Status Alphanumeric(1) Yes Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
DETAILSTATUS Detailstatus Alphanumeric(1) No Stamtabel: DETAILSTATUS
KNIPLAS Cut splice Numeric non-decimal(1) No Lijstwaarde: YESNO
NACHTWERK Nachtwerk Alphanumeric(1) No Lijstwaarde: JANEE_SPACE_LOWER
INSTALLCOMPANY Installcompany Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF
INSTALLDATE Installdate Datetime No
INSTALLER Installer Alphanumeric(50) No
UITVOERSTATUS Uitvoerstatus Alphanumeric(1) No Lijstwaarde: COCON_UITVOERSTATUS
SHORTCOMMENTS Shortcomments Alphanumeric(50) No
SPLICECOMMENTS Splicecomments Alphanumeric(500) No
UITVOERTOELICHTING Uitvoertoelichting Alphanumeric(500) No
ADDRESSID Addressid Numeric non-decimal(11) No
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record

Changed splice (SPLICETRAY_CHANGED)
Copy of Splicetray table
Properties
Technical name Label Type Mandatory Entry info Description
LASID Id Numeric non-decimal(11) Yes Systeemveld
LOCATIE_NAAM Location Alphanumeric(50) Yes
ENCLOSUREID Enclosure Alphanumeric(50) Yes
ZIJDE Side Alphanumeric(1) Yes
TRAY Tray Numeric non-decimal(11) No
TRAYPOS Position Numeric non-decimal(5) Yes
SPANA Span A Numeric non-decimal(11) No
FIBERAFROM Fiber from A Numeric non-decimal(5) No
FIBERATO Fiber to A Numeric non-decimal(5) No
SPANB Span B Numeric non-decimal(11) No
FIBERBFROM Fiber from B Numeric non-decimal(5) No
FIBERBTO Fiber to B Numeric non-decimal(5) No
SPLICETYPE Splice type Alphanumeric(50) Yes
TRAYTYPE Type Alphanumeric(8) Yes
PROJECTNUMMER Project Alphanumeric(40) Yes
STATUS Status Alphanumeric(1) Yes
DETAILSTATUS Detailstatus Alphanumeric(1) No
KNIPLAS Kniplas Numeric non-decimal(1) No
NACHTWERK Nachtwerk Alphanumeric(1) No Lijstwaarde: JANEE
INSTALLCOMPANY Installcompany Alphanumeric(50) No
INSTALLDATE Installdate Datetime No
INSTALLER Installer Alphanumeric(50) No
UITVOERSTATUS Uitvoerstatus Alphanumeric(1) No Lijstwaarde: COCON_UITVOERSTATUS
UPDATETIME Edited Datetime Yes Systeemveld
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld
SHORTCOMMENTS Shortcomments Alphanumeric(50) No
SPLICECOMMENTS Splicecomments Alphanumeric(500) No
UITVOERTOELICHTING Uitvoertoelichting Alphanumeric(500) No
ADDRESSID Addressid Numeric non-decimal(11) No

Spliceunit (SPLICEUNIT)
Non-splice info of an enclosure
Properties
Technical name Label Type Mandatory Entry info Description
AUTOINDEX Autoindex Numeric non-decimal(11) Yes Systeemveld Unique id for this object
LOCATIE_NAAM Location Alphanumeric(50) No Name of the location
ENCLOSUREID* Enclosureid Alphanumeric(50) No Verwijst naar: Enclosure Name of the enclosure
ENCLOSURETYPE Enclosuretype Alphanumeric(50) Yes Type of enclosre
OPSLAGRUIMTE1 Opslagruimte1 Alphanumeric(250) Yes Contents of the ? container in a n enclosure
OPSLAGRUIMTE2 Opslagruimte2 Alphanumeric(250) Yes Contents of the ? container in a n enclosure
OPSLAGRUIMTE3 Opslagruimte3 Alphanumeric(250) Yes Contents of the ? container in a n enclosure
OPSLAGRUIMTE4 Opslagruimte4 Alphanumeric(250) Yes Contents of the ? container in a n enclosure
KABELID1 Kabelid1 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID2 Kabelid2 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID3 Kabelid3 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID4 Kabelid4 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID5 Kabelid5 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID6 Kabelid6 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID7 Kabelid7 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
KABELID8 Kabelid8 Numeric non-decimal(11) Yes Verwijst naar: Span Cable identification in the involved port
MARKERING1 Markering1 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING2 Markering2 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING3 Markering3 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING4 Markering4 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING5 Markering5 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING6 Markering6 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING7 Markering7 Alphanumeric(10) Yes Measurement on the cable itself in port ?
MARKERING8 Markering8 Alphanumeric(10) Yes Measurement on the cable itself in port ?
OVERLENGTE1 Overlengte1 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE2 Overlengte2 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE3 Overlengte3 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE4 Overlengte4 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE5 Overlengte5 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE6 Overlengte6 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE7 Overlengte7 Alphanumeric(10) Yes Over length of the cable in port ?
OVERLENGTE8 Overlengte8 Alphanumeric(10) Yes Over length of the cable in port ?
GETEKEND Getekend Alphanumeric(50) no Drawing drawn by who
CONTROLE Check Alphanumeric(50) no Name of person who checked the enclosure
PROJECTNUMMER Projectnummer Alphanumeric(50) Yes Hoofdletters, Verwijst naar: Project Identification of the project
GETEKENDDATUM Getekenddatum Datetime No Drawing date
CONTROLEDATUM Check date Datetime No Date of checking the enclosure
UITGAVE Uitgave Alphanumeric(50) no Type of the object
OPMERKING Opmerking Alphanumeric(1000) no Comment concerning enclosure
STATUS Status Alphanumeric(1) Yes Status of the object 0(reserved), 1 (in use), 2 (cease)
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime Yes Systeemveld Date (and time) of the last change

Stati (STATI)
List of values for all kinds of information
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
TYPE* Type Alphanumeric(20) Yes Type of the object
STATUS* Status Alphanumeric(8) Yes Sevaral purposes
OMSCHRIJVING* Description Alphanumeric(200) Yes Sevaral purposes
OVERIG* Overig Alphanumeric(200) No Sevaral purposes
OPMERKINGEN Opmerkingen Alphanumeric(200) No Sevaral purposes
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
OMSCHRIJF_EN Description Alphanumeric(200) No English description
EXTRA1 Extra1 Alphanumeric(250) no
EXTRA2 Extra2 Alphanumeric(250) no
EXTRA3 Extra3 Alphanumeric(250) no
EXTRA4 Extra4 Alphanumeric(250) no
KOSTEN Kosten Numeric decimal(11,2) No
KOSTEN2 Kosten2 Numeric decimal(11,2) No
EENHEID2 Eenheid2 Alphanumeric(250) no
EENHEID Eenheid Alphanumeric(250) no
BLOCKED Blocked Numeric non-decimal(1) Yes

Statusaut (STATUSAUT)
Autorization table of status changes
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
STATUSTYPE* Statustype Numeric non-decimal(1) Yes
GROUPID* Groupid Alphanumeric(50) Yes
FROM_STATUS* From_status Alphanumeric(1) Yes
TO_STATUS To_status Alphanumeric(40) No
USERID Userid Alphanumeric(50) no

Accesspoint (TABAP)
Geographical table for accesspoins
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Object id Numeric non-decimal(10) Yes Verwijst naar: Location Unique identification of this object
SPANID Span ID Numeric non-decimal(10) No Unique number for a cable(span) between two manipulatable locations
X X Numeric decimal(10,1) No Systeemveld X-ordinate of this object
Y Y Numeric decimal(10,1) No Systeemveld Y-ordinate of this object
NAME* Name Alphanumeric(50) No Hoofdletters Name of the object
ALIASNAME Alias Alphanumeric(50) No
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
STATUS State Alphanumeric(1) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
GEOPEND Opened Alphanumeric(1) No Lijstwaarde: JANEE_UPPER Is a handhole opend ?
PROJECTSOORT Project type Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
ROUTETYPE Route type Alphanumeric(10) No Lijstwaarde: ROUTETYPE Type route (fiber or copper)
DETAILSTATUS Detail state Alphanumeric(1) No Stamtabel: DETAILSTATUS Detailed status of an object
APDEPTH Depth Numeric non-decimal(11) No The depth of an accesspoint
APCOVERED Covered Numeric non-decimal(1) No Lijstwaarde: YESNO Accesspoint is covered
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
CREATIONDATE Creation date Datetime No
CREATIONPROJECT Project created Alphanumeric(40) No
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

Building (TABBDG)
Geographical table for buildings
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Object id Numeric non-decimal(38) Yes Verwijst naar: Location Unique identification of this object
X X Numeric decimal(10,1) No Systeemveld X-ordinate of this object
Y Y Numeric decimal(10,1) No Systeemveld Y-ordinate of this object
NAME* Name Alphanumeric(50) No Hoofdletters Name of the object
ALIASNAME Alias Alphanumeric(50) No
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)
PROJECTSOORT Project type Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
VERDIEPINGEN Floors Numeric non-decimal(38) No Number of floors
LAAGSTEVERDIEPING Lowest floor Numeric non-decimal(38) No
VERMOGENPERTILE Power per tile Numeric non-decimal(38) No
PRIMARYPSU Primary PSU Numeric non-decimal(10) No
COMPLEXID Complex Numeric non-decimal(38) No Verwijst naar: Building
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
CREATIONDATE Creation Datetime No
CREATIONPROJECT Project created Alphanumeric(40) No
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)
DETAILSTATUS Detailstatus Alphanumeric(1) No LOV

Tabblo (TABBLO)
Geographical table for blocked areas
Properties
Technical name Label Type Mandatory Entry info Description
ID* Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
NAME* Name Alphanumeric(50) No Name of the object
COMMENTS Comments Alphanumeric(600) No Comments field, free format
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
HYPERLINK Hyperlink Alphanumeric(250) No Hyperlink to a file concerning this object
FIXEDPRICE Fixedprice Numeric decimal(10,2) No
METERPRICE Meterprice Numeric decimal(10,2) No
SOORT Soort Alphanumeric(1) No
EMAILADRES Emailadres Alphanumeric(50) No
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)

Drilling (TABBOR)
Geographical table for drillings
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Object id Numeric non-decimal(38) Yes Unique identification of this object
BRON Name Alphanumeric(30) No Name of the drilling
TYP Type Alphanumeric(50) No Type of the object
STATUS Status Alphanumeric(1) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
DETAILSTATUS Detail status Alphanumeric(1) No Stamtabel: DETAILSTATUS Detailed status of an object
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
PROJECTSOORT Project kind Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
INSTALLCOMPANY Install company Alphanumeric(50) No STATI_OMS:INSTALLATIEBEDRIJF Company who installed the involved objects
INSTALLDAY Install day Numeric non-decimal(11) No The day the object was built
INSTALLMONTH Install month Numeric non-decimal(11) No The month the object was built
INSTALLYEAR Install year Numeric non-decimal(11) No Year of installing the object
NUMBEROFDUCTS Number of ducts Alphanumeric(3) No Number of ducts in a drilling
DIAMETER Diameter Alphanumeric(3) No Diameter drilling
MATERIAAL Material Alphanumeric(50) no
LENGTE Length Alphanumeric(8) no
EIGENDOM Ownership Alphanumeric(50) no
COMMENTS Comments Alphanumeric(250) No Comments field, free format
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
EXTERNAL_REF External reference Alphanumeric(32) No
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

Tabcab (TABCAB)
Geographical table for cables
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Objectid Numeric non-decimal(38) Yes Verwijst naar: Cable Unique identification of this object
SPANID Spanid Numeric non-decimal(38) No Verwijst naar: Span Unique number for a cable(span) between two manipulatable locations
BRON Bron Alphanumeric(50) No Name of the cable
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
OWNER Owner Alphanumeric(10) No Lijstwaarde: OWNER Purpose of the object (access, core etc.)
STATUS_NUM Status_num Numeric non-decimal(38) No Status of the object 0(reserved), 1 (in use), 2 (cease)
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
PROJECTSOORT Projectsoort Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
DETAILSTATUS Detailstatus Alphanumeric(1) No Detailed status of an object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
GEOLENGTH Geolength Numeric decimal(10,1) No Length of object generate by sdo_length
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
CREATIONDATE Creationdate Datetime No
CREATIONPROJECT Creationproject Alphanumeric(40) No
ALIASNAME Alias Alphanumeric(50) No
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)

Trench (TABCON)
Geographical table for duct routes
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Id Numeric non-decimal(38) Yes Verwijst naar: Trench Unique identification of this object
BRON Name Alphanumeric(50) No Name of the duct route
STATUS Status Alphanumeric(1) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
DETAILSTATUS Detail status Alphanumeric(1) No Stamtabel: DETAILSTATUS Detailed status of an object
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
PROJECTSOORT Project type Alphanumeric(1) No Systeemveld Identification of the type of project
ROUTETYPE Route type Alphanumeric(10) No Lijstwaarde: ROUTETYPE Type route (fiber or copper)
GEOLENGTH Length Numeric decimal(12,2) No Length of object generate by sdo_length
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
KLICON_MELDING_ID Klicon ID Numeric non-decimal(10) No Identification of the object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
CREATIONDATE Created Datetime No
CREATIONPROJECT Creation project Alphanumeric(40) No
SPANID Span ID Numeric non-decimal(38) No Unique number for a cable(span) between two manipulatable locations
CONTENTS Contents Alphanumeric(254) No Indicating the contents of a ductroute (for label-usages)
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

DP area (TABDP)
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Id Numeric non-decimal(11) Yes Systeemveld
NAAM* Name Alphanumeric(50) no Hoofdletters
ZWAARTEPUNT_X Point of mass addresses X Numeric non-decimal(22) No
ZWAARTEPUNT_Y Point of mass addresses Y Numeric non-decimal(22) No
MAX_WONINGEN Max # homes Numeric non-decimal(6) No
AANTAL_WONINGEN # homes Numeric non-decimal(6) No
PROJECTNUMMER AP area Alphanumeric(50) no Hoofdletters, Verwijst naar: Project
PLAATSNAAM City Alphanumeric(50) no
DATETIME_CALC Calculated Datetime No
MI_SYMBOLOGY Mi_symbology Alphanumeric(50) No Systeemveld
UPDATETIME Edited Datetime No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld
TRAJECT_LENGTE Route length Numeric decimal(11) No
KABEL_LENGTE Cable length Numeric decimal(11) No
BORING_LENGTE Garden drilling length Numeric decimal(11) No
CALCULATED_DIGGING_LENGTH Calculated digging length Numeric decimal(11) No
CALCULATED_TRENCH_LENGTH Calculated trench length Numeric decimal(11) No
CALCULATED_CABLE_LENGTH Calculated trench cable length Numeric decimal(11) No
CALCULATED_DRILLING_LENGTH Calculated drilling length Numeric decimal(11) No
PLANDATUM Plan date Datetime No
REALISATIEDATUM Date realized Datetime No
UITVOERDER Contractor Alphanumeric(20) No
BUIZENIMPORT Ducts import Datetime No
BLOCKED Blocked Numeric decimal(1) No Lijstwaarde: YESNO
BLOCKUSER Blocked by Alphanumeric(50) No
ADDRESS_DEADLINE Address deadline Date No
GEOLOC Geometry Geometry No Systeemveld

Enclosure (TABENC)
Geographical table for enclosures
Properties
Technical name Label Type Mandatory Entry info Description
NAME* Name Alphanumeric(50) No Hoofdletters Name of the object
OBJECTID Object id Numeric non-decimal(38) Yes Verwijst naar: Enclosure Unique identification of this object
TYPEID Type Alphanumeric(50) No Type of the object
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
PROJECTSOORT Project kind Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
STATUS State Alphanumeric(1) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
DETAILSTATUS Detail state Alphanumeric(1) No Stamtabel: DETAILSTATUS Detailed status of an object
X X Numeric decimal(10,1) No Systeemveld X-ordinate of this object
Y Y Numeric decimal(10,1) No Systeemveld Y-ordinate of this object
SPANID Span id Numeric non-decimal(38) No Unique number for a cable(span) between two manipulatable locations
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

Frame (TABFRA)
Geographical table for frames
Properties
Technical name Label Type Mandatory Entry info Description
FIBERMNGRID* Frame name Alphanumeric(100) No Hoofdletters
OBJECTID Object id Numeric non-decimal(38) Yes Verwijst naar: Frame Unique identification of this object
PLACEOBJECTID Location Numeric non-decimal(38) No Verwijst naar: Location ID of location
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
PROJECTSOORT Project kind Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
STATUS Status Alphanumeric(1) No Lijstwaarde: COCONSTATUS Status of the object 0(reserved), 1 (in use), 2 (cease)
DETAILSTATUS Detail status Alphanumeric(1) No Stamtabel: DETAILSTATUS Detailed status of an object
X X Numeric decimal(10,1) No Systeemveld X-ordinate of this object
Y Y Numeric decimal(10,1) No Systeemveld Y-ordinate of this object
SPANID Span id Numeric non-decimal(38) No Unique number for a cable(span) between two manipulatable locations
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

Permit (TABGUN)
Permits
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID* Object id Numeric non-decimal(11) Yes Unique identification of this object
KENMERK* Reference Alphanumeric(50) No Identification of the object
STATUS Authority Numeric non-decimal(3) No Stamtabel: VERGUNNING Status of the object 0(reserved), 1 (in use), 2 (cease)
VERLENER Name autority department Alphanumeric(50) No Authority giving the permit
PROJECTNR Project Alphanumeric(50) No Hoofdletters, Verwijst naar: Project Identification of the project
OPZEGTERMIJN Notice (days) Numeric non-decimal(10) Yes Term of notice
GEREEDGEMELD Ready Numeric non-decimal(2) No Ready
AANVRAAG Request date Date No Request date
VERSTREK Supply date Date No Date when permit was given
REFERENTIE_INTERN Internal reference Alphanumeric(50) Yes Reference internal
GEREEDDATUM Date of maturity of activities Date No Date ready
VERVALDATUM Date of maturity Date No Expiry date
STARTDATEBORG Start date deposit Date No
ENDDATEBORG End date deposit Date No
BORGBEDRAG Deposit amount Numeric non-decimal(6) No
RESTISTUTIE Restitution Numeric non-decimal(2) No
INGEVORDERD Collected Numeric non-decimal(2) No
OPMERKINGEN Comment Alphanumeric(254) No Comment concerning permit
HYPERLINK Hyperlink Alphanumeric(254) No Hyperlink to a file concerning this object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
MI_SYMBOLOGY Symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
PERMITOWNER Permitowner Alphanumeric(50) No Stamtabel: OLO
GEOLOC Geo Geometry No Systeemveld Geographical object (spatial)

Tablelock (TABLELOCK)
Softlocking a table for multiuser aspects (only used while splicing)
Properties
Technical name Label Type Mandatory Entry info Description
TABELNAAM Tabelnaam Alphanumeric(50) Yes Table which is blocked
DATUMTIJD Datumtijd Datetime No Date and time locking the table
USERNAAM Usernaam Alphanumeric(50) Yes Login name of the user
VERSION Version Numeric decimal(2) No

Tablog (TABLOG)
Geographical table for logical network transports (straight lines)
Properties
Technical name Label Type Mandatory Entry info Description
STARTLOC Startloc Alphanumeric(50) Yes Start location
ENDLOC Endloc Alphanumeric(50) Yes End location
FREE Free Numeric non-decimal(10) Yes Number of free logical fibers
RES Res Numeric non-decimal(10) Yes Number of logical fibers reserved
USED Used Numeric non-decimal(10) Yes Number of logical connections
REMOVE Remove Numeric non-decimal(10) Yes Number of logical fibers reserved for removal
OWNER Owner Alphanumeric(10) Yes Lijstwaarde: OWNER Purpose of the object (access, core etc.)
BEZETPERC Bezetperc Numeric decimal(10,1) Yes Percentage used
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)

Tabmes (TABMES)
Measurements
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(38) Yes Identification of the object
ID1 Id1 Numeric non-decimal(38) Yes Verwijst naar: Tabmes Identification of the object
ID2 Id2 Numeric non-decimal(38) Yes Verwijst naar: Tabmes Identification of the object
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld Geo-styoe of measurement lines
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
LABEL Label Alphanumeric(20) no Label of the measurement line

Drawing object (TABMID)
Central layer with free drawn objects
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes
NAAM Naam Alphanumeric(254) no
REMARKS Remarks Alphanumeric(254) no
GEOLOC Geoloc Geometry No Systeemveld
MI_SYMBOLOGY Mi_symbology Alphanumeric(50) No Systeemveld
UPDATETIME Edited Datetime No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) no
SOURCE Source Alphanumeric(5) No
REMOVEDATE Removedate Datetime No Systeemveld

Tabmsg (TABMSG)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
LOCATIENAAM Locatienaam Alphanumeric(50) No
ACTIVITEITCODE Activiteitcode Alphanumeric(5) No
MELDDATUMTIJD Melddatumtijd Datetime No
AFMELDDATUMTIJD Afmelddatumtijd Datetime No
USERNAAM Usernaam Alphanumeric(50) No
TELEFOONNUMMER Telefoonnummer Alphanumeric(15) No
USERNAAM_AF Usernaam_af Alphanumeric(50) No
TELEFOONNUMMER_AF Telefoonnummer_af Alphanumeric(15) No
FOUTMELDING Foutmelding Alphanumeric(250) No
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld
AFMELDCODE Afmeldcode Alphanumeric(5) No
GEOLOC Geo Geometry No
OORSPRONG Oorsprong Alphanumeric(1) No
HERINNERING_1_VERSTUURD Reminder 1 sent Datetime No
HERINNERING_2_VERSTUURD Reminder 2 sent Datetime No
AUTOMATISCH_AFGEMELD Automatisch afgemeld Datetime No

Tabrem (TABREM)
Properties
Technical name Label Type Mandatory Entry info Description
GUI Gui Alphanumeric(32) no
OBJECTID Id Numeric non-decimal(11) No
OBJECTTYPE Type Alphanumeric(15) no
OBJECTNAAM Objectname Alphanumeric(50) no Hoofdletters
REMARKER Remarker Alphanumeric(50) no
TO_EMAILADRES Reciever Alphanumeric(100) no
REMINDERTIME Time Alphanumeric(8) No
REMINDERDATE Date Date No
REMINDERTYPE By Alphanumeric(1) no
VIEWREMINDER Show Alphanumeric(1) no
REMARKTEXT Remark Alphanumeric(4000) no
UPDATETIME Edited Alphanumeric(8) No Systeemveld
EMAILVERSTUURDDATETIME Send email Datetime No
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld
UPDATEDATE Update date Date No
GEOLOC Geoloc Geometry No Systeemveld

Tabsla (TABSLA)
Geographical table for cable slacks
Properties
Technical name Label Type Mandatory Entry info Description
OBJECTID Objectid Numeric non-decimal(38) Yes Verwijst naar: Cable Unique identification of this object
SPANID Spanid Numeric non-decimal(38) No Verwijst naar: Span Unique number for a cable(span) between two manipulatable locations
X X Numeric decimal(10,1) No Systeemveld X-ordinate of this object
Y Y Numeric decimal(10,1) No Systeemveld Y-ordinate of this object
NAME Name Alphanumeric(50) No Name of the object
PROJECT Project Alphanumeric(40) No Hoofdletters, Verwijst naar: Project Identification of the project
MI_SYMBOLOGY Mi_symbology Alphanumeric(254) No Systeemveld Type of symbology of a geographical object
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
PROJECTSOORT Projectsoort Alphanumeric(1) No Stamtabel: PROJECTSRT Identification of the type of project
DETAILSTATUS Detailstatus Alphanumeric(1) No Detailed status of an object
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)

Survey object (TABSUR)
Survey information
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes
OBJECTTYPE Objecttype Alphanumeric(40) no
REMARKS Remarks Alphanumeric(254) no
GEOLOC Geoloc Geometry No Systeemveld
MI_SYMBOLOGY Mi_symbology Alphanumeric(50) No Systeemveld
UPDATETIME Edited Datetime No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) no

Tabwijz (TABWIJZ)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(22) No Systeemveld
UPDATETIME Edited Datetime No
UPDATEUSER Edited by Alphanumeric(50) No
GEOLOC Geo Geometry No

Teller (TELLER)
All types of requestable labels
Properties
Technical name Label Type Mandatory Entry info Description
SOORT Soort Alphanumeric(3) Yes Letter used for the label
MAXWAARDE Maxwaarde Numeric non-decimal(11) No Maximum value of label
VOORLOOPNULLEN Voorloopnullen Numeric non-decimal(5) No Numer of forerunning zero's used
OMSCHRIJVING Omschrijving Alphanumeric(50) No Description of the type of label used
VOLGORDE Volgorde Numeric non-decimal(5) No In this order things will be presented to a user
KABEL Kabel Numeric non-decimal(1) No Type of label may be used for cables
BUIS Buis Numeric non-decimal(1) No Type of label may be used for ducts
ACCESSPOINT Accesspoint Numeric non-decimal(1) No Type of label may be used for accesspoints
OMSCHRIJF_EN Omschrijf_en Alphanumeric(50) No English description
TYPELIJST Typelist Alphanumeric(500) No

Thematic Project (THEMATICPROJECT)
Thematic Project platform support table
Properties
Technical name Label Type Mandatory Entry info Description
ID Project id Numeric non-decimal(10) Yes Systeemveld
NAME* Project name Alphanumeric(30) Yes
ACTIVE Active Numeric non-decimal(1) Yes Lijstwaarde: YESNO 1- active in cocon/mapinfo 0 - not active
BUTTONNAME Button name Alphanumeric(30) Yes Name of the button created dinamically in frmMap ribbon
BUTTONICON Button icon Alphanumeric(30) Yes Icon for the button from cocon resources
BUTTONTOOLTIP Button tooltip Alphanumeric(100) No Button tooltip in frmMap ribbon - use it as key pointing to texts in metamanager
PERMISSIONGROUPS permission groups Alphanumeric(100) No Enumeration of cocon groups id, comma separated
THEMATICPROJECTDATA Thematic project data Blob Yes Binary serialization of the cocon.thematicproject class instance. (make sure the version matches)
UIDATA Uidata Blob No Used to store the UI selection data for some projects
VERSION Version Numeric non-decimal(2) Yes Thematicproject class version
CREATIONDATE Creation date Datetime Yes Creation date for the project
DISPLAYORDER Display order Numeric non-decimal(2) No
UPDATETIME Edited Datetime Yes Date when the entry was last updated
UPDATEUSER Edited by Alphanumeric(50) Yes Systeemveld User who did the last change

Tracedocuments (TRACEDOCUMENTS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
USERID Userid Alphanumeric(50) no
TO_EMAIL_ADRES To_email_adres Alphanumeric(50) no
PROJECTDOC_DOCNAME Projectdoc_docname Alphanumeric(250) no
PROJECTDOC_DATE_IN Projectdoc_date_in Datetime No
MAIL_SEND Mail_send Datetime No
MAIL_BODY Mail_body Alphanumeric(4000) no

Tracelas (TRACELAS)
History on splices
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
USERNAAM Usernaam Alphanumeric(50) No Login name of the user
REDEN Reden Alphanumeric(255) No Reason of mutation
TIJDSTIP Tijdstip Datetime No Time of mutation
LOCATIE_NAAM Locatie_naam Alphanumeric(50) No Name of the location
ENCLOSUREID Enclosureid Alphanumeric(50) No Name of the enclosure
SPANA Spana Numeric non-decimal(11) No Verwijst naar: Span Unique number for a cable(span) between two locations a-side
FAF Faf Numeric non-decimal(5) No A-side : fiber from
FAT Fat Numeric non-decimal(5) No A-side : fiber to
SPANB Spanb Numeric non-decimal(11) No Verwijst naar: Span Unique number for a cable(span) between two locations b-side
FBF Fbf Numeric non-decimal(5) No B-side : fiber from
FBT Fbt Numeric non-decimal(5) No B-side : fiber to
BLOKUSER Blokuser Alphanumeric(50) No User who has locked the table
SPLICEUSER Spliceuser Alphanumeric(50) No User who has made the splice
PROJECTNUMMER Projectnummer Alphanumeric(40) No Verwijst naar: Project Identification of the project
STATUS Status Alphanumeric(2) No Status of the object 0(reserved), 1 (in use), 2 (cease)
SPLICETYPE Splicetype Alphanumeric(50) No
TRAY Tray Numeric non-decimal(11) No
ZIJDE Zijde Alphanumeric(1) No
TRAYTYPE Traytype Alphanumeric(8) No
TRAYPOS Traypos Numeric non-decimal(5) No
KNIPLAS Kniplas Numeric non-decimal(1) No
DETAILSTATUS Detailstatus Alphanumeric(1) No
SHORTCOMMENTS Shortcomments Alphanumeric(50) No
SPLICECOMMENTS Splicecomments Alphanumeric(500) No
INSTALLCOMPANY Installcompany Alphanumeric(50) No
INSTALLDATE Installdate Datetime No
INSTALLER Installer Alphanumeric(50) No
UITVOERSTATUS Uitvoerstatus Alphanumeric(1) No
UITVOERTOELICHTING Uitvoertoelichting Alphanumeric(500) No
NACHTWERK Nachtwerk Alphanumeric(1) No

Traceoutage (TRACEOUTAGE)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
TTNR Ttnr Alphanumeric(50) no Verwijst naar: Project
ACTIE Actie Alphanumeric(50) no
UPDATETIME Edited Datetime No Systeemveld
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld

Tracepatch (TRACEPATCH)
History on patches
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
USERNAAM Usernaam Alphanumeric(50) No Login name of the user
REDEN Reden Alphanumeric(255) No Reason of mutation
TIJDSTIP Tijdstip Datetime No Time of mutation
LOCATIE_NAAM Locatie_naam Alphanumeric(50) No Name of the location
FRAMEA Framea Alphanumeric(50) No A-side : name of the frame
AFWERKEENHEIDNUMMERA Afwerkeenheidnummera Alphanumeric(50) No Number of the patch panel a-side
TRAYNUMMERA Traynummera Alphanumeric(10) No Number of the tray a-side
POSITIENUMMERA Positienummera Numeric non-decimal(11) No Number of the position in the tray a-side
ZIJDEA Zijdea Alphanumeric(6) No Side of patch panel A-side
FRAMEB Frameb Alphanumeric(50) No B-side : name of the frame
AFWERKEENHEIDNUMMERB Afwerkeenheidnummerb Alphanumeric(50) No Number of the patch panel b-side
TRAYNUMMERB Traynummerb Alphanumeric(10) No Number of the tray b-side
POSITIENUMMERB Positienummerb Numeric non-decimal(11) No Number of the position in the tray b-side
ZIJDEB Zijdeb Alphanumeric(6) No Side of patch panel B-side
LIJNBENAMING Lijnbenaming Alphanumeric(75) No Unique section name indicating the usage of a connection
PATCHUSER Patchuser Alphanumeric(50) No Name of person who made the patch
PROJECTNUMMER Projectnummer Alphanumeric(50) No Identification of the project
STATUS Status Alphanumeric(2) No Status of the object 0(reserved), 1 (in use), 2 (cease)
INSTALLCOMPANY Installcompany Alphanumeric(50) No
PATCHDATUM Patchdatum Date No
PATCHCOMMENTS Patchcomments Alphanumeric(500) No
UITVOERTOELICHTING Implementation explaination Alphanumeric(500) No
UITVOERSTATUS Implementation state Alphanumeric(1) No
LENGTE Length Numeric decimal(10,1) No
PATCHCORDTYPE Patchcordtype Alphanumeric(30) No
PATCHLABEL Patchlabel Alphanumeric(50) No

Traceproject (TRACEPROJECT)
Geographical table for history of projects
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld Identification of the object
PROJECTNUMMER Projectnummer Alphanumeric(50) Yes Verwijst naar: Project Identification of the project
USERNAME Username Alphanumeric(50) Yes Login name of the user
YEAR Year Alphanumeric(4) Yes Year
MONTH Month Alphanumeric(2) Yes Month
DAY Day Alphanumeric(2) Yes Day the project was saved
COMMENTS Comments Alphanumeric(250) no Comments field, free format
HYPERLINK Hyperlink Alphanumeric(250) no Hyperlink to a file concerning this object
GEOLOC Geoloc Geometry No Systeemveld Geographical object (spatial)

Tracetabrem (TRACETABREM)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
GUI Gui Alphanumeric(32) no Verwijst naar: Tabrem
OBJECTID Id Numeric non-decimal(11) No
OBJECTTYPE Type Alphanumeric(15) no
OBJECTNAAM Object name Alphanumeric(50) no
REMARKER Remarker Alphanumeric(50) no
TO_EMAILADRES Reciever Alphanumeric(50) no
REMINDERTIME Time Alphanumeric(8) No
REMINDERDATE Date Date No
REMINDERTYPE By Alphanumeric(1) no
VIEWREMINDER Show Alphanumeric(1) no
REMARKTEXT Remark Alphanumeric(4000) no
GEOLOC Geoloc Geometry No Systeemveld
UPDATETIME Edited Alphanumeric(8) No Systeemveld
EMAILVERSTUURDDATETIME Send Email Datetime No
UPDATEUSER Edited by Alphanumeric(50) no Systeemveld
UPDATEDATE Updatedate Date No

Traceuser (TRACEUSER)
History per user per month per menu choice
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
USERNAAM Usernaam Alphanumeric(50) No Login name of the user
FUNCTIE Functie Alphanumeric(255) No Action executed by user
JAARMAAND Jaarmaand Alphanumeric(6) No Year and month of the involved action
DATUM Datum Datetime No Date
AANTAL Aantal Numeric non-decimal(11) No Identification of the project
VERVALLEN Vervallen Numeric non-decimal(1) No Not used anymore

UI setting (UISETTING)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
TYPE* Type Numeric non-decimal(1) Yes Lijstwaarde: UISETTING_TYPE
TABLE* Table Alphanumeric(32) Yes
CONTEXT* Context Alphanumeric(50) No Systeemveld
NAME* Name Alphanumeric(40) Yes
CATEGORY Category Alphanumeric(32) No
COCONUSER_ID User Numeric non-decimal(10) No Verwijst naar: Coconuser
DATA Data Blob No

Userlog (USERLOG)
Log in history per user
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld Identification of the object
USERNAME Username Alphanumeric(50) No Login name of the user
LOGIN Login Datetime No Date and time of user logging in
LOGOUT Logout Datetime No Date and time of user logging out
COMPUTERNAME Computername Alphanumeric(50) No Name of the computer
COMPONENTVERSIE Componentversie Alphanumeric(1) Yes
COCONVERSIE Coconversie Alphanumeric(2) Yes
COCONONJUISTEINDE Cocononjuisteinde Alphanumeric(300) No
IPADDRESS Ipaddress Alphanumeric(45) No

Installcompany user (USER_INSTALLCOMPANY)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(22) Yes Systeemveld
COCONUSER_ID* Coconuser id Numeric decimal(22) Yes Verwijst naar: Coconuser
INSTALLCOMPANY_ID* Installcompany id Numeric decimal(22) Yes Verwijst naar: Stati

Customer user (USER_KLANT_ACCESS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(38) Yes Systeemveld
USER_ID* User_id Numeric non-decimal(38) Yes Verwijst naar: Coconuser
KLANT_ID* Klant_id Numeric non-decimal(38) Yes Verwijst naar: Customer

Verbinding (VERBINDING)
Connections, combination of one or more fibers in a row
Properties
Technical name Label Type Mandatory Entry info Description
VERBINDINGNUMMER Connection Numeric non-decimal(11) Yes Systeemveld Unique number for connection
STATUS Status Alphanumeric(1) No Status of the object 0(reserved), 1 (in use), 2 (cease)
LIJNBENAMING Section name Alphanumeric(50) no Verwijst naar: Section Unique section name indicating the usage of a connection
PROJECTNUMMER Project number Alphanumeric(50) Yes Hoofdletters, Verwijst naar: Project Identification of the project
RESERVERINGSDATUM Reservation date Datetime Yes Date of reservation
RESERVERINGSEINDDATUM Res. end date Datetime Yes Date when reservation expires
AANVRAAGUSER Request user Alphanumeric(50) no User who requested the reservation
UPDATETIME Edited Datetime No Systeemveld Date (and time) of the last change
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld Userid who made the last change on the record
SERVICEPRIORITEIT Service priority Alphanumeric(2) No Indicating the priority of the connection
SUBSECTIE Subsection Alphanumeric(50) No

Web session (WEBSESSION)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
SESSIONID* Sessionid Alphanumeric(50) Yes
LOGGEDIN Loggedin Datetime No
LOGGEDOUT Loggedout Datetime No
UPDATETIME Edited Datetime No Systeemveld
IPADDRESS Ipaddress Alphanumeric(32) No
USERNAME Username Alphanumeric(50) No

Web statistics (WEBSTATS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
APPLICATION Application Alphanumeric(20) No
APP_VERSION App_version Alphanumeric(16) No
ACTION Action Alphanumeric(50) No
DURATION Duration Numeric non-decimal(10) No
PARAMS Params Alphanumeric(80) No
CUSTOMER Customer Alphanumeric(24) No
COMPUTER Computer Alphanumeric(80) No
USERNAME Username Alphanumeric(80) No
IP_ADDRESS Ip_address Alphanumeric(15) No
UPDATEUSER Edited by Alphanumeric(50) No Systeemveld
UPDATETIME Edited Datetime No Systeemveld

WorkOn file (WORKONFILE)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
SUBFOLDER* Subfolder Alphanumeric(80) No
FILENAME* Filename Alphanumeric(70) Yes
OBJECTTYPE* Objecttype Alphanumeric(15) No
DATECREATED Datecreated Datetime Yes
DATEMODIFIED Datemodified Datetime Yes
DATEACCEPTED Dateaccepted Datetime No
ACCEPTANCEUSER Acceptanceuser Alphanumeric(50) No
PROJECTNR Projectnr Alphanumeric(40) No
AUTHOR Author Alphanumeric(50) No
PROCESSED Accepted Numeric decimal(1) Yes Lijstwaarde: YESNO
STATUS Status Numeric decimal(1) Yes
CREATOR Creator Alphanumeric(15) Yes
INSTALLCOMPANY Installcompany Alphanumeric(50) Yes

WorkOn splice (WORKONLAS)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(10) Yes Systeemveld
ENCLOSUREID Enclosureid Alphanumeric(50) No
SPANID_A Spanid a Numeric non-decimal(11) No Verwijst naar: Ospspanfiber
VEZEL_A Vezel a Numeric non-decimal(5) No Verwijst naar: Ospspanfiber
SPANID_B Spanid b Numeric non-decimal(11) No Verwijst naar: Ospspanfiber
VEZEL_B Vezel b Numeric non-decimal(5) No Verwijst naar: Ospspanfiber
UITVOERSTATUS Uitvoerstatus Alphanumeric(1) No
INSTALLCOMPANY Installcompany Alphanumeric(50) No
LIJNBENAMING Lijnbenaming Alphanumeric(50) No
SERVICEPRIORITEIT_HUID Serviceprioriteit huid Alphanumeric(2) No
LIJNBENAMING_TOEK Lijnbenaming toek Alphanumeric(60) No
DETAILSTATUS_LAS Detailstatus las Alphanumeric(1) No
NACHTLAS Nachtlas Alphanumeric(1) No
COMBILAS Combilas Alphanumeric(1) No
STATUS_LAS Status las Alphanumeric(1) No
INSTALLER Installer Alphanumeric(50) No
UPDATETIME Edited Datetime Yes

Workonobject (WORKONOBJECT)
Properties
Technical name Label Type Mandatory Entry info Description
ID Id Numeric non-decimal(11) Yes Systeemveld
ENCLOSUREID Enclosureid Alphanumeric(50) No
OBJECTNAAM Objectnaam Alphanumeric(100) No
OBJECTID Objectid Numeric non-decimal(11) No
OBJECTTYPE Objecttype Alphanumeric(15) No Systeemveld
ACTIE Action Alphanumeric(8) No Lijstwaarde: WORKONACTIE
OBJECTDATA Content Alphanumeric(800) No
COMMENTS Comments Alphanumeric(500) No
INSTALLCOMPANY Install company Alphanumeric(50) No
WORKONUSER Field work user Alphanumeric(50) No
INSERTDATETIME Change date Datetime No
STATUS Status Alphanumeric(2) No Lijstwaarde: WORKONACTIESTATUS
OBJECTDATA_ORG Old data Alphanumeric(800) No
RESULTS Result Alphanumeric(500) No
UPDATEUSER Edited by Alphanumeric(50) No
UPDATETIME Edited Datetime No
UITVOERSTATUS Process status Alphanumeric(1) No
UITVOERTOELICHTING Process comment Alphanumeric(500) No
PROJECTNUMMER Projectnumber Alphanumeric(40) No
GEOLOC Geoloc Geometry No

AGGREGATE
ALIGNMENT
AUTORISATIENIVEAU
AVAILABLE_SERVICE
COCONCONTACTTYPE
COCONSETTING_SECTION
COCONSTATUS
COCON_UITVOERSTATUS
COORDSYSNUMBER_ORACLE
COORDSYSNUMBER_POSTGRES
COUNTRY
CS_AUTOMATICDESIGN
CS_BAG
CS_CCCROUTING
CS_CUSTEXCEPTIONS
CS_CUSTEXCEPTIONSBOOLEAN
CS_CUSTEXEPTIONS
CS_CUSTEXEPTIONSBOOLEAN
CS_FIXEDLENGTHNUMERIC
CS_FTTHIMPORT
CS_GLOBVAR
CS_INVOERENPUNT
CS_LOCALIZEDSLACK
CS_NONSLACKFRAMES
CS_PROTECTIONENVIRONMENT
CS_RESERVEERTRAJECT
CS_ROUTING
CS_SLACKFRAMES
CS_ZOOMLAYERMAX
CS_ZOOMLAYERMIN
CULTURE
DAYS
EVENTTYPE
EXISTS
FIBERS_USED
FINANCECODEKIND
FLD_TYPE
FTTO_STATUS
GEOTYPE
GEO_TYPE
GOODWRONG
ICONSIZE
IMPORT_EXISTS
JANEE
JANEE_SPACE_LOWER
JANEE_SPACE_UPPER
JANEE_UPPER
KASTZIJDE
LANGUAGE
LOCATIETYPE
MD_ALIGNMENT
MEDIUM
NETWORK_CONCEPT
NORECORDSACTION
ODF_PORT_STATE
OFFICE_VERSION
OPERAND_TYPE
ORDER
ORIENTATION
OUTAGESTATUS
OUTPUTMODES
OWNER
PARSEMOMENT
PATCHORDER_CANCELCODE
PATCHORDER_CLOSECODE
PATCHORDER_CLOSECODE_OBS
PATCHORDER_DENYCODE
PATCHORDER_HOLDCODE
PATCHORDER_KIND
PATCHORDER_RESUMECODE
PATCHORDER_STATUS
PATCHORDER_STATUS_QQQ
PATCHORDER_TYPE
PERIODS
PLACE_DESCRIPTION
PORT_MARK
PPS_ORDER_TYPE
PROJECTSOORT
PROJECTSTATUS
RECORDNODE_TYPE
REPORTEXPORTFORMAT
ROUTETYPE
SPLICETRAY_SIDE
SPLICETYPE
STATI_TYPE
TREEITEM_TYPE
TRUEFALSE
UISETTING_TYPE
UPGRADEALERTSTATUS
WEBSERVICEPHASE
WINDOWSTYLE
WORKONACTIE
WORKONACTIESTATUS
WORKONFIELDACTION
WORKONOBJECTTYPE
XREPORTEXPORTFORMAT
YESNO
YESNONA
YESNO_UPPER
ZIPCODE_REGION

AGGREGATE
Properties
Label Code Value
Sum SUM 0
Average AVERAGE 0
Minimum MINIMUM 0
Maximum MAXIMUM 0

ALIGNMENT
Properties
Label Code Value
Left L 0
Right R 0

AUTORISATIENIVEAU
Properties
Label Code Value
0
One 1 0
Two 2 0

AVAILABLE_SERVICE
Properties
Label Code Value
Construct 1
Migrate 2

COCONCONTACTTYPE
Properties
Label Code Value
No c 0
Yes k 0

COCONSETTING_SECTION
Properties
Label Code Value
Automaticdesign AutomaticDesign 0
Bag BAG 0
Cccrouting CCCRouting 0
Custexceptions CustExceptions 0
Custexceptionsboolean CustExceptionsboolean 0
Custexeptions CustExeptions 0
Custexeptionsboolean CustExeptionsboolean 0
Fixedlengthnumeric FixedLengthNumeric 0
Ftthimport FTTHImport 0
Globvar GlobVar 0
Invoerenpunt InvoerenPunt 0
Localizedslack LocalizedSlack 0
Monthly amount codes MonthlyAmountCodes 0
Nonslackframes NonSlackFrames 0
Once only amount codes OnceOnlyAmountCodes 0
Projectdbcontroles ProjectDBControles 0
Protectionenvironment ProtectionEnvironment 0
Redemption codes RedemptionCodes 0
Reserveertraject ReserveerTraject 0
Routing Routing 0
Slackframes SlackFrames 0
Zoomlayermax ZoomLayerMax 0
Zoomlayermin ZoomLayerMin 0

COCONSTATUS
Properties
Label Code Value
Reserved for connect 0 0
In use 1 0
Reserved for removal 2 0

COCON_UITVOERSTATUS
Properties
Label Code Value
Fault F 0
Not done N 0
Already done R 0
Done U 0
Done differently W 0
0

COORDSYSNUMBER_ORACLE
Properties
Label Code Value
Utm 0
France 2154
Wgs84 4326
Germany 25832
Ireland 29902
Netherlands 90112
Belgiumold 1327680
Spain 1328000
Belgium 2327680

COORDSYSNUMBER_POSTGRES
Properties
Label Code Value
France 2154
Germany 3044
Wgs84 4326
Utmzone30nspain 23030
Netherlands 28992
Tm65ireland 29902
Thailand 32647
Spain 132800
Netherlandssterenew 828992
Googlemercator 900913
Utmzone30nspainsimple 923030
Netherlandsstere 928992
Belgium 931370

COUNTRY
Properties
Label Code Value
Belgium BELG 0
Belgium old BELG_OLD 0
Germany DEUT 0
Spain ESPA 0
France FRAN 0
Ireland IREL 0
Netherlands NETH 0
Utm UTM 0

CS_AUTOMATICDESIGN
Properties
Label Code Value
Buildsuccesslimit BuildSuccessLimit 0
Fiberroutingsuccesslimit FiberRoutingSuccessLimit 0
Networkgenerationsuccesslimit NetworkGenerationSuccessLimit 0
Reservationsuccesslimit ReservationSuccessLimit 0
Routingsuccesslimit RoutingSuccessLimit 0

CS_BAG
Properties
Label Code Value
Version Version 0

CS_CCCROUTING
Properties
Label Code Value
Line0:0.9 Line0:0.9 0
Line1:1.9 Line1:1.9 0
Line2:2.9 Line2:2.9 0
Zoomcccrouting ZoomcccRouting 0

CS_CUSTEXCEPTIONS
Properties
Label Code Value
Somschroutageverplicht sOmschrOutageVerplicht 0

CS_CUSTEXCEPTIONSBOOLEAN
Properties
Label Code Value
Aannemer2sales aannemer2sales 0
Bmagrftszien bMagRFTSZien 0
Cablemanager_all cablemanager_all 0
Coconwebmapscentraal CoconWebmapsCentraal 0
Geen_email_postmdb_niet_open Geen_Email_Postmdb_niet_open 0
Isgetservicecontract IsGetServiceContract 0
Isgetservicepriolijnbenaming IsGetServicePrioLijnbenaming 0
Label_tabap Label_Tabap 0
Overlapservicewindows OVERLAPSERVICEWINDOWS 0

CS_CUSTEXEPTIONS
Properties
Label Code Value
Postcodehuisnummerbestand PostcodeHuisnummerBestand 0

CS_CUSTEXEPTIONSBOOLEAN
Properties
Label Code Value
Redirectpath RedirectPath 0

CS_FIXEDLENGTHNUMERIC
Properties
Label Code Value
Pps PPS 0
Rass RASS 0

CS_FTTHIMPORT
Properties
Label Code Value
Ignorefibersnotterminated IgnoreFibersNotTerminated 0
Loosefiberprojects LooseFiberProjects 0
Nonslackftutype NonSlackFTUType 0
Pass cable types PASS cable types 0
Slackftutype SlackFTUType 0

CS_GLOBVAR
Properties
Label Code Value
Adresstring AdresString 0
Adresveldenbedrijfbestand AdresveldenBedrijfbestand 0
Afsluitenprojectprojectdbcontroles AfsluitenProjectProjectDBControles 0
Autosetresdate AutoSetResDate 0
Autstatususer autstatususer 0
Availableframeneededforconnect AvailableFrameNeededForConnect 0
Baccesspointtoevoegen bAccesspointToevoegen 0
Backgroundlokaalverplicht BackGroundLokaalVerplicht 0
Bafstandbepalenalleennaartabconused bAfstandBepalenAlleenNaarTabconUsed 0
Balternatelanguage bAlternateLanguage 0
Bautonosplicetoegestaan bAutoNoSpliceToegestaan 0
Bautotrajectnaam bAutoTrajectNaam 0
Bbequipmentlimitinkm BBEquipmentLimitInKM 0
Bboringexternookoranje bBoringExternOokOranje 0
Bbuisnummeruniek bBuisnummerUniek 0
Bcablepackcablesinvisible bCablePackCablesInvisible 0
Bcombineenclosurecomments bCombineEnclosureComments 0
Bctw_livesync_enabled bCTW_LIVESYNC_ENABLED 0
Bduitseftthstraat bDuitseFtthStraat 0
Bextrasectievelden bExtraSectieVelden 0
Bfilteropglasmogelijk bFilterOpGlasMogelijk 0
Bftthoperator bFTTHOperator 0
Bimskoppeling bIMSkoppeling 0
Bkabelsoplasschets bKabelsOpLasschets 0
Bkabelwerkdetailstatus bKabelWerkDetailStatus 0
Bklantdefaulserver bKlantDefaulServer 0
Bloskoppelenobjectentoegestaaninkabelwerk bLoskoppelenObjectenToegestaanInKabelwerk 0
Bmagkabelwerkeninvoerenopbasisvanexcel bMagKabelwerkenInvoerenOpbasisVanExcel 0
Bmagopenbaarregister bMagOpenbaarRegister 0
Bmireadonly bMIReadOnly 0
Bmireadonlyfileslocal bMIReadOnlyFilesLocal 0
Borgen_redundancy Borgen_Redundancy 0
Botdrviewer bOTDRviewer 0
Bpackprojectdocuments bPackProjectDocuments 0
Bplannedworksvrijenaamkeuze bPlannedWorksVrijeNaamkeuze 0
Bpostcodeverplicht bPostcodeVerplicht 0
Bsendagendaitem bSendAgendaItem 0
Bshowbaanvak bShowBaanvak 0
Btoonpoort bToonPoort 0
Buildingaddressconnected BuildingAddressConnected 0
Buildinggeoconnected BuildingGeoConnected 0
Buildingtabcondirectconnected BuildingTabconDirectConnected 0
Buildingtabcongeoconnected BuildingTabconGeoConnected 0
Builprogressinplanon BuilProgressInPlanon 0
Busebuildingalias bUseBuildingAlias 0
Busetellertable bUseTellerTable 0
Bverwdocsbijaanbieden bVerwDocsBijAanbieden 0
Bvulgatenop bVulGatenOp 0
Bwdminoutages bWDMinOutages 0
Cablepackversion CablePackVersion 0
Closecocononerror CloseCoconOnError 0
Coordsys2 CoordSys2 0
Coordsysnumber CoordSysNumber 0
Coordsysnummer2 CoordSysNummer2 0
Ctw2environment CTW2ENVIRONMENT 0
Customercode CustomerCode 0
Cyclomedia Cyclomedia 0
Defaultlanguage DefaultLanguage 0
Defaultspanowner DefaultSpanOwner 0
Detailstatus_no_mark Detailstatus_no_mark 0
Ductowners DuctOwners 0
Ductspliceinuse DUCTSPLICEInUse 0
Email_borgen_redundancy Email_Borgen_Redundancy 0
Excludeprojectdc ExcludeProjectDC 0
Excludeprojects ExcludeProjects 0
Extrahhdistanceinm ExtraHHDistanceInM 0
Foreignownerupdates ForeignOwnerUpdates 0
Gemiddeldelengtespoorboring GemiddeldeLengteSpoorboring 0
Getfilemd5hashcode GetFileMD5HashCode 0
Googlemapsurl GoogleMapsUrl 0
Hoogteeenheidvanaf1 HoogteEenheidVanaf1 0
Incitrixservers InCitrixServers 0
Iscoconthewebomgeving IsCoconTheWebOmgeving 0
Kabelbezetting_check kabelbezetting_check 0
Keepdetailstatus KeepDetailstatus 0
Klicview KlicView 0
Koplaskabelwerk KoplasKabelwerk 0
Laanmeldaccountsurenoud lAanmeldAccountsUrenOud 0
Leeftijdbestandenextleveranciers LeeftijdBestandenExtLeveranciers 0
Lijnbenamingcontractrelatieverplicht LijnbenamingContractRelatieVerplicht 0
Lijnbenaminginklantcontract LijnbenamingInKlantcontract 0
Lmaxrecords lMaxRecords 0
Lmaxzoomkmvoorimportcad lMaxZoomKmVoorImportCad 0
Lmaxzoomvooropenenbgt lMaxZoomVoorOpenenBGT 0
Lmaxzoomvoorwijzigen lMaxZoomVoorWijzigen 0
Lngfindnearest LngFindNearest 0
Locationtype1serviceneed LocationType1ServiceNeed 0
Locationtype2serviceneed LocationType2ServiceNeed 0
Maaksectieinneis MaakSectieInNeis 0
Maaksectieinneishost MaakSectieInNeisHost 0
Maaksectieinneispassword MaakSectieInNeisPassword 0
Maaksectieinneisusername MaakSectieInNeisUsername 0
Mailkeyuser MailKeyUser 0
Mailnaaansluitingen MailNaAansluitingen 0
Mapdelaytime MapDelayTime 0
Max_list_results MAX_LIST_RESULTS 0
Maxkabellengte MaxKabelLengte 0
Maxlocaltaillength MaxLocalTailLength 0
Maxstraightblowlengthinm MaxStraightBlowLengthInM 0
Merkbandafstand merkbandafstand 0
Minlengtewaterboring MinLengteWaterboring 0
Miroutingtabusers MIRoutingTabUsers 0
Mnuoverzichtkastindelingnew mnuOverzichtKastindelingNew 0
Naamaanb NaamAanb 0
Negeerlengteinvoerkabelinbuis NegeerLengteInvoerKabelInBuis 0
Nieuwekastindeling NieuweKastindeling 0
Nmagcocon11starten nMagCocon11Starten 0
Openfileblocked OpenFileBlocked 0
Overview_tablename Overview_tablename 0
Percextralengtewaterboring PercExtraLengteWaterboring 0
Pps_available_sales pps_available_sales 0
Prefixlengthftpmap PreFixLengthFTPMap 0
Projectdocstatusvoorafsluit ProjectDocStatusVoorAfsluit 0
Refreshgebouwennietdirect RefreshGebouwenNietDirect 0
Registreerklantbijgebouw registreerklantbijgebouw 0
Repairtoolmd5locatie Repairtoolmd5locatie 0
Routetabelincltoekomstig RouteTabelInclToekomstig 0
Routingaptypes RoutingAPTypes 0
Routinglocationtype1 RoutingLocationType1 0
Routinglocationtype2 RoutingLocationType2 0
Routingownerchangetypes RoutingOwnerChangeTypes 0
Routingpatchtypes RoutingPatchTypes 0
Schangedatewhilcopyfile sChangeDateWhilCopyFile 0
Schouwonly SchouwOnly 0
Semaildomeinnaam sEmailDomeinnaam 0
Sendagendaitemexternal SendAgendaItemExternal 0
Sendagendaitemexternallog SendAgendaItemExternalLOG 0
Snameforcontractor sNameForContractor 0
Specialeboringen SpecialeBoringen 0
Srid SRID 0
Stabborlabel sTabborLabel 0
Svezelstatusniettoegestaanbylijnbenaming sVezelStatusNietToegestaanByLijnbenaming 0
Syncenclosurepoorten SyncEnclosurePoorten 0
Tabconsharecontents TabconShareContents 0
Tubenroplasschets TubenrOpLasschets 0
Useofsms UseOfSMS 0
Validateopheffingslas ValidateOpheffingsLas 0
Verstuurmail_wijzig_vezelstatus VerstuurMail_wijzig_vezelstatus 0
Visualstyles VisualStyles 0
Vmapthemes vMapThemes 0
Workonfielduploadsfolder WorkOnFieldUploadsFolder 0
Workonplannerinfo WorkOnPlannerInfo 0
Zoom_lvl_overview ZOOM_LVL_OVERVIEW 0

CS_INVOERENPUNT
Properties
Label Code Value
Buiseinde buiseinde 0
Buiseinde+marker buiseinde+marker 0
Buiskoppeling buiskoppeling 0
Buiskoppeling+marker buiskoppeling+marker 0
Handhole handhole 0
Handhole+marker handhole+marker 0
Km2 km2 0
Km2+marker km2+marker 0

CS_LOCALIZEDSLACK
Properties
Label Code Value
Lgnb LGNB 0

CS_NONSLACKFRAMES
Properties
Label Code Value
Ande ANDE 0
Kldr KLDR 0
Mtk MTK 0
Onb ONB 0
Wnk WNK 0

CS_PROTECTIONENVIRONMENT
Properties
Label Code Value
Eurofiber belgie Eurofiber Belgie 0

CS_RESERVEERTRAJECT
Properties
Label Code Value
Chkhemelsbreed chkHemelsbreed 0
Chkkabelsverplicht chkKabelsVerplicht 0
Chknohhcreation chkNoHHCreation 0
Chkviabuffer chkViaBuffer 0
Chkwaterenspoor chkWaterEnSpoor 0
Chkzoomselectie chkZoomSelectie 0
Txtbuffertol txtBufferTol 0
Txttolerantie txtTolerantie 0

CS_ROUTING
Properties
Label Code Value
Excludedconnectionstati ExcludedConnectionStati 0
Fiberdatadumpstart FiberDataDumpStart 0
Firstfiberdatachange FirstFiberDataChange 0
Getaddressdata GetAddressData 0
Prios Prios 0
Tentaclebuffer TentacleBuffer 0
Tentacledistance TentacleDistance 0
Tentaclelength TentacleLength 0

CS_SLACKFRAMES
Properties
Label Code Value
Blak BLAK 0
Eg EG 0
Gl GL 0
Gv GV 0
Idp IDP 0
Ievp IEVP 0
Pass PASS 0
Smk SMK 0
Swon SWON 0

CS_ZOOMLAYERMAX
Properties
Label Code Value
Filegbkngrid FileGBKNGrid 0
Hoofdlocaties HOOFDLOCATIES 0
Hoofdlocatieslabels HOOFDLOCATIESLabels 0
Sublocaties Sublocaties 0
Sublocatieslabels SublocatiesLabels 0

CS_ZOOMLAYERMIN
Properties
Label Code Value
Filegbkngrid FileGBKNGrid 0
Hoofdlocaties HOOFDLOCATIES 0
Hoofdlocatieslabels HOOFDLOCATIESLabels 0
Sublocaties Sublocaties 0
Sublocatieslabels SublocatiesLabels 0

CULTURE
Properties
Label Code Value
German de-DE 0
English en-US 0
Dutch nl-NL 0

DAYS
Properties
Label Code Value
Day before yesterday 20
Yesterday 21
Today 22
Tomorrow 23
Day after tomorrow 24

EVENTTYPE
Properties
Label Code Value
Various 0
Distancecalculator 1
Erroremail 2
Coconbatch 3
Coconimport 4
Routingcachebuild 5
Fiberroutingcachebuild 6
Routingdatabuild 7
Fiberroutingdatabuild 8
Calculateproject 9
Uploadasbuilts 10
Softwareinstalled 11
Backupandftp 12
Login 13
Webservice call 14
Cocon abruptly terminated 15

EXISTS
Properties
Label Code Value
None 0
Exists 1
Not exists 2

FIBERS_USED
Properties
Label Code Value
All 0
Fiber 1 1
Fiber 2 2

FINANCECODEKIND
Properties
Label Code Value
Monthly amount codes MonthlyAmountCodes 0
Once only amount codes OnceOnlyAmountCodes 0
Redemption codes RedemptionCodes 0

FLD_TYPE
Properties
Label Code Value
Geometry GEO 0
Alphanumeric AN 0
Blob BLOB 0
Date D 0
Numeric decimal DN 0
Datetime DT 0
Memo M 0
Numeric non-decimal N 0

FTTO_STATUS
Properties
Label Code Value
Green groen 0
Orange oranje 0
Red rood 0

GEOTYPE
Properties
Label Code Value
Collection 0
Point 1
Polyline 2
Polygon 3
Multi point 4
Multi polyline 5
Multi polygon 6

GEO_TYPE
Properties
Label Code Value
Node 1
Polyline 2
Polygon 3
Arc 4
Ellipse 5
Rectangle 6
Marker 7
Line 8

GOODWRONG
Properties
Label Code Value
Wrong 0
Good 1

ICONSIZE
Properties
Label Code Value
Small 16
Medium 24
Big 32

IMPORT_EXISTS
Properties
Label Code Value
Raise error 0
Overwrite 1
Skip 2

JANEE
Properties
Label Code Value
No n 0
Yes j 0

JANEE_SPACE_LOWER
Properties
Label Code Value
0
Yes j 0
No n 0

JANEE_SPACE_UPPER
Properties
Label Code Value
0
Yes J 0
No N 0

JANEE_UPPER
Properties
Label Code Value
No N 0
Yes J 0

KASTZIJDE
Properties
Label Code Value
Back B 0
Front F 0

LANGUAGE
Properties
Label Code Value
German deu 0
English eng 0
Dutch nld 0

LOCATIETYPE
Properties
Label Code Value
Enclosure enclosure 0
Frame frame 0
Slack slack 0

MD_ALIGNMENT
Properties
Label Code Value
List and properties left aligned 0
List and properties right aligned 1

MEDIUM
Properties
Label Code Value
Email E 0
Fax F 0
Mail M 0
Phone P 0

NETWORK_CONCEPT
Properties
Label Code Value
Single fiber 1V 0
Two fiber 2V 0

NORECORDSACTION
Properties
Label Code Value
Show title and texts 0
Show nothing 1

ODF_PORT_STATE
Properties
Label Code Value
Reserved 0
In use 1
To be removed 2
Free 3
Defect 4

OFFICE_VERSION
Properties
Label Code Value
Current 0
Office 97_2003 1
Office 2007 2

OPERAND_TYPE
Properties
Label Code Value
Field 0
Script 1
Literal 2
Local script 3
Select statement 4
Local value 5
Value 6

ORDER
Properties
Label Code Value
Ascending 0
Descending 1

ORIENTATION
Properties
Label Code Value
Horizontal 0
Vertical 1

OUTAGESTATUS
Properties
Label Code Value
Engineer present 0
Work started 1
Active (connection) 2
Engineer done 3
Work delayed 4
Work ready 5

OUTPUTMODES
Properties
Label Code Value
Ms excel EXCEL 0
Html HTML 0
Ms word WORD 0

OWNER
Properties
Label Code Value
Access access 0
Core core 0
Unknown unknown 0

PARSEMOMENT
Properties
Label Code Value
Before record 0
After record 1
After helper queries 2
After sub queries 3

PATCHORDER_CANCELCODE
Properties
Label Code Value
Op tijd geannuleerd, geen werk gedaan 500
Nt reeds geplaatst 501
Vezels geblazen of graafwerkzaamheden uitgevoerd 502
Aannemer heeft cancel gezien 599

PATCHORDER_CLOSECODE
Properties
Label Code Value
Oplevering is succesvol geweest 0

PATCHORDER_CLOSECODE_OBS
Properties
Label Code Value
Nt wel geplaatst, geen licht door vezel 50
Nt wel geplaatst, wel licht, geen opleversignaal 51
Oplevering niet succesvol, zie text voor reden 100

PATCHORDER_DENYCODE
Properties
Label Code Value
Geen klant contact - kib/brief 101
Klant niet thuis op afspraakdatum 102
Klant wil diensten niet 103
Wacht op klant nieuwbouw/verbouw woning 104
Wacht op klant - vakantie 105
Wacht op klant - overige 106
Onaangekondigd bezoek - klant niet thuis (kib) 107
Geen klant contact - na 2 belpogingen en sms 108
Toestemming - geen toestemming vve 201
Toestemming - geen toestemming gemeente 202
Vergunningsverzoek afgewezen 203
Technisch beletsel - hoogbouw/onderburen 204
Technisch beletsel - overige 205
Offerte (hoogbouw/meerwerk) 206
Tracé onvindbaar 207
Pop / (i)dp niet toegankelijk 208
Geen cocongegevens 209
Vrijsch. gevraagd - klant niet tijdelijk in dienst 210
Vrijsch. gevraagd - klant wel tijdelijk in dienst 211
Offerte (meerwerk assurance) 212
Offerte niet mogelijk 250
Nadere informatie nodig 251
Actief poort niet gevonden - poort bestaat niet 301
Odf poort niet gevonden - odf poort bestaat niet 302
Actief poort reeds in gebruik (bezet) 303
Odf poort reeds in gebruik (bezet) 304
Actieve poort defect (zichtbaar defect) 305
Odf poort defect (zichtbaar defect) 306
Geen licht (vanaf klant) gemeten in odf lade 307
Administratief beletsel 401
Klant niet bereikbaar voor maken afspraak (kib) 402
Geen nt voorraad van ao ontvangen 410
In opdracht van ao gecancelled 411
In opdracht van beheerder gecancelled 412
Dubbele order 413
Dubbel incidentticket 414
Opdracht is dubbel 601
Buiten het werkgebied 602
Order incorrect 603
Er bestaat al een order op het adres 604
Odf port state is 'defect' 901
Odf port state is not 'free' 902
Odf port state is not 'in use' 903
Status adres is leeg of groter gelijk aan 90 904
Overig uitstel/afstel 951
Beletsel door natuurinvloeden (bijvoorbeeld vorst) 952

PATCHORDER_HOLDCODE
Properties
Label Code Value
Geen klant contact - kib/brief 101
Klant niet thuis op afspraakdatum 102
Klant wil diensten niet 103
Wacht op klant nieuwbouw/verbouw woning 104
Wacht op klant - vakantie 105
Wacht op klant - overige 106
Onaangekondigd bezoek - klant niet thuis (kib) 107
Geen klant contact - na 2 belpogingen en sms 108
Toestemming - nog geen toestemming vve 201
Toestemming - nog geen toestemming gemeente 202
Vergunningsverzoek afgewezen 203
Technisch beletsel - hoogbouw/onderburen 204
Technisch beletsel - overige 205
Hoogbouw (offerte) 206
Tracé onvindbaar 207
Pop / (i)dp niet toegankelijk 208
Geen cocongegevens 209
Vrijsch. gevraagd - klant niet tijdelijk in dienst 210
Vrijsch. gevraagd - klant wel tijdelijk in dienst 211
Offerte (meerwerk assurance) 212
Offerte niet mogelijk 250
Nadere informatie nodig 251
Actief poort niet gevonden - poort bestaat niet 301
Odf poort niet gevonden - odf poort bestaat niet 302
Actief poort reeds in gebruik (bezet) 303
Odf poort reeds in gebruik (bezet) 304
Actieve poort defect (zichtbaar defect) 305
Odf poort defect (zichtbaar defect) 306
Geen licht (vanaf klant) gemeten in odf lade 307
Administratief beletsel 401
Contactgegevens onjuist/ontbreken (kib) 402
Geen nt voorraad van ao ontvangen 410
In opdracht van ao gecancelled 411
In opdracht van ao op hold gezet 412
Dubbele order 413
Dubbel incidentticket 414
Overig afstel 901
Beletsel door natuurinvloeden (bijvoorbeeld vorst) 902

PATCHORDER_KIND
Properties
Label Code Value
Last executed 0
Planned 1
Followed 2
N.a. 3

PATCHORDER_RESUMECODE
Properties
Label Code Value
Overige 799

PATCHORDER_STATUS
Properties
Label Code Value
Received 0
Confirmed 1
Delivered 3
Denied 4
Replan received 5
Cancel received 6
Cancelled 7
Replanned 8
On-hold 9

PATCHORDER_STATUS_QQQ
Properties
Label Code Value
Provided 2

PATCHORDER_TYPE
Properties
Label Code Value
Install I 0
Migrate M 0
Pre P 0
Remove R 0

PERIODS
Properties
Label Code Value
Days 1
Weeks 2
Months 3
Quarters 4
Years 5

PLACE_DESCRIPTION
Properties
Label Code Value
Accesspoint access 0
Building building 0

PORT_MARK
Properties
Label Code Value
No nee 0
Gel seal ja 0
Gel seal r4 r4 0
Gel seal r8 r8 0

PPS_ORDER_TYPE
Properties
Label Code Value
Cancel planned de-patch CD 0
Cancel planned patch CP 0
De-patch D 0
Patch P 0
Planned de-patch PD 0
Planned patch PP 0

PROJECTSOORT
Properties
Label Code Value
New build 4 0
Maintenance 5 0
Failure 6 0
Bid 7 0
Splicing only 8 0
Ftth design 9 0

PROJECTSTATUS
Properties
Label Code Value
0
Import 0 0
In maintenance 1 0
Check 2 0
In build 3 0
Design 5 0

RECORDNODE_TYPE
Properties
Label Code Value
Record 0
Child record 1
Folder 2
Relation folder 3

REPORTEXPORTFORMAT
Properties
Label Code Value
Csv (*.csv) csv 0
Web page (*.html) html 0
Jpeg (*.jpg) jpg 0
Pdf (*.pdf) pdf 0
Excel workbook (*.xlsx) xlsx 0

ROUTETYPE
Properties
Label Code Value
Copper copper 0
Fiber fiber 0

SPLICETRAY_SIDE
Properties
Label Code Value
N.a. 0
A A 0
B B 0

SPLICETYPE
Properties
Label Code Value
No splice no-splice 0
Splice splice 0
Splitter splitter 0

STATI_TYPE
Properties
Label Code Value
Accesspoint type accesspoint 0
Adresgebied adresgebied 0
Algemeen algemeen 0
Algemeennw algemeennw 0
Bandbreedte bandbreedte 0
Buisdiameter buisdiameter 0
Buiskleur buiskleur 0
Buisopmerking buisopmerking 0
Chromaticdispersion chromaticdispersion 0
Connectortype connectortype 0
Detailstatus detailstatus 0
Dienst dienst 0
Document document 0
Enclosure enclosure 0
Gbknonline GbknOnline 0
Building type gebouwtype 0
Graafkosten graafkosten 0
Incident incident 0
Installatiebedrijf installatiebedrijf 0
Kabelcategorien kabelcategorien 0
Kabeltype kabeltype 0
Kabelwerk kabelwerk 0
Kleur kleur 0
Label label 0
Las las 0
Lascassette lascassette 0
Leasecontractstatus leasecontractstatus 0
Objecttype objecttype 0
Olo olo 0
Openbaarregister openbaarregister 0
Owner owner 0
Patchcordtype patchcordtype 0
Priokabelbezetting priokabelbezetting 0
Product product 0
Projectsrt projectsrt 0
Question question 0
Raamcontract raamcontract 0
Ringbestemming ringbestemming 0
Ringkleur ringkleur 0
Ringstatus ringstatus 0
Servertype servertype 0
Serviceprio serviceprio 0
Soortblokkering soortblokkering 0
Soortboring soortboring 0
Soortkabelwerk soortkabelwerk 0
Frame type soortkast 0
Soortklant soortklant 0
Soortonderbreking soortonderbreking 0
Soorttraject soorttraject 0
Subductdiameter subductdiameter 0
Subductitem subductitem 0
Subductkleur subductkleur 0
Subductsysteem subductsysteem 0
Typeleaselines typeleaselines 0
Vergunning vergunning 0
Vertalen vertalen 0
Vezellasdemping vezellasdemping 0
Vezelstat vezelstat 0
Vezeltype vezeltype 0
Workonfielddoc WorkOnFieldDoc 0

TREEITEM_TYPE
Properties
Label Code Value
Detail items 1
Main items 2
Items 3
Folders 4

TRUEFALSE
Properties
Label Code Value
True -1
False 0

UISETTING_TYPE
Properties
Label Code Value
List setting 1
Group by setting 2
Import profile 3

UPGRADEALERTSTATUS
Properties
Label Code Value
0
Send 0 0
In operation 1 0
Processed 2 0

WEBSERVICEPHASE
Properties
Label Code Value
Request 0
Routing done 1
Answer send 2
Failed to send 3

WINDOWSTYLE
Properties
Label Code Value
Normal 0
Minimized 2
Maximized 3

WORKONACTIE
Properties
Label Code Value
Acknowledge bevestig 0
Insert insert 0
Update update 0
Edit wijzig 0

WORKONACTIESTATUS
Properties
Label Code Value
Not authorized to process A 0
Error while processing F 0
Processed manually H 0
Entered I 0
Not processed N 0
Already processed R 0
Processed V 0
Processed with warning W 0

WORKONFIELDACTION
Properties
Label Code Value
Remove 1
Windowcut 2
Set in service 3
Change cable 4
Change enclosure 5

WORKONOBJECTTYPE
Properties
Label Code Value
Accesspoint accesspoint 0
Building building 0
Cable cable 0
Cable part cableo 0
Drilling drilling 0
Duct duct 0
Ductbank ductbank 0
Enclosure enclosure 0
Frame frame 0
Patch patch 0
Patchpanel patchpanel 0
Patchpoint patchpoint 0
Patchposition patchpos 0
Splicepanel splicepanel 0
Splicepoint splicepoint 0
Section traject 0
Window cut windowcut 0

XREPORTEXPORTFORMAT
Properties
Label Code Value
Bmp (*.bmp) bmp 0
Csv (comma delimited) (*.csv) csv 0
Gif (*.gif) gif 0
Open document spreadsheet (*.ods) ods 0
Portable network graphics (*.png) png 0
Tiff (*.tiff) tiff 0
Windows media photo (*.wmp) wmp 0
Excel 97-2003 workbook (*.xls) xls 0
Xps document (*.xps) xps 0

YESNO
Properties
Label Code Value
No 0
Yes 1

YESNONA
Properties
Label Code Value
No 0
Yes 1
N/a 2

YESNO_UPPER
Properties
Label Code Value
No N 0
Yes Y 0

ZIPCODE_REGION
Properties
Label Code Value
Belgium BELG 0
Belgium old BELG_OLD 0
Germany DEUT 0
Spain ESPA 0
France FRAN 0
Ireland IREL 0
Netherlands NETH 0
Utm UTM 0
Zone 2 germany ZONE2DEUT 0
Zone 3 germany ZONE3DEUT 0
Zone 4 germany ZONE4DEUT 0