PABUDGET – Budget

System: Personnel (PA)
Prefix: PAB
Primary key: COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE, EFFECT-DATE
Fields: 23
Updated by: 17 programs
Referenced by: 42 programs

PABUDGET is the Budget table in Lawson Personnel (prefix PAB). It is indexed by COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE, EFFECT-DATE (PABSET1); alternate indexes: PABSET2 and PABSET3. It is related 1:1 to CUCODES, PCODES, PRSYSTEM, DEPTCODE and JOBCODE and 1:M to PAENCUMBER, PAPOSRULE, PAPOSITION and PAJOBREQ. It is updated by HR00.1, HR01.1, LT101, LT111, PA02.1, PA170, PA171, PA172 and 9 more and referenced by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, PA01.1, PA01.2 and 34 more. The table has 23 fields, 3 indexes and 12 documented relations.

About PABUDGET

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.

Fields (23)

Column = COBOL field name without the PAB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PAB-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-POSITION` PK POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	PA172, PA570, PA70.1, PA72.1
`PAB-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	Contains the process level.	PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-DEPARTMENT` PK DEPARTMENT	Alpha 5	Contains the department.	PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-JOB-CODE` PK JOB_CODE	Alpha 9	Contains a user-defined code that represents a type of job.	PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-EFFECT-DATE` PK EFFECT_DATE	Numeric 8 (yyyymmdd)	Contains the effective date of a budget.	PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	Contains the end date for a budget.	PA170, PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-CHG-REASON` CHG_REASON	Alpha 10	Contains the reason a change was made to the budget.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-HDCNT` HDCNT	Numeric 5	Contains the budgeted head count.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1, PA80.1
`PAB-AUTH-HDCNT` AUTH_HDCNT	Numeric 5	Contains the authorized head count if authorized counts are used.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1, PA80.1
`PAB-FTE` FTE	Signed 11.6	Contains the budgeted full time equivalent factor.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1, PA80.1
`PAB-AUTH-FTE` AUTH_FTE	Signed 11.6	Contains the authorized full time equivalent factor if authorized counts are used.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1, PA80.1
`PAB-SALARY` SALARY	Signed 11.2	Contains the budgeted salary as defined by the user.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-AUTH-SALARY` AUTH_SALARY	Signed 11.2	Contains the authorized salary as defined by the user.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	Contains the date (month, day, and year) a change was made to the record. Each date is tied to a user ID and time to create a history of changes to the record.	PA170, PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the time (hour, minute, and second) a change was made to the record. Each time stamp is tied to a date and user ID to create a history of changes to the record.	PA170, PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of a user who has made changes to the record. The user ID is tied to a date and time to create a history of changes to the record.	PA170, PA171, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the salary is recorded.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	Contains the company base currency.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-BASE-SALARY` BASE_SALARY	Signed 11.2	Contains the budgeted salary in the company's base currency.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1
`PAB-BASE-AUTH-SAL` BASE_AUTH_SAL	Signed 11.2	Contains the authorized salary in the company's base currency.	PA170, PA172, PA570, PA70.1, PA71.1, PA72.1, PA73.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PABSET1`	`COMPANY`, `POSITION`, `PROCESS-LEVEL`, `DEPARTMENT`, `JOB-CODE`, `EFFECT-DATE`	Primary		HR00.1, HR01.1, LT101, LT111, PA02.1, PA172, PA302, PA406 +7 more
`PABSET2`	`COMPANY`, `POSITION`, `EFFECT-DATE*`, `PROCESS-LEVEL`, `DEPARTMENT`, `JOB-CODE`	Subset	Where (POSITION != Spaces)	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
`PABSET3`	`COMPANY`, `PROCESS-LEVEL`, `DEPARTMENT`, `JOB-CODE`, `EFFECT-DATE*`, `POSITION`	Subset	Where (POSITION = Spaces)	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (5) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (17)

HR00.1 Company
HR01.1 Process Level
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA170 Budget Update
PA171 Job Budget Transfer
PA172 Initiate Preliminary Budget Data
PA302 Position Purge
PA371 Budget Purge
PA502 Position Conversion
PA570 Budget Conversion
PA70.1 Position Budget
PA71.1 Job Budget
PA72.1 Preliminary Position Budget
PA73.1 Preliminary Job Budget
PA82.1 Salary Encumbrance Inquiry

Referenced by (42)

BN305 Highly Compensated Employees
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
PA01.1 Position Class
PA01.2 Position Class by Position
PA01.3 Position Class Totals
PA100 Action Update
PA102 Position Update
PA11.1 Assigned Resources
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA201 Position Class Listing
PA271 Budget Listing
PA272 Budget and Assigned Resource Listing
PA406 Position Rules Audit Listing
PA42.1 Requisition
PA42.3 Requisition Approval Override
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA535 e-Recruiting Requisition Conversion
PA79.1 Current Totals
PA80.1 Position Budget Inquiry
PA80.2 Job Budget Inquiry
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP