Definition of table emp-aca
No table description available , Table Dump Name emp-aca-

Alphabetical Field Summary

  • aca-category-code-id: (INTG) Category Code ID
  • active-for-aca: (LOGC) Is this person currently "active" for ACA purposes
  • benefit-end-date: (DATE) End date of benefits this month
  • benefit-start-date: (DATE) Start Date of benefits this month
  • benefits-accepted: (LOGC) Were benefits accepted by this employee this month
  • benefits-offered: (LOGC) Were benefits offered to this employee this month?
  • calendar-year: (INTG) Calendar year associated with this record
  • coverage-code-id: (INTG) Internally assigned identifier
  • 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-dob[10]: (DATE) Dependents date of birth
  • depend-name[10]: (CHAR) Name of dependent accepting coverage
  • depend-ssn[10]: (CHAR) Dependents SSN, if available
  • emp-seq: (INTG) Employee's Unique Sequence #
  • employment-status: (CHAR) Employee's employment designation
  • hours-this-month: (DECM) # of hours worked by the employee this month
  • ichraz-zip-code: (CHAR) ICHRAZ Zip Code, if required for this employee
  • lowest-cost-plan-id: (INTG) Benefit plan offerred that is the lowest cost, self-insured
  • lowest-ee-share: (DECM) Lowest-cost offerred for self-only coverage
  • month-num: (INTG) Month this aca record is associated with
  • primary-key: (INTG) Unique, Primary key for record
  • safe-harbor-code-id: (INTG) Internally assigned identifier
  • 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

  • year-coverage: calendar-year, coverage-code-id
  • year-emp-month: (UNIQUE, PRIMARY) calendar-year, emp-seq, month-num
  • year-harbor: calendar-year, safe-harbor-code-id
  • year-month-emp: calendar-year, month-num, emp-seq

    Alphabetical Trigger Summary

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

    Tables emp-aca references

  • aca-category-code - (no description available)
  • aca-coverage-code - ACA Coverage Codes
  • aca-safe-harbor-code - (no description available)
  • emp-dc - (no description available)
  • emp-demo - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-tdp - Employee DTL3 record
  • emp-w2 - Employee W2 Info
  • pay-profile - Payroll System Profile

    Detailed Alphabetical Field Listing
    aca-category-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Category Code ID

    active-for-aca Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this person currently "active" for ACA purposes

    benefit-end-date Data type: DATE
    Format: 99/99/99
    Help: End date of benefits this month

    benefit-start-date Data type: DATE
    Format: 99/99/99
    Help: Start Date of benefits this month

    benefits-accepted Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Were benefits accepted by this employee this month

    benefits-offered Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Were benefits offered to this employee this month?

    calendar-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Calendar year associated with this record
    Attributes: Index Component

    coverage-code-id Data type: INTEGER
    Format: zzzzzzzz9 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Coverage Code for this month
    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-dob Data type: DATE (Extent: 10)
    Format: 99/99/9999
    Help: Dependents date of birth

    depend-name Data type: CHARACTER (Extent: 10)
    Format: x(28)
    Help: Name of dependent accepting coverage

    depend-ssn Data type: CHARACTER (Extent: 10)
    Format: xxx-xx-xxxx
    Help: Dependents SSN, if available

    emp-seq Data type: INTEGER
    Format: zzzzzzzz9
    Description: Employee's Unique Sequence #
    Attributes: Index Component

    employment-status Data type: CHARACTER
    Format: x(2)
    Help: Employee's employment designation

    hours-this-month Data type: DECIMAL (Decimals: 2)
    Format: zz9 (Initial Value: 0)
    Help: # of hours worked by the employee this month

    ichraz-zip-code Data type: CHARACTER
    Format: x(9)
    Help: ICHRAZ Zip Code, if required for this employee

    lowest-cost-plan-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Benefit plan offerred that is the lowest cost, self-insured

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

    month-num Data type: INTEGER
    Format: z9
    Help: Month this aca record is associated with
    Attributes: Index Component

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

    safe-harbor-code-id Data type: INTEGER
    Format: zzzzzzzz9 (Initial Value: 0)
    Description: Internally assigned identifier
    Help: Safe Harbor Code associated with this month, if any
    Attributes: Index Component

    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