Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PABUDGET FILE

                                 Budget

The Personnel Administration Budget file contains the budgeted head count,
FTE, or both. These budgeted counts are determined at one or more points
during the fiscal period. The budget file holds effective dated records. Both
historical and future records are maintained here.

REFERENCED BY

PA406     HR11.1    HR11.2    HR511     HR650     PA01.1
PA01.2    PA01.3    PA100     PA102     PA11.1    PA13.1
PA13.2    PA201     PA271     PA272     PA42.1    PA513
PA52.1    PA52.3    PA52.4    PA52.5    PA79.1    PA80.1
PA80.2    PR110     PR113     PR120     PR13.1    PR13.5
PR13.6    PR13.8

UPDATED BY

PA170     PA171     PA172     PA371     PA570     PA70.1
PA71.1    PA72.1    PA73.1    HR00.1    HR01.1    PA02.1
PA302     PA502     PBIP.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PAB-COMPANY          Numeric 4                                   PA172   PA570
Company              Contains the company number.                PA70.1  PA71.1
                                                                 PA72.1  PA73.1

PAB-POSITION         Alpha 12                                    PA172   PA570
Position             Contains the user-defined code that         PA70.1  PA72.1
                     represents a position in the company.

PAB-PROCESS-LEVEL    Alpha 5                                     PA171   PA172
Process Level        Contains the process level.                 PA570   PA70.1
                                                                 PA71.1  PA72.1
                                                                 PA73.1

PAB-DEPARTMENT       Alpha 5                                     PA171   PA172
Department           Contains the department.                    PA570   PA70.1
                                                                 PA71.1  PA72.1
                                                                 PA73.1

PAB-JOB-CODE         Alpha 9                                     PA171   PA172
Job Code             Contains a user-defined code that           PA570   PA70.1
                     represents a type of job.                   PA71.1  PA72.1
                                                                 PA73.1

PAB-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA171   PA172
Effective Date       Contains the effective date of a            PA570   PA70.1
                     budget.                                     PA71.1  PA72.1
                                                                 PA73.1

PAB-END-DATE         Numeric 8  (yyyymmdd)                       PA170   PA171
End Date             Contains the end date for a budget.         PA172   PA570
                                                                 PA70.1  PA71.1
                                                                 PA72.1  PA73.1

PAB-CHG-REASON       Alpha 10                                    PA170   PA172
Reason Code          Contains the reason a change was made       PA570   PA70.1
                     to the budget.                              PA71.1  PA72.1
                                                                 PA73.1

PAB-HDCNT            Numeric 5                                   PA170   PA172
Head Count           Contains the budgeted head count.           PA570   PA70.1
                                                                 PA71.1  PA72.1
                                                                 PA73.1  PA80.1

PAB-AUTH-HDCNT       Numeric 5                                   PA170   PA172
Authorized Head      Contains the authorized head count if       PA570   PA70.1
Count                authorized counts are used.                 PA71.1  PA72.1
                                                                 PA73.1  PA80.1

PAB-FTE              Signed 8.3                                  PA170   PA172
Full Time Equivalent Contains the budgeted full time             PA570   PA70.1
                     equivalent factor.                          PA71.1  PA72.1
                                                                 PA73.1  PA80.1

PAB-AUTH-FTE         Signed 8.3                                  PA170   PA172
Authorized FTE       Contains the authorized full time           PA570   PA70.1
                     equivalent factor if authorized counts      PA71.1  PA72.1
                     are used.                                   PA73.1  PA80.1

PAB-SALARY           Signed 11.2                                 PA170   PA172
Salary               Contains the budgeted salary as defined     PA570   PA70.1
                     by the user.                                PA71.1  PA72.1
                                                                 PA73.1

PAB-AUTH-SALARY      Signed 11.2                                 PA170   PA172
Authorized Salary    Contains the authorized salary as           PA570   PA70.1
                     defined by the user.                        PA71.1  PA72.1
                                                                 PA73.1

PAB-DATE-STAMP       Numeric 8  (yyyymmdd)                       PA170   PA171
Date Stamp           Contains the date (month, day, and          PA172   PA570
                     year) a change was made to the record.      PA70.1  PA71.1
                     Each date is tied to a user ID and time     PA72.1  PA73.1
                     to create a history of changes to the
                     record.

PAB-TIME-STAMP       Numeric 6  (hhmmss)                         PA170   PA171
Time Stamp           Contains the time (hour, minute, and        PA172   PA570
                     second) a change was made to the record.    PA70.1  PA71.1
                     Each time stamp is tied to a date and       PA72.1  PA73.1
                     user ID to create a history of changes
                     to the record.

