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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#DSG-COMPANY PKCOMPANY | Numeric 4 | — | HR02.1 |
#DSG-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | HR02.1 |
#DSG-DEPARTMENT PKDEPARTMENT | Alpha 5 | Contains the department. | HR02.1 |
#DSG-SEGMENT-BLOCKSEGMENT_BLOCK | Alpha 103 | This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
DSGSET1 |
| Primary | BN150, HR02.1, HR202, PR521, EXI2.1, EXI4.1, LP130, ZE532 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Department | DEPTCODE | Required |
|
Programs
Updated by (1)
- HR02.1 Department
Referenced by (42)
- BN150 Life Insurance Reportable Income
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HR202 Department Listing
- LP130 Absence Plan Payout
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR189 Gross Up Calculation
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- ZE532 Pos Mgr Master List Interface