Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAENCUMBER


                            PAENCUMBER FILE

REFERENCED BY

HR00.1    HR01.1    HR02.1    PA02.1    PA502     PA82.1
PBIP.1    PR197     HR11.1    HR11.2    HR511     PA100
PA102     PA115     PA52.1    PA52.3    PA52.4    PA52.5
PR110     PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8

UPDATED BY

PA182

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PEN-COMPANY            Numeric 4                                 PA182
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PEN-POSITION           Alpha 12                                  PA182
Element: Position      Contains the user-defined code that
                       represents a position in the company.

PEN-PROCESS-LEVEL      Alpha 5                                   PA182
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

PEN-DEPARTMENT         Alpha 5                                   PA182
Element: Department    Contains the department.

PEN-JOB-CODE           Alpha 9                                   PA182
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

PEN-EMPLOYEE           Numeric 9                                 PA182
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PEN-GLT-OBJ-ID         Numeric 12                                PA182
Object                 This is a subsystem GL interface
Identification         identification number. It is used for
                       Drill Around purposes.

PEN-ATN-OBJ-ID         Numeric 12                                PA182
Object                 The system-defined object id
Identification         representing the Activity Management
                       commitment.

PEN-ENCUMBER-SAL       Signed 13.2                               PA182
Element: Wage Amount

PEN-ENCUMBER-FRNG      Signed 13.2                               PA182
Element: Wage Amount

PEN-ACTIVITY           Alpha 15                                  PA182
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


PEN-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA182
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PEN-SHORT-NAME-CND     Derived
Element: Short Name Cnd

PEN-LABEL-NAME-1       Derived
Element: Label Name 1

                         PAENCUMBER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PENSET1   COMPANY                                                HR00.1  HR01.1
          POSITION                                               HR02.1  PA02.1
          PROCESS-LEVEL                                          PA182   PA502
          DEPARTMENT                                             PA82.1  PBIP.1
          JOB-CODE                                               PR197
          EMPLOYEE
          GLT-OBJ-ID
          ATN-OBJ-ID

PENSET2   COMPANY                                                HR11.1  HR11.2
          EMPLOYEE                                               HR511   PA02.1
          POSITION                                               PA100   PA102
          PROCESS-LEVEL                                          PA115   PA502
          DEPARTMENT                                             PA52.1  PA52.3
          JOB-CODE                                               PA52.4  PA52.5
          GLT-OBJ-ID                                             PR110   PR113
          ATN-OBJ-ID                                             PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PENSET3   GLT-OBJ-ID    Subset
                        Where GLT-OBJ-ID != Zeroes

PENSET4   ATN-OBJ-ID    Subset
                        Where ATN-OBJ-ID != Zeroes

                         PAENCUMBER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Activity       ACACTIVITY   Required
                            When PEN-ACTIVITY != Spaces

                            PEN-ACTIVITY         -> ACV-ACTIVITY

Atn Obj Id     ACCOMMITX    Required
                            When PEN-ATN-OBJ-ID != Zeroes

                            PEN-ATN-OBJ-ID       -> MIX-ATN-OBJ-ID

Company        PRSYSTEM     Required

                            PEN-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When PEN-DEPARTMENT != Spaces

                            PEN-COMPANY          -> DPT-COMPANY
                            PEN-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PEN-DEPARTMENT       -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            PEN-COMPANY          -> EMP-COMPANY
                            PEN-EMPLOYEE         -> EMP-EMPLOYEE

Glt Obj Id     GLCOMMITX    Required
                            When PEN-GLT-OBJ-ID != Zeroes

                            PEN-GLT-OBJ-ID       -> GOX-GLT-OBJ-ID

Job Code       JOBCODE      Required
                            When PEN-JOB-CODE != Spaces

                            PEN-COMPANY          -> JBC-COMPANY
                            PEN-JOB-CODE         -> JBC-JOB-CODE

Paemployee     PAEMPLOYEE   Required

                            PEN-COMPANY          -> PEM-COMPANY
                            PEN-EMPLOYEE         -> PEM-EMPLOYEE

Process Level  PRSYSTEM     Required
                            When PEN-PROCESS-LEVEL != Spaces

                            PEN-COMPANY          -> PRS-COMPANY
                            PEN-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         PAENCUMBER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Position       PAPOSITION   Required
                            When PEN-POSITION != Spaces

                            PEN-COMPANY          -> POS-COMPANY
                            PEN-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE