Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PAPOSITION FILE

                               Positions

The Personnel Position Parameters file contains information for each position.

REFERENCED BY

HR14.1    HR15.1    HR15.2    HR155     HR170     HR211
HR511     HR514     HR515     HR54.1    HR55.2    HR650
HR70.1    HRS1.1    HRSC.1    PA01.1    PA01.2    PA01.3
PA03.1    PA03.2    PA08.1    PA08.2    PA08.3    PA11.1
PA111     PA120     PA16.1    PA170     PA172     PA201
PA23.1    PA231     PA242     PA262     PA263     PA272
PA31.1    PA37.1    PA371     PA406     PA41.1    PA42.1
PA513     PA53.1    PA532     PA54.1    PA570     PA62.1
PA63.1    PA64.2    PA65.2    PA66.3    PA70.1    PA72.1
PA79.1    TR22.1    TR500     HS01.1    HS34.1    HS36.1
PR13.1    PR13.5    PR13.6    PR13.8    PR30.1    AC541
AC542     BN150     HCEM.1    HCOP.1    HCPO.1    HR217
HR220     HS10.1    HS10.2    HS11.1    HS50.1    HS50.2
HS50.5    PA149     PA202     PA208     PA211     PA241
PA248     PA249     PA271     PA296     PA311     PA48.3
PA48.4    PA531     PA96.1    PR128     PR131     PR132
PR134     PR136     PR223     PR23.3    PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR530     PR82.1    PR82.2
UK102     TM240     TM245     TM470     UK120     UK60.1
UK70.1    HPOS.1    PA402     PA80.1    HS51.1    HS51.2
HS52.1    HS52.2    TR120     TR121     TR20.1    TR20.2
TR20.3

UPDATED BY

PA302     PA502     HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

POS-COMPANY          Numeric 4                                   PA170   PA371
Company              Contains the company number which           PA502
                     represents an established company.

POS-POSITION         Alpha 12                                    PA170   PA371
Position             Contains the user-defined code that         PA502
                     represents a position in the company.

POS-DESCRIPTION      Alpha 30  (Lower Case)                      PA502
Description          Contains the description of the
                     position.

POS-POSIT-STATUS     Numeric 1                                   PA502   PA62.1
Position Status      Contains a value that indicates the         PA63.1
                     status of a position.
                     1 = Active
                     2 = Temporary
                     3 = Frozen
                     4 = Proposed
                     5 = Inactive

POS-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA170   PA371
Effective Date       Contains the date the position is           PA502
                     available to be used.

POS-END-DATE         Numeric 8  (yyyymmdd)                       PA502
End Date             Contains the ending date when the
                     position is no longer available to be
                     used.

POS-JOB-CODE         Alpha 9                                     PA262   PA263
Job Code             Contains the job code.                      PA502

POS-PROCESS-LEVEL    Alpha 5                                     PA502
Process Level        Contains the process Level.

POS-DEPARTMENT       Alpha 5                                     PA502
Department           Contains the department.

POS-USER-LEVEL       Alpha 10                                    PA502
User Level           Contains the user level.

POS-EXP-COMPANY      Numeric 4                                   PA502
Expense Company      Contains the general ledger expense
                     company.

POS-EXP-ACCT-UNIT    Alpha 15                                    PA502
Expense Accounting   Contains the expense account unit.
Unit

POS-EXP-ACCOUNT      Numeric 6                                   PA502
Expense Account      Contains the expense account.

POS-EXP-SUB-ACCT     Numeric 4                                   PA502
Expense Subaccount   Contains the expense subaccount.

POS-PAY-RATE         Signed 13.4                                 PA502
Pay Rate             Contains the rate of pay for a
                     position. This can be an annual amount
                     or an hourly amount.

POS-SALARY-CLASS     Alpha 1                                     PA502
Salary Class         Contains the code that indicates
                     whether the rate of pay is hourly or
                     salaried.
                     H = Hourly
                     S = Salaried

POS-PAY-FREQUENCY    Numeric 1                                   PA502
Pay Frequency        Contains the pay frequency.
                     1 = Weekly
                     2 = Biweekly
                     3 = Semimonthly
                     4 = Monthly

POS-SCHEDULE         Alpha 9                                     PA502
Schedule             Contains the step and grade schedule or
                     the grade range schedule.

POS-PAY-GRADE        Alpha 3                                     PA502
Pay Grade            Contains the appropriate grade if the
                     position is paid based on a step and
                     grade schedule or is assigned to a grade
                     range schedule.

