PRSYSTEM – HR Company and Process Levels

System
Human Resources (HR)
Prefix
PRS
Primary key
COMPANY, PROCESS-LEVEL
Fields
129
Updated by
107 programs
Referenced by
1095 programs

PRSYSTEM is the HR Company and Process Levels table in Lawson Human Resources (prefix PRS). It is indexed by COMPANY, PROCESS-LEVEL (PRSSET1); alternate indexes: PRSSET2 and PRSSET3. It is related 1:1 to GLNAMES, PERSACTYPE, BANKFILE, BNCOMPANY, GLMASTER, PRSYSTEM, INSTCTRYCD, CUCODES and 5 more and 1:M to PACOMMENTS, APPLICANT, PAASSIGNED, ATCLASSHDR, BANKFILE, PABUDGET, PRPROCGRP, PASCRTY and 48 more. It is updated by BN150, BN305, BN66.1, EX542, EX545, EXI2.1, EXI4.1, HR00.1 and 99 more and referenced by AC03.3, AC03.7, AC145, AC17.3, AC18.2, AC191, AC203, AC210 and 1087 more. The table has 129 fields, 3 indexes and 85 documented relations.

About PRSYSTEM

Contains payroll company and process level records. The process level field is equal to spaces on company records. HR00.1 (Company) creates company records, while HR01.1 (Process Level) creates process level records.

Fields (129)

Column = COBOL field name without the PRS- 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
#PRS-COMPANY PK
COMPANY
Numeric 4Contains the company number.HR00.1, HR01.1
#PRS-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5Contains the process level identifier. This field is spaces for company records.HR00.1, HR01.1
#PRS-NAME
NAME
Alpha 30 (Lower Case)Displays the company or process level name.HR00.1, HR01.1, PA170, PA218, PA80.1, PA80.2
#PRS-LONG-NAME
LONG_NAME
Alpha 75 (Lower Case)HR00.1, HR01.1
#PRS-ADDR1
ADDR1
Alpha 30 (Lower Case)This field contains the first line of address information.HR00.1, HR01.1
#PRS-ADDR2
ADDR2
Alpha 30 (Lower Case)This field contains the first line of address information.HR00.1, HR01.1
#PRS-ADDR3
ADDR3
Alpha 30 (Lower Case)This field contains the first line of address information.HR00.1, HR01.1
#PRS-ADDR4
ADDR4
Alpha 30 (Lower Case)This field contains the first line of address information.HR00.1, HR01.1
#PRS-CITY
CITY
Alpha 58 (Lower Case)This field contains the city of the address.HR00.1, HR01.1
#PRS-STATE
STATE
Alpha 2Contains the state of the address.HR00.1, HR01.1
#PRS-ZIP
ZIP
Alpha 10This field contains the postal code of the address.HR00.1, HR01.1
#PRS-PAYROLL-YEAR
PAYROLL_YEAR
Numeric 4Contains the current payroll year.HR00.1, HR01.1, PR999
#PRS-BSI-COMPANY
BSI_COMPANY
Alpha 11Contains the BSI Company. The BSI "Tax File Load Validation Report" determines this parameter. The company code defined here must be one for which taxing authorities are supported within the BSI tax system. If you enter an unsupported value, PR140 (Earnings and Deductions Calculation) and PR80.1 (Manual Payment) abort because of a division by zero (the BSI interface software controls this). However, the Lawson Human Resources system edits BSITAX when you add or change a company, to verify the BSI company is valid.HR00.1, HR01.1
#PRS-GL-UNITS
GL_UNITS
Alpha 1Determines if hours are posted to the general ledger.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-DC-DED-CLASS
DC_DED_CLASS
Alpha 3Contains the Defined Contribution deduction class which is used only by the Lawson Benefits system. All deductions tied to this deduction class are applied to the Section 415 maximum annual additions limit defined in BN00 (Benefits Company).HR00.1, HR01.1
#PRS-OVERTIME
OVERTIME
Alpha 3Contains the overtime pay class. When you enter time records for exempt employees, the Lawson Payroll system edits time records with pay codes tied to the overtime pay class.HR00.1, HR01.1
#PRS-PAY-IN-KIND
PAY_IN_KIND
Alpha 3Contains the payment-in-kind pay class. The Payroll system subtracts all gross amounts from any pay code tied to the payment-in-kind pay class before calculating the net payment.HR00.1, HR01.1
#PRS-TIPS
TIPS
Alpha 3Contains the tips pay class. The tips pay class provides edits that let you enter both hours and amounts on time records without being multiplied together. This is a required field if you use the Lawson Tips system.HR00.1, HR01.1
#PRS-AUTO-EMPLOYEE
AUTO_EMPLOYEE
Alpha 1Determines if the system assigns employee numbers automatically when you add employees. If the value is No, you must type an employee number when adding an employee.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-LAST-EMPLOYEE
LAST_EMPLOYEE
Numeric 9Contains the last employee number assigned.BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 +26 more
#PRS-BATCH-OPTION
BATCH_OPTION
Alpha 1Determines if the batch number is assigned automatically when you add time records.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-AUTO-BTCH-NBR
AUTO_BTCH_NBR
Numeric 6Identifies the last batch number created.BN150, EXI2.1, EXI4.1, HR00.1, HR01.1, LP130, PR128, PR131 +34 more
#PRS-BATCH-CONTROL
BATCH_CONTROL
Alpha 1Determines if PR37.1 (Batch Time Control) requires entry of batch control totals to release a batch of time records.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-ES-DIST-CO
ES_DIST_CO
Numeric 4Contains the error suspense distribution company.HR00.1, HR01.1
#PRS-ES-ACCT-UNIT
ES_ACCT_UNIT
Alpha 15Contains the error suspense accounting unit.HR00.1, HR01.1
#PRS-ES-ACCOUNT
ES_ACCOUNT
Numeric 6Contains the error suspense account.HR00.1, HR01.1
#PRS-ES-SUB-ACCT
ES_SUB_ACCT
Numeric 4Contains the error suspense subaccount.HR00.1, HR01.1
#PRS-EXP-DIST-CO
EXP_DIST_CO
Numeric 4Contains the expense distribution company.HR00.1, HR01.1
#PRS-EXP-ACCT-UNIT
EXP_ACCT_UNIT
Alpha 15Contains the payroll expense accounting unit.HR00.1, HR01.1
#PRS-EXP-ACCOUNT
EXP_ACCOUNT
Numeric 6Contains the payroll expense account.HR00.1, HR01.1
#PRS-EXP-SUB-ACCT
EXP_SUB_ACCT
Numeric 4Contains the payroll expense subaccount.HR00.1, HR01.1
#PRS-ACH-COMP-ID
ACH_COMP_ID
Alpha 10Contains the company's ACH (Automated Clearing House) identification number.HR00.1, HR01.1
#PRS-EMPLOYEE-SEQ
EMPLOYEE_SEQ
Alpha 1Contains the default sort order for reports.
  • A Employee Name Sequence
  • N Employee Number Sequence
