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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HOPSET1COMPANY, JOB-CODE, COUNTRY-CODE, OCCUPTN-CODEPrimaryHR00.1, HR01.1, HR06.1, HR206, HR22.1, HR222, HR506, LT101 +3 more
HOPSET2COUNTRY-CODE, OCCUPTN-CODE, COMPANY, JOB-CODEHR03.2, HR91.1, HR91.2, HR91.3, HR91.4, HR91.5, HR91.6
HOPSET3COMPANY, OCCUPTN-TYPE, COUNTRY-CODE, OCCUPTN-CODE, JOB-CODEKeyChange, 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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredHOP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Country CodeINSTCTRYCDRequiredHOP-COUNTRY-CODE → INT-COUNTRY-CODE
Job CodeJOBCODERequiredHOP-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)