PA513 - Position and Job Conversion
Run PA513 to import historical information from a comma-separated value (CSV)
file into PA13.2 (Position, Job History).
Planning considerations
1. Determine what information will be converted and make sure valid value
tables exist (see prerequisites section).
2. Determine how much historical data you will convert for each
employee.
3. Determine if information should be logged to history.
4. A Level 1 (primary) historical record must exist for the time frame for
which any Level 2-5 records are converted.
5. It is recommend the file be sorted in the following order:
employee:position level:descending effective date
6. If using formal positions, default/override edits will not be performed.
Before you run PA513:
- Ensure companies are defined in HR00.1 (Company).
- Ensure process levels are defined HR01.1 (Process Level).
- Ensure positions are defined in PA02.1 (Position)
- Ensure departments are defined in HR02.1 (Department).
- Ensure user level codes (UL) are defined HR04.1 (HR Code Setup)
- Ensure location codes (LO) are defined in HR04.1. - Ensure supervisor codes
are defined in HR07.1 (Supervisor)
- Ensure work schedule codes (WS) are defined in HR04.1
- Ensure union codes (UN) are defined in HR04.1.
- Ensure schedules or grade ranges are defined in PR16.1 (Step & Grade
Schedule) or PA95.1 (Grade Range Schedule).
- Ensure steps are defined in PR16.1.
In addition:
- Be sure employee records exist in HR11.1 (Employee).
- Be sure position rules exist in PA06.1 (Position Rules) and HR10.2
(Position Item Attributes) for the earliest date being converted.
- If you use formal positions, be sure positions exist in PA02.1 (Positions)
for the dates being converted.
- Be sure all codes such as job and location are set up.
The program processes and prints records in the order in which they are found
on the CSV file. The program edits records as if they were directly typed
into PA13.2. Any errors are written out to a new CSV file.
PA513 updates the following files:
Database File Description Database File Name
------------------------- ------------------
Employee Positions PAEMPPOS
History* HRHISTORY
Rate History* PRRATEHIST
*updated if changes are logged to history
Input file name:
PA513CSV
To verify data:
- Run PA213 (Position, Job Listing).
Note: PA513 (Position, Job Conversion) also has report output.
Updated Files
BNCHANGE - The Benefit Changes file is updated with benefit changes when
positions are updated.
BNGRPCHG - The Benefit Group Change file is updated with group changes
that affect benefits.
CKPOINT - The Checkpoint Restart file is the environment file used for
recovery.
EMDEDMASTR -
EMPLOYEE - The Employee file updates employees in the position.
HISTERR -
HRHISTORY -
HRSUPER - The Supervisors file is updated with position supervisor link
information.
ONETMDED -
PAASSIGNED - The Assigned Resources file is updated with count changes.
PAEMPLOYEE - The Employee Personnel Information file is updated with
employee information from position changes.
PAEMPPOS - The Employee Multiple Pos, Jobs file is updated with employee
updates from position changes.
PAPEPAUDIT - The Retroactive Pos, Job Changes file is updated with
retroactive employee and requisition changes.
PAPOSCHG - The Position Changes file is updated with postion changes if
this is not an immediate update or if employees were in error.
PATHFIND - The Employee Report Writer Paths file is updated with employee
changes when applying position updates.
PAYDEDUCTN -
PAYMASTR - The Employee Payment Master file is udpated with process level
changes when employees are updated.
PERSACTHST - The Personnel Action Detail file is updated with employee
postion changes that require a personnel action.
PERSACTION -
PERSGROUP - The Employee Group Header file is updated with employee group
changes.
PGEMPLOYEE - The Employee Group History file is updated if an add or change
affects an employee group.
PRRATEHIST -
PRTAXLOC -
STANDTIME - The Payroll Standard Time Record file is updated with payrate
changes for hourly employees.
TIMERECORD - The Employee Time Records file is updated for department or
process level changes.
Referenced Files
ACACCTCAT -
BENEFIT - The Beneficiary file is referenced by the routine.
CUCODES -
DEDCODE -
DEPTCODE - The Department file verifies the department.
EMPCODES - The Emp/App Personnel Codes file is referenced by the routine.
EMSTATUS - The Employee/Applicant Status file retrieves the status count.
GLINTCO -
GLSYSTEM -
HRCTRYCODE -
HREMPUSF - The Employee/Applican User Fields file is referenced by the
group routine.
HRSECLEV - The Employee Security Level file retrieves the user's security
level.
INSTCTRYCD -
JOBCODE - The Job Code Parameters file verfies the job code and
retrieves the annual hours for the job and salary range for pay
verification. It also verifies tip information.
PABUDGET - The Budget file is verifies the FTE against the budgeted FTE
depending on the position rules.
PADICT - The HR Systems Data Dictionary retrieves error messages.
PADICT2 -
PAEMPAPP -
PAPOSITION - The Positions file verifies the position.
PAPOSRULE - The Position Rules file is referenced for assigned resources
updates.
PASCRTY - The Data Item Attributes Parameters file is used for security.
The file retrieves flags for personnel additions edits and
logging to history.
PCODES - The Human Resource Codes file verfies HR codes.
PCODESDTL -
PERSACTYPE -
PGSELECT - The Employee Group Selection Criteria file is used by the
group routine.
PLAN -
PREMDEDHST -
PRRATES -
PRSAGDTL - The Step & Grade Schedule Detail file verifies the step and
grade.
PRSAGHEAD - The Step & Grade Schedule Header file verifies the schedule.
PRSTATE - The States file is referenced by the routine.
PRSYSTEM - The HR Company and Process Levels file verifies the company.
PRTAXAUTH - The Tax Authority file is refenced by the routine.
PRTAXLEVY -
INVOKED Programs
ACAC
ACCL
IFCU
IFSG
HRCL
HRFN
HRHI
HRLO
HRST
IFAC
IFAU
SLSE
SLSU
IFOB
|
