Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              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

BN150     HPSA.1    HR11.1    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     HR54.1    HR55.2
HR70.1    HR700     HRS1.1    HRSC.1    PA02.1    PA100
PA102     PA13.1    PA13.2    PA16.1    PA20.1    PA21.1
PA22.1    PA24.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    TR500     PR03.1    PR06.1
PR128     PR13.1    PR131     PR132     PR134     PR136
PR137     PR140     PR150     PR18.1    PR195     PR199
PR289     PR291     PR292     PR296     PR298     PR32.1
PR32.2    PR33.1    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR36.1
PR37.1    PR45.1    PR530     PR560     PR61.1    PR80.1
PR82.1    PR85.1    PR89.1    UK102     UK330     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                                                  BN150   HPSA.1
                                                                 HR11.1  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
                                                                 HR54.1  HR55.2
                                                                 ...