DEPBEN – No description in the Lawson data dictionary

System
Benefits (BN)
Prefix
DEP
Primary key
COMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATE
Fields
20
Updated by
10 programs
Referenced by
0 programs

DEPBEN is a Lawson Benefits table (prefix DEP); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATE (DEPSET1); alternate indexes: DEPSET3. It is related 1:1 to BNBEN, PRSYSTEM, EMDEPEND, EMPLOYEE, PLAN and PCODES. It is updated by BS30.1, BS31.1, BS531, HR11.1, HR13.1, HR513, PA115, PA218 and 2 more. The table has 20 fields, 2 indexes and 6 documented relations.

About DEPBEN

No description in the Lawson data dictionary.

Fields (20)

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

Field / columnTypeDescription & valuesUpdated by
DEP-COMPANY PK
COMPANY		Numeric 4—BS30.1
DEP-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BS30.1
DEP-DEPENDENT PK
DEPENDENT		Numeric 4—BS30.1
DEP-PLAN-TYPE PK
PLAN_TYPE		Alpha 2—BS30.1
DEP-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the user-defined code that represents a benefit plan.BS30.1
DEP-EMP-START PK
EMP_START		Numeric 8 (yyyymmdd)—BS30.1
DEP-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)—BS30.1
DEP-STOP-DATE
STOP_DATE		Numeric 8 (yyyymmdd)—BS30.1
DEP-FC
FC		Alpha 1—BS30.1
DEP-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.BS30.1
DEP-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BS30.1
DEP-USER-ID
USER_ID		Alpha 10 (Lower Case)—BS30.1
DEP-CREATE-TRANS
CREATE_TRANS		Alpha 1—
  • Y Yes
  • N No
BS30.1
DEP-TRAN-REASON
TRAN_REASON		Alpha 10—BS30.1
DEP-MEMBER-ID
MEMBER_ID		Numeric 1—BS30.1
DEP-BN-TYPE
BN_TYPE		Alpha 1—
  • 1 Annual
  • 2 Life Event
  • 3 New Hire
BS30.1
DEP-HOLD-FLAG
HOLD_FLAG		Alpha 1—
  • N No
  • Y Yes
BS30.1
DEP-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BS30.1
DEP-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BS30.1
DEP-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BS30.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
DEPSET1COMPANY, EMPLOYEE, DEPENDENT, PLAN-TYPE, PLAN-CODE, EMP-START, START-DATEPrimaryBS30.1, BS31.1, ZB10.3, HR11.1, HR13.1, HR513, PA115, PA218
DEPSET3COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, EMP-START, DEPENDENT, START-DATEBS531, ZS531

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
BnbenBNBENRequiredDEP-COMPANY → BNB-COMPANY, DEP-EMPLOYEE → BNB-EMPLOYEE, DEP-PLAN-TYPE → BNB-PLAN-TYPE, DEP-PLAN-CODE → BNB-PLAN-CODE, DEP-EMP-START → BNB-START-DATE
CompanyPRSYSTEMRequiredDEP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DependentEMDEPENDRequiredDEP-COMPANY → EMD-COMPANY, DEP-EMPLOYEE → EMD-EMPLOYEE, DEP-DEPENDENT → EMD-SEQ-NBR
EmployeeEMPLOYEERequiredDEP-COMPANY → EMP-COMPANY, DEP-EMPLOYEE → EMP-EMPLOYEE
PlanPLANRequiredDEP-COMPANY → PLN-COMPANY, DEP-PLAN-TYPE → PLN-PLAN-TYPE, DEP-PLAN-CODE → PLN-PLAN-CODE
Reason CodePCODESRequiredWhen DEP-TRAN-REASON != Spaces"BT" → PCO-TYPE, DEP-TRAN-REASON → PCO-CODE

Programs

Updated by (10)