PARTBEN – COBRA Participant Benefit

System
Benefits (BN)
Prefix
PTB
Primary key
COMPANY, PLAN-TYPE, PARTICIPNT, EMPLOYEE, START-DATE, PLAN-CODE
Fields
33
Updated by
5 programs
Referenced by
57 programs

PARTBEN is the COBRA Participant Benefit table in Lawson Benefits (prefix PTB). It is indexed by COMPANY, PLAN-TYPE, PARTICIPNT, EMPLOYEE, START-DATE, PLAN-CODE (PTBSET1); alternate indexes: PTBSET2, PTBSET3, PTBSET4 and PTBSET5. It is related 1:1 to BNCOVOPT, BNCOMPANY, PRSYSTEM, PERSGROUP, EMPLOYEE, PARTICIPNT, PLAN, PREMIUM and 1 more and 1:M to HRDEPBEN. It is updated by BN105, BN175, BN430, BN71.1 and BN72.1 and referenced by BN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN100, BN101 and 49 more. The table has 33 fields, 5 indexes and 11 documented relations.

About PARTBEN

The COBRA Participant Benefit file contains benefit records for COBRA participants and retirees.

Fields (33)

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

Field / columnTypeDescription & valuesUpdated by
PTB-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN105, BN71.1, BN72.1
PTB-PLAN-TYPE PK
PLAN_TYPE		Alpha 2This field contains the code that identifies the type of benefit plan.
  • DB Defined Benefit
  • DC Defined Contribution
  • DI Disability
  • DL Dependent Life
  • DN Dental
  • EL Employee Life
  • HL Health
  • RS Reserve Account
  • SB Savings Bond
  • SP Stock Purchase
  • VA Vacation
BN105, BN71.1, BN72.1
PTB-PLAN-CODE PK
PLAN_CODE		Alpha 4The user-defined code used to represent a specific benefit plan.BN105, BN71.1, BN72.1
PTB-PARTICIPNT PK
PARTICIPNT		Numeric 9This is the COBRA participant's number. This is not the same as the employee number. If this record is for a retiree, this field is blank.BN105, BN331, BN71.1, BN72.1
PTB-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. This field only has a value in it if this record is for a retiree. If the record is for a COBRA participant, this field is blank.BN105, BN71.1, BN72.1
PTB-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)This is the benefit start date. It determines when premium/invoicing begins for the participant/employee.BN105, BN71.1, BN72.1
PTB-STOP-DATE
STOP_DATE		Numeric 8 (yyyymmdd)This field indicates when the participant/retiree terminates or switches coverage. This field also is used to terminate premium invoicing.BN105, BN175, BN71.1, BN72.1
PTB-COV-OPTION
COV_OPTION		Numeric 2This field selects the plan and coverage type desired by the participant/retiree.BN105, BN71.1, BN72.1
PTB-COVER-AMT
COVER_AMT		Signed 11.2This field specifies the coverage amount. The system uses this field to calculate the premium for the desired coverage amount. The user enters the coverage amount.BN105, BN71.1, BN72.1
PTB-DEP-COVER-AMT
DEP_COVER_AMT		Signed 11.2——
PTB-COMP-CONT
COMP_CONT		Signed 11.2This is the company contribution for retiree premiums.BN105, BN71.1, BN72.1
PTB-EMP-AFT-CONT
EMP_AFT_CONT		Signed 11.2This is the Retiree or COBRA contribution amount.BN105, BN71.1, BN72.1
PTB-EXC-PREM-AMT
EXC_PREM_AMT		Signed 7.2This is the excess premium amount for COBRA participants (holds the surcharge for administrative costs).—
PTB-PAY-PER-AMT
PAY_PER_AMT		Signed 7.2Contains the monthly contribution amount for spending accounts. This field is used only for COBRA participants.BN105, BN71.1, BN72.1
PTB-ANNUAL-AMT
ANNUAL_AMT		Signed 9.2Contains the annual contribution for spending accounts. This field is used only for COBRA participants.BN105, BN71.1, BN72.1
PTB-SMOKER
SMOKER		Alpha 1Indicates if the participant is a smoker.BN105, BN71.1, BN72.1
PTB-PREM-UPD-DT
PREM_UPD_DT		Numeric 8 (yyyymmdd)Contains the most recent start date.BN105, BN71.1, BN72.1
PTB-PREM-GROUP
PREM_GROUP		Alpha 10Contains the employee group name of the contribution record for retiree or COBRA benefits.BN105, BN71.1, BN72.1
PTB-COV-UPD-DT
COV_UPD_DT		Numeric 8 (yyyymmdd)Contains the start date of the coverage record used for this benefit.BN105, BN71.1, BN72.1
PTB-CNT-AGE-DATE
CNT_AGE_DATE		Numeric 8 (yyyymmdd)——
PTB-COV-GROUP
COV_GROUP		Alpha 10Contains the employee group name of the coverage record for retiree and COBRA benefits.BN105, BN71.1, BN72.1
PTB-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.BN105, BN71.1, BN72.1
PTB-UPD-DATE
UPD_DATE		Numeric 8 (yyyymmdd)Contains the date the retiree or COBRA benefits were updated.BN105, BN175, BN71.1, BN72.1
PTB-MO-COMP-CONT
MO_COMP_CONT		Derived——
PTB-MO-EMP-AFT
MO_EMP_AFT		Derived——
PTB-MO-EXC-PREM
MO_EXC_PREM		Derived——
PTB-MO-TOT-EMP
MO_TOT_EMP		Derived——
PTB-TOT-EMP-PREM
TOT_EMP_PREM		Derived——
PTB-PLAN-TYPE-2
PLAN_TYPE_2		Derived——
PTB-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN105, BN175, BN71.1, BN72.1
PTB-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN105, BN175, BN71.1, BN72.1
PTB-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN105, BN71.1, BN72.1
PTB-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN105, BN71.1, BN72.1

