A CDE Definition
A physical structure in a form, file or database that holds data. A field is one or more bytes in size. A collection of fields makes up a data record; for example, ORDER #, NAME, ADDRESS, CITY, etc. The terms field and "box" are often used synonymously such as a "search field" or "search box" on a Web page.
The field is the common denominator for database searches. For example, the STATE field is referenced when the query to find "all customers who live in Florida" is made to a database. When totaling transactions, the ORDER_AMOUNT field is summed. JOB_TITLE is referenced when looking for certain employees.
Fields, Data Elements and Data Items
Although often used interchangeably, there are several terms that refer to the same unit of storage in a data record. A "data element" is the logical definition of the field, while a "data item" is the actual data stored in the field. For example, for each CITY data element defined in a record, there are many CITY fields (structures) in the database that hold the data items (New York, Chicago, Phoenix, etc.).
The Basic Unit of Storage
Before/After Your Search Term
Terms By Topic
Click any of the following categories for a list of fundamental terms.