Definition of table district-1094c
No table description available , Table Dump Name district

Alphabetical Field Summary

  • annual-4980h: (CHAR) 4980H code for the whole year, if applicable
  • annual-emps: (INTG) Total # of all employees for the year, if applicable
  • annual-ft-emps: (INTG) # of FT employees for the whole year, if applicable
  • annual-mec: (LOGC) Annual MEC indicator. ? means monthly
  • attached-forms: (INTG) # of 1095 forms attached to this submission
  • calendar-year: (INTG) Calendar year this submission is for
  • correcting-utid: (CHAR) UTID of submission that we're correcting
  • corrects-1094: (LOGC) Does this submission correct a previously submitted 1094-C?
  • corrects-1095: (LOGC) Does this submission correct previously submitted 1095-Cs?
  • employer-name: (CHAR) Employer Name, as reported to the IRS with this submission
  • employer-tin: (CHAR) Employer TIN, as reported to the IRS with this submission
  • has-1a: (LOGC) Did the district use coverage code 1A (qualifying offer)
  • has-1i: (LOGC) Did the district use cover code 1I for this submission?
  • has-4980: (LOGC) Did the district use the section 4980H relief?
  • has-98-percent: (LOGC) Does this submission qualify for the 98% offer method?
  • is-authoritative: (LOGC) Is submission the authoritative submission for the district?
  • monthly-4980h[12]: (CHAR) Montly 4980H relief indicators
  • monthly-emps[12]: (INTG) Total # of employees, by month
  • monthly-ft-emps[12]: (INTG) # of FT employees, by month
  • monthly-mec[12]: (LOGC) Montly MEC indicators. ? means it was handled annually
  • obsoleted: (LOGC) Has this submission been corrected or replaced?
  • primary-key: (INTG) Unique, Primary key for record
  • receipt-id: (CHAR) Receipt ID for this submission, assigned by the IRS
  • replaces-submission: (LOGC) Does this submission replace a previous submission?
  • submission-id: (INTG) Unique submission identifier for this submission
  • submission-status: (CHAR) Submission status, as assigned by the IRS
  • submit-date: (DATE) Date this submission was generated
  • submit-time: (CHAR) Time this submission was generated
  • submit-user-name: (CHAR) Username of the person that generated this submission
  • total-forms: (INTG) Total # of 1095-Cs filed by the district
  • 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
  • utid: (CHAR) Unique Transmission ID for this submission

    Alphabetical Index Summary

  • by-receipt: calendar-year, receipt-id
  • by-user: calendar-year, submit-user-name, submit-date, submit-time
  • utid: (UNIQUE, PRIMARY) utid

    Alphabetical Trigger Summary

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

    Other tables who reference district-1094c

  • emp-1095c - Employee 1095c filing record

    Tables district-1094c references

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


    Detailed Alphabetical Field Listing
    annual-4980h Data type: CHARACTER
    Format: x(1)
    Help: 4980H code for the whole year, if applicable

    annual-emps Data type: INTEGER
    Format: zzz,zz9
    Help: Total # of all employees for the year, if applicable

    annual-ft-emps Data type: INTEGER
    Format: zzz,zz9
    Help: # of FT employees for the whole year, if applicable

    annual-mec Data type: LOGICAL
    Format: Yes/No
    Help: Annual MEC indicator. ? means monthly

    attached-forms Data type: INTEGER
    Format: zzz,zz9 (Initial Value: 0)
    Help: # of 1095 forms attached to this submission

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

    correcting-utid Data type: CHARACTER
    Format: x(51)
    Help: UTID of submission that we're correcting

    corrects-1094 Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Does this submission correct a previously submitted 1094-C?

    corrects-1095 Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Does this submission correct previously submitted 1095-Cs?

    employer-name Data type: CHARACTER
    Format: x(28)
    Help: Employer Name, as reported to the IRS with this submission

    employer-tin Data type: CHARACTER
    Format: x(11)
    Help: Employer TIN, as reported to the IRS with this submission

    has-1a Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Did the district use coverage code 1A (qualifying offer)

    has-1i Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Did the district use cover code 1I for this submission?

    has-4980 Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Did the district use the section 4980H relief?

    has-98-percent Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Does this submission qualify for the 98% offer method?

    is-authoritative Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Is submission the authoritative submission for the district?

    monthly-4980h Data type: CHARACTER (Extent: 12)
    Format: x(1)
    Help: Montly 4980H relief indicators

    monthly-emps Data type: INTEGER (Extent: 12)
    Format: zzz,zz9 (Initial Value: 0)
    Help: Total # of employees, by month

    monthly-ft-emps Data type: INTEGER (Extent: 12)
    Format: zzz,zz9 (Initial Value: 0)
    Help: # of FT employees, by month

    monthly-mec Data type: LOGICAL (Extent: 12)
    Format: Yes/No
    Help: Montly MEC indicators. ? means it was handled annually

    obsoleted Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Has this submission been corrected or replaced?

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

    receipt-id Data type: CHARACTER
    Format: x(20)
    Help: Receipt ID for this submission, assigned by the IRS
    Attributes: Index Component

    replaces-submission Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Does this submission replace a previous submission?

    submission-id Data type: INTEGER
    Format: zz9 (Initial Value: 1)
    Help: Unique submission identifier for this submission

    submission-status Data type: CHARACTER
    Format: x(20)
    Help: Submission status, as assigned by the IRS

    submit-date Data type: DATE
    Format: 99/99/9999
    Help: Date this submission was generated
    Attributes: Index Component

    submit-time Data type: CHARACTER
    Format: x(8)
    Help: Time this submission was generated
    Attributes: Index Component

    submit-user-name Data type: CHARACTER
    Format: x(8)
    Help: Username of the person that generated this submission
    Attributes: Index Component

    total-forms Data type: INTEGER
    Format: zzz,zz9 (Initial Value: 0)
    Help: Total # of 1095-Cs filed by the district

    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

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

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