PAOFFLANG

UPDATED BY
HR00.1 HR01.1 HR11.1 LT101 PA02.1 PA115
PA296 PA302 PA496 PA502 PA96.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLA-COMPANY
Element: Company Hr		Numeric 4
PA96.1
PLA-EMPLOYEE
Element: Employee		Numeric 9
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.
PA96.1
PLA-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
PA96.1
PLA-REPORT-TYPE
Element: Report Type		Alpha 1

1 = Service to Public
2 = Internal Services
3 = Supervision
PA96.1
PLA-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
PA96.1
PLA-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
PA96.1
PLA-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date for this effort period.
PA96.1
PLA-TYPE
Element: Type		Alpha 2
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
PA96.1
PLA-CODE
Element: Code		Alpha 10
Code that is valid for the specified record type.
PA96.1
PLA-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PA96.1


PAOFFLANG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLASET1 COMPANY
EMPLOYEE
POSITION
REPORT-TYPE
SEQ-NBR
HR00.1 HR01.1
HR11.1 LT101
PA02.1 PA115
PA302 PA496
PA502 PA96.1
PLASET2 COMPANY
EMPLOYEE
POSITION
REPORT-TYPE
DATE*
SEQ-NBR
KeyChange
PA296 PA96.1


PAOFFLANG FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When PLA-POSITION !=Spaces
PLA-COMPANY->POS-COMPANY
PLA-POSITION->POS-POSITION
  POS-EFFECT-DATE

File created: Thu Jun 09 11:22:16 2016

Home
Contact Us



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