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     BN305     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     UK10.1    UK110     UK210

UPDATED BY

PA100     PA50.1    PA56.1    HR00.1    HR01.1

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
Element: Fld Nbr       Contains the data dictionary item
                       number corresponding to the field used
                       in the personnel action.

PAT-LAST-CMT-SEQ       Numeric 4                                 PA100   PA56.1
Element: Last Cmt Seq  Contains the last sequence number used
                       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 Flag 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

PAT-ERECRUIT-FLAG      Alpha 1
Element: Erecruit Flag N = No
                       Y = Yes

                         PERSACTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PATSET1   COMPANY                                                BN16.2  BN16.3
          ACTION-CODE                                            BN16.4  BN216
                                                                 BN305   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
                                                                 ...

                         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