HR00.1, HR01.1
#PRS-BANK-CODE SET2
BANK_CODE
Alpha 4Contains the bank code. The bank code is a user-defined field associating the bank account information with the cash account information.HR00.1, HR01.1
#PRS-CL-DIST-CO
CL_DIST_CO
Numeric 4Contains the clearing account general ledger distribution company.HR00.1, HR01.1
#PRS-CL-ACCT-UNIT
CL_ACCT_UNIT
Alpha 15Contains the clearing account general ledger accounting unit.HR00.1, HR01.1
#PRS-CL-ACCOUNT
CL_ACCOUNT
Numeric 6Contains the clearing account general ledger account number.HR00.1, HR01.1
#PRS-CL-SUB-ACCT
CL_SUB_ACCT
Numeric 4Contains the clearing account general ledger subaccount number.HR00.1, HR01.1
#PRS-PIK-DIST-CO
PIK_DIST_CO
Numeric 4Contains the payment-in-kind general ledger distribution company.HR00.1, HR01.1
#PRS-PIK-ACCT-UNIT
PIK_ACCT_UNIT
Alpha 15Contains the payment-in-kind general ledger accounting unit.HR00.1, HR01.1
#PRS-PIK-ACCOUNT
PIK_ACCOUNT
Numeric 6Contains the payment-in-kind general ledger account number.HR00.1, HR01.1
#PRS-PIK-SUB-ACCT
PIK_SUB_ACCT
Numeric 4Contains the payment-in-kind general ledger subaccount number.HR00.1, HR01.1
#PRS-PR132-RUN-FLG
PR132_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run PR132 by company, the system sets the run flag for the company and all process levels that are processed. When you run PR132 by process level, the system sets the run flag for that process level only.
  • * Completed
  • E Error
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +34 more
#PRS-PR140-RUN-FLG
PR140_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run PR140 by company, the system sets the run flag for the company and all process levels that are processed. When you run PR140 by process level, the system sets the run flag for that process level only.
  • * Completed
  • E Error
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +37 more
#PRS-PR160-RUN-FLG
PR160_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run PR160 by company, the system sets the run flag for the company and all process levels that are processed. When you run PR160 by process level, the system sets the run flag for that process level only.
  • * Completed
  • E Error
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +36 more
#PRS-PR199-RUN-FLG
PR199_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run PR199 by company, the system sets the run flag for the company and all process levels that are processed. When you run PR199 by process level, the system sets the run flag for that process level only.
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +34 more
#PRS-TA170-RUN-FLG
TA170_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run TA170 by company, the system sets the run flag for the company and all process levels that are processed. When you run TA170 by process level, the system sets the run flag for that process level only.
  • * Completed
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +36 more
#PRS-TA199-RUN-FLG
TA199_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run TA199 by company, the system sets the run flag for the company and all process levels that are processed. When you run TA199 by process level, the system sets the run flag for that process level only.
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +33 more
#PRS-TP135-RUN-FLG
TP135_RUN_FLG
Alpha 1Insures that cycle programs are run in the correct order. When you run TP135 by company, the system sets the run flag for the company and all process levels that are processed. When you run TP135 by process level, the system sets the run flag for that process level only.
  • * Completed
  • E Error
  • R Running
BN150, EXI2.1, EXI4.1, LP130, PR00.1, PR128, PR131, PR132 +34 more
#PRS-COMPLETE-FLAG
COMPLETE_FLAG
Alpha 1Indicates that the system has completed an Add function for a company.
  • Y Add complete
