Field name:

Format:

Size / range

CASE_ID

CHARACTER

characters

STREET_1 STREET_2

CHARACTER

(up to 65,000 streets)

BLOCK_1 BLOCK_2

NUMBER

+/- 2 billion (whole numbers)

MILE_1 MILE_2 (not used)

NUMBER

+/- 2 million (3 decimal places)

DATE

DATE

/1/01 - almost forever

TIME

-HOUR

to 2400 (0=2400)

DISTANCE

NUMBER

-64000 (whole numbers)

U_LONG (user defined number)

NUMBER

+/- 2 billion (whole numbers)

U_WORD (user defined number)

NUMBER

to 65,500 (whole numbers)