Definition of table aca-benefit-plan
ACA Benefit Plan codes , Table Dump Name aca-bene

Alphabetical Field Summary

  • aca-benefit-plan-id: (INTG) Internally assigned ID
  • calendar-year: (INTG) Calendar year for this plan
  • cre-date: (DATE) Date this record was created
  • cre-time: (CHAR) Creation time of this record
  • cre-user-name: (CHAR) Name of user who created this record
  • depend-coverage-options: (CHAR) E (Employee Only), ES (and spouse), ED (and depend), EDS (sp
  • is-active: (LOGC) Plan active?
  • lowest-ee-self-only-cost: (DECM) Lowest cost for this plan, self-only coverage
  • plan-description: (CHAR) Description of this benefit plan
  • plan-end: (DATE) Ending date of this plan
  • plan-name: (CHAR) Short name of this benefit plan
  • plan-start: (DATE) Start Date of this benefit plan
  • primary-key: (INTG) Unique, Primary key for record
  • provider-fein: (CHAR) FEIN for this insurance provider
  • upd-date: (DATE) Date this record was last updated
  • upd-time: (CHAR) Time of last update to this record
  • upd-user-name: (CHAR) Name of user who last updated this record

    Alphabetical Index Summary

  • active-name: calendar-year, -is-active, plan-name
  • plan-desc: calendar-year, plan-description
  • plan-id: (UNIQUE, PRIMARY) calendar-year, aca-benefit-plan-id
  • plan-name: (UNIQUE) calendar-year, plan-name

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-acp.p
  • DELETE: Overridable, Procedure is tr-d-acp.p
  • REPLICATION-CREATE: Procedure is rp-c-acp.p
  • REPLICATION-DELETE: Procedure is rp-d-acp.p
  • REPLICATION-WRITE: Procedure is rp-u-acp.p
  • WRITE: Overridable, Procedure is tr-u-acp.p

    Tables aca-benefit-plan references

  • emp-w2 - Employee W2 Info
  • pay-profile - Payroll System Profile

    Detailed Alphabetical Field Listing
    aca-benefit-plan-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally assigned ID
    Help: Internally assigned identifier
    Attributes: Index Component

    calendar-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Help: Calendar year for this plan
    Attributes: Index Component

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Creation time of this record

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: Name of user who created this record
    Attributes: Mandatory

    depend-coverage-options Data type: CHARACTER
    Format: x(8)
    Description: E (Employee Only), ES (and spouse), ED (and depend), EDS (sp
    Help: E, ES, ED, or ESD

    is-active Data type: LOGICAL
    Format: Yes/No (Initial Value: yes)
    Description: Plan active?
    Help: Is this ACA Benefit Plan currently active?
    Attributes: Index Component

    lowest-ee-self-only-cost Data type: DECIMAL (Decimals: 2)
    Format: zzzz,zz9.99 (Initial Value: 0)
    Description: Lowest cost for this plan, self-only coverage
    Help: Lowest cost for this plan, self-only coverage

    plan-description Data type: CHARACTER
    Format: x(28)
    Description: Description of this benefit plan
    Help: Description of this benefit plan
    Attributes: Index Component

    plan-end Data type: DATE
    Format: 99/99/9999
    Help: Ending date of this plan

    plan-name Data type: CHARACTER
    Format: x(16)
    Description: Short name of this benefit plan
    Help: Short Name of this benefit plan
    Attributes: Index Component

    plan-start Data type: DATE
    Format: 99/99/9999
    Help: Start Date of this benefit plan

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for record

    provider-fein Data type: CHARACTER
    Format: 99-9999999
    Description: FEIN for this insurance provider
    Help: FEIN for this insurance provider

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date this record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time of last update to this record

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who last updated this record

    Created on 12/28/2020 by DBHTML V1.2