HR00.1, HR01.1
#PRS-SERIAL-NBR
SERIAL_NBR
Numeric 6Identifies a group of payments created by PR160 (Payment Print). Each time you run PR160 the system increments this value.HR00.1, HR01.1, PR160, PR180, PR80.2
#PRS-AUTO-APP
AUTO_APP
Alpha 1Contains the option for the Lawson Personnel system to automatically number the applicants.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-LAST-APP
LAST_APP
Numeric 9Contains the last applicant number assigned.HR00.1, HR01.1, LT101, LT111, PA100, PA28.1, PA31.1, PA52.4 +1 more
#PRS-ANNUAL-HOURS
ANNUAL_HOURS
Signed 8.4Contains the annual hours used in the calculation of wages and benefits.HR00.1, HR01.1, PA370
#PRS-EEO4-OPTION
EEO4_OPTION
Alpha 1Indicates if the company is required to file an EEO-4 report, and provides the proper edits when entering job code EEO categories.
  • N EEO-1 Edits Performed
  • Y EEO-4 Edits Performed
  • T EEO-5 Edits Performed
HR00.1, HR01.1, PA93.3
#PRS-FNCTN-DESC
FNCTN_DESC
Alpha 20Contains the description of functional group fifteen. Used for "Other" in EEO4 reporting.HR00.1, HR01.1, PA93.3
#PRS-BEG-SAL-RANGE
BEG_SAL_RANGE
Signed 13.4 Occurs 7 Times ×7Contains the beginning salary of a salary range used for the EEO-4 report.HR00.1, HR01.1, PA93.3
#PRS-END-SAL-RANGE
END_SAL_RANGE
Signed 13.4 Occurs 7 Times ×7Contains the ending salary of a salary range used for the EEO-4 report.HR00.1, HR01.1, PA93.3
#PRS-LIMIT-FLAG
LIMIT_FLAG
Alpha 1Contains the indicator that prevents PR140 (Earnings and Deductions Calculation) from taking 401k, 403b, and 457 deductions after they reach the federal withholding limit.
  • N No
  • Y Yes
  • L Yes - OTD*
HR00.1, HR01.1
#PRS-PRD-OPTION
PRD_OPTION
Alpha 1Determines if the system creates records in the Employee Payment Distribution file. You can set this up by company or process level.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-GLI-OPTION
GLI_OPTION
Alpha 1Determines if the system creates general ledger interface records for the company.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-PS-OPTION
PS_OPTION
Alpha 1Determines if the system creates project detail distributions for the company in the General Ledger Interface file.
  • N No
  • Y Yes
#PRS-PL-OPTION
PL_OPTION
Alpha 1Determines if the process level is treated as an independent company. " " = No ; Not Independent
  • N No ; Not Independent
  • Y Yes; Independent
HR00.1, HR01.1
#PRS-ACR-DIST-CO
ACR_DIST_CO
Numeric 4Contains the accrual account general ledger distribution company.HR00.1, HR01.1
#PRS-ACR-ACCT-UNIT
ACR_ACCT_UNIT
Alpha 15Contains the accrual account general ledger accounting unit.HR00.1, HR01.1
#PRS-LAST-CHECK-ID
LAST_CHECK_ID
Numeric 12Contains the last payment number.HR00.1, HR01.1, PR160, PR180, PR560, PR582, PR80.1, PR80.4 +3 more
#PRS-INCLUDE-PR132
INCLUDE_PR132
Alpha 1Indicates if PR132 has been defined as required in the payroll cycle.
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-INCLUDE-TP135
INCLUDE_TP135
Alpha 1
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-LAST-TIME-SEQ
LAST_TIME_SEQ
Numeric 12Contains the last number used for time record sequence numbering.BN150, EX542, EXI2.1, EXI4.1, HR00.1, HR01.1, LP130, PR128 +38 more
#PRS-OT-PLAN-CODE
OT_PLAN_CODE
Alpha 4 Occurs 5 Times ×5Contains the pay plans defined for the company.HR00.1, HR01.1, PR22.1
#PRS-RECIP-CALC
RECIP_CALC
Alpha 1Indicates if the system is to perform state reciprocal calculations.
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-LOCAL-MAX
LOCAL_MAX
Alpha 1Indicates if the company uses the Local Maximum (coterminous) taxing method provided by BSI.
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-LAST-JOB-REQ
LAST_JOB_REQ
Numeric 9Contains the last job requisition number used.HR00.1, HR01.1, LT101, LT111, PA02.1, PA102, PA42.1, PA42.3 +2 more
#PRS-IMM-DEST
IMM_DEST
Numeric 9Contains the routing number of the ACH receiving point.HR00.1, HR01.1
#PRS-IMM-DEST-NAME
IMM_DEST_NAME
Alpha 30 (Lower Case)Contains the name that corresponds with the ACH routing number of the immediate destination.HR00.1, HR01.1
#PRS-IMM-ORIG
IMM_ORIG
Numeric 10Contains the routing number of the ACH operator or sending point of the file.HR00.1, HR01.1
#PRS-IMM-ORIG-NAME
IMM_ORIG_NAME
Alpha 30 (Lower Case)Contains the name that corresponds with the routing number of the ACH operator or sending point of the file.HR00.1, HR01.1
#PRS-AT-LIMIT-DEDS
AT_LIMIT_DEDS
Alpha 1Indicates whether to use after limit deductions when an employee reaches the pre-tax limit for 401k, 403b, and 457 type deductions.
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-SEC-LVL
SEC_LVL
Numeric 1Contains the security level for the company or process level.HR00.1, HR01.1
#PRS-SEC-LOCATION
SEC_LOCATION
Alpha 10Contains the security location for the company or process level.HR00.1, HR01.1
#PRS-CHK-DIGIT-EDIT
CHK_DIGIT_EDIT
Alpha 1Indicates if the system automatically edits for a valid ACH account for an employee. This is used for employee self service.
  • A Application Only
  • B Both Application and ESS
  • E ESS Only
  • N None
