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