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

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 SET3
PREM_UPD_DT		Numeric 8 (yyyymmdd)Contains the most recent start date.BN105, BN71.1, BN72.1
#PTB-PREM-GROUP SET3
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 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
PTBSET1
  1. COMPANY
  2. PLAN-TYPE
  3. PARTICIPNT
  4. EMPLOYEE
  5. START-DATE
  6. PLAN-CODE
PrimaryBN00.1, BN100, BN101, BN102, BN103, BN105, BN106, BN175 +22 more (list truncated in source)
PTBSET2
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. PARTICIPNT
  5. EMPLOYEE
  6. START-DATE ↓
BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN105, BN106, BN15.1 +19 more
PTBSET3
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. PREM-UPD-DT
  5. PREM-GROUP
  6. EMPLOYEE
  7. PARTICIPNT
  8. START-DATE
KeyChangeBN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +5 more
PTBSET4
  1. COMPANY
  2. PARTICIPNT
  3. EMPLOYEE
  4. PLAN-TYPE
  5. PLAN-CODE
  6. START-DATE ↓
KeyChangeBN105, BN233, BN331, BN71.1, BN72.1
PTBSET5
  1. COMPANY
  2. EMPLOYEE
  3. PARTICIPNT
  4. PLAN-TYPE
  5. PLAN-CODE
  6. START-DATE
KeyChangeBN100, BN101, BN102, BN103, BN105, BN180, BN31.1, BN31.2 +22 more (list truncated in source)

Relations

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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
BncovoptBNCOVOPTNot Required
PTB-COMPANY→COP-COMPANY
PTB-PLAN-TYPE→COP-PLAN-TYPE
PTB-PLAN-CODE→COP-PLAN-CODE
PTB-COV-OPTION→COP-COVERAGE-OPT
CompanyBNCOMPANYRequired
PTB-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
PTB-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Contrib GroupPERSGROUPNot Required
PTB-COMPANY→PRG-COMPANY
PTB-PREM-GROUP→PRG-GROUP-NAME
Coverage GroupPERSGROUPNot Required
PTB-COMPANY→PRG-COMPANY
PTB-COV-GROUP→PRG-GROUP-NAME
EmployeeEMPLOYEERequiredWhen PTB-EMPLOYEE != Zeroes And PTB-PARTICIPNT = Zeroes
PTB-COMPANY→EMP-COMPANY
PTB-EMPLOYEE→EMP-EMPLOYEE
ParticipantPARTICIPNTRequiredWhen PTB-PARTICIPNT != Zeroes
PTB-COMPANY→PAR-COMPANY
PTB-PARTICIPNT→PAR-PARTICIPNT
PlanPLANRequired
PTB-COMPANY→PLN-COMPANY
PTB-PLAN-TYPE→PLN-PLAN-TYPE
PTB-PLAN-CODE→PLN-PLAN-CODE
Ret Cont GroupPREMIUMNot Required
PTB-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 Required
PTB-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
HrdepbenHRDEPBEN
PTB-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)