#PRS-AUTO-POSITION
AUTO_POSITION
Alpha 1Indicates whether the system should automatically assign a position number when positions are added.
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-LAST-POSITION
LAST_POSITION
Numeric 12Indicates the starting position number. If blank, default = 1.HR00.1, HR01.1, LT101, LT111, PA02.1, PA502
#PRS-REQ-CLOSE-STAT
REQ_CLOSE_STAT
Alpha 10Indicates value used when a requisition is closed automatically.HR00.1, HR01.1
#PRS-ACTION-CODE
ACTION_CODE
Alpha 10This field contains the personnel action code.HR00.1, HR01.1
#PRS-REASON
REASON
Alpha 10Contains reason code used when an immediate update is performed on PA02.1 (Position).HR00.1, HR01.1
#PRS-AUTO-JOB-REQ
AUTO_JOB_REQ
Alpha 1Determines whether the system assigns the requisition number when a requisition is added for a job or position.
  • Y Yes
  • N No
HR00.1, HR01.1
#PRS-AP-COMPANY
AP_COMPANY
Numeric 4Contains the accounts payable company where payroll information will be posted.HR00.1, HR01.1
#PRS-BSI-CONT-ALLOC
BSI_CONT_ALLOC
Alpha 1Indicates how to allocate benefit plan contributions in reciprocal situations.
  • 0 Percent Worked
  • 1 Full Amount
  • 9 Full Amount Alt Override
HR00.1, HR01.1
#PRS-CURRENCY-CODE
CURRENCY_CODE
Alpha 5Contains the company or process level currency.HR00.1, HR01.1
#PRS-CURR-ND
CURR_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.HR00.1, HR01.1
#PRS-CURRENCY-FLAG
CURRENCY_FLAG
Alpha 1Indicates whether the company allows multiple currencies.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-COUNTRY-CODE
COUNTRY_CODE
Alpha 2Contains the country of the address.HR00.1, HR01.1
#PRS-WORK-COUNTRY
WORK_COUNTRY
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).HR00.1, HR01.1
#PRS-CA-REL-CORP
CA_REL_CORP
Alpha 1If the independent process levels and tax reporting groups identified for a Canada company are related for tax purposes, this flag is set to yes. This means tax deductions that have a limit will share the wage base. An employee that works in multiple process levels mentioned above, will in essence, have one wage base.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-US-REL-CORP
US_REL_CORP
Alpha 1If the independent process levels and tax reporting groups identified for this U.S. company are related for tax purposes, this flag is set to yes. This means tax deductions that have a limit will share the wage base. An employee that works in multiple process levels mentioned above, will in essence, have one wage base.
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-BUS-NBR-GRP
BUS_NBR_GRP
Alpha 4HR00.1, HR01.1, PR09.1, PR125
#PRS-QC-ENT-NBR-GRP
QC_ENT_NBR_GRP
Alpha 4HR00.1, HR01.1
#PRS-COUNTRY-FLAG
COUNTRY_FLAG
Alpha 1
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-MAX-DED-IND
MAX_DED_IND
Alpha 1
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-HIST-CORR-FLAG
HIST_CORR_FLAG
Alpha 2Indicates default method the system uses to correct employee history audit files when a retroactive change is performed.
  • 1 Create pending upd
  • 2 Delete
  • 3 Move to Hist Error
HR00.1, HR01.1
#PRS-TAX-FORMS
TAX_FORMS
Numeric 1
  • 0 All forms are valid
  • 1 Only W-2 forms are valid
  • 2 Only 1099-R forms are valid
  • 3 Only 1099-DIV forms are valid
  • 4 No tax reporting is done
HR00.1, HR01.1
#PRS-EMP-TAX-ADDR
EMP_TAX_ADDR
Numeric 1
  • 0 Home
  • 1 Supplemental
