 |
Lawson Insight Technical Documentation |
|
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
HR511 HR650 PA11.1 PA111 PA42.1 PA45.1
PA502 PA513 PR13.1 PR13.5 PR13.6 PR13.8
HR00.1 HR01.1 PA302 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAA-COMPANY Numeric 4 HR511 HR650
Company Contains the company number. PA11.1 PA111
PA42.1 PA45.1
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
PAA-POSITION Alpha 12 HR511 HR650
Position Contains the user-defined code that PA11.1 PA111
represents a type of position. PA42.1 PA45.1
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
PAA-PROCESS-LEVEL Alpha 5 HR511 HR650
Process Level Contains the process level. PA11.1 PA111
PA42.1 PA45.1
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
PAA-DEPARTMENT Alpha 5 HR511 HR650
Department Contains the department. PA11.1 PA111
PA42.1 PA45.1
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
PAA-JOB-CODE Alpha 9 HR511 HR650
Job Code Contains a user-defined code that PA11.1 PA111
represents a type of job. PA42.1 PA45.1
PA502 PA513
PR13.1 PR13.5
PR13.6 PR13.8
PAA-EMP-HDCNT Signed 5.0 HR511 HR650
Employee Head Count Contains the current head count for PA11.1 PA111
employees by count category. Count PA42.1 PA45.1
category can be position; process level PA502 PA513
and job code; or process level, PR13.1 PR13.5
department, and job code. PR13.6 PR13.8
PAA-EMP-FTE Signed 8.3 HR511 HR650
Employee Full Time Contains the current full time PA11.1 PA111
Equivalent equivalent factor for employees by count PA42.1 PA45.1
category. Count category can be PA502 PA513
position; process level and job code; or PR13.1 PR13.5
process level, department, and job code. PR13.6 PR13.8
PAA-INACT-EMPHDCNT Signed 5.0 HR511 HR650
Inactive Employee Contains the current head count for PA11.1 PA111
Head Count inactive employees by count category. PA42.1 PA45.1
Count category can be position; process PA502 PA513
level and job code; or process level, PR13.1 PR13.5
department, and job code. PR13.6 PR13.8
PAA-INACT-EMP-FTE Signed 8.3 HR511 HR650
Inactive Emloyee FTE Contains the current full time PA11.1 PA111
equivalent factor for inactive employees PA42.1 PA45.1
by count category. Count category can be PA502 PA513
position; process level and job code; PR13.1 PR13.5
or process level, department, and job PR13.6 PR13.8
code.
PAA-REQ-HDCNT Signed 5.0 HR511 HR650
Requisition Head Contains the total count of remaining PA11.1 PA111
Count openings for active requisitions by PA42.1 PA45.1
count category. To be included in this PA502 PA513
count, the requisition must status PR13.1 PR13.5
must have a count value of 2 (Active) as PR13.6 PR13.8
defined in HRO3 (Employee Status
Codes).
PAA-REQ-FTE Signed 8.3 HR511 HR650
Requisition FTE Contains the total remaining full time PA11.1 PA111
equivalent factor for active PA42.1 PA45.1
requisitions by count category. To be PA502 PA513
included in this count, a requisition PR13.1 PR13.5
must have a count status of 2 (Active) PR13.6 PR13.8
as defined in HR03 (Employee Status
Codes).
PAA-DATE-STAMP Numeric 8 (yyyymmdd) HR511 HR650
Date Stamp Contains the date (month, day, and PA11.1 PA111
year) a change was made to the record. PA42.1 PA45.1
Each date is tied to a user ID and time PA502 PA513
to create a history of changes to the PR13.1 PR13.5
record. PR13.6 PR13.8
PAA-TIME-STAMP Numeric 6 (hhmmss) HR511 HR650
Time Stamp Contains the time (hour, minute, and PA11.1 PA111
second) a change was made to the record. PA42.1 PA45.1
Each time stamp is tied to a date and PA502 PA513
user ID to create a history of changes PR13.1 PR13.5
to the record. PR13.6 PR13.8
PAA-USER-ID Alpha 10 (Lower Case) HR511 HR650
User ID Contains the user ID of a user who has PA11.1 PA111
made changes to the record. The user ID PA42.1 PA45.1
is tied to a date and time to create a PA502 PA513
history of changes to the record. 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 HR511 HR650
PROCESS-LEVEL PA01.1 PA01.2
DEPARTMENT PA01.3 PA11.1
JOB-CODE PA111 PA170
PA171 PA172
PA201 PA211
PA272 PA302
PA371 PA42.1
PA45.1 PA502
PA513 PA70.1
PA71.1 PA79.1
PA80.1 PA80.2
PR13.1 PR13.5
PR13.6 PR13.8
...
PAASET2 COMPANY HR511 HR650
PROCESS-LEVEL PA01.1 PA01.2
DEPARTMENT PA01.3 PA11.1
JOB-CODE PA170 PA172
POSITION PA201 PA211
PA272 PA42.1
PA45.1 PA502
PA513 PA70.1
PA71.1 PA79.1
PA80.1 PA80.2
PR13.1 PR13.5
PR13.6 PR13.8
PAASSIGNED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
When (PAA-PROCESS-LEVEL = Spaces )
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
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
|