|
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
BN305 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAA-COMPANY Numeric 4 BN305 HR11.1
Element: Company Contains the company number. 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
PAA-POSITION Alpha 12 BN305 HR11.1
Element: Position Contains the user-defined code that HR11.2 HR511
represents a type of position. 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
PAA-PROCESS-LEVEL Alpha 5 BN305 HR11.1
Element: Process Level Contains the process level. 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
PAA-DEPARTMENT Alpha 5 BN305 HR11.1
Element: Department Contains the department. 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
PAA-JOB-CODE Alpha 9 BN305 HR11.1
Element: Job Code Contains a user-defined code that HR11.2 HR511
represents a type of job. 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
PAA-EMP-HDCNT Signed 5.0 BN305 HR11.1
Element: Employee Head Contains the current head count for HR11.2 HR511
employees by count category. Count PA02.1 PA100
category can be position; process level PA102 PA11.1
and job code; or process level, PA111 PA115
department, and job code. 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-FTE Signed 11.6 BN305 HR11.1
Employee Full Time Contains the current full time HR11.2 HR511
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 PA115
process level, department, and job code. 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-INACT-EMPHDCNT Signed 5.0 BN305 HR11.1
Inactive Employee Contains the current head count for HR11.2 HR511
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 PA115
department, and job code. 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-INACT-EMP-FTE Signed 11.6 BN305 HR11.1
Element: Inactive EmloyContains the current full time HR11.2 HR511
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 PA115
or process level, department, and job PA13.1 PA13.2
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-REQ-HDCNT Signed 5.0 BN305 HR11.1
Requisition Head Contains the total count of remaining HR11.2 HR511
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 PA115
must have a count value of 2 (Active) as PA13.1 PA13.2
defined in HRO3 (Employee Status PA42.1 PA42.3
Codes). 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-FTE Signed 11.6 BN305 HR11.1
Element: Requisition FTContains the total remaining full time HR11.2 HR511
equivalent factor for active PA02.1 PA100
requisitions by count category. To be PA102 PA11.1
included in this count, a requisition PA111 PA115
must have a count status of 2 (Active) PA13.1 PA13.2
as defined in HR03 (Employee Status PA42.1 PA42.3
Codes). 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-DATE-STAMP Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Date Stamp Contains the date (month, day, and HR11.2 HR511
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 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) BN305 HR11.1
Element: Time Stamp Contains the time (hour, minute, and HR11.2 HR511
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 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) BN305 HR11.1
Element: User ID Contains the user ID of a user who has HR11.2 HR511
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 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 BN305 HR00.1
POSITION HR01.1 HR11.1
PROCESS-LEVEL HR11.2 HR511
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
PA42.3 PA45.1
PA502 PA513
...
PAASET2 COMPANY BN305 HR11.1
PROCESS-LEVEL HR11.2 HR511
DEPARTMENT PA01.1 PA01.2
JOB-CODE PA01.3 PA02.1
POSITION PA100 PA102
PA11.1 PA115
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
...
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
|