Benefit Plan Premium
The Benefit Plan Premium file contains contributions for a benefit plan. It includes premiums for employees, retirees, and COBRA participants.
REFERENCED BY
BN104 | BN17.1 | BN180 | BN220 | BN230 | BN242 |
ZB599 | HR55.1 | PRBN.1 | BN215 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PRE-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|
||||||||||||||||||
PRE-PLAN-TYPE Element: Plan Type | Alpha 2 Contains the type of benefit plan. 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 |
|
||||||||||||||||||
PRE-PLAN-CODE Element: Plan Code | Alpha 4 Contains a user-defined field used to represent a specific plan. |
|
||||||||||||||||||
PRE-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the start date for the premium record. |
|||||||||||||||||||
PRE-GROUP-NAME Element: Group Name | Alpha 10 Contains the group that uses the contribution record. This field may contain spaces. |
|
||||||||||||||||||
PRE-CONTRIB-TYPE Element: Contrib Type | Alpha 2 Contains the contribution type. It must match the plan contribution type. 1 = Option Amounts 2 = Option Rate Table 3 = Amount 4 = Coverage or Salary Rate Table 5 = Contribution Limits 6 = Service Schedule 7 = Percent Schedule X = Custom Calculation |
|
||||||||||||||||||
PRE-CALC-TYPE Element: Calc Type | Alpha 1 Determines how the contribution is calculated. 1 = Flat Amount 2 = Flat Percent 3 = Percent of Salary 4 = Rate Table X = Custom Calculation |
|
||||||||||||||||||
PRE-SALARY-TYPE Element: Salary Type | Alpha 2 If contributions are based on salary, this field determines the salary to be used. EM = HR11 Salary B1 = Benefit Salary 1 B2 = Benefit Salary 2 B3 = Benefit Salary 3 B4 = Benefit Salary 4 B5 = Benefit Salary 5 E1 = HR11 and Ben Sal 1 E2 = HR11 and Ben Sal 2 E3 = HR11 and Ben Sal 3 E4 = HR11 and Ben Sal 4 E5 = HR11 and Ben Sal 5 ET = Total Emp Salary T1 = Total Emp and Sal 1 T2 = Total Emp and Sal 2 T3 = Total Emp and Sal 3 T4 = Total Emp and Sal 4 T5 = Total Emp and Sal 5 X = Custom Calculation FL = Flex Salary |
|
||||||||||||||||||
PRE-SALARY-DATE Element: Salary Date | Numeric 4 (mmdd) If contributions are based on salary and if the salary first month is an "as of" date, this field contains the month and day the salary should be determined. This field may be used with the salary year. |
|
||||||||||||||||||
PRE-SAL-FIRST-MO Element: Sal First Mo | Alpha 1 If contributions are based on salary, this field determines the salary calculation date. C = Current M = First of Month A = As of Date F = Flex Calc Date |
|
||||||||||||||||||
PRE-ROUND-METH Element: Round Meth | Alpha 1 If contributions are based on salary, this field contains the rounding method used to calculate the annual salary. H = High L = Low N = No Rounding R = Normal |
|
||||||||||||||||||
PRE-BEF-AFT-FLAG Element: Bef Aft Flag | Alpha 1 If the contribution is based on salary, this field indicates if rounding is done before or after multiplying salary. A = After B = Before |
|
||||||||||||||||||
PRE-ROUND-TO Element: Round To | Signed 9.4 If contributions are based on salary, this field determines the place to which the salary is rounded; for example 1, .1, .01, and so on. |
|
||||||||||||||||||
PRE-AMT-MINIMUM Element: Amt Minimum | Signed 11.2 Indicates if the salary minimum amount is used. |
|
||||||||||||||||||
PRE-AMT-MAXIMUM Element: Amt Maximum | Signed 11.2 Indicates if the salary maximum amount is used. |
|
||||||||||||||||||
PRE-TABLE-TYPE Element: Table Type | Alpha 2 If the premium is tied to a rate table, this field indicates the type of table used. 1 = Age 2 = Salary 3 = Years of Service X = Custom Calculation |
|
||||||||||||||||||
PRE-EMP-SPS-AGE Element: Emp Sps Age | Alpha 1 If the contribution is based on age, this field indicates whether the contribution is base on the employee age or spouse age. E = Employee S = Spouse or Domestic Partner |
|
||||||||||||||||||
PRE-AGE-DATE Element: Age Date | Numeric 4 (mmdd) If the contribution is based on age, this field contains the date for the "as of" date. |
|
||||||||||||||||||
PRE-AGE-FIRST-MO Element: Age First Mo | Alpha 1 If the contribution is based on age, this field contains indicates the date used to calculate the age. C = Current M = First of Month A = As of Date F = Flex Calc Date |
|
||||||||||||||||||
PRE-FROM-DATE Element: From Date | Alpha 2 If the contribution is based on service, this field is used to calculate the years of service. HI = Hire Date AJ = Adjusted Hire Date AN = Anniversary Date SN = Seniority Date B1 = Benefit Date 1 B2 = Benefit Date 2 B3 = Benefit Date 3 B4 = Benefit Date 4 B5 = Benefit Date 5 X = Custom Calculation |
|
||||||||||||||||||
PRE-SERV-DATE Element: Serv Date | Numeric 4 (mmdd) If the contribution is based on service, this field contains the date through which the service is calculated. |
|
||||||||||||||||||
PRE-SERV-FIRST-MO Element: Serv First Mo | Alpha 1 If contributions are based on service, this field contains the date through which the years of service is calculated. C = Current M = First of Month A = As of Date F = Flex Calc Date |
|
||||||||||||||||||
PRE-EMP-CONT Element: Emp Cont4 | Signed 9.4 If the contribution type is a flat contribution, this field contains the employee contribution amount. |
|
||||||||||||||||||
PRE-COMP-CONT Element: Comp Cont4 | Signed 13.4 If the contribution type is a flat contribution, this field contains the company contribution. |
|
||||||||||||||||||
PRE-FLEX-CONT Element: Flex Cont4 | Signed 9.4 If the contribution type is a flat contribution, this field contains the flex credit contribution. |
|
||||||||||||||||||
PRE-RATE-TABLE Element: Rate Table | Alpha 4 Indicates the rate table used to calculate contributions for the plan. This field is used only for flat contributions and for salary or coverage rate table contributions. |
|
||||||||||||||||||
PRE-CONTRIB-BASIS Element: Contrib Basis | Alpha 1 If the contribution type is salary or coverage rate table, this field indicates if the contribution is based on the salary or coverage amount on the benefit. C = Coverage S = Salary |
|
||||||||||||||||||
PRE-COST-PER-CVG Element: Cost Per Cvg | Signed 9.2 If the premium is calculated by a rate per dollars of coverage, this is the amount on which the rate is based. |
|
||||||||||||||||||
PRE-ANN-AMT-MIN Element: Ann Amt Min | Signed 11.2 If the contribution type is a contribution limit, this field contains the minimum annual amount. |
|
||||||||||||||||||
PRE-ANN-AMT-MAX Element: Ann Amt Max | Signed 11.2 If the contribution type is contribution limit, this field contains the maximum annual amount. |
|
||||||||||||||||||
PRE-PCT-MINIMUM Element: Pct Minimum4 | Signed 7.4 If the contribution type is contribution limit, this field contains the minimum annual percent. |
|
||||||||||||||||||
PRE-PCT-MAXIMUM Element: Pct Maximum4 | Signed 7.4 If the contribution type is contribution limit, this field contains the maximum annual percent. |
|
||||||||||||||||||
PRE-COMP-AMT Element: Comp Amt | Signed 7.2 If the contribution type is contribution limit, this field contains the company amount contribution. |
|
||||||||||||||||||
PRE-COMP-PCT Element: Comp Pct4 | Signed 7.4 If the contribution type is contribution limit, this field contains the company percent contribution. |
|
||||||||||||||||||
PRE-VAC-MAX-HOURS Element: Vac Max Hours | Signed 6.3 If the plan type is vacation and the contribution type is contribution limit, this field contains the maximum vacation hours that can be bought or sold. |
|
||||||||||||||||||
PRE-VAC-COST Element: Vac Cost | Signed 5.2 If the plan type is vacation and the contribution type is contribution limit, this field contains the cost of each hour purchased or sold. |
|
||||||||||||||||||
PRE-INCREMENT Element: Increment | Signed 5.2 If the contribution type is match limit schedule or match percent schedule, this field contains the increments an employee must elect. |
|
||||||||||||||||||
PRE-EMP-CONT-TYPE Element: Emp Cont Type | Alpha 1 If the contribution type is match limit schedule or match percent schedule, this field indicates the type of employee contribution. A = Amount P = Percent B = Both N = No Contribution |
|
||||||||||||||||||
PRE-CONT-TAX-STS Element: Cont Tax Sts | Alpha 1 Indicates how an employee can contribute. P = Pre-Tax A = After-Tax B = Both N = No Contribution |
|
||||||||||||||||||
PRE-MATCH-OPTION Element: Match Option | Alpha 1 If the contribution type is match limit schedule or match percent schedule, this field indicates which contributions are matched. P = Pre-Tax A = After-Tax B = Both |
|
||||||||||||||||||
PRE-MATCH-CALC Element: Match Calc | Alpha 1 If the contribution type is match percent schedule, this field indicates how the match is determined. C = Cumulative F = Fixed |
|
||||||||||||||||||
PRE-END-PCT Element: End Pct | Numeric 3 If the contribution type is match percent schedule, this field indicates the maximum contribution percent. |
|
||||||||||||||||||
PRE-E-COMP-CONT1 Element: E Comp Cont1 | Signed 7.2 This field is not used. |
|
||||||||||||||||||
PRE-R-COMP-CONT1 Element: R Comp Cont1 | Signed 7.2 This field is not used. |
|
||||||||||||||||||
PRE-RET-RATE-TBL Element: Ret Rate Tbl | Alpha 2 This field is not used. |
|
||||||||||||||||||
PRE-STATUS Element: Status | Numeric 1 This field is not used. 0 = New Group New Date 1 = Existing Group New Date 2 = Change Existing Record 3 = Updated |
|
||||||||||||||||||
PRE-RET-STATUS Element: Ret Status | Numeric 1 This field is not used. 0 = New Group New Date 1 = Existing Group New Date 2 = Change Existing Record 3 = Updated |
|
||||||||||||||||||
PRE-EARLY-RT-AGE Element: Early Rt Age | Numeric 2 This field is not used. |
|
||||||||||||||||||
PRE-REG-RT-AGE Element: Reg Rt Age | Numeric 2 This field is not used. |
|
||||||||||||||||||
PRE-FLEX-CONT1 Element: Flex Cont1 | Signed 7.2 This field is not used. |
|
||||||||||||||||||
PRE-DEFAUL-TAX-TYP Element: Defaul Tax Typ | Alpha 1 Contains the default contribution tax type for the employee contribution. P = Pre-Tax A = After-Tax |
|
||||||||||||||||||
PRE-SALARY-YEAR Element: Salary Year | Numeric 4 If contributions are based on salary and an "as of" date is used, this field contains the year. |
|
||||||||||||||||||
PRE-AGE-YEAR Element: Age Year | Numeric 4 If contributions are based on age and an "as of" date, this field contains the year. |
|
||||||||||||||||||
PRE-SERV-YEAR Element: Serv Year | Numeric 4 If contributions are based on a service and an "as of" date, this field contains the year. |
|
||||||||||||||||||
PRE-PAY-PER-MIN Element: Pay Per Min | Signed 6.2 If the contribution type is contribution limit, this field contains the pay period minimum contribution amount. |
|
||||||||||||||||||
PRE-PAY-PER-MAX Element: Pay Per Max | Signed 6.2 If the contribution type is contribution limit, this field contains the maximum pay period amount. |
|
||||||||||||||||||
PRE-COVER-TYPE Element: Cover Type | Alpha 1 Indicates if the coverage is for employees, retirees, or COBRA participants for each premium record. E = Employees R = Retirees C = COBRA |
|
||||||||||||||||||
PRE-COBRA-STATUS Element: Cobra Status | Numeric 1 If the coverage type is COBRA, this field indicates the status. If the status is New Group New Record, Existing Group New Date, or Change Existing Record, the premium record must be updated before an invoice can be generated. 0 = New Group New Record 1 = Existing Group New Date 2 = Change Existing Record 3 = Updated |
|
||||||||||||||||||
PRE-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||
PRE-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||||||||||||||
PRE-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
||||||||||||||||||
PRE-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||
PRE-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||||||||||||||
PRE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PRESET1 |
COMPANY PLAN-TYPE PLAN-CODE COVER-TYPE START-DATE GROUP-NAME |
|
|||||||||||||||||||||||||||||||||||||
PRESET3 |
COMPANY PLAN-TYPE PLAN-CODE COVER-TYPE START-DATE* GROUP-NAME |
|
| ||||||||||||||||||||||||||||||||||||
PRESET5 |
COMPANY CONTRIB-TYPE PLAN-TYPE PLAN-CODE COVER-TYPE START-DATE GROUP-NAME |
|
| ||||||||||||||||||||||||||||||||||||
PRESET6 |
COMPANY COVER-TYPE RATE-TABLE START-DATE PLAN-TYPE PLAN-CODE GROUP-NAME |
|
| ||||||||||||||||||||||||||||||||||||
PRESET7 |
COMPANY PLAN-TYPE PLAN-CODE COVER-TYPE GROUP-NAME START-DATE* |
|
| ||||||||||||||||||||||||||||||||||||
PRESET8 |
COMPANY CONTRIB-TYPE PLAN-TYPE PLAN-CODE COVER-TYPE START-DATE* GROUP-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Age Rate Table | RATETBLHDR |
Not Required
| |||||||||||||||
Company | BNCOMPANY |
Required
| |||||||||||||||
Company Name | PRSYSTEM |
Required
| |||||||||||||||
Contrib 0 | PLAN |
Required
| |||||||||||||||
Contrib 1 | PLAN |
Required
| |||||||||||||||
Contrib 2 | PLAN |
Required
| |||||||||||||||
Contrib 3 | PLAN |
Required
| |||||||||||||||
Contrib 4 | PLAN |
Required
| |||||||||||||||
Contrib 5 | PLAN |
Required
| |||||||||||||||
Contrib 6 | PLAN |
Required
| |||||||||||||||
Contrib 7 | PLAN |
Required
| |||||||||||||||
Contrib User | PLAN |
Required
| |||||||||||||||
Persgroup | PERSGROUP |
Not Required
| |||||||||||||||
Plan | PLAN |
Required
| |||||||||||||||
Prsystem | PRSYSTEM |
Required
| |||||||||||||||
Rate Table | RATETBLHDR |
Not Required
| |||||||||||||||
Sal Rate Table | RATETBLHDR |
Not Required
| |||||||||||||||
Serv Rate Tbl | RATETBLHDR |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bnprmopt | BNPRMOPT |
Delete Cascades
| |||||||||||||||||||||
Contrdetl | CONTRDETL |
| |||||||||||||||||||||
Contrib Sch | CONTRDETL |
| |||||||||||||||||||||
Rate Tbl Dtl | RATETBLDTL |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.