HROCCUPCD – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
HOP
Primary key
COMPANY, JOB-CODE, COUNTRY-CODE, OCCUPTN-CODE
Fields
10
Updated by
103 programs
Referenced by
4 programs

HROCCUPCD is a Lawson Human Resources table (prefix HOP); no description in the lawson data dictionary. It is indexed by COMPANY, JOB-CODE, COUNTRY-CODE, OCCUPTN-CODE (HOPSET1); alternate indexes: HOPSET2 and HOPSET3. It is related 1:1 to PRSYSTEM, INSTCTRYCD, JOBCODE, HRCTRYCODE and PCODES. It is updated by HR00.1, HR01.1, HR04.2, HR04.3, HR04.7, HR04.8, HR06.1, HR22.1 and 95 more and referenced by HR03.2, HR206, HR222 and ZE532. The table has 10 fields, 3 indexes and 5 documented relations.

About HROCCUPCD

No description in the Lawson data dictionary.

Fields (10)

Column = COBOL field name without the HOP- 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
#HOP-COMPANY PK
COMPANY		Numeric 4—HR22.1
#HOP-JOB-CODE PK
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.HR22.1
#HOP-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).HR22.1
#HOP-OCCUPTN-CODE PK
OCCUPTN_CODE		Alpha 4 (Lower Case)—HR22.1, ZE532
#HOP-OCCUPTN-TYPE SET3
OCCUPTN_TYPE		Alpha 10Code that is valid for the specified record type.HR22.1
#HOP-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
HR22.1
#HOP-COMMENT
COMMENT		Alpha 40 (Lower Case)This field contains the comment narrative.HR22.1
#HOP-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR22.1
#HOP-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR22.1
#HOP-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR22.1

Indexes (3)

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
HOPSET1
  1. COMPANY
  2. JOB-CODE
  3. COUNTRY-CODE
  4. OCCUPTN-CODE
PrimaryHR00.1, HR01.1, HR06.1, HR206, HR22.1, HR222, HR506, LT101 +3 more
HOPSET2
  1. COUNTRY-CODE
  2. OCCUPTN-CODE
  3. COMPANY
  4. JOB-CODE
HR03.2, HR91.1, HR91.2, HR91.3, HR91.4, HR91.5, HR91.6
HOPSET3
  1. COMPANY
  2. OCCUPTN-TYPE
  3. COUNTRY-CODE
  4. OCCUPTN-CODE
  5. JOB-CODE
KeyChange, SubsetWhere (OCCUPTN-TYPE != Spaces)HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
HOP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Country CodeINSTCTRYCDRequired
HOP-COUNTRY-CODE→INT-COUNTRY-CODE
Job CodeJOBCODERequired
HOP-COMPANY→JBC-COMPANY
HOP-JOB-CODE→JBC-JOB-CODE
Occuptn CodeHRCTRYCODERequired
"JO"→CTC-TYPE
HOP-COUNTRY-CODE→CTC-COUNTRY-CODE
HOP-OCCUPTN-CODE→CTC-HRCTRY-CODE
Occuptn TypePCODESRequiredWhen (HOP-OCCUPTN-TYPE != Spaces)
"JT"→PCO-TYPE
HOP-OCCUPTN-TYPE→PCO-CODE

Programs

Updated by (103)

Referenced by (4)