HRJOBRCVR – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LJB
Primary key
COMPANY, JOB-CODE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE
Fields
73
Updated by
6 programs
Referenced by
1 program

HRJOBRCVR is a Lawson Human Resources table (prefix LJB); no description in the lawson data dictionary. It is indexed by COMPANY, JOB-CODE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE (LJBSET1); alternate indexes: LJBSET2, LJBSET3, LJBSET4, LJBSET5 and LJBSET6. It is updated by LT01.1, LT101, LT103, LT11.3, LT111 and LT13.3 and referenced by LT22.3. The table has 73 fields, 6 indexes and 0 documented relations.

About HRJOBRCVR

No description in the Lawson data dictionary.

Fields (73)

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

Field / columnTypeDescription & valuesUpdated by
LJB-COMPANY PK
COMPANY		Numeric 4—LT11.3, LT13.3
LJB-JOB-CODE PK
JOB_CODE		Alpha 9—LT101, LT11.3, LT111, LT13.3
LJB-LTM-DATE-STAMP PK
LTM_DATE_STAMP		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-LTM-TIME-STAMP PK
LTM_TIME_STAMP		Numeric 8—LT11.3, LT13.3
LJB-ACTION-CODE PK
ACTION_CODE		Alpha 10—LT11.3, LT13.3
LJB-ACTION-REASON
ACTION_REASON		Alpha 20—LT11.3, LT13.3
LJB-STATUS
STATUS		Numeric 1—LT01.1, LT101, LT103, LT11.3, LT111, LT13.3
LJB-ERROR-FLAG
ERROR_FLAG		Alpha 1—LT101, LT11.3, LT111, LT13.3
LJB-TRAN-TYPE
TRAN_TYPE		Alpha 1—LT11.3, LT13.3
LJB-MESSAGE
MESSAGE		Alpha 60—LT101, LT11.3, LT111, LT13.3
LJB-DESCRIPTION
DESCRIPTION		Alpha 60 (Lower Case)—LT11.3, LT13.3
LJB-RATE-OVERRIDE
RATE_OVERRIDE		Alpha 1—
  • N Cannot Pay Below Normal Rate
  • Y Allow Pay Below Normal Rate
LT11.3, LT13.3
LJB-BEG-SAL-RANGE
BEG_SAL_RANGE		Signed 13.4—LT11.3, LT13.3
LJB-MID-SAL-RANGE
MID_SAL_RANGE		Signed 13.4—LT11.3, LT13.3
LJB-END-SAL-RANGE
END_SAL_RANGE		Signed 13.4—LT11.3, LT13.3
LJB-POINTS
POINTS		Signed 7.2—LT11.3, LT13.3
LJB-EEO-CAT
EEO_CAT		Alpha 2—
  • 01 Official Administrator
  • 02 Professional
  • 03 Technician
  • 04 Protective Service
  • 05 Para-Professionals
  • 06 Office and Clerical
  • 07 Skilled Craft
  • 08 Service / Maintenance
  • 10 Officials and Managers
  • 11 Trainee
  • 20 Professionals
  • 21 Trainee
  • 30 Technicians
  • 31 Trainee
  • 40 Sales Workers
  • 41 Trainee
  • 50 Office and Clerical
  • 51 Trainee
  • 60 Craft Workers (Skilled)
  • 61 Trainee
  • 70 Operatives (Semi-skilled)
  • 72 Trainee
  • 80 Laborers (Unskilled)
  • 82 Trainee
  • 90 Service Workers
  • 92 Trainee
  • 99 Not Applicable
LT11.3, LT13.3
LJB-LAST-CMT-SEQ
LAST_CMT_SEQ		Numeric 4—LT11.3, LT13.3
LJB-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1—
  • A Active
  • I Inactive
LT101, LT11.3, LT111, LT13.3
LJB-ANNUAL-HOURS
ANNUAL_HOURS		Signed 8.4—LT11.3, LT13.3
LJB-JOB-CLASS
JOB_CLASS		Alpha 3—LT11.3, LT13.3
LJB-SCHEDULE
SCHEDULE		Alpha 9—LT11.3, LT13.3
LJB-PAY-GRADE
PAY_GRADE		Alpha 3—LT11.3, LT13.3
LJB-EEO-SUB-CODE
EEO_SUB_CODE		Numeric 3—LT11.3, LT13.3
LJB-EVAL-DATE
EVAL_DATE		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-EXEMPT
EXEMPT		Alpha 1—
  • N No
  • Y Yes
LT101, LT11.3, LT111, LT13.3
LJB-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-DESC-DATE
DESC_DATE		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-WC-CLASS
WC_CLASS		Alpha 4—LT11.3, LT13.3
LJB-CA-WC-CLASS
CA_WC_CLASS		Alpha 10—LT11.3, LT13.3
LJB-PAY-RATE
PAY_RATE		Signed 13.4—LT11.3, LT13.3
LJB-EXP-DIST-CO
EXP_DIST_CO		Numeric 4—LT11.3, LT13.3
LJB-EXP-ACCT-UNIT
EXP_ACCT_UNIT		Alpha 15—LT11.3, LT13.3
LJB-EXP-ACCOUNT
EXP_ACCOUNT		Numeric 6—LT11.3, LT13.3
LJB-EXP-SUB-ACCT
EXP_SUB_ACCT		Numeric 4—LT11.3, LT13.3
LJB-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5—LT11.3, LT13.3
LJB-DEPARTMENT
DEPARTMENT		Alpha 5—LT11.3, LT13.3
LJB-REPORTS-TO
REPORTS_TO		Numeric 9—LT11.3, LT13.3
LJB-APPROVED-BY
APPROVED_BY		Numeric 9—LT11.3, LT13.3
LJB-TIPPED
TIPPED		Alpha 1—
  • C Tipped job - Tax Credit
  • N Not a tipped job
  • T Tipped job - No Tax
