PAASSIGNED

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 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 PR13.9
HR00.1 HR01.1 PA211 PA272 PA302

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAA-COMPANY
Element: Company		Numeric 4
Contains the company number.
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 PR13.9
PAA-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a type of position.
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 PR13.9
PAA-PROCESS-LEVEL
Element: Process Level		Alpha 5
Contains the process level.
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 PR13.9
PAA-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
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 PR13.9
PAA-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
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 PR13.9
PAA-EMP-HDCNT
Element: Employee Head Count		Signed 5.0
Contains the current head count for employees by count category. Count category can be position; process level and job code; or process level, department, and job code.
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 PR13.9
PAA-EMP-FTE
Employee Full Time
Equivalent		Signed 11.6
Contains the current full time equivalent factor for employees by count category. Count category can be position; process level and job code; or process level, department, and job code.
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 PR13.9
PAA-INACT-EMPHDCNT
Inactive Employee
Head Count		Signed 5.0
Contains the current head count for inactive employees by count category. Count category can be position; process level and job code; or process level, department, and job code.
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 PR13.9
PAA-INACT-EMP-FTE
Element: Inactive Emloyee FTE		Signed 11.6
Contains the current full time equivalent factor for inactive employees by count category. Count category can be position; process level and job code; or process level, department, and job code.
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 PR13.9
PAA-REQ-HDCNT
Requisition Head
Count		Signed 5.0
Contains the total count of remaining openings for active requisitions by count category. To be included in this count, the requisition must status must have a count value of 2 (Active) as defined in HRO3 (Employee Status Codes).
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 PR13.9
PAA-REQ-FTE
Element: Requisition FTE		Signed 11.6
Contains the total remaining full time equivalent factor for active requisitions by count category. To be included in this count, a requisition must have a count status of 2 (Active) as defined in HR03 (Employee Status Codes).
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 PR13.9
PAA-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
Contains the date (month, day, and year) a change was made to the record. Each date is tied to a user ID and time to create a history of changes to the record.
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 PR13.9
PAA-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the time (hour, minute, and second) a change was made to the record. Each time stamp is tied to a date and user ID to create a history of changes to the record.
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 PR13.9
PAA-USER-ID
Element: User ID		Alpha 10 (Lower Case)
Contains the user ID of a user who has made changes to the record. The user ID is tied to a date and time to create a history of changes to the record.
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 PR13.9


PAASSIGNED FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAASET1 COMPANY
POSITION
PROCESS-LEVEL
DEPARTMENT
JOB-CODE
...
BN305 HR00.1
HR01.1 HR11.1
HR11.2 HR511
PA01.1 PA01.2
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
PROCESS-LEVEL
DEPARTMENT
JOB-CODE
POSITION
...
BN305 HR11.1
HR11.2 HR511
PA01.1 PA01.2
PA01.3 PA02.1
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
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:50:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.