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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET4
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 SET5
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 SET8
PLAN		Alpha 10—HS19.2
#LPQ-EMPLOYEE-GROUP SET8
EMPLOYEE_GROUP		Alpha 10—HS19.2
#LPQ-POSITION SET8
POSITION		Alpha 12—HS19.2
#LPQ-MEMO
MEMO		Alpha 64 (Lower Case)—HS19.2

Indexes (7)

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
LPQSET1
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NUMBER
PrimaryHS19.2
LPQSET2
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NUMBER ↓
HS19.2
LPQSET3
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NUMBER
SubsetWhere (STATUS = 1 Or STATUS = 2 Or STATUS = 5 Or STATUS = 6)—
LPQSET4
  1. COMPANY
  2. EMPLOYEE
  3. LEAVE-DATE
  4. SEQ-NUMBER
—
LPQSET5
  1. COMPANY
  2. ABN-OBJ-ID
  3. EMPLOYEE
  4. SEQ-NUMBER
SubsetWhere ABN-OBJ-ID != ZeroesBN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, LP197, PR128 +22 more (list truncated in source)
LPQSET7
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NUMBER
SubsetWhere STATUS = 1 Or STATUS = 2—
LPQSET8
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. SEQ-NUMBER
HS19.1, HS19.2

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
LPQ-COMPANY→EMP-COMPANY
LPQ-EMPLOYEE→EMP-EMPLOYEE
PrsystemPRSYSTEMRequired
LPQ-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Service CodeTASERVCODERequired
LPQ-COMPANY→TSC-COMPANY
LPQ-SERVICE-CODE→TSC-SERVICE-CODE
TaeemasterTAEEMASTERRequired
LPQ-COMPANY→TEM-COMPANY
LPQ-EMPLOYEE→TEM-EMPLOYEE
LPQ-PLAN→TEM-PLAN
LPQ-EMPLOYEE-GROUP→TEM-EMPLOYEE-GROUP
LPQ-POSITION→TEM-POSITION
TaplanTAPLANRequired
LPQ-COMPANY→TAP-COMPANY
LPQ-PLAN→TAP-PLAN

One to many (2) — child tables

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

Programs

Updated by (49)