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.

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
PROCESS_LEVEL
Alpha 5Contains the process Level.LT101, LT111, PA02.1, PA502
POS-DEPARTMENT
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 10LT101, LT111, PA02.1, PA502
POS-BARGAIN-UNIT
BARGAIN_UNIT
Alpha 10LT101, 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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
POSSET1COMPANY, POSITION, EFFECT-DATEPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HLTM.1, HPOS.1, HPQC.1, HPRS.1 +22 more (list truncated in source)
POSSET2COMPANY, POSITION, EFFECT-DATE*BN150, BN305, HCDL.1, HCEM.1, HCHP.1, HCPO.1, HAP3.1, HCRE.1 +22 more (list truncated in source)
POSSET3COMPANY, PROCESS-LEVEL, DEPARTMENT, POSITION, EFFECT-DATE*KeyChangeHPOS.1, PA402, PA80.1
POSSET4COMPANY, POSITION, EFFECT-DATESubsetWhere END-DATE = ZeroesHR11.1, HR511, LT101, LT111, LP100, LP101, LP102, LP103 +22 more (list truncated in source)
POSSET6COMPANY, OBJ-ID, EFFECT-DATEKeyChangeHR93.7

Relations

One to one (19) — lookups and parents

RelationTableRulesConditionField map
Acct CatACACCTCATRequiredWhen (POS-ACCT-CATEGORY != Spaces)POS-ACCT-CATEGORYAAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen (POS-ACTIVITY != Spaces)POS-ACTIVITYACV-ACTIVITY
Assign ResPAASSIGNEDNot RequiredPOS-COMPANYPAA-COMPANY, POS-POSITIONPAA-POSITION, SpacesPAA-PROCESS-LEVEL, SpacesPAA-DEPARTMENT, SpacesPAA-JOB-CODE
Bargain UnitPCODESRequiredWhen POS-BARGAIN-UNIT != Spaces"BU"PCO-TYPE, POS-BARGAIN-UNITPCO-CODE
Base CurrencyCUCODESRequiredWhen POS-CURRENCY-CODE != SpacesPOS-BASE-CURRENCYCUC-CURRENCY-CODE
Chg ReasonPCODESRequiredWhen (POS-CHG-REASON != Spaces)"PO"PCO-TYPE, POS-CHG-REASONPCO-CODE
CompanyPRSYSTEMRequiredPOS-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen POS-CURRENCY-CODE != SpacesPOS-CURRENCY-CODECUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen (POS-DEPARTMENT != Spaces)POS-COMPANYDPT-COMPANY, POS-PROCESS-LEVELDPT-PROCESS-LEVEL, POS-DEPARTMENTDPT-DEPARTMENT
Exp AccountGLMASTERRequiredWhen (POS-EXP-ACCT-UNIT != Spaces) Or (POS-EXP-ACCOUNT != Zeroes)POS-EXP-COMPANYGLM-COMPANY, POS-EXP-ACCT-UNITGLM-ACCT-UNIT, POS-EXP-ACCOUNTGLM-ACCOUNT, POS-EXP-SUB-ACCTGLM-SUB-ACCOUNT
Indir SupvHRSUPERRequiredWhen (POS-SUPERVISOR-IND != Spaces)POS-COMPANYHSU-COMPANY, POS-SUPERVISOR-INDHSU-CODE
Job CodeJOBCODERequiredWhen (POS-JOB-CODE != Spaces)POS-COMPANYJBC-COMPANY, POS-JOB-CODEJBC-JOB-CODE
LocationPCODESRequiredWhen POS-LOCAT-CODE != Spaces"LO"PCO-TYPE, POS-LOCAT-CODEPCO-CODE
Process LevelPRSYSTEMRequiredWhen (POS-PROCESS-LEVEL != Spaces)POS-COMPANYPRS-COMPANY, POS-PROCESS-LEVELPRS-PROCESS-LEVEL
SupervisorHRSUPERRequiredWhen POS-SUPERVISOR != SpacesPOS-COMPANYHSU-COMPANY, POS-SUPERVISORHSU-CODE
Supervisor IndHRSUPERRequiredWhen (POS-SUPERVISOR-IND != Spaces)POS-COMPANYHSU-COMPANY, POS-SUPERVISOR-INDHSU-CODE
Supv LinkHRSUPERRequiredWhen (POS-SUPERVISOR-LNK != Spaces)POS-COMPANYHSU-COMPANY, POS-SUPERVISOR-LNKHSU-CODE
Union CodePCODESRequiredWhen POS-UNION-CODE != Spaces"UN"PCO-TYPE, POS-UNION-CODEPCO-CODE
User LevelPCODESRequiredWhen POS-USER-LEVEL != Spaces"UL"PCO-TYPE, POS-USER-LEVELPCO-CODE

One to many (24) — child tables

