FEDERALW42020¶
This source table stores information about Federal W-4s.
Columns¶
| Column | Data type | Description |
|---|---|---|
BUILDID |
VARCHAR | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
CDCSTATUS |
VARCHAR | For Avionté internal use only. |
DATECOMPLETED |
TIMESTAMP_NTZ | The date the W-4 was completed. |
DEDUCTIONS |
NUMBER | The deductions from the W-4. |
EMPLOYEEGUID |
VARCHAR | The employee unique identifier for the W-4, formatted as a GUID. |
EXTRAWITHHOLDING |
NUMBER | The amount of extra withholdings noted on the W-4. |
FEDERALW42020ID |
NUMBER | The identifier for this record. |
HASLOCKINLETTER |
NUMBER | Lock in letter flag. |
HASMULTIPLEJOBS |
NUMBER | Flag indicating if the employee has multiple jobs. |
ISTAXEXEMPT |
NUMBER | Flag indicating if the W-4 is marked as Tax Exempt. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |
OTHERDEPENDENTS |
NUMBER | The number of other dependents. |
OTHERINCOME |
NUMBER | Other income amount noted on the W-4. |
QUALIFYINGCHILDREN |
NUMBER | The number of qualifying children noted on the W-4. |
TAXFILINGSTATUSID |
NUMBER | The identifier for the Tax Filing Status. |
TOTALDEPENDENTS |
NUMBER | The total number of dependents. |