PAENCUMBER – No description in the Lawson data dictionary

System
Personnel (PA)
Prefix
PEN
Primary key
COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE, EMPLOYEE, GLT-OBJ-ID, ATN-OBJ-ID
Fields
14
Updated by
2 programs
Referenced by
35 programs

PAENCUMBER is a Lawson Personnel table (prefix PEN); no description in the lawson data dictionary. It is indexed by COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE, EMPLOYEE, GLT-OBJ-ID, ATN-OBJ-ID (PENSET1); alternate indexes: PENSET2, PENSET3 and PENSET4. It is related 1:1 to ACACTIVITY, ACCOMMITX, PRSYSTEM, DEPTCODE, EMPLOYEE, GLCOMMITX, JOBCODE and PAEMPLOYEE and 1:M to PAPOSITION. It is updated by PA182 and PA82.1 and referenced by BN305, HR00.1, HR01.1, HR02.1, HR11.1, HR11.2, HR11.4, HR28.1 and 27 more. The table has 14 fields, 4 indexes and 10 documented relations.

About PAENCUMBER

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the PEN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PEN-COMPANY PK
COMPANY		Numeric 4—PA182
#PEN-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.PA182
#PEN-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PA182
#PEN-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.PA182
#PEN-JOB-CODE PK
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.PA182
#PEN-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.PA182
#PEN-GLT-OBJ-ID PK
GLT_OBJ_ID		Numeric 12This 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.PA182
#PEN-ATN-OBJ-ID PK
ATN_OBJ_ID		Numeric 12This 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.PA182
#PEN-ENCUMBER-SAL
ENCUMBER_SAL		Signed 13.2Contains the sum of all wage amounts from the time records for pay codes tied to this pay summary group.PA182
#PEN-ENCUMBER-FRNG
ENCUMBER_FRNG		Signed 13.2Contains the sum of all wage amounts from the time records for pay codes tied to this pay summary group.PA182
#PEN-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.PA182
#PEN-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA182
#PEN-SHORT-NAME-CND
SHORT_NAME_CND		Derived——
#PEN-LABEL-NAME-1
LABEL_NAME_1		Derived——

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PENSET1
  1. COMPANY
  2. POSITION
  3. PROCESS-LEVEL
  4. DEPARTMENT
  5. JOB-CODE
  6. EMPLOYEE
  7. GLT-OBJ-ID
  8. ATN-OBJ-ID
PrimaryHR00.1, HR01.1, HR02.1, LT101, LT111, PA02.1, PA182, PA502 +1 more
PENSET2
  1. COMPANY
  2. EMPLOYEE
  3. POSITION
  4. PROCESS-LEVEL
  5. DEPARTMENT
  6. JOB-CODE
  7. GLT-OBJ-ID
  8. ATN-OBJ-ID
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
PENSET3
  1. GLT-OBJ-ID
SubsetWhere GLT-OBJ-ID != Zeroes—
PENSET4
  1. ATN-OBJ-ID
SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYACCOMMITXPRSYSTEMDEPTCODEEMPLOYEEGLCOMMITXJOBCODEPAEMPLOYEEPAPOSITIONPAENCUMBER

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ActivityACACTIVITYRequiredWhen PEN-ACTIVITY != Spaces
PEN-ACTIVITY→ACV-ACTIVITY
Atn Obj IdACCOMMITXRequiredWhen PEN-ATN-OBJ-ID != Zeroes
PEN-ATN-OBJ-ID→MIX-ATN-OBJ-ID
CompanyPRSYSTEMRequired
PEN-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen PEN-DEPARTMENT != Spaces
PEN-COMPANY→DPT-COMPANY
PEN-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PEN-DEPARTMENT→DPT-DEPARTMENT
EmployeeEMPLOYEERequired
PEN-COMPANY→EMP-COMPANY
PEN-EMPLOYEE→EMP-EMPLOYEE
Glt Obj IdGLCOMMITXRequiredWhen PEN-GLT-OBJ-ID != Zeroes
PEN-GLT-OBJ-ID→GOX-GLT-OBJ-ID
Job CodeJOBCODERequiredWhen PEN-JOB-CODE != Spaces
PEN-COMPANY→JBC-COMPANY
PEN-JOB-CODE→JBC-JOB-CODE
PaemployeePAEMPLOYEERequired
PEN-COMPANY→PEM-COMPANY
PEN-EMPLOYEE→PEM-EMPLOYEE
Process LevelPRSYSTEMRequiredWhen PEN-PROCESS-LEVEL != Spaces
PEN-COMPANY→PRS-COMPANY
PEN-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
PositionPAPOSITIONRequiredWhen PEN-POSITION != Spaces
PEN-COMPANY→POS-COMPANY
PEN-POSITION→POS-POSITION
—→POS-EFFECT-DATE

Programs

Updated by (2)

Referenced by (35)