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.

Field / column	Type	Description & values	Updated by
`HSU-COMPANY` PK COMPANY	Numeric 4	—	HR07.1, HR507, LT101, LT111, PA242
`HSU-CODE` PK CODE	Alpha 10	Contains 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` EMPLOYEE	Numeric 9	Contains 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` OBJ_ID	Numeric 12	Contains 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 1	The Active flag of the credit card type. `A` Active `I` Inactive	HR07.1, HR507, LT101, LT111
`HSU-SUPER-RPTS-TO` SUPER_RPTS_TO	Alpha 10	Indicates supervisor to whom this supervisor reports.	HR07.1, HR507, LT101, LT111
`HSU-USER1` USER1	Alpha 10	Contains information from the first user field.	HR07.1, HR507, LT101, LT111
`HSU-USER2` USER2	Alpha 10	Contains information from the second supervisor user field.	HR07.1, HR507, LT101, LT111
`HSU-USER3` USER3	Alpha 10	Contains information from the third user field.	HR07.1, HR507, LT101, LT111
`HSU-USER4` USER4	Alpha 10	Contains information from the fourth user field.	HR07.1, HR507, LT101, LT111
`HSU-USER5` USER5	Alpha 10	Contains 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`HSUSET1`	`COMPANY`, `CODE`	Primary		BN145, BN231, BN232, BN234, BN238, BN240, BN245, BN246 +22 more (list truncated in source)
`HSUSET2`	`OBJ-ID`	KeyChange		HR93.4
`HSUSET3`	`COMPANY`, `EMPLOYEE`, `CODE`	KeyChange		HR11.1, HS10.1, HS10.2, HS12.1, HS12.2, HS13.1, HS13.2, HS15.1 +7 more
`HSUSET4`	`COMPANY`, `SUPER-RPTS-TO`, `CODE`	KeyChange, Subset	Where (SUPER-RPTS-TO != Spaces)	HCSU.1, HR07.1, HR507, HS10.1, HS10.2, LT101, LT111

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`HSU-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	When HSU-EMPLOYEE != Zeroes	`HSU-COMPANY` → `EMP-COMPANY`, `HSU-EMPLOYEE` → `EMP-EMPLOYEE`
Emstatus	EMSTATUS	Not Required	Valid When HSU-EMPLOYEE != Zeroes	`HSU-COMPANY` → `EMS-COMPANY`, `EMP-EMP-STATUS` → `EMS-EMP-STATUS`
Paemployee	PAEMPLOYEE	Required		`HSU-COMPANY` → `PEM-COMPANY`, `HSU-EMPLOYEE` → `PEM-EMPLOYEE`
Parent	HRSUPER	Not Required	Valid When (HSU-SUPER-RPTS-TO != Spaces)	`HSU-COMPANY` → `HSU-COMPANY`, `HSU-SUPER-RPTS-TO` → `HSU-CODE`
User1	PCODES	Not Required	Valid When (HSU-USER1 != Spaces)	`"S1"` → `PCO-TYPE`, `HSU-USER1` → `PCO-CODE`
User2	PCODES	Not Required	Valid When (HSU-USER2 != Spaces)	`"S2"` → `PCO-TYPE`, `HSU-USER2` → `PCO-CODE`
User3	PCODES	Not Required	Valid When (HSU-USER3 != Spaces)	`"S3"` → `PCO-TYPE`, `HSU-USER3` → `PCO-CODE`
User4	PCODES	Not Required	Valid When (HSU-USER4 != Spaces)	`"S4"` → `PCO-TYPE`, `HSU-USER4` → `PCO-CODE`
User5	PCODES	Not Required	Valid When (HSU-USER5 != Spaces)	`"S5"` → `PCO-TYPE`, `HSU-USER5` → `PCO-CODE`

One to many (4) — child tables

Relation	Table	Rules	Field map
Employees	PATHFIND	Delete Restricted	`HSU-COMPANY` → `PTF-COMPANY`, `18` → `PTF-FLD-NBR`, `HSU-CODE` → `PTF-FLD-VALUE`, → `PTF-EMPLOYEE`, → `PTF-POS-LEVEL`
History	HRHISTORY	Delete Cascades	`HSU-COMPANY` → `HRH-COMPANY`, `Zeroes` → `HRH-EMPLOYEE`, `HSU-OBJ-ID` → `HRH-OBJ-ID`, → `HRH-FLD-NBR`, → `HRH-BEG-DATE`, → `HRH-SEQ-NBR`
Indirect Emps	PATHFIND		`HSU-COMPANY` → `PTF-COMPANY`, `289` → `PTF-FLD-NBR`, `HSU-CODE` → `PTF-FLD-VALUE`, → `PTF-EMPLOYEE`, → `PTF-POS-LEVEL`
Requisition	PAJOBREQ		`HSU-COMPANY` → `PJR-COMPANY`, `HSU-CODE` → `PJR-SUPERVISOR`, → `PJR-REQUISITION`

Programs

Updated by (36)

BN305 Highly Compensated Employees
HR00.1 Company
HR01.1 Process Level
HR07.1 Supervisor
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR28.1 Employee Ethnicity
HR507 Supervisor Conversion
HR511 Employee Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

Referenced by (145)

BN145 Flex Dollars Calculation
BN231 Employee Benefit Report
BN232 Benefits Statement
BN234 Employee Stock Option Listing
BN238 Vacation Hours History
BN240 Savings Bond Balance Report
BN245 Benefit Election Form
BN246 Flex Missing Benefits Report
BN335 Employee Deferral Report
EXLD.1 Load XM Users
HAP3.1 Applicant Option 4 Selection Invoke
HCDL.1 Olap Data Load
HCEM.1 Olap Dimension Retrieval Format
HCHP.1 Olap Data Load
HCRE.1 Action Reason Code Selects
HCSU.1 Olap Dimension Retrieval Format
HEP4.1 Employee Option 4 Selection Invoke
HHSU.1 Supervisor Select Invoke
HLTM.1 Lawson Talent Management Feed
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR15.1 User Fields
HR155 Employee Group Update
HR156 Employee Group Company Update
HR170 Human Resource Writer Report Request
HR207 Supervisor Listing
HR211 Employee Listing
HR213 Dependent Listing
HR217 Work Eligibility Listing
HR220 Additional Contact Listing
HR51.2 Employee Interface Data
HR51.5 Supervisor Interface Data
HR51.6 Emp Position Interface Data
HR51.8 WFM Interface Data
HR515 User Field Conversion
HR52.2 Talent Management Interface Data
HR52.5 Talent Mngmt Supervisor Data
HR52.6 Talent Mngmt Emp Position Data
HR54.1 Employee History Correction
HR55.2 Employee Groups By Employees
HR70.1 Human Resource Writer Inquiry
HR93.4 Supervisor Audit Inquiry
HRLRD Import Employee Data
HRS1.1 Select Control
HRSC.1 Select Control
HS10.1 Direct Report Inquiry
HS10.2 Direct Report Inquiry
HS12.1 Web Expired Competencies
HS12.2 Web Expired Competencies
HS13.1 Web Competency Compliance Rpt
HS13.2 Web Competency Compliance Rpt
HS15.1 Web Direct Rpt Inq - Emp Dtl
HS19.1 Employee Paid Time Off Request Balances
HS20.1 Time Form Inquiry
HS208 Goal Management Report
HS21.1 Time Form Inquiry
HS22.1 Pending Time Summary
HS22.2 Direct Reports Pay Plans
HS22.3 Reporting Pay Plans With Dates
HS36.1 Pending Time Records
HS52.1 Employee Qualification Search
HS52.2 Employee Qualification Search
HS703 LPMH Employee and Job Profile Extract
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP251 Employee Leave of Absence Report
LP260 Employee Service and Event Report
LP262 Employee Event Audit Report
LT11.5 HRM User Field Interface
LT13.5 HRM User Field Interface History
PA103 Mass Position Changes
PA113 Retroactive History Update
PA149 Update Scheduled Tests
PA16.1 Company Property
PA20.1 Education
PA202 Position Listing
PA208 Position and Job Description List
PA21.1 Competencies
PA210 Length of Service Report
PA212 Emergency Contact Listing
PA214 Military Service Listing
PA215 Medical Listing
PA216 Company Property Listing
PA217 Automobile Listing
PA218 Travel Listing
PA22.1 Certifications
PA220 Education Listing
PA221 Employee Competency Listing
PA222 Certification Listing
PA223 Starters and Leavers Report
PA224 Relocation Listing
PA225 Employee Benefits Listing
PA227 Contract Listing
PA24.1 Relocation
PA242 Requisition Listing
PA248 Test Listing
PA249 Employee and Applicant Test Listing
PA262 Qualified Employees Listing
PA27.1 Contracts
PA272 Budget and Assigned Resource Listing
PA290 Health and Safety Incident Listing
PA310 Birthdate Listing
PA311 Employee Profile
PA315 Telephone Listing
PA320 Interoffice Directory
PA325 Post Office Mailing Listing
PA330 Interoffice Labels
PA335 Employee Listing
PA34.1 Applicant Education
PA345 Review Schedule Report
PA35.1 Applicant Competencies
PA350 Review History Report
PA355 Active Actions Report
PA36.1 Applicant Certification
PA360 Wage Analysis Report
PA370 Employee Review Document
PA372 Health and Safety Incident Purge
PA38.1 Applicant Relocation
PA42.1 Requisition
PA42.3 Requisition Approval Override
PA490 OSHA Log, Summary Report
PA520 Employee and Applicant Code Conversion
PA53.1 Personnel Action Workflow Override
PA532 Code, Requisitions Exports
PA535 e-Recruiting Requisition Conversion
PA54.1 Personnel Action History Correction
PA59.1 Grievance and Disciplinary Actions
PA590 Health and Safety Incident Conversion
PA66.2 Action Inquiry
PA66.3 Employee Action Detail
PA90.1 Health and Safety Incident
TM240 Employee Attendance Code Report
TM245 Employee Attendance Class Report
TM470 Attendance History Audit Report
TM52.1 Attendance Inquiry
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion
ZE532 Pos Mgr Master List Interface
ZH156 Employee Group Company Update
ZH230 PPH Big Bad Edit
ZH500 Employee Data Extract
ZH568 Reed Employee Census Interface