Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAASSIGNED


                            PAASSIGNED FILE

                           Assigned Resources

The Personnel Administration Assigned Resource file contains the total head
count and FTE currently assigned to employees and requisitions. Position rules
indicate whether assigned resources are counted by position; by process level
and job code; or by process level, department, and job code.

REFERENCED BY

PA01.1    PA01.2    PA01.3    PA170     PA171     PA172
PA201     PA211     PA272     PA371     PA70.1    PA71.1
PA79.1    PA80.1    PA80.2

UPDATED BY

BN305     HR11.1    HR11.2    HR511     PA02.1    PA100
PA102     PA11.1    PA111     PA115     PA13.1    PA13.2
PA42.1    PA42.3    PA45.1    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PA535     PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8    HR00.1
HR01.1    PA302

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAA-COMPANY            Numeric 4                                 BN305   HR11.1
Element: Company       Contains the company number.              HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA11.1
                                                                 PA111   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-POSITION           Alpha 12                                  BN305   HR11.1
Element: Position      Contains the user-defined code that       HR11.2  HR511
                       represents a type of position.            PA02.1  PA100
                                                                 PA102   PA11.1
                                                                 PA111   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-PROCESS-LEVEL      Alpha 5                                   BN305   HR11.1
Element: Process Level Contains the process level.               HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA11.1
                                                                 PA111   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-DEPARTMENT         Alpha 5                                   BN305   HR11.1
Element: Department    Contains the department.                  HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA11.1
                                                                 PA111   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-JOB-CODE           Alpha 9                                   BN305   HR11.1
Element: Job Code      Contains a user-defined code that         HR11.2  HR511
                       represents a type of job.                 PA02.1  PA100
                                                                 PA102   PA11.1
                                                                 PA111   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-EMP-HDCNT          Signed 5.0                                BN305   HR11.1
Element: Employee Head Contains the current head count for       HR11.2  HR511
                       employees by count category. Count        PA02.1  PA100
                       category can be position; process level   PA102   PA11.1
                       and job code; or process level,           PA111   PA115
                       department, and job code.                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-EMP-FTE            Signed 11.6                               BN305   HR11.1
Employee Full Time     Contains the current full time            HR11.2  HR511
Equivalent             equivalent factor for employees by count  PA02.1  PA100
                       category. Count category can be           PA102   PA11.1
                       position; process level and job code; or  PA111   PA115
                       process level, department, and job code.  PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-INACT-EMPHDCNT     Signed 5.0                                BN305   HR11.1
Inactive Employee      Contains the current head count for       HR11.2  HR511
Head Count             inactive employees by count category.     PA02.1  PA100
                       Count category can be position; process   PA102   PA11.1
                       level and job code; or process level,     PA111   PA115
                       department, and job code.                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-INACT-EMP-FTE      Signed 11.6                               BN305   HR11.1
Element: Inactive EmloyContains the current full time            HR11.2  HR511
                       equivalent factor for inactive employees  PA02.1  PA100
                       by count category. Count category can be  PA102   PA11.1
                        position; process level and job code;    PA111   PA115
                       or process level, department, and job     PA13.1  PA13.2
                       code.                                     PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-REQ-HDCNT          Signed 5.0                                BN305   HR11.1
Requisition Head       Contains the total count of remaining     HR11.2  HR511
Count                  openings for active requisitions by       PA02.1  PA100
                       count category. To be  included in this   PA102   PA11.1
                       count,  the requisition  must status      PA111   PA115
                       must have a count value of 2 (Active) as  PA13.1  PA13.2
                       defined in HRO3 (Employee  Status         PA42.1  PA42.3
                       Codes).                                   PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-REQ-FTE            Signed 11.6                               BN305   HR11.1
Element: Requisition FTContains the total remaining full time    HR11.2  HR511
                       equivalent factor for active              PA02.1  PA100
                       requisitions by count category. To be     PA102   PA11.1
                       included in this count, a requisition     PA111   PA115
                       must have a count status of 2 (Active)    PA13.1  PA13.2
                       as defined in HR03 (Employee Status       PA42.1  PA42.3
                       Codes).                                   PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-DATE-STAMP         Numeric 8  (yyyymmdd)                     BN305   HR11.1
Element: Date Stamp    Contains the date (month, day, and        HR11.2  HR511
                       year) a change was made to the record.    PA02.1  PA100
                       Each date is tied to a user ID and time   PA102   PA11.1
                       to create a history of changes to the     PA111   PA115
                       record.                                   PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-TIME-STAMP         Numeric 6  (hhmmss)                       BN305   HR11.1
