PAPOSITION – Positions

System
Personnel (PA)
Prefix
POS
Primary key
COMPANY, POSITION, EFFECT-DATE
Fields
52
Updated by
11 programs
Referenced by
257 programs

PAPOSITION is the Positions table in Lawson Personnel (prefix POS). It is indexed by COMPANY, POSITION, EFFECT-DATE (POSSET1); alternate indexes: POSSET2, POSSET3, POSSET4 and POSSET6. It is related 1:1 to ACACCTCAT, ACACTIVITY, PAASSIGNED, PCODES, CUCODES, PRSYSTEM, DEPTCODE, GLMASTER and 2 more and 1:M to PABUDGET, PACLASSPOS, PAEMPPOS, PRSAGDTL, HISTERR, HRHISTORY, JOBAUTH, JOBRELATE and 11 more. It is updated by HR00.1, HR01.1, LP130, LP198, LP31.1, LT101, LT111, PA02.1 and 3 more and referenced by BN150, BN305, EXI2.1, EXI4.1, HAP3.1, HCDL.1, HCEM.1, HCHP.1 and 249 more. The table has 52 fields, 5 indexes and 43 documented relations.

About PAPOSITION

The Personnel Position Parameters file contains information for each position.

Fields (52)

Column = COBOL field name without the POS- 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
#POS-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.LT101, LT111, PA02.1, PA170, PA371, PA502
#POS-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.LT101, LT111, PA02.1, PA170, PA371, PA502
#POS-DESCRIPTION
DESCRIPTION		Alpha 60 (Lower Case)Contains the description of the position.LT101, LT111, PA02.1, PA102, PA502
#POS-POSIT-STATUS
POSIT_STATUS		Numeric 1Contains a value that indicates the status of a position.
  • 1 Active
  • 2 Temporary
  • 3 Frozen
  • 4 Proposed
  • 5 Inactive
LT101, LT111, PA02.1, PA502
#POS-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date the position is available to be used.LT101, LT111, PA02.1, PA170, PA371, PA502
#POS-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the ending date when the position is no longer available to be used.LT101, LT111, PA02.1, PA102, PA502
#POS-JOB-CODE
JOB_CODE		Alpha 9Contains the job code.LT101, LT111, PA02.1, PA262, PA263, PA502
#POS-PROCESS-LEVEL SET3
PROCESS_LEVEL		Alpha 5Contains the process Level.LT101, LT111, PA02.1, PA502
#POS-DEPARTMENT SET3
DEPARTMENT		Alpha 5Contains the department.LT101, LT111, PA02.1, PA502
#POS-USER-LEVEL
USER_LEVEL		Alpha 10Contains the user level.LT101, LT111, PA02.1, PA502
#POS-EXP-COMPANY
EXP_COMPANY		Numeric 4Contains the general ledger expense company.LT101, LT111, PA02.1, PA502
#POS-EXP-ACCT-UNIT
EXP_ACCT_UNIT		Alpha 15Contains the expense account unit.LT101, LT111, PA02.1, PA502
#POS-EXP-ACCOUNT
EXP_ACCOUNT		Numeric 6Contains the expense account.LT101, LT111, PA02.1, PA502
#POS-EXP-SUB-ACCT
EXP_SUB_ACCT		Numeric 4Contains the expense subaccount.LT101, LT111, PA02.1, PA502
#POS-PAY-RATE
PAY_RATE		Signed 13.4Contains the rate of pay for a position. This can be an annual amount or an hourly amount.LT101, LT111, PA02.1, PA502
#POS-SALARY-CLASS
SALARY_CLASS		Alpha 1Contains the code that indicates whether the rate of pay is hourly or salaried.
  • H Hourly
  • S Salaried
LT101, LT111, PA02.1, PA502
#POS-PAY-FREQUENCY
PAY_FREQUENCY		Numeric 1Contains the pay frequency.
  • 1 Weekly
  • 2 Biweekly
  • 3 Semimonthly
  • 4 Monthly
  • 5 UK Four-Weekly
