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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PMN-COMPANY PK
COMPANY		Numeric 4—BN66.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 10—BN66.1, LP140, LP145, PR140, PR160, PR180, PR189, PR195 +4 more
#PMN-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—BN66.1, LP130, LP131, LP140, LP145, PR140, PR160, PR180 +7 more
#PMN-BANK-CODE PK
BANK_CODE		Alpha 4—BN66.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 1—PR00.1
#PMN-PR198-RUN-FLG
PR198_RUN_FLG		Alpha 1—PR00.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 8—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PMN-END-CHECK-NBR
END_CHECK_NBR		Numeric 8—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PMN-BEG-RECPT-NBR
BEG_RECPT_NBR		Numeric 8—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#PMN-END-RECPT-NBR
END_RECPT_NBR		Numeric 8—BN66.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 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
PMNSET1
  1. COMPANY
  2. CYCLE-PROCESS
  3. PROC-GROUP
  4. PROCESS-LEVEL
  5. BANK-CODE
PrimaryBN150, BN66.1, HR11.1, HR511, LT101, LT111, PR521, EXI2.1 +22 more (list truncated in source)
PMNSET2
  1. COMPANY
  2. CYCLE-PROCESS
  3. PROC-GROUP
  4. PROCESS-LEVEL
  5. BANK-CODE
KeyChange, SubsetWhere CYCLE-PROCESS = "2"BN150, PR521, EXI2.1, EXI4.1, LP130, LP900, PR128, PR131 +22 more (list truncated in source)
PMNSET6
  1. COMPANY
  2. CYCLE-PROCESS
  3. PROC-GROUP
  4. BANK-CODE
  5. PROCESS-LEVEL
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPRPROCGRPPRMONITOR

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PMN-COMPANY→PRS-COMPANY (PRSSET1)
Spaces→PRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequired
PMN-COMPANY→PRS-COMPANY
PMN-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
Process GroupPRPROCGRPRequired
PMN-COMPANY→PRP-COMPANY
PMN-PROC-GROUP→PRP-PROC-GROUP
—→PRP-PROCESS-LEVEL

Programs

Updated by (65)

Referenced by (13)