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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PBGSET1COMPANY, PROCESS-LEVEL, BUS-NBR-GRPPrimaryBN150, BN305, BN55.2, BN555, BN66.1, HPBG.1, HR00.1, HR00.2 +22 more (list truncated in source)
PBGSET2COMPANY, BUS-NBR-GRP, PROCESS-LEVELHR00.1, HR00.2, HR01.1, PR11.4, PR127, PR240, PR241, PR242 +8 more

Programs

Updated by (3)

Referenced by (98)