LT101, LT111, PA02.1, PA502
#POS-SCHEDULE
SCHEDULE		Alpha 9Contains the step and grade schedule or the grade range schedule.LT101, LT111, PA02.1, PA502
#POS-PAY-GRADE
PAY_GRADE		Alpha 3Contains the appropriate grade if the position is paid based on a step and grade schedule or is assigned to a grade range schedule.LT101, LT111, PA02.1, PA502
#POS-PAY-STEP
PAY_STEP		Numeric 2Contains the appropriate step if the position is based on a step and grade schedule.LT101, LT111, PA02.1, PA502
#POS-SUPERVISOR
SUPERVISOR		Alpha 10Contains the supervisor code that identifies the supervisor to whom the position reports.LT101, LT111, PA02.1, PA502
#POS-SHIFT
SHIFT		Numeric 1Contains the shift with which the position's pay is associated.
  • 1 Shift 1
  • 2 Shift 2
  • 3 Shift 3
  • 4 Shift 4
  • 5 Shift 5
  • 6 Shift 6
  • 7 Shift 7
  • 8 Shift 8
  • 9 Shift 9
LT101, LT111, PA02.1, PA502
#POS-UPDATE-FLAG
UPDATE_FLAG		Alpha 1Contains a yes or no value that indicates when the user would like to update employee and requisition records to reflect changes being made to the position. If the user selects Yes, updates will be made to employee and requisition records when the change is complete. If the user selects No, an update program must be run to update records with the changes.
  • Y Needs to be Updated
LT101, LT111, PA02.1, PA102, PA502
#POS-LOCAT-CODE
LOCAT_CODE		Alpha 10Contains the default location at which this position works.LT101, LT111, PA02.1, PA502
#POS-UNION-CODE
UNION_CODE		Alpha 10—LT101, LT111, PA02.1, PA502
#POS-BARGAIN-UNIT
BARGAIN_UNIT		Alpha 10—LT101, LT111, PA02.1, PA502
#POS-CHG-REASON
CHG_REASON		Alpha 10Contains the reason for a change to a position.LT101, LT111, PA02.1, PA502
#POS-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.LT101, LT111, PA02.1, PA502
#POS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruLT101, LT111, PA02.1, PA502
#POS-OT-PLAN-CODE
OT_PLAN_CODE		Alpha 4Contains the pay plan with which the position is associated.LT101, LT111, PA02.1, PA502
#POS-SUPERVISOR-IND
SUPERVISOR_IND		Alpha 10Contains the supervisor code that identifies the supervisor to whom the position indirectly reports.LT101, LT111, PA02.1, PA502
#POS-SUPERVISOR-LNK
SUPERVISOR_LNK		Alpha 10Contains the supervisor code to which the position is linked. Changes to the incumbents of this position will result in an update to the employee assigned to the supervisor code.LT101, LT111, PA02.1, PA502
#POS-WORK-SCHED
WORK_SCHED		Alpha 10Contains the default work schedule for this position.LT101, LT111, PA02.1, PA502
#POS-EXEMPT-EMP
EXEMPT_EMP		Alpha 1Contains a value that indicates if the rate of pay is hourly or salaried.
  • Y Yes
  • N No
LT101, LT111, PA02.1, PA502
#POS-SEC-LVL
SEC_LVL		Numeric 1Contains a number between 1 and 9 that indicates the security level for this position.LT101, LT111, PA02.1, PA502
#POS-SEC-LOCATION
SEC_LOCATION		Alpha 10Contains the security location that is used in combination with the security level to define employee and data item security. Location can represent a physical location, or it can represent a group of employees, such as hourly or salaried employees.LT101, LT111, PA02.1, PA502
#POS-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)Contains the date (month, day, and year) a change was made to the record.LT101, LT111, PA02.1, PA502
#POS-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the time (hour, minute, and second) that a change was made to the record.LT101, LT111, PA02.1, PA502
#POS-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the user ID of a user who has made changes to the record.LT101, LT111, PA02.1, PA502
#POS-OBJ-ID SET6
OBJ_ID		Numeric 12This is the object identifier.LT101, LT111, PA02.1, PA502
#POS-ANNUAL-HOURS
ANNUAL_HOURS		Signed 8.4Contains the annual hours for the position.LT101, LT111, PA02.1, PA502
#POS-SHORT-DESC
SHORT_DESC		DerivedA short description.—
#POS-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the pay is recorded.LT101, LT111, PA02.1, PA502
#POS-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.LT101, LT111, PA02.1, PA502
#POS-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company's base currency.LT101, LT111, PA02.1, PA502
#POS-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.LT101, LT111, PA02.1, PA502
#POS-BASE-PAY-RATE
BASE_PAY_RATE		Signed 13.4Contains the pay in the company's base currency.LT101, LT111, PA02.1, PA502
#POS-ENCUMBER-FLAG
ENCUMBER_FLAG		Alpha 1" " = No
  • N No
  • Y Yes
