Lawson Insight Technical Documentation |
|
PAPOSITION
PAPOSITION FILE
Positions
The Personnel Position Parameters file contains information for each position.
REFERENCED BY
BN305 ET700 HAP3.1 HEP4.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 HR70.1 HRS1.1 HRSC.1 LP100
LP101 LP180 LP197 LP231 LP264 LP31.1
LP32.1 LP32.2 LP32.3 LP64.1 LP64.2 LP80.1
LP88.1 PA01.1 PA01.2 PA01.3 PA03.1 PA03.2
PA03.3 PA08.1 PA08.2 PA08.3 PA100 PA11.1
PA113 PA115 PA120 PA13.1 PA13.2 PA13.3
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 PA42.3 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA53.1 PA532 PA535 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 SN60.3 SN60.4 SN80.2 SN80.3
BN150 ET530 ETI2.1 HCDL.1 HCEM.1 HCHP.1
HCPO.1 HR217 HR220 HS10.1 HS10.2 LP130
LP198 LP251 LP260 LP262 LP34.1 LP53.1
LP553 LP554 HS11.1 HS11.2 HS50.1 HS50.2
HS50.5 PA103 PA149 PA182 PA202 PA208
PA210 PA211 PA223 PA241 PA248 PA249
PA271 PA296 PA311 PA48.3 PA48.4 PA495
PA496 PA531 PA62.1 PA63.1 PA65.2 PA65.1
PA82.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
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR80.1 PR80.2 PR82.1 PR82.2 UK102 UK560
TA147 TM240 TM245 TM470 PA402 PA80.1
HS12.1 HS12.2 HS13.1 HS13.2 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
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-UNION-CODE Alpha 10 PA02.1 PA502
Element: Union Code
POS-BARGAIN-UNIT Alpha 10 PA02.1 PA502
Element: Bargain Unit
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.
Valid account category types are:
cost
revenue
accrual
pass thru
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
Element: Obj Id This is the object identifier.
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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
POS-BASE-CURRENCY Alpha 5 PA02.1 PA502
Element: Base Currency Contains the company's base currency.
POS-BASE-ND Numeric 1 PA02.1 PA502
Element: Base Nd The number of decimal positions defined
for the company base currency.
POS-BASE-PAY-RATE Signed 13.4 PA02.1 PA502
Element: Pay Rate Contains the pay in the company's base
currency.
POS-ENCUMBER-FLAG Alpha 1 PA02.1 PA502
Element: Encumber Flag " " = No
N = No
Y = Yes
PAPOSITION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POSSET1 COMPANY BN305 ET700
POSITION HAP3.1 HEP4.1
EFFECT-DATE HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR11.1
HR11.2 HR14.1
HR15.1 HR15.2
HR155 HR170
HR211 HR511
HR514 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 LP100
LP101 LP180
LP197 LP231
...
POSSET2 COMPANY BN150 BN305
POSITION ET530 ETI2.1
EFFECT-DATE* HCDL.1 HCEM.1
HCHP.1 HCPO.1
HAP3.1 HEP4.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 HR70.1
HRS1.1 HRSC.1
...
POSSET3 COMPANY KeyChange HPOS.1 PA402
PROCESS-LEVEL PA80.1
DEPARTMENT
POSITION
EFFECT-DATE*
POSSET4 COMPANY Subset HR11.1 HR511
POSITION Where END-DATE = Zeroes LP100 LP101
EFFECT-DATE LP180 LP197
LP31.1 LP32.1
LP32.2 LP32.3
LP80.1 HS11.1
HS11.2 HS12.1
HS12.2 HS13.1
HS13.2 HS50.1
HS50.2 HS51.1
HS51.2 HS52.1
HS52.2 PA100
PA262 PA263
PA52.4 PA62.1
PA63.1 PA64.1
...
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
Assign Res PAASSIGNED Not Required
POS-COMPANY -> PAA-COMPANY
POS-POSITION -> PAA-POSITION
Spaces -> PAA-PROCESS-LEVEL
Spaces -> PAA-DEPARTMENT
Spaces -> PAA-JOB-CODE
Bargain Unit PCODES Required
When POS-BARGAIN-UNIT != Spaces
"BU" -> PCO-TYPE
POS-BARGAIN-UNIT -> PCO-CODE
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
Union Code PCODES Required
When POS-UNION-CODE != Spaces
"UN" -> PCO-TYPE
POS-UNION-CODE -> PCO-CODE
User Level PCODES Required
When POS-USER-LEVEL != Spaces
"UL" -> PCO-TYPE
POS-USER-LEVEL -> PCO-CODE
PAPOSITION FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Budget PABUDGET
POS-COMPANY -> PAB-COMPANY
POS-POSITION -> PAB-POSITION
PAB-EFFECT-DATE
PAB-PROCESS-LEVEL
PAB-DEPARTMENT
PAB-JOB-CODE
Class Pos PACLASSPOS
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-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 Err HISTERR
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
POS-COMPANY -> JBA-COMPANY
1 -> JBA-EMP-APP
Spaces -> JBA-JOB-CODE
POS-POSITION -> JBA-POSITION
JBA-EMPLOYEE
Job Auth Emp JOBAUTH
POS-COMPANY -> JBA-COMPANY
Zeroes -> JBA-EMP-APP
Spaces -> JBA-JOB-CODE
POS-POSITION -> JBA-POSITION
JBA-EMPLOYEE
Job Relations JOBRELATE
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
Paencumber PAENCUMBER
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
Pathfind PATHFIND
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
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
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
Work Sched HRWRKSCHD
Valid When (POS-WORK-SCHED != Spaces )
POS-COMPANY -> WSC-COMPANY
POS-WORK-SCHED -> WSC-WORK-SCHED
WSC-EFFECT-DATE
|