HRSUPER – Supervisors

System
Human Resources (HR)
Prefix
HSU
Primary key
COMPANY, CODE
Fields
21
Updated by
36 programs
Referenced by
145 programs

HRSUPER is the Supervisors table in Lawson Human Resources (prefix HSU). It is indexed by COMPANY, CODE (HSUSET1); alternate indexes: HSUSET2, HSUSET3 and HSUSET4. It is related 1:1 to PRSYSTEM, EMPLOYEE, EMSTATUS, PAEMPLOYEE, HRSUPER and PCODES and 1:M to PATHFIND, HRHISTORY and PAJOBREQ. It is updated by BN305, HR00.1, HR01.1, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1 and 28 more and referenced by BN145, BN231, BN232, BN234, BN238, BN240, BN245, BN246 and 137 more. The table has 21 fields, 4 indexes and 14 documented relations.

About HRSUPER

Contains the supervisor code and description as well as the employee number of the individual who is assigned to the supervisor position.

Fields (21)

Column = COBOL field name without the HSU- 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
#HSU-COMPANY PK
COMPANY		Numeric 4—HR07.1, HR507, LT101, LT111, PA242
#HSU-CODE PK
CODE		Alpha 10Contains the supervisor code. The supervisor code identifies the supervisor position.HR07.1, HR507, LT101, LT111
#HSU-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the supervisor code description.HR07.1, HR507, LT101, LT111, PA218
#HSU-EMPLOYEE SET3
EMPLOYEE		Numeric 9Contains the employee number of the individual who holds the supervisor position.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +27 more
#HSU-OBJ-ID SET2
OBJ_ID		Numeric 12Contains a system-assigned identifier that provides access to data in related files.HR07.1, HR507, LT101, LT111
#HSU-FULL-NAME
FULL_NAME		Derived——
#HSU-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date the supervisor code becomes effective.HR07.1, HR507, LT101, LT111
#HSU-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
HR07.1, HR507, LT101, LT111
#HSU-SUPER-RPTS-TO SET4
SUPER_RPTS_TO		Alpha 10Indicates supervisor to whom this supervisor reports.HR07.1, HR507, LT101, LT111
#HSU-USER1
USER1		Alpha 10Contains information from the first user field.HR07.1, HR507, LT101, LT111
#HSU-USER2
USER2		Alpha 10Contains information from the second supervisor user field.HR07.1, HR507, LT101, LT111
#HSU-USER3
USER3		Alpha 10Contains information from the third user field.HR07.1, HR507, LT101, LT111
#HSU-USER4
USER4		Alpha 10Contains information from the fourth user field.HR07.1, HR507, LT101, LT111
#HSU-USER5
USER5		Alpha 10Contains information from the fifth user field.HR07.1, HR507, LT101, LT111
#HSU-FULL-NAME-SUFF
FULL_NAME_SUFF		Derived——
#HSU-FULL-NAME-CND
FULL_NAME_CND		Derived——
#HSU-SHORT-NAME-CND
SHORT_NAME_CND		Derived——
#HSU-LABEL-NAME-1
LABEL_NAME_1		Derived——
#HSU-FULL-NAME-COND
FULL_NAME_COND		Derived——
#HSU-SHRT-NAME-COND
SHRT_NAME_COND		Derived——
#HSU-UPDATED-BY-LTM
UPDATED_BY_LTM		Alpha 1—
  • Y Yes
  • N No
—

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
HSUSET1
  1. COMPANY
  2. CODE
PrimaryBN145, BN231, BN232, BN234, BN238, BN240, BN245, BN246 +22 more (list truncated in source)
HSUSET2
  1. OBJ-ID
KeyChangeHR93.4
HSUSET3
  1. COMPANY
  2. EMPLOYEE
  3. CODE
KeyChangeHR11.1, HS10.1, HS10.2, HS12.1, HS12.2, HS13.1, HS13.2, HS15.1 +7 more
HSUSET4
  1. COMPANY
  2. SUPER-RPTS-TO
  3. CODE
KeyChange, SubsetWhere (SUPER-RPTS-TO != Spaces)HCSU.1, HR07.1, HR507, HS10.1, HS10.2, LT101, LT111

Relations

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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
HSU-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen HSU-EMPLOYEE != Zeroes
HSU-COMPANY→EMP-COMPANY
HSU-EMPLOYEE→EMP-EMPLOYEE
EmstatusEMSTATUSNot RequiredValid When HSU-EMPLOYEE != Zeroes
HSU-COMPANY→EMS-COMPANY
EMP-EMP-STATUS→EMS-EMP-STATUS
PaemployeePAEMPLOYEERequired
HSU-COMPANY→PEM-COMPANY
HSU-EMPLOYEE→PEM-EMPLOYEE
ParentHRSUPERNot RequiredValid When (HSU-SUPER-RPTS-TO != Spaces)
HSU-COMPANY→HSU-COMPANY
HSU-SUPER-RPTS-TO→HSU-CODE
User1PCODESNot RequiredValid When (HSU-USER1 != Spaces)
"S1"→PCO-TYPE
HSU-USER1→PCO-CODE
User2PCODESNot RequiredValid When (HSU-USER2 != Spaces)
"S2"→PCO-TYPE
HSU-USER2→PCO-CODE
User3PCODESNot RequiredValid When (HSU-USER3 != Spaces)
"S3"→PCO-TYPE
HSU-USER3→PCO-CODE
User4PCODESNot RequiredValid When (HSU-USER4 != Spaces)
"S4"→PCO-TYPE
HSU-USER4→PCO-CODE
User5PCODESNot RequiredValid When (HSU-USER5 != Spaces)
"S5"→PCO-TYPE
HSU-USER5→PCO-CODE

One to many (4) — child tables

RelationTableRulesConditionField map
EmployeesPATHFINDDelete Restricted
HSU-COMPANY→PTF-COMPANY
18→PTF-FLD-NBR
HSU-CODE→PTF-FLD-VALUE
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
HistoryHRHISTORYDelete Cascades
HSU-COMPANY→HRH-COMPANY
Zeroes→HRH-EMPLOYEE
HSU-OBJ-ID→HRH-OBJ-ID
—→HRH-FLD-NBR
—→HRH-BEG-DATE
—→HRH-SEQ-NBR
Indirect EmpsPATHFIND
HSU-COMPANY→PTF-COMPANY
289→PTF-FLD-NBR
HSU-CODE→PTF-FLD-VALUE
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
RequisitionPAJOBREQ
HSU-COMPANY→PJR-COMPANY
HSU-CODE→PJR-SUPERVISOR
—→PJR-REQUISITION

Programs

Updated by (36)

Referenced by (145)