LT11.3, LT13.3
LJB-OBJ-ID
OBJ_ID		Numeric 12—LT11.3, LT13.3
LJB-EEO-CAT-1
EEO_CAT_1		Derived——
LJB-MARKET-SALARY
MARKET_SALARY		Signed 13.4—LT11.3, LT13.3
LJB-MARKET-DATE
MARKET_DATE		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-CURRENCY-CODE
CURRENCY_CODE		Alpha 5—LT11.3, LT13.3
LJB-CURR-ND
CURR_ND		Numeric 1—LT11.3, LT13.3
LJB-BASE-PAY-RATE
BASE_PAY_RATE		Signed 13.4—LT11.3, LT13.3
LJB-BASE-CURRENCY
BASE_CURRENCY		Alpha 5—LT11.3, LT13.3
LJB-BASE-ND
BASE_ND		Numeric 1—LT11.3, LT13.3
LJB-BASE-BEG-SAL
BASE_BEG_SAL		Signed 13.4—LT11.3, LT13.3
LJB-BASE-MID-SAL
BASE_MID_SAL		Signed 13.4—LT11.3, LT13.3
LJB-BASE-END-SAL
BASE_END_SAL		Signed 13.4—LT11.3, LT13.3
LJB-BASE-MARKET
BASE_MARKET		Signed 13.4—LT11.3, LT13.3
LJB-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-SALARY-CLASS
SALARY_CLASS		Alpha 1—
  • H Hourly
  • S Salary
LT11.3, LT13.3
LJB-WEB-TYPE
WEB_TYPE		Alpha 3—
  • 1 Physician
  • 2 Nurse
LT11.3, LT13.3
LJB-GENDER-CLASS
GENDER_CLASS		Alpha 1" " = Not Applicable
  • 1 Female
  • 2 Male
  • 3 Gender Neutral
LT11.3, LT13.3
LJB-DIR-IND-JOB
DIR_IND_JOB		Numeric 1—
  • 1 Direct
  • 2 Indirect
LT11.3, LT13.3
LJB-OCCUP-GROUP
OCCUP_GROUP		Alpha 2—
  • 01 Senior Managers
  • 02 Middle and Other Managers
  • 03 Professionals
  • 04 Semi-Professionals/Technicians
  • 05 Supervisors
  • 06 Supervisors/Crafts and Trades
  • 07 Administrators/Senior Clerical
  • 08 Skilled Sales/Service
  • 09 Skilled Crafts/Trades
  • 10 Clerical
  • 11 Intermediate Sales/Service
  • 12 Semi-Skilled Manual
  • 13 Other Sales/Service
  • 14 Other Manual
  • 99 Not Applicable
LT11.3, LT13.3
LJB-TENURE-ELIG
TENURE_ELIG		Alpha 1" " = Not Applicable
  • N No
  • Y Yes
LT11.3, LT13.3
LJB-HIGH-ED-CAT
HIGH_ED_CAT		Numeric 2—
  • 01 Exec;Admin;Mgr
  • 02 Faculty
  • 03 Other Professionals
  • 04 Clerical;Secretarial
  • 05 Technical;Paraprofessional
  • 06 Skilled Craft Workers
  • 07 Service;Maintenance
LT11.3, LT13.3
LJB-HIGH-ED-SUBCAT
HIGH_ED_SUBCAT		Alpha 4—LT11.3, LT13.3
LJB-ACADEMIC-RANK
ACADEMIC_RANK		Alpha 1—
  • 1 Professor
  • 2 Associate Professor
  • 3 Assistant Professor
  • 4 Instructor
  • 5 Lecturer
  • 6 Other Instructional Staff
LT11.3, LT13.3
LJB-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—LT11.3, LT13.3
LJB-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—LT11.3, LT13.3
LJB-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—LT11.3, LT13.3
LJB-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—LT101, LT11.3, LT111, LT13.3
LJB-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—LT101, LT11.3, LT111, LT13.3
LJB-USER-ID
USER_ID		Alpha 10 (Lower Case)—LT101, LT11.3, LT111, LT13.3
LJB-LTM-OBJ-ID PK
LTM_OBJ_ID		Numeric 13—LT11.3, LT13.3
LJB-AUDIT-TRAN-ID
AUDIT_TRAN_ID		Alpha 40—LT11.3, LT13.3
LJB-FUTR-RESEND
FUTR_RESEND		Numeric 1—LT11.3, LT13.3
LJB-HAS-DELTA
HAS_DELTA		Numeric 1——

Indexes (6)

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

IndexKeysFlagsConditionUsed in
LJBSET1COMPANY, JOB-CODE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODEPrimaryLT101, LT103, LT11.3, LT111, LT13.3
LJBSET2COMPANY, JOB-CODE, STATUS, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ERROR-FLAG, ACTION-CODEKeyChangeLT01.1, LT101, LT103, LT111
LJBSET3COMPANY, STATUS, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ERROR-FLAG, JOB-CODE, ACTION-CODEKeyChangeLT101, LT111
LJBSET4COMPANY, ACTION-CODE, STATUS, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ERROR-FLAG, JOB-CODEKeyChange—
LJBSET5COMPANY, JOB-CODE, AUDIT-TRAN-ID, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODEKeyChange—
LJBSET6COMPANY, JOB-CODE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODESubsetWhere (HAS-DELTA = 1)LT22.3

Programs

Updated by (6)

Referenced by (1)