HRLTMDATA

UPDATED BY
HLTM.1 HR51.2 HR51.8 HR52.2 HR751

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LTD-COMPANY
Element: Company		Numeric 4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-EMPLOYEE
Element: Employee		Numeric 9
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-PROCESS-LEVEL
Element: Process Level		Alpha 5
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-DEPARTMENT
Element: Department		Alpha 5
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-PREFIX-TITLE
Element: Ded Code		Alpha 4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-MIDDLE-NAME
Element: Middle Name		Alpha 15 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-LAST-NAME
Element: Last Name		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-LAST-NAME-PRE
Element: Last Name Pre		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-NICK-NAME
Element: Nick Name		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SUFFIX
Element: Ded Code		Alpha 4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-DATE-HIRED
Element: Date Hired		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ADJ-HIRE-DATE
Element: Adj Hire Date		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-TERM-DATE
Element: Term Date		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-EMP-STATUS
Element: Emp Status		Alpha 2
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SEX
Element: Sex		Alpha 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-BIRTHDATE
Element: Birthdate		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-PERS-ACT-CODE
Element: Action Code		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-REASON-CODE
Element: Ltm Reason		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-REASON-CODE2
Element: Ltm Reason		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-CITY
Element: City Address		Alpha 58 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-STATE
Element: State		Alpha 2
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ZIP
Element: Zip		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-COUNTRY-CODE
Element: Country Code		Alpha 2
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ADDRESS-TYPE
Element: Flag Num		Numeric 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-POSITION
Element: Position		Alpha 12
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-JOB-CODE
Element: Job Code		Alpha 9
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-IMA-SUPERVISOR
Element: Supervisor		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SUPERVISOR-CD
Element: Supervisor		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SUPER-REPORTTO
Element: Supervisor		Alpha 10
LTD-NBR-FTE
Element: Nbr Fte		Signed 7.6
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-EMAIL-ADDRESS
Element: Email Address		Alpha 60 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WORK-EMAIL
Element: Email Address		Alpha 60 (Lower Case)
LTD-PAY-RATE
Element: Pay Rate		Signed 13.4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-CURR-CODE
Element: Currency Code		Alpha 5
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SALARY-CLASS
Element: Salary Class		Alpha 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-COUNTY
Element: County		Alpha 25 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-IND-SUPERVISOR
Element: Supervisor		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-HM-PHONE-CNTRY
Element: Phone Country		Alpha 6
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-HM-PHONE-NBR
Element: Phone		Alpha 15
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WK-PHONE-CNTRY
Element: Phone Country		Alpha 6
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WK-PHONE-NBR
Element: Phone		Alpha 15
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WK-PHONE-EXT
Element: Phone Ext		Alpha 5
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-REL-TO-ORG
Element: Alpha 20		Alpha 20
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-REL-STATUS
Element: Alpha 20		Alpha 20
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WORK-TYPE
Element: Alpha 20		Alpha 20
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ORG-UNIT
Element: Alpha Lower20		Alpha 20 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-JOB-REQ
Element: Jobrequisition		Numeric 9
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-JOB-APP
Element: Jobapplication		Numeric 4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-CANDIDATE
Element: Candidate Id		Numeric 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-LOCATION
Element: Sec Location		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-BARGAIN-UNIT
Element: Alpha 10		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-UNION-CODE
Element: Alpha 10		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-EXEMPT-EMP
Element: Flag		Alpha 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-APPLICANT-ID
Element: Applicant		Numeric 9
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-REMOTE
Element: Flag Num		Numeric 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ANNIVERSARY-DT
Element: Date		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SENIORITY-DT
Element: Date		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-EFFECT-DATE
Element: Date		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-RECORD-TYPE
Element: Alpha 10		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-RECORD-SOURCE
Element: Alpha 10		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-CREATE-USER
Element: User		Alpha 10 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-USER-ID
Element: User		Alpha 10 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SEQ-NBR
Element: Seq Nbr		Numeric 4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-ORIGIN-CODE
Element: Rcd Type		Numeric 2
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WFM-PROCESSED
Element: Value Type		Numeric 1

0 = Not Applicable
1 = Unprocessed
2 = Error
9 = Processed
HLTM.1 HR51.2
HR51.8 HR52.2
HR751
LTD-LTM-PROCESSED
Element: Value Type		Numeric 1

0 = Unprocessed
1 = Processed
2 = Error
8 = Not Applicable
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-USER-CHG-FLAG
Element: Flag		Alpha 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-USER-COMMENTS
Element: Comments		Alpha 50 (Lower Case)
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-HIRE-SOURCE
Element: Hire Source		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-PAY-PLAN
Element: Ot Plan Code		Alpha 4
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-WORK-SCHEDULE
Element: Work Sched		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SHIFT
Element: Shift		Numeric 1
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-SECURITY-NBR
Element: Security Nbr		Alpha 10
HLTM.1 HR51.2
HR51.8 HR52.2
LTD-LMS-PROCESSED
Element: Value Type		Numeric 1

0 = Unprocessed
9 = Processed
HR51.2 HR51.8
HR52.2


HRLTMDATA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LTDSET1 COMPANY
EMPLOYEE
EFFECT-DATE
CREATE-DATE
CREATE-TIME
SEQ-NBR
HLTM.1 HR51.2
HR51.8 HR52.2
LTDSET2 COMPANY
EMPLOYEE
RECORD-TYPE
CREATE-DATE
CREATE-TIME
SEQ-NBR
HLTM.1
LTDSET3 COMPANY
EMPLOYEE
RECORD-TYPE
CREATE-DATE
CREATE-TIME
SEQ-NBR
Subset
WhereLTM-PROCESSED =Zeroes
LTDSET4 COMPANY
RECORD-TYPE
EMPLOYEE
CREATE-DATE
CREATE-TIME
SEQ-NBR
Subset
Where(WFM-PROCESSED =1)
And(RECORD-TYPE ="WFM")
HR751
LTDSET5 COMPANY
RECORD-TYPE
EMPLOYEE
WFM-PROCESSED
LTM-PROCESSED
CREATE-DATE
CREATE-TIME
SEQ-NBR
KeyChange
HR751
LTDSET6 COMPANY
EMPLOYEE
CREATE-DATE
CREATE-TIME
SEQ-NBR
Subset
WhereLMS-PROCESSED =Zeroes

File created: Thu Jun 09 02:16:18 2016

Home
Contact Us



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