PACANEEA FILE
REFERENCED BY
PA294
UPDATED BY
PA94.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCE-COMPANY Numeric 4 PA94.1
Company The company number represents an
established company and is entered on
all function codes.
PCE-SIC Numeric 3 PA94.1
Sic Contains the Canadian Standard Industry
Code by the Canadian Government.
PCE-PROCESS-LEVEL Alpha 5 PA94.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PCE-DEPARTMENT Alpha 5 PA94.1
Department Contains the department.
PCE-LOCAT-CODE Alpha 10 PA94.1
Location Contains the location.
PACANEEA FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCESET1 COMPANY PA294 PA94.1
SIC
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PCESET2 COMPANY PA94.1
PROCESS-LEVEL
DEPARTMENT
LOCAT-CODE
PCESET3 COMPANY
LOCAT-CODE
PROCESS-LEVEL
DEPARTMENT
PACANEEA FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PCE-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When PCE-DEPARTMENT != Spaces
And PCE-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
Process Level PRSYSTEM Required
When PCE-PROCESS-LEVEL != Spaces
PCE-COMPANY -> PRS-COMPANY
PCE-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
|
