Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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    HPAT.1
HR04.4    HR04.5    HR04.6    HR15.1    HR200     HR511
HR515     HR521     HR54.1    HR650     HRS1.1    HRSC.1
PA113     PA213     PA248     PA250     PA272     PA311
PA341     PA370     PA502     PA513     PA53.1    PA54.1
PA66.1    PA66.2    PA66.3    PA66.4    PR13.1    PR13.5
PR13.6    PR13.8    PR282     UK10.1    UK110     UK210

UPDATED BY

PA50.1    PA56.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

PAT-DESCRIPTION      Alpha 30  (Lower Case)                      PA50.1
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                                   PA56.1
Last Comment         Contains the last sequence number used
Sequence Number      for personnel action comments.

PAT-WEB-AVAILABLE    Alpha 1                                     PA50.1
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
Web Avail Supv       Indicates 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
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
Workflow             Indicates whether to initiate a
                     workflow service.
                     N = No
                     Y = Yes

PAT-HIST-CORR-FLAG   Alpha 2                                     PA50.1
Hist Corr Flag       Indicates 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  HPAT.1
                                                                 HR00.1  HR01.1
                                                                 HR04.4  HR04.5
                                                                 HR04.6  HR15.1
                                                                 HR200   HR511
                                                                 HR515   HR521
                                                                 HR54.1  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA113   PA213
                                                                 PA248   PA250
                                                                 PA272   PA311
                                                                 PA341   PA370
                                                                 PA50.1  PA502
                                                                 ...

                         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