Lawson Insight Technical Documentation

                              PRSTATE FILE

                                 States

This file contains state codes that provide access to fields for entering
required or optional additional information for state reporting.

REFERENCED BY

AC541     AC542     BN150     HPSA.1    HR04.9    HR11.1
HR11.2    HR15.1    HR155     HR16.1    HR16.2    HR16.3
HR16.4    HR16.5    HR16.6    HR16.7    HR16.8    HR17.1
HR17.2    HR17.3    HR17.4    HR17.5    HR17.6    HR17.7
HR17.8    HR17.9    HR170     HR18.1    HR18.2    HR18.3
HR18.4    HR511     HR515     HR54.1    HR55.2    HR650
HR70.1    HRS1.1    HRSC.1    HS50.3    HS50.4    PA02.1
PA100     PA102     PA113     PA13.1    PA13.2    PA16.1
PA20.1    PA21.1    PA22.1    PA24.1    PA27.1    PA272
PA34.1    PA35.1    PA36.1    PA38.1    PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PA520     PA53.1
PA54.1    PA66.3    PA93.1    PA93.2    TR21.1    TR22.1
TR26.1    TR500     PR03.1    PR06.1    PR110     PR113
PR120     PR128     PR13.1    PR13.5    PR13.6    PR13.8
PR130     PR131     PR132     PR134     PR136     PR18.1
PR189     PR250     PR251     PR253     PR27.1    PR289
PR29.1    PR291     PR292     PR296     PR297     PR298
PR299     PR32.2    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR36.1
PR45.1    PR529     PR530     PR560     PR80.1    PR82.1
PR89.1    PRSC.1    UK102     TA147     UK120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PSA-STATE            Alpha 2
State or Province    Contains the two-character code that
                     identifies the state.

PSA-DESCRIPTION      Alpha 30  (Lower Case)                      HR16.1
Description          Contains the state code description.

                         PRSTATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSASET1   STATE                                                  AC541   AC542
                                                                 BN150   HPSA.1
                                                                 HR04.9  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR16.1
                                                                 HR16.2  HR16.3
                                                                 HR16.4  HR16.5
                                                                 HR16.6  HR16.7
                                                                 HR16.8  HR17.1
                                                                 HR17.2  HR17.3
                                                                 HR17.4  HR17.5
                                                                 HR17.6  HR17.7
                                                                 HR17.8  HR17.9
                                                                 HR170   HR18.1
                                                                 HR18.2  HR18.3
                                                                 ...