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     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     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   PA02.1
                                                                 PA100   PA102
                                                                 PA11.1  PA111
                                                                 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                                  HR11.1  HR11.2
Element: Position      Contains the user-defined code that       HR511   PA02.1
                       represents a type of position.            PA100   PA102
                                                                 PA11.1  PA111
                                                                 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                                   HR11.1  HR11.2
Element: Process Level Contains the process level.               HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA11.1  PA111
                                                                 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                                   HR11.1  HR11.2
Element: Department    Contains the department.                  HR511   PA02.1
                                                                 PA100   PA102
                                                                 PA11.1  PA111
                                                                 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                                   HR11.1  HR11.2
Element: Job Code      Contains a user-defined code that         HR511   PA02.1
                       represents a type of job.                 PA100   PA102
                                                                 PA11.1  PA111
                                                                 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                                HR11.1  HR11.2
Element: Employee Head Contains the current head count for       HR511   PA02.1
                       employees by count category. Count        PA100   PA102
                       category can be position; process level   PA11.1  PA111
                       and job code; or process level,           PA13.1  PA13.2
                       department, and job 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-EMP-FTE            Signed 11.6                               HR11.1  HR11.2
Employee Full Time     Contains the current full time            HR511   PA02.1
Equivalent             equivalent factor for employees by count  PA100   PA102
                       category. Count category can be           PA11.1  PA111
                       position; process level and job code; or  PA13.1  PA13.2
                       process level, department, and job 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-INACT-EMPHDCNT     Signed 5.0                                HR11.1  HR11.2
Inactive Employee      Contains the current head count for       HR511   PA02.1
Head Count             inactive employees by count category.     PA100   PA102
                       Count category can be position; process   PA11.1  PA111
                       level and job code; or process level,     PA13.1  PA13.2
                       department, and job 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-INACT-EMP-FTE      Signed 11.6                               HR11.1  HR11.2
Element: Inactive EmloyContains the current full time            HR511   PA02.1
                       equivalent factor for inactive employees  PA100   PA102
                       by count category. Count category can be  PA11.1  PA111
                        position; process level and job code;    PA13.1  PA13.2
                       or process level, department, and job     PA42.1  PA42.3
                       code.                                     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                                HR11.1  HR11.2
Requisition Head       Contains the total count of remaining     HR511   PA02.1
Count                  openings for active requisitions by       PA100   PA102
                       count category. To be  included in this   PA11.1  PA111
                       count,  the requisition  must status      PA13.1  PA13.2
                       must have a count value of 2 (Active) as  PA42.1  PA42.3
                       defined in HRO3 (Employee  Status         PA45.1  PA502
                       Codes).                                   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                               HR11.1  HR11.2
Element: Requisition FTContains the total remaining full time    HR511   PA02.1
                       equivalent factor for active              PA100   PA102
                       requisitions by count category. To be     PA11.1  PA111
                       included in this count, a requisition     PA13.1  PA13.2
                       must have a count status of 2 (Active)    PA42.1  PA42.3
                       as defined in HR03 (Employee Status       PA45.1  PA502
                       Codes).                                   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)                     HR11.1  HR11.2
Element: Date Stamp    Contains the date (month, day, and        HR511   PA02.1
                       year) a change was made to the record.    PA100   PA102
                       Each date is tied to a user ID and time   PA11.1  PA111
                       to create a history of changes to the     PA115   PA13.1
                       record.                                   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)                       HR11.1  HR11.2
Element: Time Stamp    Contains the time (hour, minute, and      HR511   PA02.1
                       second) a change was made to the record.  PA100   PA102
                       Each time stamp is tied to a date and     PA11.1  PA111
                       user ID to create a history of changes    PA115   PA13.1
                       to the record.                            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)                    HR11.1  HR11.2
Element: User ID       Contains the user ID of a user who has    HR511   PA02.1
                       made changes to the record. The user ID   PA100   PA102
                       is tied to a date and time to create a    PA11.1  PA111
                       history of changes to the record.         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                                                HR00.1  HR01.1
          POSITION                                               HR11.1  HR11.2
          PROCESS-LEVEL                                          HR511   PA01.1
          DEPARTMENT                                             PA01.2  PA01.3
          JOB-CODE                                               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   PA52.1
                                                                 ...

PAASET2   COMPANY                                                HR11.1  HR11.2
          PROCESS-LEVEL                                          HR511   PA01.1
          DEPARTMENT                                             PA01.2  PA01.3
          JOB-CODE                                               PA02.1  PA100
          POSITION                                               PA102   PA11.1
                                                                 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
                                                                 PA71.1  PA79.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