HR00.1, HR01.1
#PRS-DUP-SOC-NBR
DUP_SOC_NBR
Alpha 1Controls the "duplicate" social number edit when an employee is added. If = "N", then duplicate numbers (withing a work country code) are NOT allowed. If blank, only a warning is recieved for duplicate number, but employee can be hired.HR00.1, HR01.1
#PRS-ACTIVE-FLAG
ACTIVE_FLAG
Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
HR00.1, HR01.1
#PRS-USER-ID
USER_ID
Alpha 10 (Lower Case)HR00.1, HR01.1
#PRS-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR00.1, HR01.1
#PRS-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR00.1, HR01.1
#PRS-RECRUIT-FLAG
RECRUIT_FLAG
Alpha 2HR00.1, HR01.1
#PRS-TA146-RUN-FLG
TA146_RUN_FLG
Alpha 1PR00.1, TA42.1
#PRS-TA198-RUN-FLG
TA198_RUN_FLG
Alpha 1PR00.1
#PRS-INCLUDE-UK121
INCLUDE_UK121
Alpha 1HR00.1, HR01.1
#PRS-UK121-RUN-FLG
UK121_RUN_FLG
Alpha 1
#PRS-EMPLOYER-DED
EMPLOYER_DED
Alpha 1Determines whether employer-paid deductions are posted to AC; can be set to No if activity burdens or allocations are used to calculate and post employer-paid fringe. " " = Yes
  • N No
HR00.1, HR01.1
#PRS-TAX-LOC-MSGLVL
TAX_LOC_MSGLVL
Numeric 1
  • 1 Messages 1000 and higher
  • 2 Messages 2000 and higher
  • 3 Messages 3000 and higher
  • 9 Messages 9000 and higher
HR00.1, HR01.1
#PRS-TAX-FILTER
TAX_FILTER
Numeric 1
  • 1 Locate All
  • 2 Locate Federal & State Only
  • 3 Locate Federal Only
HR00.1, HR01.1
#PRS-UPGRADE-FLD1
UPGRADE_FLD1
Alpha 1BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PRS-OVR-DED-EXP
OVR_DED_EXP
Alpha 1Add field for PR197 processing of company paid deduction expenses.
  • 1 No
  • 2 Yes; Override
  • 3 Yes; Override Specified Ded
HR00.1, HR01.1
#PRS-ADDR-CONFIG
ADDR_CONFIG
Numeric 1Used to identify which address line is the Location Address and which is the Delivery address
  • 1 Addr1 Location; Addr2 Delivery
  • 2 Addr2 Location; Addr1 Delivery
HR00.1, HR01.1
#PRS-LOCAL-RECIP-CD
LOCAL_RECIP_CD
Numeric 4HR00.1, HR01.1
#PRS-LP-POST-RULE
LP_POST_RULE
Alpha 1
  • N No
  • Y Yes
HR00.1, HR01.1
#PRS-PHONE-NBR
PHONE_NBR
Alpha 15HR00.1, HR01.1
#PRS-PHONE-CNTRY
PHONE_CNTRY
Alpha 6HR00.1, HR01.1
#PRS-PHONE-EXT
PHONE_EXT
Alpha 5HR00.1, HR01.1
#PRS-LTM-FLAG
LTM_FLAG
Alpha 2
#PRS-ACH-COMP-NAME
ACH_COMP_NAME
Alpha 16 (Lower Case)HR00.1, HR01.1
#PRS-EMAIL-ADD
EMAIL_ADD
Alpha 50HR00.1, HR01.1
#PRS-PAN SET3
PAN
Alpha 10HR00.1, HR01.1

Indexes (3)

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
PRSSET1
  1. COMPANY
  2. PROCESS-LEVEL
PrimaryAC03.3, AC03.7, AC145, AC17.3, AC18.2, AC191, AC203, AC210 +22 more (list truncated in source)
PRSSET2
  1. COMPANY
  2. BANK-CODE
  3. PROCESS-LEVEL
KeyChangeBN66.1, HR00.1, HR01.1, LP140, LP145, PR01.2, PR140, PR189 +5 more
PRSSET3
  1. PAN
  2. COMPANY
  3. PROCESS-LEVEL
KeyChange

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLNAMESPERSACTYPEBANKFILEBNCOMPANYGLMASTERPRSYSTEMINSTCTRYCDCUCODESDCCLASSPAYCLASSPRMONITORPRQCENTGRPPCODESPACOMMENTSAPPLICANTPAASSIGNEDATCLASSHDRBANKFILEPABUDGETPRPROCGRPPASCRTYDCCLASSDEDCODEDEPTCODEPERSGROUPEMPLOYEETIMERECORD+42 more belowPRSYSTEM

One to one (19) — lookups and parents

