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 |
