|
|
LPEMPLEAVE FILE
REFERENCED BY
LP09.1 LP251
UPDATED BY
LP51.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LEL-COMPANY Numeric 4 LP51.1
Element: Company Hr
LEL-EMPLOYEE Numeric 9 LP51.1
Element: Employee 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.
LEL-SEQ-NBR Numeric 4 LP51.1
Element: Seq Nbr An automatically assigned sequence
number.
LEL-BEGIN-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Begin Date
LEL-END-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta End Date
LEL-REQUEST-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-INTERMITTENT Numeric 1 LP51.1
Element: Ta Indicator 0 = No
1 = Yes
LEL-LEAVE-REASON Alpha 10 LP51.1
Element: Ta Loa Reason
LEL-REASON-CLASS Alpha 3 LP51.1
Element: Reason Class
LEL-EMP-NOTIFY-DT Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-EMP-RESP-DT Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-MGR-NOTIFY-DT Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-STATUS Alpha 10 LP51.1
Element: Ta Loa Status
LEL-SERVICE-DATE Numeric 2 LP51.1
Element: Ta Date Code 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
LEL-GOVT-QUALIFY Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-ELIGIBLE-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-STATE-QUALIFY Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-ST-ELIG-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-BN-QUALIFY Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-BN-PAID-THRU Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-PAY-STATUS Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = Paid
2 = Partially Paid
3 = Unpaid
LEL-PAY-THRU-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-DISABILITY Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-DISABLE-EFFECT Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-WORKERS-COMP Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-EXPECT-RETURN Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-RETURN-TO-WORK Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-RESTRICT-DUTY Numeric 1 LP51.1
Element: Ta Indicator 0 = No
1 = Yes
LEL-RESTRICT-THRU Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-PHYS-RELEASE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-CONTACT-ADDR Alpha 1 LP51.1
Element: Emp Address 1 = Home Address
2 = Supplemental Address
3 = Other
LEL-ADDR1 Alpha 30 (Lower Case) LP51.1
Element: Addr1 This field contains the first line of
address information.
LEL-ADDR2 Alpha 30 (Lower Case) LP51.1
Element: Addr2 This field contains the second line of
address information.
LEL-ADDR3 Alpha 30 (Lower Case) LP51.1
Element: Addr3 This field contains the third line of
address information.
LEL-CITY Alpha 18 (Lower Case) LP51.1
Element: City This field contains the city of the
address.
LEL-STATE-OR-PROV Alpha 2 LP51.1
Element: State This field contains the two-character
state code of the address.
LEL-POSTAL-CODE Alpha 10 LP51.1
Element: Zip This field contains the postal code of
the address.
LEL-COUNTRY-CODE Alpha 2 LP51.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
LEL-PHONE-CNTRY Alpha 6 LP51.1
Element: Hm Phone Cntry
LEL-PHONE-NBR Alpha 15 LP51.1
Element: Hm Phone Nbr
LEL-LOA-DATE-1 Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-LOA-DATE-2 Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-LOA-DATE-3 Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-LOA-DATE-4 Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-LOA-DATE-5 Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-CREATE-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
LEL-CREATE-TIME Numeric 6 (hhmmss) LP51.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
LEL-CREATE-USER-ID Alpha 10 (Lower Case) LP51.1
Element: User
LEL-DATE-STAMP Numeric 8 (yyyymmdd) LP51.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
LEL-TIME-STAMP Numeric 6 (hhmmss) LP51.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
LEL-USER-ID Alpha 10 (Lower Case) LP51.1
Element: User
LEL-EE-GOVT-QUAL Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-EE-STATE-QUAL Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-COMP-QUALIFY Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-EE-COMP-QUAL Numeric 1 LP51.1
Element: Ta Indicator 0 = Not Determined
1 = No
2 = Yes
LEL-COMP-ELIG-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-LEAVE-END-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-ST-LV-END-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LEL-CO-LV-END-DATE Numeric 8 (yyyymmdd) LP51.1
Element: Ta Date
LPEMPLEAVE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LELSET1 COMPANY HR11.1 LP09.1
EMPLOYEE LP251 LP51.1
SEQ-NBR PA115
LELSET2 COMPANY KeyChange LP251
EMPLOYEE
BEGIN-DATE
SEQ-NBR
LPEMPLEAVE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
