LPEMPLEAVE

REFERENCED BY
HR93.9 LP251


UPDATED BY
LP51.1 HR11.1 HR170 HR70.1 LP220 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LEL-COMPANY
Element: Company Hr
Numeric 4
LP51.1
LEL-EMPLOYEE
Element: Employee
Numeric 9
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.
LP51.1
LEL-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
LP51.1
LEL-BEGIN-DATE
Element: Ta Begin Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-END-DATE
Element: Ta End Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-REQUEST-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-INTERMITTENT
Element: Ta Indicator
Numeric 1

0 = No
1 = Yes
LP51.1
LEL-LEAVE-REASON
Element: Ta Loa Reason
Alpha 10
LP51.1
LEL-REASON-CLASS
Element: Reason Class
Alpha 3
LP51.1
LEL-EMP-NOTIFY-DT
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-EMP-RESP-DT
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-MGR-NOTIFY-DT
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-STATUS
Element: Ta Loa Status
Alpha 10
LP51.1
LEL-SERVICE-DATE
Element: Ta Date Code
Numeric 2

00 = Hire Date
01 = Adjusted Hire Date
02 = Anniversary Date
03 = Seniority Date
04 = First Day Worked
05 = Benefit Date 1
06 = Benefit Date 2
07 = Benefit Date 3
08 = Benefit Date 4
09 = Benefit Date 5
LP51.1
LEL-GOVT-QUALIFY
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-ELIGIBLE-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-STATE-QUALIFY
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-ST-ELIG-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-BN-QUALIFY
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-BN-PAID-THRU
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-PAY-STATUS
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = Paid
2 = Partially Paid
3 = Unpaid
LP51.1
LEL-PAY-THRU-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-DISABILITY
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-DISABLE-EFFECT
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-WORKERS-COMP
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-EXPECT-RETURN
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-RETURN-TO-WORK
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-RESTRICT-DUTY
Element: Ta Indicator
Numeric 1

0 = No
1 = Yes
LP51.1
LEL-RESTRICT-THRU
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-PHYS-RELEASE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-CONTACT-ADDR
Element: Emp Address
Alpha 1

1 = Home Address
2 = Supplemental Address
3 = Other
LP51.1
LEL-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
LP51.1
LEL-ADDR2
Element: Addr2
Alpha 30 (Lower Case)
This field contains the second line of address information.
LP51.1
LEL-ADDR3
Element: Addr3
Alpha 30 (Lower Case)
This field contains the third line of address information.
LP51.1
LEL-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
LP51.1
LEL-STATE-OR-PROV
Element: State
Alpha 2
This field contains the two-character state code of the address.
LP51.1
LEL-POSTAL-CODE
Element: Zip
Alpha 10
This field contains the postal code of the address.
LP51.1
LEL-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
LP51.1
LEL-PHONE-CNTRY
Element: Hm Phone Cntry
Alpha 6
LP51.1
LEL-PHONE-NBR
Element: Hm Phone Nbr
Alpha 15
LP51.1
LEL-LOA-DATE-1
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-LOA-DATE-2
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-LOA-DATE-3
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-LOA-DATE-4
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-LOA-DATE-5
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP51.1
LEL-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP51.1
LEL-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
LP51.1
LEL-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP51.1
LEL-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP51.1
LEL-USER-ID
Element: User
Alpha 10 (Lower Case)
LP51.1
LEL-EE-GOVT-QUAL
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-EE-STATE-QUAL
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-COMP-QUALIFY
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-EE-COMP-QUAL
Element: Ta Indicator
Numeric 1

0 = Not Determined
1 = No
2 = Yes
LP51.1
LEL-COMP-ELIG-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-LEAVE-END-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-ST-LV-END-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-CO-LV-END-DATE
Element: Ta Date
Numeric 8 (yyyymmdd)
LP51.1
LEL-HRH-OBJ-ID
Element: Obj Id
Numeric 12
LP51.1


LPEMPLEAVE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LELSET1 COMPANY
EMPLOYEE
SEQ-NBR
HR11.1 HR170
HR70.1 HR93.9
LP220 LP251
LP51.1 PA115
LELSET2 COMPANY
EMPLOYEE
BEGIN-DATE
SEQ-NBR
KeyChange
LP251


LPEMPLEAVE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
LEL-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country Code INSTCTRYCD Required
When LEL-COUNTRY-CODE !=Spaces
LEL-COUNTRY-CODE->INT-COUNTRY-CODE
Employee EMPLOYEE Required
LEL-COMPANY->EMP-COMPANY
LEL-EMPLOYEE->EMP-EMPLOYEE
Leave Reason PCODES Required
When LEL-LEAVE-REASON !=Spaces
"LR"->PCO-TYPE
LEL-LEAVE-REASON->PCO-CODE
Leave Status PCODES Required
When (LEL-STATUS !=Spaces )
"LS"->PCO-TYPE
LEL-STATUS->PCO-CODE
Paemployee PAEMPLOYEE Required
LEL-COMPANY->PEM-COMPANY
LEL-EMPLOYEE->PEM-EMPLOYEE
Reason Class TAREASCLSS Required
When (LEL-REASON-CLASS !=Spaces )
LEL-COMPANY->TRL-COMPANY
LEL-REASON-CLASS->TRL-REASON-CLASS


LPEMPLEAVE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Hrhistory HRHISTORY Delete Cascades
Valid When LEL-HRH-OBJ-ID !=Zeroes
LEL-COMPANY->HRH-COMPANY
LEL-EMPLOYEE->HRH-EMPLOYEE
LEL-HRH-OBJ-ID->HRH-OBJ-ID
  HRH-FLD-NBR
  HRH-POS-LEVEL
  HRH-BEG-DATE
  HRH-SEQ-NBR


File created: Wed Jun 08 20:49:59 2016

Home
Contact Us



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