Indexes (5)

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

IndexKeysFlagsConditionUsed in
PTBSET1COMPANY, PLAN-TYPE, PARTICIPNT, EMPLOYEE, START-DATE, PLAN-CODEPrimaryBN00.1, BN100, BN101, BN102, BN103, BN105, BN106, BN175 +22 more (list truncated in source)
PTBSET2COMPANY, PLAN-TYPE, PLAN-CODE, PARTICIPNT, EMPLOYEE, START-DATE*BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN105, BN106, BN15.1 +19 more
PTBSET3COMPANY, PLAN-TYPE, PLAN-CODE, PREM-UPD-DT, PREM-GROUP, EMPLOYEE, PARTICIPNT, START-DATEKeyChangeBN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +5 more
PTBSET4COMPANY, PARTICIPNT, EMPLOYEE, PLAN-TYPE, PLAN-CODE, START-DATE*KeyChangeBN105, BN233, BN331, BN71.1, BN72.1
PTBSET5COMPANY, EMPLOYEE, PARTICIPNT, PLAN-TYPE, PLAN-CODE, START-DATEKeyChangeBN100, BN101, BN102, BN103, BN105, BN180, BN31.1, BN31.2 +22 more (list truncated in source)

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
BncovoptBNCOVOPTNot RequiredPTB-COMPANY → COP-COMPANY, PTB-PLAN-TYPE → COP-PLAN-TYPE, PTB-PLAN-CODE → COP-PLAN-CODE, PTB-COV-OPTION → COP-COVERAGE-OPT
CompanyBNCOMPANYRequiredPTB-COMPANY → BNC-COMPANY
Company NamePRSYSTEMRequiredPTB-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Contrib GroupPERSGROUPNot RequiredPTB-COMPANY → PRG-COMPANY, PTB-PREM-GROUP → PRG-GROUP-NAME
Coverage GroupPERSGROUPNot RequiredPTB-COMPANY → PRG-COMPANY, PTB-COV-GROUP → PRG-GROUP-NAME
EmployeeEMPLOYEERequiredWhen PTB-EMPLOYEE != Zeroes And PTB-PARTICIPNT = ZeroesPTB-COMPANY → EMP-COMPANY, PTB-EMPLOYEE → EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen PTB-PARTICIPNT != ZeroesPTB-COMPANY → PAR-COMPANY, PTB-PARTICIPNT → PAR-PARTICIPNT
PlanPLANRequiredPTB-COMPANY → PLN-COMPANY, PTB-PLAN-TYPE → PLN-PLAN-TYPE, PTB-PLAN-CODE → PLN-PLAN-CODE
Ret Cont GroupPREMIUMNot RequiredPTB-COMPANY → PRE-COMPANY, PTB-PLAN-TYPE → PRE-PLAN-TYPE, PTB-PLAN-CODE → PRE-PLAN-CODE, "R" → PRE-COVER-TYPE, PTB-START-DATE → PRE-START-DATE, PTB-PREM-GROUP → PRE-GROUP-NAME
Ret Cov GroupBNCOVERAGENot RequiredPTB-COMPANY → CVR-COMPANY, PTB-PLAN-TYPE → CVR-PLAN-TYPE, PTB-PLAN-CODE → CVR-PLAN-CODE, "R" → CVR-COVER-TYPE, PTB-START-DATE → CVR-START-DATE, PTB-COV-GROUP → CVR-GROUP-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
HrdepbenHRDEPBENPTB-COMPANY → HDB-COMPANY, PTB-EMPLOYEE → HDB-EMPLOYEE, PTB-PLAN-TYPE → HDB-PLAN-TYPE, PTB-PLAN-CODE → HDB-PLAN-CODE, PTB-START-DATE → HDB-EMP-START, → HDB-DEPENDENT, → HDB-START-DATE

Programs

Updated by (5)

Referenced by (57)