Get Directions
Plan A Trip
Map & Travel Store
Explore Maps
Get Directions
Learn & Play
Business Solutions

Search Maps.com

Channel Features
Travel Deals
Travel Alert Bulletin
Travel Tools
Business Traveler Guide
Student Traveler Guide
Map & Travel Store

Free Newsletter
Get travel news, alerts, tips, deals, and trivia delivered free to your email in-box.
Email Address:

tell me more

Site Tools
Site Map
About Maps.com
Contact Maps.com
Advertise with Maps.com
Affiliate Program
Order Tracking
View Cart
Check Out
Help

 
Site Map | Help | Home

New Online Book! Handbook of Mathematical Functions (AMS55)
Conversion & Calculation Home >> Reference Information

Types of Missing Information
Codes Used to Represent Missing Information in Other Tables

Abbreviation Long Name Null Type Description
(N/A) (Not Applicable) Value not applicable Value is not applicable to rows of the current type.
(UNK) (Unknown) Value unknown Value is unknown by the computer user or source of information.
(DNE) (Does Not Exist) Value does not exist Value is applicable, but it does not exist.
(N/V) (Not Valid) Value not valid Value supplied by source is invalid within computer system.
(N/S) (Not Supplied) Value not supplied Value was not supplied by the source of the information--"no comment."
(NYC) (Not Yet Classified) Value not yet classified Computer user has not yet chosen or entered the proper value.
(DEF) (Inherit Default Value) Value is inherited Default value is inherited from an above entity.
(DNC) (Do Not Care) Do not care User does not care about the value.
(ALL) (All Values) All instances Value represents all non-missing values within target table.
(A/O) (All Other Values) All other instances Value represents all non-missing and non-specified values within target.
(UWM) (Unknown Why Missing) Unknown why missing Set when data loaded from other computer sources contains blanks.
(U/D) (Undefined) Value undefined Result of some operation is undefined.
(E/S) (Empty Set) Value is the empty set Result of some join operation returned nothing.
(O/U) (Outer Union Result) Outer union type Result of an outer union operation.

(800) 430-7532 | info@maps.com | Online Privacy Policy
2000 Maps.com. All rights reserved.
Portions 2000 ConvertIt.com, Inc. All rights reserved. Terms of Use.