 |
Lawson Insight Technical Documentation |
|
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
|