PAASSIGNED – Assigned Resources

System: Personnel (PA)
Prefix: PAA
Primary key: COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE
Fields: 14
Updated by: 41 programs
Referenced by: 15 programs

PAASSIGNED is the Assigned Resources table in Lawson Personnel (prefix PAA). It is indexed by COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE (PAASET1); alternate indexes: PAASET2. It is related 1:1 to PRSYSTEM, DEPTCODE and JOBCODE and 1:M to PABUDGET, PAENCUMBER, PAPOSRULE, PAPOSITION and PAJOBREQ. It is updated by BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 and 33 more and referenced by PA01.1, PA01.2, PA01.3, PA170, PA171, PA172, PA201, PA211 and 7 more. The table has 14 fields, 2 indexes and 10 documented relations.

About PAASSIGNED

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.

Fields (14)

Column = COBOL field name without the PAA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`PAA-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-POSITION` PK POSITION	Alpha 12	Contains the user-defined code that represents a type of position.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	Contains the process level.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-DEPARTMENT` PK DEPARTMENT	Alpha 5	Contains the department.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-JOB-CODE` PK JOB_CODE	Alpha 9	Contains a user-defined code that represents a type of job.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-EMP-HDCNT` EMP_HDCNT	Signed 5.0	Contains the current head count for employees by count category. Count category can be position; process level and job code; or process level, department, and job code.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-EMP-FTE` EMP_FTE	Signed 11.6	Contains the current full time equivalent factor for employees by count category. Count category can be position; process level and job code; or process level, department, and job code.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-INACT-EMPHDCNT` INACT_EMPHDCNT	Signed 5.0	Contains the current head count for inactive employees by count category. Count category can be position; process level and job code; or process level, department, and job code.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-INACT-EMP-FTE` INACT_EMP_FTE	Signed 11.6	Contains the current full time equivalent factor for inactive employees by count category. Count category can be position; process level and job code; or process level, department, and job code.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-REQ-HDCNT` REQ_HDCNT	Signed 5.0	Contains the total count of remaining openings for active requisitions by count category. To be included in this count, the requisition must status must have a count value of 2 (Active) as defined in HRO3 (Employee Status Codes).	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-REQ-FTE` REQ_FTE	Signed 11.6	Contains the total remaining full time equivalent factor for active requisitions by count category. To be included in this count, a requisition must have a count status of 2 (Active) as defined in HR03 (Employee Status Codes).	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-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.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-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.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more
#`PAA-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.	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PAASET1`	`COMPANY` `POSITION` `PROCESS-LEVEL` `DEPARTMENT` `JOB-CODE`	Primary		BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 +22 more (list truncated in source)
`PAASET2`	`COMPANY` `PROCESS-LEVEL` `DEPARTMENT` `JOB-CODE` `POSITION`			BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (4) — lookups and parents

Relation Table Rules Condition Field map

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`

One to many (6) — child tables

Relation Table Rules Condition Field map

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`

Programs

Updated by (41)

BN305 Highly Compensated Employees
HR00.1 Company
HR01.1 Process Level
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA11.1 Assigned Resources
PA111 Recalculate Assigned Resources
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA302 Position Purge
PA42.1 Requisition
PA42.3 Requisition Approval Override
PA45.1 Requisition Offers
PA502 Position Conversion
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
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

Referenced by (15)

PA01.1 Position Class
PA01.2 Position Class by Position
PA01.3 Position Class Totals
PA170 Budget Update
PA171 Job Budget Transfer
PA172 Initiate Preliminary Budget Data
PA201 Position Class Listing
PA211 Assigned Resource Listing
PA272 Budget and Assigned Resource Listing
PA371 Budget Purge
PA70.1 Position Budget
PA71.1 Job Budget
PA79.1 Current Totals
PA80.1 Position Budget Inquiry
PA80.2 Job Budget Inquiry

PAASSIGNED – Assigned Resources

About PAASSIGNED

Fields (14) Copy as SQL

Indexes (2)

Relations

One to one (4) — lookups and parents

One to many (6) — child tables

Programs

Updated by (41)

Referenced by (15)

Fields (14)