Column Alias Name |
Domain Name |
Domain Type |
Valid Value Description |
Mms Company Num |
MMS_COMPANY_NUMS |
Number Range |
Between 00001 and 99999 |
Mms Start Date |
GENERAL_DATES |
Date Range |
Between 01-JAN-1947 and SYSDATE+10 |
Mms Term Date |
LSE_FUTURE_DT |
Date Range |
Between 01-JAN-1900 and SYSDATE+7300 |
Pac Region Code |
PAC_REGION_CODES |
Enumeration Range |
The Value-Description Pairs are listed below:
- P- Qualified in the Pacific Region.
|
Gom Region Code |
GOM_REGION_CODES |
Enumeration Range |
The Value-Description Pairs are listed below:
- G- Qualified in the Gulf of Mexico Region.
|
Alaska Rgn Code |
ALASKA_RGN_CODES |
Enumeration Range |
The Value-Description Pairs are listed below:
- Y- Qualified in the Alaska Region.
|
Atl Region Code |
ATL_REGION_CODES |
Enumeration Range |
The Value-Description Pairs are listed below:
- A- Qualified in the Atlantic Region..
|
Term Actn Eff Dt |
LSE_FUTURE_DT |
Date Range |
Between 01-JAN-1900 and SYSDATE+7300 |
Termination Code |
TERMINATION_CODES |
Enumeration Range |
The Value-Description Pairs are listed below:
- C- Change of Name.
- M- Merger.
- O- Other.
|
Postal St Code |
POSTAL_ST_CODES |
Enumeration Range |
The Value-Description Pairs are listed below:
- AK- Alaska.
- AL- Alabama.
- AR- Arkansas.
- AS- American Samoa.
- AZ- Arizona.
- CA- California.
- CO- Colorado.
- CT- Connecticut.
- DC- District of Columbia.
- DE- Delaware.
- FL- Florida.
- GA- Georgia.
- GU- Guam.
- HI- Hawaii.
- IA- Iowa.
- ID- Idaho.
- IL- Illinois.
- IN- Indiana.
- KS- Kansas.
- KY- Kentucky.
- LA- Louisiana.
- MA- Massachusetts.
- MD- Maryland.
- ME- Maine.
- MH- Marshall Islands.
- MI- Michigan.
- MN- Minnesota.
- MO- Missouri.
- MP- Northern Mariana Is.
- MS- Mississippi.
- MT- Montana.
- NC- North Carolina.
- ND- North Dakota.
- NE- Nebraska.
- NH- New Hampshire.
- NJ- New Jersey.
- NM- New Mexico.
- NV- Nevada.
- NY- New York.
- OH- Ohio.
- OK- Oklahoma.
- OR- Oregon.
- PA- Pennsylvania.
- PR- Puerto Rico.
- PW- Palau.
- RI- Rhode Island.
- SC- South Carolina.
- SD- South Dakota.
- TN- Tennessee.
- TX- Texas.
- UT- Utah.
- VA- Virginia.
- VI- Virgin Island.
- VT- Vermont.
- WA- Washington.
- WI- Wisconsin.
- WV- West Virginia.
- WY- Wyoming.
|