PAPOSITION FILE
Positions
The Personnel Position Parameters file contains information for each position.
REFERENCED BY
HR11.1 HR14.1 HR15.1 HR15.2 HR155 HR170
HR211 HR511 HR514 HR515 HR54.1 HR55.2
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 PA115 PA120 PA13.1 PA13.2
PA16.1 PA170 PA172 PA20.1 PA201 PA208
PA21.1 PA22.1 PA23.1 PA231 PA24.1 PA242
PA262 PA263 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 PA532 PA54.1 PA570 PA62.1
PA63.1 PA64.2 PA65.2 PA66.3 PA70.1 PA72.1
PA79.1 TR21.1 TR22.1 TR500 HS01.1 HS34.1
PR13.1 PR30.1 BN150 HCEM.1 HCOP.1 HCPO.1
HS10.1 HS11.1 PA149 PA202 PA211 PA241
PA248 PA249 PA271 PA311 PA48.3 PA48.4
PA531 PR128 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR223
PR23.3 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR36.1 PR37.1 PR45.1 PR530 PR80.1
PR82.1 PR82.2 PR85.1 UK102 UK330 TM240
TM245 TM470 UK120 UK60.1 UK70.1 HPOS.1
PA402 PA80.1
UPDATED BY
HR700 PA02.1 PA102 PA302 PA502 HR00.1
HR01.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POS-COMPANY Numeric 4 PA02.1 PA170
Company Contains the company number which PA371 PA502
represents an established company.
POS-POSITION Alpha 12 PA02.1 PA170
Position Contains the user-defined code that PA371 PA502
represents a position in the company.
POS-DESCRIPTION Alpha 30 (Lower Case) PA02.1 PA102
Description Contains the description of the PA502
position.
POS-POSIT-STATUS Numeric 1 PA02.1 PA502
Position Status Contains a value that indicates the PA62.1 PA63.1
status of a position.
1 = Active
2 = Temporary
3 = Frozen
4 = Proposed
5 = Inactive
POS-EFFECT-DATE Numeric 8 (yyyymmdd) PA02.1 PA170
Effective Date Contains the date the position is PA371 PA502
available to be used.
POS-END-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
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
Job Code Contains the job code. PA263 PA502
POS-PROCESS-LEVEL Alpha 5 PA02.1 PA502
Process Level Contains the process Level.
POS-DEPARTMENT Alpha 5 PA02.1 PA502
Department Contains the department.
POS-USER-LEVEL Alpha 10 PA02.1 PA502
User Level Contains the user level.
POS-EXP-COMPANY Numeric 4 PA02.1 PA502
Expense Company Contains 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
Expense Account Contains the expense account.
POS-EXP-SUB-ACCT Numeric 4 PA02.1 PA502
Expense Subaccount Contains the expense subaccount.
POS-PAY-RATE Signed 13.4 PA02.1 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 PA02.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 PA02.1 PA502
Pay Frequency Contains the pay frequency.
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
POS-SCHEDULE Alpha 9 PA02.1 PA502
Schedule Contains the step and grade schedule or
the grade range schedule.
POS-PAY-GRADE Alpha 3 PA02.1 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 PA02.1 PA502
Step Contains the appropriate step if the
position is based on a step and grade
schedule.
POS-SUPERVISOR Alpha 10 PA02.1 PA502
Supervisor Contains the supervisor code that
identifies the supervisor to whom the
position reports.
POS-SHIFT Numeric 1 PA02.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 PA02.1 PA102
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
Location Contains the default location at which
this position works.
POS-CHG-REASON Alpha 10 PA02.1 PA502
Reason Contains the reason for a change to a
position.
POS-ACTIVITY Alpha 15 PA02.1 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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
POS-ACCT-CATEGORY Alpha 5 PA02.1 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 PA02.1 PA502
Pay Plan Contains the pay plan with which the
position is associated.
POS-SUPERVISOR-IND Alpha 10 PA02.1 PA502
Indirect Supervisor Contains the supervisor code that
identifies the supervisor to whom the
position indirectly reports.
POS-SUPERVISOR-LNK Alpha 10 PA02.1 PA502
Supervisor Link Contains the supervisor code to which
the position is linked. Changes to the
incumbants of this position will result
in an update to the employee assigned to
the supervisor code.
POS-WORK-SCHED Alpha 10 PA02.1 PA502
Work Schedule Contains the default work schedule for
this position.
POS-EXEMPT-EMP Alpha 1 PA02.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 PA02.1 PA502
Security Level Contains a number between 1 and 9 that
indicates the security level for this
position.
POS-SEC-LOCATION Alpha 10 PA02.1 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) PA02.1 PA102
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
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
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
Annual Hours Contains the annual hours for the
position.
POS-SHORT-DESC Derived
Short Description A short description.
POS-CURRENCY-CODE Alpha 5 HR700 PA02.1
Currency Code Contains the currency in which the pay PA502
is recorded.
POS-CURR-ND Numeric 1 HR700 PA02.1
Currency Number of Represents the number of decimals PA502
Decimals defined for the currency of the object.
POS-BASE-CURRENCY Alpha 5 HR700 PA02.1
Base Currency Contains the company's base currency. PA502
POS-BASE-ND Numeric 1 HR700 PA02.1
Base Number Of The number of decimal positions defined PA502
Decimals for the company base currency.
POS-BASE-PAY-RATE Signed 13.4 HR700 PA02.1
Base Pay Rate Contains the pay in the company's base PA502
currency.
PAPOSITION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POSSET1 COMPANY HR00.1 HR01.1
POSITION HR11.1 HR14.1
EFFECT-DATE HR15.1 HR15.2
HR155 HR170
HR211 HR511
HR514 HR515
HR54.1 HR55.2
HR70.1 HR700
HRS1.1 HRSC.1
PA01.1 PA01.2
PA01.3 PA02.1
PA03.1 PA03.2
PA08.1 PA08.2
PA08.3 PA100
PA102 PA11.1
...
POSSET2 COMPANY BN150 HCEM.1
POSITION HCOP.1 HCPO.1
EFFECT-DATE* HR11.1 HR14.1
HR15.1 HR155
HR170 HR211
HR511 HR514
HR515 HR54.1
HR55.2 HR70.1
HR700 HRS1.1
HRSC.1 HS10.1
HS11.1 PA01.1
PA01.2 PA01.3
PA02.1 PA08.1
PA08.2 PA08.3
PA100 PA102
...
POSSET3 COMPANY KeyChange HPOS.1 PA402
PROCESS-LEVEL PA80.1
DEPARTMENT
POSITION
EFFECT-DATE*
POSSET4 COMPANY Duplicates, Subset
POSITION Where END-DATE = Zeroes
POSSET6 COMPANY KeyChange HR700
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
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-JOB-CODE
POS-POSITION -> JBR-POSITION
JBR-TYPE
JBR-PERS-CODE
JBR-SUBJECT-CODE
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 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
|