RelationTableRulesConditionField map
Accrual AcctGLNAMESRequiredWhen PRS-ACR-ACCT-UNIT != Spaces
PRS-COMPANYGLN-COMPANY
PRS-ACR-ACCT-UNITGLN-ACCT-UNIT
ActionPERSACTYPERequiredWhen (PRS-ACTION-CODE != Spaces)
PRS-COMPANYPAT-COMPANY
PRS-ACTION-CODEPAT-ACTION-CODE
Bank CodeBANKFILERequiredWhen PRS-BANK-CODE != Spaces
PRS-COMPANYBFL-COMPANY
PRS-BANK-CODEBFL-BANK-CODE
Benefit CompBNCOMPANYNot Required, Delete RestrictedValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYBNC-COMPANY
Clearing AcctGLMASTERRequiredWhen PRS-CL-ACCT-UNIT != Spaces Or PRS-CL-ACCOUNT != Zeroes
PRS-COMPANYGLM-COMPANY
PRS-CL-ACCT-UNITGLM-ACCT-UNIT
PRS-CL-ACCOUNTGLM-ACCOUNT
PRS-CL-SUB-ACCTGLM-SUB-ACCOUNT
CompanyPRSYSTEMRequiredWhen PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPRS-COMPANY
SpacesPRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredWhen (PRS-COUNTRY-CODE != Spaces)
PRS-COUNTRY-CODEINT-COUNTRY-CODE
CurrencyCUCODESRequiredWhen (PRS-CURRENCY-CODE != Spaces)
PRS-CURRENCY-CODECUC-CURRENCY-CODE
DcclassDCCLASSRequiredWhen PRS-DC-DED-CLASS != Spaces
PRS-COMPANYDCL-COMPANY
PRS-DC-DED-CLASSDCL-DED-CLASS
Error Sus AcctGLMASTERRequiredWhen PRS-ES-ACCT-UNIT != Spaces Or PRS-ES-ACCOUNT != Zeroes
PRS-COMPANYGLM-COMPANY
PRS-ES-ACCT-UNITGLM-ACCT-UNIT
PRS-ES-ACCOUNTGLM-ACCOUNT
PRS-ES-SUB-ACCTGLM-SUB-ACCOUNT
Expense AcctGLMASTERRequiredWhen PRS-EXP-ACCT-UNIT != Spaces Or PRS-EXP-ACCOUNT != Zeroes
PRS-EXP-DIST-COGLM-COMPANY
PRS-EXP-ACCT-UNITGLM-ACCT-UNIT
PRS-EXP-ACCOUNTGLM-ACCOUNT
PRS-EXP-SUB-ACCTGLM-SUB-ACCOUNT
Ovt Pay ClassPAYCLASSRequiredWhen PRS-PROCESS-LEVEL = Spaces And PRS-BSI-COMPANY != Spaces
PRS-COMPANYPCL-COMPANY
PRS-OVERTIMEPCL-PAY-CLASS
Pik AccountGLMASTERRequiredWhen PRS-PIK-ACCT-UNIT != Spaces Or PRS-PIK-ACCOUNT != Zeroes
PRS-COMPANYGLM-COMPANY
PRS-PIK-ACCT-UNITGLM-ACCT-UNIT
PRS-PIK-ACCOUNTGLM-ACCOUNT
PRS-PIK-SUB-ACCTGLM-SUB-ACCOUNT
Pik Pay ClassPAYCLASSRequiredWhen PRS-PROCESS-LEVEL = Spaces And PRS-BSI-COMPANY != Spaces
PRS-COMPANYPCL-COMPANY
PRS-PAY-IN-KINDPCL-PAY-CLASS
Prmonitor LpPRMONITORRequiredWhen PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPMN-COMPANY
SpacesPMN-CYCLE-PROCESS
SpacesPMN-PROC-GROUP
SpacesPMN-BANK-CODE
PRS-PROCESS-LEVELPMN-PROCESS-LEVEL
PrqcentgrpPRQCENTGRPRequired
PRS-COMPANYPQC-COMPANY
PRS-PROCESS-LEVELPQC-PROCESS-LEVEL
PRS-QC-ENT-NBR-GRPPQC-QC-ENT-NBR-GRP
Req Close StatPCODESRequiredWhen (PRS-REQ-CLOSE-STAT != Spaces)
"RQ"PCO-TYPE
PRS-REQ-CLOSE-STATPCO-CODE
Tips Pay ClassPAYCLASSRequiredWhen PRS-TIPS != Spaces
PRS-COMPANYPCL-COMPANY
PRS-TIPSPCL-PAY-CLASS
Work CountryINSTCTRYCDNot RequiredValid When PRS-WORK-COUNTRY != Spaces
PRS-WORK-COUNTRYINT-COUNTRY-CODE

One to many (66) — child tables