LT101, LT111, PA02.1, PA502
#POS-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—LT101, LT111, PA02.1, PA502
#POS-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—LT101, LT111, PA02.1, PA502
#POS-CREATE-USER
CREATE_USER		Alpha 10 (Lower Case)—LT101, LT111, PA02.1, PA502
#POS-UPDATED-BY-LTM
UPDATED_BY_LTM		Alpha 1—
  • Y Yes
  • N No
—

Indexes (5)

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
POSSET1
  1. COMPANY
  2. POSITION
  3. EFFECT-DATE
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
POSSET2
  1. COMPANY
  2. POSITION
  3. EFFECT-DATE ↓
BN150, BN305, HCDL.1, HCEM.1, HCHP.1, HCPO.1, HAP3.1, HCRE.1 +22 more (list truncated in source)
POSSET3
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. POSITION
  5. EFFECT-DATE ↓
KeyChangeHPOS.1, PA402, PA80.1
POSSET4
  1. COMPANY
  2. POSITION
  3. EFFECT-DATE
SubsetWhere END-DATE = ZeroesHR11.1, HR511, LT101, LT111, LP100, LP101, LP102, LP103 +22 more (list truncated in source)
POSSET6
  1. COMPANY
  2. OBJ-ID
  3. EFFECT-DATE
KeyChangeHR93.7

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYPAASSIGNEDPCODESCUCODESPRSYSTEMDEPTCODEGLMASTERHRSUPERJOBCODEPABUDGETPACLASSPOSPAEMPPOSPRSAGDTLHISTERRHRHISTORYJOBAUTHJOBRELATEPAOFFLANGPROVERTIMEPAENCUMBERPATHFINDPAPOSERRPAJOBINTRS+5 more belowPAPOSITION

One to one (19) — lookups and parents

RelationTableRulesConditionField map
Acct CatACACCTCATRequiredWhen (POS-ACCT-CATEGORY != Spaces)
POS-ACCT-CATEGORY→AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen (POS-ACTIVITY != Spaces)
POS-ACTIVITY→ACV-ACTIVITY
Assign ResPAASSIGNEDNot Required
POS-COMPANY→PAA-COMPANY
POS-POSITION→PAA-POSITION
Spaces→PAA-PROCESS-LEVEL
Spaces→PAA-DEPARTMENT
Spaces→PAA-JOB-CODE
Bargain UnitPCODESRequiredWhen POS-BARGAIN-UNIT != Spaces
"BU"→PCO-TYPE
POS-BARGAIN-UNIT→PCO-CODE
Base CurrencyCUCODESRequiredWhen POS-CURRENCY-CODE != Spaces
POS-BASE-CURRENCY→CUC-CURRENCY-CODE
Chg ReasonPCODESRequiredWhen (POS-CHG-REASON != Spaces)
"PO"→PCO-TYPE
POS-CHG-REASON→PCO-CODE
CompanyPRSYSTEMRequired
POS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen POS-CURRENCY-CODE != Spaces
POS-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen (POS-DEPARTMENT != Spaces)
POS-COMPANY→DPT-COMPANY
POS-PROCESS-LEVEL→DPT-PROCESS-LEVEL
POS-DEPARTMENT→DPT-DEPARTMENT
Exp AccountGLMASTERRequiredWhen (POS-EXP-ACCT-UNIT != Spaces) Or (POS-EXP-ACCOUNT != Zeroes)
POS-EXP-COMPANY→GLM-COMPANY
POS-EXP-ACCT-UNIT→GLM-ACCT-UNIT
POS-EXP-ACCOUNT→GLM-ACCOUNT
POS-EXP-SUB-ACCT→GLM-SUB-ACCOUNT
Indir SupvHRSUPERRequiredWhen (POS-SUPERVISOR-IND != Spaces)
POS-COMPANY→HSU-COMPANY
POS-SUPERVISOR-IND→HSU-CODE
Job CodeJOBCODERequiredWhen (POS-JOB-CODE != Spaces)
POS-COMPANY→JBC-COMPANY
POS-JOB-CODE→JBC-JOB-CODE
LocationPCODESRequiredWhen POS-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
POS-LOCAT-CODE→PCO-CODE
Process LevelPRSYSTEMRequiredWhen (POS-PROCESS-LEVEL != Spaces)
POS-COMPANY→PRS-COMPANY
POS-PROCESS-LEVEL→PRS-PROCESS-LEVEL
SupervisorHRSUPERRequiredWhen POS-SUPERVISOR != Spaces
POS-COMPANY→HSU-COMPANY
POS-SUPERVISOR→HSU-CODE
Supervisor IndHRSUPERRequiredWhen (POS-SUPERVISOR-IND != Spaces)
POS-COMPANY→HSU-COMPANY
POS-SUPERVISOR-IND→HSU-CODE
Supv LinkHRSUPERRequiredWhen (POS-SUPERVISOR-LNK != Spaces)
POS-COMPANY→HSU-COMPANY
POS-SUPERVISOR-LNK→HSU-CODE
Union CodePCODESRequiredWhen POS-UNION-CODE != Spaces
"UN"→PCO-TYPE
POS-UNION-CODE→PCO-CODE
User LevelPCODESRequiredWhen POS-USER-LEVEL != Spaces
"UL"→PCO-TYPE
POS-USER-LEVEL→PCO-CODE

