PAPOSERR FILE
Position Errors
Holds information that is error when you run PA02.1 (Positions).
UPDATED BY
PA02.1 PA03.2 PA03.1 PA100 PA102 PA502
PA52.1 PA52.5 HR00.1 HR01.1 HR11.1 PA115
PA42.1 PA42.3 PA535 PA302
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPE-COMPANY Numeric 4 PA02.1 PA102
Element: Company Hr PA502 PA52.1
PA52.5
PPE-EMPLOYEE Numeric 9 PA02.1 PA102
Element: Employee Contains the employee number. Each PA502 PA52.1
person employed by the company is PA52.5
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PPE-REQUISITION Numeric 9 PA02.1 PA102
Element: Requisition Contains the requisition. PA502 PA52.1
PA52.5
PPE-POSITION Alpha 12 PA02.1 PA102
Element: Position Contains the user-defined code that PA502 PA52.1
represents a position in the company. PA52.5
PPE-EFFECT-DATE Numeric 8 (yyyymmdd) PA02.1 PA102
Element: Effect Date Contains the position effective date. PA502 PA52.1
PA52.5
PPE-UPDATE-TYPE Alpha 3 PA02.1 PA102
Element: Update Type Indicates why the change could not be PA502 PA52.1
performed. Data Change indicates an PA52.5
action exists for an employee; End Date
indicates the position has ended; and
Upd Error indicates a general error.
1 = Data Change
2 = End Date
3 = Upd Error
PPE-POS-LEVEL Numeric 2 Occurs 98 Times PA02.1 PA100
Element: Pos Level Contains the position level. PA102 PA502
PA52.1 PA52.5
PAPOSERR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPESET1 COMPANY HR00.1 HR01.1
EMPLOYEE HR11.1 PA02.1
REQUISITION PA100 PA102
POSITION PA115 PA42.1
EFFECT-DATE PA42.3 PA502
UPDATE-TYPE PA535
PPESET2 COMPANY PA02.1 PA03.1
POSITION PA03.2 PA03.3
EFFECT-DATE PA102 PA302
EMPLOYEE PA502 PA52.1
REQUISITION PA52.5
UPDATE-TYPE
PAPOSERR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PPE-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When (PPE-EMPLOYEE != Zeroes )
PPE-COMPANY -> EMP-COMPANY
PPE-EMPLOYEE -> EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
When (PPE-EMPLOYEE != Zeroes )
PPE-COMPANY -> PEM-COMPANY
PPE-EMPLOYEE -> PEM-EMPLOYEE
Position PAPOSITION Required
PPE-COMPANY -> POS-COMPANY
PPE-POSITION -> POS-POSITION
PPE-EFFECT-DATE -> POS-EFFECT-DATE
Requisition PAJOBREQ Required
When (PPE-REQUISITION != Zeroes )
PPE-COMPANY -> PJR-COMPANY
PPE-REQUISITION -> PJR-REQUISITION
PAPOSERR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mult Pos PAEMPPOS
Valid When (PPE-EMPLOYEE != Zeroes )
PPE-COMPANY -> PEP-COMPANY
PPE-EMPLOYEE -> PEP-EMPLOYEE
PEP-POS-LEVEL
PEP-EFFECT-DATE
Pos Chg PAPOSCHG
PPE-COMPANY -> PPC-COMPANY
PPE-POSITION -> PPC-POSITION
PPE-EFFECT-DATE -> PPC-EFFECT-DATE
PPC-FLD-NBR
|