Table Name

Field Name

Definition

Valid Values

Description

state.pat        
  STATE_NAME 10,10,C   Displays the name of the state.
      Minnesota  
  STATE_FIPS 2,2,C   Displays the state-number portion of the state FIPS (Federal Information Processing Standard) code.
      27  
  FIPS 5,5,C   Displays the full FIPS code of the state.
      27000