HRUSFRCVR

REFERENCED BY
LT22.5 LT22.7


UPDATED BY
LT101 LT103 LT11.5 LT11.7 LT111 LT13.5
LT13.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LUF-COMPANY
Element: Company Hr		Numeric 4
LT11.5 LT11.7
LT13.5 LT13.7
LUF-EMPLOYEE
Element: Employee		Numeric 9
LT11.5 LT13.5
LUF-LTM-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
LT11.5 LT11.7
LT13.5 LT13.7
LUF-LTM-TIME-STAMP
Element: Time		Numeric 8
LT11.5 LT11.7
LT13.5 LT13.7
LUF-ACTION-CODE
Element: Action Code		Alpha 10
LT11.5 LT11.7
LT13.5 LT13.7
LUF-ACTION-REASON
Element: Action Reason		Alpha 20
LT11.5 LT11.7
LT13.5 LT13.7
LUF-STATUS
Element: Status		Numeric 1

0 = Unprocessed
1 = Error
9 = Processed
LT101 LT103
LT11.5 LT11.7
LT111 LT13.5
LT13.7
LUF-ERROR-FLAG
Element: Error Flag		Alpha 1

0 = No Error
1 = Error
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-TRAN-TYPE
Element: Alphadata1		Alpha 1
LT11.5 LT11.7
LT13.5 LT13.7
LUF-MESSAGE
Element: Err Message		Alpha 60
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-PCT-OBJ-ID
Element: Obj Id		Numeric 12
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-EMP-APP
Element: Emp App		Numeric 1

0 = Employee
1 = Applicant
LT11.5 LT13.5
LUF-FIELD-KEY
Element: Field Key		Alpha 2 Occurs 30 Times
LT11.5 LT11.7
LT13.5 LT13.7
LUF-A-FIELD
Element: A Field		Alpha 10 Occurs 30 Times
LT11.5 LT11.7
LT13.5 LT13.7
LUF-N-FIELD
Element: N Field		Signed 11.2 Occurs 30 Times
LT11.5 LT11.7
LT13.5 LT13.7
LUF-D-FIELD
Element: D Field		Numeric 8 (yyyymmdd) Occurs 30 Times
LT11.5 LT11.7
LT13.5 LT13.7
LUF-CURRENCY-CODE
Element: Currency Code		Alpha 5 Occurs 30 Times
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-DELTA-FLAG
Element: Manual Flag		Numeric 1 Occurs 30 Times
LT11.5
LUF-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
LT11.5 LT11.7
LT13.5 LT13.7
LUF-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
LT11.5 LT11.7
LT13.5 LT13.7
LUF-CREATE-TIME
Element: Time		Numeric 8
LT11.5 LT11.7
LT13.5 LT13.7
LUF-USER-ID
Element: User Id		Alpha 10 (Lower Case)
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
LT101 LT11.5
LT11.7 LT111
LT13.5 LT13.7
LUF-TYPE
Element: Table Type		Alpha 2

EM = Employee
PO = Position
JC = Job Code
AP = Applicant
LT11.5 LT11.7
LT13.5 LT13.7
LUF-POS-JOB
Element: Position		Alpha 12
LT11.5 LT11.7
LT13.5 LT13.7
LUF-EFFECT-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
LT11.7 LT13.7
LUF-LTM-OBJ-ID
Element: Ltm Obj Id		Numeric 13
LT11.5 LT11.7
LT13.5 LT13.7
LUF-HAS-DELTA
Element: Manual Flag		Numeric 1
LT11.5


HRUSFRCVR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LUFSET1 COMPANY
EMPLOYEE
TYPE
LTM-DATE-STAMP
LTM-TIME-STAMP
PCT-OBJ-ID
LTM-OBJ-ID
LT101 LT103
LT11.5 LT111
LT13.5 LT22.5
LUFSET2 COMPANY
EMPLOYEE
TYPE
STATUS
LTM-DATE-STAMP
LTM-TIME-STAMP
EMP-APP
POS-JOB
LTM-OBJ-ID
KeyChange
LT101 LT103
LT111
LUFSET3 COMPANY
TYPE
POS-JOB
LTM-DATE-STAMP
LTM-TIME-STAMP
EFFECT-DATE
STATUS
LTM-OBJ-ID
KeyChange
LT101 LT11.7
LT111 LT13.7
LT22.7
LUFSET4 COMPANY
EMPLOYEE
TYPE
LTM-DATE-STAMP
LTM-TIME-STAMP
PCT-OBJ-ID
LTM-OBJ-ID
Subset
Where(HAS-DELTA =1)


HRUSFRCVR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Not Required
LUF-COMPANY->EMP-COMPANY (EMPSET1)
LUF-EMPLOYEE->EMP-EMPLOYEE
Job Code JOBCODE Not Required
Valid When LUF-TYPE ="JC"
LUF-COMPANY->JBC-COMPANY
LUF-POS-JOB->JBC-JOB-CODE
Position PAPOSITION Not Required
Valid When LUF-TYPE ="PO"
LUF-COMPANY->POS-COMPANY
LUF-POS-JOB->POS-POSITION
LUF-EFFECT-DATE->POS-EFFECT-DATE

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

Home
Contact Us



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