| BN100 | BN101 | BN102 | BN103 | BN105 | BN29.1 |
| BN29.2 | BN31.1 | BN31.2 | BN32.1 | BN32.2 | BN32.3 |
| BN529 | BN531 | BN729 | BS32.1 | BN229 | BN79.1 |
| BN990 | BN15.3 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PPO-COMPANY Element: Company Hr | Numeric 4 Contains the company. |
|
||||||||||||||
| PPO-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||||||||||||||
| PPO-PLAN-TYPE Element: Plan Type | Alpha 2 Contains the Benefit Plan Type. |
|
||||||||||||||
| PPO-PLAN-CODE Element: Plan Code | Alpha 4 Contains the Benefit plan code. |
|
||||||||||||||
| PPO-ENTRY-DATE Element: Start Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||
| PPO-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the Benefit Start Date after any waiting period. |
|
||||||||||||||
| PPO-STOP-DATE Element: Stop Date | Numeric 8 (yyyymmdd) Contains the Benefit stop date of the offer. |
|
||||||||||||||
| PPO-WAIVE-FLAG Element: Waive Flag | Alpha 1 If the benefit plan is a waive plan, value is (Y)es, otherwise (N)o. N = No Y = Yes |
|
||||||||||||||
| PPO-COVERAGE-OPT Element: Coverage Opt | Numeric 2 Contains the Coverage Option offered. |
|
||||||||||||||
| PPO-EMP-COST Element: Emp Pre Cont | Signed 11.2 Contains the lowest employee cost of the plan. |
|
||||||||||||||
| PPO-FAMILY-STATUS Element: Family Status | Alpha 10 Contains the life event of the benefit offer. |
|
||||||||||||||
| PPO-PRIORITY Element: Aca Priority | Numeric 5 Contains the ACA Priority from the Benefit Plan. |
|
||||||||||||||
| PPO-OFFER-CODE Element: Aca Code | Alpha 2 Contains the ACA Offer Code from the Benefit Plan. |
|
||||||||||||||
| PPO-SAFE-HARBOR Element: Aca Code | Alpha 2 Contains the ACA Safe Harbor code from the Benefit Plan. |
|
||||||||||||||
| PPO-SELF-INSURED Element: Alphadata1 | Alpha 1 Contains the ACA Self Insured flag from the Benefit plan. N = No Y = Yes |
|
||||||||||||||
| PPO-ENROLL-FLAG Element: Alphadata1 | Alpha 1 If employee is enrolled in the plan, the Enroll Flag is set to (Y)es, otherwise (N). N = No Y = Yes |
|
||||||||||||||
| PPO-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) Contains the System Date the record was updated. |
|
||||||||||||||
| PPO-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||
| PPO-USER-ID Element: User | Alpha 10 (Lower Case) Contains the User Id of the user who made the change. |
|
||||||||||||||
| PPO-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) Contains the system date of when the record was created. |
|
||||||||||||||
| PPO-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, second) when the record was created. |
|
||||||||||||||
| PPO-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) Contains the User Id of the User who created the record. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PPOSET1 |
COMPANY EMPLOYEE START-DATE PLAN-TYPE PLAN-CODE |
|
| ||||||||||||||||||||||||||
| PPOSET2 |
COMPANY EMPLOYEE START-DATE PLAN-TYPE PLAN-CODE |
|
|||||||||||||||||||||||||||
| PPOSET3 |
COMPANY EMPLOYEE START-DATE PRIORITY PLAN-TYPE PLAN-CODE |
|
|||||||||||||||||||||||||||
| PPOSET4 |
COMPANY EMPLOYEE START-DATE PLAN-TYPE PLAN-CODE |
|
| ||||||||||||||||||||||||||
| PPOSET5 |
COMPANY PLAN-TYPE PLAN-CODE EMPLOYEE START-DATE |
|
| ||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | BNCOMPANY |
Required
| |||||||||
| Employee | EMPLOYEE |
Required
| |||||||||
| Plan | PLAN |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.