Benefit Premium Options
REFERENCED BY
BN15.1 | BN17.1 | BN18.1 | BN18.2 | BN18.3 | BN18.4 |
BN18.5 | BN18.6 | BN18.7 | BN19.1 | BN19.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
PCV-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||||
PCV-PLAN-TYPE Element: Plan Type | Alpha 2 Contains the plan type that identifies the type of benefit. HL = Health DN = Dental DI = Disability EL = Life DL = Dependent Life DC = Defined Contribution DB = Defined Benefit VA = Vacation RS = Spending Account SB = Savings Bond SP = Stock Purchase |
|
||||
PCV-PLAN-CODE Element: Plan Code | Alpha 4 Contains the user-defined code that represents a benefit plan. |
|
||||
PCV-GROUP-NAME Element: Group Name | Alpha 10 Contains the group that uses the contribution record. This field may contain spaces. |
|
||||
PCV-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the start date for contribution. |
|
||||
PCV-COVERAGE-OPT Element: Coverage Opt | Numeric 2 Contains the coverage option with which the contributions are associated. |
|
||||
PCV-EMP-CONT Element: Emp Cont | Signed 7.2 If the contribution type is the same as the option amount, this is the employee contribution. |
|
||||
PCV-COMP-CONT Element: Comp Cont | Signed 11.2 If the contribution type is the same as the option amount, this field contains the company contribution. |
|
||||
PCV-FLEX-CONT Element: Flex Cont | Signed 7.2 If the contribution type is the same as the option amount, this field contains the flex credit contribution. |
|
||||
PCV-RATE-TABLE Element: Rate Table | Alpha 4 If the contribution type is the same as the options amount range, this field contains the rate table used for the contribution. |
|
||||
PCV-E-RET-CONT Element: E Ret Cont | Signed 7.2 This field is not used. |
|
||||
PCV-E-CO-CONT Element: E Co Cont | Signed 7.2 This field is not used. |
|
||||
PCV-R-RET-CONT Element: R Ret Cont | Signed 7.2 This field is not used. |
|
||||
PCV-R-CO-CONT Element: R Co Cont | Signed 7.2 This field is not used. |
|
||||
PCV-COBRA-CONT Element: Cobra Cont | Signed 7.2 This field is not used. |
|
||||
PCV-EARLY-RET-AGE Element: Early Ret Age | Numeric 2 This field is not used. |
|
||||
PCV-REG-RET-AGE Element: Reg Ret Age | Numeric 2 This field is not used. |
|
||||
PCV-TERM-AGE Element: Term Age | Numeric 2 This field is not used. |
|
||||
PCV-PREMIUM-CHG Element: Premium Chg | Numeric 1 This field is not used. 0 = Not Updated 1 = Updated |
|
||||
PCV-ACTIVE-FLAG Element: Active Flag | Alpha 1 Indicates if the option contribution is active or inactive. A = Active I = Inactive |
|
||||
PCV-COVER-TYPE Element: Cover Type | Alpha 1 For each record, indicates if the contribution type is for employees, retirees, COBRA participants. E = Employee C = COBRA Participant R = Retiree |
|
||||
PCV-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||
PCV-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||
PCV-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
||||
PCV-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||
PCV-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||
PCV-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
PCVSET1 |
COMPANY PLAN-TYPE PLAN-CODE COVER-TYPE START-DATE GROUP-NAME COVERAGE-OPT |
|
|||||||||
PCVSET2 |
COMPANY PLAN-TYPE PLAN-CODE COVERAGE-OPT COVER-TYPE START-DATE GROUP-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bncovopt | BNCOVOPT |
Required
| ||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||
Persgroup | PERSGROUP |
Not Required
| ||||||||||||
Plan | PLAN |
Required
| ||||||||||||
Prsystem | PRSYSTEM |
Required
| ||||||||||||
Ratetblhdr | RATETBLHDR |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Premium | PREMIUM |
Required
| ||||||||||||||||||
Ratetbldtl | RATETBLDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.