RelationTableRulesConditionField map
All Pa CommentPACOMMENTSValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAC-COMPANY
PAC-EMP-APP
PAC-CMT-TYPE
PAC-EMPLOYEE
PAC-JOB-CODE
PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
PAC-DATE
ApplicantsAPPLICANTDelete RestrictedValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYAPL-COMPANY
APL-APPLICANT
Assigned ResPAASSIGNEDValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAA-COMPANY
PAA-POSITION
PAA-PROCESS-LEVEL
PAA-DEPARTMENT
PAA-JOB-CODE
Attend ClassATCLASSHDRDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYASH-COMPANY
ASH-ATTEND-CLASS
Bank CodesBANKFILEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYBFL-COMPANY
BFL-BANK-CODE
BudgetPABUDGETValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAB-COMPANY
PAB-POSITION
PAB-PROCESS-LEVEL
PAB-DEPARTMENT
PAB-JOB-CODE
PAB-EFFECT-DATE
Co Proc GroupsPRPROCGRPDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPRP-COMPANY
PRP-PROC-GROUP
PRP-PROCESS-LEVEL
Data ItemsPASCRTYDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAS-COMPANY
PAS-COUNTRY-CD-REQ
PAS-PROCESS-LEVEL
PAS-FLD-NBR
Deduct ClassesDCCLASSDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYDCL-COMPANY
DCL-DED-CLASS
Deduction CodeDEDCODEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYDDC-COMPANY
DDC-DED-CODE
DepartmentsDEPTCODEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYDPT-COMPANY
DPT-PROCESS-LEVEL
DPT-DEPARTMENT
Employee GroupPERSGROUPDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPRG-COMPANY
PRG-GROUP-NAME
EmployeesEMPLOYEEDelete RestrictedValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYEMP-COMPANY
EMP-EMPLOYEE
Err Time RecsTIMERECORDValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYTRD-COMPANY
TRD-PROCESS-LEVEL
TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-REPORT-ENTITY
TRD-BUS-NBR-GRP
TRD-SUPP-TAX-CODE
TRD-PROCESS-GRP
TRD-TIME-SEQ
Gr Dis Act StpPAGRDISTEPValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPGI-COMPANY
PGI-EMPLOYEE
PGI-TYPE
PGI-GRIEV-DIS-NBR
PGI-EFFECT-DATE
PGI-SEQ-NBR
Griev Dis ActPAGRDIValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAG-COMPANY
PAG-EMPLOYEE
PAG-TYPE
PAG-DATE
PAG-GRIEV-DIS-NBR
Hr Cont NbrHRCONTNBRValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYHCN-COMPANY
HCN-REQ-TYPE
HCN-ID-NBR
HCN-DEPENDENT
HCN-SEQ-NBR
Hr Occup CodeHROCCUPCDDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYHOP-COMPANY
HOP-JOB-CODE
HOP-COUNTRY-CODE
HOP-OCCUPTN-CODE
Hr User FldsHRPOSUSDValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYHPD-COMPANY
HPD-TYPE
HPD-OBJ-ID
HPD-EFFECT-DATE
HPD-FIELD-KEY
Inci Follow UpPAFOLLOWUPDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAF-COMPANY
PAF-EMPLOYEE
PAF-ESTABLISHMENT
PAF-INCIDENT-NBR
PAF-EFFECT-DATE
PAF-SEQ-NBR
Incid CostsPAINCICOSTDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAI-COMPANY
PAI-EMPLOYEE
PAI-ESTABLISHMENT
PAI-INCIDENT-NBR
PAI-EFFECT-DATE
PAI-SEQ-NBR
Job ReqsPAJOBREQDelete RestrictedValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPJR-COMPANY
PJR-REQUISITION
JobcodesJOBCODEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYJBC-COMPANY
JBC-JOB-CODE
JobrelationsJOBRELATEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYJBR-COMPANY
JBR-PROCESS-LEVEL
JBR-JOB-CODE
JBR-POSITION
JBR-TYPE
JBR-PERS-CODE
JBR-SUBJECT-CODE
PacaneeaPACANEEAValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPCE-COMPANY
PCE-SIC
PCE-PROCESS-LEVEL
PCE-DEPARTMENT
PCE-LOCAT-CODE
PacanhdrPACANHDRValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPHD-COMPANY
PHD-SIC
Pay ClassesPAYCLASSDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPCL-COMPANY
PCL-PAY-CLASS
Pay CodesPRPAYCODEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPCD-COMPANY
PCD-PROCESS-LEVEL
PCD-JOB-CODE
PCD-PAY-CODE
Pay Sum GroupsPAYSUMGRPDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPSG-COMPANY
PSG-PAY-SUM-GRP
Pending ActionPERSACTIONValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPCT-COMPANY
PCT-ACTION-TYPE
PCT-EFFECT-DATE
PCT-ACTION-CODE
PCT-EMPLOYEE
PCT-ACTION-NBR
Pep AuditPAPEPAUDITDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPEA-COMPANY
PEA-EMPLOYEE
PEA-POS-LEVEL
PEA-EFFECT-DATE
PEA-UPDATE-DATE
PEA-FLD-NBR
PEA-ACT-OBJ-ID
Pl Assn ResourPAASSIGNEDDelete CascadesValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPAA-COMPANY
PRS-PROCESS-LEVELPAA-PROCESS-LEVEL
PAA-DEPARTMENT
PAA-JOB-CODE
PAA-POSITION
Pl BudgetPABUDGETDelete CascadesValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPAB-COMPANY
PRS-PROCESS-LEVELPAB-PROCESS-LEVEL
PAB-DEPARTMENT
PAB-JOB-CODE
PAB-EFFECT-DATE
PAB-POSITION
Pl DepartmentsDEPTCODEDelete CascadesValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYDPT-COMPANY
PRS-PROCESS-LEVELDPT-PROCESS-LEVEL
DPT-DEPARTMENT
Pl EmployeesEMPLOYEEDelete RestrictedValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYEMP-COMPANY
PRS-PROCESS-LEVELEMP-PROCESS-LEVEL
EMP-EMPLOYEE
Pl EncumberPAENCUMBERDelete Restricted
PRS-COMPANYPEN-COMPANY
SpacesPEN-POSITION
PRS-PROCESS-LEVELPEN-PROCESS-LEVEL
PEN-DEPARTMENT
PEN-JOB-CODE
PEN-EMPLOYEE
PEN-GLT-OBJ-ID
PEN-ATN-OBJ-ID
Pl Err Time RTIMERECORDValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYTRD-COMPANY
PRS-PROCESS-LEVELTRD-PROCESS-LEVEL
TRD-EMPLOYEE
TRD-CHECK-GRP
TRD-REPORT-ENTITY
TRD-BUS-NBR-GRP
TRD-SUPP-TAX-CODE
TRD-PROCESS-GRP
TRD-TIME-SEQ
Pl PositionsPAPOSITIONValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPOS-COMPANY
PRS-PROCESS-LEVELPOS-PROCESS-LEVEL
POS-DEPARTMENT
POS-POSITION
POS-EFFECT-DATE
Pl Proc GroupsPRPROCGRPDelete CascadesValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPRP-COMPANY
PRS-PROCESS-LEVELPRP-PROCESS-LEVEL
PRP-PROC-GROUP
PlanPLANMASTERDelete RestrictedValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPLM-COMPANY
PLM-PLAN-NAME
Pos RulePAPOSRULEValid When PRS-PROCESS-LEVEL != Spaces
PRS-COMPANYPPR-COMPANY
PRS-PROCESS-LEVELPPR-PROCESS-LEVEL
PPR-DEPARTMENT
PPR-EFFECT-DATE
Pos Rule CompPAPOSRULEValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPPR-COMPANY
PPR-PROCESS-LEVEL
PPR-DEPARTMENT
PPR-EFFECT-DATE
Posit StructPAPOSITIONValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPOS-COMPANY
POS-PROCESS-LEVEL
POS-DEPARTMENT
POS-POSITION
POS-EFFECT-DATE
PositionsPAPOSITIONDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPOS-COMPANY
POS-POSITION
POS-EFFECT-DATE
PrhoursPRHOURSDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPHS-COMPANY
PHS-EMPLOYEE
PHS-HOURS-TYPE
PHS-PAYROLL-YEAR
Process LevelsPRSYSTEMDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPRS-COMPANY
PRS-PROCESS-LEVEL
PrqualifyPRQUALIFYDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPRQ-COMPANY
PRQ-RECORD-KEY
PRQ-SEQ-NBR
ReasonPAACTREASValid When (PRS-REASON != Spaces)
PRS-COMPANYCRE-COMPANY
PRS-REASONCRE-ACT-REASON-CD
CRE-ACTION-CODE
RegistrationsPAREGISTERValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYREG-COMPANY
REG-EMPLOYEE
REG-COURSE
REG-SESSION
REG-START-DATE
Required CodesREQCODEDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYRQC-COMPANY
RQC-REQ-CODE
Schedule DtlPRSAGDTLDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYSGD-COMPANY
SGD-SCHEDULE
SGD-EFFECT-DATE
SGD-PAY-GRADE
SGD-PAY-STEP
Schedule HdrPRSAGHEADDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYSGH-COMPANY
SGH-INDICATOR
SGH-SCHEDULE
SGH-EFFECT-DATE
Stand TimerecsSTANDTIMEValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYSTM-COMPANY
STM-EMPLOYEE
STM-TIME-GROUP
STM-PAY-CODE
STM-SEQ-NBR
StatusesEMSTATUSDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYEMS-COMPANY
EMS-EMP-STATUS
Step And GradePRSAGHEADValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYSGH-COMPANY
"S"SGH-INDICATOR
SGH-SCHEDULE
SGH-EFFECT-DATE
Stock ExerBNEMPEXERValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYBXR-COMPANY
BXR-EMPLOYEE
BXR-OPT-GRANT-NBR
BXR-STOCK-CTF
BXR-EXERCISE-DATE
BXR-SEQ-NBR
Stock GrantBNEMPGRNTValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYBEG-COMPANY
BEG-EMPLOYEE
BEG-OPT-GRANT-NBR
BEG-STOCK-CTF
Stock Opt PlnBNSTKGNTValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYBSG-COMPANY
BSG-OPT-GRANT-NBR
SupervisorsHRSUPERValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYHSU-COMPANY
HSU-CODE
TaeemasterTAEEMASTERDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYTEM-COMPANY
TEM-EMPLOYEE
TEM-PLAN
TEM-EMPLOYEE-GROUP
TEM-POSITION
TaloshrsTALOSHRSDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYTLH-COMPANY
TLH-EMPLOYEE
TLH-PLAN
TLH-EMPLOYEE-GROUP
TLH-POSITION
TLH-PLAN-RULE
TLH-ACCRUAL-TYPE
TLH-YEAR
TaplanTAPLANDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYTAP-COMPANY
TAP-PLAN
Tax Id ExemptTAXIDEXMPDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYTID-COMPANY
TID-PAY-DED-FLAG
TID-PAY-CODE
TID-DED-CODE
Test SetupPATSTSETUPDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYPAP-COMPANY
PAP-TEST
TrainingPATRNHISTValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYTRH-COMPANY
TRH-EMPLOYEE
TRH-COURSE
TRH-DATE-COMPLETED
Work SchedHRWRKSCHDDelete CascadesValid When PRS-PROCESS-LEVEL = Spaces
PRS-COMPANYWSC-COMPANY
WSC-WORK-SCHED
WSC-CONTRACT-YEAR
WSC-EFFECT-DATE

Programs

Updated by (107)

Referenced by (1095)