One to many (24) — child tables

RelationTableRulesConditionField map
BudgetPABUDGET
POS-COMPANY→PAB-COMPANY
POS-POSITION→PAB-POSITION
—→PAB-EFFECT-DATE
—→PAB-PROCESS-LEVEL
—→PAB-DEPARTMENT
—→PAB-JOB-CODE
Class PosPACLASSPOS
POS-COMPANY→PQP-COMPANY
—→PQP-POS-CLASS
—→PQP-POSITION
Emp Pos HistPAEMPPOS
POS-COMPANY→PEP-COMPANY
POS-POSITION→PEP-POSITION
—→PEP-EMPLOYEE
—→PEP-POS-LEVEL
—→PEP-EFFECT-DATE
GradePRSAGDTLRequiredWhen (POS-SCHEDULE != Spaces) And (POS-PAY-GRADE != Spaces) And (POS-PAY-STEP = Zeroes)
POS-COMPANY→SGD-COMPANY
POS-SCHEDULE→SGD-SCHEDULE
POS-PAY-GRADE→SGD-PAY-GRADE
—→SGD-PAY-STEP
—→SGD-EFFECT-DATE
Hist ErrHISTERR
POS-COMPANY→HER-COMPANY
Zeroes→HER-EMPLOYEE
POS-OBJ-ID→HER-OBJ-ID
—→HER-EFFECT-DATE
—→HER-ACTION-CODE
—→HER-ACTION-NBR
—→HER-FLD-NBR
—→HER-SEQ-NBR
Hr Hist DtHRHISTORYDelete Cascades
POS-COMPANY→HRH-COMPANY
Zeroes→HRH-EMPLOYEE
POS-OBJ-ID→HRH-OBJ-ID
Zeroes→HRH-POS-LEVEL
POS-EFFECT-DATE→HRH-BEG-DATE
—→HRH-FLD-NBR
—→HRH-SEQ-NBR
HrhistoryHRHISTORY
POS-COMPANY→HRH-COMPANY
Zeroes→HRH-EMPLOYEE
POS-OBJ-ID→HRH-OBJ-ID
—→HRH-FLD-NBR
—→HRH-POS-LEVEL
—→HRH-BEG-DATE
—→HRH-SEQ-NBR
Job Auth ApplJOBAUTH
POS-COMPANY→JBA-COMPANY
1→JBA-EMP-APP
Spaces→JBA-JOB-CODE
POS-POSITION→JBA-POSITION
—→JBA-EMPLOYEE
Job Auth EmpJOBAUTH
POS-COMPANY→JBA-COMPANY
Zeroes→JBA-EMP-APP
Spaces→JBA-JOB-CODE
POS-POSITION→JBA-POSITION
—→JBA-EMPLOYEE
Job RelationsJOBRELATE
POS-COMPANY→JBR-COMPANY
Spaces→JBR-PROCESS-LEVEL
Spaces→JBR-JOB-CODE
POS-POSITION→JBR-POSITION
—→JBR-TYPE
—→JBR-PERS-CODE
—→JBR-SUBJECT-CODE
Off LangPAOFFLANG
POS-COMPANY→PLA-COMPANY
Zeroes→PLA-EMPLOYEE
POS-POSITION→PLA-POSITION
—→PLA-REPORT-TYPE
—→PLA-SEQ-NBR
Ot PlanPROVERTIMERequiredWhen (POS-OT-PLAN-CODE != Spaces)
POS-COMPANY→PRO-COMPANY
POS-OT-PLAN-CODE→PRO-PLAN-CODE
—→PRO-EFFECT-DATE
PaencumberPAENCUMBER
POS-COMPANY→PEN-COMPANY
POS-POSITION→PEN-POSITION
Spaces→PEN-PROCESS-LEVEL
Spaces→PEN-DEPARTMENT
Spaces→PEN-JOB-CODE
—→PEN-EMPLOYEE
—→PEN-GLT-OBJ-ID
—→PEN-ATN-OBJ-ID
PathfindPATHFIND
POS-COMPANY→PTF-COMPANY
126→PTF-FLD-NBR
POS-POSITION→PTF-FLD-VALUE
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
Pos Chg ErrorPAPOSERRDelete Cascades
POS-COMPANY→PPE-COMPANY
POS-POSITION→PPE-POSITION
POS-EFFECT-DATE→PPE-EFFECT-DATE
—→PPE-EMPLOYEE
—→PPE-REQUISITION
—→PPE-UPDATE-TYPE
Pos ClassposPACLASSPOS
POS-COMPANY→PQP-COMPANY
POS-POSITION→PQP-POSITION
—→PQP-POS-CLASS
Pos InterestPAJOBINTRSDelete CascadesValid When POS-END-DATE = Zeroes
POS-COMPANY→PJI-COMPANY
Spaces→PJI-JOB-CODE
POS-POSITION→PJI-POSITION
—→PJI-EMP-APP
—→PJI-EMPLOYEE
Pos RulePAPOSRULE
POS-COMPANY→PPR-COMPANY
POS-PROCESS-LEVEL→PPR-PROCESS-LEVEL
POS-DEPARTMENT→PPR-DEPARTMENT
—→PPR-EFFECT-DATE
Pos UserHRPOSUSDDelete Cascades
POS-COMPANY→HPD-COMPANY
"1"→HPD-TYPE
POS-OBJ-ID→HPD-OBJ-ID
POS-EFFECT-DATE→HPD-EFFECT-DATE
—→HPD-FIELD-KEY
PoschangePAPOSCHGDelete Cascades
POS-COMPANY→PPC-COMPANY
POS-POSITION→PPC-POSITION
POS-EFFECT-DATE→PPC-EFFECT-DATE
—→PPC-FLD-NBR
RequisitionPAJOBREQ
POS-COMPANY→PJR-COMPANY
POS-POSITION→PJR-POSITION
—→PJR-REQUISITION
Step And GradePRSAGDTLRequiredWhen (POS-PAY-STEP != Zeroes)
POS-COMPANY→SGD-COMPANY
POS-SCHEDULE→SGD-SCHEDULE
POS-PAY-GRADE→SGD-PAY-GRADE
POS-PAY-STEP→SGD-PAY-STEP
—→SGD-EFFECT-DATE
User FieldsHRPOSUSDDelete Cascades
POS-COMPANY→HPD-COMPANY
"1"→HPD-TYPE
POS-OBJ-ID→HPD-OBJ-ID
POS-EFFECT-DATE→HPD-EFFECT-DATE
—→HPD-FIELD-KEY
Work SchedHRWRKSCHDValid When (POS-WORK-SCHED != Spaces)
POS-COMPANY→WSC-COMPANY
POS-WORK-SCHED→WSC-WORK-SCHED
—→WSC-CONTRACT-YEAR
—→WSC-EFFECT-DATE

Programs

Updated by (11)

Referenced by (257)