PACLASSPOS

Position Class/Position Number

The Position Class/Position Number file is used to associate position numbers with position classes.
UPDATED BY
PA01.1 PA01.2 PA01.3 PA103 PA201 PA210
PA82.1 PR323 HCPO.1 PA02.1 PA302 PA502

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PQP-COMPANY
Element: Company		Numeric 4
Contains the company number which represents an established company.
PA01.1 PA01.2
PQP-POS-CLASS
Element: Position Class		Alpha 3
Contains the code that represents a position class.
PA01.1 PA01.2
PQP-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
PA01.1 PA01.2


PACLASSPOS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PQPSET1 COMPANY
POS-CLASS
POSITION
PA01.1 PA01.2
PA01.3 PA103
PA201 PA210
PA82.1 PR323
PQPSET2 COMPANY
POSITION
POS-CLASS
HCPO.1 PA01.2
PA02.1 PA302
PA502


PACLASSPOS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PQP-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Passigned PAASSIGNED Not Required
PQP-COMPANY->PAA-COMPANY
PQP-POSITION->PAA-POSITION
Spaces->PAA-PROCESS-LEVEL
Spaces->PAA-DEPARTMENT
Spaces->PAA-JOB-CODE
Pqp Class PACLASS Required
PQP-COMPANY->PAQ-COMPANY
PQP-POS-CLASS->PAQ-POS-CLASS


PACLASSPOS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pabudget PABUDGET
PQP-COMPANY->PAB-COMPANY
PQP-POSITION->PAB-POSITION
  PAB-EFFECT-DATE
  PAB-PROCESS-LEVEL
  PAB-DEPARTMENT
  PAB-JOB-CODE
Paencumber PAENCUMBER
PQP-COMPANY->PEN-COMPANY
PQP-POSITION->PEN-POSITION
Spaces->PEN-PROCESS-LEVEL
Spaces->PEN-DEPARTMENT
Spaces->PEN-JOB-CODE
  PEN-EMPLOYEE
  PEN-GLT-OBJ-ID
  PEN-ATN-OBJ-ID
Pqp Employee PATHFIND
PQP-COMPANY->PTF-COMPANY
126->PTF-FLD-NBR
PQP-POSITION->PTF-FLD-VALUE
  PTF-EMPLOYEE
  PTF-POS-LEVEL
Pqp Positions PAPOSITION Required
PQP-COMPANY->POS-COMPANY
PQP-POSITION->POS-POSITION
  POS-EFFECT-DATE

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

Home
Contact Us



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