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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DEPSET1
  1. COMPANY
  2. EMPLOYEE
  3. DEPENDENT
  4. PLAN-TYPE
  5. PLAN-CODE
  6. EMP-START
  7. START-DATE
PrimaryBS30.1, BS31.1, ZB10.3, HR11.1, HR13.1, HR513, PA115, PA218
DEPSET3
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. EMP-START
  6. DEPENDENT
  7. START-DATE
BS531, ZS531

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BNBENPRSYSTEMEMDEPENDEMPLOYEEPLANPCODESDEPBEN

One to one (6) — lookups and parents

RelationTableRulesConditionField map
BnbenBNBENRequired
DEP-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
CompanyPRSYSTEMRequired
DEP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DependentEMDEPENDRequired
DEP-COMPANY→EMD-COMPANY
DEP-EMPLOYEE→EMD-EMPLOYEE
DEP-DEPENDENT→EMD-SEQ-NBR
EmployeeEMPLOYEERequired
DEP-COMPANY→EMP-COMPANY
DEP-EMPLOYEE→EMP-EMPLOYEE
PlanPLANRequired
DEP-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)