EMPL_TAX
The Employee Tax (EMPL_TAX) table stores employee federal and state W-4 information.
| Costpoint Destination Table | Costpoint Destination Field | Costpoint Field Description | Required (Y/N) | Talent Management/Default Source |
|---|---|---|---|---|
| EMPL_TAX | AEIC_EXMPT_NO | AEIC exemption number | N | N/A |
| EMPL_TAX | AEIC_OVRIDE_AMT | AEIC override Amount | N | N/A |
| EMPL_TAX | AR_SEAS_EMPL | Arkansas seasonal employee code | N | N/A |
| EMPL_TAX | CLASS_CD | class code | N | N/A |
| EMPL_TAX | CORP_OFCR_ID | corporate officer ID | N | N/A |
| EMPL_TAX | COVG_TYPE | Coverage type | N | N/A |
| EMPL_TAX | DSLE_ESS_W4_FL | Disable ESS W-4 flag | N | N/A |
| EMPL_TAX | EE_ER_RELATION_CD | Employee/employer relationship | N | N/A |
| EMPL_TAX | EMPL_ID | Employee ID | Y (if auto ID generation is not enabled) | user_employee_id |
| EMPL_TAX | FED_ADDTL_AMT | Federal additional withholdingamount | N | ESS |
| EMPL_TAX | FED_EXMPT_NO | Number of federal withholding exemption claimed | N | ESS |
| EMPL_TAX | FED_OVRIDE_AMT | Federal withholding override amount | N | N/A |
| EMPL_TAX | FED_OVRIDE_PCT | Federal override percent | N | N/A |
| EMPL_TAX | FUTA_TXBL_FL | Federal unemployment tax flag (Y/N) | N | N/A |
| EMPL_TAX | FUTURE_TXBL_FL | Future use flag (Y/N) | N | N/A |
| EMPL_TAX | LC1_OVRIDE_PCT | Local 1 override percent | N | N/A |
| EMPL_TAX | LC2_OVRIDE_PCT | Local 2 override percent | N | N/A |
| EMPL_TAX | LC3_OVRIDE_PCT | Local 3 override percent | N | N/A |
| EMPL_TAX | LC4_OVRIDE_PCT | Local 4 override percent | N | N/A |
| EMPL_TAX | LC5_OVRIDE_PCT | Local 5 override percent | N | N/A |
| EMPL_TAX | LOC1_ADDTL_AMT | Locality 1 additional withholding amount | N | N/A |
| EMPL_TAX | LOC1_CREDIT_NO | Locality 1 number of credits claimed | N | N/A |
| EMPL_TAX | LOC1_DEPEND_NO | Locality 1 number of dependents claimed | N | N/A |
| EMPL_TAX | LOC1_EXMPT_NO | Locality 1 number of exemptions claimed | N | N/A |
| EMPL_TAX | LOC1_OVRIDE_AMT | Locality 1 withholding override claimed | N | N/A |
| EMPL_TAX | LOC2_ADDTL_AMT | Locality 2 additional withholding amount | N | N/A |
| EMPL_TAX | LOC2_CREDIT_NO | Locality 2 number of credits claimed | N | N/A |
| EMPL_TAX | LOC2_DEPEND_NO | Locality 2 number of dependents claimed | N | N/A |
| EMPL_TAX | LOC2_EXMPT_NO | Locality 2 number of exemptions claimed | N | N/A |
| EMPL_TAX | LOC2_OVRIDE_AMT | Locality 2 withholding override claimed | N | N/A |
| EMPL_TAX | LOC3_ADDTL_AMT | Locality 3 additional withholding amount | N | N/A |
| EMPL_TAX | LOC3_CREDIT_NO | Locality 3 number of credits claimed | N | N/A |
| EMPL_TAX | LOC3_DEPEND_NO | Locality 3 number of dependents claimed | N | N/A |
| EMPL_TAX | LOC3_EXMPT_NO | Locality 3 number of exemptions claimed | N | N/A |
| EMPL_TAX | LOC3_OVRIDE_AMT | Locality 3 withholding override claimed | N | N/A |
| EMPL_TAX | LOC4_ADDTL_AMT | Locality 4 additional withholding amount | N | N/A |
| EMPL_TAX | LOC4_CREDIT_NO | Locality 4 number of credits claimed | N | N/A |
| EMPL_TAX | LOC4_DEPEND_NO | Locality 4 number of dependents claimed | N | N/A |
| EMPL_TAX | LOC4_EXMPT_NO | Locality 4 number of exemptions claimed | N | N/A |
| EMPL_TAX | LOC4_OVRIDE_AMT | Locality 4 withholding override claimed | N | N/A |
| EMPL_TAX | LOC5_ADDTL_AMT | Locality 5 additional withholding amount | N | N/A |
| EMPL_TAX | LOC5_CREDIT_NO | Locality 5 number of credits claimed | N | N/A |
| EMPL_TAX | LOC5_DEPEND_NO | Locality 5 number of dependents claimed | N | N/A |
| EMPL_TAX | LOC5_EXMPT_NO | Locality 5 number of exemptions claimed | N | N/A |
| EMPL_TAX | LOC5_OVRIDE_AMT | Locality 5 withholding Override Claimed | N | N/A |
| EMPL_TAX | MAIL_STATE_DC | Tax state | Y ( if the employee's pay cycle is set up for multi-state tax) | user_state_abbreviation |
| EMPL_TAX | MEDICR_TXBL_FL | Medicare taxable flag (Y/N) | N | N/A |
| EMPL_TAX | MN_WORKSITE_NO | Minnesota worksite number | N | N/A |
| EMPL_TAX | MO_PROBATION_FL | MO probationary flag | N | N/A |
| EMPL_TAX | MODIFIED_BY | ID of the user who last created or modified row | N | N/A |
| EMPL_TAX | NE_MIN_WH_FL | Exempt from Nebraska minimum withholding | N | N/A |
| EMPL_TAX | NRA_FL | Nonresident alien flag | N | N/A |
| EMPL_TAX | OWNER_FL | Owner flag | N | N/A |
| EMPL_TAX | PA_PSD_CD | Pennsylvania resident PSD code | N | N/A |
| EMPL_TAX | PA_WORK_PSD_CD | Pennsylvania work location PSD code | N | N/A |
| EMPL_TAX | PAY_PD_CD | Pay cycle code | Y | CP Job Template; CP Company Default |
| EMPL_TAX | PENSION_PLAN_FL | Pension plan covered flag (Y/N) | N | N/A |
| EMPL_TAX | ROWVERSION | System-assigned number to handle row concurrency | N | N/A |
| EMPL_TAX | S_AEIC_FIL_STAT_CD | Filing Status AEIC Code | N | N/A |
| EMPL_TAX | S_AK_GEO_CD | Geographic code | N | N/A |
| EMPL_TAX | S_AK_OCC_CD | Alaska occupational code | N | N/A |
| EMPL_TAX | S_FED_FIL_STAT_CD | Federal filing status code | N | N/A |
| EMPL_TAX | S_FED_WH_MTHD_CD | Filing status federal tax withholding method code | N | N/A |
| EMPL_TAX | S_LOC1_FIL_STAT_CD | Filing status locality 1 code | N | N/A |
| EMPL_TAX | S_LOC2_FIL_STAT_CD | Filing status locality 2 code | N | N/A |
| EMPL_TAX | S_LOC3_FIL_STAT_CD | Filing status locality 3 code | N | N/A |
| EMPL_TAX | S_LOC4_FIL_STAT_CD | Filing status locality 4 code | N | N/A |
| EMPL_TAX | S_LOC5_FIL_STAT_CD | Filing status locality 5 code | N | N/A |
| EMPL_TAX | S_ST_FIL_STAT_CD | State filing status code | N | ESS |
| EMPL_TAX | SPCL_DED_FL | Puerto Rico special deduction fag | N | N/A |
| EMPL_TAX | SS_TXBL_FL | Social Security taxable flag (Y/N) | N | N/A |
| EMPL_TAX | ST_ADDTL_AMT | State additional withholding amount | N | ESS |
| EMPL_TAX | ST_CREDIT_NO | State number of credits claimed | N | ESS |
| EMPL_TAX | ST_DEPEND_NO | State number of dependents claimed | N | ESS |
| EMPL_TAX | ST_EXMPT_NO | State number of exemptions claimed | N | ESS |
| EMPL_TAX | ST_OVRIDE_AMT | State withholding override amount | N | N/A |
| EMPL_TAX | ST_OVRIDE_PCT | State override percent | N | N/A |
| EMPL_TAX | SUTA_STATE_CD | State unemployment tax state code | Y (if SUTA_TXBL_FL field value is Y) | N/A |
| EMPL_TAX | SUTA_TXBL_FL | Subject to SUTA | N | N/A |
| EMPL_TAX | TAX_SVC_GRP_ID | Payroll tax service group ID | N | N/A |
| EMPL_TAX | TIME_STAMP | Date and time of row creation or last modification | Y | N/A |
| EMPL_TAX | US_CITIZEN_STAT_CD | U.S. citizenship status code | Y (if the SUTA_STATE_CD field value is VI) | N/A |
| EMPL_TAX | VET_EXMPT_FL | Puerto Rico veteran exemption Flag | N | N/A |
| EMPL_TAX | WAGE_PLN_CD | Wage plan code | Y (if the SUTA_STATE_CD field value is CA) | N/A |
| EMPL_TAX | WH_LOC1_CD | Withholding locality 1 code | N | N/A |
| EMPL_TAX | WH_LOC2_CD | Withholding locality 2 code | N | N/A |
| EMPL_TAX | WH_LOC3_CD | Withholding locality 3 code | N | N/A |
| EMPL_TAX | WH_LOC4_CD | Withholding locality 4 code | N | N/A |
| EMPL_TAX | WH_LOC5_CD | Withholding locality 5 code | N | N/A |
| EMPL_TAX | WH_STATE_CD | Withholding state code | N | N/A |