PRMONITOR – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PMN
Primary key
COMPANY, CYCLE-PROCESS, PROC-GROUP, PROCESS-LEVEL, BANK-CODE
Fields
28
Updated by
65 programs
Referenced by
13 programs

PRMONITOR is a Lawson Payroll table (prefix PMN); no description in the lawson data dictionary. It is indexed by COMPANY, CYCLE-PROCESS, PROC-GROUP, PROCESS-LEVEL, BANK-CODE (PMNSET1); alternate indexes: PMNSET2 and PMNSET6. It is related 1:1 to PRSYSTEM and 1:M to PRPROCGRP. It is updated by BN150, BN66.1, EXI2.1, EXI4.1, LP00.1, LP100, LP101, LP130 and 57 more and referenced by HR11.1, HR511, LP102, LP103, LP180, LP270, LP31.1, LP570 and 5 more. The table has 28 fields, 3 indexes and 3 documented relations.

About PRMONITOR

No description in the Lawson data dictionary.

Fields (28)

Column = COBOL field name without the PMN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PMN-COMPANY PK
COMPANY
Numeric 4BN66.1, LP130, LP131, LP140, LP145, PR140, PR160, PR180 +7 more
PMN-CYCLE-PROCESS PK
CYCLE_PROCESS
Alpha 1
  • 1 Company
  • 2 Process Level
  • 3 Process Group
  • 4 Distribution Process Level
BN66.1, LP140, LP145, PR140, PR160, PR180, PR189, PR195 +4 more
PMN-PROC-GROUP PK
PROC_GROUP
Alpha 10BN66.1, LP140, LP145, PR140, PR160, PR180, PR189, PR195 +4 more
PMN-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5BN66.1, LP130, LP131, LP140, LP145, PR140, PR160, PR180 +7 more
PMN-BANK-CODE PK
BANK_CODE
Alpha 4BN66.1, LP140, LP145, PR140, PR160, PR180, PR189, PR195 +4 more
PMN-PR132-RUN-FLG
PR132_RUN_FLG
Alpha 1" " = No Cycle
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
PR00.1
PMN-PR140-RUN-FLG
PR140_RUN_FLG
Alpha 1" " = No Cycle
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
PR00.1
PMN-PR160-RUN-FLG
PR160_RUN_FLG
Alpha 1" " = No Cycle
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
PR00.1, PR160
PMN-PR197-RUN-FLG
PR197_RUN_FLG
Alpha 1PR00.1
PMN-PR198-RUN-FLG
PR198_RUN_FLG
Alpha 1PR00.1, PR198
PMN-PR199-RUN-FLG
PR199_RUN_FLG
Alpha 1" " = No Cycle
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
PR00.1
PMN-TA170-RUN-FLG
TA170_RUN_FLG
Alpha 1" " = No Cycle
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
PR00.1
PMN-TP135-RUN-FLG
TP135_RUN_FLG
Alpha 1" " = No Cycle
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
PR00.1
PMN-BEG-CHECK-NBR
BEG_CHECK_NBR
Numeric 8BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PMN-END-CHECK-NBR
END_CHECK_NBR
Numeric 8BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PMN-BEG-RECPT-NBR
BEG_RECPT_NBR
Numeric 8BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PMN-END-RECPT-NBR
END_RECPT_NBR
Numeric 8BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PMN-SERIAL-NBR
SERIAL_NBR
Numeric 6Check run serial number.BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PMN-TA146-RUN-FLG
TA146_RUN_FLG
Alpha 1
PMN-TA198-RUN-FLG
TA198_RUN_FLG
Alpha 1
PMN-UK121-RUN-FLG
UK121_RUN_FLG
Alpha 1
PMN-LP140-RUN-FLG
LP140_RUN_FLG
Alpha 1
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
BN150, EXI2.1, EXI4.1, LP00.1, LP130, LP140, LP197, LP53.1 +41 more
PMN-LP145-RUN-FLG
LP145_RUN_FLG
Alpha 1
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
LP00.1, LP145, LP197
PMN-LP197-RUN-FLG
LP197_RUN_FLG
Alpha 1
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
LP00.1, LP197, PR00.1
PMN-LP130-RUN-FLG
LP130_RUN_FLG
Alpha 1
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
LP00.1, LP130, LP140, LP197
PMN-LP198-RUN-FLG
LP198_RUN_FLG
Alpha 1To indicate when LP198 is in process so that LP197 can not be run at the same time for the applicable process level on this record
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
LP00.1, LP198
PMN-LP131-RUN-FLG
LP131_RUN_FLG
Alpha 1Indicates the status of the LP131 job.
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
LP00.1, LP131, LP197
PMN-CW197-RUN-FLG
CW197_RUN_FLG
Alpha 1Indicates the status of the CW197 job.
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete
  • 1 Interactive
  • 2 Updating
  • 3 Reporting
  • 4 Error
  • * Complete

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PMNSET1COMPANY, CYCLE-PROCESS, PROC-GROUP, PROCESS-LEVEL, BANK-CODEPrimaryBN150, BN66.1, HR11.1, HR511, LT101, LT111, PR521, EXI2.1 +22 more (list truncated in source)
PMNSET2COMPANY, CYCLE-PROCESS, PROC-GROUP, PROCESS-LEVEL, BANK-CODEKeyChange, SubsetWhere CYCLE-PROCESS = "2"BN150, PR521, EXI2.1, EXI4.1, LP130, LP900, PR128, PR131 +22 more (list truncated in source)
PMNSET6COMPANY, CYCLE-PROCESS, PROC-GROUP, BANK-CODE, PROCESS-LEVEL

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPMN-COMPANYPRS-COMPANY (PRSSET1), SpacesPRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequiredPMN-COMPANYPRS-COMPANY, PMN-PROCESS-LEVELPRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
Process GroupPRPROCGRPRequiredPMN-COMPANYPRP-COMPANY, PMN-PROC-GROUPPRP-PROC-GROUP, PRP-PROCESS-LEVEL

Programs

Updated by (65)

Referenced by (13)