Data Center

Data Center >>
Field Values for PIPELINE HISTORIES

Field Values for PIPELINE HISTORIES

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Segment Num SEGMENT_NUMBERS Number Range Between 0000000 and 9999999
History Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
History Code HISTORY_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A- AS-BUILT APPROVED.
  • B- ABANDONED/PROPOSED ABANDONMENT.
  • C- COMBINED WITH OTHER PIPE TO CREATE A NEW SEGMENT.
  • D- DEPARTURE APPROVED.
  • E- MISCELLANEOUS.
  • F- FLOW DIRECTION CHANGE.
  • H- HYDRO-STATIC TEST DATE.
  • I- DATE OF FIRST OIL FLOW (ALASKA REGION).
  • L- FLUSH/FILL DATE.
  • M- MAOP CHANGE.
  • O- OUT-OF-SERVICE DATE.
  • P- PIPE ADDED OR NEW SEGMENT CREATED.
  • R- REPAIR MADE.
  • S- CHANGE IN SERVICE.
  • T- TEMPORARY CESSATION OF OPERATIONS DATE.
  • U- DATE LINE PLACED IN-SERVICE OR RETURNED TO SERVICE.
Last Rev Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10