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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 SET2 SET3
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 SET2
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 SET2 SET3
POS_JOB		Alpha 12—LT11.5, LT11.7, LT13.5, LT13.7
#LUF-EFFECT-DATE SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LUFSET1
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. PCT-OBJ-ID
  7. LTM-OBJ-ID
PrimaryLT101, LT103, LT11.5, LT111, LT13.5, LT22.5
LUFSET2
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. STATUS
  5. LTM-DATE-STAMP
  6. LTM-TIME-STAMP
  7. EMP-APP
  8. POS-JOB
  9. LTM-OBJ-ID
KeyChangeLT101, LT103, LT111
LUFSET3
  1. COMPANY
  2. TYPE
  3. POS-JOB
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. EFFECT-DATE
  7. STATUS
  8. LTM-OBJ-ID
KeyChangeLT101, LT11.7, LT111, LT13.7, LT22.7
LUFSET4
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. PCT-OBJ-ID
  7. LTM-OBJ-ID
SubsetWhere (HAS-DELTA = 1)—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMPLOYEEJOBCODEPAPOSITIONHRUSFRCVR

One to one (3) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEENot Required
LUF-COMPANY→EMP-COMPANY (EMPSET1)
LUF-EMPLOYEE→EMP-EMPLOYEE
Job CodeJOBCODENot RequiredValid When LUF-TYPE = "JC"
LUF-COMPANY→JBC-COMPANY
LUF-POS-JOB→JBC-JOB-CODE
PositionPAPOSITIONNot RequiredValid When LUF-TYPE = "PO"
LUF-COMPANY→POS-COMPANY
LUF-POS-JOB→POS-POSITION
LUF-EFFECT-DATE→POS-EFFECT-DATE

Programs

Updated by (7)

Referenced by (2)