LPPENDREQ – No description in the Lawson data dictionary

System
Absence Management (LP)
Prefix
LPQ
Primary key
COMPANY, EMPLOYEE, SEQ-NUMBER
Fields
21
Updated by
49 programs
Referenced by
0 programs

LPPENDREQ is a Lawson Absence Management table (prefix LPQ); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, SEQ-NUMBER (LPQSET1); alternate indexes: LPQSET2, LPQSET3, LPQSET4, LPQSET5, LPQSET7 and LPQSET8. It is related 1:1 to EMPLOYEE, PRSYSTEM, TASERVCODE, TAEEMASTER and TAPLAN and 1:M to PRPENDTIME and TAEMPSERV. It is updated by BN150, BN66.1, EXI2.1, EXI4.1, HS19.2, LP130, LP197, PR128 and 41 more. The table has 21 fields, 7 indexes and 7 documented relations.

About LPPENDREQ

No description in the Lawson data dictionary.

Fields (21)

Column = COBOL field name without the LPQ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
LPQ-COMPANY PK
COMPANY		Numeric 4HR CompanyHS19.2
LPQ-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.HS19.2
LPQ-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6—HS19.2
LPQ-SERVICE-CODE
SERVICE_CODE		Alpha 10Usage Service Code from Leave Request Rules. Will be used to decrement balances and to payout hours from the hours balance.HS19.2
LPQ-HOURS
HOURS		Signed 9.4Hours that has been requested by the employee for the Paid Time Off from the ESS Time Off Request Task.HS19.2
LPQ-LEAVE-DATE
LEAVE_DATE		Numeric 8 (yyyymmdd)Date of the leave request.HS19.2
LPQ-STATUS
STATUS		Numeric 1Contains the Status: 1=Submitted;
  • 2 Approved; 3=Cancelled; 4=Rejected;
  • 5 Time Record; 6=Payroll Cycle Closed;
  • 7 Absence Cycle Closed
  • 1 Submitted
  • 2 Approved
  • 3 Cancelled
  • 4 Rejected
  • 5 Time Record Created
  • 6 Payroll Cycle Closed
  • 7 Absence Cycle Closed
BN150, BN66.1, EXI2.1, EXI4.1, HS19.2, LP130, LP197, PR128 +41 more
LPQ-ABN-OBJ-ID
ABN_OBJ_ID		Numeric 12This is an object identifier. It is used to relate the originating Leave Request to a pending time record in PRPENDTIME.HS19.2
LPQ-REQ-OBJ-ID
REQ_OBJ_ID		Numeric 12This is an object identifier. It is used to relate the originating Leave Request to the pending service records in TAEMPSERV.HS19.2
LPQ-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)Contains the Server date (month, date, and year) of the last change to this record.HS19.2
LPQ-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the time (Hour, Minute, and Second) of the last change to this record.HS19.2
LPQ-PROXY-ID
PROXY_ID		Alpha 10 (Lower Case)Contains the user id of the proxy to approve the PTO request.HS19.2
LPQ-EMP-USER-ID
EMP_USER_ID		Alpha 10 (Lower Case)Contains the USER ID of the employee who updated the record by performing a Submit or Cancel action.HS19.2
LPQ-MGR-USER-ID
MGR_USER_ID		Alpha 10 (Lower Case)Contains USER ID of the manager who updated the record by performing an Approval or Rejection action.HS19.2
LPQ-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)Contains the server date (month, date, and year) the record was created.HS19.2
LPQ-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)Contains the time (Hour, Minute, and Second) of when the record was created.HS19.2
LPQ-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)Contains the USER ID of the person who created the record. This would be the employee User Id only.HS19.2
LPQ-PLAN
PLAN		Alpha 10—HS19.2
LPQ-EMPLOYEE-GROUP
EMPLOYEE_GROUP		Alpha 10—HS19.2
LPQ-POSITION
POSITION		Alpha 12—HS19.2
LPQ-MEMO
MEMO		Alpha 64 (Lower Case)—HS19.2

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LPQSET1COMPANY, EMPLOYEE, SEQ-NUMBERPrimaryHS19.2
LPQSET2COMPANY, EMPLOYEE, SEQ-NUMBER*HS19.2
LPQSET3COMPANY, EMPLOYEE, SEQ-NUMBERSubsetWhere (STATUS = 1 Or STATUS = 2 Or STATUS = 5 Or STATUS = 6)—
LPQSET4COMPANY, EMPLOYEE, LEAVE-DATE, SEQ-NUMBER—
LPQSET5COMPANY, ABN-OBJ-ID, EMPLOYEE, SEQ-NUMBERSubsetWhere ABN-OBJ-ID != ZeroesBN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, LP197, PR128 +22 more (list truncated in source)
LPQSET7COMPANY, EMPLOYEE, SEQ-NUMBERSubsetWhere STATUS = 1 Or STATUS = 2—
LPQSET8COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, SEQ-NUMBERHS19.1, HS19.2

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequiredLPQ-COMPANY → EMP-COMPANY, LPQ-EMPLOYEE → EMP-EMPLOYEE
PrsystemPRSYSTEMRequiredLPQ-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Service CodeTASERVCODERequiredLPQ-COMPANY → TSC-COMPANY, LPQ-SERVICE-CODE → TSC-SERVICE-CODE
TaeemasterTAEEMASTERRequiredLPQ-COMPANY → TEM-COMPANY, LPQ-EMPLOYEE → TEM-EMPLOYEE, LPQ-PLAN → TEM-PLAN, LPQ-EMPLOYEE-GROUP → TEM-EMPLOYEE-GROUP, LPQ-POSITION → TEM-POSITION
TaplanTAPLANRequiredLPQ-COMPANY → TAP-COMPANY, LPQ-PLAN → TAP-PLAN

One to many (2) — child tables

RelationTableRulesConditionField map
PrpendtimePRPENDTIMEValid When LPQ-ABN-OBJ-ID != ZeroesLPQ-COMPANY → PPT-COMPANY, LPQ-EMPLOYEE → PPT-EMPLOYEE, → PPT-TIME-SEQ
TaempservTAEMPSERVValid When LPQ-ABN-OBJ-ID != ZeroesLPQ-COMPANY → TES-COMPANY, LPQ-EMPLOYEE → TES-EMPLOYEE, → TES-TES-OBJ-ID

Programs

Updated by (49)