HRUSFRCVR – No description in the Lawson data dictionary

System: Human Resources (HR)
Prefix: LUF
Primary key: COMPANY, EMPLOYEE, TYPE, LTM-DATE-STAMP, LTM-TIME-STAMP, PCT-OBJ-ID, LTM-OBJ-ID
Fields: 29
Updated by: 7 programs
Referenced by: 2 programs

HRUSFRCVR is a Lawson Human Resources table (prefix LUF); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, TYPE, LTM-DATE-STAMP, LTM-TIME-STAMP, PCT-OBJ-ID, LTM-OBJ-ID (LUFSET1); alternate indexes: LUFSET2, LUFSET3 and LUFSET4. It is related 1:1 to EMPLOYEE, JOBCODE and PAPOSITION. It is updated by LT101, LT103, LT11.5, LT11.7, LT111, LT13.5 and LT13.7 and referenced by LT22.5 and LT22.7. The table has 29 fields, 4 indexes and 3 documented relations.

About HRUSFRCVR

No description in the Lawson data dictionary.

Fields (29)

Column = COBOL field name without the LUF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`LUF-COMPANY` PK COMPANY	Numeric 4	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	LT11.5, LT13.5
`LUF-LTM-DATE-STAMP` PK LTM_DATE_STAMP	Numeric 8 (yyyymmdd)	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-LTM-TIME-STAMP` PK LTM_TIME_STAMP	Numeric 8	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-ACTION-CODE` ACTION_CODE	Alpha 10	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-ACTION-REASON` ACTION_REASON	Alpha 20	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-STATUS` STATUS	Numeric 1	— `0` Unprocessed `1` Error `9` Processed	LT101, LT103, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-ERROR-FLAG` ERROR_FLAG	Alpha 1	— `0` No Error `1` Error	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-TRAN-TYPE` TRAN_TYPE	Alpha 1	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-MESSAGE` MESSAGE	Alpha 60	—	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-PCT-OBJ-ID` PK PCT_OBJ_ID	Numeric 12	—	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-EMP-APP` EMP_APP	Numeric 1	— `0` Employee `1` Applicant	LT11.5, LT13.5
`LUF-FIELD-KEY` FIELD_KEY	Alpha 2 Occurs 30 Times ×30	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-A-FIELD` A_FIELD	Alpha 10 Occurs 30 Times ×30	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-N-FIELD` N_FIELD	Signed 11.2 Occurs 30 Times ×30	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-D-FIELD` D_FIELD	Numeric 8 (yyyymmdd) Occurs 30 Times ×30	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-CURRENCY-CODE` CURRENCY_CODE	Alpha 5 Occurs 30 Times ×30	—	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-DELTA-FLAG` DELTA_FLAG	Numeric 1 Occurs 30 Times ×30	—	LT11.5
`LUF-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-CREATE-TIME` CREATE_TIME	Numeric 8	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	LT101, LT11.5, LT11.7, LT111, LT13.5, LT13.7
`LUF-TYPE` PK TYPE	Alpha 2	— `EM` Employee `PO` Position `JC` Job Code `AP` Applicant	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-POS-JOB` POS_JOB	Alpha 12	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	—	LT11.7, LT13.7
`LUF-LTM-OBJ-ID` PK LTM_OBJ_ID	Numeric 13	—	LT11.5, LT11.7, LT13.5, LT13.7
`LUF-HAS-DELTA` HAS_DELTA	Numeric 1	—	LT11.5

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`LUFSET1`	`COMPANY`, `EMPLOYEE`, `TYPE`, `LTM-DATE-STAMP`, `LTM-TIME-STAMP`, `PCT-OBJ-ID`, `LTM-OBJ-ID`	Primary		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)	—

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (7)

LT101 HRM Receiver Update
LT103 HRM RCVR History Change,Delete
LT11.5 HRM User Field Interface
LT11.7 HRM Position User Field Interface
LT111 HRM Receiver Update
LT13.5 HRM User Field Interface History
LT13.7 HRM Pos UserFld Interface History

Referenced by (2)

LT22.5 HRM Employee User Field Interface
LT22.7 HRM Position User Field Interface