Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PERSACTYPE


                            PERSACTYPE FILE

                         Personnel Action Code

The Personnel Action Code file contains information about personnel actions.

PA50.1 (Action) is the primary program that updates this file.

REFERENCED BY

BN16.2    BN16.3    BN16.4    BN216     HC02.5    HAP3.1
HEP4.1    HPAT.1    HPOS.1    HPQC.1    HPRS.1    HR04.4
HR04.5    HR04.6    HR11.1    HR11.2    HR15.1    HR200
HR511     HR515     HR521     HR54.1    HRS1.1    HRSC.1
PA02.1    PA102     PA113     PA115     PA125     PA13.1
PA13.2    PA213     PA223     PA248     PA250     PA272
PA311     PA341     PA370     PA502     PA513     PA52.1
PA52.2    PA52.3    PA52.4    PA52.5    PA53.1    PA54.1
PA594     PA66.1    PA66.2    PA66.3    PA66.4    PR110
PR113     PR120     PR13.1    PR13.5    PR13.6    PR13.8
PR282     PRSC.1    UK10.1    UK110     UK210

UPDATED BY

PA100     PA50.1    PA56.1    HR00.1    HR01.1    PBIP.1
PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAT-COMPANY            Numeric 4                                 PA50.1
Element: Company Hr    Contains the company number which
                       represents an established company.

PAT-ACTION-CODE        Alpha 10                                  PA50.1
Element: Action Code   Contains the code that represents the
                       personnel action.

PAT-DESCRIPTION        Alpha 30  (Lower Case)                    PA50.1
Element: Description   Contains the description of the
                       personnel action.

PAT-FLD-NBR            Numeric 4 Occurs 36 Times                 PA50.1
Dictionary Field       Contains the data dictionary item
Number                 number corresponding to the field used
                       in the personnel action.

PAT-LAST-CMT-SEQ       Numeric 4                                 PA100   PA56.1
Last Comment           Contains the last sequence number used
Sequence Number        for personnel action comments.

PAT-WEB-AVAILABLE      Alpha 1                                   PA50.1
Element: Web Available Indicates whether the employee can
                       change information on the Web by using
                       this action code.
                       N = No
                       Y = Yes

PAT-WEB-AVAIL-SUPV     Alpha 1                                   PA50.1
Element: Web Avail SupvIndicates whether the employee's
                       supervisor can see results of the action
                       on the web.
                       1 = Not Available
                       2 = Direct Supervisor
                       3 = Indirect Supervisor
                       4 = Direct; Indirect Supvr
                       " "

PAT-WEB-IMMEDIATE      Alpha 1                                   PA50.1
Element: Web Immediate Indicates whether an employee or
                       supervisor can make the action immediate
                       using the Web.
                       N = No
                       Y = Yes

PAT-WORKFLOW-FLAG      Alpha 1                                   PA50.1
Element: Workflow      Indicates whether to initiate a
                       workflow service.
                       N = No
                       Y = Yes

PAT-HIST-CORR-FLAG     Alpha 2                                   PA50.1
Element: Hist Corr FlagIndicates default method the system uses
                       to correct employee history audit files
                       when a retroactive change is performed.
                       1 = Create pending upd
                       2 = Delete
                       3 = Move to Hist Error

                         PERSACTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PATSET1   COMPANY                                                BN16.2  BN16.3
          ACTION-CODE                                            BN16.4  BN216
                                                                 HC02.5  HAP3.1
                                                                 HEP4.1  HPAT.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HR00.1
                                                                 HR01.1  HR04.4
                                                                 HR04.5  HR04.6
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR200
                                                                 HR511   HR515
                                                                 HR521   HR54.1
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA113
                                                                 ...

                         PERSACTYPE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PAT-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Field Nbr      PADICT       Required
                            When PAT-FLD-NBR != Zeroes

                            PAT-FLD-NBR        -> PAD-FLD-NBR

                         PERSACTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hist Err       HISTERR      Delete Cascades

                            PAT-COMPANY        -> HER-COMPANY
                            PAT-ACTION-CODE    -> HER-ACTION-CODE
                                                  HER-EMPLOYEE
                                                  HER-OBJ-ID
                                                  HER-EFFECT-DATE
                                                  HER-ACTION-NBR
                                                  HER-FLD-NBR
                                                  HER-SEQ-NBR

Pers Actions   PERSACTION   Delete Restricted

                            PAT-COMPANY        -> PCT-COMPANY
                            PAT-ACTION-CODE    -> PCT-ACTION-CODE
                                                  PCT-ACTION-TYPE
                                                  PCT-EFFECT-DATE
                                                  PCT-EMPLOYEE
                                                  PCT-ACTION-NBR

Persacthst     PERSACTHST   Delete Restricted

                            PAT-COMPANY        -> PAH-COMPANY
                            PAT-ACTION-CODE    -> PAH-ACTION-CODE
                                                  PAH-EMPLOYEE
                                                  PAH-EFFECT-DATE
                                                  PAH-ACTION-NBR