POS-PAY-STEP         Numeric 2                                   PA502
Step                 Contains the appropriate step if the
                     position is based on a step and grade
                     schedule.

POS-SUPERVISOR       Alpha 10                                    PA502
Supervisor           Contains the supervisor code that
                     identifies the supervisor to whom the
                     position reports.

POS-SHIFT            Numeric 1                                   PA502
Shift                Contains 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

POS-UPDATE-FLAG      Alpha 1                                     PA502
Update Flag          Contains 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

POS-LOCAT-CODE       Alpha 10                                    PA502
Location             Contains the default location at which
                     this position works.

POS-CHG-REASON       Alpha 10                                    PA502
Reason               Contains the reason for a change to a
                     position.

POS-ACTIVITY         Alpha 15                                    PA502
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.


POS-ACCT-CATEGORY    Alpha 5                                     PA502
Account Category     Account 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.

POS-OT-PLAN-CODE     Alpha 4                                     PA502
Pay Plan             Contains the pay plan with which the
                     position is associated.

POS-SUPERVISOR-IND   Alpha 10                                    PA502
Indirect Supervisor  Contains the supervisor code that
                     identifies the supervisor to whom the
                     position indirectly reports.

POS-SUPERVISOR-LNK   Alpha 10                                    PA502
Supervisor Link      Contains 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.

POS-WORK-SCHED       Alpha 10                                    PA502
Work Schedule        Contains the default work schedule for
                     this position.

POS-EXEMPT-EMP       Alpha 1                                     PA502
Exempt               Contains a value that indicates if the
                     rate of pay is hourly or salaried.
                     Y = Yes
                     N = No

POS-SEC-LVL          Numeric 1                                   PA502
Security Level       Contains a number between 1 and 9 that
                     indicates the security level for this
                     position.

POS-SEC-LOCATION     Alpha 10                                    PA502
Security Location    Contains 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.

POS-DATE-STAMP       Numeric 8  (yyyymmdd)                       PA502
Date Stamp           Contains the date (month, day, and
                     year) a change was made to the record.

POS-TIME-STAMP       Numeric 6  (hhmmss)                         PA502
Time Stamp           Contains the time (hour, minute, and
                     second) that a change was made to the
                     record.

POS-USER-ID          Alpha 10  (Lower Case)                      PA502
User ID              Contains the user ID of a user who has
                     made changes to the record.

POS-OBJ-ID           Numeric 12                                  PA502
Object               This is the object identifier.
Identification

POS-ANNUAL-HOURS     Numeric 4                                   PA502
Annual Hours         Contains the annual hours for the
                     position.

POS-SHORT-DESC       Derived
Short Description    A short description.

POS-CURRENCY-CODE    Alpha 5                                     PA502
Currency Code        Contains the currency in which the pay
                     is recorded.

POS-CURR-ND          Numeric 1                                   PA502
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

POS-BASE-CURRENCY    Alpha 5                                     PA502
Base Currency        Contains the company's base currency.

POS-BASE-ND          Numeric 1                                   PA502
Base Number Of       The number of decimal positions defined
Decimals             for the company base currency.

POS-BASE-PAY-RATE    Signed 13.4                                 PA502
Base Pay Rate        Contains the pay in the company's base
                     currency.

                         PAPOSITION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POSSET1   COMPANY                                                HR00.1  HR01.1
          POSITION                                               HR14.1  HR15.1
          EFFECT-DATE                                            HR15.2  HR155
                                                                 HR170   HR211
                                                                 HR511   HR514
                                                                 HR515   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA01.1
                                                                 PA01.2  PA01.3
                                                                 PA03.1  PA03.2
                                                                 PA08.1  PA08.2
                                                                 PA08.3  PA11.1
                                                                 PA111   PA120
                                                                 PA16.1  PA170
                                                                 ...

POSSET2   COMPANY                                                AC541   AC542
          POSITION                                               BN150   HCEM.1
          EFFECT-DATE*                                           HCOP.1  HCPO.1
                                                                 HR14.1  HR15.1
                                                                 HR155   HR170
                                                                 HR211   HR217
                                                                 HR220   HR511
                                                                 HR514   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 HS10.1  HS10.2
                                                                 HS11.1  HS50.1
                                                                 HS50.2  HS50.5
                                                                 PA01.1  PA01.2
                                                                 ...

POSSET3   COMPANY       KeyChange                                HPOS.1  PA402
          PROCESS-LEVEL                                          PA80.1
          DEPARTMENT
          POSITION
          EFFECT-DATE*

