PAOFFLANG – No description in the Lawson data dictionary

System: Personnel (PA)
Prefix: PLA
Primary key: COMPANY, EMPLOYEE, POSITION, REPORT-TYPE, SEQ-NBR
Fields: 10
Updated by: 10 programs
Referenced by: 2 programs

PAOFFLANG is a Lawson Personnel table (prefix PLA); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, POSITION, REPORT-TYPE, SEQ-NBR (PLASET1); alternate indexes: PLASET2. It is related 1:1 to PRSYSTEM, EMPLOYEE, PCODES and PAEMPLOYEE and 1:M to PAPOSITION. It is updated by HR00.1, HR01.1, HR11.1, LT101, LT111, PA02.1, PA115, PA302 and 2 more and referenced by PA296 and PA496. The table has 10 fields, 2 indexes and 6 documented relations.

About PAOFFLANG

No description in the Lawson data dictionary.

Fields (10)

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

Field / column	Type	Description & values	Updated by
`PLA-COMPANY` PK COMPANY	Numeric 4	—	PA96.1
`PLA-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	PA96.1
`PLA-POSITION` PK POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	PA96.1
`PLA-REPORT-TYPE` PK REPORT_TYPE	Alpha 1	— `1` Service to Public `2` Internal Services `3` Supervision	PA96.1
`PLA-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	PA96.1
`PLA-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	—	PA96.1
`PLA-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for this effort period.	PA96.1
`PLA-TYPE` TYPE	Alpha 2	This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. `BO` Bilingual Office `BR` Billingual Region	PA96.1
`PLA-CODE` CODE	Alpha 10	Code that is valid for the specified record type.	PA96.1
`PLA-DATE` DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	PA96.1

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`PLASET1`	`COMPANY`, `EMPLOYEE`, `POSITION`, `REPORT-TYPE`, `SEQ-NBR`	Primary		HR00.1, HR01.1, HR11.1, LT101, LT111, PA02.1, PA115, PA302 +3 more
`PLASET2`	`COMPANY`, `EMPLOYEE`, `POSITION`, `REPORT-TYPE`, `DATE*`, `SEQ-NBR`	KeyChange		PA296, PA96.1

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PLA-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	When PLA-EMPLOYEE != Zeroes	`PLA-COMPANY` → `EMP-COMPANY`, `PLA-EMPLOYEE` → `EMP-EMPLOYEE`
Office	PCODES	Required	When PLA-TYPE = "BO"	`PLA-TYPE` → `PCO-TYPE`, `PLA-CODE` → `PCO-CODE`
Paemployee	PAEMPLOYEE	Required	When PLA-EMPLOYEE != Zeroes	`PLA-COMPANY` → `PEM-COMPANY`, `PLA-EMPLOYEE` → `PEM-EMPLOYEE`
Region	PCODES	Required	When PLA-TYPE = "BR"	`PLA-TYPE` → `PCO-TYPE`, `PLA-CODE` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Position	PAPOSITION		Valid When PLA-POSITION != Spaces	`PLA-COMPANY` → `POS-COMPANY`, `PLA-POSITION` → `POS-POSITION`, → `POS-EFFECT-DATE`

Programs

Updated by (10)

HR00.1 Company
HR01.1 Process Level
HR11.1 Employee
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA115 Employee Purge
PA302 Position Purge
PA502 Position Conversion
PA96.1 Official Languages Bilingual Requirements

Referenced by (2)

PA296 Canadian Language Bilingual Requirements Listing
PA496 Official Languages Report