Factpages Norwegian petroleum directorate
NPD          Norsk

TRANSPORTATION AND UTILIZATION FACILITIES (TUF) – attribute description

Export: 
  • Main level

    Main level
    Heading
    Description
    Tag
    Data type
    NPDID for TUF
    NPD's unique id for transportation and utilisation facilities
    tufNpdidTuf
    int
    TUF name
    Name of the transportation and utilisation facility
    tufName
    varchar(40)
    Kind
    Kind of transportation and utilisation facility. Legal values: ONSHORE PLANT, PIPELINE, TERMINAL
    tufKind
    varchar(80)
    Status
    Status of the transportation and utilisation facility. Legal values: ACTIVE, INACTIVE
    tufStatus
    varchar(40)
    Valid from date
    Date the transportation and utilisation facility is valid from
    tufDateValidFrom
    datetime
    Valid to date
    Date the transportation and utilisation facility is valid to
    tufDateValidTo
    datetime
    From facility
    From facility
    tufStartPoint
    varchar(40)
    To facility
    To facility
    tufEndPoint
    varchar(40)
  • Sub level – Operator

    Sub level – Operator
    Heading
    Description
    Tag
    Data type
    NPDID TUF
    NPD's unique id for transportation and utilisation facilities
    tufNpdidTuf
    int
    NPDID operator company
    NPD's unique id for operator company
    cmpNpdidCompany
    int
    Kind
    Kind of transportation and utilisation facility. Legal values: ONSHORE PLANT, PIPELINE, TERMINAL
    tufKind
    varchar(80)
    TUF
    Name of the transportation and utilisation facility
    tufName
    varchar(40)
    Date valid from
    The date the company's operatorship is valid from
    tufOperDateValidFrom
    datetime
    Date valid to
    The date the company's operatorship is valid to
    tufOperDateValidTo
    datetime
    Company fact page
    URL to the company's FactPage on NPD's FactWEB
    cmpFactPageUrl
    varchar(200)
    Operator company
    Operator company for this TUF
    cmpLongName
    varchar(100)
  • Sub level – Owners

    Sub level – Owners
    Heading
    Description
    Tag
    Data type
    NPDID for TUF
    NPD's unique id for transportation and utilisation facilities
    tufNpdidTuf
    int
    NPDID owner company
    NPD's unique id for companies
    cmpNpdidCompany
    int
    Kind
    Kind of transportation and utilisation facility. Legal values: ONSHORE PLANT, PIPELINE, TERMINAL
    tufKind
    varchar(80)
    TUF
    Name of the transportation and utilisation facility
    tufName
    varchar(40)
    Date valid from
    The date the company's ownership is valid from
    tufOwnerDateValidFrom
    datetime
    Date valid to
    The date the company's ownership is valid to
    tufOwnerDateValidTo
    datetime
    Owner company
    Owner company for this TUF
    cmpLongName
    varchar(100)
    Share [%]
    The company's share in percent.
    tufOwnerShare
    decimal
    Company fact page
    URL to the company's FactPage on NPD's FactWEB
    cmpFactPageUrl
    varchar(200)
  • Sub level – Petroleum register , Main level (in Norwegian only)

    Sub level – Petroleum register , Main level (in Norwegian only)
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for TUF
    ODs entydige nøkkel for transport og utnyttelsesanlegg
    tufNpdidTuf
    int
    Gyldig fra dato
    Dato tillatelsen er gyldig fra.
    ptlDateValidFrom
    datetime
    Gyldig til dato
    Dato tillatelsen er gyldig til.
    ptlDateValidTo
    datetime
    Dato for tildeling
    Dato tillatelsen ble tildelt av norske myndigheter.
    ptlDateAwarded
    datetime
    Dato hovednivå oppdatert
    Dato for når informasjon om denne Petroleumsregister tillatelsen ble oppdatert sist eller lagt inn for første gang. Datoen vil bare bli forandret dersom data i 'Hovednivå' blir forandret.
    ptlDateUpdated
    datetime
    Dato alle oppdatert
    Dato når noe informasjon om denne Petroleumsregister tillatelsen ble oppdatert sist eller lagt inn for første gang. Datoen vil også bli forandret dersom data i noen av 'Undernivåene' blir forandret.
    ptlDateUpdatedMax
    datetime
  • Sub level – Petroleum register , Licencees (in Norwegian only)

    Sub level – Petroleum register , Licencees (in Norwegian only)
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for TUF
    ODs entydige nøkkel for transport og utnyttelsesanlegg.
    tufNpdidTuf
    int
    NPDID for selskap
    ODs entydige nøkkel for selskap.
    cmpNpdidCompany
    int
    TUF
    Navn på transport og utnyttelsesanlegget.
    tufName
    varchar(40)
    Selskap
    Selskapets offisielle navn.
    cmpLongName
    varchar(100)
    Andel [%]
    Selskapets andel i prosent.
    ptlLicenseeInterest
    numeric
    Dato oppdatert
    Dato når denne posten ble oppdatert sist eller lagt inn for første gang.
    ptlLicenseeDateUpdated
    datetime
  • Sub level – Petroleum register , Operatorship (in Norwegian (only)

    Sub level – Petroleum register , Operatorship (in Norwegian (only)
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for TUF
    ODs entydige nøkkel for transport og utnyttelsesanlegg.
    tufNpdidTuf
    int
    NPDID for selskap
    ODs entydige nøkkel for selskap.
    cmpNpdidCompany
    int
    TUF
    Navn på transport og utnyttelsesanlegget.
    tufName
    varchar(40)
    Selskap
    Selskapets offisielle navn.
    cmpLongName
    varchar(100)
    Dato oppdatert
    Dato når denne posten ble oppdatert sist eller lagt inn for første gang.
    ptlOperDateUpdated
    datetime
  • Sub level – Petroleum register , Messages (in Norwegian only)

    Sub level – Petroleum register , Messages (in Norwegian only)
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for TUF
    ODs entydige nøkkel for transport og utnyttelsesanlegg.
    tufNpdidTuf
    int
    Utdrag av dokument
    Utdrag av dokumentet, orginal dokumentet er registert i OD
    ptlMessage
    varchar(2000)
    Merknad
    Merknad. Hvis ikke meldingen er konferert (kvalitetskontrollert) i OD, vil det stå 'Ikke konferert', ellers er dette feltet blankt.
    ptlMessageRemark
    varchar(14)
    Type
    Type dokument. Eksempel på lovlig verdier: Heftelse,Ny tillatelse, Endring i tillatelse,Sletting av heftelse, Andre meldinger.
    ptlMessageKindDesc
    varchar(2000)
    Registreringsdato
    Dato dokumentet er registret i Petroleumsregisteret.
    ptlMessageRegisteredDate
    datetime
    TUF
    Navn på transport og utnyttelsesanlegget.
    tufName
    varchar(40)
    Dato oppdatert
    Dato når denne posten ble oppdatert sist eller lagt inn for første gang.
    ptlMessageDateUpdated
    datetime
  • Sub level – Pipeline

    Sub level – Pipeline
    Heading
    Description
    Tag
    Data type
    Pipeline name
    NPD's official name of pipeline
    pplName
    varchar(200)
    NPDID pipeline
    NPD's unique id for pipelines
    pplNpdidPipeline
    int
    Map label
    Name used in the map
    pplMapLabel
    varchar(100)
    Belongs to
    Name of the TUF or Field the pipeline belongs to.
    pplBelongsToName
    varchar(50)
    Current operator
    Name of the company that is currently operator of the pipeline
    cmpLongName
    varchar(100)
    Current phase
    Current phase for the pipeline. Examples of legal values:FUTURE, REMOVED, IN SERVICE, INSTALLATION, DECOMMISSIONED, ABANDONED IN PLACE
    pplCurrentPhase
    varchar(40)
    Phase valid from
    Date from, current phase
    pplCurrentPhaseFromDate
    datetime
    From facility
    Name of facility where the pipeline starts
    fclNameFrom
    varchar(50)
    To facility
    Name of facility where the pipeline ends
    fclNameTo
    varchar(50)
    Main grouping
    Name of main grouping of pipeline. Example of legal values: Transportation, Feeder
    pplMainGroupingName
    varchar(100)
    Dimension [inch]
    Pipeline dimension in inches
    pplDimension
    real
    Max water depth [m]
    Maximum waterdepth [m]
    pplWaterDepth
    real
    Medium
    Medium transported in the pipeline.
    pplMedium
    varchar(40)
    NPDID belongs to
    NPD's unique id for the information carrier the pipeline belongs to
    pplNpdidBelongsTo
    int
    NPDID facility from
    NPD's unique id for the facility where the pipeline starts
    fclNpdidFacilityFrom
    int
    NPDID facility to
    NPD's unique id for the facility where the pipeline ends
    fclNpdidFacilityTo
    int
    NPDID operator
    NPD's unique id for the company operating the pipeline
    cmpNpdidCompany
    int
    Date updated
    Date when this record was updated last or inserted the first time.
    pplDateUpdated
    datetime
    Fact page
    URL to the pipeline on NPD factpages
    pplFactPageUrl
    varchar(200)
    Factmaps
    URL to the pipeline on NPD factmap
    pplFactMapUrl
    varchar(200)