COBRA Participant Benefit
The COBRA Participant Benefit file contains benefit records for COBRA participants and retirees.
REFERENCED BY
BN105 | BN175 | BN430 | BN71.1 | BN72.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
PTB-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||||
PTB-PLAN-TYPE Element: Plan Type | Alpha 2 This 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 |
|
||||
PTB-PLAN-CODE Element: Plan Code | Alpha 4 The user-defined code used to represent a specific benefit plan. |
|
||||
PTB-PARTICIPNT Element: Participnt | Numeric 9 This 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. |
|
||||
PTB-EMPLOYEE Element: Employee | Numeric 9 Contains 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. |
|
||||
PTB-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) This is the benefit start date. It determines when premium/invoicing begins for the participant/employee. |
|
||||
PTB-STOP-DATE Element: 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. |
|
||||
PTB-COV-OPTION Element: Cov Option | Numeric 2 This field selects the plan and coverage type desired by the participant/retiree. |
|
||||
PTB-COVER-AMT Element: Cover Amt | Signed 11.2 This 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. |
|
||||
PTB-DEP-COVER-AMT Element: Dep Cover Amt | Signed 11.2 |
|
||||
PTB-COMP-CONT Element: Comp Cont | Signed 11.2 This is the company contribution for retiree premiums. |
|
||||
PTB-EMP-AFT-CONT Element: Emp Aft Cont | Signed 11.2 This is the Retiree or COBRA contribution amount. |
|
||||
PTB-EXC-PREM-AMT Element: Exc Prem Amt | Signed 7.2 This is the excess premium amount for COBRA participants (holds the surcharge for administrative costs). |
|
||||
PTB-PAY-PER-AMT Element: Pay Per Amt | Signed 7.2 Contains the monthly contribution amount for spending accounts. This field is used only for COBRA participants. |
|
||||
PTB-ANNUAL-AMT Element: Annual Amt | Signed 9.2 Contains the annual contribution for spending accounts. This field is used only for COBRA participants. |
|
||||
PTB-SMOKER Element: Smoker | Alpha 1 Indicates if the participant is a smoker. |
|
||||
PTB-PREM-UPD-DT Element: Prem Upd Dt | Numeric 8 (yyyymmdd) Contains the most recent start date. |
|
||||
PTB-PREM-GROUP Element: Prem Group | Alpha 10 Contains the employee group name of the contribution record for retiree or COBRA benefits. |
|
||||
PTB-COV-UPD-DT Element: Cov Upd Dt | Numeric 8 (yyyymmdd) Contains the start date of the coverage record used for this benefit. |
|
||||
PTB-CNT-AGE-DATE Element: Cnt Age Date | Numeric 8 (yyyymmdd) |
|
||||
PTB-COV-GROUP Element: Cov Group | Alpha 10 Contains the employee group name of the coverage record for retiree and COBRA benefits. |
|
||||
PTB-CREATION-DATE Element: Creation Date | Numeric 8 (yyyymmdd) This is the date that this line was added to the requisition. |
|
||||
PTB-UPD-DATE Element: Upd Date | Numeric 8 (yyyymmdd) Contains the date the retiree or COBRA benefits were updated. |
|
||||
PTB-MO-COMP-CONT Element: Mo Comp Cont | Derived |
|
||||
PTB-MO-EMP-AFT Element: Mo Emp Aft | Derived |
|
||||
PTB-MO-EXC-PREM Element: Mo Exc Prem | Derived |
|
||||
PTB-MO-TOT-EMP Element: Mo Tot Emp | Derived |
|
||||
PTB-TOT-EMP-PREM Element: Tot Emp Prem | Derived |
|
||||
PTB-PLAN-TYPE-2 Element: Plan Type 2 | Derived |
|
||||
PTB-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||
PTB-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||
PTB-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||
PTB-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bncovopt | BNCOVOPT |
Not Required
| ||||||||||||||||||
Company | BNCOMPANY |
Required
| ||||||||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||||||||
Contrib Group | PERSGROUP |
Not Required
| ||||||||||||||||||
Coverage Group | PERSGROUP |
Not Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||
Participant | PARTICIPNT |
Required
| ||||||||||||||||||
Plan | PLAN |
Required
| ||||||||||||||||||
Ret Cont Group | PREMIUM |
Not Required
| ||||||||||||||||||
Ret Cov Group | BNCOVERAGE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Hrdepben | HRDEPBEN |
|
All trademarks and registered trademarks are the property of their
respective owners.