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.3    HGLM.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    HR650     HRS1.1    HRSC.1
PA02.1    PA102     PA113     PA115     PA125     PA13.1
PA13.2    PA213     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       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
Element: Sequence NumbeContains 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: All 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

                         PERSACTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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