POSSET4   COMPANY       Subset                                   HS50.1  HS50.2
          POSITION      Where END-DATE = Zeroes                  HS51.1  HS51.2
          EFFECT-DATE                                            HS52.1  HS52.2
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR22.1
                                                                 TR500

POSSET6   COMPANY       KeyChange
          OBJ-ID
          EFFECT-DATE

                         PAPOSITION FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Cat       ACACCTCAT    Required
                            When (POS-ACCT-CATEGORY != Spaces )

                            POS-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When (POS-ACTIVITY != Spaces )

                            POS-ACTIVITY          -> ACV-ACTIVITY

Base Currency  CUCODES      Required
                            When POS-CURRENCY-CODE != Spaces

                            POS-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Chg Reason     PCODES       Required
                            When (POS-CHG-REASON != Spaces )

                            "PO"                  -> PCO-TYPE
                            POS-CHG-REASON        -> PCO-CODE

Company        PRSYSTEM     Required

                            POS-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When POS-CURRENCY-CODE != Spaces

                            POS-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When (POS-DEPARTMENT != Spaces )

                            POS-COMPANY           -> DPT-COMPANY
                            POS-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            POS-DEPARTMENT        -> DPT-DEPARTMENT

Exp Account    GLMASTER     Required
                            When (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 Supv     HRSUPER      Required
                            When (POS-SUPERVISOR-IND != Spaces )

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR-IND    -> HSU-CODE

Job Code       JOBCODE      Required
                            When (POS-JOB-CODE != Spaces )

                            POS-COMPANY           -> JBC-COMPANY
                            POS-JOB-CODE          -> JBC-JOB-CODE

Location       PCODES       Required
                            When POS-LOCAT-CODE != Spaces

                            "LO"                  -> PCO-TYPE
                            POS-LOCAT-CODE        -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When (POS-PROCESS-LEVEL != Spaces )

                            POS-COMPANY           -> PRS-COMPANY
                            POS-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Supervisor     HRSUPER      Required
                            When POS-SUPERVISOR != Spaces

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR        -> HSU-CODE

Supervisor Ind HRSUPER      Required
                            When (POS-SUPERVISOR-IND != Spaces )

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR-IND    -> HSU-CODE

Supv Link      HRSUPER      Required
                            When (POS-SUPERVISOR-LNK != Spaces )

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR-LNK    -> HSU-CODE

User Level     PCODES       Required
                            When POS-USER-LEVEL != Spaces

                            "UL"                  -> PCO-TYPE
                            POS-USER-LEVEL        -> PCO-CODE

Work Sched     PCODES       Required
                            When (POS-WORK-SCHED != Spaces )

                            "WS"                  -> PCO-TYPE
                            POS-WORK-SCHED        -> PCO-CODE

                         PAPOSITION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Assign Res     PAASSIGNED

                            POS-COMPANY           -> PAA-COMPANY
                            POS-POSITION          -> PAA-POSITION
                                                     PAA-PROCESS-LEVEL
                                                     PAA-DEPARTMENT
                                                     PAA-JOB-CODE

Budget         PABUDGET     Delete Restricted

                            POS-COMPANY           -> PAB-COMPANY
                            POS-POSITION          -> PAB-POSITION
                                                     PAB-EFFECT-DATE
                                                     PAB-PROCESS-LEVEL
                                                     PAB-DEPARTMENT
                                                     PAB-JOB-CODE

Class Pos      PACLASSPOS   Delete Cascades

                            POS-COMPANY           -> PQP-COMPANY
                                                     PQP-POS-CLASS
                                                     PQP-POSITION

Emp Pos Hist   PAEMPPOS

                            POS-COMPANY           -> PEP-COMPANY
                            POS-POSITION          -> PEP-POSITION
                                                     PEP-EMPLOYEE
                                                     PEP-POS-LEVEL
                                                     PEP-EFFECT-DATE

Grade          PRSAGDTL     Required
                            When (POS-PAY-GRADE != Spaces )
                            And  (POS-SCHEDULE  != Spaces )

                            POS-COMPANY           -> SGD-COMPANY
                            POS-SCHEDULE          -> SGD-SCHEDULE
                            POS-PAY-GRADE         -> SGD-PAY-GRADE
                            "0"                   -> SGD-PAY-STEP
                                                     SGD-EFFECT-DATE

Hist Err       HISTERR      Delete Cascades

                            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 Dt     HRHISTORY    Delete 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

Hrhistory      HRHISTORY

                            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 Appl  JOBAUTH      Delete Cascades

                            POS-COMPANY           -> JBA-COMPANY
                            1                     -> JBA-EMP-APP
                            Spaces                -> JBA-JOB-CODE
                            POS-POSITION          -> JBA-POSITION
                                                     JBA-EMPLOYEE

Job Auth Emp   JOBAUTH      Delete Cascades

                            POS-COMPANY           -> JBA-COMPANY
                            Zeroes                -> JBA-EMP-APP
                            Spaces                -> JBA-JOB-CODE
                            POS-POSITION          -> JBA-POSITION
                                                     JBA-EMPLOYEE

Job Relations  JOBRELATE    Delete Cascades

                            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 Lang       PAOFFLANG

                            POS-COMPANY           -> PLA-COMPANY
                            Zeroes                -> PLA-EMPLOYEE
                            POS-POSITION          -> PLA-POSITION
                                                     PLA-REPORT-TYPE
                                                     PLA-SEQ-NBR

Ot Plan        PROVERTIME   Required
                            When (POS-OT-PLAN-CODE != Spaces )

                            POS-COMPANY           -> PRO-COMPANY
                            POS-OT-PLAN-CODE      -> PRO-PLAN-CODE
                                                     PRO-EFFECT-DATE

Pathfind       PATHFIND     Delete Restricted

                            POS-COMPANY           -> PTF-COMPANY
                            126                   -> PTF-FLD-NBR
                            POS-POSITION          -> PTF-FLD-VALUE
                                                     PTF-EMPLOYEE
                                                     PTF-POS-LEVEL

Pos Chg Error  PAPOSERR     Delete Cascades

                            POS-COMPANY           -> PPE-COMPANY
                            POS-POSITION          -> PPE-POSITION
                            POS-EFFECT-DATE       -> PPE-EFFECT-DATE
                                                     PPE-EMPLOYEE
                                                     PPE-REQUISITION
                                                     PPE-UPDATE-TYPE

Pos Classpos   PACLASSPOS   Delete Cascades

                            POS-COMPANY           -> PQP-COMPANY
                            POS-POSITION          -> PQP-POSITION
                                                     PQP-POS-CLASS

Pos Interest   PAJOBINTRS   Delete Cascades
                            Valid When POS-END-DATE = Zeroes

                            POS-COMPANY           -> PJI-COMPANY
                            Spaces                -> PJI-JOB-CODE
                            POS-POSITION          -> PJI-POSITION
                                                     PJI-EMP-APP
                                                     PJI-EMPLOYEE

Pos Rule       PAPOSRULE

                            POS-COMPANY           -> PPR-COMPANY
                            POS-PROCESS-LEVEL     -> PPR-PROCESS-LEVEL
                            POS-DEPARTMENT        -> PPR-DEPARTMENT
                                                     PPR-EFFECT-DATE

Pos User       HRPOSUSD     Delete Cascades

                            POS-COMPANY           -> HPD-COMPANY
                            "1 "                  -> HPD-TYPE
                            POS-OBJ-ID            -> HPD-OBJ-ID
                            POS-EFFECT-DATE       -> HPD-EFFECT-DATE
                                                     HPD-FIELD-KEY

Poschange      PAPOSCHG     Delete Cascades

                            POS-COMPANY           -> PPC-COMPANY
                            POS-POSITION          -> PPC-POSITION
                            POS-EFFECT-DATE       -> PPC-EFFECT-DATE
                                                     PPC-FLD-NBR

Requisition    PAJOBREQ

                            POS-COMPANY           -> PJR-COMPANY
                            POS-POSITION          -> PJR-POSITION
                                                     PJR-REQUISITION

Schedule       PRSAGHEAD    Required
                            When (POS-SCHEDULE != Spaces )

                            POS-COMPANY           -> SGH-COMPANY
                            "P"                   -> SGH-INDICATOR
                            POS-SCHEDULE          -> SGH-SCHEDULE
                                                     SGH-EFFECT-DATE

Step And Grade PRSAGDTL     Required
                            When (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 Fields    HRPOSUSD     Delete Cascades

                            POS-COMPANY           -> HPD-COMPANY
                            "1 "                  -> HPD-TYPE
                            POS-OBJ-ID            -> HPD-OBJ-ID
                            POS-EFFECT-DATE       -> HPD-EFFECT-DATE
                                                     HPD-FIELD-KEY