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

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

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

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

PAA-EMP-FTE            Signed 8.3                                HR11.1  HR11.2
Employee Full Time     Contains the current full time            HR511   HR650
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   PA13.1
                       process level, department, and job code.  PA13.2  PA42.1
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PAA-INACT-EMPHDCNT     Signed 5.0                                HR11.1  HR11.2
Inactive Employee      Contains the current head count for       HR511   HR650
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   PA13.1
                       department, and job code.                 PA13.2  PA42.1
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PAA-INACT-EMP-FTE      Signed 8.3                                HR11.1  HR11.2
Element: Inactive EmloyContains the current full time            HR511   HR650
                       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   PA13.1
                       or process level, department, and job     PA13.2  PA42.1
                       code.                                     PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PAA-REQ-HDCNT          Signed 5.0                                HR11.1  HR11.2
Requisition Head       Contains the total count of remaining     HR511   HR650
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   PA13.1
                       must have a count value of 2 (Active) as  PA13.2  PA42.1
                       defined in HRO3 (Employee  Status         PA45.1  PA502
                       Codes).                                   PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

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

PAA-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR11.1  HR11.2
Element: Date Stamp    Contains the date (month, day, and        HR511   HR650
                       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  PA45.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-TIME-STAMP         Numeric 6  (hhmmss)                       HR11.1  HR11.2
Element: Time Stamp    Contains the time (hour, minute, and      HR511   HR650
                       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  PA45.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

PAA-USER-ID            Alpha 10  (Lower Case)                    HR11.1  HR11.2
Element: User ID       Contains the user ID of a user who has    HR511   HR650
                       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  PA45.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         PAASSIGNED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAASET1   COMPANY                                                HR00.1  HR01.1
          POSITION                                               HR11.1  HR11.2
          PROCESS-LEVEL                                          HR511   HR650
          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
                                                                 PA45.1  PA502
                                                                 PA513   PA52.1
                                                                 ...

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

                         PAASSIGNED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required
                            When (PAA-PROCESS-LEVEL = Spaces )

                            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

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