RelationTableRulesConditionField map
BudgetPABUDGETPOS-COMPANYPAB-COMPANY, POS-POSITIONPAB-POSITION, PAB-EFFECT-DATE, PAB-PROCESS-LEVEL, PAB-DEPARTMENT, PAB-JOB-CODE
Class PosPACLASSPOSPOS-COMPANYPQP-COMPANY, PQP-POS-CLASS, PQP-POSITION
Emp Pos HistPAEMPPOSPOS-COMPANYPEP-COMPANY, POS-POSITIONPEP-POSITION, PEP-EMPLOYEE, PEP-POS-LEVEL, PEP-EFFECT-DATE
GradePRSAGDTLRequiredWhen (POS-SCHEDULE != Spaces) And (POS-PAY-GRADE != Spaces) And (POS-PAY-STEP = Zeroes)POS-COMPANYSGD-COMPANY, POS-SCHEDULESGD-SCHEDULE, POS-PAY-GRADESGD-PAY-GRADE, SGD-PAY-STEP, SGD-EFFECT-DATE
Hist ErrHISTERRPOS-COMPANYHER-COMPANY, ZeroesHER-EMPLOYEE, POS-OBJ-IDHER-OBJ-ID, HER-EFFECT-DATE, HER-ACTION-CODE, HER-ACTION-NBR, HER-FLD-NBR, HER-SEQ-NBR
Hr Hist DtHRHISTORYDelete CascadesPOS-COMPANYHRH-COMPANY, ZeroesHRH-EMPLOYEE, POS-OBJ-IDHRH-OBJ-ID, ZeroesHRH-POS-LEVEL, POS-EFFECT-DATEHRH-BEG-DATE, HRH-FLD-NBR, HRH-SEQ-NBR
HrhistoryHRHISTORYPOS-COMPANYHRH-COMPANY, ZeroesHRH-EMPLOYEE, POS-OBJ-IDHRH-OBJ-ID, HRH-FLD-NBR, HRH-POS-LEVEL, HRH-BEG-DATE, HRH-SEQ-NBR
Job Auth ApplJOBAUTHPOS-COMPANYJBA-COMPANY, 1JBA-EMP-APP, SpacesJBA-JOB-CODE, POS-POSITIONJBA-POSITION, JBA-EMPLOYEE
Job Auth EmpJOBAUTHPOS-COMPANYJBA-COMPANY, ZeroesJBA-EMP-APP, SpacesJBA-JOB-CODE, POS-POSITIONJBA-POSITION, JBA-EMPLOYEE
Job RelationsJOBRELATEPOS-COMPANYJBR-COMPANY, SpacesJBR-PROCESS-LEVEL, SpacesJBR-JOB-CODE, POS-POSITIONJBR-POSITION, JBR-TYPE, JBR-PERS-CODE, JBR-SUBJECT-CODE
Off LangPAOFFLANGPOS-COMPANYPLA-COMPANY, ZeroesPLA-EMPLOYEE, POS-POSITIONPLA-POSITION, PLA-REPORT-TYPE, PLA-SEQ-NBR
Ot PlanPROVERTIMERequiredWhen (POS-OT-PLAN-CODE != Spaces)POS-COMPANYPRO-COMPANY, POS-OT-PLAN-CODEPRO-PLAN-CODE, PRO-EFFECT-DATE
PaencumberPAENCUMBERPOS-COMPANYPEN-COMPANY, POS-POSITIONPEN-POSITION, SpacesPEN-PROCESS-LEVEL, SpacesPEN-DEPARTMENT, SpacesPEN-JOB-CODE, PEN-EMPLOYEE, PEN-GLT-OBJ-ID, PEN-ATN-OBJ-ID
PathfindPATHFINDPOS-COMPANYPTF-COMPANY, 126PTF-FLD-NBR, POS-POSITIONPTF-FLD-VALUE, PTF-EMPLOYEE, PTF-POS-LEVEL
Pos Chg ErrorPAPOSERRDelete CascadesPOS-COMPANYPPE-COMPANY, POS-POSITIONPPE-POSITION, POS-EFFECT-DATEPPE-EFFECT-DATE, PPE-EMPLOYEE, PPE-REQUISITION, PPE-UPDATE-TYPE
Pos ClassposPACLASSPOSPOS-COMPANYPQP-COMPANY, POS-POSITIONPQP-POSITION, PQP-POS-CLASS
Pos InterestPAJOBINTRSDelete CascadesValid When POS-END-DATE = ZeroesPOS-COMPANYPJI-COMPANY, SpacesPJI-JOB-CODE, POS-POSITIONPJI-POSITION, PJI-EMP-APP, PJI-EMPLOYEE
Pos RulePAPOSRULEPOS-COMPANYPPR-COMPANY, POS-PROCESS-LEVELPPR-PROCESS-LEVEL, POS-DEPARTMENTPPR-DEPARTMENT, PPR-EFFECT-DATE
Pos UserHRPOSUSDDelete CascadesPOS-COMPANYHPD-COMPANY, "1"HPD-TYPE, POS-OBJ-IDHPD-OBJ-ID, POS-EFFECT-DATEHPD-EFFECT-DATE, HPD-FIELD-KEY
PoschangePAPOSCHGDelete CascadesPOS-COMPANYPPC-COMPANY, POS-POSITIONPPC-POSITION, POS-EFFECT-DATEPPC-EFFECT-DATE, PPC-FLD-NBR
RequisitionPAJOBREQPOS-COMPANYPJR-COMPANY, POS-POSITIONPJR-POSITION, PJR-REQUISITION
Step And GradePRSAGDTLRequiredWhen (POS-PAY-STEP != Zeroes)POS-COMPANYSGD-COMPANY, POS-SCHEDULESGD-SCHEDULE, POS-PAY-GRADESGD-PAY-GRADE, POS-PAY-STEPSGD-PAY-STEP, SGD-EFFECT-DATE
User FieldsHRPOSUSDDelete CascadesPOS-COMPANYHPD-COMPANY, "1"HPD-TYPE, POS-OBJ-IDHPD-OBJ-ID, POS-EFFECT-DATEHPD-EFFECT-DATE, HPD-FIELD-KEY
Work SchedHRWRKSCHDValid When (POS-WORK-SCHED != Spaces)POS-COMPANYWSC-COMPANY, POS-WORK-SCHEDWSC-WORK-SCHED, WSC-CONTRACT-YEAR, WSC-EFFECT-DATE

Programs

Updated by (11)

Referenced by (257)