PAB-USER-ID          Alpha 10  (Lower Case)                      PA170   PA171
User ID              Contains the user ID of a user who has      PA172   PA570
                     made changes to the record. The user ID     PA70.1  PA71.1
                     is tied to a date and time to create a      PA72.1  PA73.1
                     history of changes to the record.

PAB-CURRENCY-CODE    Alpha 5                                     PA170   PA172
Currency Code        Contains the currency in which the          PA570   PA70.1
                     salary is recorded.                         PA71.1  PA72.1
                                                                 PA73.1

PAB-CURR-ND          Numeric 1                                   PA170   PA172
Currency Number of   Represents the number of decimals           PA570   PA70.1
Decimals             defined for the currency of the object.     PA71.1  PA72.1
                                                                 PA73.1

PAB-BASE-CURRENCY    Alpha 5                                     PA170   PA172
Base Currency        Contains the company base currency.         PA570   PA70.1
                                                                 PA71.1  PA72.1
                                                                 PA73.1

PAB-BASE-ND          Numeric 1                                   PA170   PA172
Base Number Of       The number of decimal positions defined     PA570   PA70.1
Decimals             for the company base currency.              PA71.1  PA72.1
                                                                 PA73.1

PAB-BASE-SALARY      Signed 11.2                                 PA170   PA172
Base Salary          Contains the budgeted salary in the         PA570   PA70.1
                     company's base currency.                    PA71.1  PA72.1
                                                                 PA73.1

PAB-BASE-AUTH-SAL    Signed 11.2                                 PA170   PA172
Base Auth Sal        Contains the authorized salary in the       PA570   PA70.1
                     company's base currency.                    PA71.1  PA72.1
                                                                 PA73.1

                         PABUDGET FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PABSET1   COMPANY                                                HR00.1  HR01.1
          POSITION                                               PA02.1  PA172
          PROCESS-LEVEL                                          PA302   PA406
          DEPARTMENT                                             PA502   PA570
          JOB-CODE                                               PA70.1  PA71.1
          EFFECT-DATE                                            PA72.1  PA73.1
                                                                 PBIP.1  PR197

PABSET2   COMPANY       Subset                                   HR11.1  HR11.2
          POSITION      Where (POSITION != Spaces )              HR511   HR650
          EFFECT-DATE*                                           PA01.1  PA01.2
          PROCESS-LEVEL                                          PA01.3  PA02.1
          DEPARTMENT                                             PA100   PA102
          JOB-CODE                                               PA11.1  PA13.1
                                                                 PA13.2  PA170
                                                                 PA172   PA201
                                                                 PA271   PA272
                                                                 PA371   PA42.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA570   PA70.1
                                                                 PA71.1  PA72.1
                                                                 ...

PABSET3   COMPANY       Subset                                   HR11.1  HR11.2
          PROCESS-LEVEL Where (POSITION = Spaces )               HR511   HR650
          DEPARTMENT                                             PA01.1  PA01.2
          JOB-CODE                                               PA01.3  PA02.1
          EFFECT-DATE*                                           PA100   PA102
          POSITION                                               PA11.1  PA13.1
                                                                 PA13.2  PA170
                                                                 PA171   PA172
                                                                 PA201   PA271
                                                                 PA272   PA371
                                                                 PA42.1  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA570
                                                                 PA70.1  PA71.1
                                                                 ...

                         PABUDGET FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required
                            When PAB-CURRENCY-CODE != Spaces

                            PAB-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Chg Reason     PCODES       Required
                            When (PAB-CHG-REASON != Spaces )

                            "BD"                 -> PCO-TYPE
                            PAB-CHG-REASON       -> PCO-CODE

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

                            PAB-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When PAB-CURRENCY-CODE != Spaces

                            PAB-CURRENCY-CODE    -> CUC-CURRENCY-CODE

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

                            PAB-COMPANY          -> DPT-COMPANY
                            PAB-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PAB-DEPARTMENT       -> DPT-DEPARTMENT

Job Code       JOBCODE      Required
                            When (PAB-JOB-CODE != Spaces )

                            PAB-COMPANY          -> JBC-COMPANY
                            PAB-JOB-CODE         -> JBC-JOB-CODE

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

                            PAB-COMPANY          -> PRS-COMPANY
                            PAB-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         PABUDGET FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

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

Position       PAPOSITION   Required
                            When (PAB-POSITION != Spaces )

                            PAB-COMPANY          -> POS-COMPANY
                            PAB-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE

Req Job        PAJOBREQ
                            Valid When (PAB-JOB-CODE != Spaces )

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

Req Pos        PAJOBREQ
                            Valid When (PAB-POSITION != Spaces )

                            PAB-COMPANY          -> PJR-COMPANY
                            PAB-POSITION         -> PJR-POSITION
                                                    PJR-REQUISITION