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

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 SET2 SET3 SET4
STATUS		Numeric 1—LT01.1, LT101, LT103, LT11.3, LT111, LT13.3
#LJB-ERROR-FLAG SET2 SET3 SET4
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 SET5
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 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
LJBSET1
  1. COMPANY
  2. JOB-CODE
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ACTION-CODE
PrimaryLT101, LT103, LT11.3, LT111, LT13.3
LJBSET2
  1. COMPANY
  2. JOB-CODE
  3. STATUS
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ERROR-FLAG
  8. ACTION-CODE
KeyChangeLT01.1, LT101, LT103, LT111
LJBSET3
  1. COMPANY
  2. STATUS
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ERROR-FLAG
  7. JOB-CODE
  8. ACTION-CODE
KeyChangeLT101, LT111
LJBSET4
  1. COMPANY
  2. ACTION-CODE
  3. STATUS
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ERROR-FLAG
  8. JOB-CODE
KeyChange—
LJBSET5
  1. COMPANY
  2. JOB-CODE
  3. AUDIT-TRAN-ID
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ACTION-CODE
KeyChange—
LJBSET6
  1. COMPANY
  2. JOB-CODE
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ACTION-CODE
SubsetWhere (HAS-DELTA = 1)LT22.3

Programs

Updated by (6)

Referenced by (1)