|
|
PAENCUMBER FILE
REFERENCED BY
HR00.1 HR01.1 HR02.1 PA02.1 PA502 PA82.1
BN305 HR11.1 HR11.2 HR511 PA100 PA102
PA115 PA13.1 PA13.2 PA513 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
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 Hr
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
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
PEN-ATN-OBJ-ID Numeric 12 PA182
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
PEN-ENCUMBER-SAL Signed 13.2 PA182
Element: Wage Amount Contains the sum of all wage amounts
from the time records for pay codes tied
to this pay summary group.
PEN-ENCUMBER-FRNG Signed 13.2 PA182
Element: Wage Amount Contains the sum of all wage amounts
from the time records for pay codes tied
to this pay summary group.
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
JOB-CODE
EMPLOYEE
GLT-OBJ-ID
ATN-OBJ-ID
PENSET2 COMPANY BN305 HR11.1
EMPLOYEE HR11.2 HR511
POSITION PA02.1 PA100
PROCESS-LEVEL PA102 PA115
DEPARTMENT PA13.1 PA13.2
JOB-CODE PA502 PA513
GLT-OBJ-ID PA52.1 PA52.3
ATN-OBJ-ID PA52.4 PA52.5
PR110 PR113
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
|
