Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PABUDGET


                             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     PA82.1    BN305     HR11.1    HR11.2    HR511
PA01.1    PA01.2    PA01.3    PA100     PA102     PA11.1
PA115     PA13.1    PA13.2    PA201     PA271     PA272
PA42.1    PA42.3    PA513     PA52.1    PA52.3    PA52.4
PA52.5    PA535     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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

PAB-JOB-CODE           Alpha 9                                   PA171   PA172
Element: 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
Element: Effective DateContains the effective date of a          PA570   PA70.1
                       budget.                                   PA71.1  PA72.1
                                                                 PA73.1

PAB-END-DATE           Numeric 8  (yyyymmdd)                     PA170   PA171
Element: 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
Element: 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
Element: 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 11.6                               PA170   PA172
Element: Full Time EquiContains the budgeted full time           PA570   PA70.1
                       equivalent factor.                        PA71.1  PA72.1
                                                                 PA73.1  PA80.1

PAB-AUTH-FTE           Signed 11.6                               PA170   PA172
Element: Authorized FTEContains 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
Element: 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
Element: Authorized SalContains 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Acct Nd       The number of decimals assigned to a      PA570   PA70.1
                       particular account as determined by the   PA71.1  PA72.1
                       account currency.                         PA73.1


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

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

PAB-BASE-SALARY        Signed 11.2                               PA170   PA172
Element: Budget 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
Element: Budget Salary 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
                                                                 PA82.1

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

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

                         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

                            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

Paencumber     PAENCUMBER

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

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