LPPENDREQ

LPPENDREQ will hold the Proposed Leave Request for Paid Time Off that will be extracted for creating a time record and will decrement Employee Absence Plan balances.
UPDATED BY
BN150 BN66.1 HS19.2 PR521 EXI2.1 EXI4.1
LP130 LP197 PR128 PR131 PR132 PR134
PR135 PR136 PR137 PR140 PR189 PR195
PR197 PR29.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR36.4 PR37.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 PR85.1 PR89.1 PRAT.1 UK102
TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LPQ-COMPANY
Element: Company Hr		Numeric 4
HR Company
HS19.2
LPQ-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
HS19.2
LPQ-SEQ-NUMBER
Element: Seq Number		Numeric 6
HS19.2
LPQ-SERVICE-CODE
Element: Ta Service Cd		Alpha 10
Usage Service Code from Leave Request Rules. Will be used to decrement balances and to payout hours from the hours balance.
HS19.2
LPQ-HOURS
Element: Ta Hours		Signed 9.4
Hours that has been requested by the employee for the Paid Time Off from the ESS Time Off Request Task.
HS19.2
LPQ-LEAVE-DATE
Element: Ta Date		Numeric 8 (yyyymmdd)
Date of the leave request.
HS19.2
LPQ-STATUS
Element: Ta Status		Numeric 1
Contains 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
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
PRAT.1 TA147
UK102
LPQ-ABN-OBJ-ID
Element: Abn Obj Id		Numeric 12
This 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
Element: Req Obj Id		Numeric 12
This 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
Element: 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
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the time (Hour, Minute, and Second) of the last change to this record.
HS19.2
LPQ-PROXY-ID
Element: Proxy Id		Alpha 10 (Lower Case)
Contains the user id of the proxy to approve the PTO request.
HS19.2
LPQ-EMP-USER-ID
Element: 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
Element: 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
Element: Date Stamp		Numeric 8 (yyyymmdd)
Contains the server date (month, date, and year) the record was created.
HS19.2
LPQ-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the time (Hour, Minute, and Second) of when the record was created.
HS19.2
LPQ-CREATE-USER-ID
Element: 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
Element: Ta Plan		Alpha 10
HS19.2
LPQ-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
HS19.2
LPQ-POSITION
Element: Position		Alpha 12
HS19.2
LPQ-MEMO
Element: Text Comment		Alpha 64 (Lower Case)
HS19.2


LPPENDREQ FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LPQSET1 COMPANY
EMPLOYEE
SEQ-NUMBER
HS19.2
LPQSET2 COMPANY
EMPLOYEE
SEQ-NUMBER*
HS19.2
LPQSET3 COMPANY
EMPLOYEE
SEQ-NUMBER
Subset
Where(STATUS =1
OrSTATUS =2
OrSTATUS =5
OrSTATUS =6)
LPQSET4 COMPANY
EMPLOYEE
LEAVE-DATE
SEQ-NUMBER
LPQSET5 COMPANY
ABN-OBJ-ID
EMPLOYEE
SEQ-NUMBER
Subset
WhereABN-OBJ-ID !=Zeroes
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
LP197 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR140 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
LPQSET7 COMPANY
EMPLOYEE
SEQ-NUMBER
Subset
WhereSTATUS =1
OrSTATUS =2
LPQSET8 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
SEQ-NUMBER
HS19.1 HS19.2


LPPENDREQ FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
LPQ-COMPANY->EMP-COMPANY
LPQ-EMPLOYEE->EMP-EMPLOYEE
Prsystem PRSYSTEM Required
LPQ-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Service Code TASERVCODE Required
LPQ-COMPANY->TSC-COMPANY
LPQ-SERVICE-CODE->TSC-SERVICE-CODE
Taeemaster TAEEMASTER Required
LPQ-COMPANY->TEM-COMPANY
LPQ-EMPLOYEE->TEM-EMPLOYEE
LPQ-PLAN->TEM-PLAN
LPQ-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
LPQ-POSITION->TEM-POSITION
Taplan TAPLAN Required
LPQ-COMPANY->TAP-COMPANY
LPQ-PLAN->TAP-PLAN


LPPENDREQ FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Prpendtime PRPENDTIME
Valid When LPQ-ABN-OBJ-ID !=Zeroes
LPQ-COMPANY->PPT-COMPANY
LPQ-EMPLOYEE->PPT-EMPLOYEE
  PPT-TIME-SEQ
Taempserv TAEMPSERV
Valid When LPQ-ABN-OBJ-ID !=Zeroes
LPQ-COMPANY->TES-COMPANY
LPQ-EMPLOYEE->TES-EMPLOYEE
  TES-TES-OBJ-ID

File created: Thu Jun 09 02:22:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.