REFERENCED BY
HR93.9 | LP251 |
LP51.1 | HR11.1 | HR170 | HR70.1 | LP220 | PA115 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
LEL-COMPANY Element: Company Hr | Numeric 4 |
|
||
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. |
|
||
LEL-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
LEL-BEGIN-DATE Element: Ta Begin Date | Numeric 8 (yyyymmdd) |
|
||
LEL-END-DATE Element: Ta End Date | Numeric 8 (yyyymmdd) |
|
||
LEL-REQUEST-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-INTERMITTENT Element: Ta Indicator | Numeric 1 0 = No 1 = Yes |
|
||
LEL-LEAVE-REASON Element: Ta Loa Reason | Alpha 10 |
|
||
LEL-REASON-CLASS Element: Reason Class | Alpha 3 |
|
||
LEL-EMP-NOTIFY-DT Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-EMP-RESP-DT Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-MGR-NOTIFY-DT Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-STATUS Element: Ta Loa Status | Alpha 10 |
|
||
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 |
|
||
LEL-GOVT-QUALIFY Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-ELIGIBLE-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-STATE-QUALIFY Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-ST-ELIG-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-BN-QUALIFY Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-BN-PAID-THRU Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-PAY-STATUS Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = Paid 2 = Partially Paid 3 = Unpaid |
|
||
LEL-PAY-THRU-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-DISABILITY Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-DISABLE-EFFECT Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-WORKERS-COMP Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-EXPECT-RETURN Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-RETURN-TO-WORK Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-RESTRICT-DUTY Element: Ta Indicator | Numeric 1 0 = No 1 = Yes |
|
||
LEL-RESTRICT-THRU Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-PHYS-RELEASE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-CONTACT-ADDR Element: Emp Address | Alpha 1 1 = Home Address 2 = Supplemental Address 3 = Other |
|
||
LEL-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||
LEL-ADDR2 Element: Addr2 | Alpha 30 (Lower Case) This field contains the second line of address information. |
|
||
LEL-ADDR3 Element: Addr3 | Alpha 30 (Lower Case) This field contains the third line of address information. |
|
||
LEL-CITY Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||
LEL-STATE-OR-PROV Element: State | Alpha 2 This field contains the two-character state code of the address. |
|
||
LEL-POSTAL-CODE Element: Zip | Alpha 10 This field contains the postal code of the address. |
|
||
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). |
|
||
LEL-PHONE-CNTRY Element: Hm Phone Cntry | Alpha 6 |
|
||
LEL-PHONE-NBR Element: Hm Phone Nbr | Alpha 15 |
|
||
LEL-LOA-DATE-1 Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-LOA-DATE-2 Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-LOA-DATE-3 Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-LOA-DATE-4 Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-LOA-DATE-5 Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
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. |
|
||
LEL-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
LEL-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||
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. |
|
||
LEL-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
LEL-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||
LEL-EE-GOVT-QUAL Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-EE-STATE-QUAL Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-COMP-QUALIFY Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-EE-COMP-QUAL Element: Ta Indicator | Numeric 1 0 = Not Determined 1 = No 2 = Yes |
|
||
LEL-COMP-ELIG-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-LEAVE-END-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-ST-LV-END-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-CO-LV-END-DATE Element: Ta Date | Numeric 8 (yyyymmdd) |
|
||
LEL-HRH-OBJ-ID Element: Obj Id | Numeric 12 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LELSET1 |
COMPANY EMPLOYEE SEQ-NBR |
|
| ||||||||||||||
LELSET2 |
COMPANY EMPLOYEE BEGIN-DATE SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Country Code | INSTCTRYCD |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Leave Reason | PCODES |
Required
| ||||||||||||
Leave Status | PCODES |
Required
| ||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||
Reason Class | TAREASCLSS |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Hrhistory | HRHISTORY |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.