PRSTATE – States

System
Payroll (PR)
Prefix
PSA
Primary key
STATE
Fields
2
Updated by
0 programs
Referenced by
0 programs

PRSTATE is the States table in Lawson Payroll (prefix PSA). It is indexed by STATE (PSASET1). The table has 2 fields, 1 index and 0 documented relations.

About PRSTATE

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

Fields (2)

Column = COBOL field name without the PSA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PSA-STATE PK
STATE
Alpha 2Contains the two-character code that identifies the state.—
#PSA-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)Contains the state code description.HR16.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PSASET1
  1. STATE
PrimaryBN150, BN305, BN47.1, BN547, BN70.1, HAP3.1, HCRE.1, HEP4.1 +22 more (list truncated in source)

Programs

No Lawson programs are documented as updating or referencing this table.