PACANEEA

REFERENCED BY
PA594


UPDATED BY
PA94.1 PA294

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCE-COMPANY
Element: Company Hr		Numeric 4
PA94.1
PCE-SIC
Element: Sic		Numeric 6
Contains the Canadian Standard Industry Code by the Canadian Government.
PA94.1
PCE-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PA94.1
PCE-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
PA94.1
PCE-LOCAT-CODE
Element: Locat Code		Alpha 10
Contains the location.
PA94.1


PACANEEA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCESET1 COMPANY
SIC
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PA294 PA94.1
PCESET2 COMPANY
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PA594 PA94.1
PCESET3 COMPANY
LOCAT-CODE
PROCESS-LEVEL
DEPARTMENT


PACANEEA FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PCE-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Department DEPTCODE Required
When PCE-DEPARTMENT !=Spaces
AndPCE-DEPARTMENT !="*ALL"
PCE-COMPANY->DPT-COMPANY
PCE-PROCESS-LEVEL->DPT-PROCESS-LEVEL
PCE-DEPARTMENT->DPT-DEPARTMENT
Location PCODES Required
When PCE-LOCAT-CODE !=Spaces
"LO"->PCO-TYPE
PCE-LOCAT-CODE->PCO-CODE
Pacanhdr PACANHDR Required
PCE-COMPANY->PHD-COMPANY
PCE-SIC->PHD-SIC
Process Level PRSYSTEM Required
When PCE-PROCESS-LEVEL !=Spaces
PCE-COMPANY->PRS-COMPANY
PCE-PROCESS-LEVEL->PRS-PROCESS-LEVEL

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

Home
Contact Us



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