HRSECLEV – Employee Security Level

System
Human Resources (HR)
Prefix
HSL
Primary key
USERNAME
Fields
2
Updated by
1 program
Referenced by
543 programs

HRSECLEV is the Employee Security Level table in Lawson Human Resources (prefix HSL). It is indexed by USERNAME (HSLSET1). It is updated by HR09.1 and referenced by AC03.3, AC03.7, AC145, AC17.3, AC18.2, AC191, AC203, AC210 and 535 more. The table has 2 fields, 1 index and 0 documented relations.

About HRSECLEV

Contains user names and their associated security level for data items.

Fields (2)

Column = COBOL field name without the HSL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
HSL-USERNAME PK
USERNAME		Alpha 10 (Lower Case)Contains the user's name.HR09.1
HSL-SEC-LEVEL
SEC_LEVEL		Numeric 1Contains the user's data item security level.HR09.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HSLSET1USERNAMEPrimaryAC03.3, AC03.7, AC145, AC17.3, AC18.2, AC191, AC203, AC210 +22 more (list truncated in source)

Programs

Updated by (1)

Referenced by (543)