Element: Time Stamp    Contains the time (hour, minute, and      HR11.2  HR511
                       second) a change was made to the record.  PA02.1  PA100
                       Each time stamp is tied to a date and     PA102   PA11.1
                       user ID to create a history of changes    PA111   PA115
                       to the record.                            PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-USER-ID            Alpha 10  (Lower Case)                    BN305   HR11.1
Element: User ID       Contains the user ID of a user who has    HR11.2  HR511
                       made changes to the record. The user ID   PA02.1  PA100
                       is tied to a date and time to create a    PA102   PA11.1
                       history of changes to the record.         PA111   PA115
                                                                 PA13.1  PA13.2
                                                                 PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA535
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         PAASSIGNED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAASET1   COMPANY                                                BN305   HR00.1
          POSITION                                               HR01.1  HR11.1
          PROCESS-LEVEL                                          HR11.2  HR511
          DEPARTMENT                                             PA01.1  PA01.2
          JOB-CODE                                               PA01.3  PA02.1
                                                                 PA100   PA102
                                                                 PA11.1  PA111
                                                                 PA115   PA13.1
                                                                 PA13.2  PA170
                                                                 PA171   PA172
                                                                 PA201   PA211
                                                                 PA272   PA302
                                                                 PA371   PA42.1
                                                                 PA42.3  PA45.1
                                                                 PA502   PA513
                                                                 ...

PAASET2   COMPANY                                                BN305   HR11.1
          PROCESS-LEVEL                                          HR11.2  HR511
          DEPARTMENT                                             PA01.1  PA01.2
          JOB-CODE                                               PA01.3  PA02.1
          POSITION                                               PA100   PA102
                                                                 PA11.1  PA115
                                                                 PA13.1  PA13.2
                                                                 PA170   PA172
                                                                 PA201   PA211
                                                                 PA272   PA42.1
                                                                 PA42.3  PA45.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA535   PA70.1
                                                                 ...

                         PAASSIGNED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PAA-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When (PAA-DEPARTMENT != Spaces )

                            PAA-COMPANY          -> DPT-COMPANY
                            PAA-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PAA-DEPARTMENT       -> DPT-DEPARTMENT

Jobcode        JOBCODE      Required
                            When (PAA-JOB-CODE != Spaces )

                            PAA-COMPANY          -> JBC-COMPANY
                            PAA-JOB-CODE         -> JBC-JOB-CODE

Process Level  PRSYSTEM     Required
                            When (PAA-PROCESS-LEVEL != Spaces )

                            PAA-COMPANY          -> PRS-COMPANY
                            PAA-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         PAASSIGNED FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Budget         PABUDGET

                            PAA-COMPANY          -> PAB-COMPANY
                            PAA-POSITION         -> PAB-POSITION
                            PAA-PROCESS-LEVEL    -> PAB-PROCESS-LEVEL
                            PAA-DEPARTMENT       -> PAB-DEPARTMENT
                            PAA-JOB-CODE         -> PAB-JOB-CODE
                                                    PAB-EFFECT-DATE

Paencumber     PAENCUMBER

                            PAA-COMPANY          -> PEN-COMPANY
                            PAA-POSITION         -> PEN-POSITION
                            PAA-PROCESS-LEVEL    -> PEN-PROCESS-LEVEL
                            PAA-DEPARTMENT       -> PEN-DEPARTMENT
                            PAA-JOB-CODE         -> PEN-JOB-CODE
                                                    PEN-EMPLOYEE
                                                    PEN-GLT-OBJ-ID
                                                    PEN-ATN-OBJ-ID

Pos Rules      PAPOSRULE
                            Valid When (PAA-JOB-CODE != Spaces )

                            PAA-COMPANY          -> PPR-COMPANY
                            PAA-PROCESS-LEVEL    -> PPR-PROCESS-LEVEL
                            PAA-DEPARTMENT       -> PPR-DEPARTMENT
                                                    PPR-EFFECT-DATE

Position       PAPOSITION
                            Valid When (PAA-POSITION != Spaces )

                            PAA-COMPANY          -> POS-COMPANY
                            PAA-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE

Req No Pos     PAJOBREQ
                            Valid When (PAA-POSITION = Spaces )

                            PAA-COMPANY          -> PJR-COMPANY
                            PAA-PROCESS-LEVEL    -> PJR-PROCESS-LEVEL
                            PAA-DEPARTMENT       -> PJR-DEPARTMENT
                            PAA-JOB-CODE         -> PJR-JOB-CODE
                                                    PJR-REQUISITION

Req Position   PAJOBREQ
                            Valid When (PAA-POSITION != Spaces )

                            PAA-COMPANY          -> PJR-COMPANY
                            PAA-POSITION         -> PJR-POSITION
                                                    PJR-REQUISITION