PAPOSCHG – Position Changes

System: Personnel (PA)
Prefix: PPC
Primary key: COMPANY, POSITION, EFFECT-DATE, FLD-NBR
Fields: 19
Updated by: 39 programs
Referenced by: 0 programs

PAPOSCHG is the Position Changes table in Lawson Personnel (prefix PPC). It is indexed by COMPANY, POSITION, EFFECT-DATE, FLD-NBR (PPCSET1). It is related 1:1 to PRSYSTEM, PADICT and PAPOSITION and 1:M to PAPOSERR. It is updated by BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 and 31 more. The table has 19 fields, 1 index and 4 documented relations.

About PAPOSCHG

No description in the Lawson data dictionary.

Fields (19)

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

Field / column	Type	Description & values	Updated by
`PPC-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the effective date for the position.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-POSITION` PK POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-FLD-NBR` PK FLD_NBR	Numeric 4	This field contains the PO dictionary field number.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	Contains the last date for the position.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-UPDATE-TYPE` UPDATE_TYPE	Alpha 3	Indicates whether the update was due to a data change or an end date addition. Data changes include the field number of the position changed. `1` Data Chg `2` End Date	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-A-VALUE-PRIOR` A_VALUE_PRIOR	Alpha 30 (Lower Case)	Contains the value of any alpha field of the position before the change.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-A-VALUE` A_VALUE	Alpha 30 (Lower Case)	Contains the value of the any alpha field of the position after the change.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-N-VALUE-PRIOR` N_VALUE_PRIOR	Signed 13.4	Contains the value of any numeric field of the position before the change.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-N-VALUE` N_VALUE	Signed 15.6	Contains the value of any numeric field for the position after the change.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-RETRO-DATE` RETRO_DATE	Numeric 8 (yyyymmdd)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-HIST-CORR-TYPE` HIST_CORR_TYPE	Alpha 1	— `2` Retroactive Change `4` Reverse	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-HIST-CORR-FLAG` HIST_CORR_FLAG	Alpha 2	— `2` Delete `3` Move to Hist Error	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-CREATE-USER` CREATE_USER	Alpha 10 (Lower Case)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-UPDATE-DATE` UPDATE_DATE	Numeric 8 (yyyymmdd)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-UPDATE-TIME` UPDATE_TIME	Numeric 6 (hhmmss)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
`PPC-UPDATE-USER` UPDATE_USER	Alpha 10 (Lower Case)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more

Indexes (1)

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
`PPCSET1`	`COMPANY`, `POSITION`, `EFFECT-DATE`, `FLD-NBR`	Primary		BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PPC-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Field Nbr	PADICT	Required	When (PPC-FLD-NBR != Zeroes)	`PPC-FLD-NBR` → `PAD-FLD-NBR`
Position	PAPOSITION	Required		`PPC-COMPANY` → `POS-COMPANY`, `PPC-POSITION` → `POS-POSITION`, `PPC-EFFECT-DATE` → `POS-EFFECT-DATE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Pos Chg Error	PAPOSERR	Delete Cascades		`PPC-COMPANY` → `PPE-COMPANY`, `PPC-POSITION` → `PPE-POSITION`, `PPC-EFFECT-DATE` → `PPE-EFFECT-DATE`, → `PPE-EMPLOYEE`, → `PPE-REQUISITION`, → `PPE-UPDATE-TYPE`

Programs

Updated by (39)

BN305 Highly Compensated Employees
HR00.1 Company
HR01.1 Process Level
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA03.1 Position Change
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA302 Position Purge
PA42.1 Requisition
PA42.3 Requisition Approval Override
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA535 e-Recruiting Requisition Conversion
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP