DEPTSEGBLK – Department Segment Block

System
Human Resources (HR)
Prefix
DSG
Primary key
COMPANY, PROCESS-LEVEL, DEPARTMENT
Fields
4
Updated by
1 program
Referenced by
42 programs

DEPTSEGBLK is the Department Segment Block table in Lawson Human Resources (prefix DSG). It is indexed by COMPANY, PROCESS-LEVEL, DEPARTMENT (DSGSET1). It is related 1:1 to DEPTCODE. It is updated by HR02.1 and referenced by BN150, EXI2.1, EXI4.1, HR202, LP130, PR128, PR131, PR132 and 34 more. The table has 4 fields, 1 index and 1 documented relation.

About DEPTSEGBLK

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
DSG-COMPANY PK
COMPANY		Numeric 4—HR02.1
DSG-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—HR02.1
DSG-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.HR02.1
DSG-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.HR02.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
DSGSET1COMPANY, PROCESS-LEVEL, DEPARTMENTPrimaryBN150, HR02.1, HR202, PR521, EXI2.1, EXI4.1, LP130, ZE532 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
DepartmentDEPTCODERequiredDSG-COMPANY → DPT-COMPANY, DSG-PROCESS-LEVEL → DPT-PROCESS-LEVEL, DSG-DEPARTMENT → DPT-DEPARTMENT

Programs

Updated by (1)

Referenced by (42)