Definition of table emp-1095c
Employee 1095c filing record , Table Dump Name emp-1095

Alphabetical Field Summary

  • calendar-year: (INTG) Calendar year for this payroll
  • cover-code[12]: (CHAR) Monthly reported coverage code
  • ee-only-cost[12]: (DECM) Monthly cost for self-only insurance
  • emp-seq: (INTG) Employee's Unique Sequence #
  • ichraz-zip-code[12]: (CHAR) ICHRAZ Zip Code, if required for this employee
  • plan-start-month: (INTG) Starting month of the benefit plan
  • primary-key: (INTG) Unique, Primary key for record
  • record-id: (INTG) Unique record ID for this employee in this submission
  • reported-age: (INTG) Reported age as of Jan 1
  • reported-name: (CHAR) Employee's name, as it was reported to the IRS
  • reported-name-control: (CHAR) (no description available)
  • reported-ssn: (CHAR) SSN as reported in E-File
  • safe-harbor[12]: (CHAR) Safe harbor codes, by month
  • utid: (CHAR) Unique Transmission ID for this submission
  • year-cost: (DECM) Cost per month, if the same all year
  • year-cover: (CHAR) Coverage code for thw whole year
  • year-harbor: (CHAR) Safe harbor code for the year, if applicable
  • year-ichraz-zip: (CHAR) Annual ICHRAZ ZIP Code

    Alphabetical Index Summary

  • by-emp: (UNIQUE) emp-seq, calendar-year, utid
  • utid: (UNIQUE, PRIMARY) utid, record-id

    Alphabetical Trigger Summary

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

    Other tables who reference emp-1095c

  • dc-record-type - (no description available)
  • emp-dc - (no description available)
  • emp-deduct - Employee Deductions file
  • _ActRecord - (no description available)

    Tables emp-1095c references

  • district-1094c - (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
    calendar-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Help: Calendar year for this payroll
    Attributes: Index Component

    cover-code Data type: CHARACTER (Extent: 12)
    Format: x(2)
    Help: Monthly reported coverage code

    ee-only-cost Data type: DECIMAL (Extent: 12, Decimals: 2)
    Format: zz,zz9.99
    Help: Monthly cost for self-only insurance

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

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

    plan-start-month Data type: INTEGER
    Format: z9
    Help: Starting month of the benefit plan

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

    record-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Unique record ID for this employee in this submission
    Attributes: Index Component

    reported-age Data type: INTEGER
    Format: zz9
    Help: Reported age as of Jan 1

    reported-name Data type: CHARACTER
    Format: x(28)
    Help: Employee's name, as it was reported to the IRS

    reported-name-control Data type: CHARACTER
    Format: x(4)

    reported-ssn Data type: CHARACTER
    Format: x(11)
    Help: SSN as reported in E-File

    safe-harbor Data type: CHARACTER (Extent: 12)
    Format: x(2)
    Help: Safe harbor codes, by month

    utid Data type: CHARACTER
    Format: x(51)
    Help: Unique Transmission ID for this submission
    Attributes: Index Component

    year-cost Data type: DECIMAL (Decimals: 2)
    Format: zz,zz9.99
    Help: Cost per month, if the same all year

    year-cover Data type: CHARACTER
    Format: x(2)
    Help: Coverage code for thw whole year

    year-harbor Data type: CHARACTER
    Format: x(2)
    Help: Safe harbor code for the year, if applicable

    year-ichraz-zip Data type: CHARACTER
    Format: x(9)
    Help: Annual ICHRAZ ZIP Code

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