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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PPC-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-EFFECT-DATE PKEFFECT_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 PKPOSITION | 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 PKFLD_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-DATEEND_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-TYPEUPDATE_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.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-A-VALUE-PRIORA_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-VALUEA_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-PRIORN_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-VALUEN_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-DATERETRO_DATE | Numeric 8 (yyyymmdd) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-HIST-CORR-TYPEHIST_CORR_TYPE | Alpha 1 | —
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-HIST-CORR-FLAGHIST_CORR_FLAG | Alpha 2 | —
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-CREATE-USERCREATE_USER | Alpha 10 (Lower Case) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-UPDATE-TIMEUPDATE_TIME | Numeric 6 (hhmmss) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
#PPC-UPDATE-USERUPDATE_USER | Alpha 10 (Lower Case) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PPCSET1 |
| 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 |
| ||||||||||
| Field Nbr | PADICT | Required | When (PPC-FLD-NBR != Zeroes) |
| |||||||||
| Position | PAPOSITION | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pos Chg Error | PAPOSERR | Delete Cascades |
|
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