|
PAENCUMBER FILE
REFERENCED BY
HR00.1 HR01.1 HR02.1 PA02.1 PA502 PA82.1
PBIP.1 PR197 HR11.1 HR11.2 HR511 PA100
PA102 PA115 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8
UPDATED BY
PA182
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEN-COMPANY Numeric 4 PA182
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PEN-POSITION Alpha 12 PA182
Element: Position Contains the user-defined code that
represents a position in the company.
PEN-PROCESS-LEVEL Alpha 5 PA182
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PEN-DEPARTMENT Alpha 5 PA182
Element: Department Contains the department.
PEN-JOB-CODE Alpha 9 PA182
Element: Job Code Contains a user-defined code that
represents a type of job.
PEN-EMPLOYEE Numeric 9 PA182
Element: 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.
PEN-GLT-OBJ-ID Numeric 12 PA182
Object This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
PEN-ATN-OBJ-ID Numeric 12 PA182
Object The system-defined object id
Identification representing the Activity Management
commitment.
PEN-ENCUMBER-SAL Signed 13.2 PA182
Element: Wage Amount
PEN-ENCUMBER-FRNG Signed 13.2 PA182
Element: Wage Amount
PEN-ACTIVITY Alpha 15 PA182
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PEN-DATE-STAMP Numeric 8 (yyyymmdd) PA182
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PEN-SHORT-NAME-CND Derived
Element: Short Name Cnd
PEN-LABEL-NAME-1 Derived
Element: Label Name 1
PAENCUMBER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PENSET1 COMPANY HR00.1 HR01.1
POSITION HR02.1 PA02.1
PROCESS-LEVEL PA182 PA502
DEPARTMENT PA82.1 PBIP.1
JOB-CODE PR197
EMPLOYEE
GLT-OBJ-ID
ATN-OBJ-ID
PENSET2 COMPANY HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
POSITION PA100 PA102
PROCESS-LEVEL PA115 PA502
DEPARTMENT PA52.1 PA52.3
JOB-CODE PA52.4 PA52.5
GLT-OBJ-ID PR110 PR113
ATN-OBJ-ID PR120 PR13.1
PR13.5 PR13.6
PR13.8
PENSET3 GLT-OBJ-ID Subset
Where GLT-OBJ-ID != Zeroes
PENSET4 ATN-OBJ-ID Subset
Where ATN-OBJ-ID != Zeroes
PAENCUMBER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Activity ACACTIVITY Required
When PEN-ACTIVITY != Spaces
PEN-ACTIVITY -> ACV-ACTIVITY
Atn Obj Id ACCOMMITX Required
When PEN-ATN-OBJ-ID != Zeroes
PEN-ATN-OBJ-ID -> MIX-ATN-OBJ-ID
Company PRSYSTEM Required
PEN-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When PEN-DEPARTMENT != Spaces
PEN-COMPANY -> DPT-COMPANY
PEN-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PEN-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
PEN-COMPANY -> EMP-COMPANY
PEN-EMPLOYEE -> EMP-EMPLOYEE
Glt Obj Id GLCOMMITX Required
When PEN-GLT-OBJ-ID != Zeroes
PEN-GLT-OBJ-ID -> GOX-GLT-OBJ-ID
Job Code JOBCODE Required
When PEN-JOB-CODE != Spaces
PEN-COMPANY -> JBC-COMPANY
PEN-JOB-CODE -> JBC-JOB-CODE
Paemployee PAEMPLOYEE Required
PEN-COMPANY -> PEM-COMPANY
PEN-EMPLOYEE -> PEM-EMPLOYEE
Process Level PRSYSTEM Required
When PEN-PROCESS-LEVEL != Spaces
PEN-COMPANY -> PRS-COMPANY
PEN-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
PAENCUMBER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION Required
When PEN-POSITION != Spaces
PEN-COMPANY -> POS-COMPANY
PEN-POSITION -> POS-POSITION
POS-EFFECT-DATE
|