|
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 HR650 PA02.1 PA100
PA102 PA11.1 PA111 PA115 PA13.1 PA13.2
PA42.1 PA45.1 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 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 HR650
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 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 HR650
represents a type of position. 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 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 HR650
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 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 HR650
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 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 HR650
represents a type of job. 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 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 HR650
employees by count category. Count PA02.1 PA100
category can be position; process level PA102 PA11.1
and job code; or process level, PA111 PA13.1
department, and job code. PA13.2 PA42.1
PA45.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PAA-EMP-FTE Signed 8.3 HR11.1 HR11.2
Employee Full Time Contains the current full time HR511 HR650
Equivalent equivalent factor for employees by count PA02.1 PA100
category. Count category can be PA102 PA11.1
position; process level and job code; or PA111 PA13.1
process level, department, and job code. PA13.2 PA42.1
PA45.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 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 HR650
Head Count inactive employees by count category. PA02.1 PA100
Count category can be position; process PA102 PA11.1
level and job code; or process level, PA111 PA13.1
department, and job code. PA13.2 PA42.1
PA45.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PAA-INACT-EMP-FTE Signed 8.3 HR11.1 HR11.2
Element: Inactive EmloyContains the current full time HR511 HR650
equivalent factor for inactive employees PA02.1 PA100
by count category. Count category can be PA102 PA11.1
position; process level and job code; PA111 PA13.1
or process level, department, and job PA13.2 PA42.1
code. PA45.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 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 HR650
Count openings for active requisitions by PA02.1 PA100
count category. To be included in this PA102 PA11.1
count, the requisition must status PA111 PA13.1
must have a count value of 2 (Active) as PA13.2 PA42.1
defined in HRO3 (Employee Status PA45.1 PA502
Codes). PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PAA-REQ-FTE Signed 8.3 HR11.1 HR11.2
Element: Requisition FTContains the total remaining full time HR511 HR650
equivalent factor for active PA02.1 PA100
requisitions by count category. To be PA102 PA11.1
included in this count, a requisition PA111 PA13.1
must have a count status of 2 (Active) PA13.2 PA42.1
as defined in HR03 (Employee Status PA45.1 PA502
Codes). PA513 PA52.1
PA52.3 PA52.4
PA52.5 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 HR650
year) a change was made to the record. PA02.1 PA100
Each date is tied to a user ID and time PA102 PA11.1
to create a history of changes to the PA111 PA115
record. PA13.1 PA13.2
PA42.1 PA45.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
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 HR650
second) a change was made to the record. PA02.1 PA100
Each time stamp is tied to a date and PA102 PA11.1
user ID to create a history of changes PA111 PA115
to the record. PA13.1 PA13.2
PA42.1 PA45.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
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 HR650
made changes to the record. The user ID PA02.1 PA100
is tied to a date and time to create a PA102 PA11.1
history of changes to the record. PA111 PA115
PA13.1 PA13.2
PA42.1 PA45.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
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 HR650
DEPARTMENT PA01.1 PA01.2
JOB-CODE PA01.3 PA02.1
PA100 PA102
PA11.1 PA111
PA115 PA13.1
PA13.2 PA170
PA171 PA172
PA201 PA211
PA272 PA302
PA371 PA42.1
PA45.1 PA502
PA513 PA52.1
...
PAASET2 COMPANY HR11.1 HR11.2
PROCESS-LEVEL HR511 HR650
DEPARTMENT PA01.1 PA01.2
JOB-CODE PA01.3 PA02.1
POSITION PA100 PA102
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
...
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
|