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