Personnel Action Types#

Through the Define Personnel Action Types (ISPY) form, you will create PA types within the system to reflect the business processes and approval requirements for your company.

A PA type definition includes a code, an approval level, and a default change reason. In addition, the PA type specifies whether an assignment is required, and defaults values for the 'update future records' and 'cascade change reason' indicators.

Finally, the PA type specifies all the tables that it touches. A single PA type may touch multiple tables, for example, the employment, assignment and assignment details, and it then specifies all the columns available within each of these tables, and the order (sequence) in which those columns should appear.

Through PA types, Wiki enables you to make a good business association between a specific change reason/action and the particular fields that must/may be affected by that change.

You will simplify each PA type to indicate only the 'mandatory' and 'optional' fields applicable and indicate those fields which may be viewed with 'no update' option or turned off altogether by the 'no view' option.

Define PA types that focus on a specific change, for example, a wage increase or a promotion, rather than create a few multi-purpose PA types that handle a wage increase and a promotion and an assignment change.

‘Maintain Personnel Action Types’ Usage and Examples#

Maintain Personnel Action Types data is maintained on the P2K_SA_PA_TYPES, P2K_SA_PA_TYPE_TABLES and P2K_SA_PA_TYPE_COLUMNS tables.
PA Type
This field holds the name of the Personnel Action type that is being created. PA_Type_Code is a 16-character alphanumeric mandatory field that is manually created.
Approval Level
Within this field, you may define the approval level required (e.g. not specified, manager, supervisor) in order to process any PA of this type. Approval_Level is a required, user-defined lexicon (X_APPROVAL_LEVEL), from which you may make a selection from the list of values.
Change Reason
The reason a PA of this type will be created is provided in this field. Change_Code is a 16-character alphanumeric mandatory field that you may either manually enter or with a select from the LOV provided. Values for the LOV are maintained in the Define Change Reasons (IDCR) form.
Description
This field displays the description of the purpose and use of the PA type. Description is an optional 50-character alphanumeric field you must manually enter.
Assignment Required
If this toggle is ON, then users must indicate which assignment is to be used to retrieve the information for a PA of this type. If the toggle is OFF, the no assignment information is required in order to process the PA. The toggle must be on for any PA’s that require the Assignment or Assignment Details tables. Assignment_Required is an optional toggle field.
Update Future Records
If this toggle is ON, then the effective date record(s) created after the date of the PA will also be updated. If the toggle is OFF, only the effective date record that is in effect when the PA is processed will be affected. Update_Future_Records is an optional toggle field.
Cascade Change Reason
If this and the Update Future Records toggle are ON, then the change reason for this PA will override all future dated effective record change reasons. If the toggle is OFF and the Update Future Records toggle is ON, future effective dated records will be updated but their change reason will remain the same. Cascade_Change_Reason is an optional toggle field.
Track Changes
If this toggle is ON, any changes to the PA that are made by anyone who is not the originator will be tracked. A copy of the PA will be made and given a negative PA number to distinguish it from the original PA. Track_Changes is an optional toggle field.
PA Type Tables
This field identifies all tables that will be affected by the PA, if selected. Table_Name is a 16-character alphanumeric mandatory field that you must complete with a selection from the LOV provided.
P2K_HR_IDENTITIESIEID
P2K_HR_PERSONALSIEPI
P2K_HR_EMPLOYMENTSIEEI
P2K_HR_ASSIGNMENTSIEAS - Header
P2K_HR_ASSIGNMENT_DETAILSIEAS – Effective date tabs
P2K_CM_DISTRIBUTIONSIEAS – Distribution tab
P2K_SA_PREMIUM_USAGESIEAS – Premiums tab
P2K_HR_ALIASESIEAL
P2K_HR_MILITARIESIEMT
P2K_HR_PROPERTIESIEPP
P2K_HR_STATISTICSIEST
P2K_PR_CDN_PAY_RULESIPRLC
P2K_PR_PAYMENT_RULE_DETAILSIPPM
Table Alias
This field shows the abbreviated alias for the table selected. Table_Name will automatically default in once the Table_Name has been selected.
No Create Allowed
If this toggle is ON, you will not be able to add information for this table on the PA. No_Create_Allowed is an optional toggle field.
No Delete Allowed
If this toggle is ON, you will not be able to delete information for this table on the PA.
No_Delete_Allowed is an optional toggle field.
Seq. #
This field defines the sequential order of the column or field. This sequence is supplied but you may override the order. Column_Sequence is a 5-digit numeric mandatory field.
PA Type Columns
This field holds the Wiki internal name of the column (field). This field is supplied and is not updateable.
Prompt
This field holds the Wiki display name of the column (field). This field is supplied and is not updateable.
PA Column Access
You may use this field to define the access that user have to each column. PA_Column_Access is a required, fixed lexicon (X_SECURITY_ACCESS), which you may fill with a selection from list of values provided.
Updateabledefault
Mandatorycolumn cannot be left blank
No Viewcolumn will not be displayed on ISPA
No Updatecolumn will be displayed but the use will not be able to update it
Context
If the toggle is ON, any changes to that field in relevant tables made after an ISPA screen is created will cause USPPA to not update that field. If the toggle is OFF, USPPA will update the field regardless of any changes since the ISPA screen was created. Context_Column is an optional toggle field.
User Field
If the toggle is ON, it indicates that the field is user defined. User_Field is an optional toggle field.
Any user fields that are added must be given a sequence number of 99000 or higher.
---

Buttons#

Create, Refresh All PA Columns for Table
If a new release has added new fields to a table, then by pressing this button, all the new information for those fields will be pulled into the database.