Lawson Insight Technical Documentation |
|
PAPOSITION
PAPOSITION FILE
Positions
The Personnel Position Parameters file contains information for each position.
REFERENCED BY
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR11.1 HR11.2
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 PA100
PA11.1 PA111 PA113 PA115 PA120 PA13.1
PA13.2 PA16.1 PA170 PA172 PA20.1 PA201
PA21.1 PA22.1 PA23.1 PA231 PA24.1 PA242
PA262 PA263 PA27.1 PA272 PA31.1 PA34.1
PA35.1 PA36.1 PA37.1 PA371 PA38.1 PA406
PA41.1 PA42.1 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA53.1 PA54.1 PA570 PA66.3
PA70.1 PA72.1 PA79.1 TR21.1 TR22.1 TR26.1
TR500 HS01.1 HS34.1 HS36.1 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR30.1
PRSC.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 PA496 PA531 PA532
PA62.1 PA63.1 PA65.2 PA65.1 PA96.1 PR128
PR130 PR131 PR132 PR134 PR136 PR160
PR180 PR189 PR223 PR23.3 PR29.1 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR45.1 PR529
PR530 PR560 PR80.1 PR80.2 PR82.1 PR82.2
UK102 UK560 TA147 TM240 TM245 TM470
UK120 UK60.1 UK70.1 PA402 PA80.1 HS51.1
HS51.2 HS52.1 HS52.2 PA64.1 PA64.2 TR120
TR121 TR20.1 TR20.2 TR20.3
UPDATED BY
PA02.1 PA102 PA302 PA502 HR00.1 HR01.1
PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POS-COMPANY Numeric 4 PA02.1 PA170
Element: Company Contains the company number which PA371 PA502
represents an established company.
POS-POSITION Alpha 12 PA02.1 PA170
Element: Position Contains the user-defined code that PA371 PA502
represents a position in the company.
POS-DESCRIPTION Alpha 30 (Lower Case) PA02.1 PA102
Element: Description Contains the description of the PA502
position.
POS-POSIT-STATUS Numeric 1 PA02.1 PA502
Element: Position StatuContains a value that indicates the
status of a position.
1 = Active
2 = Temporary
3 = Frozen
4 = Proposed
5 = Inactive
POS-EFFECT-DATE Numeric 8 (yyyymmdd) PA02.1 PA170
Element: Effective DateContains the date the position is PA371 PA502
available to be used.
POS-END-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Element: End Date Contains the ending date when the PA502
position is no longer available to be
used.
POS-JOB-CODE Alpha 9 PA02.1 PA262
Element: Job Code Contains the job code. PA263 PA502
POS-PROCESS-LEVEL Alpha 5 PA02.1 PA502
Element: Process Level Contains the process Level.
POS-DEPARTMENT Alpha 5 PA02.1 PA502
Element: Department Contains the department.
POS-USER-LEVEL Alpha 10 PA02.1 PA502
Element: User Level Contains the user level.
POS-EXP-COMPANY Numeric 4 PA02.1 PA502
Element: Expense CompanContains the general ledger expense
company.
POS-EXP-ACCT-UNIT Alpha 15 PA02.1 PA502
Expense Accounting Contains the expense account unit.
Unit
POS-EXP-ACCOUNT Numeric 6 PA02.1 PA502
Element: Expense AccounContains the expense account.
POS-EXP-SUB-ACCT Numeric 4 PA02.1 PA502
Element: Expense SubaccContains the expense subaccount.
POS-PAY-RATE Signed 13.4 PA02.1 PA502
Element: 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 PA02.1 PA502
Element: 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 PA02.1 PA502
Element: Pay Frequency Contains the pay frequency.
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = UK Four-Weekly
POS-SCHEDULE Alpha 9 PA02.1 PA502
Element: Schedule Contains the step and grade schedule or
the grade range schedule.
POS-PAY-GRADE Alpha 3 PA02.1 PA502
Element: 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 PA02.1 PA502
Element: Step Contains the appropriate step if the
position is based on a step and grade
schedule.
POS-SUPERVISOR Alpha 10 PA02.1 PA502
Element: Supervisor Contains the supervisor code that
identifies the supervisor to whom the
position reports.
POS-SHIFT Numeric 1 PA02.1 PA502
Element: 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 PA02.1 PA102
Element: Update Flag Contains a yes or no value that PA502
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 PA02.1 PA502
Element: Location Contains the default location at which
this position works.
POS-CHG-REASON Alpha 10 PA02.1 PA502
Element: Reason Contains the reason for a change to a
position.
POS-ACTIVITY Alpha 15 PA02.1 PA502
Element: 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 PA02.1 PA502
Element: Account CategoAccount 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 PA02.1 PA502
Element: Pay Plan Contains the pay plan with which the
position is associated.
POS-SUPERVISOR-IND Alpha 10 PA02.1 PA502
Element: Indirect SuperContains the supervisor code that
identifies the supervisor to whom the
position indirectly reports.
POS-SUPERVISOR-LNK Alpha 10 PA02.1 PA502
Element: Supervisor LinContains 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 PA02.1 PA502
Element: Work Schedule Contains the default work schedule for
this position.
POS-EXEMPT-EMP Alpha 1 PA02.1 PA502
Element: Exempt Contains a value that indicates if the
rate of pay is hourly or salaried.
Y = Yes
N = No
POS-SEC-LVL Numeric 1 PA02.1 PA502
Element: Security LevelContains a number between 1 and 9 that
indicates the security level for this
position.
POS-SEC-LOCATION Alpha 10 PA02.1 PA502
Element: Security LocatContains 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) PA02.1 PA102
Element: Date Stamp Contains the date (month, day, and PA502
year) a change was made to the record.
POS-TIME-STAMP Numeric 6 (hhmmss) PA02.1 PA102
Element: Time Stamp Contains the time (hour, minute, and PA502
second) that a change was made to the
record.
POS-USER-ID Alpha 10 (Lower Case) PA02.1 PA102
Element: User ID Contains the user ID of a user who has PA502
made changes to the record.
POS-OBJ-ID Numeric 12 PA02.1 PA502
Object This is the object identifier.
Identification
POS-ANNUAL-HOURS Numeric 4 PA02.1 PA502
Element: Annual Hours Contains the annual hours for the
position.
POS-SHORT-DESC Derived
Element: Short DescriptA short description.
POS-CURRENCY-CODE Alpha 5 PA02.1 PA502
Element: Currency Code Contains the currency in which the pay
is recorded.
POS-CURR-ND Numeric 1 PA02.1 PA502
Account Currency
Code
POS-BASE-CURRENCY Alpha 5 PA02.1 PA502
To Company Base Contains the company's base currency.
Currency
POS-BASE-ND Numeric 1 PA02.1 PA502
Account Currency
Code
POS-BASE-PAY-RATE Signed 13.4 PA02.1 PA502
Element: 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 HGLM.1 HPOS.1
POSITION HPQC.1 HPRS.1
EFFECT-DATE HR00.1 HR01.1
HR11.1 HR11.2
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
PA02.1 PA03.1
PA03.2 PA08.1
...
POSSET2 COMPANY AC541 AC542
POSITION BN150 HCEM.1
EFFECT-DATE* HCOP.1 HCPO.1
HGLM.1 HPOS.1
HPQC.1 HPRS.1
HR11.1 HR11.2
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
...
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
PA262 PA263
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
TR120 TR121
TR20.1 TR20.2
TR20.3 TR21.1
TR22.1 TR26.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
|