PRBUSGRP – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PBG
Primary key
COMPANY, PROCESS-LEVEL, BUS-NBR-GRP
Fields
7
Updated by
3 programs
Referenced by
98 programs

PRBUSGRP is a Lawson Payroll table (prefix PBG); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, BUS-NBR-GRP (PBGSET1); alternate indexes: PBGSET2. It is updated by HR00.1, HR00.2 and HR01.1 and referenced by BN150, BN305, BN55.2, BN555, BN66.1, EXI2.1, EXI4.1, HPBG.1 and 90 more. The table has 7 fields, 2 indexes and 0 documented relations.

About PRBUSGRP

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the PBG- 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
#PBG-COMPANY PK
COMPANY
Numeric 4—HR00.1, HR00.2, HR01.1
#PBG-PROCESS-LEVEL PK
PROCESS_LEVEL
Alpha 5—HR00.1, HR00.2, HR01.1
#PBG-BUS-NBR-GRP PK
BUS_NBR_GRP
Alpha 4—HR00.1, HR00.2, HR01.1
#PBG-BUS-NBR
BUS_NBR
Alpha 15—HR00.1, HR00.2, HR01.1
#PBG-CA-BSI-COMPANY
CA_BSI_COMPANY
Alpha 11—HR00.1, HR00.2, HR01.1
#PBG-LOCAL-OFF
LOCAL_OFF
Alpha 4Refers to a Human Resource Centre of Canada number. It helps to associate a hiring with the proper employer name and address.HR00.2
#PBG-PAY-LOCATOR
PAY_LOCATOR
Alpha 4Pay Locator is used to identify separate pay centers (plants, branches, stores, or subsidiaries) when the same employer number is used to report hiring for numerous pay centers.HR00.2

Indexes (2)

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
PBGSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. BUS-NBR-GRP
PrimaryBN150, BN305, BN55.2, BN555, BN66.1, HPBG.1, HR00.1, HR00.2 +22 more (list truncated in source)
PBGSET2
  1. COMPANY
  2. BUS-NBR-GRP
  3. PROCESS-LEVEL
HR00.1, HR00.2, HR01.1, PR11.4, PR127, PR240, PR241, PR242 +8 more

Programs

Updated by (3)

Referenced by (98)