Column Alias Name
Position |
Domain Name
Length |
Domain Type
Alias |
Valid Value Description |
| Application Received Date |
GENERAL_DATES |
Date Range |
Between 01-JAN-1947 and SYSDATE+10 |
| Mms Company Num |
MMS_COMPANY_NUMS |
Number Range |
Between 00001 and 99999 |
| Temporary Structure Flag |
FLAG |
Character |
The Value-Description Pairs are listed below:
|
| Platform Expiration Date |
PLTFRM_EXPIR_DTS |
Date Range |
Between 01-JAN-1947 and SYSDATE+1200 |
| Area Code |
0059 |
Character |
The Value-Description Pairs are listed below:
- AB- NG 15-8 60.
- AC- MINOS CANYON 60.
- AM- AMERY TERRACE.
- AP- APALACHICOLA 60.
- AT- ATWATER * 60.
- BA- BRAZOS AREA 42.
- BM- BAY MARCHAND AREA 17.
- BS- BRETON SOUND AREA 17.
- CA- CHANDELEUR AREA 17.
- CC- CORPUS CHRISTI 60.
- CE- CAMPECHE ESCARPMENT.
- CH- CHARLOTTE HARBOR 60.
- CP- COON POINT (THIS IS A FIELD) 17.
- CS- CHANDELEUR SOUND 17.
- DC- DESOTO CANYON 60.
- DD- DESTIN DOME 60.
- DT- DRY TORTUGAS 60.
- EB- EAST BREAKS 60.
- EC- EAST CAMERON AREA 17.
- EI- EUGENE ISLAND AREA 17.
- EL- THE ELBOW 60.
- EW- EWING BANK 60.
- FM- FLORIDA MIDDLE GROUND 60.
- FP- FLORIDA PLAIN.
- GA- GALVESTON AREA 42.
- GB- GARDEN BANKS 60.
- GC- GREEN CANYON 60.
- GI- GRAND ISLE AREA 17.
- GV- GAINESVILLE 60.
- HC- HUDSON CANYON.
- HE- HENDERSON 60.
- HH- HOWELL HOOK 60.
- HI- HIGH ISLAND AREA 42.
- KC- KEATHLEY CANYON 60.
- KW- KEY WEST 60.
- LL- LLOYD 60.
- LP- LIGHTHOUSE POINT (THIS IS A FIELD) 17.
- LS- LUND SOUTH.
- LU- LUND * 60.
- MA- MIAMI 60.
- MC- MISSISSIPPI CANYON 60.
- MI- MATAGORDA ISLAND AREA 42.
- MO- MOBILE 60.
- MP- MAIN PASS AREA 17.
- MQ- MARQESAS 09.
- MU- MUSTANG ISLAND AREA 42.
- PB- ST PETERSBURG 60.
- PE- PENSACOLA 60.
- PI- PORT ISABEL 60.
- PL- SOUTH PELTO AREA 17.
- PN- NORTH PADRE ISLAND AREA 42.
- PR- PULLEY RIDGE 60.
- PS- SOUTH PADRE ISLAND AREA 42.
- RK- RANKIN 60.
- SA- SABINE PASS (LOUISIANA) 17.
- SM- SOUTH MARSH ISLAND AREA 17.
- SP- SOUTH PASS AREA 17.
- SS- SHIP SHOAL AREA 17.
- ST- SOUTH TIMBALIER AREA 17.
- SX- SABINE PASS (TEXAS) 42.
- TP- TARPON SPRINGS 60.
- TS- TIGER SHOAL (THIS IS A FIELD) 17.
- TV- TORTUGAS VALLEY.
- VK- VIOSCA KNOLL 60.
- VN- VERNON * 60.
- VR- VERMILION AREA 17.
- WC- WEST CAMERON AREA 17.
- WD- WEST DELTA AREA 17.
- WR- WALKER RIDGE 60.
|
| Surface N/S Distance |
N_S_E_W_DISTS |
Number Range |
Between 0 and 32000 |
| Surface N/S Code |
N_S_CODES |
Character |
The Value-Description Pairs are listed below:
- N- NORTH BLOCK LINE.
- S- SOUTH BLOCK LINE.
|
| Surface E/W Distance |
N_S_E_W_DISTS |
Number Range |
Between 0 and 32000 |
| Surface E/W Code |
E_W_CODES |
Character |
The Value-Description Pairs are listed below:
- E- EAST BLOCK LINE.
- W- WEST BLOCK LINE.
|
| Water Depth |
WATER_DEPTHS |
Number Range |
Between 0 and 13000 |
| Platform Approved Date |
GENERAL_DATES |
Date Range |
Between 01-JAN-1947 and SYSDATE+10 |
| PVP Flag |
FLAG |
Character |
The Value-Description Pairs are listed below:
|
