Data Dictionary Data Type Codes

Alphabetic; 52 characters including upper case A - Z and lower case a-z inclusive

Alphanumeric; includes all upper and lower case keyboard characters

Date values entered as MMDDYYYY or MM/DD/YYYY only

Numeric value representing whole dollars (250) or dollars and cents (250.00) – do not include comma separators

Real number with a specific number of digits to the right of the decimal

Decimal fraction multiplied by 100 (.5025 is represented as 50.25)

Numeric value in the range of -32768 through 32767 inclusive

Data field accepts only “Y” for yes and “N” for no

Data field accepts only “D” for whole dollars or “C” for dollars and cents; defines the precision if the data type is Dollar