PAOFFLANG FILE
REFERENCED BY
PA296
UPDATED BY
PA96.1 HR00.1 HR01.1 PA302 PA502 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLA-COMPANY Numeric 4 PA96.1
Company The company number represents an
established company and is entered on
all function codes.
PLA-EMPLOYEE Numeric 9 PA96.1
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PLA-POSITION Alpha 12 PA96.1
Position Contains the user-defined code that
represents a position in the company.
PLA-REPORT-TYPE Alpha 1 PA96.1
EEO Report Type 1 = Service to Public
2 = Internal Services
3 = Supervision
PLA-SEQ-NBR Numeric 4 PA96.1
Sequence Number An automatically assigned sequence
number.
PLA-EFFECT-DATE Numeric 8 (yyyymmdd) PA96.1
Effective Date
PLA-END-DATE Numeric 8 (yyyymmdd) PA96.1
Ending Date The ending date in a range of dates.
PLA-TYPE Alpha 2 PA96.1
Type This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
BO = Bilingual Office
BR = Billingual Region
PLA-CODE Alpha 10 PA96.1
Code
PLA-DATE Numeric 8 (yyyymmdd) PA96.1
Date This field displays the system date
when this was created.
PAOFFLANG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLASET1 COMPANY HR00.1 HR01.1
EMPLOYEE PA302 PA502
POSITION PA96.1 PR197
REPORT-TYPE
SEQ-NBR
PLASET2 COMPANY KeyChange PA296 PA96.1
EMPLOYEE
POSITION
REPORT-TYPE
DATE*
SEQ-NBR
PAOFFLANG FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PLA-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When PLA-EMPLOYEE != Zeroes
PLA-COMPANY -> EMP-COMPANY
PLA-EMPLOYEE -> EMP-EMPLOYEE
Office PCODES Required
When PLA-TYPE = "BO"
PLA-TYPE -> PCO-TYPE
PLA-CODE -> PCO-CODE
Paemployee PAEMPLOYEE Required
When PLA-EMPLOYEE != Zeroes
PLA-COMPANY -> PEM-COMPANY
PLA-EMPLOYEE -> PEM-EMPLOYEE
Region PCODES Required
When PLA-TYPE = "BR"
PLA-TYPE -> PCO-TYPE
PLA-CODE -> PCO-CODE
PAOFFLANG FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When PLA-POSITION != Spaces
PLA-COMPANY -> POS-COMPANY
PLA-POSITION -> POS-POSITION
POS-EFFECT-DATE
|
